(t *testing.T)
| 105 | } |
| 106 | |
| 107 | func TestSelectWithWhereNotEqual(t *testing.T) { |
| 108 | |
| 109 | engineTestSuite := engineTableContentTestSuite{ |
| 110 | createInputs: []string{ |
| 111 | "CREATE TABLE tb1( one TEXT, two INT, three INT, four TEXT );", |
| 112 | }, |
| 113 | insertAndDeleteInputs: []string{ |
| 114 | "INSERT INTO tb1 VALUES( 'hello', 1, 11, 'q' );", |
| 115 | "INSERT INTO tb1 VALUES( 'goodbye', 2, NULL, 'w' );", |
| 116 | "INSERT INTO tb1 VALUES( 'byebye', 3, 33, 'e' );", |
| 117 | }, |
| 118 | selectInput: "SELECT one, two, three, four FROM tb1 WHERE three NOT NULL;", |
| 119 | expectedOutput: [][]string{ |
| 120 | {"one", "two", "three", "four"}, |
| 121 | {"hello", "1", "11", "q"}, |
| 122 | {"byebye", "3", "33", "e"}, |
| 123 | }, |
| 124 | } |
| 125 | |
| 126 | engineTestSuite.runTestSuite(t) |
| 127 | } |
| 128 | |
| 129 | func TestSelectWithWhereContains(t *testing.T) { |
| 130 |
nothing calls this directly
no test coverage detected