why are errors from running a .sql file on d1 so damn vague, I need a line number ```X [ERROR] near
why are errors from running a .sql file on d1 so damn vague, I need a line number
X [ERROR] near ")": syntax errornearparse error which mean editor detected it.sqlite3 detected it, not the sqlite engine itself.nearsqlite3ErrorMsg(pParse, "near \"%T\": syntax error", &TOKEN);Parse error near line 163: near "VALUES": syntax error
INSERT INTO "keyedData" ("key", "data" VALUES ('expirationTimeForJWT', '216000
error here ---^Parse error near line 135: near "(": syntax error
nnedOut IS dateTime(timeScannedOut)) PRIMARY KEY (lineNum, ticketNumber) );
error here ---^X [ERROR] near "(": syntax errorParse error near line 135parse errorsqlite3 Test.db ".read testdata.sql"sqlite3X [ERROR] The supplied SQL string contains more than one statement-- CREATE TRIGGER check_lineValuesAreValidIndexes BEFORE
-- INSERT ON lines FOR EACH ROW BEGIN
-- SELECT CASE
-- WHEN (
-- (
-- SELECT lineManagerId
-- FROM lineManagers
-- WHERE lineManagerId = NEW.lineCreator
-- ) IS NULL
-- ) THEN RAISE(
-- ABORT,
-- 'lineCreator not found in lineManagers table'
-- )
-- END;
-- END;