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

Insert command truncates ZIP CSV table

    Details

      Description

      commands below show that after insert all rows in ZIP CSV table(CONNECT engine) disappear, zip file is also rewritten.

      --------------
      CREATE TABLE `c1` (
      	`n1` varchar(255)  NOT NULL,
       	`n2` varchar(255)  NOT NULL
      ) ENGINE=CONNECT  `table_type`=CSV `file_name`='/home/alice/t/d1.zip' sep_char=';' zipped=1
      --------------
      Query OK, 0 rows affected (0.06 sec)
       
      --------------
      select count(*) from c1
      --------------
      +----------+
      | count(*) |
      +----------+
      |      101 |
      +----------+
      1 row in set (0.00 sec)
       
      --------------
      insert into c1 select 1,1
      --------------
      Query OK, 1 row affected (0.00 sec)
      Records: 1  Duplicates: 0  Warnings: 0
       
      --------------
      select count(*) from c1
      --------------
      +----------+
      | count(*) |
      +----------+
      |        1 |
      +----------+
      1 row in set (0.00 sec)
      

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: