| create table very_simple_table_for_in_test (name STRING, othername STRING); |
| insert into very_simple_table_for_in_test values ('a', null); |
| insert into very_simple_table_for_in_test values (null, null); |
| |
| explain cbo |
| select * from very_simple_table_for_in_test where name IN('g','r') AND name IN('a','b') ; |
| |
| select * from very_simple_table_for_in_test where name IN('g','r') AND name IN('a','b') ; |
| |
| explain cbo |
| select name IN('g','r') AND name IN('a','b') from very_simple_table_for_in_test ; |
| |
| select name IN('g','r') AND name IN('a','b') from very_simple_table_for_in_test ; |
| |
| explain cbo |
| select name IN('g','r') AND name IN('a','b') AND othername IN('x', 'y') from very_simple_table_for_in_test ; |
| |
| select name IN('g','r') AND name IN('a','b') AND othername IN('x', 'y') from very_simple_table_for_in_test ; |