Hello, 2014-09-06 17:55 GMT+02:00 Thomas Mueller <[email protected]>:
> Hi, > > One problem is that this would not be backward compatible for some cases, > if the select list uses the same identifier names as available in the > selected tables. > Hmm, I can see how such a change would be a breaking change. I'm still not sure, though, if the status quo is correct (according to the SQL standard) or not. In any case, I still find it to be surprising that expressions work only on columns from the table reference, not from the select list, yet (renamed) columns from the select list can be referenced "standalone". > Do you know which databases support it and which don't? > There actually weren't too many (I think 5 among the 17 supported by jOOQ) when I last ran that test. Right now, I don't have access to all my integration test databases for a while, so I won't be able to help you with this right now. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
