Repository navigation
Can't find column when to analyze virtual column with vector #62682
Description
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
CREATE TABLE t1 (
id bigint NOT NULL,
c1 varchar(50) NOT NULL,
c2 int DEFAULT NULL,
c3 json DEFAULT NULL,
c4 varchar(255) GENERATED ALWAYS AS (json_unquote(json_extract(c3, '$.oppositePlaceId'))) VIRTUAL,
c5 vector(3),
c6 double GENERATED ALWAYS AS (vec_l2_distance(c5, '[0,0,0]')) VIRTUAL,
PRIMARY KEY (id),
UNIQUE KEY idx_unique (c1,c2)) ;
analyze table t1 all columns;
2. What did you expect to see? (Required)
success
3. What did you see instead (Required)
(1105, "Can't find column Column#6 in schema Column: [test.t1.id,test.t1.c1,test.t1.c2,test.t1.c4,test.t1.c6,test.t1.c3] PKOrUK: [] NullableUK: []")
Activity
planner,analyze: Add skipped vector column to "skipCol" (pingcap#62683)
planner,analyze: Add skipped vector column to "skipCol" (pingcap#62683)
planner,analyze: Add skipped vector column to "skipCol" (#62683) (#62753