Port Bug Report: Regression test failures in distinct and limit expressions

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Gianni Mariani
Your email address : marianig(at)cwix(dot)com

Category : runtime: back-end: SQL
Severity : serious

Summary: Regression test failures in distinct and limit expressions

System Configuration
--------------------
Operating System : Linux - RH 6.0 SMP

PostgreSQL version : 6.5

Compiler used : egcs-2.91.60

Hardware:
---------
Dual 450MHz PIII

Versions of other tools:
------------------------
Standard RH 6.0

--------------------------------------------------------------------------

Problem Description:
--------------------
$ cat regress.out
=============== Notes... =================
postmaster must already be running for the regression tests to succeed.
The time zone is now set to PST8PDT explicitly by this regression test
client frontend. Please report any apparent problems to
ports(at)postgresql(dot)org
See regress/README for more information.

=============== destroying old regression database... =================
=============== creating new regression database... =================
=============== installing PL/pgSQL... =================
=============== running regression queries... =================
boolean .. ok
char .. ok
name .. ok
varchar .. ok
text .. ok
strings .. ok
int2 .. ok
int4 .. ok
int8 .. ok
oid .. ok
float4 .. ok
float8 .. failed
numerology .. ok
point .. ok
lseg .. ok
box .. ok
path .. ok
polygon .. ok
circle .. ok
geometry .. failed
timespan .. ok
datetime .. ok
reltime .. ok
abstime .. ok
tinterval .. ok
horology .. ok
inet .. ok
comments .. ok
oidjoins .. ok
type_sanity .. ok
opr_sanity .. ok
create_function_1 .. ok
create_type .. ok
create_table .. ok
create_function_2 .. ok
constraints .. ok
triggers .. ok
copy .. failed
create_misc .. ok
create_aggregate .. ok
create_operator .. ok
create_view .. ok
create_index .. ok
sanity_check .. ok
errors .. ok
select .. failed
select_into .. ok
select_distinct .. failed
select_distinct_on .. failed
select_implicit .. ok
select_having .. ok
subselect .. ok
union .. ok
case .. ok
join .. ok
aggregates .. failed
transactions .. ok
random .. failed
portals .. ok
misc .. failed
arrays .. ok
btree_index .. ok
hash_index .. ok
select_views .. ok
alter_table .. ok
portals_p2 .. failed
rules .. ok
limit .. failed
plpgsql .. ok
temp .. ok
numeric .. ok
unicode .. ./regress.sh: sql/unicode.sql: No such file or directory
diff: expected/unicode.out: No such file or directory
diff: results/unicode.out: No such file or directory
ok
====== float8 ======
192c192,200
< ERROR: pow() result is out of range
---
> bad|?column?
> ---+--------
> |0
> |NaN
> |NaN
> |NaN
> |NaN
> (5 rows)
>
198c206,214
< ERROR: exp() result is out of range
---
> bad| ?column?
> ---+--------------------
> | 1
> |7.39912306090513e-16
> | 0
> | 0
> | 1
> (5 rows)
>
====== geometry ======
115c115
< |(-10,0) |[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140473)
---
> |(-10,0) |[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140472)
412,418c412,418
< ---+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
< |((-3,0),(-2.59807621135332,1.5),(-1.5,2.59807621135332),(-1.83690953073357e-16,3),(1.5,2.59807621135332),(2.59807621135332,1.5),(3,3.67381906146713e-16),(2.59807621135332,-1.5),(1.5,-2.59807621135332),(5.5107285922007e-16,-3),(-1.5,-2.59807621135332),(-2.59807621135332,-1.5))
< |((-99,2),(-85.6025403784439,52),(-49,88.6025403784439),(0.999999999999994,102),(51,88.6025403784439),(87.6025403784439,52),(101,2.00000000000001),(87.6025403784439,-48),(51,-84.6025403784438),(1.00000000000002,-98),(-49,-84.6025403784439),(-85.6025403784438,-48))
< |((-4,3),(-3.33012701892219,5.5),(-1.5,7.33012701892219),(1,8),(3.5,7.33012701892219),(5.33012701892219,5.5),(6,3),(5.33012701892219,0.500000000000001),(3.5,-1.33012701892219),(1,-2),(-1.5,-1.33012701892219),(-3.33012701892219,0.499999999999998))
< |((-2,2),(-1.59807621135332,3.5),(-0.5,4.59807621135332),(1,5),(2.5,4.59807621135332),(3.59807621135332,3.5),(4,2),(3.59807621135332,0.500000000000001),(2.5,-0.598076211353315),(1,-1),(-0.5,-0.598076211353316),(-1.59807621135332,0.499999999999999))
< |((90,200),(91.3397459621556,205),(95,208.660254037844),(100,210),(105,208.660254037844),(108.660254037844,205),(110,200),(108.660254037844,195),(105,191.339745962156),(100,190),(95,191.339745962156),(91.3397459621556,195))
< |((0,0),(13.3974596215561,50),(50,86.6025403784439),(100,100),(150,86.6025403784439),(186.602540378444,50),(200,1.22460635382238e-14),(186.602540378444,-50),(150,-86.6025403784438),(100,-100),(50,-86.6025403784439),(13.3974596215562,-50))
---
> ---+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> |((-3,0),(-2.59807621135076,1.50000000000442),(-1.49999999999116,2.59807621135842),(1.53102359078377e-11,3),(1.50000000001768,2.59807621134311),(2.59807621136607,1.4999999999779),(3,-3.06204718156754e-11),(2.59807621133545,-1.50000000003094),(1.49999999996464,-2.59807621137373),(-4.59307077235131e-11,-3),(-1.5000000000442,-2.5980762113278),(-2.59807621138138,-1.49999999995138))
> |((-99,2),(-85.6025403783588,52.0000000001473),(-48.9999999997054,88.602540378614),(1.00000000051034,102),(51.0000000005893,88.6025403781036),(87.6025403788692,51.9999999992634),(101,1.99999999897932),(87.6025403778485,-48.0000000010313),(50.9999999988214,-84.6025403791243),(0.999999998468976,-98),(-49.0000000014732,-84.6025403775933),(-85.6025403793795,-47.9999999983795))
> |((-4,3),(-3.33012701891794,5.50000000000737),(-1.49999999998527,7.3301270189307),(1.00000000002552,8),(3.50000000002946,7.33012701890518),(5.33012701894346,5.49999999996317),(6,2.99999999994897),(5.33012701889242,0.499999999948437),(3.49999999994107,-1.33012701895622),(0.999999999923449,-2),(-1.50000000007366,-1.33012701887966),(-3.33012701896897,0.500000000081028))
> |((-2,2),(-1.59807621135076,3.50000000000442),(-0.499999999991161,4.59807621135842),(1.00000000001531,5),(2.50000000001768,4.59807621134311),(3.59807621136607,3.4999999999779),(4,1.99999999996938),(3.59807621133545,0.499999999969062),(2.49999999996464,-0.59807621137373),(0.999999999954069,-1),(-0.500000000044197,-0.598076211327799),(-1.59807621138138,0.500000000048617))
> |((90,200),(91.3397459621641,205.000000000015),(95.0000000000295,208.660254037861),(100.000000000051,210),(105.000000000059,208.66025403781),(108.660254037887,204.999999999926),(110,199.999999999898),(108.660254037785,194.999999999897),(104.999999999882,191.339745962088),(99.9999999998469,190),(94.9999999998527,191.339745962241),(91.3397459620621,195.000000000162))
> |((0,0),(13.3974596216412,50.0000000001473),(50.0000000002946,86.602540378614),(100.00000000051,100),(150.000000000589,86.6025403781036),(186.602540378869,49.9999999992634),(200,-1.02068239385585e-09),(186.602540377848,-50.0000000010313),(149.999999998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-86.6025403775933),(13.3974596206205,-49.9999999983795))
424,430c424,430
< ---+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
< |((-3,0),(-2.12132034355964,2.12132034355964),(-1.83690953073357e-16,3),(2.12132034355964,2.12132034355964),(3,3.67381906146713e-16),(2.12132034355964,-2.12132034355964),(5.5107285922007e-16,-3),(-2.12132034355964,-2.12132034355964))
< |((-99,2),(-69.7106781186548,72.7106781186548),(0.999999999999994,102),(71.7106781186547,72.7106781186548),(101,2.00000000000001),(71.7106781186548,-68.7106781186547),(1.00000000000002,-98),(-69.7106781186547,-68.7106781186548))
< |((-4,3),(-2.53553390593274,6.53553390593274),(1,8),(4.53553390593274,6.53553390593274),(6,3),(4.53553390593274,-0.535533905932737),(1,-2),(-2.53553390593274,-0.535533905932738))
< |((-2,2),(-1.12132034355964,4.12132034355964),(1,5),(3.12132034355964,4.12132034355964),(4,2),(3.12132034355964,-0.121320343559642),(1,-1),(-1.12132034355964,-0.121320343559643))
< |((90,200),(92.9289321881345,207.071067811865),(100,210),(107.071067811865,207.071067811865),(110,200),(107.071067811865,192.928932188135),(100,190),(92.9289321881345,192.928932188135))
< |((0,0),(29.2893218813452,70.7106781186548),(100,100),(170.710678118655,70.7106781186548),(200,1.22460635382238e-14),(170.710678118655,-70.7106781186547),(100,-100),(29.2893218813453,-70.7106781186548))
---
> ---+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> |((-3,0),(-2.12132034355423,2.12132034356506),(1.53102359078377e-11,3),(2.12132034357588,2.1213203435434),(3,-3.06204718156754e-11),(2.12132034353258,-2.12132034358671),(-4.59307077235131e-11,-3),(-2.12132034359753,-2.12132034352175))
> |((-99,2),(-69.7106781184743,72.7106781188352),(1.00000000051034,102),(71.710678119196,72.7106781181134),(101,1.99999999897932),(71.7106781177526,-68.7106781195569),(0.999999998468976,-98),(-69.7106781199178,-68.7106781173917))
> |((-4,3),(-2.53553390592372,6.53553390594176),(1.00000000002552,8),(4.5355339059598,6.53553390590567),(6,2.99999999994897),(4.53553390588763,-0.535533905977846),(0.999999999923449,-2),(-2.53553390599589,-0.535533905869586))
> |((-2,2),(-1.12132034355423,4.12132034356506),(1.00000000001531,5),(3.12132034357588,4.1213203435434),(4,1.99999999996938),(3.12132034353258,-0.121320343586707),(0.999999999954069,-1),(-1.12132034359753,-0.121320343521752))
> |((90,200),(92.9289321881526,207.071067811884),(100.000000000051,210),(107.07106781192,207.071067811811),(110,199.999999999898),(107.071067811775,192.928932188044),(99.9999999998469,190),(92.9289321880082,192.928932188261))
> |((0,0),(29.2893218815257,70.7106781188352),(100.00000000051,100),(170.710678119196,70.7106781181134),(200,-1.02068239385585e-09),(170.710678117753,-70.7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917))
====== copy ======
3a4
> ERROR: COPY command, running in backend with effective uid 101, could not open file '/var/people/gianni/downloads/postgresql/pgicx/postgresql-6.5/src/test/regress/input/../results/onek.data' for writing. Errno = Permission denied (13).
5a7
> ERROR: COPY command, running in backend with effective uid 101, could not open file '/var/people/gianni/downloads/postgresql/pgicx/postgresql-6.5/src/test/regress/input/../results/onek.data' for reading. Errno = No such file or directory (2).
====== select ======
4,14c4
< 0| 998| 0| 0| 0| 0| 0| 0| 0| 0| 0| 0| 1|AAAAAA |KMBAAA |OOOOxx
< 1| 214| 1| 1| 1| 1| 1| 1| 1| 1| 1| 2| 3|BAAAAA |GIAAAA |OOOOxx
< 2| 326| 0| 2| 2| 2| 2| 2| 2| 2| 2| 4| 5|CAAAAA |OMAAAA |OOOOxx
< 3| 431| 1| 3| 3| 3| 3| 3| 3| 3| 3| 6| 7|DAAAAA |PQAAAA |VVVVxx
< 4| 833| 0| 0| 4| 4| 4| 4| 4| 4| 4| 8| 9|EAAAAA |BGBAAA |HHHHxx
< 5| 541| 1| 1| 5| 5| 5| 5| 5| 5| 5| 10| 11|FAAAAA |VUAAAA |HHHHxx
< 6| 978| 0| 2| 6| 6| 6| 6| 6| 6| 6| 12| 13|GAAAAA |QLBAAA |OOOOxx
< 7| 647| 1| 3| 7| 7| 7| 7| 7| 7| 7| 14| 15|HAAAAA |XYAAAA |VVVVxx
< 8| 653| 0| 0| 8| 8| 8| 8| 8| 8| 8| 16| 17|IAAAAA |DZAAAA |HHHHxx
< 9| 49| 1| 1| 9| 9| 9| 9| 9| 9| 9| 18| 19|JAAAAA |XBAAAA |HHHHxx
< (10 rows)
---
> (0 rows)
21,41c11
< 19|TAAAAA
< 18|SAAAAA
< 17|RAAAAA
< 16|QAAAAA
< 15|PAAAAA
< 14|OAAAAA
< 13|NAAAAA
< 12|MAAAAA
< 11|LAAAAA
< 10|KAAAAA
< 9|JAAAAA
< 8|IAAAAA
< 7|HAAAAA
< 6|GAAAAA
< 5|FAAAAA
< 4|EAAAAA
< 3|DAAAAA
< 2|CAAAAA
< 1|BAAAAA
< 0|AAAAAA
< (20 rows)
---
> (0 rows)
48,67c18
< 988|AMAAAA
< 989|BMAAAA
< 990|CMAAAA
< 991|DMAAAA
< 992|EMAAAA
< 993|FMAAAA
< 994|GMAAAA
< 995|HMAAAA
< 996|IMAAAA
< 997|JMAAAA
< 998|KMAAAA
< 999|LMAAAA
< 981|TLAAAA
< 982|ULAAAA
< 983|VLAAAA
< 984|WLAAAA
< 985|XLAAAA
< 986|YLAAAA
< 987|ZLAAAA
< (19 rows)
---
> (0 rows)
74,93c25
< 999|AAAAxx
< 995|AAAAxx
< 983|AAAAxx
< 982|AAAAxx
< 981|AAAAxx
< 998|HHHHxx
< 997|HHHHxx
< 993|HHHHxx
< 990|HHHHxx
< 986|HHHHxx
< 996|OOOOxx
< 991|OOOOxx
< 988|OOOOxx
< 987|OOOOxx
< 985|OOOOxx
< 994|VVVVxx
< 992|VVVVxx
< 989|VVVVxx
< 984|VVVVxx
< (19 rows)
---
> (0 rows)
100,119c32
< 984|VVVVxx
< 989|VVVVxx
< 992|VVVVxx
< 994|VVVVxx
< 985|OOOOxx
< 987|OOOOxx
< 988|OOOOxx
< 991|OOOOxx
< 996|OOOOxx
< 986|HHHHxx
< 990|HHHHxx
< 993|HHHHxx
< 997|HHHHxx
< 998|HHHHxx
< 981|AAAAxx
< 982|AAAAxx
< 983|AAAAxx
< 995|AAAAxx
< 999|AAAAxx
< (19 rows)
---
> (0 rows)
126,146c39
< 19|OOOOxx
< 18|VVVVxx
< 17|HHHHxx
< 16|OOOOxx
< 15|VVVVxx
< 14|AAAAxx
< 13|OOOOxx
< 12|AAAAxx
< 11|OOOOxx
< 10|AAAAxx
< 9|HHHHxx
< 8|HHHHxx
< 7|VVVVxx
< 6|OOOOxx
< 5|HHHHxx
< 4|HHHHxx
< 3|VVVVxx
< 2|OOOOxx
< 1|OOOOxx
< 0|OOOOxx
< (20 rows)
---
> (0 rows)
153,173c46
< 0|OOOOxx
< 1|OOOOxx
< 2|OOOOxx
< 3|VVVVxx
< 4|HHHHxx
< 5|HHHHxx
< 6|OOOOxx
< 7|VVVVxx
< 8|HHHHxx
< 9|HHHHxx
< 10|AAAAxx
< 11|OOOOxx
< 12|AAAAxx
< 13|OOOOxx
< 14|AAAAxx
< 15|VVVVxx
< 16|OOOOxx
< 17|HHHHxx
< 18|VVVVxx
< 19|OOOOxx
< (20 rows)
---
> (0 rows)
====== select_distinct ======
4,6c4
< 0
< 1
< (2 rows)
---
> (0 rows)
11,21c9
< 0
< 1
< 2
< 3
< 4
< 5
< 6
< 7
< 8
< 9
< (10 rows)
---
> (0 rows)
26,30c14
< AAAAxx
< HHHHxx
< OOOOxx
< VVVVxx
< (4 rows)
---
> (0 rows)
37,77c21
< 0|AAAAxx | 0
< 0|AAAAxx | 2
< 0|AAAAxx | 4
< 0|AAAAxx | 6
< 0|AAAAxx | 8
< 0|HHHHxx | 0
< 0|HHHHxx | 2
< 0|HHHHxx | 4
< 0|HHHHxx | 6
< 0|HHHHxx | 8
< 0|OOOOxx | 0
< 0|OOOOxx | 2
< 0|OOOOxx | 4
< 0|OOOOxx | 6
< 0|OOOOxx | 8
< 0|VVVVxx | 0
< 0|VVVVxx | 2
< 0|VVVVxx | 4
< 0|VVVVxx | 6
< 0|VVVVxx | 8
< 1|AAAAxx | 1
< 1|AAAAxx | 3
< 1|AAAAxx | 5
< 1|AAAAxx | 7
< 1|AAAAxx | 9
< 1|HHHHxx | 1
< 1|HHHHxx | 3
< 1|HHHHxx | 5
< 1|HHHHxx | 7
< 1|HHHHxx | 9
< 1|OOOOxx | 1
< 1|OOOOxx | 3
< 1|OOOOxx | 5
< 1|OOOOxx | 7
< 1|OOOOxx | 9
< 1|VVVVxx | 1
< 1|VVVVxx | 3
< 1|VVVVxx | 5
< 1|VVVVxx | 7
< 1|VVVVxx | 9
< (40 rows)
---
> (0 rows)
====== select_distinct_on ======
6,14c6
< 0|AAAAxx | 0
< 0|HHHHxx | 0
< 0|OOOOxx | 0
< 0|VVVVxx | 0
< 1|AAAAxx | 1
< 1|HHHHxx | 1
< 1|OOOOxx | 1
< 1|VVVVxx | 1
< (8 rows)
---
> (0 rows)
====== aggregates ======
4c4
< 1
---
>
28c28
< 1500
---
>
52c52
< 3
---
>
76c76
< 1000
---
> 0
82c82
< 1
---
> 0
88c88
< 1500
---
> 0
94c94
< 1000
---
> 0
====== random ======
4c4
< 1000
---
> 0
16c16,17
< (0 rows)
---
> 0| 2
> (1 row)
22c23,25
< (0 rows)
---
> 0
> 0
> (2 rows)
====== misc ======
14a15
> ERROR: COPY command, running in backend with effective uid 101, could not open file '/var/people/gianni/downloads/postgresql/pgicx/postgresql-6.5/src/test/regress/input/../results/onek.data' for writing. Errno = Permission denied (13).
16a18
> ERROR: COPY command, running in backend with effective uid 101, could not open file '/var/people/gianni/downloads/postgresql/pgicx/postgresql-6.5/src/test/regress/input/../results/onek.data' for reading. Errno = No such file or directory (2).
20,22c22
< 0
< 1
< (2 rows)
---
> (0 rows)
25a26
> ERROR: COPY command, running in backend with effective uid 101, could not open file '/var/people/gianni/downloads/postgresql/pgicx/postgresql-6.5/src/test/regress/input/../results/onek.data' for reading. Errno = No such file or directory (2).
29,31c30
< 0
< 1
< (2 rows)
---
> (0 rows)
33a33
> ERROR: COPY command, running in backend with effective uid 101, could not open file '/var/people/gianni/downloads/postgresql/pgicx/postgresql-6.5/src/test/regress/input/../results/stud_emp.data' for writing. Errno = Permission denied (13).
35a36
> ERROR: COPY command, running in backend with effective uid 101, could not open file '/var/people/gianni/downloads/postgresql/pgicx/postgresql-6.5/src/test/regress/input/../results/stud_emp.data' for reading. Errno = No such file or directory (2).
38,42c39,40
< -----+---+----------+------+-------+---+-------
< jeff | 23|(8,7.7) | 600|sharon |3.5|
< cim | 30|(10.5,4.7)| 400| |3.4|
< linda| 19|(0.9,6.1) | 100| |2.9|
< (3 rows)
---
> ----+---+--------+------+-------+---+-------
> (0 rows)
379,380c377
< jeff |posthacking
< (4 rows)
---
> (3 rows)
417,418c414
< jeff |posthacking|advil
< (4 rows)
---
> (3 rows)
434,435c430
< advil |jeff |posthacking
< (4 rows)
---
> (3 rows)
451,452c446
< advil |posthacking|jeff
< (4 rows)
---
> (3 rows)
====== portals_p2 ======
31,32c31
< 50| 253| 0| 2| 0| 10| 0| 50| 50| 50| 50| 0| 1|YBAAAA |TJAAAA |HHHHxx
< (1 row)
---
> (0 rows)
37,38c36
< 51| 76| 1| 3| 1| 11| 1| 51| 51| 51| 51| 2| 3|ZBAAAA |YCAAAA |AAAAxx
< (1 row)
---
> (0 rows)
43,44c41
< 52| 985| 0| 0| 2| 12| 2| 52| 52| 52| 52| 4| 5|ACAAAA |XLBAAA |HHHHxx
< (1 row)
---
> (0 rows)
49,50c46
< 53| 196| 1| 1| 3| 13| 3| 53| 53| 53| 53| 6| 7|BCAAAA |OHAAAA |AAAAxx
< (1 row)
---
> (0 rows)
55,56c51
< 54| 356| 0| 2| 4| 14| 4| 54| 54| 54| 54| 8| 9|CCAAAA |SNAAAA |AAAAxx
< (1 row)
---
> (0 rows)
61,62c56
< 55| 627| 1| 3| 5| 15| 5| 55| 55| 55| 55| 10| 11|DCAAAA |DYAAAA |VVVVxx
< (1 row)
---
> (0 rows)
67,68c61
< 56| 54| 0| 0| 6| 16| 6| 56| 56| 56| 56| 12| 13|ECAAAA |CCAAAA |OOOOxx
< (1 row)
---
> (0 rows)
73,74c66
< 57| 942| 1| 1| 7| 17| 7| 57| 57| 57| 57| 14| 15|FCAAAA |GKBAAA |OOOOxx
< (1 row)
---
> (0 rows)
79,80c71
< 58| 114| 0| 2| 8| 18| 8| 58| 58| 58| 58| 16| 17|GCAAAA |KEAAAA |OOOOxx
< (1 row)
---
> (0 rows)
85,86c76
< 59| 593| 1| 3| 9| 19| 9| 59| 59| 59| 59| 18| 19|HCAAAA |VWAAAA |HHHHxx
< (1 row)
---
> (0 rows)
91,92c81
< 60| 483| 0| 0| 0| 0| 0| 60| 60| 60| 60| 0| 1|ICAAAA |PSAAAA |VVVVxx
< (1 row)
---
> (0 rows)
97,98c86
< 50| 253| 0| 2| 0| 10| 0| 50| 50| 50| 50| 0| 1|YBAAAA |TJAAAA |HHHHxx
< (1 row)
---
> (0 rows)
103,104c91
< 60| 483| 0| 0| 0| 0| 0| 60| 60| 60| 60| 0| 1|ICAAAA |PSAAAA |VVVVxx
< (1 row)
---
> (0 rows)
====== limit ======
6,8c6
< | 51| 76|ZBAAAA
< | 52| 985|ACAAAA
< (2 rows)
---
> (0 rows)
15,20c13
< | 61| 560|JCAAAA
< | 62| 633|KCAAAA
< | 63| 296|LCAAAA
< | 64| 479|MCAAAA
< | 65| 64|NCAAAA
< (5 rows)
---
> (0 rows)
27,29c20
< | 61| 560|JCAAAA
< | 62| 633|KCAAAA
< (2 rows)
---
> (0 rows)
36,39c27
< | 121| 700|REAAAA
< | 122| 519|SEAAAA
< | 123| 777|TEAAAA
< (3 rows)
---
> (0 rows)
53,64c41
< | 10| 520|KAAAAA
< | 9| 49|JAAAAA
< | 8| 653|IAAAAA
< | 7| 647|HAAAAA
< | 6| 978|GAAAAA
< | 5| 541|FAAAAA
< | 4| 833|EAAAAA
< | 3| 431|DAAAAA
< | 2| 326|CAAAAA
< | 1| 214|BAAAAA
< | 0| 998|AAAAAA
< (11 rows)
---
> (0 rows)
71,81c48
< | 990| 369|CMAAAA
< | 991| 426|DMAAAA
< | 992| 363|EMAAAA
< | 993| 661|FMAAAA
< | 994| 695|GMAAAA
< | 995| 144|HMAAAA
< | 996| 258|IMAAAA
< | 997| 21|JMAAAA
< | 998| 549|KMAAAA
< | 999| 152|LMAAAA
< (10 rows)
---
> (0 rows)
88,93c55
< | 990| 369|CMAAAA
< | 991| 426|DMAAAA
< | 992| 363|EMAAAA
< | 993| 661|FMAAAA
< | 994| 695|GMAAAA
< (5 rows)
---
> (0 rows)
100,105c62
< | 900| 913|QIAAAA
< | 901| 931|RIAAAA
< | 902| 702|SIAAAA
< | 903| 641|TIAAAA
< | 904| 793|UIAAAA
< (5 rows)
---
> (0 rows)

--------------------------------------------------------------------------

Test Case:
----------
Build with configure line:

./configure --enable-locale --with-mb=UNICODE --with-odbc --with-x

-- initialize PGDATA
-- create a database
-- run regression suite

--------------------------------------------------------------------------

Solution:
---------

--------------------------------------------------------------------------