|
Replies:
4
-
Pages:
1
-
Last Post:
Jan 23, 2012 10:11 AM
by: ArielTK
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Toad for MySQL 6.0.1 GA Release
Posted:
Sep 30, 2011 3:19 PM
|
|
|
Quest is pleased to announce the general release of Toad for MySQL 6.0.1 patch
release update.
Two specific bugs are fixed in this release.
• It was impossible to use the compare & sync functionality.
• It was impossible to create the schema objects needed to do debugging.
Get it now at http://www.toadformysql.com/!
|
|
|
Posts:
3
Registered:
10/26/10
|
|
|
|
Re: Toad for MySQL 6.0.1 GA Release
Posted:
Oct 10, 2011 8:30 AM
in response to: Mauritz
|
|
|
Hi,
there's a bug in ToadForMysql 6.0.1:
If you have an tinyint-field which ist defined with "tinyint(1)" Toad shows an checkbox-field. That's wrong. Quote from mysql.com:
The display width does not constrain the range of values that can be stored in the column, nor the number of digits that will be displayed for values having a width exceeding that specified for the column.
Whenused in conjunction with the optional extension attribute ZEROFILL, thedefault padding of spaces is replaced with zeros. For example, for a column declared as INT(5) ZEROFILL, a value of 4 is retrieved as 00004. Note that if you store larger values than the display width in an integer column, you may experience problems when MySQL generates temporary tables for some complicated joins, because in these cases MySQL trusts that the data did fit into the original column width.
Edit: You can have (for example) the number 6 in a tinyint(1)-field, but this number wouldn't be displayed because the field displays itself as a checkbox in Toad.
Hope you can fix this. Thanks!
Message was edited by: Pascal J.
|
|
|
Posts:
40
Registered:
1/27/11
|
|
|
|
Re: Toad for MySQL 6.0.1 GA Release
Posted:
Oct 10, 2011 8:52 AM
in response to: Pascal J.
|
|
|
But does ZEROFILL affect tinyint(1), which before MySQL 5.0.3 was interpreted as BIT?
http://stormysan.com/2011/02/mysql-integer-lengths/
|
|
|
Posts:
1
Registered:
11/22/11
|
|
|
Posts:
1
Registered:
1/23/12
|
|
|
|
Re: Toad for MySQL 6.0.1 GA Release
Posted:
Jan 23, 2012 10:11 AM
in response to: Steff.Sullivan
|
|
|
I have the same problem.
I have a field type: tinyint(1) and I see it as a checkbox.
how can I see it as numeric field?
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
