diff options
| author | unknown <serg@serg.mylan> | 2004-08-22 12:47:11 +0200 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2004-08-22 12:47:11 +0200 |
| commit | 6f6f7ba94d8c20183dfa4f5253a5801514e77fad (patch) | |
| tree | 3be7f12525aecd585a733ac126df79776972544f /mysql-test/t/null.test | |
| parent | fe450cd719ef074cbc3895e183fbabd5669325e6 (diff) | |
| parent | cb6dc5738cc41445725bbcb19ed33d45d1f5a48a (diff) | |
| download | mariadb-git-6f6f7ba94d8c20183dfa4f5253a5801514e77fad.tar.gz | |
merged
sql/item_cmpfunc.h:
Auto merged
mysql-test/r/join_outer.result:
merged with 'ul'
mysql-test/r/null.result:
merged with 'ul'
Diffstat (limited to 'mysql-test/t/null.test')
| -rw-r--r-- | mysql-test/t/null.test | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/t/null.test b/mysql-test/t/null.test index 9f3b6646e7f..7d30fd06ba7 100644 --- a/mysql-test/t/null.test +++ b/mysql-test/t/null.test @@ -98,3 +98,24 @@ explain select * from t1 where a between 2 and 3; explain select * from t1 where a between 2 and 3 or b is null; drop table t1; select cast(NULL as signed); + +# +# Test case for bug #4256 +# + +create table t1(i int, key(i)); +insert into t1 values(1); +insert into t1 select i*2 from t1; +insert into t1 select i*2 from t1; +insert into t1 select i*2 from t1; +insert into t1 select i*2 from t1; +insert into t1 select i*2 from t1; +insert into t1 select i*2 from t1; +insert into t1 select i*2 from t1; +insert into t1 select i*2 from t1; +insert into t1 select i*2 from t1; +explain select * from t1 where i=2 or i is null; +alter table t1 change i i int not null; +explain select * from t1 where i=2 or i is null; +drop table t1; + |