Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitd1687c6

Browse files
committed
Disable multi-byte citext tests
This reverts commit890faaf which attempted unsuccessfully to deal withthe problem, and instead just comments out these tests like other similartests elsewhere in the script.
1 parented22fb8 commitd1687c6

File tree

3 files changed

+19
-59
lines changed

3 files changed

+19
-59
lines changed

‎contrib/citext/expected/citext.out

Lines changed: 6 additions & 26 deletions
Original file line numberDiff line numberDiff line change
@@ -1,8 +1,6 @@
11
--
22
-- Test citext datatype
33
--
4-
--- script setup
5-
set client_encoding = 'utf8';
64
CREATE EXTENSION citext;
75
-- Check whether any of our opclasses fail amvalidate
86
SELECT amname, opcname
@@ -2599,6 +2597,8 @@ SELECT citext_pattern_ge('b'::citext, 'A'::citext) AS true;
25992597
t
26002598
(1 row)
26012599

2600+
-- Multi-byte tests below are diabled like the sanity tests above.
2601+
-- Uncomment to run them.
26022602
-- Test ~<~ and ~<=~
26032603
SELECT 'a'::citext ~<~ 'B'::citext AS t;
26042604
t
@@ -2612,12 +2612,7 @@ SELECT 'b'::citext ~<~ 'A'::citext AS f;
26122612
f
26132613
(1 row)
26142614

2615-
SELECT 'à'::citext ~<~ 'À'::citext AS f;
2616-
f
2617-
---
2618-
f
2619-
(1 row)
2620-
2615+
-- SELECT 'à'::citext ~<~ 'À'::citext AS f;
26212616
SELECT 'a'::citext ~<=~ 'B'::citext AS t;
26222617
t
26232618
---
@@ -2630,12 +2625,7 @@ SELECT 'a'::citext ~<=~ 'A'::citext AS t;
26302625
t
26312626
(1 row)
26322627

2633-
SELECT 'à'::citext ~<=~ 'À'::citext AS t;
2634-
t
2635-
---
2636-
f
2637-
(1 row)
2638-
2628+
-- SELECT 'à'::citext ~<=~ 'À'::citext AS t;
26392629
-- Test ~>~ and ~>=~
26402630
SELECT 'B'::citext ~>~ 'a'::citext AS t;
26412631
t
@@ -2649,12 +2639,7 @@ SELECT 'b'::citext ~>~ 'A'::citext AS t;
26492639
t
26502640
(1 row)
26512641

2652-
SELECT 'à'::citext ~>~ 'À'::citext AS f;
2653-
f
2654-
---
2655-
t
2656-
(1 row)
2657-
2642+
-- SELECT 'à'::citext ~>~ 'À'::citext AS f;
26582643
SELECT 'B'::citext ~>~ 'b'::citext AS f;
26592644
f
26602645
---
@@ -2667,12 +2652,7 @@ SELECT 'B'::citext ~>=~ 'b'::citext AS t;
26672652
t
26682653
(1 row)
26692654

2670-
SELECT 'à'::citext ~>=~ 'À'::citext AS t;
2671-
t
2672-
---
2673-
t
2674-
(1 row)
2675-
2655+
-- SELECT 'à'::citext ~>=~ 'À'::citext AS t;
26762656
-- Test implicit casting. citext casts to text, but not vice-versa.
26772657
SELECT 'B'::citext ~<~ 'a'::text AS t; -- text wins.
26782658
t

‎contrib/citext/expected/citext_1.out

Lines changed: 6 additions & 26 deletions
Original file line numberDiff line numberDiff line change
@@ -1,8 +1,6 @@
11
--
22
-- Test citext datatype
33
--
4-
--- script setup
5-
set client_encoding = 'utf8';
64
CREATE EXTENSION citext;
75
-- Check whether any of our opclasses fail amvalidate
86
SELECT amname, opcname
@@ -2599,6 +2597,8 @@ SELECT citext_pattern_ge('b'::citext, 'A'::citext) AS true;
25992597
t
26002598
(1 row)
26012599

2600+
-- Multi-byte tests below are diabled like the sanity tests above.
2601+
-- Uncomment to run them.
26022602
-- Test ~<~ and ~<=~
26032603
SELECT 'a'::citext ~<~ 'B'::citext AS t;
26042604
t
@@ -2612,12 +2612,7 @@ SELECT 'b'::citext ~<~ 'A'::citext AS f;
26122612
f
26132613
(1 row)
26142614

