Hello!
I think you should just escape column names properly when using them:
SELECT * FROM acc WHERE "accCol1" is null;
Regards,
--
Ilya Kasnacheev
сб, 28 дек. 2019 г. в 23:19, sr.prane...@gmail.com <sr.prane...@gmail.com>:
> Thanks for the suggestion
>
> I am using Pure SQL to create tables.
> I dont know how to use this option on the SQL Create syntax.
>
> I tried using the below code.
> cfg.setCacheConfiguration(
> new
>
> CacheConfiguration().setName("PUBLIC").setSqlSchema("PUBLIC").setSqlEscapeAll(true)
> );
> After when I create the table I see the same behaviour as before.
>
> I also tried creating cache as below.
> cfg.setCacheConfiguration(
> new
>
> CacheConfiguration().setName("SQL_PUBLIC_ACC").setSqlSchema("PUBLIC").setSqlEscapeAll(true)
> );
> But this is not allowing me to create table after that.
> java.sql.SQLException: Table already exists: ACC
> at
>
> org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:751)
>
>
> Is there a way to use this parameter with SQL create table?
>
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
