895 B
895 B
Summary
**No review yet**Minimized query
ATTACH DATABASE ':memory:' AS aux44;
CREATE TABLE T (
a INTEGER,
b REAL,
c REAL
);
INSERT INTO T VALUES (strftime('%s', if(0, 9145485036963515638, 9145485036963515638)),1.5,10.0), (2,-2.5,20.0), (3,-9e999,30.0);
SELECT * FROM T WHERE b < 2.0 ORDER BY b;
DETACH DATABASE aux44;
SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.a = T.a);
INSERT INTO T VALUES (NULL, NULL, NULL);
INSERT OR ROLLBACK INTO T VALUES (NULL, NULL, '');
Actual output
Parse error near line 7: no such function: if
INSERT INTO T VALUES (strftime('%s', if(0, 9145485036963515638, 91454850369635
error here ---^
Expectation
Flag