Details
-
Type:
Bug
-
Status: Confirmed (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 10.4.12, 10.4.13, 10.4, 10.5, 10.6
-
Component/s: None
-
Labels:None
-
Environment:Windows 10 64-bit
Description
For the following table:
CREATE TABLE `demo_upsert` ( |
`ID` BIGINT(20) NOT NULL AUTO_INCREMENT, |
`Url` TEXT NOT NULL COLLATE 'utf8mb4_unicode_ci', |
`LastListID` BIGINT(20) NULL DEFAULT NULL, |
`Statistics` BIGINT(20) NOT NULL DEFAULT '0', |
PRIMARY KEY (`ID`) USING BTREE, |
UNIQUE INDEX `Url` (`Url`) USING HASH |
)
|
COLLATE='utf8mb4_unicode_ci' |
ENGINE=InnoDB
|
;
|
When I run the following query:
INSERT INTO demo_upsert (Url, LastListID) SELECT Url, 10 FROM demo_upsert ON DUPLICATE KEY UPDATE LastListID=10 |
I get the following error:
SQL Error (1364): Field 'DB_ROW_HASH_1' doesn't have a default value
Attachments
Issue Links
- is duplicated by
-
MDEV-26846 SQL Error: Field 'DB_ROW_HASH_1' doesn't have a default value
-
- Closed
-
- relates to
-
MDEV-371 Unique indexes for blobs
-
- Closed
-