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

Unexpected value after DDL 'ALTER TABLE t ADD COLUMN test blob NOT NULL' #36254

Closed
CodingPoeta opened this issue Jul 17, 2022 · 2 comments
Closed

Unexpected value after DDL 'ALTER TABLE t ADD COLUMN test blob NOT NULL' #36254

CodingPoeta opened this issue Jul 17, 2022 · 2 comments
Labels
affects-5.0 This bug affects 5.0.x versions. affects-5.1 This bug affects 5.1.x versions. component/tiflash severity/major sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.

Comments

@CodingPoeta
Copy link

CodingPoeta commented Jul 17, 2022 •
edited
Loading

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

Can not reproducing the bug yet in a new tidb, but it happened twice while they are still running( one is staging env, and another is prod env)

  1. run ALTER TABLE `t` ADD COLUMN `test1` blob NOT NULL;
  2. run select test1 from t limit 1;

2. What did you expect to see?

get result: an empty string ''

3. What did you see instead

get an unexpected value: 0x0000000000000000000......

4. What is your TiDB version?

our staging tidb version is v5.0.0, prod tidb version is v5.1.4
@CodingPoeta CodingPoeta added type/bug The issue is confirmed as a bug. affects-5.0 This bug affects 5.0.x versions. affects-5.1 This bug affects 5.1.x versions. labels Jul 17, 2022
@CodingPoeta
Copy link
Author

Please get in touch with me in feishu and I'll offer you the access to the cluster

@ti-chi-bot ti-chi-bot added may-affects-4.0 This bug maybe affects 4.0.x versions. may-affects-5.2 This bug maybe affects 5.2.x versions. may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-6.0 may-affects-6.1 labels Jul 18, 2022
@seiya-annie seiya-annie added sig/execution SIG execution and removed may-affects-4.0 This bug maybe affects 4.0.x versions. may-affects-5.2 This bug maybe affects 5.2.x versions. may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-6.0 may-affects-6.1 labels Jul 18, 2022
@zanmato1984 zanmato1984 added sig/sql-infra SIG: SQL Infra and removed sig/execution SIG execution labels Jul 18, 2022
@CodingPoeta
Copy link
Author

Found out to be a tiflash bug, solved here ,but not cherry-picked to v5.0 yet

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
affects-5.0 This bug affects 5.0.x versions. affects-5.1 This bug affects 5.1.x versions. component/tiflash severity/major sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@zanmato1984 @CodingPoeta @seiya-annie @ti-chi-bot