firebird icon indicating copy to clipboard operation
firebird copied to clipboard

Make syntax of "SELECT ... INTO" sql standard compliant [CORE1382]

Open firebird-automations opened this issue 18 years ago • 2 comments

Submitted by: lacak (lacak)

SQL Stand. 92/2003 defines :

SELECT [ <set quantifier> ] <select list> INTO <select target list>

INTO clause before FROM clause

(Today Firebird allows INTO only as last clause of SELECT : singleton_select : select INTO variable_list )

firebird-automations avatar Jul 26 '07 08:07 firebird-automations

Modified by: @pcisar

Workflow: jira [ 12690 ] => Firebird [ 14173 ]

firebird-automations avatar Jan 28 '08 15:01 firebird-automations

Since we'll have to support both positions (for backward compatibility), I doubt this feature gonna add something but confusion.

dyemanov avatar Jan 15 '24 17:01 dyemanov