Details

    Description

      /* init */ CREATE TABLE t(c1 BLOB NOT NULL, c2 TEXT);
      /* init */ INSERT IGNORE INTO t VALUES (NULL, NULL), (NULL, 'abc');
       
      mariadb> UPDATE t SET c2 = 'test' WHERE c1;
      ERROR 1292 (22007): Truncated incorrect DOUBLE value: ''
       
      mariadb> SELECT * FROM t WHERE c1;
      Empty set, 2 warnings (0.00 sec)
       
      mariadb> DELETE FROM t WHERE c1;
      Query OK, 0 rows affected, 2 warnings (0.00 sec)
      

      Only UPDATE statement reports an error, while SELECT and DELETE do not report the error.

      Attachments

        Issue Links

          Activity

            Transition Time In Source Status Execution Times
            Sergei Golubchik made transition -
            Open Confirmed
            2d 1h 14m 1

            People

              sanja Oleksandr Byelkin
              John Jove John Jove
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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