Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Queries involving multiple tables will fail in a cluster environment #1538

Closed
dracoooooo opened this issue Jun 15, 2024 · 1 comment
Closed
Labels
bug Something isn't working

Comments

@dracoooooo
Copy link
Contributor

dracoooooo commented Jun 15, 2024

Describe this problem

Queries involving multiple tables fail to find table in a cluster environment.

Server version

commit 0970b03

Steps to reproduce

CREATE TABLE `t1` (`timestamp` timestamp NOT NULL, `value` int, `name` string, timestamp KEY (timestamp)) ENGINE=Analytic WITH(  enable_ttl='false' );
Query OK, 0 rows affected (0.05 sec)

CREATE TABLE `t2` (`timestamp` timestamp NOT NULL, `value` int, `name` string, timestamp KEY (timestamp)) ENGINE=Analytic WITH(  enable_ttl='false' );
Query OK, 0 rows affected (0.04 sec)

CREATE TABLE `t3` ( `timestamp` timestamp NOT NULL, `value` int, `name` string, timestamp KEY (timestamp)) ENGINE=Analytic WITH(  enable_ttl='false' );
Query OK, 0 rows affected (0.06 sec)

SELECT * FROM `t1`, `t2`, `t3`;
ERROR 1105 (HY000): Failed to handle sql:SELECT * FROM `t1`, `t2`, `t3`, err:Rpc error, code:500, message:Failed to create plan, err:Failed to create plan, err:Failed to generate datafusion plan, err:Execution error: Table is not found, "table:t3"

Expected behavior

No error

Additional Information

Use the same config as the integration test.

Cannot be 100% replicated, possibly due to the randomness of shard allocation?

@dracoooooo dracoooooo added the bug Something isn't working label Jun 15, 2024
@jiacai2050
Copy link
Contributor

Cannot be 100% replicated, possibly due to the randomness of shard allocation?

Yes, currently tables included in one query should be on same instance(an instance may have many shards).

@jiacai2050 jiacai2050 closed this as not planned Won't fix, can't repro, duplicate, stale Nov 25, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants