[#MDEV-12919] Make keyword FROM optional in DELETE statement

[MDEV-12919] Make keyword FROM optional in DELETE statement Created: 2017-05-25 Updated: 2023-11-09
Status:	Open
Project:	MariaDB Server
Component/s:	None
Fix Version/s:	None

Type:

Task

Priority:

Minor

Reporter:

Tadas Balaišis

Assignee:

Unassigned

Resolution:

Unresolved

Votes:

Labels:

Compatibility

Description

Make keyword FROM optional in DELETE statement:

DELETE [LOW_PRIORITY] [QUICK] [IGNORE]
FROM tbl_name

DELETE [LOW_PRIORITY] [QUICK] [IGNORE]
[FROM] tbl_name

This would help in porting application from Oracle.

Comments

Comment by Tadas Balaišis [ 2023-11-09 ]

As a workaround, you may change your code like this:

Find:

delete\s+(from)*\s*(\w+)

Replace:

delete from \2

[x] Regular expression

Generated at Thu Feb 08 08:01:31 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.