[h2] Re: LINEKED TABLE contains a select query to a row name with slachs

2019-08-14 Thread Evgenij Ryazanov
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

[h2] LINEKED TABLE contains a select query to a row name with slachs

2019-08-14 Thread Sofiane CHELABI
Hi all, I'm trying to create an H2 link to an oracle database with this query : CREATE LINKED TABLE MyLinekTable('oracle.jdbc.OracleDriver','jdbc:oracle:thin:@127.0.0.1:1521:orcl','login','password','(SELECT "/BIC/ZBSARK" as FLOW FROM MYTABLE)'); And i get this error : Error: ORA-01424: