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

bug: ERROR 1105 (HY000): assert failed on cur_pack != nullptr at tianmu_attr.cpp:427, msg: [Pack ptr is null] #1912

Closed
3 tasks done
haitaoguan opened this issue Jun 28, 2023 · 1 comment · Fixed by #1958
Closed
3 tasks done
Assignees
Labels
A-bug Something isn't working prio: high High priority

Comments

@haitaoguan
Copy link
Collaborator

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 IFNULL(b.CURRENCY_NAME, '合计(人民币)') CURRENCY_NAME
    ->   FROM v_c1am_busi_type a
    ->   LEFT JOIN (select a.INNER_CODE, a.CURRENCY_ID, d.CURRENCY_NAME
    ->                FROM (SELECT a.INNER_CODE, b.CURRENCY_ID
    ->                        FROM v_c1am_busi_type a
    ->                       CROSS JOIN (SELECT a.TENANT_ID, b.CURRENCY_ID
    ->                                    FROM C1AM_BANK_CLASS a, c1AM_BANK_LIST b
    ->                                   where a.SERIAL_ID = b.ROW_ID
    ->                                     and F_DATE_FORMAT(b.TRADE_DATE) BETWEEN
    ->                                         DATE_FORMAT('2023-06-06', '%Y-%m-%d') AND
    ->                                         DATE_FORMAT('2023-06-06', '%Y-%m-%d')
    ->                                   GROUP BY a.TENANT_ID, b.CURRENCY_ID) b
    ->                       WHERE a.CLASS_ID = 3000000000233027) a
    ->                LEFT JOIN C1CD_CURRENCY d
    ->                  ON a.CURRENCY_ID = d.ROW_ID) b
    ->     ON a.INNER_CODE =
    ->   LEFT(b.INNER_CODE, LENGTH(a.INNER_CODE))
    ->  GROUP BY b.CURRENCY_NAME;
ERROR 1105 (HY000): assert failed on cur_pack != nullptr at tianmu_attr.cpp:427, msg: [Pack ptr is null]

Expected behavior

No response

How To Reproduce

No response

Environment

./mysqld Ver 5.7.36-StoneDB-v1.0.1 for Linux on x86_64 (build-)
build information as follow:
Repository address: https://github.com/stoneatom/stonedb.git:stonedb-5.7-dev
Branch name: stonedb-5.7-dev
Last commit ID: a4600c4
Last commit time: Date: Thu Jun 15 21:10:49 2023 +0800
Build time: Date: Tue Jun 27 01:17:55 UTC 2023

Are you interested in submitting a PR to solve the problem?

  • Yes, I will!
@haitaoguan haitaoguan added the A-bug Something isn't working label Jun 28, 2023
@haitaoguan haitaoguan assigned haitaoguan and RingsC and unassigned haitaoguan Jun 28, 2023
@haitaoguan haitaoguan added the prio: high High priority label Jun 28, 2023
@RingsC
Copy link
Contributor

RingsC commented Jul 13, 2023

@Xinqiangxu , pls, check it out.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-bug Something isn't working prio: high High priority
Projects
None yet
3 participants