Hello. It looks like the problem is caused by H2's attempt to fetch metadata of the source table. H2 tries to pass its name as is even when it definitely is a query and not a plain name. I filled an issue about it on GitHub: https://github.com/h2database/h2database/issues/2073
I don't think that there are workarounds if you really need to use that query for a some reason, but you can try to create a link to the whole table by specifying its name instead of such query. Do you really need to have a column with such unusual name? It's just asking for trouble. -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/e20cd825-5957-4700-90b3-bcdbdcfca153%40googlegroups.com.
