matrixone icon indicating copy to clipboard operation
matrixone copied to clipboard

[Bug]: prepare update statment error.

Open tianyahui-python opened this issue 3 years ago • 1 comments

Is there an existing issue for the same bug?

  • [X] I have checked the existing issues.

Environment

- Version or commit-id (e.g. v0.1.0 or 8b23a93):
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

create table t1 (str1 varchar(25),str2 char(25));

insert into t1 values('a1','b1'),('a2', 'b2'),('a3', '');

prepare s1 from 'update t1 set str1="xx1" where str2=?'; error msg: ERROR 1105 (HY000): Column 'test_db.t1.PADDR' does not exist

Expected Behavior

prepare s1 from 'update t1 set str1="xx1" where str2=?';

mysql> prepare s1 from 'update t1 set str1="xx1" where str2=?';

Query OK, 0 rows affected (0.02 sec) Statement prepared

Steps to Reproduce

No response

Additional information

No response

tianyahui-python avatar Aug 15 '22 06:08 tianyahui-python

mysql> prepare s4 from 'delete from t2 where time1=?'; ERROR 1105 (HY000): Column 't2.PADDR' does not exist

tianyahui-python avatar Aug 15 '22 06:08 tianyahui-python

截屏2022-10-24 16 50 38

tianyahui-python avatar Oct 24 '22 08:10 tianyahui-python