Bug #28437 Query Builder missing tinytext columns
Submitted: 15 May 2007 10:14 Modified: 14 Jun 2007 9:14
Reporter: Hendrik Wiese
Status: Closed
Category:Connector/Net Severity:S1 (Critical)
Version:5.1 OS:Microsoft Windows (VS.NET 2005)
Assigned to: Target Version:
Tags: Query Builder

[15 May 2007 10: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 22: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 22:25] Tonci Grgin 
QB failing

Attachment: 28437.jpg (image/jpeg, text), 34.30 KiB.
[22 May 2007 22:26] Tonci Grgin 
Strangly enough, drag&drop works

Attachment: 28437-1.jpg (image/jpeg, text), 32.97 KiB.
[12 Jun 2007 0: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 9:14] MC Brown 
A note has been added to the 5.1.2 changelog.