#41 ALTER TABLE commands not terminated with semicolon

[Anonymous]

When I use the "Sql script->Standard Sql" module to
dump a script to disk or to rebuild the schema in the
jdbc DB, MySQL gives me syntax errors.

The ALTER TABLE commands in the generated SQL (for
createing the indices) do not end with a semicolon (;).
Shouldn't these commands end with a semicolon?

The errors disappear if I terminate the ALTER TABLE
commands with a semicolon.

-Randall Rickert
randall@rickert-digital.com

[Nobody/Anonymous]

Logged In: NO

Also, turning off index generation for the SQL module
doesn't quite work correctly. I turned off index generation
as a temporary workaround to the ALTER TABLE problem, which
gets rid of the errors for most of the tables, but I still
get the error for some tables because ALTER TABLE commands
are still being created for any indexed fields that are of
type VARCHAR or TEXT.

-Randall Rickert