Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
None
-
None
Description
Build tested
engine: 678bd6c91e22c72f57462f05a16dd8fea68a0db4
server: 34ad833c6a39f169c4a42f52338258ea563bc263
buildNo: 6098
MTR test case: columnstore/autopilot.mcs4002_autopilot_large_insert.test
insert into lineitem values
|
(10,128449,3474,3,27,39890.88,0.06,0.07,'A','F','1994-01-16','1993-11-22','1994-01-23','DELIVER IN PERSON','SHIP','nal foxes wake.'),
|
(10,128449,3474,3,27,39890.88,0.06,0.07,'A','F','1994-01-16','1993-11-22','1994-01-23','DELIVER IN PERSON','SHIP','nal foxes wake.'),
|
(10,128449,3474,3,27,39890.88,0.06,0.07,'A','F','1994-01-16','1993-11-22','1994-01-23','DELIVER IN PERSON','SHIP','nal foxes wake.'),
|
.
|
.
|
.
|
(10,128449,3474,3,27,39890.88,0.06,0.07,'A','F','1994-01-16','1993-11-22','1994-01-23','DELIVER IN PERSON','SHIP','nal foxes wake.'),(10,128449,3474,3,27,39890.88,0.06,0.07,'A','F','1994-01-16','1993-11-22','1994-01-23','DELIVER IN PERSON','SHIP','nal foxes wake.');
|
Query OK, 7300 rows affected (0.297 sec)
|
Records: 7300 Duplicates: 0 Warnings: 0
|
|
|
MariaDB [mytest]> select count(*) from lineitem;
|
+----------+
|
| count(*) |
|
+----------+
|
| 0 |
|
+----------+
|
1 row in set (0.023 sec)
|
MTR test case: columnstore/autopilot.mcs4008_autopilot_sanity_test.test
MariaDB [mytest]> set columnstore_use_import_for_batchinsert=0;
|
Query OK, 0 rows affected (0.000 sec)
|
|
|
MariaDB [mytest]> LOAD DATA INFILE '/data/qa/source/dbt3/1m/orders.tbl' INTO TABLE orders FIELDS TERMINATED BY '|';
|
Query OK, 1500 rows affected (0.199 sec)
|
Records: 1500 Deleted: 0 Skipped: 0 Warnings: 0
|
|
|
MariaDB [mytest]> select count(*) from orders;
|
+----------+
|
| count(*) |
|
+----------+
|
| 0 |
|
+----------+
|
1 row in set (0.023 sec)
|
LDI works fine when columnstore_use_import_for_batchinsert=1.