Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-6835

Invalid unparse for IS TRUE,IS FALSE,IS NOT TRUE and IS NOT FALSE in StarRocksDialect

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.40.0
    • None

    Description

      The SQL: 

      // SKIPPED is Boolean Type
      select SKIPPED is not true from be_cloud_native_compactions;
      select * from be_cloud_native_compactionswhere SKIPPED is NOT true. 

      throws exception:

      (conn=152) Getting syntax error at line 1, column 22. Detail message: Unexpected input 'true', the most similar input is {'NULL'}. 

      Attachments

        Issue Links

          Activity

            People

              nobigo xiong duan
              nobigo xiong duan
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: