stonedb icon indicating copy to clipboard operation
stonedb copied to clipboard

bug: delete return wrong response

Open hustjieke opened this issue 3 years ago • 1 comments
trafficstars

Describe the problem

mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| t              |
+----------------+
1 row in set (0.00 sec)

mysql> delete  from t;
Query OK, 0 rows affected (0.05 sec)

mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| t              |
+----------------+
1 row in set (0.00 sec)

mysql> select * from t;
Empty set (0.01 sec)

mysql> desc t;
+-------+---------+------+-----+---------+-------+
| Field | Type    | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| a     | int(11) | NO   | PRI | NULL    |       |
| b     | int(11) | YES  |     | NULL    |       |
+-------+---------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> insert into t values(1,1),(2,2);
Query OK, 2 rows affected (0.01 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> delete  from t;
ERROR 1031 (HY000): Table storage engine for 't' doesn't have this option

Expected behavior

No response

How To Reproduce

No response

Environment

No response

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

  • [x] Yes, I will!

hustjieke avatar Aug 02 '22 02:08 hustjieke

well, the table delete function is being supported, details for the feature #344. now could we close this issue? @hustjieke

swoapri avatar Aug 10 '22 03:08 swoapri