Skip to content

planner: plan replayer: create schema and tables failed when there is ";" in the column comment #46989

@elsa0520

Description

@elsa0520

Bug Report

mysql>  plan replayer load
plan replayer: create schema and tables failed

1. Minimal reproduce step (Required)

  1. create table and the column comment contains ";"
create table t (k1 int, k2 int comment 'xx;xxx')
  1. dump plan replayer
plan replayer dump explain select * from t;
  1. reload plan replayer
PLAN REPLAYER LOAD 'plan_replayer.zip';

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

Reload table and schema successful

3. What did you see instead (Required)

mysql>  plan replayer load "plan_replayer.zip";
ERROR 1105 (HY000): plan replayer: create schema and tables failed

4. What is your TiDB version? (Required)

v6.5.2

Metadata

Metadata

Assignees

No one assigned

    Labels

    affects-7.5This bug affects the 7.5.x(LTS) versions.affects-8.1This bug affects the 8.1.x(LTS) versions.affects-8.5This bug affects the 8.5.x(LTS) versions.severity/moderatesig/plannerSIG: Plannertype/bugThe issue is confirmed as a bug.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions