[Bug] [Vectorized] fix schema change add varchar type column default value get wrong result

[BiteTheDDDDt]

Search before asking

• I had searched in the issues and found no similar issues.

Version

master

What's Wrong?

CREATE TABLE `test_dup` (
 `k1` int(11) NULL COMMENT "",
 `k2` int(11) NULL COMMENT ""
) ENGINE=OLAP
DUPLICATE KEY(`k1`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`k1`) BUCKETS 5
PROPERTIES (
"replication_num" = "1",
"in_memory" = "false",
"storage_format" = "V2"
);

insert into test_dup values(1,1),(2,2),(3,3);

ALTER TABLE test_dup ADD COLUMN new_col VARCHAR(100) DEFAULT "1" AFTER k2;

MySQL [test]> select * from test_dup;
+------+------+------------------+
| k1 | k2 | new_col |
+------+------+------------------+
| 2 | 2 | (��N |
| 1 | 1 | (��v |
| 3 | 3 | (��v |
+------+------+------------------+

What You Expected?

fix it

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct