(t *testing.T)
| 281 | } |
| 282 | |
| 283 | func TestBinaryLogic(t *testing.T) { |
| 284 | RunScripts(t, []ScriptTest{ |
| 285 | { |
| 286 | Name: "AND", |
| 287 | Assertions: []ScriptTestAssertion{ |
| 288 | { |
| 289 | Query: `SELECT 1 = 1 AND 2 = 2;`, |
| 290 | Expected: []sql.Row{{"t"}}, |
| 291 | }, |
| 292 | { |
| 293 | Query: `SELECT (1 = 1 AND 2 = 2) AND (false);`, |
| 294 | Expected: []sql.Row{{"f"}}, |
| 295 | }, |
| 296 | { |
| 297 | Query: `SELECT (1 > 1 AND 2 = 2);`, |
| 298 | Expected: []sql.Row{{"f"}}, |
| 299 | }, |
| 300 | { |
| 301 | Query: `SELECT (1 = 1 AND 2 = 2) AND (false);`, |
| 302 | Expected: []sql.Row{{"f"}}, |
| 303 | }, |
| 304 | { |
| 305 | Query: `SELECT (1 = 1 AND 2 = 2) AND (true);`, |
| 306 | Expected: []sql.Row{{"t"}}, |
| 307 | }, |
| 308 | }, |
| 309 | }, |
| 310 | { |
| 311 | Name: "OR", |
| 312 | Assertions: []ScriptTestAssertion{ |
| 313 | { |
| 314 | Query: `SELECT 1 = 1 OR 2 = 2;`, |
| 315 | Expected: []sql.Row{{"t"}}, |
| 316 | }, |
| 317 | { |
| 318 | Query: `SELECT (1 = 1 AND 2 = 2) OR (false);`, |
| 319 | Expected: []sql.Row{{"t"}}, |
| 320 | }, |
| 321 | { |
| 322 | Query: `SELECT (1 > 1 OR 2 = 2);`, |
| 323 | Expected: []sql.Row{{"t"}}, |
| 324 | }, |
| 325 | { |
| 326 | Query: `SELECT (1 > 1 OR 2 > 2);`, |
| 327 | Expected: []sql.Row{{"f"}}, |
| 328 | }, |
| 329 | { |
| 330 | Query: `SELECT (1 > 1 OR 2 > 2) OR (true);`, |
| 331 | Expected: []sql.Row{{"t"}}, |
| 332 | }, |
| 333 | { |
| 334 | Query: `SELECT (1 = 1 AND 2 = 2) OR (true);`, |
| 335 | Expected: []sql.Row{{"t"}}, |
| 336 | }, |
| 337 | }, |
| 338 | }, |
| 339 | { |
| 340 | Name: "IS DISTINCT FROM", |
nothing calls this directly
no test coverage detected