diff options
| author | unknown <igor@rurik.mysql.com> | 2006-06-13 22:38:00 -0700 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2006-06-13 22:38:00 -0700 |
| commit | 5eead315e038d705b69eb1ca354398b38b533441 (patch) | |
| tree | 37db9296a9908b1d8884b46891ddfc5fea692eac /mysql-test/r/func_group.result | |
| parent | 61684e2e7578d98754648899b9595089dc78f3af (diff) | |
| download | mariadb-git-5eead315e038d705b69eb1ca354398b38b533441.tar.gz | |
Post-review corrections of the fix for bug #18206.
mysql-test/r/func_group.result:
Added another test case for bug #18206.
mysql-test/t/func_group.test:
Added another test case for bug #18206.
Diffstat (limited to 'mysql-test/r/func_group.result')
| -rw-r--r-- | mysql-test/r/func_group.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/func_group.result b/mysql-test/r/func_group.result index ffa68f279f3..f16fb01d0df 100644 --- a/mysql-test/r/func_group.result +++ b/mysql-test/r/func_group.result @@ -940,3 +940,16 @@ EXPLAIN SELECT MAX(b) FROM t1; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL NULL NULL NULL NULL 2 DROP TABLE t1; +CREATE TABLE t1 (id int , b varchar(512), INDEX(b(250))) COLLATE latin1_bin; +Warnings: +Warning 1246 Converting column 'b' from CHAR to TEXT +INSERT INTO t1 VALUES +(1,CONCAT(REPEAT('_', 250), "qq")), (1,CONCAT(REPEAT('_', 250), "zz")), +(1,CONCAT(REPEAT('_', 250), "aa")), (1,CONCAT(REPEAT('_', 250), "ff")); +SELECT MAX(b) FROM t1; +MAX(b) +__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________zz +EXPLAIN SELECT MAX(b) FROM t1; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 ALL NULL NULL NULL NULL 4 +DROP TABLE t1; |