diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2004-01-12 16:28:12 +0200 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2004-01-12 16:28:12 +0200 |
| commit | 7e50f03271171e65d479798abdae97b7f2f1a2d0 (patch) | |
| tree | 976b296e81b5cb1a30426e0159606a7a431a3982 /mysql-test | |
| parent | 9d8bf6980ab67940e91425d5bcb6968e630ac8a2 (diff) | |
| parent | e2ab8558e899716d653d994af1a1e86c54e90bf9 (diff) | |
| download | mariadb-git-7e50f03271171e65d479798abdae97b7f2f1a2d0.tar.gz | |
Merge sinisa@bk-internal.mysql.com:/home/bk/mysql-4.0
into sinisa.nasamreza.org:/mnt/work/mysql-4.0
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/type_blob.result | 6 | ||||
| -rw-r--r-- | mysql-test/t/type_blob.test | 6 |
2 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/type_blob.result b/mysql-test/r/type_blob.result index 0bb9146fafc..685301f3639 100644 --- a/mysql-test/r/type_blob.result +++ b/mysql-test/r/type_blob.result @@ -601,3 +601,9 @@ id txt 2 Chevy 4 Ford drop table t1; +CREATE TABLE t1 ( i int(11) NOT NULL default '0', c text NOT NULL, PRIMARY KEY (i), KEY (c(1),c(1))); +INSERT t1 VALUES (1,''),(2,''),(3,'asdfh'),(4,''); +select max(i) from t1 where c = ''; +max(i) +4 +drop table t1; diff --git a/mysql-test/t/type_blob.test b/mysql-test/t/type_blob.test index cf5c0d6e581..928f79a661e 100644 --- a/mysql-test/t/type_blob.test +++ b/mysql-test/t/type_blob.test @@ -312,3 +312,9 @@ select * from t1 where txt <= 'Chevy'; select * from t1 where txt > 'Chevy'; select * from t1 where txt >= 'Chevy'; drop table t1; +CREATE TABLE t1 ( i int(11) NOT NULL default '0', c text NOT NULL, PRIMARY KEY (i), KEY (c(1),c(1))); +INSERT t1 VALUES (1,''),(2,''),(3,'asdfh'),(4,''); +select max(i) from t1 where c = ''; +drop table t1; + + |