appsmith icon indicating copy to clipboard operation
appsmith copied to clipboard
verified publisher icon appsmithorg

[Bug]-[11200]:Unable to use IN or ANY clause with prepared statements turned on for MySQL

Open nidhi-nair opened this issue 3 years ago • 3 comments

Is there an existing issue for this?

  • [X] I have searched the existing issues

Current Behavior

https://discord.com/channels/725602949748752515/760761686549463060/941054952711806976

Steps To Reproduce

Create a select statement using MySQL plugin

Environment

Production

Version

Cloud

nidhi-nair avatar Feb 18 '22 08:02 nidhi-nair

slack conversation: https://theappsmith.slack.com/archives/CGBPVEJ5C/p1647957711673979

rohan-arthur avatar Mar 25 '22 11:03 rohan-arthur

6m usage(pg+mysql): 3500 usage of "IN" and "ANY" is a basic requirement for SQL, so assume 80% reach: 2800

Stats

Stat Values
Reach 2800
Effort (months) 0.5

rohan-arthur avatar Apr 07 '22 11:04 rohan-arthur

Another user reported this issue here: https://community.appsmith.com/t/using-an-array-in-query/1346/8

amelia-c0n avatar Sep 22 '22 17:09 amelia-c0n