Date: 2020-06-13 14:23:15 +0200
From: @PedroTadim
To: SQL devs <>
Version: 11.37.7 (Jun2020)

Last updated: 2020-07-27 09:30:12 +0200

Comment 27842

Date: 2020-06-13 14:23:15 +0200
From: @PedroTadim

User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36
Build Identifier:

Run the statements below.

Reproducible: Always

Steps to Reproduce:

CREATE TABLE t0 (a int, b int);
insert into t0 values (1,1);
select 1 from t0 where (3 in (1, 2)) is null;

Actual Results:

TypeException:user.s42_0[22]:'algebra.select' undefined in: algebra.select(X_30:bat[:oid], X_32:bit, X_32:bit, true:bit, true:bit, false:bit);

Expected Results:

Empty result set.