bug: query result wrong: SELECT - Githubissues

stoneatom / stonedb

StoneDB is an Open-Source MySQL HTAP and MySQL-Native DataBase for OLTP, Real-Time Analytics, a counterpart of MySQLHeatWave. (https://stonedb.io)

https://stonedb.io/

GNU General Public License v2.0

862 stars 140 forks source link

bug: query result wrong: SELECT #1949

Open zhenglin-charlie-li opened 1 year ago

zhenglin-charlie-li commented 1 year ago

Have you read the Contributing Guidelines on issues?

[X] I have read the Contributing Guidelines on issues.

Please confirm if bug report does NOT exists already ?

[X] I confirm there is no existing issue for this

Describe the problem

The query result does not meet expectation

StoneDB V1.0.4 Result

MySQL 5.7 Result

Expected behavior

No response

How To Reproduce

CREATE TABLE t0(c0 TEXT);
INSERT INTO t0(c0) VALUES (DEFAULT);
DELETE FROM t0;
INSERT INTO t0(c0) VALUES (DEFAULT);

SELECT * FROM t0;

Environment

Docker V1.0.4

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

[ ] Yes, I will!