diff options
| author | unknown <sergefp@mysql.com> | 2006-05-15 14:18:23 +0400 |
|---|---|---|
| committer | unknown <sergefp@mysql.com> | 2006-05-15 14:18:23 +0400 |
| commit | e5838e160b989623c57f69a3fdb259b93467dcf6 (patch) | |
| tree | 464b36ebd8d6ba1244b6fce0b8b14bd635b215de /mysql-test/r/func_in.result | |
| parent | fe3ac3007a3766be7e826724b6bc3cf59b9930d0 (diff) | |
| download | mariadb-git-e5838e160b989623c57f69a3fdb259b93467dcf6.tar.gz | |
BUG#19618: Crash for unsigned_col NOT IN (-1, ... )
- When manually constructing a SEL_TREE for "t.key NOT IN(...)", take into account that
get_mm_parts may return a tree with type SEL_TREE::IMPOSSIBLE
- Added missing OOM checks
- Added comments
mysql-test/r/func_in.result:
Testcase for BUG#19618
mysql-test/t/func_in.test:
Testcase for BUG#19618
Diffstat (limited to 'mysql-test/r/func_in.result')
| -rw-r--r-- | mysql-test/r/func_in.result | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/func_in.result b/mysql-test/r/func_in.result index e3257ce5fd0..e38e2624e19 100644 --- a/mysql-test/r/func_in.result +++ b/mysql-test/r/func_in.result @@ -326,3 +326,20 @@ deallocate prepare s; set @str=NULL; drop table t2; drop table t1; +create table t1 ( +some_id smallint(5) unsigned, +key (some_id) +); +insert into t1 values (1),(2); +select some_id from t1 where some_id not in(2,-1); +some_id +1 +select some_id from t1 where some_id not in(-4,-1,-4); +some_id +1 +2 +select some_id from t1 where some_id not in(-4,-1,3423534,2342342); +some_id +1 +2 +drop table t1; |