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

unstable test TestHypoIndexDDL #44327

Closed
Tracked by #41316
hawkingrei opened this issue Jun 1, 2023 · 0 comments · Fixed by #44358
Closed
Tracked by #41316

unstable test TestHypoIndexDDL #44327

hawkingrei opened this issue Jun 1, 2023 · 0 comments · Fixed by #44358
Labels
component/test severity/major sig/planner SIG: Planner type/bug The issue is confirmed as a bug.

Comments

@hawkingrei
Copy link
Member

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

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

3. What did you see instead (Required)

--- FAIL: TestHypoIndexDDL (1.12s)
    result.go:49:
                Error Trace:    testkit/result.go:49
                                                        planner/core/plan_test.go:970
                Error:          Not equal:
                                expected: "[t CREATE TABLE `t` (\n  `a` int(11) DEFAULT NULL,\n  `b` int(11) DEFAULT NULL,\n  `c` int(11) DEFAULT NULL,\n  `d` int(11) DEFAULT NULL,\n  KEY `a` (`a`),\n  KEY `hypo_a` (`a`) /* HYPO INDEX */,\n  KEY `hypo_bc` (`b`,`c`) /* HYPO INDEX */\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin]\n"
                                actual  : "[t CREATE TABLE `t` (\n  `a` int(11) DEFAULT NULL,\n  `b` int(11) DEFAULT NULL,\n  `c` int(11) DEFAULT NULL,\n  `d` int(11) DEFAULT NULL,\n  KEY `a` (`a`),\n  KEY `hypo_bc` (`b`,`c`) /* HYPO INDEX */,\n  KEY `hypo_a` (`a`) /* HYPO INDEX */\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin]\n"

                                Diff:
                                --- Expected
                                +++ Actual
                                @@ -6,4 +6,4 @@
                                   KEY `a` (`a`),
                                -  KEY `hypo_a` (`a`) /* HYPO INDEX */,
                                -  KEY `hypo_bc` (`b`,`c`) /* HYPO INDEX */
                                +  KEY `hypo_bc` (`b`,`c`) /* HYPO INDEX */,
                                +  KEY `hypo_a` (`a`) /* HYPO INDEX */
                                 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin]
                Test:           TestHypoIndexDDL
                Messages:       sql:show create table t, args:[]

4. What is your TiDB version? (Required)

@hawkingrei hawkingrei added the type/bug The issue is confirmed as a bug. label Jun 1, 2023
@ti-chi-bot ti-chi-bot bot added may-affects-5.1 This bug maybe affects 5.1.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.1 may-affects-6.5 may-affects-7.1 labels Jun 1, 2023
@seiya-annie seiya-annie removed may-affects-5.1 This bug maybe affects 5.1.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.1 may-affects-6.5 may-affects-7.1 labels Jun 1, 2023
@qw4990 qw4990 added the sig/planner SIG: Planner label Jun 2, 2023
ti-chi-bot bot pushed a commit that referenced this issue Jun 2, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
component/test severity/major 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.

3 participants