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

Accept=1 may show incorrect value for NULL column in CONNECT TBL

    Details

      Description

      Column 'm' should have null in last 3 rows

      CREATE TABLE q (
        id INT NOT NULL
      ) ENGINE=CONNECT TABLE_TYPE=CSV;
      Query OK, 0 rows affected, 1 warning (0.02 sec)
      Warning (Code 1105): No file name. Table will use q.csv
       
      INSERT INTO q VALUES(1),(2),(3);
      Query OK, 3 rows affected (0.00 sec)
      Records: 3  Duplicates: 0  Warnings: 0
       
      CREATE TABLE w (
        id INT NOT NULL, 
        m char (10)
      ) ENGINE=Innodb;
      Query OK, 0 rows affected (0.12 sec)
       
      INSERT INTO w VALUES(1,'a'),(2,'b'),(3,'c');
      Query OK, 3 rows affected (0.01 sec)
      Records: 3  Duplicates: 0  Warnings: 0
       
      create table rt1(
      id int not null,
      m char(10)
      )engine=connect  table_type= TBL table_list='q,w,q', option_list='Accept=1';
      Query OK, 0 rows affected (0.02 sec)
       
      select * from rt1;
      +----+------+
      | id | m    |
      +----+------+
      |  1 |      |
      |  2 |      |
      |  3 |      |
      |  1 | a    |
      |  2 | b    |
      |  3 | c    |
      |  1 | c    |
      |  2 | c    |
      |  3 | c    |
      +----+------+
      9 rows in set (0.00 sec)
      

        Attachments

          Activity

            People

            • Assignee:
              bertrandop Olivier Bertrand
              Reporter:
              alice Alice Sherepa
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: