Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.5.10
-
None
-
Debian Linux and mariadb docker 10.5.10
Description
I have an existing table:
CREATE TABLE `Users` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`handle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`first_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`display_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`phonenumber` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`verified` int(11) NOT NULL DEFAULT 0,
`settings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`settings`)),
`last_login` datetime DEFAULT NULL,
`locked` tinyint(1) NOT NULL DEFAULT 0,
`api_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `users_username_unique` (`username`),
UNIQUE KEY `users_email_unique` (`email`),
UNIQUE KEY `Users_handle_uindex` (`handle`),
UNIQUE KEY `users_api_token_unique` (`api_token`)
) ENGINE=InnoDB AUTO_INCREMENT=188 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
Then I want to add another columns
alter table Users add foo int;
The error I see is:
[2021-05-17 16:27:48] [42S22][1054] (conn=1773) Unknown column '`<<database-name>>`.`U`.`settings`' in 'CHECK'
This is properly working on 10.5.9 and 10.5.8
Already known? Happy to dig deeper if helpful! THX
Attachments
Issue Links
- is duplicated by
-
MDEV-25672 table alias from previous statement interferes later commands
- Closed