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: | |
Category: | MySQL Visual Studio Plugin | Severity: | S2 (Serious) |
Version: | all | OS: | Windows (Win XP) |
Assigned to: | CPU Architecture: | Any | |
Tags: | Plug In, Visual Studio |
[7 Dec 2006 6:01]
Mev Talundzic
[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.