Bug #69065 Visual Studio Debugging Procedure - Table not found
Submitted: 25 Apr 2013 9:31 Modified: 4 Jul 2013 1:38
Reporter: Tobias Bauer Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S2 (Serious)
Version:6.6.5 OS:Windows (7)
Assigned to: Fernando Gonzalez.Sanchez CPU Architecture:Any

[25 Apr 2013 9:31] Tobias Bauer
Description:
If I try to debug a stored procedure via VisualStudio following the guide at http://dev.mysql.com/doc/refman/5.5/en/connector-net-visual-studio-debugger.html I get the Debugger Error message "Error while debugging: Table 'serversidedebugger.DebugScope' does not exist'... 

How to repeat:
Use Visual Studio 2010 on Windows 7 and connect to MySql Database 5.5.29 on Linux (Ubuntu) - try to debug a stored procedure

Suggested fix:
Linux table-names are case-sensitive while windows is not... 

when the database 'serversidedebugger' is created from the visual-studio-debugger all the tables are created in lowercase - for Windows this doesn't matter, but if created on linux it does - I checked this also in the source code of the connector (Source/MySql.Debugger/MySql Scripts/Schema.sql) -> all names are lowercase in the create-script...

but then the visual-studio-debugger seems to try to access the tables using camel-case tablename syntax in the SQL-script to query the table... 
and thats why the error occurs...
[25 Apr 2013 9:42] Tobias Bauer
As a workaround 'lower_case_table_names' option can be set to 1 for the mysql-server running on linux...
[4 Jul 2013 1:38] Philip Olson
Fixed as of MySQL for Visual Studio 1.0.0, and here's the changelog entry:

It was not possible to debug a stored procedure from a Linux server
without the "lower_case_table_names" option enabled.

Thank you for the bug report.