diff options
| author | unknown <igor@rurik.mysql.com> | 2006-06-02 14:16:22 -0700 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2006-06-02 14:16:22 -0700 |
| commit | ccad0572f5c7a20d909785732995984de9d76552 (patch) | |
| tree | e54db3799946891ffee27e78bb432b724acc362a /mysql-test/r | |
| parent | 3390eaa08582d9c0d0e12db7259ae00ede9741e7 (diff) | |
| parent | e3e0658779bffacd5323efb54ecb7f42ded19231 (diff) | |
| download | mariadb-git-ccad0572f5c7a20d909785732995984de9d76552.tar.gz | |
Merge ibabaev@bk-internal.mysql.com:/home/bk/mysql-4.1-opt
into rurik.mysql.com:/home/igor/mysql-4.1-opt
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/func_group.result | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/r/func_group.result b/mysql-test/r/func_group.result index 67966b999d4..ffa68f279f3 100644 --- a/mysql-test/r/func_group.result +++ b/mysql-test/r/func_group.result @@ -916,3 +916,27 @@ select count(*), min(7), max(7) from t2m, t1i; count(*) min(7) max(7) 0 NULL NULL drop table t1m, t1i, t2m, t2i; +CREATE TABLE t1 (id int PRIMARY KEY, b char(3), INDEX(b)); +INSERT INTO t1 VALUES (1,'xx'), (2,'aa'); +SELECT * FROM t1; +id b +1 xx +2 aa +SELECT MAX(b) FROM t1 WHERE b < 'ppppp'; +MAX(b) +aa +SHOW WARNINGS; +Level Code Message +SELECT MAX(b) FROM t1 WHERE b < 'pp'; +MAX(b) +aa +DROP TABLE t1; +CREATE TABLE t1 (id int PRIMARY KEY, b char(16), INDEX(b(4))); +INSERT INTO t1 VALUES (1, 'xxxxbbbb'), (2, 'xxxxaaaa'); +SELECT MAX(b) FROM t1; +MAX(b) +xxxxbbbb +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; |