Skip to content

error while using the keyword as the view name in the "show create view" statement #856

@FlyingMao

Description

@FlyingMao
  • dble version:
    5.6.29-dble-9.9.9.9-a5491f6-20181123014546
  • preconditions :
    no
  • configs:

schema.xml



rule.xml



server.xml



  • steps:
    step1. create view and using the keyword as the view name
mysql> drop table test;
Query OK, 0 rows affected (0.02 sec)

mysql> create table test(id int);
Query OK, 0 rows affected (0.02 sec)

mysql> create view `select` as select * from test;
Query OK, 0 rows affected (0.00 sec)

step2. execute show create view in dble

mysql> show create view `select`;
ERROR 1064 (HY000): Table 'mytest.select' doesn't exist
  • expect result:
    1. step2 execute succssed
  • real result:
    1. step2 execute failed
  • supplements:
    1.

/label ~BUG

Metadata

Metadata

Assignees

Labels

resolveproblem has been fixed by developer

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions