MySQL Bugs: #26530: Index Column Length dialog accepts negativ Integers

Bug #26530	Index Column Length dialog accepts negativ Integers
Submitted:	21 Feb 2007 15:39	Modified:	26 Feb 2007 8:48
Reporter:	Heinz Schweitzer (Gold Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.2.9	OS:	Windows (XP)
Assigned to:	Mike Lischke	CPU Architecture:	Any
Tags:	qc

Description:
Index Column Length dialog accepts negativ Integers

It also accepts NaNs and floats but seems to ignore them.

MySQL Administrator 1.2.9

MySQL Server Information
--------------------------------------------------------------------------------
Connected to MySQL Server Instance
  Username:                root
  Hostname:                localhost
  Port:                    3306
--------------------------------------------------------------------------------
Server Information
  MySQL Version:           MySQL 5.0.27-community-nt via TCP/IP
  Network Name:            localhost
  IP:                      127.0.0.1
--------------------------------------------------------------------------------
Client Information
  Version:                 MySQL Client Version 5.1.11
  Network Name:            xxxxxxxxxxx
  IP:                      xxxxxxxxxxx
  Operating System:        Windows XP
  Hardware:                2x Intel(R) Core(TM)2 CPU         T7200  @ 2.00GHz, 2.0 GB RAM

How to repeat:
Prerequisit
	Have a table with a varchar field.
	

Start English or German MySQL Administrator 1.2.9
Open Catalogs
Select from Catalogs a database 

In the right pane activate the 'Schema Tables' tab
Select a table with a varchar field,like in this case t1
Say Edit Table.

In the table editor create a new index like Index_2 using the
the varchar field like 'c';

Now start to set  the 'Index Column Lenght' like in
screen shot i1.

A dialog pops up like in screen shot i2,
In that dialog enter a negativ Integer.
Say OK and you will see the negativ number 
in the sql statement to be excuted, like in screen
shot i3.

If you carry on this will produce an error dialog.

i1

Attachment: ScreenHunter_001.jpg (image/pjpeg, text), 162.91 KiB.

i2

Attachment: ScreenHunter_002.jpg (image/pjpeg, text), 167.41 KiB.

i3

Attachment: ScreenHunter_003.jpg (image/pjpeg, text), 167.27 KiB.

Thank you for the bug.

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 bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html