Bug #24875 Add Connection Dialog of Server Explorer will freeze with capitalized db names
Submitted: 7 Dec 2006 6:01 Modified: 14 Dec 2006 14:20
Reporter: Mev Talundzic Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Visual Studio Plugin Severity:S2 (Serious)
Version:all OS:Microsoft Windows (Win XP)
Assigned to: CPU Architecture:Any
Tags: Plug In, Visual Studio

[7 Dec 2006 6:01] Mev Talundzic
Description:
After following:

Connect To Database > Add Connectiion

When entering credentials into the Add Connection dialogue box to connect to a MYSQL server.  A database name containing capitalized letters (eg: test_DB) will freeze the Add Connection diaglogue box and Visual Studio along side it.

MYSQL Server Version: 4.0.27

How to repeat:
Create a dummy Database name with capitalized letters (eg: test_DB)

(1) Open Server Explorer
(2) Click Data on 'Connect To Database' icon
(3) Ensure that Selected 'Data Source' is MYSQL DB
(4) Enter logon credentials, (with capitalized DB name)

Suggested fix:
No fix
[7 Dec 2006 9:14] Tonci Grgin
Hi Mark and thanks for your problem report. I was able to verify it partially on my WinXP Pro SP2 with latest c/NET (5 and 1) and NET FW 2.0. There are some things that need looking into.

Server version: 5.0.27-log Source distribution
mysql> create database testCL;
mysql> create database test_UCL;
mysql> create database Mix_test_UCL;
mysql> create database MixTestUCl;
----
Your MySQL connection id is 1 to server version: 4.1.22-log
mysql> create database testCL;
mysql> create database test_UCL;
mysql> create database Mix_test_UCL;
mysql> create database MixTestUCl;

Plugin with MySQL server 5.0.X and both c/NET 5 and 1 gives correct result.
Plugin with MySQL server 4.1.X and both c/NET 5 and 1 gives *incorrect* result as shown on pictures attached.

Summary: Plugin shows null(null) instead of ServerName(database) when attaching to 4.1.x server. However, you can view tables etc...

I was able to crash VS2005 Pro *just once* during this testing but I think it was internal VS problem as it doesn't show anymore. 

General log:
061207  9:50:17	      3 Connect     root@localhost on Mix_test_UCL
		      3 Query       SHOW VARIABLES
		      3 Query       SHOW COLLATION
		      3 Query       SET character_set_results=NULL
		      3 Init DB     mix_test_ucl
061207  9:50:19	      3 Init DB     mix_test_ucl
		      3 Query       SHOW DATABASES LIKE 'Mix_test_UCL'
		      3 Query       SHOW DATABASES LIKE 'Mix_test_UCL'
061207  9:50:36	      3 Query       SHOW DATABASES LIKE 'Mix_test_UCL'
		      3 Query       SHOW DATABASES LIKE 'Mix_test_UCL'
		      3 Query       SHOW TABLE STATUS
061207  9:51:37	      3 Query       SHOW DATABASES LIKE 'Mix_test_UCL'
		      3 Query       SHOW DATABASES LIKE 'Mix_test_UCL'
		      3 Query       SHOW TABLE STATUS
[7 Dec 2006 9:15] Tonci Grgin
Demonstration of a problem

Attachment: 24875-Server4-1-problem1.jpg (image/jpeg, text), 36.04 KiB.

[7 Dec 2006 9:15] Tonci Grgin
Problematic connection properties

Attachment: 24875-Server4-1-problem2.jpg (image/jpeg, text), 10.35 KiB.

[7 Dec 2006 9:17] Tonci Grgin
Same test succedes with MySQL server 5.0.27BK and c/NET 1.0.x + c/NET 5.0.x SVN

Attachment: 24875-Net10.jpg (image/jpeg, text), 9.60 KiB.

[7 Dec 2006 13:49] Mev Talundzic
Thanks Tonchi,

Please note that I am currently access MYSQL Server 4.0.27 remotely w/CNET 5.0.2.  (ie: the Servername is just an IP address)

I had no issues connecting to the DB via 3.51.14 ODBC. I've re-tested and my Add Connection Dialogue box still freezes like clockwork.
[7 Dec 2006 20:45] Tonci Grgin
Mev, I'm sorry I misspelled your name, probably due to working on several issues at once...
[8 Dec 2006 17:29] 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/16676
[8 Dec 2006 17:29] Reggie Burnett
Fix will appear in 1.0.2
[14 Dec 2006 14:20] MC Brown
A note has been added to the Visual Studio Plugin changelog.