|
1 | 1 |
|
2 | | -*** expected/float8.outFri Jan 23 11:59:29 1998 |
3 | | ---- results/float8.outWed Feb 25 16:32:43 1998 |
| 2 | +*** expected/float8.outMon Oct 12 16:56:31 1998 |
| 3 | +--- results/float8.outTue Oct 13 17:20:46 1998 |
4 | 4 | *************** |
5 | | -***203,217 **** |
| 5 | +***195,209 **** |
6 | 6 | QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 < '0.0' ; |
7 | 7 | ERROR: can't take log of a negative number |
8 | 8 | QUERY: SELECT '' AS bad, : (f.f1) from FLOAT8_TBL f; |
|
18 | 18 | QUERY: SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f; |
19 | 19 | ERROR: float8div: divide by zero error |
20 | 20 | QUERY: SELECT '' AS five, FLOAT8_TBL.*; |
21 | | ----203,209 ---- |
| 21 | +---195,201 ---- |
22 | 22 | QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 < '0.0' ; |
23 | 23 | ERROR: can't take log of a negative number |
24 | 24 | QUERY: SELECT '' AS bad, : (f.f1) from FLOAT8_TBL f; |
|
29 | 29 |
|
30 | 30 | ---------------------- |
31 | 31 |
|
32 | | -*** expected/geometry.outFri Jan 23 11:59:29 1998 |
33 | | ---- results/geometry.outWed Feb 25 16:32:55 1998 |
34 | | -*************** |
35 | | -***113,119 **** |
36 | | - |(-5,-12) |[(10,-10),(-3,-4)] |(-3,-4) |
37 | | - |(10,10) |[(10,-10),(-3,-4)] |(-3,-4) |
38 | | - |(0,0) |[(-1000000,200),(300000,-40)]|(0.0028402365895872,15.384614860264) |
39 | | -! |(-10,0) |[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140473) |
40 | | - |(-3,4) |[(-1000000,200),(300000,-40)]|(-2.99789812267519,15.3851688427303) |
41 | | - |(5.1,34.5)|[(-1000000,200),(300000,-40)]|(5.09647083221496,15.3836744976925) |
42 | | - |(-5,-12) |[(-1000000,200),(300000,-40)]|(-4.99494420845634,15.3855375281616) |
43 | | ----113,119 ---- |
44 | | - |(-5,-12) |[(10,-10),(-3,-4)] |(-3,-4) |
45 | | - |(10,10) |[(10,-10),(-3,-4)] |(-3,-4) |
46 | | - |(0,0) |[(-1000000,200),(300000,-40)]|(0.0028402365895872,15.384614860264) |
47 | | -! |(-10,0) |[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140472) |
48 | | - |(-3,4) |[(-1000000,200),(300000,-40)]|(-2.99789812267519,15.3851688427303) |
49 | | - |(5.1,34.5)|[(-1000000,200),(300000,-40)]|(5.09647083221496,15.3836744976925) |
50 | | - |(-5,-12) |[(-1000000,200),(300000,-40)]|(-4.99494420845634,15.3855375281616) |
51 | | -*************** |
52 | | -***130,140 **** |
| 32 | +*** expected/geometry.outMon Oct 12 16:56:34 1998 |
| 33 | +--- results/geometry.outTue Oct 13 17:20:57 1998 |
| 34 | +*************** |
| 35 | +***112,118 **** |
| 36 | + |(-5,-12) |[(10,-10),(-3,-4)] |(-1.60487804878049,-4.64390243902439) |
| 37 | + |(10,10) |[(10,-10),(-3,-4)] |(2.39024390243902,-6.48780487804878) |
| 38 | + |(0,0) |[(-1000000,200),(300000,-40)]|(0.0028402365895872,15.384614860264) |
| 39 | +! |(-10,0) |[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140473) |
| 40 | + |(-3,4) |[(-1000000,200),(300000,-40)]|(-2.99789812267519,15.3851688427303) |
| 41 | + |(5.1,34.5)|[(-1000000,200),(300000,-40)]|(5.09647083221496,15.3836744976925) |
| 42 | + |(-5,-12) |[(-1000000,200),(300000,-40)]|(-4.99494420845634,15.3855375281616) |
| 43 | +---112,118 ---- |
| 44 | + |(-5,-12) |[(10,-10),(-3,-4)] |(-1.60487804878049,-4.64390243902439) |
| 45 | + |(10,10) |[(10,-10),(-3,-4)] |(2.39024390243902,-6.48780487804878) |
| 46 | + |(0,0) |[(-1000000,200),(300000,-40)]|(0.0028402365895872,15.384614860264) |
| 47 | +! |(-10,0) |[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140472) |
| 48 | + |(-3,4) |[(-1000000,200),(300000,-40)]|(-2.99789812267519,15.3851688427303) |
| 49 | + |(5.1,34.5)|[(-1000000,200),(300000,-40)]|(5.09647083221496,15.3836744976925) |
| 50 | + |(-5,-12) |[(-1000000,200),(300000,-40)]|(-4.99494420845634,15.3855375281616) |
| 51 | +*************** |
| 52 | +***129,139 **** |
53 | 53 | six|box |
54 | 54 | ---+-------------------------------------------------------------------------- |
55 | 55 | |(2.12132034355964,2.12132034355964),(-2.12132034355964,-2.12132034355964) |
|
61 | 61 | (6 rows) |
62 | 62 |
|
63 | 63 | QUERY: SELECT '' AS twentyfour, b.f1 + p.f1 AS translation |
64 | | ----130,140 ---- |
| 64 | +---129,139 ---- |
65 | 65 | six|box |
66 | 66 | ---+-------------------------------------------------------------------------- |
67 | 67 | |(2.12132034355964,2.12132034355964),(-2.12132034355964,-2.12132034355964) |
|
74 | 74 |
|
75 | 75 | QUERY: SELECT '' AS twentyfour, b.f1 + p.f1 AS translation |
76 | 76 | *************** |
77 | | -***410,434 **** |
| 77 | +***409,433 **** |
78 | 78 | QUERY: SELECT '' AS six, polygon(f1) |
79 | 79 | FROM CIRCLE_TBL; |
80 | 80 | six|polygon |
|
100 | 100 | (6 rows) |
101 | 101 |
|
102 | 102 | QUERY: SELECT '' AS six, circle(f1, 50.0) |
103 | | ----410,434 ---- |
| 103 | +---409,433 ---- |
104 | 104 | QUERY: SELECT '' AS six, polygon(f1) |
105 | 105 | FROM CIRCLE_TBL; |
106 | 106 | six|polygon |
|
127 | 127 |
|
128 | 128 | QUERY: SELECT '' AS six, circle(f1, 50.0) |
129 | 129 | *************** |
130 | | -***467,477 **** |
| 130 | +***466,476 **** |
131 | 131 | WHERE (p1.f1 <-> c1.f1) > 0 |
132 | 132 | ORDER BY distance, circle, point using <<; |
133 | 133 | twentyfour|circle |point | distance |
|
139 | 139 | |<(100,0),100> |(-5,-12) | 5.68348972285122 |
140 | 140 | |<(1,3),5> |(-10,0) | 6.40175425099138 |
141 | 141 | |<(1,3),5> |(10,10) | 6.40175425099138 |
142 | | ----467,477 ---- |
| 142 | +---466,476 ---- |
143 | 143 | WHERE (p1.f1 <-> c1.f1) > 0 |
144 | 144 | ORDER BY distance, circle, point using <<; |
145 | 145 | twentyfour|circle |point | distance |
|
152 | 152 | |<(1,3),5> |(-10,0) |6.40175425099138 |
153 | 153 | |<(1,3),5> |(10,10) |6.40175425099138 |
154 | 154 | *************** |
155 | | -***483,489 **** |
| 155 | +***482,488 **** |
156 | 156 | |<(0,0),3> |(10,10) | 11.142135623731 |
157 | 157 | |<(1,3),5> |(-5,-12) | 11.1554944214035 |
158 | 158 | |<(1,2),3> |(-5,-12) | 12.2315462117278 |
159 | 159 | ! |<(1,3),5> |(5.1,34.5)| 26.7657047773224 |
160 | 160 | |<(1,2),3> |(5.1,34.5)| 29.757594539282 |
161 | 161 | |<(0,0),3> |(5.1,34.5)| 31.8749193547455 |
162 | 162 | |<(100,200),10>|(5.1,34.5)| 180.778038568384 |
163 | | ----483,489 ---- |
| 163 | +---482,488 ---- |
164 | 164 | |<(0,0),3> |(10,10) | 11.142135623731 |
165 | 165 | |<(1,3),5> |(-5,-12) |11.1554944214035 |
166 | 166 | |<(1,2),3> |(-5,-12) |12.2315462117278 |
|
171 | 171 |
|
172 | 172 | ---------------------- |
173 | 173 |
|
174 | | -*** expected/abstime.outFri Jan 23 11:59:24 1998 |
175 | | ---- results/abstime.outWed Feb 25 16:32:59 1998 |
| 174 | +*** expected/abstime.outMon Oct 12 16:56:25 1998 |
| 175 | +--- results/abstime.outTue Oct 13 17:21:04 1998 |
176 | 176 | *************** |
177 | 177 | *** 22,28 **** |
178 | 178 | |current |
|
354 | 354 |
|
355 | 355 | ---------------------- |
356 | 356 |
|
357 | | -*** expected/tinterval.outFri Jan 23 11:59:43 1998 |
358 | | ---- results/tinterval.outWed Feb 25 16:33:01 1998 |
| 357 | +*** expected/tinterval.outMon Oct 12 16:56:57 1998 |
| 358 | +--- results/tinterval.outTue Oct 13 17:21:05 1998 |
359 | 359 | *************** |
360 | 360 | *** 19,25 **** |
361 | 361 | five|f1 |
|
504 | 504 |
|
505 | 505 | ---------------------- |
506 | 506 |
|
507 | | -*** expected/horology.outFri Jan 23 11:59:30 1998 |
508 | | ---- results/horology.outWed Feb 25 16:33:03 1998 |
| 507 | +*** expected/horology.outMon Oct 12 16:56:40 1998 |
| 508 | +--- results/horology.outTue Oct 13 17:21:08 1998 |
509 | 509 | *************** |
510 | 510 | *** 430,436 **** |
511 | 511 | ORDER BY abstime; |
|
747 | 747 |
|
748 | 748 | ---------------------- |
749 | 749 |
|
750 | | -*** expected/random.outFri Jan 23 11:59:34 1998 |
751 | | ---- results/random.outWed Feb 25 16:37:11 1998 |
752 | | -*************** |
753 | | -*** 7,18 **** |
754 | | - QUERY: SELECT count(*) FROM onek where oidrand(onek.oid, 10); |
755 | | - count |
756 | | - ----- |
757 | | -! 92 |
758 | | - (1 row) |
759 | | - |
760 | | - QUERY: SELECT count(*) FROM onek where oidrand(onek.oid, 10); |
761 | | - count |
762 | | - ----- |
763 | | -! 98 |
764 | | - (1 row) |
765 | | - |
766 | | ---- 7,18 ---- |
767 | | - QUERY: SELECT count(*) FROM onek where oidrand(onek.oid, 10); |
768 | | - count |
769 | | - ----- |
770 | | -! 95 |
771 | | - (1 row) |
772 | | - |
773 | | - QUERY: SELECT count(*) FROM onek where oidrand(onek.oid, 10); |
774 | | - count |
775 | | - ----- |
776 | | -! 88 |
777 | | - (1 row) |
| 750 | +*** expected/random.outMon Oct 12 16:56:50 1998 |
| 751 | +--- results/random.outTue Oct 13 17:24:27 1998 |
| 752 | +*************** |
| 753 | +*** 19,23 **** |
| 754 | + WHERE random NOT BETWEEN 80 AND 120; |
| 755 | + random |
| 756 | + ------ |
| 757 | +! (0 rows) |
| 758 | + |
| 759 | +--- 19,24 ---- |
| 760 | + WHERE random NOT BETWEEN 80 AND 120; |
| 761 | + random |
| 762 | + ------ |
| 763 | +! 121 |
| 764 | +! (1 row) |
778 | 765 |
|
779 | 766 |
|
780 | 767 | ---------------------- |
781 | 768 |
|
| 769 | +*** expected/rules.outMon Oct 12 16:56:51 1998 |
| 770 | +--- results/rules.outTue Oct 13 17:25:33 1998 |
| 771 | +*************** |
| 772 | +*** 315,322 **** |
| 773 | + pname |sysname |
| 774 | + ------+------- |
| 775 | + bm |pluto |
| 776 | +- jwieck|orion |
| 777 | + jwieck|notjw |
| 778 | + (3 rows) |
| 779 | + |
| 780 | + QUERY: delete from rtest_system where sysname = 'orion'; |
| 781 | +--- 315,322 ---- |
| 782 | + pname |sysname |
| 783 | + ------+------- |
| 784 | + bm |pluto |
| 785 | + jwieck|notjw |
| 786 | ++ jwieck|orion |
| 787 | + (3 rows) |
| 788 | + |
| 789 | + QUERY: delete from rtest_system where sysname = 'orion'; |
| 790 | + |
| 791 | +---------------------- |
| 792 | + |