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

Commitc28aa15

Browse files
committed
Make pg_trgm tests independ from standard_conforming_string. Tests uses
regular expression which contains backslash.
1 parent4034db2 commitc28aa15

File tree

2 files changed

+7
-0
lines changed

2 files changed

+7
-0
lines changed

‎contrib/pg_trgm/expected/pg_trgm.out

Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -7,6 +7,9 @@ WHERE opc.oid >= 16384 AND NOT amvalidate(opc.oid);
77
--------+---------
88
(0 rows)
99

10+
--backslash is used in tests below, installcheck will fail if
11+
--standard_conforming_string is off
12+
set standard_conforming_strings=on;
1013
select show_trgm('');
1114
show_trgm
1215
-----------

‎contrib/pg_trgm/sql/pg_trgm.sql

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -5,6 +5,10 @@ SELECT amname, opcname
55
FROM pg_opclass opcLEFT JOIN pg_am amONam.oid= opcmethod
66
WHEREopc.oid>=16384AND NOT amvalidate(opc.oid);
77

8+
--backslash is used in tests below, installcheck will fail if
9+
--standard_conforming_string is off
10+
set standard_conforming_strings=on;
11+
812
select show_trgm('');
913
select show_trgm('(*&^$@%@');
1014
select show_trgm('a b c');

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp