diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2015-06-04 13:50:32 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2015-06-04 13:50:32 -0400 |
| commit | 78e72794a76fef3233c06800c6046aaad0704a22 (patch) | |
| tree | 127620a290bfe04835eb41f004accad635f7f94a | |
| parent | bac99475eb6e9e6d69a91fee30b5420b8e0115be (diff) | |
| download | postgresql-78e72794a76fef3233c06800c6046aaad0704a22.tar.gz postgresql-78e72794a76fef3233c06800c6046aaad0704a22.zip | |
Fix brin "char" test to actually test what it meant to test.
Casting to char, without quotes, does not give the same results as casting
to "char". That meant we were not testing the brin "char" paths at all,
since we ended up with a text operator not a "char" operator.
| -rw-r--r-- | src/test/regress/expected/brin.out | 2 | ||||
| -rw-r--r-- | src/test/regress/sql/brin.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/expected/brin.out b/src/test/regress/expected/brin.out index ba0824428ec..b45c77a0649 100644 --- a/src/test/regress/expected/brin.out +++ b/src/test/regress/expected/brin.out @@ -96,7 +96,7 @@ CREATE TABLE brinopers (colname name, typ text, op text[], value text[], check (cardinality(op) = cardinality(value))); INSERT INTO brinopers VALUES ('byteacol', 'bytea', '{>, >=, =, <=, <}', '{AAAAAA, AAAAAA, BNAAAABNAAAABNAAAABNAAAABNAAAABNAAAABNAAAABNAAAA, ZZZZZZ, ZZZZZZ}'), - ('charcol', 'char', '{>, >=, =, <=, <}', '{A, A, M, Z, Z}'), + ('charcol', '"char"', '{>, >=, =, <=, <}', '{A, A, M, Z, Z}'), ('namecol', 'name', '{>, >=, =, <=, <}', '{AAAAAA, AAAAAA, MAAAAA, ZZAAAA, ZZAAAA}'), ('int2col', 'int2', '{>, >=, =, <=, <}', '{0, 0, 800, 999, 999}'), ('int2col', 'int4', '{>, >=, =, <=, <}', '{0, 0, 800, 999, 1999}'), diff --git a/src/test/regress/sql/brin.sql b/src/test/regress/sql/brin.sql index 881a13b1b0b..9a8baef812a 100644 --- a/src/test/regress/sql/brin.sql +++ b/src/test/regress/sql/brin.sql @@ -101,7 +101,7 @@ CREATE TABLE brinopers (colname name, typ text, op text[], value text[], INSERT INTO brinopers VALUES ('byteacol', 'bytea', '{>, >=, =, <=, <}', '{AAAAAA, AAAAAA, BNAAAABNAAAABNAAAABNAAAABNAAAABNAAAABNAAAABNAAAA, ZZZZZZ, ZZZZZZ}'), - ('charcol', 'char', '{>, >=, =, <=, <}', '{A, A, M, Z, Z}'), + ('charcol', '"char"', '{>, >=, =, <=, <}', '{A, A, M, Z, Z}'), ('namecol', 'name', '{>, >=, =, <=, <}', '{AAAAAA, AAAAAA, MAAAAA, ZZAAAA, ZZAAAA}'), ('int2col', 'int2', '{>, >=, =, <=, <}', '{0, 0, 800, 999, 999}'), ('int2col', 'int4', '{>, >=, =, <=, <}', '{0, 0, 800, 999, 1999}'), |