(t *testing.T)
| 127 | } |
| 128 | |
| 129 | func TestSelectWithWhereContains(t *testing.T) { |
| 130 | |
| 131 | engineTestSuite := engineTableContentTestSuite{ |
| 132 | createInputs: []string{ |
| 133 | "CREATE TABLE tb1( one TEXT, two INT, three INT, four TEXT );", |
| 134 | }, |
| 135 | insertAndDeleteInputs: []string{ |
| 136 | "INSERT INTO tb1 VALUES( 'hello', 1, 11, 'q' );", |
| 137 | "INSERT INTO tb1 VALUES( 'goodbye', 2, NULL, 'w' );", |
| 138 | "INSERT INTO tb1 VALUES( 'byebye', 3, 33, 'e' );", |
| 139 | }, |
| 140 | selectInput: "SELECT one, two, three, four FROM tb1 WHERE three IN (11, NULL, 67);", |
| 141 | expectedOutput: [][]string{ |
| 142 | {"one", "two", "three", "four"}, |
| 143 | {"hello", "1", "11", "q"}, |
| 144 | {"goodbye", "2", "NULL", "w"}, |
| 145 | }, |
| 146 | } |
| 147 | |
| 148 | engineTestSuite.runTestSuite(t) |
| 149 | } |
| 150 | |
| 151 | func TestSelectWithWhereNotContains(t *testing.T) { |
| 152 | engineTestSuite := engineTableContentTestSuite{ |
nothing calls this directly
no test coverage detected