Bug #86978 Connector/Net cannot debug a stored procedure including a table like a 0123_aa.
Submitted: 7 Jul 2017 1:25 Modified: 7 Jul 2017 5:34
Reporter: Meiji Kimura Email Updates:
Status: Verified Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version: OS:Microsoft Windows
Assigned to: CPU Architecture:Any

[7 Jul 2017 1:25] Meiji Kimura
Description:
Based on historical reason, MySQL can deal with a table name start with numerical character without `

create table 0123_aa(i1 int);

But if a stored procedure contains table name like this, Connector/Net cannot debug the stored procedue with this error message.

line 3:22 no viable alternative at input '0123'. Expected simple_table_ref_no_alias_existing
line 4:14 no viable alternative at input '0123'.

How to repeat:
Add these stored procedures, and try to debug them with this procedure.

https://dev.mysql.com/doc/visual-studio/en/visual-studio-debugger.html

only dt shows no viable alternative errors.

drop procedure if exists dt;
delimiter $$
CREATE PROCEDURE dt()
begin
DROP TABLE IF EXISTS 0123_aa;
CREATE TABLE 0123_aa(i1 int);
end$$
delimiter ;

drop procedure if exists dt2;
delimiter $$
CREATE PROCEDURE dt2()
begin
DROP TABLE IF EXISTS aa;
CREATE TABLE aa(i1 int);
end$$
delimiter ;

drop procedure if exists dt3;
delimiter $$
CREATE PROCEDURE dt3()
begin
DROP TABLE IF EXISTS `0123_aa`;
CREATE TABLE `0123_aa`(i1 int);
end$$
delimiter ;

Suggested fix:
Should be able debug dt,

or 

Add limitation statement to this manual.
https://dev.mysql.com/doc/visual-studio/en/visual-studio-debugger.html
[7 Jul 2017 5:34] Chiranjeevi Battula
Hello Meiji,

Thank you for the bug report and test case.
Verified this behavior on Visual Studio 2013 (C#.Net) and Connector/NET 6.9.9 version.

Thanks,
Chiranjeevi.
[7 Jul 2017 5:35] Chiranjeevi Battula
Screenshot

Attachment: 86978.JPG (image/jpeg, text), 88.44 KiB.