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

ARRAY string constructor, and implicit cast from string literal (enabled in PostgreSQL conformance)

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.33.0
    • core

    Description

      According to the documentation https://www.postgresql.org/docs/current/arrays.html

      Postgres dialect should support implicit cast from string literal to array literal:

      SELECT ARRAY[1,2,3] = '{1,2,3}'

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-5147 Allow DATE, TIME, TIMESTAMP, INTERVAL literals in BigQuery dialect

          • Major - Major loss of function.
          • Closed
          links to

          Web Link GitHub Pull Request #2819

          Activity

            People

              dmsysolyatin Dmitry Sysolyatin
              dmsysolyatin Dmitry Sysolyatin
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 2h 10m
                  2h 10m