Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
1.4.2
-
None
-
2020-1
Description
Reported by customer..
Is there a plan to re-implement the 'insert into table select' syntax with the newest release of Columnstore? We utilized this quite often with Columnstore tables in the 1.2.5 and earlier versions.
SQL statement will be in the followup comments with Eng only permissions
MariaDB [assay_archive]> insert into ....
ERROR 1815 (HY000): Internal error: load failed. The detailed error information is listed in err.log.
Select Handler lacks support for some vtable features, including:
Cartesian JOIN
Non-Equi JOIN
INSERT .. SELECT
SELECT INTO OUTFILE
nothing in the error logs, this in the debug log
Where the query returned to check the err.log, the log is actually completely empty and the debug.log just states that there is an error.
Jan 20 10:34:35 mdb-cs2 dbcon[578022]: 35.694801 |34|0|0| D 24 CAL0001: Start SQL statement: insert into beef_batch_col_1 select * from beef_batch_2; |assay_archive|
Jan 20 10:34:35 mdb-cs2 ExeMgr[577173]: 35.700284 |2147483682|0|0| D 16 CAL0041: Start SQL statement: select objectid from systable where schema='assay_archive' and tablename='beef_batch_col_1' --tableRID/; ||
Jan 20 10:34:35 mdb-cs2 ExeMgr[577173]: 35.706849 |2147483682|0|0| D 16 CAL0042: End SQL statement
Jan 20 10:34:35 mdb-cs2 dbcon[578022]: 35.893247 |34|0|0| D 24 CAL0001: End SQL statement with error