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

Allow NULL literal as argument

          Details

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

            Description

            Even though the SQL standard does not allow raw (non-casted) NULL literals, most databases do. So we should allow 1 = null or select * from emp where empno > null. Of course, these expressions always return UNKNOWN.

              Attachments

                Issue Links

                relates to

                Bug - A problem which impairs or prevents the functions of the product. CALCITE-2921 nullif(null,y) throws exception in verification

                • Critical - Crashes, loss of data, severe memory leak.
                • Open

                  Activity

                    People

                    • Assignee:
                      julianhyde Julian Hyde
                      Reporter:
                      julianhyde Julian Hyde
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: