[MDEV-25763] optimize table : Unknown column Created: 2021-05-24  Updated: 2021-05-27  Resolved: 2021-05-25

Status: Closed
Project: MariaDB Server
Component/s: Optimizer
Affects Version/s: 10.5.10
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Pascal HOARAU Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Environment:

centos 8


Issue Links:
Duplicate
is duplicated by MDEV-25672 table alias from previous statement i... Closed

 Description   

check table jbm_clients.voyageprive;
+-------------------------+-------+----------+----------+
| Table                   | Op    | Msg_type | Msg_text |
+-------------------------+-------+----------+----------+
| jbm_clients.voyageprive | check | status   | OK       |
+-------------------------+-------+----------+----------+
 
 optimize table jbm_clients.voyageprive;
+-------------------------+----------+----------+--------------------------------------------------------------------+
| Table                   | Op       | Msg_type | Msg_text                                                           |
+-------------------------+----------+----------+--------------------------------------------------------------------+
| jbm_clients.voyageprive | optimize | note     | Table does not support optimize, doing recreate + analyze instead  |
| jbm_clients.voyageprive | optimize | error    | Unknown column '`jbm_clients`.`y`.`headers`' in 'GENERATED ALWAYS' |
| jbm_clients.voyageprive | optimize | status   | Operation failed                                                   |
+-------------------------+----------+----------+--------------------------------------------------------------------+


Generated at Thu Feb 08 09:40:10 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.