[
https://issues.apache.org/jira/browse/CALCITE-6835?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17930277#comment-17930277
]
xiong duan edited comment on CALCITE-6835 at 2/25/25 11:13 AM:
---------------------------------------------------------------
This rewriting rule could be:
||Original expression||Replcaed expression||
|A IS TRUE|A IS NOT NUL AND A|
|A IS FALSE|A IS NOT NUL AND NOT A|
|A IS NOT TRUE|A IS NUL OR NOT A|
|A IS NOT FALSE|A IS NUL OR A|
was (Author: nobigo):
This rewriting rule could be:
||Original expression ||Replcaed expression||
|A IS TRUE|A IS NOT NUL AND A|
|A IS FALSE|A IS NOT NUL AND !A|
|A IS NOT TRUE|A IS NUL OR !A|
|A IS NOT FALSE|A IS NUL OR A|
> Invalid unparse for IS TRUE,IS FALSE,IS NOT TRUE and IS NOT FALSE in
> StarRocksDialect
> -------------------------------------------------------------------------------------
>
> Key: CALCITE-6835
> URL: https://issues.apache.org/jira/browse/CALCITE-6835
> Project: Calcite
> Issue Type: Bug
> Reporter: xiong duan
> Assignee: xiong duan
> Priority: Major
>
> The SQL:
> {code:java}
> // SKIPPED is Boolean Type
> select SKIPPED is not true from be_cloud_native_compactions;
> select * from be_cloud_native_compactionswhere SKIPPED is NOT true. {code}
> throws exception:
> {code:java}
> (conn=152) Getting syntax error at line 1, column 22. Detail message:
> Unexpected input 'true', the most similar input is {'NULL'}. {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
