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 139 forks source link

bug: when execute the prepared statement, mysqld crashed #1877

Open davidshiz opened 1 year ago

davidshiz commented 1 year ago

Have you read the Contributing Guidelines on issues?

Please confirm if bug report does NOT exists already ?

Describe the problem

mysql> prepare stmt from "select * from t1 where a in (select b from t2 where t1.a=t2.c-299)";
Query OK, 0 rows affected (0.00 sec)
Statement prepared

mysql> execute stmt;
+------+
| a    |
+------+
|    3 |
+------+
1 row in set (0.00 sec)

mysql> execute stmt;
ERROR 2013 (HY000): Lost connection to MySQL server during query

Expected behavior

No response

How To Reproduce

No response

Environment

[root@stonedb-test support-files]# /stonedb57/install/bin/mysqld --version
/stonedb57/install/bin/mysqld  Ver 5.7.36-StoneDB-v1.0.1.6b369e5 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: 6b369e5
        Last commit time: Date:   Thu Jun 8 19:16:12 2023 +0800
        Build time: Date: Tue Jun 13 08:31:13 UTC 2023

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

davidshiz commented 1 year ago

only debug version has this problem