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.

Sign up for GitHub

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

Jump to bottom

failed to load plan replayer: ERROR 1292 (22007): Truncated incorrect DOUBLE value #56083

Closed
dbsid opened this issue Sep 14, 2024 · 0 comments · Fixed by #57314
Closed

failed to load plan replayer: ERROR 1292 (22007): Truncated incorrect DOUBLE value #56083

dbsid opened this issue Sep 14, 2024 · 0 comments · Fixed by #57314
Assignees
@hawkingrei
Labels
affects-8.1 This bug affects the 8.1.x(LTS) versions. affects-8.5 This bug affects the 8.5.x(LTS) versions. severity/critical sig/planner SIG: Planner type/bug The issue is confirmed as a bug.

Comments

@dbsid
Copy link
Contributor

dbsid commented Sep 14, 2024

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

mysql> PLAN REPLAYER LOAD 'plan_replay_20240913_0923.zip';

2. What did you expect to see? (Required)

no error

3. What did you see instead (Required)

ERROR 1292 (22007): Truncated incorrect DOUBLE value: 'P'

4. What is your TiDB version? (Required)

v7.5.0, v8.3.0
@dbsid dbsid added the type/bug The issue is confirmed as a bug. label Sep 14, 2024
@hawkingrei hawkingrei self-assigned this Sep 18, 2024
@ti-chi-bot ti-chi-bot bot added the affects-8.5 This bug affects the 8.5.x(LTS) versions. label Nov 1, 2024
@hawkingrei hawkingrei mentioned this issue Nov 13, 2024
Merged
13 tasks
@hawkingrei hawkingrei added affects-8.1 This bug affects the 8.1.x(LTS) versions. and removed may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-6.1 may-affects-6.5 may-affects-7.1 may-affects-7.5 may-affects-8.1 labels Nov 13, 2024
ti-chi-bot bot pushed a commit that referenced this issue Nov 13, 2024
@hawkingrei
statistics: fix bad lower bound and upper bound when to dump stats in…
66cb425 
…to json (#57314)

close #56083
@ti-chi-bot ti-chi-bot mentioned this issue Nov 14, 2024
Merged
13 tasks
ti-chi-bot pushed a commit to ti-chi-bot/tidb that referenced this issue Nov 14, 2024
@hawkingrei @ti-chi-bot
statistics: fix bad lower bound and upper bound when to dump stats in…
e66fd5c 
…to json (pingcap#57314)

close pingcap#56083
@ti-chi-bot ti-chi-bot mentioned this issue Nov 14, 2024
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Nov 14, 2024
@ti-chi-bot
statistics: fix bad lower bound and upper bound when to dump stats in…
0db50c1 
…to json (#57314) (#57363)

close #56083
ti-chi-bot bot pushed a commit that referenced this issue Nov 14, 2024
@ti-chi-bot
statistics: fix bad lower bound and upper bound when to dump stats in…
1a581e1 
…to json (#57314) (#57364)

close #56083
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@hawkingrei hawkingrei

Labels
affects-8.1 This bug affects the 8.1.x(LTS) versions. affects-8.5 This bug affects the 8.5.x(LTS) versions. severity/critical sig/planner SIG: Planner type/bug The issue is confirmed as a bug.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

statistics: fix bad lower bound and upper bound when to dump stats into json hawkingrei/tidb
4 participants
@fixdb @dbsid @hawkingrei @jebter