Returning zero from user-defined function treated as returning null #296

AnyhowStep · 2019-09-20T17:42:43Z

db = new Database();
db.create_function(
    "returnZero",
    () => 0
);
db.exec("SELECT returnZero(), 0");

Expected:

returnZero()	0
0	0

Actual:

returnZero()	0
null	0

AnyhowStep · 2019-09-20T20:08:25Z

Tracked the bug down to this line of code.

AnyhowStep · 2019-09-20T20:08:49Z

!0 is true.

So, it thinks 0 is null

AnyhowStep · 2019-09-20T20:09:54Z

AnyhowStep · 2019-09-20T20:11:22Z

Seems like it was fixed recently, but no npm package was published, and the dist was not updated.

sql-js / sql.js