[MCOL-5557] MariaDB columnstore table join innodb table caused ERROR 1815 (HY000): Internal error: MCS-2058: Unknown Error Created: 2023-08-19  Updated: 2023-11-06

Status: Needs Feedback
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 23.02.4
Fix Version/s: None

Type: Bug Priority: Critical
Reporter: Shai Zambrovski Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

I know that this kind of join is suppose supported, but it doesn't work for me for the next case;

Given the tables:

CREATE TABLE person_cs(
 
    firstName VARCHAR(255),
 
    lastName VARCHAR(255),
 
    address TEXT,
 
    age INT,
 
    stateId INT
 
) ENGINE=ColumnStore;
 
 
 
CREATE TABLE person_inno(
 
    firstName VARCHAR(255),
 
    lastName VARCHAR(255),
 
    address TEXT,
 
    age INT,
 
    stateId INT
 
) engine=InnoDB;
 
 
 
CREATE TABLE states (
 
    id INT NOT NULL,
 
    state TEXT NOT NULL
 
) ENGINE = InnoDB;

person_cs and person_inno are the same entries table (12M) but different engine.

states is lookup innodb table with 50 entries;

So the query:

select count(*), state from person_inno p join states s on p.stateId = s.id where p.age > 31 group by s.state

works great (although it take more then 5 minutes with indexed columns)

once I try:

 select count(*), state from person_cs p join states s on p.stateId = s.id where p.age > 31 group by s.state

it fails with the error:

ERROR 1815 (HY000): Internal error: MCS-2058: Unknown Error

Any idea why?

I worked with MariaDB columnstore as docker with latest version.

 Comments   
Comment by Todd Stoffel (Inactive) [ 2023-08-21 ]

Have you altered the credentials for the default cross engine join user?

Comment by Todd Stoffel (Inactive) [ 2023-08-21 ]

As a side note, you probably want to put an index on any InnoDB column used in a join or filter.

Comment by Shai Zambrovski [ 2023-08-23 ]

I did put index, of course.
By the way, I didn't know about the credentials staff, can your share about it, how to do it?

Comment by Shai Zambrovski [ 2023-08-24 ]

After trying to altered the credentials for the default cross engine join user, it didn't work.

Why this is downgrade to minor? simple query could not be executed, and error message not understood at all...

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