compiled 6.5.1 onto RedHat v6.0 Linux 2.2.5-15 running on i586
compile and install a-ok
regression summary follows, e-mail if you want more logs, it
looks like mostly floating point rounding differences
Cheng Leong
--
NioTerra http://www.nioterra.com 512/708-1727
1404A W.12th St. Austin, TX 78703=============== 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... =================
ERROR: destroydb: database 'regression' does not exist
destroydb: database destroy failed on regression.
=============== 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
*** expected/float8.out Sat Jan 23 18:12:59 1999
--- results/float8.out Mon Aug 23 21:40:50 1999
***************
*** 189,201 ****
QUERY: SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
ERROR: Bad float8 input format -- overflow
QUERY: SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
! ERROR: pow() result is out of range
QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 = '0.0' ;
ERROR: can't take log of zero
QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 < '0.0' ;
ERROR: can't take log of a negative number
QUERY: SELECT '' AS bad, : (f.f1) from FLOAT8_TBL f;
! ERROR: exp() result is out of range
QUERY: SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f;
ERROR: float8div: divide by zero error
QUERY: SELECT '' AS five, FLOAT8_TBL.*;
--- 189,217 ----
QUERY: SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
ERROR: Bad float8 input format -- overflow
QUERY: SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
! bad|?column?
! ---+--------
! |0
! |NaN
! |NaN
! |NaN
! |NaN
! (5 rows)
!
QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 = '0.0' ;
ERROR: can't take log of zero
QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 < '0.0' ;
ERROR: can't take log of a negative number
QUERY: SELECT '' AS bad, : (f.f1) from FLOAT8_TBL f;
! bad| ?column?
! ---+--------------------
! | 1
! |7.39912306090513e-16
! | 0
! | 0
! | 1
! (5 rows)
!
QUERY: SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f;
ERROR: float8div: divide by zero error
QUERY: SELECT '' AS five, FLOAT8_TBL.*;
----------------------
*** expected/geometry.out Sun Dec 13 17:49:18 1998
--- results/geometry.out Mon Aug 23 21:40:59 1999
***************
*** 112,118 ****
|(-5,-12) |[(10,-10),(-3,-4)] |(-1.60487804878049,-4.64390243902439)
|(10,10) |[(10,-10),(-3,-4)] |(2.39024390243902,-6.48780487804878)
|(0,0) |[(-1000000,200),(300000,-40)]|(0.0028402365895872,15.384614860264)
! |(-10,0) |[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140473)
|(-3,4) |[(-1000000,200),(300000,-40)]|(-2.99789812267519,15.3851688427303)
|(5.1,34.5)|[(-1000000,200),(300000,-40)]|(5.09647083221496,15.3836744976925)
|(-5,-12) |[(-1000000,200),(300000,-40)]|(-4.99494420845634,15.3855375281616)
--- 112,118 ----
|(-5,-12) |[(10,-10),(-3,-4)] |(-1.60487804878049,-4.64390243902439)
|(10,10) |[(10,-10),(-3,-4)] |(2.39024390243902,-6.48780487804878)
|(0,0) |[(-1000000,200),(300000,-40)]|(0.0028402365895872,15.384614860264)
! |(-10,0) |[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140472)
|(-3,4) |[(-1000000,200),(300000,-40)]|(-2.99789812267519,15.3851688427303)
|(5.1,34.5)|[(-1000000,200),(300000,-40)]|(5.09647083221496,15.3836744976925)
|(-5,-12) |[(-1000000,200),(300000,-40)]|(-4.99494420845634,15.3855375281616)
***************
*** 409,433 ****
QUERY: SELECT '' AS six, polygon(f1)
FROM CIRCLE_TBL;
six|polygon
!
---+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
!
|((-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))
(6 rows)
QUERY: SELECT '' AS six, polygon(8, f1)
FROM CIRCLE_TBL;
six|polygon
!
---+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
!
|((-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))
(6 rows)
QUERY: SELECT '' AS six, circle(f1, 50.0)
--- 409,433 ----
QUERY: SELECT '' AS six, polygon(f1)
FROM CIRCLE_TBL;
six|polygon
!
---+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
!
|((-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))
(6 rows)
QUERY: SELECT '' AS six, polygon(8, f1)
FROM CIRCLE_TBL;
six|polygon
!
---+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
!
|((-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))
(6 rows)
QUERY: SELECT '' AS six, circle(f1, 50.0)
----------------------
*** expected/copy.out Mon Aug 23 21:40:32 1999
--- results/copy.out Mon Aug 23 21:42:28 1999
***************
*** 1,8 ****
--- 1,10 ----
QUERY: COPY aggtest FROM '/usr/src/pgsql/src/test/regress/input/../data/agg.data';
QUERY: COPY onek FROM '/usr/src/pgsql/src/test/regress/input/../data/onek.data';
QUERY: COPY onek TO '/usr/src/pgsql/src/test/regress/input/../results/onek.data';
+ ERROR: COPY command, running in backend with effective uid 503, could not open file
'/usr/src/pgsql/src/test/regress/input/../results/onek.data'for writing. Errno = Permission denied (13).
QUERY: DELETE FROM onek;
QUERY: COPY onek FROM '/usr/src/pgsql/src/test/regress/input/../results/onek.data';
+ ERROR: COPY command, running in backend with effective uid 503, could not open file
'/usr/src/pgsql/src/test/regress/input/../results/onek.data'for reading. Errno = No such file or directory (2).
QUERY: COPY tenk1 FROM '/usr/src/pgsql/src/test/regress/input/../data/tenk.data';
QUERY: COPY slow_emp4000 FROM '/usr/src/pgsql/src/test/regress/input/../data/rect.data';
QUERY: COPY person FROM '/usr/src/pgsql/src/test/regress/input/../data/person.data';
----------------------
*** expected/select.out Mon Feb 1 21:45:39 1999
--- results/select.out Mon Aug 23 21:44:00 1999
***************
*** 1,176 ****
QUERY: SELECT onek.* WHERE onek.unique1 < 10;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! 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)
QUERY: SELECT onek.unique1, onek.stringu1
WHERE onek.unique1 < 20
ORDER BY unique1 using >;
unique1|stringu1
-------+--------
! 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)
QUERY: SELECT onek.unique1, onek.stringu1
WHERE onek.unique1 > 980
ORDER BY stringu1 using <;
unique1|stringu1
-------+--------
! 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)
QUERY: SELECT onek.unique1, onek.string4
WHERE onek.unique1 > 980
ORDER BY string4 using <, unique1 using >;
unique1|string4
-------+-------
! 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)
QUERY: SELECT onek.unique1, onek.string4
WHERE onek.unique1 > 980
ORDER BY string4 using >, unique1 using <;
unique1|string4
-------+-------
! 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)
QUERY: SELECT onek.unique1, onek.string4
WHERE onek.unique1 < 20
ORDER BY unique1 using >, string4 using <;
unique1|string4
-------+-------
! 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)
QUERY: SELECT onek.unique1, onek.string4
WHERE onek.unique1 < 20
ORDER BY unique1 using <, string4 using >;
unique1|string4
-------+-------
! 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)
QUERY: SELECT two, stringu1, ten, string4
INTO TABLE tmp
--- 1,49 ----
QUERY: SELECT onek.* WHERE onek.unique1 < 10;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
QUERY: SELECT onek.unique1, onek.stringu1
WHERE onek.unique1 < 20
ORDER BY unique1 using >;
unique1|stringu1
-------+--------
! (0 rows)
QUERY: SELECT onek.unique1, onek.stringu1
WHERE onek.unique1 > 980
ORDER BY stringu1 using <;
unique1|stringu1
-------+--------
! (0 rows)
QUERY: SELECT onek.unique1, onek.string4
WHERE onek.unique1 > 980
ORDER BY string4 using <, unique1 using >;
unique1|string4
-------+-------
! (0 rows)
QUERY: SELECT onek.unique1, onek.string4
WHERE onek.unique1 > 980
ORDER BY string4 using >, unique1 using <;
unique1|string4
-------+-------
! (0 rows)
QUERY: SELECT onek.unique1, onek.string4
WHERE onek.unique1 < 20
ORDER BY unique1 using >, string4 using <;
unique1|string4
-------+-------
! (0 rows)
QUERY: SELECT onek.unique1, onek.string4
WHERE onek.unique1 < 20
ORDER BY unique1 using <, string4 using >;
unique1|string4
-------+-------
! (0 rows)
QUERY: SELECT two, stringu1, ten, string4
INTO TABLE tmp
----------------------
*** expected/select_distinct.out Mon Feb 1 21:45:39 1999
--- results/select_distinct.out Mon Aug 23 21:44:01 1999
***************
*** 1,80 ****
QUERY: SELECT DISTINCT two FROM tmp;
two
---
! 0
! 1
! (2 rows)
QUERY: SELECT DISTINCT ten FROM tmp;
ten
---
! 0
! 1
! 2
! 3
! 4
! 5
! 6
! 7
! 8
! 9
! (10 rows)
QUERY: SELECT DISTINCT string4 FROM tmp;
string4
-------
! AAAAxx
! HHHHxx
! OOOOxx
! VVVVxx
! (4 rows)
QUERY: SELECT DISTINCT two, string4, ten
FROM tmp
ORDER BY two using <, string4 using <, ten using <;
two|string4|ten
---+-------+---
! 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)
QUERY: SELECT DISTINCT p.age FROM person* p ORDER BY age using >;
age
--- 1,24 ----
QUERY: SELECT DISTINCT two FROM tmp;
two
---
! (0 rows)
QUERY: SELECT DISTINCT ten FROM tmp;
ten
---
! (0 rows)
QUERY: SELECT DISTINCT string4 FROM tmp;
string4
-------
! (0 rows)
QUERY: SELECT DISTINCT two, string4, ten
FROM tmp
ORDER BY two using <, string4 using <, ten using <;
two|string4|ten
---+-------+---
! (0 rows)
QUERY: SELECT DISTINCT p.age FROM person* p ORDER BY age using >;
age
----------------------
*** expected/select_distinct_on.out Mon Feb 1 21:45:40 1999
--- results/select_distinct_on.out Mon Aug 23 21:44:01 1999
***************
*** 3,15 ****
ORDER BY two using <, string4 using <, ten using <;
two|string4|ten
---+-------+---
! 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)
--- 3,7 ----
ORDER BY two using <, string4 using <, ten using <;
two|string4|ten
---+-------+---
! (0 rows)
----------------------
*** expected/aggregates.out Tue Apr 29 09:23:15 1997
--- results/aggregates.out Mon Aug 23 21:44:12 1999
***************
*** 1,7 ****
QUERY: SELECT avg(four) AS avg_1 FROM onek;
avg_1
-----
! 1
(1 row)
QUERY: SELECT avg(a) AS avg_32 FROM aggtest WHERE a < 100;
--- 1,7 ----
QUERY: SELECT avg(four) AS avg_1 FROM onek;
avg_1
-----
!
(1 row)
QUERY: SELECT avg(a) AS avg_32 FROM aggtest WHERE a < 100;
***************
*** 25,31 ****
QUERY: SELECT sum(four) AS sum_1500 FROM onek;
sum_1500
--------
! 1500
(1 row)
QUERY: SELECT sum(a) AS sum_198 FROM aggtest;
--- 25,31 ----
QUERY: SELECT sum(four) AS sum_1500 FROM onek;
sum_1500
--------
!
(1 row)
QUERY: SELECT sum(a) AS sum_198 FROM aggtest;
***************
*** 49,55 ****
QUERY: SELECT max(four) AS max_3 FROM onek;
max_3
-----
! 3
(1 row)
QUERY: SELECT max(a) AS max_100 FROM aggtest;
--- 49,55 ----
QUERY: SELECT max(four) AS max_3 FROM onek;
max_3
-----
!
(1 row)
QUERY: SELECT max(a) AS max_100 FROM aggtest;
***************
*** 73,96 ****
QUERY: SELECT count(four) AS cnt_1000 FROM onek;
cnt_1000
--------
! 1000
(1 row)
QUERY: SELECT newavg(four) AS avg_1 FROM onek;
avg_1
-----
! 1
(1 row)
QUERY: SELECT newsum(four) AS sum_1500 FROM onek;
sum_1500
--------
! 1500
(1 row)
QUERY: SELECT newcnt(four) AS cnt_1000 FROM onek;
cnt_1000
--------
! 1000
(1 row)
--- 73,96 ----
QUERY: SELECT count(four) AS cnt_1000 FROM onek;
cnt_1000
--------
! 0
(1 row)
QUERY: SELECT newavg(four) AS avg_1 FROM onek;
avg_1
-----
! 0
(1 row)
QUERY: SELECT newsum(four) AS sum_1500 FROM onek;
sum_1500
--------
! 0
(1 row)
QUERY: SELECT newcnt(four) AS cnt_1000 FROM onek;
cnt_1000
--------
! 0
(1 row)
----------------------
*** expected/random.out Mon Aug 17 11:11:15 1998
--- results/random.out Mon Aug 23 21:44:14 1999
***************
*** 1,7 ****
QUERY: SELECT count(*) FROM onek;
count
-----
! 1000
(1 row)
QUERY: SELECT count(*) AS random INTO RANDOM_TBL
--- 1,7 ----
QUERY: SELECT count(*) FROM onek;
count
-----
! 0
(1 row)
QUERY: SELECT count(*) AS random INTO RANDOM_TBL
***************
*** 13,23 ****
GROUP BY random HAVING count(random) > 1;
random|count
------+-----
! (0 rows)
QUERY: SELECT random FROM RANDOM_TBL
WHERE random NOT BETWEEN 80 AND 120;
random
------
! (0 rows)
--- 13,26 ----
GROUP BY random HAVING count(random) > 1;
random|count
------+-----
! 0| 2
! (1 row)
QUERY: SELECT random FROM RANDOM_TBL
WHERE random NOT BETWEEN 80 AND 120;
random
------
! 0
! 0
! (2 rows)
----------------------
*** expected/misc.out Mon Aug 23 21:40:32 1999
--- results/misc.out Mon Aug 23 21:44:18 1999
***************
*** 12,45 ****
onek2.stringu1 = tmp.stringu1;
QUERY: DROP TABLE tmp;
QUERY: COPY onek TO '/usr/src/pgsql/src/test/regress/input/../results/onek.data';
QUERY: DELETE FROM onek;
QUERY: COPY onek FROM '/usr/src/pgsql/src/test/regress/input/../results/onek.data';
QUERY: SELECT unique1 FROM onek WHERE unique1 < 2;
unique1
-------
! 0
! 1
! (2 rows)
QUERY: DELETE FROM onek2;
QUERY: COPY onek2 FROM '/usr/src/pgsql/src/test/regress/input/../results/onek.data';
QUERY: SELECT unique1 FROM onek2 WHERE unique1 < 2;
unique1
-------
! 0
! 1
! (2 rows)
QUERY: COPY BINARY stud_emp TO '/usr/src/pgsql/src/test/regress/input/../results/stud_emp.data';
QUERY: DELETE FROM stud_emp;
QUERY: COPY BINARY stud_emp FROM '/usr/src/pgsql/src/test/regress/input/../results/stud_emp.data';
QUERY: SELECT * FROM stud_emp;
name |age|location |salary|manager|gpa|percent
! -----+---+----------+------+-------+---+-------
! 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)
QUERY: SELECT * FROM a_star*;
class| a
--- 12,43 ----
onek2.stringu1 = tmp.stringu1;
QUERY: DROP TABLE tmp;
QUERY: COPY onek TO '/usr/src/pgsql/src/test/regress/input/../results/onek.data';
+ ERROR: COPY command, running in backend with effective uid 503, could not open file
'/usr/src/pgsql/src/test/regress/input/../results/onek.data'for writing. Errno = Permission denied (13).
QUERY: DELETE FROM onek;
QUERY: COPY onek FROM '/usr/src/pgsql/src/test/regress/input/../results/onek.data';
+ ERROR: COPY command, running in backend with effective uid 503, could not open file
'/usr/src/pgsql/src/test/regress/input/../results/onek.data'for reading. Errno = No such file or directory (2).
QUERY: SELECT unique1 FROM onek WHERE unique1 < 2;
unique1
-------
! (0 rows)
QUERY: DELETE FROM onek2;
QUERY: COPY onek2 FROM '/usr/src/pgsql/src/test/regress/input/../results/onek.data';
+ ERROR: COPY command, running in backend with effective uid 503, could not open file
'/usr/src/pgsql/src/test/regress/input/../results/onek.data'for reading. Errno = No such file or directory (2).
QUERY: SELECT unique1 FROM onek2 WHERE unique1 < 2;
unique1
-------
! (0 rows)
QUERY: COPY BINARY stud_emp TO '/usr/src/pgsql/src/test/regress/input/../results/stud_emp.data';
+ ERROR: COPY command, running in backend with effective uid 503, could not open file
'/usr/src/pgsql/src/test/regress/input/../results/stud_emp.data'for writing. Errno = Permission denied (13).
QUERY: DELETE FROM stud_emp;
QUERY: COPY BINARY stud_emp FROM '/usr/src/pgsql/src/test/regress/input/../results/stud_emp.data';
+ ERROR: COPY command, running in backend with effective uid 503, could not open file
'/usr/src/pgsql/src/test/regress/input/../results/stud_emp.data'for reading. Errno = No such file or directory (2).
QUERY: SELECT * FROM stud_emp;
name|age|location|salary|manager|gpa|percent
! ----+---+--------+------+-------+---+-------
! (0 rows)
QUERY: SELECT * FROM a_star*;
class| a
***************
*** 376,383 ****
mike |posthacking
joe |basketball
sally|basketball
! jeff |posthacking
! (4 rows)
QUERY: SELECT DISTINCT hobbies_r.name, hobbies_r.equipment.name FROM hobbies_r;
name |name
--- 374,380 ----
mike |posthacking
joe |basketball
sally|basketball
! (3 rows)
QUERY: SELECT DISTINCT hobbies_r.name, hobbies_r.equipment.name FROM hobbies_r;
name |name
***************
*** 414,421 ****
mike |posthacking|advil
joe |basketball |peet's coffee
sally|basketball |hightops
! jeff |posthacking|advil
! (4 rows)
QUERY: SELECT p.hobbies.equipment.name, p.name, p.hobbies.name FROM person p;
name |name |name
--- 411,417 ----
mike |posthacking|advil
joe |basketball |peet's coffee
sally|basketball |hightops
! (3 rows)
QUERY: SELECT p.hobbies.equipment.name, p.name, p.hobbies.name FROM person p;
name |name |name
***************
*** 431,438 ****
advil |mike |posthacking
hightops|joe |basketball
hightops|sally|basketball
! advil |jeff |posthacking
! (4 rows)
QUERY: SELECT p.hobbies.equipment.name, p.hobbies.name, p.name FROM person p;
name |name |name
--- 427,433 ----
advil |mike |posthacking
hightops|joe |basketball
hightops|sally|basketball
! (3 rows)
QUERY: SELECT p.hobbies.equipment.name, p.hobbies.name, p.name FROM person p;
name |name |name
***************
*** 448,455 ****
advil |posthacking|mike
peet's coffee|basketball |joe
hightops |basketball |sally
! advil |posthacking|jeff
! (4 rows)
QUERY: SELECT user_relns() AS user_relns
ORDER BY user_relns;
--- 443,449 ----
advil |posthacking|mike
peet's coffee|basketball |joe
hightops |basketball |sally
! (3 rows)
QUERY: SELECT user_relns() AS user_relns
ORDER BY user_relns;
----------------------
*** expected/portals_p2.out Mon May 5 01:43:59 1997
--- results/portals_p2.out Mon Aug 23 21:44:38 1999
***************
*** 28,107 ****
QUERY: FETCH all in foo13;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! 50| 253| 0| 2| 0| 10| 0| 50| 50| 50| 50| 0| 1|YBAAAA |TJAAAA |HHHHxx
! (1 row)
QUERY: FETCH all in foo14;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! 51| 76| 1| 3| 1| 11| 1| 51| 51| 51| 51| 2| 3|ZBAAAA |YCAAAA |AAAAxx
! (1 row)
QUERY: FETCH all in foo15;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! 52| 985| 0| 0| 2| 12| 2| 52| 52| 52| 52| 4| 5|ACAAAA |XLBAAA |HHHHxx
! (1 row)
QUERY: FETCH all in foo16;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! 53| 196| 1| 1| 3| 13| 3| 53| 53| 53| 53| 6| 7|BCAAAA |OHAAAA |AAAAxx
! (1 row)
QUERY: FETCH all in foo17;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! 54| 356| 0| 2| 4| 14| 4| 54| 54| 54| 54| 8| 9|CCAAAA |SNAAAA |AAAAxx
! (1 row)
QUERY: FETCH all in foo18;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! 55| 627| 1| 3| 5| 15| 5| 55| 55| 55| 55| 10| 11|DCAAAA |DYAAAA |VVVVxx
! (1 row)
QUERY: FETCH all in foo19;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! 56| 54| 0| 0| 6| 16| 6| 56| 56| 56| 56| 12| 13|ECAAAA |CCAAAA |OOOOxx
! (1 row)
QUERY: FETCH all in foo20;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! 57| 942| 1| 1| 7| 17| 7| 57| 57| 57| 57| 14| 15|FCAAAA |GKBAAA |OOOOxx
! (1 row)
QUERY: FETCH all in foo21;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! 58| 114| 0| 2| 8| 18| 8| 58| 58| 58| 58| 16| 17|GCAAAA |KEAAAA |OOOOxx
! (1 row)
QUERY: FETCH all in foo22;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! 59| 593| 1| 3| 9| 19| 9| 59| 59| 59| 59| 18| 19|HCAAAA |VWAAAA |HHHHxx
! (1 row)
QUERY: FETCH all in foo23;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! 60| 483| 0| 0| 0| 0| 0| 60| 60| 60| 60| 0| 1|ICAAAA |PSAAAA |VVVVxx
! (1 row)
QUERY: FETCH all in foo24;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! 50| 253| 0| 2| 0| 10| 0| 50| 50| 50| 50| 0| 1|YBAAAA |TJAAAA |HHHHxx
! (1 row)
QUERY: FETCH all in foo25;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! 60| 483| 0| 0| 0| 0| 0| 60| 60| 60| 60| 0| 1|ICAAAA |PSAAAA |VVVVxx
! (1 row)
QUERY: CLOSE foo13;
QUERY: CLOSE foo14;
--- 28,94 ----
QUERY: FETCH all in foo13;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
QUERY: FETCH all in foo14;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
QUERY: FETCH all in foo15;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
QUERY: FETCH all in foo16;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
QUERY: FETCH all in foo17;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
QUERY: FETCH all in foo18;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
QUERY: FETCH all in foo19;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
QUERY: FETCH all in foo20;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
QUERY: FETCH all in foo21;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
QUERY: FETCH all in foo22;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
QUERY: FETCH all in foo23;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
QUERY: FETCH all in foo24;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
QUERY: FETCH all in foo25;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
QUERY: CLOSE foo13;
QUERY: CLOSE foo14;
----------------------
*** expected/limit.out Mon Feb 8 08:14:22 1999
--- results/limit.out Mon Aug 23 21:45:16 1999
***************
*** 3,42 ****
ORDER BY unique1 LIMIT 2;
two|unique1|unique2|stringu1
---+-------+-------+--------
! | 51| 76|ZBAAAA
! | 52| 985|ACAAAA
! (2 rows)
QUERY: SELECT ''::text AS five, unique1, unique2, stringu1
FROM onek WHERE unique1 > 60
ORDER BY unique1 LIMIT 5;
five|unique1|unique2|stringu1
----+-------+-------+--------
! | 61| 560|JCAAAA
! | 62| 633|KCAAAA
! | 63| 296|LCAAAA
! | 64| 479|MCAAAA
! | 65| 64|NCAAAA
! (5 rows)
QUERY: SELECT ''::text AS two, unique1, unique2, stringu1
FROM onek WHERE unique1 > 60 AND unique1 < 63
ORDER BY unique1 LIMIT 5;
two|unique1|unique2|stringu1
---+-------+-------+--------
! | 61| 560|JCAAAA
! | 62| 633|KCAAAA
! (2 rows)
QUERY: SELECT ''::text AS three, unique1, unique2, stringu1
FROM onek WHERE unique1 > 100
ORDER BY unique1 LIMIT 3 OFFSET 20;
three|unique1|unique2|stringu1
-----+-------+-------+--------
! | 121| 700|REAAAA
! | 122| 519|SEAAAA
! | 123| 777|TEAAAA
! (3 rows)
QUERY: SELECT ''::text AS zero, unique1, unique2, stringu1
FROM onek WHERE unique1 < 50
--- 3,30 ----
ORDER BY unique1 LIMIT 2;
two|unique1|unique2|stringu1
---+-------+-------+--------
! (0 rows)
QUERY: SELECT ''::text AS five, unique1, unique2, stringu1
FROM onek WHERE unique1 > 60
ORDER BY unique1 LIMIT 5;
five|unique1|unique2|stringu1
----+-------+-------+--------
! (0 rows)
QUERY: SELECT ''::text AS two, unique1, unique2, stringu1
FROM onek WHERE unique1 > 60 AND unique1 < 63
ORDER BY unique1 LIMIT 5;
two|unique1|unique2|stringu1
---+-------+-------+--------
! (0 rows)
QUERY: SELECT ''::text AS three, unique1, unique2, stringu1
FROM onek WHERE unique1 > 100
ORDER BY unique1 LIMIT 3 OFFSET 20;
three|unique1|unique2|stringu1
-----+-------+-------+--------
! (0 rows)
QUERY: SELECT ''::text AS zero, unique1, unique2, stringu1
FROM onek WHERE unique1 < 50
***************
*** 50,106 ****
ORDER BY unique1 DESC LIMIT 20 OFFSET 39;
eleven|unique1|unique2|stringu1
------+-------+-------+--------
! | 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)
QUERY: SELECT ''::text AS ten, unique1, unique2, stringu1
FROM onek
ORDER BY unique1 OFFSET 990;
ten|unique1|unique2|stringu1
---+-------+-------+--------
! | 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)
QUERY: SELECT ''::text AS five, unique1, unique2, stringu1
FROM onek
ORDER BY unique1 OFFSET 990 LIMIT 5;
five|unique1|unique2|stringu1
----+-------+-------+--------
! | 990| 369|CMAAAA
! | 991| 426|DMAAAA
! | 992| 363|EMAAAA
! | 993| 661|FMAAAA
! | 994| 695|GMAAAA
! (5 rows)
QUERY: SELECT ''::text AS five, unique1, unique2, stringu1
FROM onek
ORDER BY unique1 LIMIT 5, 900;
five|unique1|unique2|stringu1
----+-------+-------+--------
! | 900| 913|QIAAAA
! | 901| 931|RIAAAA
! | 902| 702|SIAAAA
! | 903| 641|TIAAAA
! | 904| 793|UIAAAA
! (5 rows)
--- 38,63 ----
ORDER BY unique1 DESC LIMIT 20 OFFSET 39;
eleven|unique1|unique2|stringu1
------+-------+-------+--------
! (0 rows)
QUERY: SELECT ''::text AS ten, unique1, unique2, stringu1
FROM onek
ORDER BY unique1 OFFSET 990;
ten|unique1|unique2|stringu1
---+-------+-------+--------
! (0 rows)
QUERY: SELECT ''::text AS five, unique1, unique2, stringu1
FROM onek
ORDER BY unique1 OFFSET 990 LIMIT 5;
five|unique1|unique2|stringu1
----+-------+-------+--------
! (0 rows)
QUERY: SELECT ''::text AS five, unique1, unique2, stringu1
FROM onek
ORDER BY unique1 LIMIT 5, 900;
five|unique1|unique2|stringu1
----+-------+-------+--------
! (0 rows)
----------------------