SET NAMES utf8;

CREATE TABLE t (c CHAR(1) GENERATED ALWAYS AS ('�'));

10.9.0-dbg>SET NAMES utf8;

Query OK, 0 rows affected (0.000 sec)

10.9.0-dbg>CREATE TABLE t (c CHAR(1) GENERATED ALWAYS AS ('�'));

ERROR 1918 (22007): Encountered illegal value '�' when converting to latin1

2022-04-09 10:11:31 4 [ERROR] mysqld: Incorrect information in file: './test/t.frm'

DROP TABLE IF EXISTS t1;

SET NAMES utf8mb3;

CREATE TABLE t1 (gc CHAR(1) GENERATED ALWAYS AS ('я')) CHARACTER SET latin1;

diff --git a/sql/table.cc b/sql/table.cc

--- a/sql/table.cc

+++ b/sql/table.cc

@@ -4837,7 +4837,7 @@ void open_table_error(TABLE_SHARE *share, enum open_frm_error error,

                       int db_errno)

 {

   char buff[FN_REFLEN];

-  const myf errortype= ME_ERROR_LOG;  // Write fatals error to log

+  const myf errortype= share->tmp_table == INTERNAL_TMP_TABLE ? 0 : ME_ERROR_LOG;  // Write fatals error to log

   DBUG_ENTER("open_table_error");

   DBUG_PRINT("info", ("error: %d  db_errno: %d", error, db_errno));

diff --git a/mysql-test/main/a.test b/mysql-test/main/a.test

--- /dev/null

+++ b/mysql-test/main/a.test

@@ -0,0 +1,10 @@

+disable_abort_on_error;

+CREATE TABLE t0 (a ENUM ('',0x0000),b ENUM (''));

+

+SET NAMES utf8mb3;

+CREATE TABLE t1 (gc CHAR(1) GENERATED ALWAYS AS ('я')) CHARACTER SET latin1;

+CREATE TABLE t1 (gc CHAR(1) GENERATED ALWAYS AS (CONCAT('я'))) CHARACTER SET latin1;

+CREATE TABLE t1 (gc CHAR(1) DEFAULT 'я') CHARACTER SET latin1;

+CREATE TABLE t1 (gc CHAR(1) CHARACTER SET latin1 GENERATED ALWAYS AS ('я'));

+CREATE TABLE t1 (gc CHAR(1) CHARACTER SET latin1 GENERATED ALWAYS AS (CONCAT('я')));

+CREATE TABLE t1 (gc CHAR(1) CHARACTER SET latin1 DEFAULT 'я');