Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

When the table config with UpperCase name ,the ER can not be recognized #590

Closed
sunsun314 opened this issue Jul 16, 2018 · 1 comment
Closed
Assignees
Labels
er-table resolve problem has been fixed by developer verified issue's resolve was verified by tester
Milestone

Comments

@sunsun314
Copy link
Contributor

  • dble version:
    master-9.9.9.9
  • preconditions :
    no
  • configs:

schema.xml

<?xml version="1.0"?>
<!DOCTYPE dble:schema SYSTEM "schema.dtd">
<dble:schema xmlns:dble="http://dble.cloud/">
<schema name="testdb"  dataNode="dn1">
	<table name="tableA" rule="testShard" dataNode = "dn1,dn2"></table>
	<table name="tableB" rule="testShard" dataNode = "dn1,dn2"></table>
    </schema>
    <dataNode name="dn1" dataHost="host1" database="db1"></dataNode>
    <dataNode name="dn2" dataHost="host1" database="db2"></dataNode>
    <dataNode name="dn3" dataHost="host1" database="db3"></dataNode>
    <dataNode name="dn4" dataHost="host1" database="db4"></dataNode>
    <dataHost name="host1"  maxCon="50" minCon="1" balance="0" switchType="1" slaveThreshold="100" tempReadHostAvailable="0" >
        <heartbeat>select user()</heartbeat>
        <writeHost host="host1m" url="10.186.24.37:3308" user="root" password="123456">
        </writeHost>
    </dataHost>
</dble:schema>


rule.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE dble:rule SYSTEM "rule.dtd">
<dble:rule xmlns:dble="http://dble.cloud/">
<tableRule name="testShard">
        <rule>
            <columns>id</columns>
            <algorithm>test</algorithm>
        </rule>
    </tableRule>

<function name="test" class="Hash">
        <property name="partitionCount">2</property>
        <property name="partitionLength">1</property>
    </function>

  • steps:
    execute 'explain select * from tableb,tablea where tableb.id = tablea.id;
    '
  • expect result:
    the route can be turned into ER join ,send to mysql with join
  • real result:
    the sql can not be recognized as ER join

/label ~BUG

@yanhuqing666 yanhuqing666 added this to the 2.18.09.0 milestone Jul 16, 2018
@yanhuqing666 yanhuqing666 added er-table resolve problem has been fixed by developer labels Jul 16, 2018
yanhuqing666 added a commit that referenced this issue Jul 17, 2018
@yexiaoli88
Copy link

verified on version: 5.6.29-dble-9.9.9.9-283f45d-20180717102231

@yexiaoli88 yexiaoli88 added the verified issue's resolve was verified by tester label Jul 18, 2018
yanhuqing666 added a commit that referenced this issue Jul 20, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
er-table resolve problem has been fixed by developer verified issue's resolve was verified by tester
Projects
None yet
Development

No branches or pull requests

3 participants