Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.22
-
None
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) |