diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2003-03-05 15:45:11 +0200 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2003-03-05 15:45:11 +0200 |
| commit | 5861dc5b8b39b3f822a8968963a4783541d59b77 (patch) | |
| tree | 00dc4e6cf99060c6edd1f3c1447875a1b72ca154 /mysql-test | |
| parent | a300406b4f599d1ab676d6fb1cbca93be466926e (diff) | |
| parent | 4016096bac76b0dd6e1980900b2ddc62d1fe6287 (diff) | |
| download | mariadb-git-5861dc5b8b39b3f822a8968963a4783541d59b77.tar.gz | |
Merge sinisa@work.mysql.com:/home/bk/mysql
into sinisa.nasamreza.org:/mnt/work/mysql
sql/mysql_priv.h:
Auto merged
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/delete.result | 4 | ||||
| -rw-r--r-- | mysql-test/t/delete.test | 20 |
2 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/r/delete.result b/mysql-test/r/delete.result new file mode 100644 index 00000000000..169232b72d8 --- /dev/null +++ b/mysql-test/r/delete.result @@ -0,0 +1,4 @@ +bool not_null misc +NULL c 6 +NULL d 7 +bool not_null misc diff --git a/mysql-test/t/delete.test b/mysql-test/t/delete.test index 953e22cdd55..13fa617b3cf 100644 --- a/mysql-test/t/delete.test +++ b/mysql-test/t/delete.test @@ -35,3 +35,23 @@ create table t1 (a bigint not null, primary key (a,a,a,a,a,a,a,a,a,a)); insert into t1 values (2),(4),(6),(8),(10),(12),(14),(16),(18),(20),(22),(24),(26),(23),(27); delete from t1 where a=27; drop table t1; + +# +# CHAR(0) bug - not actually DELETE bug, but anyway... +# + +CREATE TABLE t1 ( + bool char(0) default NULL, + not_null varchar(20) binary NOT NULL default '', + misc integer not null, + PRIMARY KEY (not_null) +) TYPE=MyISAM; + +INSERT INTO t1 VALUES (NULL,'a',4), (NULL,'b',5), (NULL,'c',6), (NULL,'d',7); + +select * from t1 where misc > 5 and bool is null; +delete from t1 where misc > 5 and bool is null; +select * from t1 where misc > 5 and bool is null; + +drop table t1; + |