Hello!
Our user expecting some problem with DELETE statement with returning clause.
dbeaver/dbeaver#15946
Because delete from t returning *; statement can't be parsed
Please, add support of RETURNING clause in DELETE statement.
Encountered unexpected token: "returning" "RETURNING"
at line 1, column 15.
Was expecting one of:
";"
"ACTION"
"ACTIVE"
"ALGORITHM"
"ARCHIVE"
"ARRAY"
"AS"
"AT"
"BYTE"
"CASCADE"
"CASE"
"CAST"
"CHANGE"
"CHAR"
"CHARACTER"
"CHECKPOINT"
"COLUMN"
"COLUMNS"
"COMMENT"
"COMMIT"
"COSTS"
"CYCLE"
"DBA_RECYCLEBIN"
"DESC"
"DESCRIBE"
"DISABLE"
"DISCONNECT"
"DIV"
"DO"
"DUMP"
"DUPLICATE"
"ENABLE"
"END"
"EXCLUDE"
"EXTRACT"
"FALSE"
"FILTER"
"FIRST"
"FLUSH"
"FN"
"FOLLOWING"
"FORMAT"
"FULLTEXT"
"HISTORY"
"INDEX"
"INSERT"
"INTERVAL"
"ISNULL"
"JSON"
"KEY"
"LAST"
"LEADING"
"LIMIT"
"LINK"
"LOCAL"
"LOG"
"MATERIALIZED"
"NO"
"NOLOCK"
"NULLS"
"OF"
"OPEN"
"ORDER"
"OVER"
"PARALLEL"
"PARTITION"
"PATH"
"PERCENT"
"PRECISION"
"PRIMARY"
"PRIOR"
"QUERY"
"QUIESCE"
"RANGE"
"READ"
"RECYCLEBIN"
"REGISTER"
"REPLACE"
"RESTRICTED"
"RESUME"
"ROW"
"ROWS"
"SCHEMA"
"SEPARATOR"
"SEQUENCE"
"SESSION"
"SHUTDOWN"
"SIBLINGS"
"SIGNED"
"SIZE"
"SKIP"
"SUSPEND"
"SWITCH"
"SYNONYM"
"SYSTEM"
"TABLE"
"TABLESPACE"
"TEMP"
"TEMPORARY"
"TIMEOUT"
"TO"
"TOP"
"TRUE"
"TRUNCATE"
"TRY_CAST"
"TYPE"
"UNQIESCE"
"UNSIGNED"
"USER"
"USING"
"VALIDATE"
"VALUE"
"VALUES"
"VIEW"
"WHERE"
"XML"
"ZONE"
<EOF>
<K_DATETIMELITERAL>
<K_DATE_LITERAL>
<K_NEXTVAL>
<K_STRING_FUNCTION_NAME>
<S_CHAR_LITERAL>
<S_IDENTIFIER>
<S_QUOTED_IDENTIFIER>
SQL Example
This statement doesn't work.
delete from t returning *;
And Update statement already support returning statement:
update t set a = 1 returning *;
I see that UPDATE supports returning clause, and DELETE statement - don't.
Software Information
- JSqlParser version - 4.2
- Database - PostgreSQL
Reactions are currently unavailable
Hello!
Our user expecting some problem with DELETE statement with returning clause.
dbeaver/dbeaver#15946
Because delete from t returning *; statement can't be parsed
Please, add support of RETURNING clause in DELETE statement.
Encountered unexpected token: "returning" "RETURNING" at line 1, column 15. Was expecting one of: ";" "ACTION" "ACTIVE" "ALGORITHM" "ARCHIVE" "ARRAY" "AS" "AT" "BYTE" "CASCADE" "CASE" "CAST" "CHANGE" "CHAR" "CHARACTER" "CHECKPOINT" "COLUMN" "COLUMNS" "COMMENT" "COMMIT" "COSTS" "CYCLE" "DBA_RECYCLEBIN" "DESC" "DESCRIBE" "DISABLE" "DISCONNECT" "DIV" "DO" "DUMP" "DUPLICATE" "ENABLE" "END" "EXCLUDE" "EXTRACT" "FALSE" "FILTER" "FIRST" "FLUSH" "FN" "FOLLOWING" "FORMAT" "FULLTEXT" "HISTORY" "INDEX" "INSERT" "INTERVAL" "ISNULL" "JSON" "KEY" "LAST" "LEADING" "LIMIT" "LINK" "LOCAL" "LOG" "MATERIALIZED" "NO" "NOLOCK" "NULLS" "OF" "OPEN" "ORDER" "OVER" "PARALLEL" "PARTITION" "PATH" "PERCENT" "PRECISION" "PRIMARY" "PRIOR" "QUERY" "QUIESCE" "RANGE" "READ" "RECYCLEBIN" "REGISTER" "REPLACE" "RESTRICTED" "RESUME" "ROW" "ROWS" "SCHEMA" "SEPARATOR" "SEQUENCE" "SESSION" "SHUTDOWN" "SIBLINGS" "SIGNED" "SIZE" "SKIP" "SUSPEND" "SWITCH" "SYNONYM" "SYSTEM" "TABLE" "TABLESPACE" "TEMP" "TEMPORARY" "TIMEOUT" "TO" "TOP" "TRUE" "TRUNCATE" "TRY_CAST" "TYPE" "UNQIESCE" "UNSIGNED" "USER" "USING" "VALIDATE" "VALUE" "VALUES" "VIEW" "WHERE" "XML" "ZONE" <EOF> <K_DATETIMELITERAL> <K_DATE_LITERAL> <K_NEXTVAL> <K_STRING_FUNCTION_NAME> <S_CHAR_LITERAL> <S_IDENTIFIER> <S_QUOTED_IDENTIFIER>SQL Example
This statement doesn't work.
delete from t returning *;
And Update statement already support returning statement:
update t set a = 1 returning *;
I see that UPDATE supports returning clause, and DELETE statement - don't.
Software Information