Bug #19361 When creating table, view, etc., last 1 or 2 characters ignored
Submitted: 26 Apr 2006 5:27 Modified: 16 Nov 2006 12:20
Reporter: Yuri Sprague Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.1.20 OS:Windows (Windows)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: Source Editors

[26 Apr 2006 5:27] Yuri Sprague 
Description:
This also occurred in 1.1.19.

When I use a script tab for creation of an InnoDB table or view, the last one or two characters in the statement are ignored.  It always occurs with table creation but not always with view creation (!?!?).

How to repeat:
Create a test table:

drop table if exists tbl_Test;

create table tbl_Test (
	nTestID smallint unsigned not null auto_increment,
	sTestText text not null,
	constraint `pk_tbl_Test_TestID` primary key (nTestID)) type=innodb;

The error message, "Unknown table engine innod", is given.
[26 Apr 2006 8:24] Valeriy Kravchuk 
Verified just as described on XP. It is a bug.
[16 Nov 2006 12:20] Mike Lischke 
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/