bug: select return nothing but retry will get results

[ZeaLoVe]

Search before asking

• I had searched in the issues and found no similar issues.

Version

v0.7.82-nightly

What's Wrong?

cc @sundy-li

How to Reproduce?

Easy to reproduce in the process of testing a large number of select statements.

Are you willing to submit PR?

• Yes I am willing to submit a PR!

[ZeaLoVe]

Fixed in the build v0.7.86-nightly, close it,

[ZeaLoVe]

1_1_select.txt

Still exists when running the logic test with this case. cc @youngsofun

[youngsofun]

@zhang2014

both http handler and mysql handler fail because some query should return some rows but did not.
these are flaky test, seem not related to a Specific case
I guess it may be a bug of pipeline? can you help with deuging/fixing it?

unzip select_cases.zip
in tests/logictest/suites/gen
replace tests/logictestlogictest.py with logictest.py.txt

export DISABLE_HTTP_LOGIC_TEST=1
cd tests/logictest
python ./main.py ".*select.*.test"

[zhang2014]

@youngsofun Ok. I will try to fixes it.

[youngsofun]

FYI

1. the table is inserted many times, so with many partitions.
2. an idea: maybe we can find one fail case， and write a script to query it many times expecting a fail, with a fixed case, we can add more assert in code to find the bug. but did not work on unit-test (did not fail)

[ZeaLoVe]

@zhang2014 Any progress？

[zhang2014]

Sorry, I worked on other tasks before. Now let's come back here.