[
https://issues.apache.org/jira/browse/CALCITE-2498?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andrei Sereda updated CALCITE-2498:
-----------------------------------
Description:
Geode should keep booleans as is (without quoting them).
{code:sql}
// SQL (calcite). original query
select * from geode where isActive = true
// OQL (geode query) result
select * from /region where isActive = 'true'
{code}
[Boolean
literals|https://geode.apache.org/docs/guide/14/developing/query_additional/literals.html]
are natively supported by geode and calcite should not convert them to SQL
strings.
was:
Geode should keep booleans as is (without quoting them).
{code:sql}
// SQL (calcite). original query
select * from geode where isActive = true
// OQL (geode query) result
select * from /region where isActive = 'true'
{code}
[Boolean
literals|https://geode.apache.org/docs/guide/14/developing/query_additional/literals.html]
are natively supported in geode
> geode adapter wrongly quotes booleans as strings ('true' / 'false')
> -------------------------------------------------------------------
>
> Key: CALCITE-2498
> URL: https://issues.apache.org/jira/browse/CALCITE-2498
> Project: Calcite
> Issue Type: Bug
> Components: geode
> Reporter: Andrei Sereda
> Assignee: Julian Hyde
> Priority: Major
>
> Geode should keep booleans as is (without quoting them).
> {code:sql}
> // SQL (calcite). original query
> select * from geode where isActive = true
> // OQL (geode query) result
> select * from /region where isActive = 'true'
> {code}
>
> [Boolean
> literals|https://geode.apache.org/docs/guide/14/developing/query_additional/literals.html]
> are natively supported by geode and calcite should not convert them to SQL
> strings.
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
