Bug #43653 Display 'NULL' icon in 'Column Details' tab
Submitted: 14 Mar 2009 14:10 Modified: 16 Apr 2009 18:38
Reporter: Arcadiy Fedushin Email Updates:
Status: No Feedback Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version:1.1.2 Alpha OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[14 Mar 2009 14:10] Arcadiy Fedushin
Description:
'NULL' icon is displayed as Default Value in table grid above but not in 'Column Details' tab below.
So in 'Column Detail' empty defaults look quite similar to NULL, which is not correct.

How to repeat:
1. Open Microsoft Visual Studio 2005 with 'MySQL Visual Studio Plugin' installed,
2. Enter 'Alter table' mode.

Suggested fix:
Display 'NULL' icon in 'Column Details' tab too.
[14 Mar 2009 14:34] Peter Laursen
One more comment from me!

You should tell the server version! I think the problem here is a problem with the returns of SHOW FULL FIELDS.  And thus it is a server problem and not a client problem! And fixed in recent servers.

A link to a 3rd party page (for a product where this also affects): 
http://www.webyog.com/faq/content/10/170/en/problem-with-string-default-__-empty-string-an...
[14 Mar 2009 15:09] Arcadiy Fedushin
Very likely you're right.
I see problem as user, not as a developer, and don't see underlying mechanics.
To repeat the bug, we MUST use Visual Studio's SERVER Explorer.
I connect to MySQL through http://localhost:3306 .
[14 Mar 2009 15:13] Arcadiy Fedushin
Well, understood, excuse me.
MySQL is Server, and VS & its plugin are Client.
[14 Mar 2009 16:53] Peter Laursen
You should still tell your server version, I think!

If the server does not return the information, no client can display it!
[14 Mar 2009 17:19] Arcadiy Fedushin
'select version()' gave '5.1.30-community'.

I don't think it's the server problem.
'NULL' icon is displayed in grid above properly, and never - in 'Column Details' below.
[16 Mar 2009 18:38] Tonci Grgin
Hi Arcadiy and thanks for your report.

You do not file feature request against plug-in, it's integral part of
connector now. So please change the Version field so I know what to
test against.
Also, a DDL script you tested with would be just nice to have.
[18 Mar 2009 12:43] Tonci Grgin
Appears to be a problem in server:
  SHOW CREATE TABLE did not display a printable value for the default value of BIT columns. (Bug#35796)

Please upgrade to at least MySQL server 5.1.31 and retest.
[16 Apr 2009 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".