MySQL Forums
Forum List  »  InnoDB

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
An error occurs when you use a stored function saved in another database in a virtual column
103
December 13, 2018 11:30PM


Sorry, only registered users may post in this forum.

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.