Issues

ZF-11367: Untrue statements on MySQL PS support

Issue Type: Docs: Problem Created: 2011-05-12T08:36:45.000+0000 Last Updated: 2011-05-12T08:38:09.000+0000 Status: Open Fix version(s): Reporter: Ulf Wendel (nixnutz) Assignee: Ralph Schindler (ralph) Tags: - Zend_Db

Related issues: Attachments:

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

Have you found an issue?

See the Overview section for more details.

Copyright

© 2006-2016 by Zend, a Rogue Wave Company. Made with by awesome contributors.

This website is built using zend-expressive and it runs on PHP 7.

Contacts