From bab9818c4ba9a636ab1d638c3cf096f90cd66351 Mon Sep 17 00:00:00 2001 From: "Marc G. Fournier" Date: Wed, 29 Apr 1998 12:26:22 +0000 Subject: [PATCH] Missed adding two files from the MultiByte patch... --- src/test/regress/expected/euc_kr.out | 55 ++++++++++++++++++++++++++++++++++++ src/test/regress/sql/euc_kr.sql | 15 ++++++++++ 2 files changed, 70 insertions(+) create mode 100644 src/test/regress/expected/euc_kr.out create mode 100644 src/test/regress/sql/euc_kr.sql diff --git a/src/test/regress/expected/euc_kr.out b/src/test/regress/expected/euc_kr.out new file mode 100644 index 0000000000..56634d5f24 --- /dev/null +++ b/src/test/regress/expected/euc_kr.out @@ -0,0 +1,55 @@ +QUERY: drop table ͪߩѦ¿ë¾î; +ERROR: Relation ͪߩѦ¿ë¾î Does Not Exist! +QUERY: create table ͪߩѦ¿ë¾î (¿ë¾î text, ÝÂ×¾ÄÚµå varchar, ºñ°í1A¶ó±¸ char(16)); +QUERY: create index ͪߩѦ¿ë¾îindex1 on ͪߩѦ¿ë¾î using btree (¿ë¾î); +QUERY: create index ͪߩѦ¿ë¾îindex2 on ͪߩѦ¿ë¾î using hash (ÝÂ×¾ÄÚµå); +QUERY: insert into ͪߩѦ¿ë¾î values('ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ', 'ѦA01ß¾'); +QUERY: insert into ͪߩѦ¿ë¾î values('ÄÄÇ»Åͱ׷¡ÇȽº', 'ÝÂB10ñé'); +QUERY: insert into ͪߩѦ¿ë¾î values('ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó', 'ìÑZ01ù»'); +QUERY: vacuum ͪߩѦ¿ë¾î; +QUERY: select * from ͪߩѦ¿ë¾î; +¿ë¾î |ÝÂ×¾ÄÚµå|ºñ°í1a¶ó±¸ +----------------+--------+---------- +ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ|ѦA01ß¾ | +ÄÄÇ»Åͱ׷¡ÇȽº |ÝÂB10ñé | +ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó|ìÑZ01ù» | +(3 rows) + +QUERY: select * from ͪߩѦ¿ë¾î where ÝÂ×¾ÄÚµå = 'ìÑZ01ù»'; +¿ë¾î |ÝÂ×¾ÄÚµå|ºñ°í1a¶ó±¸ +----------------+--------+---------- +ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó|ìÑZ01ù» | +(1 row) + +QUERY: select * from ͪߩѦ¿ë¾î where ÝÂ×¾ÄÚµå ~* 'ìÑz01ù»'; +¿ë¾î |ÝÂ×¾ÄÚµå|ºñ°í1a¶ó±¸ +----------------+--------+---------- +ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó|ìÑZ01ù» | +(1 row) + +QUERY: select * from ͪߩѦ¿ë¾î where ÝÂ×¾ÄÚµå like '_Z01_'; +¿ë¾î |ÝÂ×¾ÄÚµå|ºñ°í1a¶ó±¸ +----------------+--------+---------- +ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó|ìÑZ01ù» | +(1 row) + +QUERY: select * from ͪߩѦ¿ë¾î where ÝÂ×¾ÄÚµå like '_Z%'; +¿ë¾î |ÝÂ×¾ÄÚµå|ºñ°í1a¶ó±¸ +----------------+--------+---------- +ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó|ìÑZ01ù» | +(1 row) + +QUERY: select * from ͪߩѦ¿ë¾î where ¿ë¾î ~ 'ÄÄÇ»ÅÍ[µð±×]'; +¿ë¾î |ÝÂ×¾ÄÚµå|ºñ°í1a¶ó±¸ +----------------+--------+---------- +ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ|ѦA01ß¾ | +ÄÄÇ»Åͱ׷¡ÇȽº |ÝÂB10ñé | +(2 rows) + +QUERY: select * from ͪߩѦ¿ë¾î where ¿ë¾î ~* 'ÄÄÇ»ÅÍ[µð±×]'; +¿ë¾î |ÝÂ×¾ÄÚµå|ºñ°í1a¶ó±¸ +----------------+--------+---------- +ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ|ѦA01ß¾ | +ÄÄÇ»Åͱ׷¡ÇȽº |ÝÂB10ñé | +(2 rows) + diff --git a/src/test/regress/sql/euc_kr.sql b/src/test/regress/sql/euc_kr.sql new file mode 100644 index 0000000000..034eca8bdb --- /dev/null +++ b/src/test/regress/sql/euc_kr.sql @@ -0,0 +1,15 @@ +drop table ͪߩѦ¿ë¾î; +create table ͪߩѦ¿ë¾î (¿ë¾î text, ÝÂ×¾ÄÚµå varchar, ºñ°í1A¶ó±¸ char(16)); +create index ͪߩѦ¿ë¾îindex1 on ͪߩѦ¿ë¾î using btree (¿ë¾î); +create index ͪߩѦ¿ë¾îindex2 on ͪߩѦ¿ë¾î using hash (ÝÂ×¾ÄÚµå); +insert into ͪߩѦ¿ë¾î values('ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ', 'ѦA01ß¾'); +insert into ͪߩѦ¿ë¾î values('ÄÄÇ»Åͱ׷¡ÇȽº', 'ÝÂB10ñé'); +insert into ͪߩѦ¿ë¾î values('ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó', 'ìÑZ01ù»'); +vacuum ͪߩѦ¿ë¾î; +select * from ͪߩѦ¿ë¾î; +select * from ͪߩѦ¿ë¾î where ÝÂ×¾ÄÚµå = 'ìÑZ01ù»'; +select * from ͪߩѦ¿ë¾î where ÝÂ×¾ÄÚµå ~* 'ìÑz01ù»'; +select * from ͪߩѦ¿ë¾î where ÝÂ×¾ÄÚµå like '_Z01_'; +select * from ͪߩѦ¿ë¾î where ÝÂ×¾ÄÚµå like '_Z%'; +select * from ͪߩѦ¿ë¾î where ¿ë¾î ~ 'ÄÄÇ»ÅÍ[µð±×]'; +select * from ͪߩѦ¿ë¾î where ¿ë¾î ~* 'ÄÄÇ»ÅÍ[µð±×]'; -- 2.11.0