How can I Disable PREPARED-STATEMENT for SELECT statement?

EnterpriseDB / mysql_fdw

PostgreSQL foreign data wrapper for MySQL

Other

521 stars 160 forks source link

How can I Disable PREPARED-STATEMENT for SELECT statement? #292

Open thevijayshekhawat opened 4 months ago

thevijayshekhawat commented 4 months ago

Hi I am trying to use MySQL FDW to query data on the StarRocks cluster which supports MySQL protocol but does not support the use of PREPARED-STATEMENT, is there a way to disable the use of PREPARED-STATEMENT?

surajkharage19 commented 4 months ago

Hi @thevijayshekhawat,

Unfortunately, there is no way to disable prepared statements in mysql_fdw. All the queries from mysql_fdw to MySQL server are executed as prepared statements only.