MySQL Bugs: #28437: Query Builder missing tinytext columns

Bug #28437	Query Builder missing tinytext columns
Submitted:	15 May 2007 8:14	Modified:	14 Jun 2007 7:14
Reporter:	Hendrik Wiese	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / NET	Severity:	S1 (Critical)
Version:	5.1	OS:	Windows (VS.NET 2005)
Assigned to:		CPU Architecture:	Any
Tags:	Query Builder

Description:
The Query Builder of the MySQL Connector/NET Tools for Visual Studio .NET 2005 is missing columns. It shows all columns of a table until it reaches a column declared as tinytext (might also appear with other declarations, I didn't test it). All columns, the one declared as tinytext and the following, are sort of hidden. They are available so far, but not shown in the Query Builder.

This one is critical, because it causes the assistent to create an incomplete typed dataset. No properties are generated for the "hidden" columns. 

How to repeat:
Create a table with several columns. One of them (somewhere in the middle or at the beginning of the table, not at the end) should be declared as "tinytext". Now create a typed dataset within Visual Studio .NET 2005 and add a table adapter. Use the Query Builder to create a query and add the new table to the assistent.

You should see that the tinytext column and all other columns following this one are missing/hidden.

Hi Hendrik and thanks for your report. Verified as described with 
 - MySQL server 5.0.38BK on WinXP Pro SP2 localhost
 - c/NET 5.1 GA, NET fw 2.0
 - VS2005Pro SP1

C:\mysql507\bin>mysql -uroot test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.38-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create table bug28437 (
    -> Id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    -> TestCol1 VARCHAR(25),
    -> TestCol2 TINYTEXT,
    -> TestCol3 INT,
    -> TestCol4 DATE);
Query OK, 0 rows affected (0.14 sec)

QB failing

Attachment: 28437.jpg (image/jpeg, text), 34.30 KiB.

Strangly enough, drag&drop works

Attachment: 28437-1.jpg (image/jpeg, text), 32.97 KiB.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/28542

A note has been added to the 5.1.2 changelog.