-
-
Notifications
You must be signed in to change notification settings - Fork 142
Open
Labels
Milestone
Description
Have you read the Contributing Guidelines on issues?
- I have read the Contributing Guidelines on issues.
Please confirm if bug report does NOT exists already ?
- I confirm there is no existing issue for this
Describe the problem
mysql> SELECT
-> count(*)
-> FROM
-> (
-> SELECT
-> c.c_id,
-> c.c_d_id,
-> c.c_w_id,
-> c.c_balance c1,
-> (
-> SELECT
-> sum(ol_amount)
-> FROM
-> orders,
-> order_line
-> WHERE
-> OL_W_ID = O_W_ID
-> AND OL_D_ID = O_D_ID
-> AND OL_O_ID = O_ID
-> AND OL_DELIVERY_D IS NOT NULL
-> AND O_W_ID = 1
-> AND O_D_ID = c.C_D_ID
-> AND O_C_ID = c.C_ID
-> ) sm,
-> (
-> SELECT
-> sum(h_amount)
-> from
-> history
-> WHERE
-> H_C_W_ID = 1
-> AND H_C_D_ID = c.C_D_ID
-> AND H_C_ID = c.C_ID
-> ) smh
-> FROM
-> customer c
-> WHERE
-> c.c_w_id = 1
-> ) t
-> WHERE
-> c1 <> sm - smh;
ERROR 1105 (HY000): Parallel worker run failed.Expected behavior
The correct result is queried
How To Reproduce
If you need to repeat the problem, please contact me separately. The generation of data is complicated, and testing tools need to be installed
Environment
mysqld Ver 5.7.36-StoneDB for Linux on x86_64 (build-)
build information as follow:
Repository address: https://github.com/stoneatom/stonedb.git:HEAD
Branch name: HEAD
Last commit ID: b44a51ce8
Last commit time: Date: Fri Dec 2 16:11:06 2022 +0000
Build time: Date: Mon Dec 5 06:12:44 UTC 2022
Are you interested in submitting a PR to solve the problem?
- Yes, I will!
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
Type
Projects
Status
Todo