Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.5.10
-
None
Description
This sequence has a failure on CREATE INDEX (Unknown column '.`r`.`DELETED`' in 'GENERATED ALWAYS')
CREATE TABLE `RULE` ( |
`DELETED` BIT(1), |
`UNIQ_CODE` VARCHAR(255) GENERATED ALWAYS AS (CASE DELETED WHEN 0 THEN 1 end) PERSISTENT |
);
|
|
CREATE OR REPLACE VIEW `V_RULE` AS SELECT DELETED FROM RULE r; |
|
CREATE INDEX `RULE_IDX01` ON `RULE` (DELETED); |
If I remove the alias ('r') in the view, everything works well.
Both scenarios works well in 10.5.9
I can't find in MariaDB 10.5.10 release notes what could cause this issue.
Attachments
Issue Links
- is duplicated by
-
MDEV-25672 table alias from previous statement interferes later commands
- Closed