Are you using a different lexical policy than the default? Does your connect string contain “lex=“ or “quoting=“? Or did you set “lex” or “quoting” in your connection properties?
Julian PS Please subscribe to the dev list so I don’t have to moderate your reply. > On Dec 16, 2016, at 1:26 PM, Julian Stenzel <[email protected]> > wrote: > > yea, i already tried it. This time it encounters: java.sql.SQLException: > Error while executing SQL "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: parse failed: Encountered > "\"" at line 1, column 8.>Did you know that you can quote table and column > names? Use double quotes, e.g. > >> select * from "My table that has spaces in its name" >>> Julian
