You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Porting from modernc.org/sqlite to this package, one of my queries fail preparation, where it executed without issue on modernc:
sqlite.Prepare: SQLITE_ERROR: no such table: temp.seen (DELETE FROM dirty WHERE NOT EXISTS (SELECT 1 FROM temp.seen WHERE temp.seen.path = dirty.path))
Schema, for context:
CREATE TABLE IF NOT EXISTS dirty (
id INTEGER PRIMARY KEY,
path TEXT,
mtime DATETIME,
size INTEGER,
dev INTEGER,
inode INTEGER,
canread INTEGER,
dirty INTEGER
);
CREATE TEMPORARY TABLE temp.seen (path TEXT);
afaict, queries across regular and temporary tables should Just Work, but something about how this package sets things up makes it unable to query temporary tables in the same query as a non-temporary table (other queries that only touch the temporary table or non-temporary table work fine).
The text was updated successfully, but these errors were encountered:
Porting from modernc.org/sqlite to this package, one of my queries fail preparation, where it executed without issue on modernc:
Schema, for context:
afaict, queries across regular and temporary tables should Just Work, but something about how this package sets things up makes it unable to query temporary tables in the same query as a non-temporary table (other queries that only touch the temporary table or non-temporary table work fine).
The text was updated successfully, but these errors were encountered: