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

explain format = ‘verbose’ has different behavior with explain format=‘VERBOSE’ #34469

Closed
AilinKid opened this issue May 9, 2022 · 0 comments · Fixed by #34471
Closed
Assignees
Labels
severity/moderate sig/planner SIG: Planner type/bug The issue is confirmed as a bug.

Comments

@AilinKid
Copy link
Contributor

AilinKid commented May 9, 2022

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required

USE test;
DROP TABLE IF EXISTS t;
CREATE TABLE t (id int, dc datetime, cc1 char(20), cc2 char(20));
INSERT INTO t VALUES (1, '2022-05-01 15:33:33', 'UUtJeaV', 'snRXXCZHBPW'), (2, '2022-05-01 15:33:33', 'snRXXCZHBPW', 'UUtJeaV');

explain format = 'verbose' select id, DAYNAME(dc), MONTHNAME(dc) from t;
explain format='VERBOSE' select id, DAYNAME(dc), MONTHNAME(dc) from t;

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

the result should be the same

3. What did you see instead (Required)

the CAPITAL one shows
TiDB-v6> explain format='VERBOSE' select id, DAYNAME(dc), MONTHNAME(dc) from t;
ERROR 1105 (HY000): runtime error: index out of range [0] with length 0

4. What is your TiDB version? (Required)

master

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

Successfully merging a pull request may close this issue.

1 participant