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

Implicitly convert character values in comparisons

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.2.0-incubating
    • Component/s: None
    • Labels:
      None

      Description

      In relational DB such as Postgres, this query works fine.
      "select ... from ... where column (INT type) between '10' and '11'"

      Calcite blocks this query early by the fact that data types "char" & "integer" are not directly compatible. However, this is very common for people to filter columns with date types. For example,

      "...where date between '1911-01-01' and '1911-01-02' "

      To relax this type check when comparing with literals can help improve usability.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                julianhyde Julian Hyde
                Reporter:
                seanhychu Sean Hsuan-Yi Chu
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: