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

Query returns different results using table vs view

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 5.5, 10.0, 10.1, 10.2, 10.3
    • 10.4
    • None
    • None

    Description

      CREATE TABLE t1 (pk int, t2 time);
      INSERT INTO t1 VALUES (95,'11:58:30'),(104,'16:21:16');
       
      CREATE VIEW v1 AS select * from t1;
       
      SELECT * FROM  v1 WHERE (v1.pk < v1.t2);
      SELECT * FROM  t1 WHERE (t1.pk < t1.t2);
      

      10.3 4f410473ed3609636c5912

      MariaDB [test1]> SELECT * FROM  v1 WHERE (v1.pk < v1.t2);
      +------+----------+
      | pk   | t2       |
      +------+----------+
      |  104 | 16:21:16 |
      +------+----------+
      1 row in set, 1 warning (0.00 sec)
      Warning (Code 1292): Incorrect datetime value: '95' for column 'pk' at row 1
       
      MariaDB [test1]> SELECT * FROM  t1 WHERE (t1.pk < t1.t2);
      +------+----------+
      | pk   | t2       |
      +------+----------+
      |   95 | 11:58:30 |
      |  104 | 16:21:16 |
      +------+----------+
      2 rows in set, 1 warning (0.01 sec)
      Warning (Code 1292): Incorrect datetime value: '95' for column 'pk' at row 1
      
      

      Attachments

        Activity

          People

            sanja Oleksandr Byelkin
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.