Possible corrupted bit default value

[zanmato1984]

Bug Report

1. Minimal reproduce step (Required)

Once #17641 get fixed, we'll see:

mysql> create table t(i int);
Query OK, 0 rows affected (0.10 sec)

mysql> insert into t values(1);
Query OK, 1 row affected (0.02 sec)

mysql> alter table t add column b bit(1) default b'<SOME VALUE TREATED AS INVALID STRING>';
Query OK, 0 rows affected (0.28 sec)

mysql> select b from t;
+------------+
| b          |
+------------+
| <SOME VALUE TREATED AS INVALID STRING> | // this value comes from `default_bit` which is OK.
+------------+
1 row in set (0.00 sec)

mysql> alter table t modify column b bit(1) default b'1';
Query OK, 0 rows affected (0.09 sec)

mysql> select b from t;
+------------+
| b          |
+------------+
| <CORRUPTED VALUE> | // this value comes from `origin_default` which is corrupted.
+------------+
1 row in set (0.01 sec)

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

3. What did you see instead (Required)

4. Affected version (Required)

v3.0.0, v3.1.0, v4.0.0

5. Root Cause Analysis

Lack something like "origin_default_bit".

[tangenta]

Let me fix it.

[sre-bot]

Integrity check:
RCA symptom trigger_condition affect_version fix_version fields are empty
@tangenta
Please comment /info to get template

[ti-srebot]

Duplicate bug

Duplicated with #17641.