From d0cab7903bf695bf305bd4c01f99e0e28d233d91 Mon Sep 17 00:00:00 2001 From: Heikki Linnakangas Date: Sat, 18 May 2013 22:30:20 +0300 Subject: [PATCH] Remove unused regression test files. euc_* and mule_internal test cases were identical to the ones in src/test/mb. sql_ascii didn't exist elsewhere, but has been broken since 2001, and doesn't seem very interesting anyway. drop.sql hasn't been used since 2000, when regress.sh was removed. --- src/test/regress/expected/euc_cn.out | 87 ----- src/test/regress/expected/euc_jp.out | 87 ----- src/test/regress/expected/euc_kr.out | 87 ----- src/test/regress/expected/euc_tw.out | 85 ----- src/test/regress/expected/mule_internal.out | 333 -------------------- src/test/regress/expected/sql_ascii.out | 87 ----- src/test/regress/sql/drop.sql | 246 --------------- src/test/regress/sql/euc_cn.sql | 19 -- src/test/regress/sql/euc_jp.sql | 19 -- src/test/regress/sql/euc_kr.sql | 19 -- src/test/regress/sql/euc_tw.sql | 20 -- src/test/regress/sql/mule_internal.sql | 72 ----- src/test/regress/sql/sql_ascii.sql | 19 -- 13 files changed, 1180 deletions(-) delete mode 100644 src/test/regress/expected/euc_cn.out delete mode 100644 src/test/regress/expected/euc_jp.out delete mode 100644 src/test/regress/expected/euc_kr.out delete mode 100644 src/test/regress/expected/euc_tw.out delete mode 100644 src/test/regress/expected/mule_internal.out delete mode 100644 src/test/regress/expected/sql_ascii.out delete mode 100644 src/test/regress/sql/drop.sql delete mode 100644 src/test/regress/sql/euc_cn.sql delete mode 100644 src/test/regress/sql/euc_jp.sql delete mode 100644 src/test/regress/sql/euc_kr.sql delete mode 100644 src/test/regress/sql/euc_tw.sql delete mode 100644 src/test/regress/sql/mule_internal.sql delete mode 100644 src/test/regress/sql/sql_ascii.sql diff --git a/src/test/regress/expected/euc_cn.out b/src/test/regress/expected/euc_cn.out deleted file mode 100644 index 7fdb13cfe5..0000000000 --- a/src/test/regress/expected/euc_cn.out +++ /dev/null @@ -1,87 +0,0 @@ -drop table ¼ÆËã»úÊõÓï; -ERROR: Relation '¼ÆËã»úÊõÓï' does not exist -create table ¼ÆËã»úÊõÓï(ÊõÓï text, ·ÖÀàºÅ varchar, ±¸×¢1A char(16)); -create index ¼ÆËã»úÊõÓïindex1 on ¼ÆËã»úÊõÓï using btree(ÊõÓï); -create index ¼ÆËã»úÊõÓïindex2 on ¼ÆËã»úÊõÓï using btree(·ÖÀàºÅ); -insert into ¼ÆËã»úÊõÓï values('µçÄÔÏÔʾÆÁ','»úA01ÉÏ'); -insert into ¼ÆËã»úÊõÓï values('µçÄÔͼÐÎ','·ÖB01ÖÐ'); -insert into ¼ÆËã»úÊõÓï values('µçÄÔ³ÌÐòÔ±','ÈËZ01ÏÂ'); -vacuum ¼ÆËã»úÊõÓï; -select * from ¼ÆËã»úÊõÓï; - ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a -------------+---------+-------- - µçÄÔÏÔʾÆÁ | »úA01ÉÏ | - µçÄÔͼÐÎ | ·ÖB01ÖÐ | - µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | -(3 rows) - -select * from ¼ÆËã»úÊõÓï where ·ÖÀàºÅ = 'ÈËZ01ÏÂ'; - ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a -------------+---------+-------- - µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | -(1 row) - -select * from ¼ÆËã»úÊõÓï where ·ÖÀàºÅ ~* 'ÈËz01ÏÂ'; - ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a -------------+---------+-------- - µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | -(1 row) - -select * from ¼ÆËã»úÊõÓï where ·ÖÀàºÅ like '_Z01_'; - ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a -------------+---------+-------- - µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | -(1 row) - -select * from ¼ÆËã»úÊõÓï where ·ÖÀàºÅ like '_Z%'; - ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a -------------+---------+-------- - µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | -(1 row) - -select * from ¼ÆËã»úÊõÓï where ÊõÓï ~ 'µçÄÔ[ÏÔͼ]'; - ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a -------------+---------+-------- - µçÄÔÏÔʾÆÁ | »úA01ÉÏ | - µçÄÔͼÐÎ | ·ÖB01ÖÐ | -(2 rows) - -select * from ¼ÆËã»úÊõÓï where ÊõÓï ~* 'µçÄÔ[ÏÔͼ]'; - ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a -------------+---------+-------- - µçÄÔÏÔʾÆÁ | »úA01ÉÏ | - µçÄÔͼÐÎ | ·ÖB01ÖÐ | -(2 rows) - -select *,character_length(ÊõÓï) from ¼ÆËã»úÊõÓï; - ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a | char_length -------------+---------+--------+------------- - µçÄÔÏÔʾÆÁ | »úA01ÉÏ | | 5 - µçÄÔͼÐÎ | ·ÖB01ÖÐ | | 4 - µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | | 5 -(3 rows) - -select *,octet_length(ÊõÓï) from ¼ÆËã»úÊõÓï; - ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a | octet_length -------------+---------+--------+-------------- - µçÄÔÏÔʾÆÁ | »úA01ÉÏ | | 10 - µçÄÔͼÐÎ | ·ÖB01ÖÐ | | 8 - µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | | 10 -(3 rows) - -select *,position('ÏÔ' in ÊõÓï) from ¼ÆËã»úÊõÓï; - ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a | strpos -------------+---------+--------+-------- - µçÄÔÏÔʾÆÁ | »úA01ÉÏ | | 3 - µçÄÔͼÐÎ | ·ÖB01ÖÐ | | 0 - µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | | 0 -(3 rows) - -select *,substring(ÊõÓï from 3 for 4) from ¼ÆËã»úÊõÓï; - ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a | substr -------------+---------+--------+-------- - µçÄÔÏÔʾÆÁ | »úA01ÉÏ | | ÏÔʾÆÁ - µçÄÔͼÐÎ | ·ÖB01ÖÐ | | ͼÐÎ - µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | | ³ÌÐòÔ± -(3 rows) - diff --git a/src/test/regress/expected/euc_jp.out b/src/test/regress/expected/euc_jp.out deleted file mode 100644 index f95d283501..0000000000 --- a/src/test/regress/expected/euc_jp.out +++ /dev/null @@ -1,87 +0,0 @@ -drop table ·×»»µ¡ÍѸì; -ERROR: table "·×»»µ¡ÍѸì" is nonexistent -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 ·×»»µ¡ÍѸì; - ÍѸì | ʬÎॳ¡¼¥É | È÷¹Í1a¤À¤è -----------------------------+------------+------------ - ¥³¥ó¥Ô¥å¡¼¥¿¥Ç¥£¥¹¥×¥ì¥¤ | µ¡A01¾å | - ¥³¥ó¥Ô¥å¡¼¥¿¥°¥é¥Õ¥£¥Ã¥¯¥¹ | ʬB10Ãæ | - ¥³¥ó¥Ô¥å¡¼¥¿¥×¥í¥°¥é¥Þ¡¼ | ¿ÍZ01²¼ | -(3 rows) - -select * from ·×»»µ¡ÍѸì where ʬÎॳ¡¼¥É = '¿ÍZ01²¼'; - ÍѸì | ʬÎॳ¡¼¥É | È÷¹Í1a¤À¤è ---------------------------+------------+------------ - ¥³¥ó¥Ô¥å¡¼¥¿¥×¥í¥°¥é¥Þ¡¼ | ¿ÍZ01²¼ | -(1 row) - -select * from ·×»»µ¡ÍѸì where ʬÎॳ¡¼¥É ~* '¿Íz01²¼'; - ÍѸì | ʬÎॳ¡¼¥É | È÷¹Í1a¤À¤è ---------------------------+------------+------------ - ¥³¥ó¥Ô¥å¡¼¥¿¥×¥í¥°¥é¥Þ¡¼ | ¿ÍZ01²¼ | -(1 row) - -select * from ·×»»µ¡ÍѸì where ʬÎॳ¡¼¥É like '_Z01_'; - ÍѸì | ʬÎॳ¡¼¥É | È÷¹Í1a¤À¤è ---------------------------+------------+------------ - ¥³¥ó¥Ô¥å¡¼¥¿¥×¥í¥°¥é¥Þ¡¼ | ¿ÍZ01²¼ | -(1 row) - -select * from ·×»»µ¡ÍѸì where ʬÎॳ¡¼¥É like '_Z%'; - ÍѸì | ʬÎॳ¡¼¥É | È÷¹Í1a¤À¤è ---------------------------+------------+------------ - ¥³¥ó¥Ô¥å¡¼¥¿¥×¥í¥°¥é¥Þ¡¼ | ¿ÍZ01²¼ | -(1 row) - -select * from ·×»»µ¡ÍѸì where ÍѸì ~ '¥³¥ó¥Ô¥å¡¼¥¿[¥Ç¥°]'; - ÍѸì | ʬÎॳ¡¼¥É | È÷¹Í1a¤À¤è -----------------------------+------------+------------ - ¥³¥ó¥Ô¥å¡¼¥¿¥Ç¥£¥¹¥×¥ì¥¤ | µ¡A01¾å | - ¥³¥ó¥Ô¥å¡¼¥¿¥°¥é¥Õ¥£¥Ã¥¯¥¹ | ʬB10Ãæ | -(2 rows) - -select * from ·×»»µ¡ÍѸì where ÍѸì ~* '¥³¥ó¥Ô¥å¡¼¥¿[¥Ç¥°]'; - ÍѸì | ʬÎॳ¡¼¥É | È÷¹Í1a¤À¤è -----------------------------+------------+------------ - ¥³¥ó¥Ô¥å¡¼¥¿¥Ç¥£¥¹¥×¥ì¥¤ | µ¡A01¾å | - ¥³¥ó¥Ô¥å¡¼¥¿¥°¥é¥Õ¥£¥Ã¥¯¥¹ | ʬB10Ãæ | -(2 rows) - -select *,character_length(ÍѸì) from ·×»»µ¡ÍѸì; - ÍѸì | ʬÎॳ¡¼¥É | È÷¹Í1a¤À¤è | char_length -----------------------------+------------+------------+------------- - ¥³¥ó¥Ô¥å¡¼¥¿¥Ç¥£¥¹¥×¥ì¥¤ | µ¡A01¾å | | 12 - ¥³¥ó¥Ô¥å¡¼¥¿¥°¥é¥Õ¥£¥Ã¥¯¥¹ | ʬB10Ãæ | | 13 - ¥³¥ó¥Ô¥å¡¼¥¿¥×¥í¥°¥é¥Þ¡¼ | ¿ÍZ01²¼ | | 12 -(3 rows) - -select *,octet_length(ÍѸì) from ·×»»µ¡ÍѸì; - ÍѸì | ʬÎॳ¡¼¥É | È÷¹Í1a¤À¤è | octet_length -----------------------------+------------+------------+-------------- - ¥³¥ó¥Ô¥å¡¼¥¿¥Ç¥£¥¹¥×¥ì¥¤ | µ¡A01¾å | | 24 - ¥³¥ó¥Ô¥å¡¼¥¿¥°¥é¥Õ¥£¥Ã¥¯¥¹ | ʬB10Ãæ | | 26 - ¥³¥ó¥Ô¥å¡¼¥¿¥×¥í¥°¥é¥Þ¡¼ | ¿ÍZ01²¼ | | 24 -(3 rows) - -select *,position('¥Ç' in ÍѸì) from ·×»»µ¡ÍѸì; - ÍѸì | ʬÎॳ¡¼¥É | È÷¹Í1a¤À¤è | strpos -----------------------------+------------+------------+-------- - ¥³¥ó¥Ô¥å¡¼¥¿¥Ç¥£¥¹¥×¥ì¥¤ | µ¡A01¾å | | 7 - ¥³¥ó¥Ô¥å¡¼¥¿¥°¥é¥Õ¥£¥Ã¥¯¥¹ | ʬB10Ãæ | | 0 - ¥³¥ó¥Ô¥å¡¼¥¿¥×¥í¥°¥é¥Þ¡¼ | ¿ÍZ01²¼ | | 0 -(3 rows) - -select *,substring(ÍѸì from 10 for 4) from ·×»»µ¡ÍѸì; - ÍѸì | ʬÎॳ¡¼¥É | È÷¹Í1a¤À¤è | substr -----------------------------+------------+------------+---------- - ¥³¥ó¥Ô¥å¡¼¥¿¥Ç¥£¥¹¥×¥ì¥¤ | µ¡A01¾å | | ¥×¥ì¥¤ - ¥³¥ó¥Ô¥å¡¼¥¿¥°¥é¥Õ¥£¥Ã¥¯¥¹ | ʬB10Ãæ | | ¥£¥Ã¥¯¥¹ - ¥³¥ó¥Ô¥å¡¼¥¿¥×¥í¥°¥é¥Þ¡¼ | ¿ÍZ01²¼ | | ¥é¥Þ¡¼ -(3 rows) - diff --git a/src/test/regress/expected/euc_kr.out b/src/test/regress/expected/euc_kr.out deleted file mode 100644 index 368525b220..0000000000 --- a/src/test/regress/expected/euc_kr.out +++ /dev/null @@ -1,87 +0,0 @@ -drop table ͪߩѦ¿ë¾î; -ERROR: Relation 'ͪߩѦ¿ë¾î' does not exist -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 ͪߩѦ¿ë¾î; - ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ -------------------+----------+------------ - ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ | ѦA01ß¾ | - ÄÄÇ»Åͱ׷¡ÇȽº | ÝÂB10ñé | - ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | -(3 rows) - -select * from ͪߩѦ¿ë¾î where ÝÂ×¾ÄÚµå = 'ìÑZ01ù»'; - ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ -------------------+----------+------------ - ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | -(1 row) - -select * from ͪߩѦ¿ë¾î where ÝÂ×¾ÄÚµå ~* 'ìÑz01ù»'; - ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ -------------------+----------+------------ - ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | -(1 row) - -select * from ͪߩѦ¿ë¾î where ÝÂ×¾ÄÚµå like '_Z01_'; - ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ -------------------+----------+------------ - ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | -(1 row) - -select * from ͪߩѦ¿ë¾î where ÝÂ×¾ÄÚµå like '_Z%'; - ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ -------------------+----------+------------ - ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | -(1 row) - -select * from ͪߩѦ¿ë¾î where ¿ë¾î ~ 'ÄÄÇ»ÅÍ[µð±×]'; - ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ -------------------+----------+------------ - ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ | ѦA01ß¾ | - ÄÄÇ»Åͱ׷¡ÇȽº | ÝÂB10ñé | -(2 rows) - -select * from ͪߩѦ¿ë¾î where ¿ë¾î ~* 'ÄÄÇ»ÅÍ[µð±×]'; - ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ -------------------+----------+------------ - ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ | ѦA01ß¾ | - ÄÄÇ»Åͱ׷¡ÇȽº | ÝÂB10ñé | -(2 rows) - -select *,character_length(¿ë¾î) from ͪߩѦ¿ë¾î; - ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ | char_length -------------------+----------+------------+------------- - ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ | ѦA01ß¾ | | 8 - ÄÄÇ»Åͱ׷¡ÇȽº | ÝÂB10ñé | | 7 - ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | | 8 -(3 rows) - -select *,octet_length(¿ë¾î) from ͪߩѦ¿ë¾î; - ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ | octet_length -------------------+----------+------------+-------------- - ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ | ѦA01ß¾ | | 16 - ÄÄÇ»Åͱ׷¡ÇȽº | ÝÂB10ñé | | 14 - ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | | 16 -(3 rows) - -select *,position('µð' in ¿ë¾î) from ͪߩѦ¿ë¾î; - ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ | strpos -------------------+----------+------------+-------- - ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ | ѦA01ß¾ | | 4 - ÄÄÇ»Åͱ׷¡ÇȽº | ÝÂB10ñé | | 0 - ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | | 0 -(3 rows) - -select *,substring(¿ë¾î from 3 for 4) from ͪߩѦ¿ë¾î; - ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ | substr -------------------+----------+------------+---------- - ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ | ѦA01ß¾ | | Å͵ð½ºÇà - ÄÄÇ»Åͱ׷¡ÇȽº | ÝÂB10ñé | | Åͱ׷¡ÇÈ - ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | | ÅÍÇÁ·Î±× -(3 rows) - diff --git a/src/test/regress/expected/euc_tw.out b/src/test/regress/expected/euc_tw.out deleted file mode 100644 index cf855809ab..0000000000 --- a/src/test/regress/expected/euc_tw.out +++ /dev/null @@ -1,85 +0,0 @@ -drop table ìÞÙ¸æñÕè; -ERROR: Relation 'ìÞÙ¸æñÕè' does not exist -create table ìÞÙ¸æñÕè (ÈçäÆɱ text, ÄüƳÍñó¤ varchar, ÇâÉß varchar(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 ìÞÙ¸æñÕè; - ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß ---------+------------------+--------- - çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî - êûÝßäÆ | ØÂäãÈ´ÓîÄüƳ | ÄãB10Äã - ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ -(3 rows) - -select * from ìÞÙ¸æñÕè where ÇâÉß = 'ØíZ01Ħ'; - ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß ---------+------------------+--------- - ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ -(1 row) - -select * from ìÞÙ¸æñÕè where ÇâÉß ~* 'Øíz01Ħ'; - ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß ---------+------------------+--------- - ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ -(1 row) - -select * from ìÞÙ¸æñÕè where ÇâÉß like '_Z01_'; - ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß ---------+------------------+--------- - ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ -(1 row) - -select * from ìÞÙ¸æñÕè where ÇâÉß like '_Z%'; - ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß ---------+------------------+--------- - ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ -(1 row) - -select * from ìÞÙ¸æñÕè where ÄüƳÍñó¤ ~ 'ç®ç®Òï[ÙìØ´ÊÀ]'; - ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß ---------+----------+--------- - çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî -(1 row) - -select * from ìÞÙ¸æñÕè where ÄüƳÍñó¤ ~* 'ç®ç®Òï[ÙìØ´ÊÀ]'; - ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß ---------+----------+--------- - çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî -(1 row) - -select *, character_length(ÈçäÆɱ) from ìÞÙ¸æñÕè; - ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß | char_length ---------+------------------+---------+------------- - çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî | 3 - êûÝßäÆ | ØÂäãÈ´ÓîÄüƳ | ÄãB10Äã | 3 - ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ | 3 -(3 rows) - -select *, octet_length(ÈçäÆɱ) from ìÞÙ¸æñÕè; - ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß | octet_length ---------+------------------+---------+-------------- - çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî | 6 - êûÝßäÆ | ØÂäãÈ´ÓîÄüƳ | ÄãB10Äã | 6 - ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ | 6 -(3 rows) - -select *, position('È´Óî' in ÄüƳÍñó¤) from ìÞÙ¸æñÕè; - ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß | strpos ---------+------------------+---------+-------- - çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî | 0 - êûÝßäÆ | ØÂäãÈ´ÓîÄüƳ | ÄãB10Äã | 3 - ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ | 5 -(3 rows) - -select *, substring(ÄüƳÍñó¤ from 3 for 6 ) from ìÞÙ¸æñÕè; - ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß | substr ---------+------------------+---------+-------------- - çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî | ÒïÊÀ - êûÝßäÆ | ØÂäãÈ´ÓîÄüƳ | ÄãB10Äã | È´ÓîÄüƳ - ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ | ϴǹȴÓîÄüƳ -(3 rows) - diff --git a/src/test/regress/expected/mule_internal.out b/src/test/regress/expected/mule_internal.out deleted file mode 100644 index bfcffc8490..0000000000 --- a/src/test/regress/expected/mule_internal.out +++ /dev/null @@ -1,333 +0,0 @@ -drop table ’·×’»»’µ¡’Íђ¸ì; -ERROR: Relation '’·×’»»’µ¡’Íђ¸ì' does not exist -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 ’·×’»»’µ¡’Íђ¸ì; - ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è ------------------------------------------+-----------------+---------------- - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ | - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | -(3 rows) - -select * from ’·×’»»’µ¡’Íђ¸ì where ’ʬ’Îà’¥³’¡¼’¥É = '’¿ÍZ01’²¼'; - ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è ---------------------------------------+-----------------+---------------- - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | -(1 row) - -select * from ’·×’»»’µ¡’Íђ¸ì where ’ʬ’Îà’¥³’¡¼’¥É ~* '’¿Íz01’²¼'; - ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è ---------------------------------------+-----------------+---------------- - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | -(1 row) - -select * from ’·×’»»’µ¡’Íђ¸ì where ’ʬ’Îà’¥³’¡¼’¥É like '_Z01_'; - ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è ---------------------------------------+-----------------+---------------- - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | -(1 row) - -select * from ’·×’»»’µ¡’Íђ¸ì where ’ʬ’Îà’¥³’¡¼’¥É like '_Z%'; - ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è ---------------------------------------+-----------------+---------------- - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | -(1 row) - -select * from ’·×’»»’µ¡’Íђ¸ì where ’Íђ¸ì ~ '’¥³’¥ó’¥Ô’¥å’¡¼’¥¿[’¥Ç’¥°]'; - ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è ------------------------------------------+-----------------+---------------- - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ | -(2 rows) - -select * from ’·×’»»’µ¡’Íђ¸ì where ’Íђ¸ì ~* '’¥³’¥ó’¥Ô’¥å’¡¼’¥¿[’¥Ç’¥°]'; - ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è ------------------------------------------+-----------------+---------------- - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ | -(2 rows) - -select *,character_length(’Íђ¸ì) from ’·×’»»’µ¡’Íђ¸ì; - ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è | char_length ------------------------------------------+-----------------+----------------+------------- - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | | 12 - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ | | 13 - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | | 12 -(3 rows) - -select *,octet_length(’Íђ¸ì) from ’·×’»»’µ¡’Íђ¸ì; - ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è | octet_length ------------------------------------------+-----------------+----------------+-------------- - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | | 36 - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ | | 39 - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | | 36 -(3 rows) - -select *,position('’¥Ç' in ’Íђ¸ì) from ’·×’»»’µ¡’Íђ¸ì; - ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è | strpos ------------------------------------------+-----------------+----------------+-------- - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | | 7 - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ | | 0 - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | | 0 -(3 rows) - -select *,substring(’Íђ¸ì from 10 for 4) from ’·×’»»’µ¡’Íђ¸ì; - ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è | substr ------------------------------------------+-----------------+----------------+-------------- - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | | ’¥×’¥ì’¥¤ - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ | | ’¥£’¥Ã’¥¯’¥¹ - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | | ’¥é’¥Þ’¡¼ -(3 rows) - -drop table ‘¼Æ‘Ë㑻ú‘Êõ‘Óï; -ERROR: Relation '‘¼Æ‘Ë㑻ú‘Êõ‘Óï' does not exist -create table ‘¼Æ‘Ë㑻ú‘Êõ‘Óï(‘Êõ‘Óï text, ‘·Ö‘Àà‘ºÅ varchar, ‘±¸‘×¢1A char(16)); -create index ‘¼Æ‘Ë㑻ú‘Êõ‘Óïindex1 on ‘¼Æ‘Ë㑻ú‘Êõ‘Óï using btree(‘Êõ‘Óï); -create index ‘¼Æ‘Ë㑻ú‘Êõ‘Óïindex2 on ‘¼Æ‘Ë㑻ú‘Êõ‘Óï using btree(‘·Ö‘Àà‘ºÅ); -insert into ‘¼Æ‘Ë㑻ú‘Êõ‘Óï values('‘µç‘ÄԑÏԑʾ‘ÆÁ','‘»úA01‘ÉÏ'); -insert into ‘¼Æ‘Ë㑻ú‘Êõ‘Óï values('‘µç‘Äԑͼ‘ÐÎ','‘·ÖB01‘ÖÐ'); -insert into ‘¼Æ‘Ë㑻ú‘Êõ‘Óï values('‘µç‘Äԑ³Ì‘Ðò‘Ô±','‘ÈËZ01‘ÏÂ'); -vacuum ‘¼Æ‘Ë㑻ú‘Êõ‘Óï; -select * from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï; - ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a ------------------+-----------+---------- - ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | - ‘µç‘Äԑͼ‘ÐÎ | ‘·ÖB01‘ÖÐ | - ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | -(3 rows) - -select * from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï where ‘·Ö‘Àà‘ºÅ = '‘ÈËZ01‘ÏÂ'; - ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a ------------------+-----------+---------- - ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | -(1 row) - -select * from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï where ‘·Ö‘Àà‘ºÅ ~* '‘ÈËz01‘ÏÂ'; - ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a ------------------+-----------+---------- - ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | -(1 row) - -select * from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï where ‘·Ö‘Àà‘ºÅ like '_Z01_'; - ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a ------------------+-----------+---------- - ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | -(1 row) - -select * from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï where ‘·Ö‘Àà‘ºÅ like '_Z%'; - ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a ------------------+-----------+---------- - ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | -(1 row) - -select * from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï where ‘Êõ‘Óï ~ '‘µç‘ÄÔ[‘Ïԑͼ]'; - ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a ------------------+-----------+---------- - ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | - ‘µç‘Äԑͼ‘ÐÎ | ‘·ÖB01‘ÖÐ | -(2 rows) - -select * from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï where ‘Êõ‘Óï ~* '‘µç‘ÄÔ[‘Ïԑͼ]'; - ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a ------------------+-----------+---------- - ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | - ‘µç‘Äԑͼ‘ÐÎ | ‘·ÖB01‘ÖÐ | -(2 rows) - -select *,character_length(‘Êõ‘Óï) from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï; - ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a | char_length ------------------+-----------+----------+------------- - ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | | 5 - ‘µç‘Äԑͼ‘ÐÎ | ‘·ÖB01‘ÖÐ | | 4 - ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | | 5 -(3 rows) - -select *,octet_length(‘Êõ‘Óï) from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï; - ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a | octet_length ------------------+-----------+----------+-------------- - ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | | 15 - ‘µç‘Äԑͼ‘ÐÎ | ‘·ÖB01‘ÖÐ | | 12 - ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | | 15 -(3 rows) - -select *,position('‘ÏÔ' in ‘Êõ‘Óï) from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï; - ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a | strpos ------------------+-----------+----------+-------- - ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | | 3 - ‘µç‘Äԑͼ‘ÐÎ | ‘·ÖB01‘ÖÐ | | 0 - ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | | 0 -(3 rows) - -select *,substring(‘Êõ‘Óï from 3 for 4) from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï; - ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a | substr ------------------+-----------+----------+----------- - ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | | ‘Ïԑʾ‘ÆÁ - ‘µç‘Äԑͼ‘ÐÎ | ‘·ÖB01‘ÖÐ | | ‘ͼ‘ÐÎ - ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | | ‘³Ì‘Ðò‘Ô± -(3 rows) - -drop table “ͪ“ß©“Ѧ“¿ë“¾î; -ERROR: Relation '“ͪ“ß©“Ѧ“¿ë“¾î' does not exist -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 “ͪ“ß©“Ѧ“¿ë“¾î; - “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ ---------------------------+--------------+---------------- - “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | - “Äēǻ“Å͓±×“·¡“Çȓ½º | “ÝÂB10“ñé | - “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | -(3 rows) - -select * from “ͪ“ß©“Ѧ“¿ë“¾î where “Ý“׾“Äړµå = '“ìÑZ01“ù»'; - “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ ---------------------------+--------------+---------------- - “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | -(1 row) - -select * from “ͪ“ß©“Ѧ“¿ë“¾î where “Ý“׾“Äړµå ~* '“ìÑz01“ù»'; - “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ ---------------------------+--------------+---------------- - “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | -(1 row) - -select * from “ͪ“ß©“Ѧ“¿ë“¾î where “Ý“׾“Äړµå like '_Z01_'; - “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ ---------------------------+--------------+---------------- - “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | -(1 row) - -select * from “ͪ“ß©“Ѧ“¿ë“¾î where “Ý“׾“Äړµå like '_Z%'; - “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ ---------------------------+--------------+---------------- - “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | -(1 row) - -select * from “ͪ“ß©“Ѧ“¿ë“¾î where “¿ë“¾î ~ '“Äēǻ“ÅÍ[“µð“±×]'; - “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ ---------------------------+--------------+---------------- - “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | - “Äēǻ“Å͓±×“·¡“Çȓ½º | “ÝÂB10“ñé | -(2 rows) - -select * from “ͪ“ß©“Ѧ“¿ë“¾î where “¿ë“¾î ~* '“Äēǻ“ÅÍ[“µð“±×]'; - “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ ---------------------------+--------------+---------------- - “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | - “Äēǻ“Å͓±×“·¡“Çȓ½º | “ÝÂB10“ñé | -(2 rows) - -select *,character_length(“¿ë“¾î) from “ͪ“ß©“Ѧ“¿ë“¾î; - “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ | char_length ---------------------------+--------------+----------------+------------- - “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | | 8 - “Äēǻ“Å͓±×“·¡“Çȓ½º | “ÝÂB10“ñé | | 7 - “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | | 8 -(3 rows) - -select *,octet_length(“¿ë“¾î) from “ͪ“ß©“Ѧ“¿ë“¾î; - “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ | octet_length ---------------------------+--------------+----------------+-------------- - “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | | 24 - “Äēǻ“Å͓±×“·¡“Çȓ½º | “ÝÂB10“ñé | | 21 - “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | | 24 -(3 rows) - -select *,position('“µð' in “¿ë“¾î) from “ͪ“ß©“Ѧ“¿ë“¾î; - “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ | strpos ---------------------------+--------------+----------------+-------- - “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | | 4 - “Äēǻ“Å͓±×“·¡“Çȓ½º | “ÝÂB10“ñé | | 0 - “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | | 0 -(3 rows) - -select *,substring(“¿ë“¾î from 3 for 4) from “ͪ“ß©“Ѧ“¿ë“¾î; - “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ | substr ---------------------------+--------------+----------------+-------------- - “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | | “Å͓µð“½º“Çà - “Äēǻ“Å͓±×“·¡“Çȓ½º | “ÝÂB10“ñé | | “Å͓±×“·¡“ÇÈ - “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | | “Å͓ÇÁ“·Î“±× -(3 rows) - -drop table test; -ERROR: Relation 'test' does not exist -create table test (t text); -insert into test values('ENGLISH'); -insert into test values('FRANÇAIS'); -insert into test values('ESPAÑOL'); -insert into test values('ÍSLENSKA'); -insert into test values('ENGLISH FRANÇAIS ESPAÑOL ÍSLENSKA'); -vacuum test; -select * from test; - t --------------------------------------- - ENGLISH - FRANÇAIS - ESPAÑOL - ÍSLENSKA - ENGLISH FRANÇAIS ESPAÑOL ÍSLENSKA -(5 rows) - -select * from test where t = 'ESPAÑOL'; - t ----------- - ESPAÑOL -(1 row) - -select * from test where t ~* 'espaÑol'; - t --------------------------------------- - ESPAÑOL - ENGLISH FRANÇAIS ESPAÑOL ÍSLENSKA -(2 rows) - -select *,character_length(t) from test; - t | char_length ---------------------------------------+------------- - ENGLISH | 7 - FRANÇAIS | 8 - ESPAÑOL | 7 - ÍSLENSKA | 8 - ENGLISH FRANÇAIS ESPAÑOL ÍSLENSKA | 33 -(5 rows) - -select *,octet_length(t) from test; - t | octet_length ---------------------------------------+-------------- - ENGLISH | 7 - FRANÇAIS | 9 - ESPAÑOL | 8 - ÍSLENSKA | 9 - ENGLISH FRANÇAIS ESPAÑOL ÍSLENSKA | 36 -(5 rows) - -select *,position('L' in t) from test; - t | strpos ---------------------------------------+-------- - ENGLISH | 4 - FRANÇAIS | 0 - ESPAÑOL | 7 - ÍSLENSKA | 3 - ENGLISH FRANÇAIS ESPAÑOL ÍSLENSKA | 4 -(5 rows) - -select *,substring(t from 3 for 4) from test; - t | substr ---------------------------------------+-------- - ENGLISH | GLIS - FRANÇAIS | ANÇA - ESPAÑOL | PAÑO - ÍSLENSKA | LENS - ENGLISH FRANÇAIS ESPAÑOL ÍSLENSKA | GLIS -(5 rows) - diff --git a/src/test/regress/expected/sql_ascii.out b/src/test/regress/expected/sql_ascii.out deleted file mode 100644 index 5b7c03575f..0000000000 --- a/src/test/regress/expected/sql_ascii.out +++ /dev/null @@ -1,87 +0,0 @@ -drop table computer_terms; -ERROR: Relation 'computer_terms' does not exist -create table computer_terms(term text, category text, comments char(16)); -create index computer_terms_index1 on computer_terms using btree(term); -create index computer_terms_index2 on computer_terms using btree(category); -insert into computer_terms values('computer display', 'X-A01-Y', 'a comment 1'); -insert into computer_terms values('computer graphics', 'T-B01-Y', 'a comment 2'); -insert into computer_terms values('computer programmer', 'S-Z01-Y', 'a comment 3'); -vacuum computer_terms; -select * from computer_terms; - term | category | comments ----------------------+----------+------------------ - computer display | X-A01-Y | a comment 1 - computer graphics | T-B01-Y | a comment 2 - computer programmer | S-Z01-Y | a comment 3 -(3 rows) - -select * from computer_terms where category = 'X-A01-Y'; - term | category | comments -------------------+----------+------------------ - computer display | X-A01-Y | a comment 1 -(1 row) - -select * from computer_terms where category ~* 'x-a01-y'; - term | category | comments -------------------+----------+------------------ - computer display | X-A01-Y | a comment 1 -(1 row) - -select * from computer_terms where category like '_-A01-_'; - term | category | comments -------------------+----------+------------------ - computer display | X-A01-Y | a comment 1 -(1 row) - -select * from computer_terms where category like '_-A%'; - term | category | comments -------------------+----------+------------------ - computer display | X-A01-Y | a comment 1 -(1 row) - -select * from computer_terms where term ~ 'computer [dg]'; - term | category | comments --------------------+----------+------------------ - computer display | X-A01-Y | a comment 1 - computer graphics | T-B01-Y | a comment 2 -(2 rows) - -select * from computer_terms where term ~* 'computer [DG]'; - term | category | comments --------------------+----------+------------------ - computer display | X-A01-Y | a comment 1 - computer graphics | T-B01-Y | a comment 2 -(2 rows) - -select *,character_length(term) from computer_terms; - term | category | comments | char_length ----------------------+----------+------------------+------------- - computer display | X-A01-Y | a comment 1 | 16 - computer graphics | T-B01-Y | a comment 2 | 17 - computer programmer | S-Z01-Y | a comment 3 | 19 -(3 rows) - -select *,octet_length(term) from computer_terms; - term | category | comments | octet_length ----------------------+----------+------------------+-------------- - computer display | X-A01-Y | a comment 1 | 16 - computer graphics | T-B01-Y | a comment 2 | 17 - computer programmer | S-Z01-Y | a comment 3 | 19 -(3 rows) - -select *,position('s' in term) from computer_terms; - term | category | comments | strpos ----------------------+----------+------------------+-------- - computer display | X-A01-Y | a comment 1 | 12 - computer graphics | T-B01-Y | a comment 2 | 17 - computer programmer | S-Z01-Y | a comment 3 | 0 -(3 rows) - -select *,substring(term from 10 for 4) from computer_terms; - term | category | comments | substr ----------------------+----------+------------------+-------- - computer display | X-A01-Y | a comment 1 | disp - computer graphics | T-B01-Y | a comment 2 | grap - computer programmer | S-Z01-Y | a comment 3 | prog -(3 rows) - diff --git a/src/test/regress/sql/drop.sql b/src/test/regress/sql/drop.sql deleted file mode 100644 index da9297d8b6..0000000000 --- a/src/test/regress/sql/drop.sql +++ /dev/null @@ -1,246 +0,0 @@ --- --- drop.source --- - --- --- this will fail if the user is not the postgres superuser. --- if it does, don't worry about it (you can turn usersuper --- back on as "postgres"). too many people don't follow --- directions and run this as "postgres", though... --- -UPDATE pg_user - SET usesuper = 't'::bool - WHERE usename = 'postgres'; - - --- --- FUNCTION REMOVAL --- -DROP FUNCTION hobbies(person); - -DROP FUNCTION hobby_construct(text,text); - -DROP FUNCTION equipment(hobbies_r); - -DROP FUNCTION user_relns(); - -DROP FUNCTION widget_in(cstring); - -DROP FUNCTION widget_out(widget); - -DROP FUNCTION pt_in_widget(point,widget); - -DROP FUNCTION overpaid(emp); - -DROP FUNCTION boxarea(box); - -DROP FUNCTION interpt_pp(path,path); - -DROP FUNCTION reverse_name(name); - -DROP FUNCTION oldstyle_length(int4, text); - --- --- OPERATOR REMOVAL --- -DROP OPERATOR ## (path, path); - -DROP OPERATOR <% (point, widget); - --- left unary -DROP OPERATOR @#@ (none, int4); - --- right unary -DROP OPERATOR #@# (int4, none); - --- right unary -DROP OPERATOR #%# (int4, none); - - --- --- ABSTRACT DATA TYPE REMOVAL --- -DROP TYPE city_budget; - -DROP TYPE widget; - - --- --- RULE REMOVAL --- (is also tested in queries.source) --- - --- --- AGGREGATE REMOVAL --- -DROP AGGREGATE newavg (int4); - -DROP AGGREGATE newsum (int4); - -DROP AGGREGATE newcnt (int4); - - --- --- CLASS REMOVAL --- (inheritance hierarchies are deleted in reverse order) --- - --- --- DROP ancillary data structures (i.e. indices) --- -DROP INDEX onek_unique1; - -DROP INDEX onek_unique2; - -DROP INDEX onek_hundred; - -DROP INDEX onek_stringu1; - -DROP INDEX tenk1_unique1; - -DROP INDEX tenk1_unique2; - -DROP INDEX tenk1_hundred; - -DROP INDEX tenk2_unique1; - -DROP INDEX tenk2_unique2; - -DROP INDEX tenk2_hundred; - --- DROP INDEX onek2_u1_prtl; - --- DROP INDEX onek2_u2_prtl; - --- DROP INDEX onek2_stu1_prtl; - -DROP INDEX rect2ind; - -DROP INDEX rix; - -DROP INDEX iix; - -DROP INDEX six; - -DROP INDEX hash_i4_index; - -DROP INDEX hash_name_index; - -DROP INDEX hash_txt_index; - -DROP INDEX hash_f8_index; - --- DROP INDEX hash_ovfl_index; - -DROP INDEX bt_i4_index; - -DROP INDEX bt_name_index; - -DROP INDEX bt_txt_index; - -DROP INDEX bt_f8_index; - - -DROP TABLE onek; - -DROP TABLE onek2; - -DROP TABLE tenk1; - -DROP TABLE tenk2; - -DROP TABLE Bprime; - - -DROP TABLE hobbies_r; - -DROP TABLE equipment_r; - - -DROP TABLE aggtest; - -DROP TABLE xacttest; - -DROP TABLE arrtest; - -DROP TABLE iportaltest; - - -DROP TABLE f_star; - -DROP TABLE e_star; - -DROP TABLE d_star; - -DROP TABLE c_star; - -DROP TABLE b_star; - -DROP TABLE a_star; - - --- --- must be in reverse inheritance order --- -DROP TABLE stud_emp; - -DROP TABLE student; - -DROP TABLE slow_emp4000; - -DROP TABLE fast_emp4000; - -DROP TABLE emp; - -DROP TABLE person; - - -DROP TABLE ramp; - -DROP TABLE real_city; - -DROP TABLE dept; - -DROP TABLE ihighway; - -DROP TABLE shighway; - -DROP TABLE road; - -DROP TABLE city; - - -DROP TABLE hash_i4_heap; - -DROP TABLE hash_name_heap; - -DROP TABLE hash_txt_heap; - -DROP TABLE hash_f8_heap; - --- DROP TABLE hash_ovfl_heap; - -DROP TABLE bt_i4_heap; - -DROP TABLE bt_name_heap; - -DROP TABLE bt_txt_heap; - -DROP TABLE bt_f8_heap; - - -DROP TABLE ABSTIME_TBL; - -DROP TABLE RELTIME_TBL; - -DROP TABLE TINTERVAL_TBL; - --- --- VIRTUAL CLASS REMOVAL --- (also tests removal of rewrite rules) --- -DROP VIEW street; - -DROP VIEW iexit; - -DROP VIEW toyemp; diff --git a/src/test/regress/sql/euc_cn.sql b/src/test/regress/sql/euc_cn.sql deleted file mode 100644 index 7cd0b9b0e2..0000000000 --- a/src/test/regress/sql/euc_cn.sql +++ /dev/null @@ -1,19 +0,0 @@ -drop table ¼ÆËã»úÊõÓï; -create table ¼ÆËã»úÊõÓï(ÊõÓï text, ·ÖÀàºÅ varchar, ±¸×¢1A char(16)); -create index ¼ÆËã»úÊõÓïindex1 on ¼ÆËã»úÊõÓï using btree(ÊõÓï); -create index ¼ÆËã»úÊõÓïindex2 on ¼ÆËã»úÊõÓï using btree(·ÖÀàºÅ); -insert into ¼ÆËã»úÊõÓï values('µçÄÔÏÔʾÆÁ','»úA01ÉÏ'); -insert into ¼ÆËã»úÊõÓï values('µçÄÔͼÐÎ','·ÖB01ÖÐ'); -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 ÊõÓï ~* 'µçÄÔ[ÏÔͼ]'; -select *,character_length(ÊõÓï) from ¼ÆËã»úÊõÓï; -select *,octet_length(ÊõÓï) from ¼ÆËã»úÊõÓï; -select *,position('ÏÔ' in ÊõÓï) from ¼ÆËã»úÊõÓï; -select *,substring(ÊõÓï from 3 for 4) from ¼ÆËã»úÊõÓï; diff --git a/src/test/regress/sql/euc_jp.sql b/src/test/regress/sql/euc_jp.sql deleted file mode 100644 index 2021205bf4..0000000000 --- a/src/test/regress/sql/euc_jp.sql +++ /dev/null @@ -1,19 +0,0 @@ -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 ÍѸì ~* '¥³¥ó¥Ô¥å¡¼¥¿[¥Ç¥°]'; -select *,character_length(ÍѸì) from ·×»»µ¡ÍѸì; -select *,octet_length(ÍѸì) from ·×»»µ¡ÍѸì; -select *,position('¥Ç' in ÍѸì) from ·×»»µ¡ÍѸì; -select *,substring(ÍѸì from 10 for 4) from ·×»»µ¡ÍѸì; diff --git a/src/test/regress/sql/euc_kr.sql b/src/test/regress/sql/euc_kr.sql deleted file mode 100644 index cf9e07fd1c..0000000000 --- a/src/test/regress/sql/euc_kr.sql +++ /dev/null @@ -1,19 +0,0 @@ -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 ¿ë¾î ~* 'ÄÄÇ»ÅÍ[µð±×]'; -select *,character_length(¿ë¾î) from ͪߩѦ¿ë¾î; -select *,octet_length(¿ë¾î) from ͪߩѦ¿ë¾î; -select *,position('µð' in ¿ë¾î) from ͪߩѦ¿ë¾î; -select *,substring(¿ë¾î from 3 for 4) from ͪߩѦ¿ë¾î; diff --git a/src/test/regress/sql/euc_tw.sql b/src/test/regress/sql/euc_tw.sql deleted file mode 100644 index 79f3def432..0000000000 --- a/src/test/regress/sql/euc_tw.sql +++ /dev/null @@ -1,20 +0,0 @@ -drop table ìÞÙ¸æñÕè; -create table ìÞÙ¸æñÕè (ÈçäÆɱ text, ÄüƳÍñó¤ varchar, ÇâÉß varchar(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 ÄüƳÍñó¤ ~* 'ç®ç®Òï[ÙìØ´ÊÀ]'; - -select *, character_length(ÈçäÆɱ) from ìÞÙ¸æñÕè; -select *, octet_length(ÈçäÆɱ) from ìÞÙ¸æñÕè; -select *, position('È´Óî' in ÄüƳÍñó¤) from ìÞÙ¸æñÕè; -select *, substring(ÄüƳÍñó¤ from 3 for 6 ) from ìÞÙ¸æñÕè; diff --git a/src/test/regress/sql/mule_internal.sql b/src/test/regress/sql/mule_internal.sql deleted file mode 100644 index 2e381f0f7e..0000000000 --- a/src/test/regress/sql/mule_internal.sql +++ /dev/null @@ -1,72 +0,0 @@ -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 ’Íђ¸ì ~* '’¥³’¥ó’¥Ô’¥å’¡¼’¥¿[’¥Ç’¥°]'; -select *,character_length(’Íђ¸ì) from ’·×’»»’µ¡’Íђ¸ì; -select *,octet_length(’Íђ¸ì) from ’·×’»»’µ¡’Íђ¸ì; -select *,position('’¥Ç' in ’Íђ¸ì) from ’·×’»»’µ¡’Íђ¸ì; -select *,substring(’Íђ¸ì from 10 for 4) from ’·×’»»’µ¡’Íђ¸ì; -drop table ‘¼Æ‘Ë㑻ú‘Êõ‘Óï; -create table ‘¼Æ‘Ë㑻ú‘Êõ‘Óï(‘Êõ‘Óï text, ‘·Ö‘Àà‘ºÅ varchar, ‘±¸‘×¢1A char(16)); -create index ‘¼Æ‘Ë㑻ú‘Êõ‘Óïindex1 on ‘¼Æ‘Ë㑻ú‘Êõ‘Óï using btree(‘Êõ‘Óï); -create index ‘¼Æ‘Ë㑻ú‘Êõ‘Óïindex2 on ‘¼Æ‘Ë㑻ú‘Êõ‘Óï using btree(‘·Ö‘Àà‘ºÅ); -insert into ‘¼Æ‘Ë㑻ú‘Êõ‘Óï values('‘µç‘ÄԑÏԑʾ‘ÆÁ','‘»úA01‘ÉÏ'); -insert into ‘¼Æ‘Ë㑻ú‘Êõ‘Óï values('‘µç‘Äԑͼ‘ÐÎ','‘·ÖB01‘ÖÐ'); -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 ‘Êõ‘Óï ~* '‘µç‘ÄÔ[‘Ïԑͼ]'; -select *,character_length(‘Êõ‘Óï) from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï; -select *,octet_length(‘Êõ‘Óï) from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï; -select *,position('‘ÏÔ' in ‘Êõ‘Óï) from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï; -select *,substring(‘Êõ‘Óï from 3 for 4) from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï; -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 “¿ë“¾î ~* '“Äēǻ“ÅÍ[“µð“±×]'; -select *,character_length(“¿ë“¾î) from “ͪ“ß©“Ѧ“¿ë“¾î; -select *,octet_length(“¿ë“¾î) from “ͪ“ß©“Ѧ“¿ë“¾î; -select *,position('“µð' in “¿ë“¾î) from “ͪ“ß©“Ѧ“¿ë“¾î; -select *,substring(“¿ë“¾î from 3 for 4) from “ͪ“ß©“Ѧ“¿ë“¾î; -drop table test; -create table test (t text); -insert into test values('ENGLISH'); -insert into test values('FRANÇAIS'); -insert into test values('ESPAÑOL'); -insert into test values('ÍSLENSKA'); -insert into test values('ENGLISH FRANÇAIS ESPAÑOL ÍSLENSKA'); -vacuum test; -select * from test; -select * from test where t = 'ESPAÑOL'; -select * from test where t ~* 'espaÑol'; -select *,character_length(t) from test; -select *,octet_length(t) from test; -select *,position('L' in t) from test; -select *,substring(t from 3 for 4) from test; diff --git a/src/test/regress/sql/sql_ascii.sql b/src/test/regress/sql/sql_ascii.sql deleted file mode 100644 index 0470f49f92..0000000000 --- a/src/test/regress/sql/sql_ascii.sql +++ /dev/null @@ -1,19 +0,0 @@ -drop table computer_terms; -create table computer_terms(term text, category text, comments char(16)); -create index computer_terms_index1 on computer_terms using btree(term); -create index computer_terms_index2 on computer_terms using btree(category); -insert into computer_terms values('computer display', 'X-A01-Y', 'a comment 1'); -insert into computer_terms values('computer graphics', 'T-B01-Y', 'a comment 2'); -insert into computer_terms values('computer programmer', 'S-Z01-Y', 'a comment 3'); -vacuum computer_terms; -select * from computer_terms; -select * from computer_terms where category = 'X-A01-Y'; -select * from computer_terms where category ~* 'x-a01-y'; -select * from computer_terms where category like '_-A01-_'; -select * from computer_terms where category like '_-A%'; -select * from computer_terms where term ~ 'computer [dg]'; -select * from computer_terms where term ~* 'computer [DG]'; -select *,character_length(term) from computer_terms; -select *,octet_length(term) from computer_terms; -select *,position('s' in term) from computer_terms; -select *,substring(term from 10 for 4) from computer_terms; -- 2.39.5