bug: bad dpn index when deleting rows

[ZhengLin-Li]

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

I am supporting the StoneDB in SQLacer. When deleting rows, SQLancer got: assert failed on i < m_idx.size() at tianmu_attr.h:387, msg: [bad dpn index 0/0]

FUll log:

Expected behavior

Delete successfully.

How To Reproduce

CREATE TABLE t1(c0 INT);
INSERT INTO t1(c0) VALUES (1), (2);
DELETE FROM t1 ORDER BY c0;

Environment

Docker Image stonedb:v1.0.3

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

• Yes, I will!

[chenshengjiang]

In my docker image stoneatom/stonedb:v1.0.3, everything is fine.

[haitaoguan]

./mysqld  Ver 5.7.36-StoneDB-v1.0.4 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: 7321c63
        Last commit time: Date:   Wed Jul 5 17:01:29 2023 +0800
        Build time: Date: Thu Jul  6 01:48:21 UTC 2023

[ZhengLin-Li]

hi @chenshengjiang @haitaoguan @RingsC , thanks for follow up.

I run it again on stoneatom/stonedb:v1.0.4 and reproduce the same error:

All we need to do to reproduce this error is run those commands very fast. For example: just copy and paste those three commands and run them.

[loloxwg]

• commit f56d76b: bugfix(tianmu): fix aggregation result incorrect when no record bug: query result not correct #1942 (bugfix(tianmu): fix aggregation result incorrect when no record #1942 #1951)
• branch: dev5.7
  Cannot be reproduced after compilation