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. > 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.
