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

invalid range,range.start should be smaller than range.end #10242

Closed
superlzs0476 opened this issue Apr 24, 2019 · 3 comments
Closed

invalid range,range.start should be smaller than range.end #10242

superlzs0476 opened this issue Apr 24, 2019 · 3 comments
Labels
type/bug The issue is confirmed as a bug.

Comments

@superlzs0476
Copy link

Bug Report

Please answer these questions before submitting your issue. Thanks!

  1. What did you do?
    Execute query output errors .
    SQL:
    select count(*) from transaction_stats_tab WHERE (whs_id = 'IDG' AND transaction_type = 2

  2. What did you expect to see?
    Execute successful.

  3. What did you see instead?
    ERROR 1105(HY0000):other error: unknown error StringError("[src/coprocessor/dag/executor/table_scan.rs:56]: invalid range,range.start should be smaller than range.end, but got [[116, 128, 0, 0, 0, 0, 0, 19, 96, 95, 114, 254, 66, 203, 60, 110, 208, 160, 57],[116, 128, 0, 0, 0, 0, 0, 19, 96, 95, 114, 0, 28, 248, 3, 250, 72, 160, 57])")

  4. What version of TiDB are you using (tidb-server -V or run select tidb_version(); on TiDB)?
    Release Version: v2.1.0-5-g4dad722
    Git Commit Hash: 4dad722
    Git Branch: release-2.1
    UTC Build Time: 2018-12-07 02:29:19
    GoVersion: go version go1.11.2 linux/amd64
    Race Enabled: false
    TiKV Min Version: 2.1.0-alpha.1-ff3dd160846b7d1aed9079c389fc188f7f5ea13e
    Check Table Before Drop: false

@zz-jason zz-jason changed the title coprocessor err: other error: unknown error StringError("[src/coprocessor/dag/executor/table_scan.rs:56]: invalid range,range.start should be smaller than range.end, but got [[116, 128, 0, 0, 0, 0, 0, 19, 96, 95, 114, 254, 66, 203, 60, 110, 208, 160, 57],[116, 128, 0, 0, 0, 0, 0, 19, 96, 95, 114, 0, 28, 248, 3, 250, 72, 160, 57])") invalid range,range.start should be smaller than range.end Apr 24, 2019
@shenli
Copy link
Member

shenli commented Apr 24, 2019

@superlzs0476 Could please provide the schema?

@shenli shenli added the type/bug The issue is confirmed as a bug. label Apr 24, 2019
@alivxxx
Copy link
Contributor

alivxxx commented Apr 24, 2019

@superlzs0476 Could you also provide the statistics?

@pingcap pingcap deleted a comment from superlzs0476 Apr 24, 2019
@alivxxx
Copy link
Contributor

alivxxx commented Apr 24, 2019

The wrong range comes from feedback when split ranges. Can we cherry-pick the part that relates to feedback of #7921? @winoros

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/bug The issue is confirmed as a bug.
Projects
None yet
Development

No branches or pull requests

4 participants