An error occurs when you use a stored function saved in another database in a virtual column
Posted by:
高木 祐介
Date: December 13, 2018 11:30PM
An error occurs when you use a stored function saved in another database in a virtual column.
CREATE TABLE `tbl_test` (
`id` int(0) AS () NOT NULL,
`name` varchar(255) NULL,
PRIMARY KEY (`id`)
);
ALTER TABLE `tbl_test`
ADD COLUMN `name2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci GENERATED ALWAYS AS (convert_data(name, other_database.stored("sample1", "sample2", "sample3", "sample4", "sample5" , "item_char1")) VIRTUAL NULL AFTER `name`
> OK
> 時刻: 0.116s
But
SHOW TABLE STATUS
/var/lib/mysql/mysql-error.log
2018-12-14T14:16:45.399156+09:00 137 [ERROR] /usr/sbin/mysqld: ファイル './database/tbl_test.frm' 内の情報が不正です。
エラー: 1033 SQLSTATE: HY000 (ER_NOT_FORM_FILE)
メッセージ: ファイル '%s' 内の情報が不正です
english
Error number: 1033; Symbol: ER_NOT_FORM_FILE; SQLSTATE: HY000
Message: Incorrect information in file: '%s'
How can I delete the last added virtual column or remove the illegally loaded frm file from the database?
Subject
Views
Written By
Posted
An error occurs when you use a stored function saved in another database in a virtual column
1016
December 13, 2018 11:30PM
457
December 14, 2018 12:14AM
566
December 14, 2018 01:38AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.