MySQL Bugs: #24875: Add Connection Dialog of Server Explorer will freeze with capitalized db names

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:	Windows (Win XP)
Assigned to:		CPU Architecture:	Any
Tags:	Plug In, Visual Studio

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

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

Demonstration of a problem

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

Problematic connection properties

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

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.

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.

Mev, I'm sorry I misspelled your name, probably due to working on several issues at once...

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

Fix will appear in 1.0.2

A note has been added to the Visual Studio Plugin changelog.