ty for the documentation - the problem has been solved
Julian Hyde <[email protected]> schrieb am 1:05 Sonntag, 18.Dezember 2016:
The JAVA lexical convention allows back-ticks to quote identifiers[1]. So,
write
SELECT `33d2004a-b157-40c2-8e9b-38a58eb42a94`.id,
`33d2004a-b157-40c2-8e9b-38a58eb42a94`.name
FROM `33d2004a-b157-40c2-8e9b-38a58eb42a94`
WHERE `33d2004a-b157-40c2-8e9b-38a58eb42a94`.name = ‘test'
AND `33d2004a-b157-40c2-8e9b-38a58eb42a94`.id = 5
AND `33d2004a-b157-40c2-8e9b-38a58eb42a94`.version = 3
Note I added single-quotes around ‘test’ because I presume it’s a character
literal.
Julian
[1] https://calcite.apache.org/apidocs/org/apache/calcite/config/Lex.html#JAVA
<https://calcite.apache.org/apidocs/org/apache/calcite/config/Lex.html#JAVA>
> On Dec 17, 2016, at 2:13 PM, Julian <[email protected]> wrote:
>
> iam using JAVA as lex:
>
> Class.forName("org.apache.calcite.jdbc.Driver");
> info = new Properties();
> info.setProperty("lex", "JAVA");
>
> connection = DriverManager.getConnection("jdbc:calcite:model/model.json",
> info);
>
> no other changes from default...
>
> thank you
>
> P.S: next time i will reply right ;-)
>
> Von meinem iPad gesendet
