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

multi-query with ddl may need sync context #743

Closed
irene-coming opened this issue Sep 29, 2018 · 3 comments
Closed

multi-query with ddl may need sync context #743

irene-coming opened this issue Sep 29, 2018 · 3 comments
Assignees
Labels
resolve problem has been fixed by developer verified issue's resolve was verified by tester
Milestone

Comments

@irene-coming
Copy link
Member

  • dble version:
    5.6.29-dble-9.9.9.9-153cf8b-20180928075325
  • preconditions :
    no
  • configs:

schema.xml

        <schema name="mytest" sqlMaxLimit="100" dataNode="dn5">
                <table name="aly_test" dataNode="dn1,dn2,dn3,dn4" rule="hash-four" />
        </schema>
        <dataNode name="dn1" dataHost="172.100.9.5" database="db1" />
        <dataNode name="dn2" dataHost="172.100.9.6" database="db1" />
        <dataNode name="dn3" dataHost="172.100.9.5" database="db2" />
        <dataNode name="dn4" dataHost="172.100.9.6" database="db2" />
        <dataNode name="dn5" dataHost="172.100.9.5" database="db3" />
  • steps:
    step1. run ./multiQuery.o

source file and compile see autotest directory:
autotest/dble/tree/master/drivers/c_mysql_api/multi-queries

  • expect result:
    1.print multi resultsets:
    0 rows affected
    More results exist
    0 rows affected
    More results exist
    0 rows affected
    More results exist
    0 rows affected
    More results exist
    1 rows affected
    More results exist
    1 rows affected
    More results exist
    0 rows affected

  • real result:

    1. print multi resultsets:
      0 rows affected
      More results exist
      0 rows affected
      More results exist
      0 rows affected
      More results exist
      Could not get next result
  • supplements:

    1. dble log segment

image

/label ~BUG

@yanhuqing666
Copy link
Member

yanhuqing666 commented Sep 29, 2018

In multi-queries ,the previous query is a distribute transaction would cause the next query executed for two times

@yanhuqing666 yanhuqing666 added this to the 2.18.10.0 milestone Sep 29, 2018
@yanhuqing666
Copy link
Member

9acdbb8 not for #734 but #743

@yanhuqing666 yanhuqing666 added the resolve problem has been fixed by developer label Sep 29, 2018
@irene-coming
Copy link
Member Author

verified on version: 5.6.29-dble-9.9.9.9-9acdbb8-20180929073705
autotest:mysql_multi_queries.cpp

@irene-coming irene-coming added the verified issue's resolve was verified by tester label Oct 8, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
resolve problem has been fixed by developer verified issue's resolve was verified by tester
Projects
None yet
Development

No branches or pull requests

2 participants