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 6 kB

Quelle jp_like_ujis.test Sprache: unbekannt

Spracherkennung für: .test vermutete Sprache: SQL {SQL[260] ABAP[198] PVS[132]} [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 `�ԣ�`;
--enable_warnings

#
# Test LIKE pattern matching using Japanese characters in ujis encoding
#

SET NAMES ujis;
SET character_set_database = ujis;

CREATE TABLE `�ԣ�` (`�ã�` char(20), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = innodb;
CREATE TABLE `�ԣ�` (`�ã�` char(20), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = innodb;
CREATE TABLE `�ԣ�` (`�ã�` char(20), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = innodb;
CREATE TABLE `�ԣ�` (`�ã�` char(20), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = myisam;
CREATE TABLE `�ԣ�` (`�ã�` char(20), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = myisam;
CREATE TABLE `�ԣ�` (`�ã�` char(20), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = myisam;
CREATE TABLE `�ԣ�` (`�ã�` char(20), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = MEMORY;
CREATE TABLE `�ԣ�` (`�ã�` char(20), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = MEMORY;
CREATE TABLE `�ԣ�` (`�ã�` char(20), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = MEMORY;

#Load the following data in each table
# jisx0201 hankaku-katakana data
# jisx0208 data
# jisx0212 supplemental character data

LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `�ԣ�`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `�ԣ�`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `�ԣ�`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `�ԣ�`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `�ԣ�`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `�ԣ�`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `�ԣ�`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `�ԣ�`;
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `�ԣ�`;

#InnoDB
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE ' %';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '% %';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '% ';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%�׎�%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '��Ï�ď�ŏ�Ə��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��Ï�ď�ŏ�Ə��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��Ï�ď�ŏ�Ə��';

#MyISAM
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE ' %';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '% %';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '% ';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%�׎�%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '��Ï�ď�ŏ�Ə��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��Ï�ď�ŏ�Ə��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��Ï�ď�ŏ�Ə��';

#MEMORY
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE ' %';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '% %';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '% ';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%�׎�%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '��Ï�ď�ŏ�Ə��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��Ï�ď�ŏ�Ə��%';
SELECT * FROM `�ԣ�` WHERE `�ã�` LIKE '%��Ï�ď�ŏ�Ə��';

DROP TABLE `�ԣ�`;
DROP TABLE `�ԣ�`;
DROP TABLE `�ԣ�`;
DROP TABLE `�ԣ�`;
DROP TABLE `�ԣ�`;
DROP TABLE `�ԣ�`;
DROP TABLE `�ԣ�`;
DROP TABLE `�ԣ�`;
DROP TABLE `�ԣ�`;