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:Microsoft Windows (VS.NET 2005)
Assigned to: CPU Architecture:Any
Tags: Query Builder

[15 May 2007 8:14] Hendrik Wiese
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.
[22 May 2007 20:24] Tonci Grgin
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)
[22 May 2007 20:25] Tonci Grgin
QB failing

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

[22 May 2007 20:26] Tonci Grgin
Strangly enough, drag&drop works

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

[11 Jun 2007 22:27] Bugs System
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
[14 Jun 2007 7:14] MC Brown
A note has been added to the 5.1.2 changelog.