2615-
SELECT 'à'::citext ~<~ 'À'::citext AS f;
2616-
f
2617-
---
2618-
f
2619-
(1 row)
2620-
2615+
-- SELECT 'à'::citext ~<~ 'À'::citext AS f;
26212616
SELECT 'a'::citext ~<=~ 'B'::citext AS t;
26222617
t
26232618
---
@@ -2630,12 +2625,7 @@ SELECT 'a'::citext ~<=~ 'A'::citext AS t;
26302625
t
26312626
(1 row)
26322627

2633-
SELECT 'à'::citext ~<=~ 'À'::citext AS t;
2634-
t
2635-
---
2636-
t
2637-
(1 row)
2638-
2628+
-- SELECT 'à'::citext ~<=~ 'À'::citext AS t;
26392629
-- Test ~>~ and ~>=~
26402630
SELECT 'B'::citext ~>~ 'a'::citext AS t;
26412631
t
@@ -2649,12 +2639,7 @@ SELECT 'b'::citext ~>~ 'A'::citext AS t;
26492639
t
26502640
(1 row)
26512641

2652-
SELECT 'à'::citext ~>~ 'À'::citext AS f;
2653-
f
2654-
---
2655-
f
2656-
(1 row)
2657-
2642+
-- SELECT 'à'::citext ~>~ 'À'::citext AS f;
26582643
SELECT 'B'::citext ~>~ 'b'::citext AS f;
26592644
f
26602645
---
@@ -2667,12 +2652,7 @@ SELECT 'B'::citext ~>=~ 'b'::citext AS t;
26672652
t
26682653
(1 row)
26692654

2670-
SELECT 'à'::citext ~>=~ 'À'::citext AS t;
2671-
t
2672-
---
2673-
t
2674-
(1 row)
2675-
2655+
-- SELECT 'à'::citext ~>=~ 'À'::citext AS t;
26762656
-- Test implicit casting. citext casts to text, but not vice-versa.
26772657
SELECT 'B'::citext ~<~ 'a'::text AS t; -- text wins.
26782658
t

‎contrib/citext/sql/citext.sql

Lines changed: 7 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -2,9 +2,6 @@
22
-- Test citext datatype
33
--
44

5-
--- script setup
6-
set client_encoding='utf8';
7-
85
CREATE EXTENSION citext;
96

107
-- Check whether any of our opclasses fail amvalidate
@@ -804,21 +801,24 @@ SELECT citext_pattern_ge('b'::citext, 'a'::citext) AS true;
804801
SELECT citext_pattern_ge('B'::citext,'a'::citext)AS true;
805802
SELECT citext_pattern_ge('b'::citext,'A'::citext)AS true;
806803

804+
-- Multi-byte tests below are diabled like the sanity tests above.
805+
-- Uncomment to run them.
806+
807807
-- Test ~<~ and ~<=~
808808
SELECT'a'::citext ~<~'B'::citextAS t;
809809
SELECT'b'::citext ~<~'A'::citextAS f;
810-
SELECT'à'::citext ~<~'À'::citextAS f;
810+
--SELECT 'à'::citext ~<~ 'À'::citext AS f;
811811
SELECT'a'::citext ~<=~'B'::citextAS t;
812812
SELECT'a'::citext ~<=~'A'::citextAS t;
813-
SELECT'à'::citext ~<=~'À'::citextAS t;
813+
--SELECT 'à'::citext ~<=~ 'À'::citext AS t;
814814

815815
-- Test ~>~ and ~>=~
816816
SELECT'B'::citext ~>~'a'::citextAS t;
817817
SELECT'b'::citext ~>~'A'::citextAS t;
818-
SELECT'à'::citext ~>~'À'::citextAS f;
818+
--SELECT 'à'::citext ~>~ 'À'::citext AS f;
819819
SELECT'B'::citext ~>~'b'::citextAS f;
820820
SELECT'B'::citext ~>=~'b'::citextAS t;
821-
SELECT'à'::citext ~>=~'À'::citextAS t;
821+
--SELECT 'à'::citext ~>=~ 'À'::citext AS t;
822822

823823
-- Test implicit casting. citext casts to text, but not vice-versa.
824824
SELECT'B'::citext ~<~'a'::textAS t;-- text wins.

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp