Hello, Thank you for your reply.
Yes it seems like a H2 issue (thanks for the opend issue on github ;) ) Yes i need exactlly to do this (customer need), my solution allow to link from H2 to a remote data , and the user can choose the kind of the remote data (table ro a result from a select querry ..). Thank you again for you help. Le mer. 14 août 2019 à 17:15, Evgenij Ryazanov <[email protected]> a écrit : > 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 > <https://groups.google.com/d/msgid/h2-database/e20cd825-5957-4700-90b3-bcdbdcfca153%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- Best regards, *Sofiane Chelabi | IT Engineer* Developpement & Consulting *ESB/ETL/BPM/BigData - JavaEE* Mob : +33 (0)7 60 85 09 95 Lyon - FRANCE ----------------------------------------------------------------------------------- -- 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/CAB0e0dAv%2BKEV%3DFp7XArUK5ZdnopRdM6BSmOtOQvcU-XBisJCjw%40mail.gmail.com.
