Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-24817

Undocumented IS operator precendence change in 10.3.26

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • None
    • N/A
    • N/A
    • None

    Description

      Up to 10.3.25 both

      SELECT NULL IS NULL = 1;

      and

      SELECT (NULL IS NULL) = 1;

      worked and returned the same result.

      Starting with 10.3.26 only the 2nd variant with extra parenthesis still works, while the 1st variant now throws a syntax error "near '= 1'"

      No related entry on the 10.3.26 release notes page refers to such changed parser behavior.

      Attachments

        Issue Links

          Activity

            Trying this on other DMBS, both variants work on latest MySQL 8, on PostgreSQL and SQLite, but only the 2nd works on Microsoft SQL server (could not check Oracle as that seems to be broken in SQLfiddle right now).

            All but SQLite fail on

            SELECT NULL IS (NULL = TRUE);

            but that's understandable as there's no literal "IS NULL" in this case for the parser to see.

            hholzgra Hartmut Holzgraefe added a comment - Trying this on other DMBS, both variants work on latest MySQL 8, on PostgreSQL and SQLite, but only the 2nd works on Microsoft SQL server (could not check Oracle as that seems to be broken in SQLfiddle right now). All but SQLite fail on SELECT NULL IS (NULL = TRUE); but that's understandable as there's no literal "IS NULL" in this case for the parser to see.
            alice Alice Sherepa added a comment -

            fixed in 10.3.28 (MDEV-24194)

            alice Alice Sherepa added a comment - fixed in 10.3.28 ( MDEV-24194 )

            People

              Unassigned Unassigned
              hholzgra Hartmut Holzgraefe
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.