FirebirdSQL / firebird

Firebird server, client and tools
https://www.firebirdsql.org/
1.26k stars 217 forks source link

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

Open firebird-automations opened 17 years ago

firebird-automations commented 17 years ago

Submitted by: lacak (lacak)

SQL Stand. 92/2003 defines :

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

INTO clause before FROM clause

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

firebird-automations commented 16 years ago
Modified by: @pcisar Workflow: jira \[ 12690 \] =\> Firebird \[ 14173 \]
dyemanov commented 10 months ago

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