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) |
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
commands below show that after insert all rows in ZIP CSV table(CONNECT engine) disappear, zip file is also rewritten.
{code:sql} -------------- CREATE TABLE `c1` ( `n1` varchar(255) NOT NULL, `n2` varchar(255) NOT NULL ) ENGINE=CONNECT `table_type`=CSV `file_name`='/home/alice/mariadb-environ-framework-master/_depot/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) {code} |
commands below show that after insert all rows in ZIP CSV table(CONNECT engine) disappear, zip file is also rewritten.
{code:sql} -------------- 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) {code} |
| Fix Version/s | 10.1 [ 16100 ] | |
| Assignee | Olivier Bertrand [ bertrandop ] |
| Fix Version/s | N/A [ 14700 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Resolution | Not a Bug [ 6 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Resolution | Not a Bug [ 6 ] | |
| Status | Closed [ 6 ] | Stalled [ 10000 ] |
| issue.field.resolutiondate | 2017-05-08 17:03:47.0 | 2017-05-08 17:03:47.49 |
| Fix Version/s | 10.0.31 [ 22501 ] | |
| Fix Version/s | 10.1.24 [ 22541 ] | |
| Fix Version/s | N/A [ 14700 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 80490 ] | MariaDB v4 [ 152025 ] |