I did some more experiments: select 'Hello' as X => ok select ? as X => ok select X as Y from (select 'Hello' as X) => ok select X as Y from (select ? as X) => error "Unknown datatype X"
Really surprising, and makes me curious about how a difference could be implemented there in the first place. Thanks Noel for pointing to TABLE as a workaround of that bug, but that's not an option for various reasons (multiple servers; generated sql strings). -- 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 https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
