Ziele Untersuchung
mit Columbo Integrität von
Datenbanken Interaktion und
Portierbarkeit Ergonomie der
Schnittstellen

Angebot Produkte Projekt Beratung

Mittel Analytik Modellierung Sprachen Algebra Logik Hardware Denken Kreativität

Zusammenhänge Gesellschaft Wirtschaft Branche Firma

Benutzer


products/Sources/formale Sprachen/C/MariaDB/mysql-test/suite/jp/t/ (MariaDB Server Version 8.1-8.4^©) Datei vom 1.9.2026 mit Größe 9 kB

Quelle jp_create_tbl_ujis.test Sprache: unbekannt

Spracherkennung für: .test vermutete Sprache: SQL {SQL[240] R[120] VDM[100]} [Methode: maximale Elemente, drei Dimensionen]

--source include/have_ujis.inc
--source include/have_innodb.inc

--disable_warnings
DROP TABLE IF EXISTS `��`;
DROP TABLE IF EXISTS `��`;
DROP TABLE IF EXISTS `��`;
DROP TABLE IF EXISTS `��`;
DROP TABLE IF EXISTS `��`;
DROP TABLE IF EXISTS `��`;
DROP TABLE IF EXISTS `��`;
DROP TABLE IF EXISTS `��`;
DROP TABLE IF EXISTS `��`;
DROP TABLE IF EXISTS `��`;
DROP TABLE IF EXISTS `��ݏ�ݏ��`;
DROP TABLE IF EXISTS `��ޏ�ޏ��`;
DROP TABLE IF EXISTS `��ߏ�ߏ��`;
DROP TABLE IF EXISTS `��`;
DROP TABLE IF EXISTS `��`;
--enable_warnings

#
# Test creating table with Japanese characters in ujis encoding
#

SET NAMES ujis;
SET character_set_database = ujis;

CREATE TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=INNODB;
CREATE TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=INNODB;
CREATE TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=INNODB;
CREATE TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=INNODB;
CREATE TABLE `��ݏ�ݏ��`(`��` char(1)) DEFAULT CHARSET = ujis engine=INNODB;
CREATE TABLE `��ޏ�ޏ��`(`��` char(1)) DEFAULT CHARSET = ujis engine=INNODB;
# Tables should not be created because table names exist
CREATE TABLE IF NOT EXISTS `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=INNODB;
CREATE TABLE IF NOT EXISTS `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=INNODB;
CREATE TABLE IF NOT EXISTS `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=INNODB;
CREATE TABLE IF NOT EXISTS `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=INNODB;
CREATE TABLE IF NOT EXISTS `��ݏ�ݏ��`(`��` char(1)) DEFAULT CHARSET = ujis engine=INNODB;
CREATE TABLE IF NOT EXISTS `��ޏ�ޏ��`(`��` char(1)) DEFAULT CHARSET = ujis engine=INNODB;
# Tables should be created
CREATE TABLE IF NOT EXISTS `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=INNODB;
CREATE TABLE IF NOT EXISTS `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=INNODB;
CREATE TABLE IF NOT EXISTS `��ߏ�ߏ��`(`��`char(1)) DEFAULT CHARSET = ujis engine=INNODB;
CREATE TEMPORARY TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=INNODB;
CREATE TEMPORARY TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=INNODB;
CREATE TEMPORARY TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=INNODB;
CREATE TEMPORARY TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=INNODB;
CREATE TEMPORARY TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=INNODB;
CREATE TEMPORARY TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=INNODB;

DESC `��`;
DESC `��`;
DESC `��`;
DESC `��`;
DESC `��`;
DESC `��`;
DESC `��`;
DESC `��`;
DESC `��`;
DESC `��`;
DESC `��ݏ�ݏ��`;
DESC `��ޏ�ޏ��`;
DESC `��ߏ�ߏ��`;
DESC `��`;
DESC `��`;

SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��ݏ�ݏ��`;
SHOW CREATE TABLE `��ޏ�ޏ��`;
SHOW CREATE TABLE `��ߏ�ߏ��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;

DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��ݏ�ݏ��`;
DROP TABLE `��ޏ�ޏ��`;
DROP TABLE `��ߏ�ߏ��`;
DROP TABLE `��`;
DROP TABLE `��`;

CREATE TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MyISAM;
CREATE TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MyISAM;
CREATE TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MyISAM;
CREATE TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MyISAM;
CREATE TABLE `��ݏ�ݏ��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MyISAM;
CREATE TABLE `��ޏ�ޏ��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MyISAM;
# Tables should not be created because table names exist
CREATE TABLE IF NOT EXISTS `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MyISAM;
CREATE TABLE IF NOT EXISTS `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MyISAM;
CREATE TABLE IF NOT EXISTS `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MyISAM;
CREATE TABLE IF NOT EXISTS `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MyISAM;
CREATE TABLE IF NOT EXISTS `��ݏ�ݏ��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MyISAM;
CREATE TABLE IF NOT EXISTS `��ޏ�ޏ��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MyISAM;
# Tables should be created
CREATE TABLE IF NOT EXISTS `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MyISAM;
CREATE TABLE IF NOT EXISTS `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MyISAM;
CREATE TABLE IF NOT EXISTS `��ߏ�ߏ��`(`��`char(1)) DEFAULT CHARSET = ujis engine=MyISAM;
CREATE TEMPORARY TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MyISAM;
CREATE TEMPORARY TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MyISAM;
CREATE TEMPORARY TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MyISAM;
CREATE TEMPORARY TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MyISAM;
CREATE TEMPORARY TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MyISAM;
CREATE TEMPORARY TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MyISAM;

DESC `��`;
DESC `��`;
DESC `��`;
DESC `��`;
DESC `��`;
DESC `��`;
DESC `��`;
DESC `��`;
DESC `��`;
DESC `��`;
DESC `��ݏ�ݏ��`;
DESC `��ޏ�ޏ��`;
DESC `��ߏ�ߏ��`;
DESC `��`;
DESC `��`;

SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��ݏ�ݏ��`;
SHOW CREATE TABLE `��ޏ�ޏ��`;
SHOW CREATE TABLE `��ߏ�ߏ��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;

DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��ݏ�ݏ��`;
DROP TABLE `��ޏ�ޏ��`;
DROP TABLE `��ߏ�ߏ��`;
DROP TABLE `��`;
DROP TABLE `��`;

CREATE TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MEMORY;
CREATE TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MEMORY;
CREATE TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MEMORY;
CREATE TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MEMORY;
CREATE TABLE `��ݏ�ݏ��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MEMORY;
CREATE TABLE `��ޏ�ޏ��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MEMORY;
# Tables should not be created because table names exist
CREATE TABLE IF NOT EXISTS `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MEMORY;
CREATE TABLE IF NOT EXISTS `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MEMORY;
CREATE TABLE IF NOT EXISTS `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MEMORY;
CREATE TABLE IF NOT EXISTS `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MEMORY;
CREATE TABLE IF NOT EXISTS `��ݏ�ݏ��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MEMORY;
CREATE TABLE IF NOT EXISTS `��ޏ�ޏ��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MEMORY;
# Tables should be created
CREATE TABLE IF NOT EXISTS `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MEMORY;
CREATE TABLE IF NOT EXISTS `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MEMORY;
CREATE TABLE IF NOT EXISTS `��ߏ�ߏ��`(`��`char(1)) DEFAULT CHARSET = ujis engine=MEMORY;
CREATE TEMPORARY TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MEMORY;
CREATE TEMPORARY TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MEMORY;
CREATE TEMPORARY TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MEMORY;
CREATE TEMPORARY TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MEMORY;
CREATE TEMPORARY TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MEMORY;
CREATE TEMPORARY TABLE `��`(`��` char(1)) DEFAULT CHARSET = ujis engine=MEMORY;

DESC `��`;
DESC `��`;
DESC `��`;
DESC `��`;
DESC `��`;
DESC `��`;
DESC `��`;
DESC `��`;
DESC `��`;
DESC `��`;
DESC `��ݏ�ݏ��`;
DESC `��ޏ�ޏ��`;
DESC `��ߏ�ߏ��`;
DESC `��`;
DESC `��`;

SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��ݏ�ݏ��`;
SHOW CREATE TABLE `��ޏ�ޏ��`;
SHOW CREATE TABLE `��ߏ�ߏ��`;
SHOW CREATE TABLE `��`;
SHOW CREATE TABLE `��`;

DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��`;
DROP TABLE `��ݏ�ݏ��`;
DROP TABLE `��ޏ�ޏ��`;
DROP TABLE `��ߏ�ߏ��`;
DROP TABLE `��`;
DROP TABLE `��`;