716 B
716 B
Summary
**No review yet**Minimized query
.once log.txt
CREATE TABLE T (
a TEXT,
b TEXT
);
INSERT INTO T VALUES ('a','2020-01-01'), ('b','2026-01-01');
SELECT a,
CAST(
(julianday('now')-julianday(b))/concat('text', 123, NULL)
AS INTEGER
) AS c
FROM T;
ALTER TABLE T DROP COLUMN b;
Actual output
Parse error near line 7: no such function: concat
SELECT a, CAST( (julianday('now')-julianday(b))/concat('text', 123, NULL)
error here ---^
Expectation
Flag