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

Wrong result for SELECT..WHERE LENGTH(time_column)=8 AND time_column=TIMESTAMP'2001-01-01 10:20:31'

    XMLWordPrintable

Details

    Description

      SET timestamp=UNIX_TIMESTAMP('2001-01-01 01:02:03');
      DROP TABLE IF EXISTS t1;
      CREATE TABLE t1 (a TIME);
      INSERT INTO t1 VALUES ('10:20:31'),('-10:20:31');
      SELECT * FROM t1 WHERE a=TIMESTAMP'2001-01-01 10:20:31';
      SELECT * FROM t1 WHERE LENGTH(a)=8;
      SELECT * FROM t1 WHERE LENGTH(a)=8 AND a=TIMESTAMP'2001-01-01 10:20:31';

      In the above script the first and the second SELECT queries correctly return one row, the third SELECT query returns erroneously no rows.

      Attachments

        Issue Links

          Activity

            People

              bar Alexander Barkov
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.