BLOB/TEXT/JSON column can't have a default value #12
Description
2022/02/12 11:45:05 ddl.go:96: [fatal] [error] [instance 2] ERROR: Error when executing SQL: ALTER TABLE `a7ab9717-107f-4257-a4f4-23ac5773c733` ALTER `31efd5ad-e11c-455d-8d43-e7f899b63e24` SET DEFAULT '1'
remote tidb Err: &mysql.MySQLError{Number:0x44d, Message:"BLOB/TEXT/JSON column '31efd5ad-e11c-455d-8d43-e7f899b63e24' can't have a default value"}
======== DEBUG BEGIN ========
Dumping expected contents for table `a7ab9717-107f-4257-a4f4-23ac5773c733`:
Comment: 5d1c8fc1-b54a-4094-8f0b-477ccd932ba3
Charset: latin1, Collate: latin1_bin
ShardRowId: 1
AutoID: 0
## Non-Primary Indexes:
Index #0: Name = `d573dac2-da30-47c6-8a62-3cfaa7b365c3`, Columnns = [`43707c77-f33e-4236-9c6f-148de13b08b1`, ]
Index #1: Name = `49c540c4-ef72-4ac7-b7e7-6c24ae749559`, Columnns = [`3f1eb01b-adc8-4f85-8f43-6be6aad006b3`, ]
Index #2: Name = `8ecd5493-130e-4e61-b22b-0bb8c5daafc0`, Columnns = [`3d87686c-fa2d-4dfe-8320-3745f37509f3`, `3f1eb01b-adc8-4f85-8f43-6be6aad006b3`, `54848b82-1524-4ce9-9178-1426ee2fb1aa`, ]
Index #3: Name = `77d45d59-0c21-4c6f-af25-b182c7a9f047`, Columnns = [`3d87686c-fa2d-4dfe-8320-3745f37509f3`, `a08c179c-c56c-428e-8075-d1d074a17289`, `3f1eb01b-adc8-4f85-8f43-6be6aad006b3`, `54848b82-1524-4ce9-9178-1426ee2fb1aa`, ]
Index #4: Name = `4a50dad8-1911-4ddf-af97-e5b9ce32b9d9`, Columnns = [`f10e1b03-05a9-4d85-9fac-692c1c18134c`, ]
Index #5: Name = `bfb85f26-54bc-47d4-beb7-b6c8f734f189`, Columnns = [`3d87686c-fa2d-4dfe-8320-3745f37509f3`, `54848b82-1524-4ce9-9178-1426ee2fb1aa`, `43707c77-f33e-4236-9c6f-148de13b08b1`, `f10e1b03-05a9-4d85-9fac-692c1c18134c`, `3f1eb01b-adc8-4f85-8f43-6be6aad006b3`, `a08c179c-c56c-428e-8075-d1d074a17289`, ]
Index #6: Name = `270af0af-4f20-404b-9e88-7f3393d3c48d`, Columnns = [`43707c77-f33e-4236-9c6f-148de13b08b1`, `a08c179c-c56c-428e-8075-d1d074a17289`, `3f1eb01b-adc8-4f85-8f43-6be6aad006b3`, `f10e1b03-05a9-4d85-9fac-692c1c18134c`, `54848b82-1524-4ce9-9178-1426ee2fb1aa`, `7e71f1d6-5327-49f5-9b6d-c7737ed897f6`, ]
Index #7: Name = `dd2749e1-2927-4b5c-a5e7-536ae0544af1`, Columnns = [`7e71f1d6-5327-49f5-9b6d-c7737ed897f6`, ]
Index #8: Name = `728f037c-d446-4041-aa95-e8041b1a3aef`, Columnns = [`de3ffa2b-8b17-4866-a7de-204b107a2987`, ]
Index #9: Name = `811e6498-5ae1-41ba-b023-9ee047d27a85`, Columnns = [`54848b82-1524-4ce9-9178-1426ee2fb1aa`, `3d87686c-fa2d-4dfe-8320-3745f37509f3`, `a08c179c-c56c-428e-8075-d1d074a17289`, `7e71f1d6-5327-49f5-9b6d-c7737ed897f6`, `de3ffa2b-8b17-4866-a7de-204b107a2987`, `3f1eb01b-adc8-4f85-8f43-6be6aad006b3`, ]
Index #10: Name = `7dc629e9-af0d-4d7b-b809-e75205d08a18`, Columnns = [`a08c179c-c56c-428e-8075-d1d074a17289`, ]
Index #11: Name = `c376c17b-4f37-4c52-b5d4-459515b9ffca`, Columnns = [`c8f81b70-d6fa-44d1-a9d8-9f42bfe081a8`, ]
Index #12: Name = `8138df8b-84a3-4686-b003-85545c887a7e`, Columnns = [`43707c77-f33e-4236-9c6f-148de13b08b1`, `54848b82-1524-4ce9-9178-1426ee2fb1aa`, ]
Index #13: Name = `75a23afd-93f3-4c7d-a96f-4bc474458893`, Columnns = [`a08c179c-c56c-428e-8075-d1d074a17289`, `f10e1b03-05a9-4d85-9fac-692c1c18134c`, `de3ffa2b-8b17-4866-a7de-204b107a2987`, `43707c77-f33e-4236-9c6f-148de13b08b1`, `c8f81b70-d6fa-44d1-a9d8-9f42bfe081a8`, `d39843dd-dfd5-43f3-8773-64a38399c14a`, `d9b6db2a-53d1-47fd-b998-9e3db5025587`, `54848b82-1524-4ce9-9178-1426ee2fb1aa`, `7e71f1d6-5327-49f5-9b6d-c7737ed897f6`, `3f1eb01b-adc8-4f85-8f43-6be6aad006b3`, ]
Index #14: Name = `48f073cc-d0f1-485e-84a0-72068af079ea`, Columnns = [`7a1de71c-f3c2-428f-9181-8364402aacca`, `54848b82-1524-4ce9-9178-1426ee2fb1aa`, `c8f81b70-d6fa-44d1-a9d8-9f42bfe081a8`, `d39843dd-dfd5-43f3-8773-64a38399c14a`, `3f1eb01b-adc8-4f85-8f43-6be6aad006b3`, `a08c179c-c56c-428e-8075-d1d074a17289`, `de3ffa2b-8b17-4866-a7de-204b107a2987`, `d9b6db2a-53d1-47fd-b998-9e3db5025587`, `7e71f1d6-5327-49f5-9b6d-c7737ed897f6`, `f10e1b03-05a9-4d85-9fac-692c1c18134c`, ]
Index #15: Name = `e2ecb234-ca40-47b6-9b50-1020c5fff70a`, Columnns = [`7a1de71c-f3c2-428f-9181-8364402aacca`, ]
Index #16: Name = `4e845d50-7940-403e-9a8e-e9ea425c00cc`, Columnns = [`d9b6db2a-53d1-47fd-b998-9e3db5025587`, ]
Index #17: Name = `0b96df59-2836-4f81-8f45-b341246463fe`, Columnns = [`3cc8f47f-585d-4b1b-b677-16057dd8b7ca`, ]
## Columns:
Column #0: Name = `31efd5ad-e11c-455d-8d43-e7f899b63e24`, Definition = BLOB(46) NULL, isPrimaryKey = false, used in 0 indexes
Column #1: Name = `4031fc43-7f33-4599-a974-9451c396eae1`, Definition = DECIMAL(22,6) NULL DEFAULT '8916667874631638.729462', isPrimaryKey = false, used in 1 indexes
Column #2: Name = `1e2bba4f-0525-40d3-ae59-787886d223c5`, Definition = TIMESTAMP NULL DEFAULT '2017-11-30 00:28:55', isPrimaryKey = false, used in 0 indexes
Column #3: Name = `7a1de71c-f3c2-428f-9181-8364402aacca`, Definition = ENUM("q47", "t0e9", "qv", "dl36c", "0", "o", "d", "ac", "v", "ubkg6", "ukl1") NULL DEFAULT 't0e9', isPrimaryKey = false, used in 2 indexes
Column #4: Name = `7e71f1d6-5327-49f5-9b6d-c7737ed897f6`, Definition = INT NULL DEFAULT '1111823347', isPrimaryKey = false, used in 5 indexes
Column #5: Name = `f10e1b03-05a9-4d85-9fac-692c1c18134c`, Definition = INT NULL DEFAULT '235440336', isPrimaryKey = false, used in 5 indexes
Column #6: Name = `43707c77-f33e-4236-9c6f-148de13b08b1`, Definition = DOUBLE NULL DEFAULT '1.550852129749729', isPrimaryKey = false, used in 5 indexes
Column #7: Name = `54848b82-1524-4ce9-9178-1426ee2fb1aa`, Definition = DATETIME NULL DEFAULT '2994-08-18 05:57:13', isPrimaryKey = false, used in 8 indexes
Column #8: Name = `a08c179c-c56c-428e-8075-d1d074a17289`, Definition = FLOAT NULL DEFAULT '1.6221433', isPrimaryKey = false, used in 6 indexes
Column #9: Name = `d39843dd-dfd5-43f3-8773-64a38399c14a`, Definition = DATE NULL DEFAULT '2426-09-03', isPrimaryKey = false, used in 2 indexes
Column #10 [DELETED]: Name = `3f1eb01b-adc8-4f85-8f43-6be6aad006b3`, Definition = VARCHAR(171) NULL DEFAULT 'vp3ts5ci9lktv22r8ay1cpzmxsgrxopdhrzv0o80q673w429qxpp8xiu5gv88ya8wijx1jxr8azayhrin4clu58fekfv4ocw73owejsumclflj21icdzd4thv7hjl1zfzdkkdow8y7uyglh4hny4idmukms6o0uhiubkkyd', isPrimaryKey = false, used in 7 indexes
Column #11: Name = `d9b6db2a-53d1-47fd-b998-9e3db5025587`, Definition = INT NULL DEFAULT '1459954307', isPrimaryKey = false, used in 2 indexes
Column #12: Name = `31efd5ad-e11c-455d-8d43-e7f899b63e24`, Definition = BOOL NULL DEFAULT '0', isPrimaryKey = false, used in 0 indexes
Column #13: Name = `3cc8f47f-585d-4b1b-b677-16057dd8b7ca`, Definition = VARCHAR(52) NULL DEFAULT 'pbqxyfq', isPrimaryKey = false, used in 1 indexes
## Values (number of rows = 0):
======== DEBUG END ========