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
