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

            bertrandop Olivier Bertrand
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.