I completely understand technical reasons but I don't believe that in any database engine query like SELECT * or SELECT X will work. Don't you think its a bug?
Sergi On Thursday, August 16, 2012 12:34:49 AM UTC+4, Thomas Mueller wrote: > > Hi, > > SELECT 1 and SELECT "Hello" also works, and is required to work for > compatibility with other databases. Internally, this is converted to SELECT > .. FROM DUAL. And DUAL is a table with one column (X) and one row (1). > > Regards, > Thomas > > > On Wed, Aug 15, 2012 at 2:19 PM, Sergi Vladykin > <[email protected]<javascript:> > > wrote: > >> Hi, >> >> Running query "SELECT *" returns one row with column named X and value 1. >> Query "SELECT X" works as well. Is it intended behavior? I expected such a >> query to fail with error. >> >> Sergi >> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To view this discussion on the web visit >> https://groups.google.com/d/msg/h2-database/-/ANbUZYPTvNQJ. >> To post to this group, send email to [email protected]<javascript:> >> . >> To unsubscribe from this group, send email to >> [email protected] <javascript:>. >> For more options, visit this group at >> http://groups.google.com/group/h2-database?hl=en. >> > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/fFApFcWsbS0J. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
