Skip to content

Pushed-down WHERE matches SQL three-valued logic on null cells #369

Pushed-down WHERE matches SQL three-valued logic on null cells

Pushed-down WHERE matches SQL three-valued logic on null cells #369

Triggered via push August 13, 2026 20:56
Status Failure
Total duration 29s
Artifacts

ci.yml

on: push
Fit to window
Zoom out
Zoom in

Annotations

10 errors
test/sql/whereFilter.equivalence.test.js > pushed-down WHERE matches the engine on nullable columns > agrees for NOT (n IN (5, 9)): test/sql/whereFilter.equivalence.test.js#L94
AssertionError: expected [] to deeply equal [ 2 ] - Expected + Received - [ - 2, - ] + [] ❯ test/sql/whereFilter.equivalence.test.js:94:22
test/sql/whereFilter.equivalence.test.js > pushed-down WHERE matches the engine on nullable columns > agrees for n NOT IN (5, NULL): test/sql/whereFilter.equivalence.test.js#L94
AssertionError: expected [] to deeply equal [ 3 ] - Expected + Received - [ - 3, - ] + [] ❯ test/sql/whereFilter.equivalence.test.js:94:22
test/sql/whereFilter.equivalence.test.js > pushed-down WHERE matches the engine on nullable columns > agrees for n IN (5, NULL): test/sql/whereFilter.equivalence.test.js#L94
AssertionError: expected [ 1 ] to deeply equal [ 1, 2 ] - Expected + Received [ 1, - 2, ] ❯ test/sql/whereFilter.equivalence.test.js:94:22
test/sql/whereFilter.equivalence.test.js > pushed-down WHERE matches the engine on nullable columns > agrees for n NOT IN (5, 9): test/sql/whereFilter.equivalence.test.js#L94
AssertionError: expected [] to deeply equal [ 2 ] - Expected + Received - [ - 2, - ] + [] ❯ test/sql/whereFilter.equivalence.test.js:94:22
test/sql/whereFilter.equivalence.test.js > pushed-down WHERE matches the engine on nullable columns > agrees for NOT (5 < n): test/sql/whereFilter.equivalence.test.js#L94
AssertionError: expected [ 1 ] to deeply equal [ 1, 2 ] - Expected + Received [ 1, - 2, ] ❯ test/sql/whereFilter.equivalence.test.js:94:22
test/sql/whereFilter.equivalence.test.js > pushed-down WHERE matches the engine on nullable columns > agrees for NOT (n > 3): test/sql/whereFilter.equivalence.test.js#L94
AssertionError: expected [] to deeply equal [ 2 ] - Expected + Received - [ - 2, - ] + [] ❯ test/sql/whereFilter.equivalence.test.js:94:22
test/sql/whereFilter.equivalence.test.js > pushed-down WHERE matches the engine on nullable columns > agrees for NOT (n >= 7): test/sql/whereFilter.equivalence.test.js#L94
AssertionError: expected [ 1 ] to deeply equal [ 1, 2 ] - Expected + Received [ 1, - 2, ] ❯ test/sql/whereFilter.equivalence.test.js:94:22
test/sql/whereFilter.equivalence.test.js > pushed-down WHERE matches the engine on nullable columns > agrees for NOT (n < 7): test/sql/whereFilter.equivalence.test.js#L94
AssertionError: expected [ 3 ] to deeply equal [ 2, 3 ] - Expected + Received [ - 2, 3, ] ❯ test/sql/whereFilter.equivalence.test.js:94:22
test/sql/whereFilter.equivalence.test.js > pushed-down WHERE matches the engine on nullable columns > agrees for NOT (n != 5): test/sql/whereFilter.equivalence.test.js#L94
AssertionError: expected [ 1 ] to deeply equal [ 1, 2 ] - Expected + Received [ 1, - 2, ] ❯ test/sql/whereFilter.equivalence.test.js:94:22
test/sql/whereFilter.equivalence.test.js > pushed-down WHERE matches the engine on nullable columns > agrees for NOT (n = 5): test/sql/whereFilter.equivalence.test.js#L94
AssertionError: expected [ 3 ] to deeply equal [ 2, 3 ] - Expected + Received [ - 2, 3, ] ❯ test/sql/whereFilter.equivalence.test.js:94:22