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
mariadb: Help: Error 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'returning' at line 1
postgres: Help: Error 42601 syntax error at or near "returning"
We should not allow RETURNING in that position either
Activity
lovasoa commentedon Jan 16, 2025
This is because we currently allow
RETURNINGas an unquoted table alias identifier. Most DBs don't.fails in
SQLITE_ERROR: sqlite3 result code 1: near "returning": syntax error: https://sqliteonline.com/#sqltext=%23url-sqlite%3Ddb-sqlite%0D%0A%23tab-name%3DSQLite.3%0D%0Aselect%20*%20from%20demo%20returningHelp: Error 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'returning' at line 1Help: Error 42601 syntax error at or near "returning"We should not allow
RETURNINGin that position eitherfix parsing of `INSERT INTO ... SELECT ... RETURNING `
fix parsing of `INSERT INTO ... SELECT ... RETURNING `
lovasoa commentedon Jan 16, 2025
I am going to need this in the sqlpage spreadsheet component: https://github.com/sqlpage/sqlpage-spreadsheet