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

Allow literals like DECIMAL '12.3' (consistent with Postgres)

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.36.0
    • core

    Description

      In Postgresql,It supports the following sql grammar:

      select DECIMAL '99.999' 

      Postgresql converts DECIMAL '99.999' to numeric constants:

      Now core sql parser converts DECIMAL '99.999' to AS SqlBasicCall,like this:

      this jira allow literals like DECIMAL '12.3' (consistent with Postgres)

      Attachments

        1. image-2023-07-24-19-23-30-316.png
          37 kB
          LakeShen
        2. image-2023-07-24-19-26-44-131.png
          159 kB
          LakeShen

        Issue Links

          Activity

            People

              shenlang LakeShen
              shenlang LakeShen
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: