You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Please confirm if bug report does NOT exists already ?
I confirm there is no existing issue for this
Describe the problem
SELECT IF(@rowno !=a.taxis_no, @rankno :=1, @rankno := @rankno +1) AS"rowNos",
IFNULL(a.out_amount/1, '-') out_amount
FROM (SELECT a.*FROM (SELECTa.currency_id, a.out_amount, d.taxis_noFROM (SELECTb.CURRENCY_ID, a.account_id, 0 out_amount
FROM C1AM_ACCT_DAY a, C1MD_BANK_ACCT b
WHEREa.account_id=b.ROW_IDUNION ALLSELECTb.CURRENCY_ID,
a.account_id,
sum(a.out_amount) out_amount
FROM C1AM_BANK_LIST a, C1MD_BANK_ACCT b
WHEREa.account_id=b.ROW_IDGROUP BYa.account_id, b.CURRENCY_ID) a
JOIN C1MD_BANK_ACCT b
onb.row_id=a.account_idJOIN C1MD_COMPANY c
onc.row_id=b.company_idJOIN C1CD_CURRENCY d
ONa.currency_id=d.row_idWHERE1=1ANDc.row_idIN (SELECTt1.row_idFROM C1MD_COMPANY t1, C1MD_COMPANY t2
WHEREt1.sys_id=t2.sys_id)) a) a
ERROR 2013 (HY000): Lost connection to MySQL server during query
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: 1f43e44
Last commit time: Date: Wed May 31 17:34:21 2023 +0800
Build time: Date: Thu Jun 1 07:20:38 UTC 2023
Are you interested in submitting a PR to solve the problem?
Yes, I will!
The text was updated successfully, but these errors were encountered:
Have you read the Contributing Guidelines on issues?
Please confirm if bug report does NOT exists already ?
Describe the problem
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: 1f43e44
Last commit time: Date: Wed May 31 17:34:21 2023 +0800
Build time: Date: Thu Jun 1 07:20:38 UTC 2023
Are you interested in submitting a PR to solve the problem?
The text was updated successfully, but these errors were encountered: