| Bug #13648 | Unrecognized DDL SQL statement | ||
|---|---|---|---|
| Submitted: | 30 Sep 2005 11:16 | Modified: | 3 Oct 2005 13:38 |
| Reporter: | c coder | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Administrator | Severity: | S2 (Serious) |
| Version: | 1.1.2 | OS: | Windows (Windows XP SP 2) |
| Assigned to: | Vladimir Kolesnikov | CPU Architecture: | Any |
[2 Oct 2005 8:35]
Valeriy Kravchuk
Thank you for a bug report. Verified on MySQL 4.1.14 using MySQL Administrator 1.1.3 and the steps presented. This warning is incorrect - index should be created during restore.
[3 Oct 2005 9:54]
Vladimir Kolesnikov
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant product(s).
[3 Oct 2005 13:38]
Vladimir Kolesnikov
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.
If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information
about accessing the source trees is available at
http://www.mysql.com/doc/en/Installing_source_tree.html
[3 Oct 2005 13:39]
Vladimir Kolesnikov
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.
If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information
about accessing the source trees is available at
http://www.mysql.com/doc/en/Installing_source_tree.html
Description: MySQL Administrator couold not recognize DDL SQL statement from script while doing database restore. Same SQL command was recognized and executed by MySQL Query Browser v1.1.14 used in conjuction with MySQL Administrator. DDL statement was of form: CREATE INDEX index_name USING BTREE ON table_name (column_name_of_type_text(10)); Bug is submitted as it is suggested by MySQL Administrator popup message. How to repeat: 1. create file blabla.sql with following content: CREATE TABLE cr ( id integer NOT NULL AUTO_INCREMENT, dp text NOT NULL, PRIMARY KEY (`id`) ); CREATE INDEX ind_cr_dp USING BTREE ON cr (dp(10)); 2. open mysql admin and create new schema named 'blabla'. 3. click 'Restore' button, click 'Open backup file' and select 'blabla.sql' 4. from 'Target Schema' drop down list select 'blabla' 5. click 'Start Restore' 6. Warning message appears: Warning: Do not know how to handle this statement at line 6: CREATE INDEX ind_cr_dp USING BTREE ON cr (dp(10)); Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized. 7. click menu 'Tools'->'MySQL Query Browser' 8. set 'blabla' schema as default 9. paste line CREATE INDEX ind_cr_dp USING BTREE ON cr (dp(10)); into query field 10. click 'Execute' 11. open 'cr' table in 'blabla' schema in tree view on the right 12. select from popup menu 'Edit table' 13. note in 'indices' list that 'ind_cr_dp' index is created as requested.