summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMichael P2011-12-15 05:24:53 +0000
committerMichael P2011-12-15 05:24:53 +0000
commit0e93089b78b8c32abd7bfbd2eb30e536bf4987e6 (patch)
tree21496e1e9ce5c852deb61b2cd2cb9b11f8726660
parent593134cb10d2129d5be5887602138892446a49da (diff)
Fix for regression test rowtypes
PostgreSQL gives the same result on the query that was failing.
-rw-r--r--src/test/regress/expected/rowtypes_1.out9
1 files changed, 5 insertions, 4 deletions
diff --git a/src/test/regress/expected/rowtypes_1.out b/src/test/regress/expected/rowtypes_1.out
index b87c710125..b345e04c8b 100644
--- a/src/test/regress/expected/rowtypes_1.out
+++ b/src/test/regress/expected/rowtypes_1.out
@@ -117,10 +117,11 @@ create temp table pp (f1 text);
insert into pp values (repeat('abcdefghijkl', 100000));
insert into people select ('Jim', f1, null)::fullname, current_date from pp;
select (fn).first, substr((fn).last, 1, 20), length((fn).last) from people order by 1, 2;
- first | substr | length
--------+--------+--------
- Joe | Blow | 4
-(1 row)
+ first | substr | length
+-------+----------------------+---------
+ Jim | abcdefghijklabcdefgh | 1200000
+ Joe | Blow | 4
+(2 rows)
-- Test row comparison semantics. Prior to PG 8.2 we did this in a totally
-- non-spec-compliant way.