Hi, No, I don't think it's a bug. My boss once said the definition of a bug is a difference between implementation and documentation / specification. In this case it's more like unexpected or strange behavior. But I don't think it is documented or specified anywhere that "SELECT *" or "SELECT X" is supposed to fail.
Regards, Thomas On Wed, Aug 15, 2012 at 10:53 PM, Sergi Vladykin <[email protected]>wrote: > 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]>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<https://groups.google.com/d/msg/h2-database/-/ANbUZYPTvNQJ> >>> **. >>> To post to this group, send email to [email protected]. >>> To unsubscribe from this group, send email to h2-database...@** >>> googlegroups.com. >>> >>> For more options, visit this group at http://groups.google.com/** >>> group/h2-database?hl=en<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. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. 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.
