Port Bug Report: Regression test failures in distinct and limit expressions - Mailing list pgsql-ports
| From | Unprivileged user |
|---|---|
| Subject | Port Bug Report: Regression test failures in distinct and limit expressions |
| Date | |
| Msg-id | 199906210003.UAA27655@hub.org Whole thread Raw |
| List | pgsql-ports |
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Gianni Mariani
Your email address : marianig@cwix.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@postgresql.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:
---------
--------------------------------------------------------------------------
pgsql-ports by date: