Skip to content

Error,when '-' in the name of schema #1241

@FlyingMao

Description

@FlyingMao
  • dble version:
    dble-9.9.9.9-67d04aa94d912fb01583096c6d8cba52f513996e-20190619021040
  • preconditions :
    no
  • configs:

schema.xml

<schema name="schema-1" sqlMaxLimit="100" dataNode="dn5">
		<table name="sharding_4_t1" dataNode="dn1,dn2,dn3,dn4" rule="hash-four" />
</schema>

rule.xml



server.xml



  • steps:
    step1. execute sql in dble user port
mysql> show columns from `schema-1`.`sharding_4_t1`;
ERROR 1146 (42S02): Table 'schema-1.sharding_4_t1' doesn't exist

step2. execute sql in dble manager port

mysql> check full @@metadata where schema='schema-1';
ERROR 1105 (HY000): The sql does not match: check full @@metadata [ where [schema='testSchema' [and table ='testTable']] | [reload_time [>|<]= 'yyyy-MM-dd HH:mm:ss']] | [reload_time is null] | [consistent_in_data_nodes =0|1] | [consistent_in_memory =0|1]
  • expect result:
    1. execute successful
  • real result:
    1. return error,such as steps
  • supplements:
    1.

Metadata

Metadata

Assignees

Labels

doc-itdiffer with mysql, and let it gofrom outsideresolveproblem has been fixed by developer

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions