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

Evaluation of two "!" operators depends on space in beetween

Details

    Description

      The following expressions don't have the expected result (do not ignore the spaces):

       
      		 
      MariaDB [(none)]> select (! !0) = (!!0), (! !1) = (!!1);
      		 
      +----------------+----------------+
      		 
      | (! !0) = (!!0) | (! !1) = (!!1) |
      		 
      +----------------+----------------+
      		 
      |              0 |              0 |
      		 
      +----------------+----------------+
      		 
      1 row in set (0.00 sec)
      		 
       

      I would expect that the results are both 1. I would expect that the calculation does not depend on existance of spaces between ! and !.

      Changing sql_mode does not change behaviour (HIGH_NOT_PRECEDENCE).

      On a MySQL 4.1 server the result of that query is all 1.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          elenst Elena Stepanova added a comment -

          Thanks for the report.

          Despite it's an upstream bug (https://bugs.mysql.com/bug.php?id=55477), I'm not decreasing the priority since it's been in Verified state for almost 5 years.

          elenst Elena Stepanova added a comment - Thanks for the report. Despite it's an upstream bug ( https://bugs.mysql.com/bug.php?id=55477 ), I'm not decreasing the priority since it's been in Verified state for almost 5 years.
          sanja Oleksandr Byelkin added a comment - - edited 

          select ((0 <> 0) = (not(0))) AS `(! !0) = (!!0)`,((1 <> 0) = (not(1))) AS `(! !1) = (!!1)`

          sanja Oleksandr Byelkin added a comment - - edited select ((0 <> 0) = ( not (0))) AS `(! !0) = (!!0)`,((1 <> 0) = ( not (1))) AS `(! !1) = (!!1)`
          yablacky L. Schwarz added a comment - - edited

          Guess which one is the correct result:

           
          		 
          MariaDB [(none)]> select ! !0, !! 0;
          		 
          +------+------+
          		 
          | ! !0 | !! 0 |
          		 
          +------+------+
          		 
          |    0 |    1 |
          		 
          +------+------+
          		 
          1 row in set (0.00 sec)
          		 
           

          Frustrating.

          yablacky L. Schwarz added a comment - - edited Guess which one is the correct result:   MariaDB [(none)]> select ! !0, !! 0; + ------+------+ | ! !0 | !! 0 | + ------+------+ | 0 | 1 | + ------+------+ 1 row in set (0.00 sec)   Frustrating.
          serg Sergei Golubchik added a comment -

          bar, could you review it, please?

          http://lists.askmonty.org/pipermail/commits/2016-June/009443.html

          serg Sergei Golubchik added a comment - bar , could you review it, please? http://lists.askmonty.org/pipermail/commits/2016-June/009443.html
          bar Alexander Barkov added a comment -

          Comments sent by IRC.

          bar Alexander Barkov added a comment - Comments sent by IRC.

          People

            serg Sergei Golubchik
            yablacky L. Schwarz
            Votes:
            0 Vote for this issue
            Watchers:
            6 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.