prepared statement for MyISAM tables fail in replication
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL patches by Codership |
Confirmed
|
Low
|
Unassigned |
Bug Description
Server side prepared statements for tables of MyISAM engine, and myisam replication enabled by wsrep_replicate
120823 2:39:09 [ERROR] Slave SQL: Error 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?, ?, ?)' at line 1' on query. Default database: 'test'. Query: 'INSERT INTO image_sound (ID, my_element1, my_picture) VALUES (?, ?, ?)', Error_code: 1064
120823 2:39:09 [Warning] WSREP: RBR event 1 Query apply warning: 1, 47987
120823 2:39:09 [Warning] WSREP: Ignoring error for TO isolated action: source: e71b252a-
Positional parameters are not spelled out in the replication.
Server side PS is needed to reproduce, issue confirmed with python/oursql test