1
0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-07-02 17:22:27 +03:00
Files
mariadb-columnstore-engine/mysql-test/columnstore/basic/t/MCOL-5744-utf8-in-ddl.test
Sergey Zefirov 5b9ddd902e feat(ddl): MCOL-5744: better handling of utf8 charset aliases (#3174)
Server expands ut8_XXX aliases to utf8mb3_XXX or utf8mb4_XXX depending
on the UTF8_IS_UTF8MB3 setting in the OLD_MODE environment variable.

Server already has the necessary code implemented in the get_utf8_flag()
method of class THD. There are several uses of this flag and all we have
to do to be in line with server is to use it.

This patch does that for DDL as work on MCOL-5705 uncovered some
problems in that area.
2024-05-10 17:17:57 +01:00

20 lines
418 B
Plaintext

--disable_warnings
DROP DATABASE IF EXISTS MCOL5744;
--enable_warnings
CREATE DATABASE MCOL5744;
SET old_mode='';
CREATE TABLE t(x text CHARACTER SET utf8 COLLATE utf8_general_ci) ENGINE=COLUMNSTORE;
SHOW CREATE TABLE t;
DROP TABLE t;
SET old_mode='UTF8_IS_UTF8MB3';
CREATE TABLE t(x text CHARACTER SET utf8 COLLATE utf8_general_ci) ENGINE=COLUMNSTORE;
SHOW CREATE TABLE t;
DROP TABLE t;
DROP DATABASE MCOL5744;