Groups | Search | Server Info | Login | Register
Groups > comp.databases.mysql > #510
| From | Serge Rielau <srielau@ca.ibm.com> |
|---|---|
| Newsgroups | comp.databases.mysql |
| Subject | Re: UPDATE as subquery of SELECT |
| Date | 2011-04-04 18:59 -0400 |
| Organization | IBM Canada |
| Message-ID | <8vv0pvF2lfU1@mid.individual.net> (permalink) |
| References | (1 earlier) <imhvlf$mje$1@dont-email.me> <8v9kkoF1ehU1@mid.individual.net> <imoq3e$9sv$1@dont-email.me> <8vbbfgFnrsU1@mid.individual.net> <imq3mi$qc1$2@dont-email.me> |
On 3/28/2011 9:50 AM, Jerry Stuckle wrote: > On 3/28/2011 7:58 AM, Serge Rielau wrote: >>> Interesting, Serge. I haven't seen that in the SQL specs. Do you know >>> which version specified it? >> Should be in SQL:2008 >> Checking.... >> >> We first published the extension at VLDB 2004: >> http://portal.acm.org/citation.cfm?id=1316774 >> >> Cheers >> Serge >> > > Interesting, and I can see where there could be performance > improvements. But which version of the ANSI standard picked it up? > I have bugged our standards reps and here is the feedback I got: "Yes, SELECT FROM INSERT has indeed made it into ANSI as well as ISO SQL standards, but it is not yet visible to the wider world since it was introduced after the current version of SQL standard, SQL-2008, came out. It will become visible when the next version gets published, which is expected either late this year or early next year. It normally takes 3 to 4 year cycle for a new version of SQL standard to come out." If you are interested I can send you a PDF of the submission. Cheers Serge -- Serge Rielau SQL Architect DB2 for LUW, IBM Toronto Lab Blog: tinyurl.com/SQLTips4DB2 Wiki: tinyurl.com/Oracle2DB2Wiki Twitter: srielau
Back to comp.databases.mysql | Previous | Next — Next in thread | Find similar
Re: UPDATE as subquery of SELECT Serge Rielau <srielau@ca.ibm.com> - 2011-04-04 18:59 -0400 Re: UPDATE as subquery of SELECT Jerry Stuckle <jstucklex@attglobal.net> - 2011-04-04 19:59 -0400
csiph-web