Skip to content

bug: ERROR 1105 (HY000): Parallel worker run failed. #1145

@shangyanwen

Description

@shangyanwen

Have you 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!

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

Status

Todo

Relationships

None yet

Development

No branches or pull requests

Issue actions