ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From afedotov <alexander.fedot...@gmail.com>
Subject Re: SQL Syntax error in cross-cache query
Date Thu, 20 Jul 2017 06:08:43 GMT

You need either adjust entity/table name to the upper case like *select ID
from "personCache".PERSON p limit 5* or
add a config option <propertyname="sqlEscapeAll" value="true"/>, in this
case you will be able to perform the query
in the following way *select \"id\" from \"personCache\".\"Person\" p limit
5* (note the escaping is mandatory for all the parts: schema, table, field).

Kind regards,

Kind regards,

19 июля 2017 г. 9:16 AM пользователь "howfree [via Apache Ignite Users]"
ml+s70518n15102h96@n6.nabble.com> написал:

> The following error came up: Schema "PERSONCACHE" not found. The style
> \"personCache\" can be separated from the Schema "personCache" in H2.
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
> http://apache-ignite-users.70518.x6.nabble.com/SQL-
> Syntax-error-in-cross-cache-query-tp15097p15102.html
> To start a new topic under Apache Ignite Users, email
> ml+s70518n1h65@n6.nabble.com
> To unsubscribe from Apache Ignite Users, click here
> <http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=1&code=YWxleGFuZGVyLmZlZG90b2ZmQGdtYWlsLmNvbXwxfC0xMzYxNTU0NTg=>
> .
> <http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>

View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Re-SQL-Syntax-error-in-cross-cache-query-tp15158.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
View raw message