Bug #7415 Mistake in ALTER table

• Submitted: 19 Dec 2004 15:46
• Modified: 23 Dec 2004 15:41
• Reporter: Dmitriy Sirant
• Status: Duplicate
• Category: MySQL Administrator
• Severity: S3 (Non-critical)
• Version: 1.18
• OS: Windows (Windows)
• CPU Architecture: Any

[19 Dec 2004 15:46] Dmitriy Sirant

Description:
Mistake in SQL query, need "COLLATE" but quered "OLLATE"

How to repeat:
When want change collate or character set of table have:

ALTER TABLE `statistic`.`id` OLLATE Default;

Suggested fix:
Change ALTER TABLE `statistic`.`id` OLLATE Default;
to ALTER TABLE `statistic`.`id` COLLATE Default;

[23 Dec 2004 15:41] MySQL Verification Team

Duplicate for #6571