[MCOL-1565] Join DML Error Created: 2018-07-17  Updated: 2021-02-21  Resolved: 2021-02-21

Status: Closed
Project: MariaDB ColumnStore
Component/s: DMLProc
Affects Version/s: 1.1.4
Fix Version/s: 5.5.1

Type: Bug Priority: Major
Reporter: ssauravy Assignee: Unassigned
Resolution: Cannot Reproduce Votes: 1
Labels: None
Environment:

Centos 6.9



 Description   

Hi.~

use mysql;
/Single Table DML/
select * from test.t1; (O)
insert into test.t1 values(1,'AAA'); (O)
update test.t1 a set a.nm='AAA' where a.id=1; (O)
delete from test.t1 a where a.id=1; (O)

/Join DML/
select a., b. from test.t1 a inner join test.t2 b on b.id=a.id where b.id=1; (O)
insert into test.t2 (id,nm) select id,nm from test.t1 where id=1; (X)
ERROR 1815 (HY000): Internal error: load failed. The detailed error information is listed in err.log.
update test.t1 a join test.t2 b on b.id=a.id set a.nm='XFF' where b.id=1; (O)
delete a from test.t1 as a join test.t2 as b on b.id=a.id where b.id=1; (X)
ERROR 1815 (HY000): Internal error: IDB-2006: 'mysql.t1' does not exist in Columnstore.



 Comments   
Comment by ssauravy [ 2018-07-18 ]

Share additional test results.
Within the primary database you access
An error occurs when the delete join process includes a limit clause.

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LIMIT 1' at line 10

Generated at Thu Feb 08 02:29:42 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.