ZF-11367: Untrue statements on MySQL PS support

Description

Manual reads:

"For example, all SQL statements run by Zend_Db are prepared, then executed. However, some database features are incompatible with prepared statements. DDL statements like CREATE and ALTER cannot be prepared in MySQL. Also, SQL statements don't benefit from the » MySQL Query Cache, prior to MySQL 5.1.17.", http://framework.zend.com/manual/en/…

MySQL 4.1 manual states on CREATE:

"The following SQL statements can be used as prepared statements: CREATE TABLE, DELETE, DO, INSERT, REPLACE, SELECT, SET, UPDATE, and most SHOW statements. Other statements are not yet supported.", http://dev.mysql.com/doc/refman/…

And, the MySQL manual of a reasonable recent MySQL 5.5 states about PS:

"The following SQL statements can be used as prepared statements:

CALL CREATE TABLE DELETE DO INSERT REPLACE SELECT SET UPDATE ANALYZE TABLE OPTIMIZE TABLE REPAIR TABLE CACHE INDEX CHANGE MASTER CHECKSUM {TABLE | TABLES} {CREATE | RENAME | DROP} DATABASE {CREATE | RENAME | DROP} USER FLUSH {TABLE | TABLES | TABLES WITH READ LOCK | HOSTS | PRIVILEGES | LOGS | STATUS | MASTER | SLAVE | DES_KEY_FILE | USER_RESOURCES} GRANT REVOKE KILL LOAD INDEX INTO CACHE RESET {MASTER | SLAVE | QUERY CACHE} SHOW BINLOG EVENTS SHOW CREATE {PROCEDURE | FUNCTION | EVENT | TABLE | VIEW} SHOW {AUTHORS | CONTRIBUTORS | WARNINGS | ERRORS} SHOW {MASTER | BINARY} LOGS SHOW {MASTER | SLAVE} STATUS SLAVE {START | STOP} INSTALL PLUGIN UNINSTALL PLUGIN

Other statements are not yet supported in MySQL 5.5. ", http://dev.mysql.com/doc/refman/…

Thus, its plain wrong to claim that MySQL can't prepare DDL statements in general.

Comments

No comments to display