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


Quellcodebibliothek Statistik Leitseite 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 5 kB

SSL jp_ltrim_ucs2.test Sprache: unbekannt

Spracherkennung für: .test vermutete Sprache: SQL {SQL[235] VDM[95] Lisp[76]} [Methode: maximale Elemente, drei Dimensionen]

--source include/have_ucs2.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 LTRIM() function with Japanese characters in ucs2 encoding
#

SET character_set_collations='ucs2=ucs2_general_ci';
SET NAMES ujis;
SET character_set_database = ucs2;
SET collation_connection = ucs2_general_ci;

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

INSERT INTO `�ԣ�` VALUES ('��');
INSERT INTO `�ԣ�` VALUES (' ��');
INSERT INTO `�ԣ�` VALUES ('  ��');
INSERT INTO `�ԣ�` VALUES ('   ��');
# Double byte spaces are not supposed to be trimed
INSERT INTO `�ԣ�` VALUES ('��');
INSERT INTO `�ԣ�` VALUES ('��');
INSERT INTO `�ԣ�` VALUES ('��');
INSERT INTO `�ԣ�` VALUES ('��');
INSERT INTO `�ԣ�` VALUES (' ��');
INSERT INTO `�ԣ�` VALUES ('  ��');
INSERT INTO `�ԣ�` VALUES ('   ��');
# Double byte spaces are not supposed to be trimed
INSERT INTO `�ԣ�` VALUES ('��');
INSERT INTO `�ԣ�` VALUES ('��');
INSERT INTO `�ԣ�` VALUES ('��');
INSERT INTO `�ԣ�` VALUES ('��܏�ݏ�ޏ�ߏ��');
INSERT INTO `�ԣ�` VALUES (' ��܏�ݏ�ޏ�ߏ��');
INSERT INTO `�ԣ�` VALUES ('  ��܏�ݏ�ޏ�ߏ��');
INSERT INTO `�ԣ�` VALUES ('   ��܏�ݏ�ޏ�ߏ��');
# Double byte spaces are not supposed to be trimed
INSERT INTO `�ԣ�` VALUES ('��܏�ݏ�ޏ�ߏ��');
INSERT INTO `�ԣ�` VALUES ('��܏�ݏ�ޏ�ߏ��');
INSERT INTO `�ԣ�` VALUES ('��܏�ݏ�ޏ�ߏ��');
INSERT INTO `�ԣ�` VALUES ('��');
INSERT INTO `�ԣ�` VALUES (' ��');
INSERT INTO `�ԣ�` VALUES ('  ��');
INSERT INTO `�ԣ�` VALUES ('   ��');
# Double byte spaces are not supposed to be trimed
INSERT INTO `�ԣ�` VALUES ('��');
INSERT INTO `�ԣ�` VALUES ('��');
INSERT INTO `�ԣ�` VALUES ('��');
INSERT INTO `�ԣ�` VALUES ('��');
INSERT INTO `�ԣ�` VALUES (' ��');
INSERT INTO `�ԣ�` VALUES ('  ��');
INSERT INTO `�ԣ�` VALUES ('   ��');
# Double byte spaces are not supposed to be trimed
INSERT INTO `�ԣ�` VALUES ('��');
INSERT INTO `�ԣ�` VALUES ('��');
INSERT INTO `�ԣ�` VALUES ('��');
INSERT INTO `�ԣ�` VALUES ('��܏�ݏ�ޏ�ߏ��');
INSERT INTO `�ԣ�` VALUES (' ��܏�ݏ�ޏ�ߏ��');
INSERT INTO `�ԣ�` VALUES ('  ��܏�ݏ�ޏ�ߏ��');
INSERT INTO `�ԣ�` VALUES ('   ��܏�ݏ�ޏ�ߏ��');
# Double byte spaces are not supposed to be trimed
INSERT INTO `�ԣ�` VALUES ('��܏�ݏ�ޏ�ߏ��');
INSERT INTO `�ԣ�` VALUES ('��܏�ݏ�ޏ�ߏ��');
INSERT INTO `�ԣ�` VALUES ('��܏�ݏ�ޏ�ߏ��');
INSERT INTO `�ԣ�` VALUES ('��');
INSERT INTO `�ԣ�` VALUES (' ��');
INSERT INTO `�ԣ�` VALUES ('  ��');
INSERT INTO `�ԣ�` VALUES ('   ��');
# Double byte spaces are not supposed to be trimed
INSERT INTO `�ԣ�` VALUES ('��');
INSERT INTO `�ԣ�` VALUES ('��');
INSERT INTO `�ԣ�` VALUES ('��');
INSERT INTO `�ԣ�` VALUES ('��');
INSERT INTO `�ԣ�` VALUES (' ��');
INSERT INTO `�ԣ�` VALUES ('  ��');
INSERT INTO `�ԣ�` VALUES ('   ��');
# Double byte spaces are not supposed to be trimed
INSERT INTO `�ԣ�` VALUES ('��');
INSERT INTO `�ԣ�` VALUES ('��');
INSERT INTO `�ԣ�` VALUES ('��');
INSERT INTO `�ԣ�` VALUES ('��܏�ݏ�ޏ�ߏ��');
INSERT INTO `�ԣ�` VALUES (' ��܏�ݏ�ޏ�ߏ��');
INSERT INTO `�ԣ�` VALUES ('  ��܏�ݏ�ޏ�ߏ��');
INSERT INTO `�ԣ�` VALUES ('   ��܏�ݏ�ޏ�ߏ��');
# Double byte spaces are not supposed to be trimed
INSERT INTO `�ԣ�` VALUES ('��܏�ݏ�ޏ�ߏ��');
INSERT INTO `�ԣ�` VALUES ('��܏�ݏ�ޏ�ߏ��');
INSERT INTO `�ԣ�` VALUES ('��܏�ݏ�ޏ�ߏ��');

#InnoDB
SELECT LTRIM(`�ã�`) from `�ԣ�`;
SELECT LTRIM(`�ã�`) from `�ԣ�`;
SELECT LTRIM(`�ã�`) from `�ԣ�`;

#MyISAM
SELECT LTRIM(`�ã�`) from `�ԣ�`;
SELECT LTRIM(`�ã�`) from `�ԣ�`;
SELECT LTRIM(`�ã�`) from `�ԣ�`;

#MEMORY
SELECT LTRIM(`�ã�`) from `�ԣ�`;
SELECT LTRIM(`�ã�`) from `�ԣ�`;
SELECT LTRIM(`�ã�`) from `�ԣ�`;

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