diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2004-01-12 16:25:13 +0200 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2004-01-12 16:25:13 +0200 |
| commit | e2ab8558e899716d653d994af1a1e86c54e90bf9 (patch) | |
| tree | 0d02b7fe1ac9bcaaf00352fab9c6e1f169f32d4d /mysql-test/r | |
| parent | 7622c393a9fc2c70b47cf5b874eb0d275c0db395 (diff) | |
| download | mariadb-git-e2ab8558e899716d653d994af1a1e86c54e90bf9.tar.gz | |
opt_sum.cc:
A fix for a bug #3189, pertaining to crashing MySQL server when a query with MIN / MAX on the BLOB column is to be optimised
sql/opt_sum.cc:
A fix for a bug #3189, pertaining to crashing MySQL server when a query with MIN / MAX on the BLOB column is to be optimised
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/type_blob.result | 6 |
1 files changed, 6 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; |