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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/e20cd825-5957-4700-90b3-bcdbdcfca153%40googlegroups.com.