Unexpected ANTI JOIN Result

[TheoristCoder]

Dear Dolt Developers,
I encountered an unexpected execution result in Dolt and would greatly appreciate it if you could take a look. Let's make concerted efforts in enhancing the robustness of Dolt. Thank you very much!

CREATE TABLE t1(c0 VARCHAR(500), PRIMARY KEY(c0));
INSERT INTO t1(c0) VALUES ('9');
SELECT * FROM t1 WHERE NOT EXISTS (SELECT 1 FROM (SELECT 1) AS sub0 WHERE ASIN(t1.c0));
-- Wrong Execution Result: Empty Result
-- Expected Result: 9

Commit: 256bfca

[timsehn]

@angelamayxie is out until Dec. 1. We may pick this up before then but she is the specialist. Expect a delayed resolution. We know you are running a testing framework and this is not blocking your use of Dolt.

[TheoristCoder]

@angelamayxie is out until Dec. 1. We may pick this up before then but she is the specialist. Expect a delayed resolution. We know you are running a testing framework and this is not blocking your use of Dolt.

Actually, I am running a testing framework.

[angelamayxie]

As of Dolt version 1.78.5, I'm not able to repro.

tmp/main*> create table t1(c0 varchar(500), primary key(c0));
Query OK, 0 rows affected (0.01 sec)
tmp/main*> insert into t1(c0) values('9');
Query OK, 1 row affected (0.01 sec)
tmp/main*> select * from t1 where not exists (select 1 from (select 1) as sub0 where asin(t1.c0));
Empty set (0.00 sec)

tmp/main*> select dolt_version();
+----------------+
| dolt_version() |
+----------------+
| 1.78.5         |
+----------------+
1 row in set (0.00 sec) 

[TheoristCoder]

I think you have reproduced. The expected result is 9 but it produces empty, which is wrong

[angelamayxie]

@TheoristCoder Sorry, I misread your report. Reopening and will look into this

[angelamayxie]

This is likely because Asin.IsNullable() is not returning true