(t *testing.T)
| 149 | } |
| 150 | |
| 151 | func TestSelectWithWhereNotContains(t *testing.T) { |
| 152 | engineTestSuite := engineTableContentTestSuite{ |
| 153 | createInputs: []string{ |
| 154 | "CREATE TABLE tb1( one TEXT, two INT, three INT, four TEXT );", |
| 155 | }, |
| 156 | insertAndDeleteInputs: []string{ |
| 157 | "INSERT INTO tb1 VALUES( 'hello', 1, 11, 'q' );", |
| 158 | "INSERT INTO tb1 VALUES( 'goodbye', 2, 22, 'w' );", |
| 159 | "INSERT INTO tb1 VALUES( 'byebye', 3, 33, 'e' );", |
| 160 | }, |
| 161 | selectInput: "SELECT one, two, three, four FROM tb1 WHERE one NOTIN ('hello', 'byebye', 'youAreTheBest');", |
| 162 | expectedOutput: [][]string{ |
| 163 | {"one", "two", "three", "four"}, |
| 164 | {"goodbye", "2", "22", "w"}, |
| 165 | }, |
| 166 | } |
| 167 | |
| 168 | engineTestSuite.runTestSuite(t) |
| 169 | } |
| 170 | |
| 171 | func TestSelectWithWhereContainsButResponseIsEmpty(t *testing.T) { |
| 172 |
nothing calls this directly
no test coverage detected