Skip to content

Complex query with table alias will cause error when has ` #651

@sunsun314

Description

@sunsun314
  • dble version: 2.18.07.2
  • preconditions :
    no
  • configs:

schema.xml
default Config
rule.xml
default Config

server.xml
default Config

  • steps:
    execute select A.* FROM (select travelrecord.id,test_s.name from test_s, travelrecord where travelrecord.id = test_s.id) A where A.id = 99 order by A.id;
  • expect result:
    Empty set (0.01 sec)
  • real result:
    ERROR 4004 (HY000): child table a not exist!

/label ~BUG

Metadata

Metadata

Assignees

Labels

resolveproblem has been fixed by developerverifiedissue's resolve was verified by tester

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions