Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit03debe1

Browse files
committed
Add regression tests for MONEY type.
1 parentaca467b commit03debe1

File tree

5 files changed

+252
-4
lines changed

5 files changed

+252
-4
lines changed

‎src/test/regress/expected/money.out

Lines changed: 187 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,187 @@
1+
--
2+
-- MONEY
3+
--
4+
CREATE TABLE money_data (m money);
5+
INSERT INTO money_data VALUES ('123');
6+
SELECT * FROM money_data;
7+
m
8+
---------
9+
$123.00
10+
(1 row)
11+
12+
SELECT m + '123' FROM money_data;
13+
?column?
14+
----------
15+
$246.00
16+
(1 row)
17+
18+
SELECT m + '123.45' FROM money_data;
19+
?column?
20+
----------
21+
$246.45
22+
(1 row)
23+
24+
SELECT m - '123.45' FROM money_data;
25+
?column?
26+
----------
27+
-$0.45
28+
(1 row)
29+
30+
SELECT m * 2 FROM money_data;
31+
?column?
32+
----------
33+
$246.00
34+
(1 row)
35+
36+
SELECT m / 2 FROM money_data;
37+
?column?
38+
----------
39+
$61.50
40+
(1 row)
41+
42+
-- All true
43+
SELECT m = '$123.00' FROM money_data;
44+
?column?
45+
----------
46+
t
47+
(1 row)
48+
49+
SELECT m != '$124.00' FROM money_data;
50+
?column?
51+
----------
52+
t
53+
(1 row)
54+
55+
SELECT m <= '$123.00' FROM money_data;
56+
?column?
57+
----------
58+
t
59+
(1 row)
60+
61+
SELECT m >= '$123.00' FROM money_data;
62+
?column?
63+
----------
64+
t
65+
(1 row)
66+
67+
SELECT m < '$124.00' FROM money_data;
68+
?column?
69+
----------
70+
t
71+
(1 row)
72+
73+
SELECT m > '$122.00' FROM money_data;
74+
?column?
75+
----------
76+
t
77+
(1 row)
78+
79+
-- All false
80+
SELECT m = '$123.01' FROM money_data;
81+
?column?
82+
----------
83+
f
84+
(1 row)
85+
86+
SELECT m != '$123.00' FROM money_data;
87+
?column?
88+
----------
89+
f
90+
(1 row)
91+
92+
SELECT m <= '$122.99' FROM money_data;
93+
?column?
94+
----------
95+
f
96+
(1 row)
97+
98+
SELECT m >= '$123.01' FROM money_data;
99+
?column?
100+
----------
101+
f
102+
(1 row)
103+
104+
SELECT m > '$124.00' FROM money_data;
105+
?column?
106+
----------
107+
f
108+
(1 row)
109+
110+
SELECT m < '$122.00' FROM money_data;
111+
?column?
112+
----------
113+
f
114+
(1 row)
115+
116+
SELECT cashlarger(m, '$124.00') FROM money_data;
117+
cashlarger
118+
------------
119+
$124.00
120+
(1 row)
121+
122+
SELECT cashsmaller(m, '$124.00') FROM money_data;
123+
cashsmaller
124+
-------------
125+
$123.00
126+
(1 row)
127+
128+
SELECT cash_words(m) FROM money_data;
129+
cash_words
130+
-------------------------------------------------
131+
One hundred twenty three dollars and zero cents
132+
(1 row)
133+
134+
SELECT cash_words(m + '1.23') FROM money_data;
135+
cash_words
136+
--------------------------------------------------------
137+
One hundred twenty four dollars and twenty three cents
138+
(1 row)
139+
140+
DELETE FROM money_data;
141+
INSERT INTO money_data VALUES ('$123.45');
142+
SELECT * FROM money_data;
143+
m
144+
---------
145+
$123.45
146+
(1 row)
147+
148+
DELETE FROM money_data;
149+
INSERT INTO money_data VALUES ('$123.451');
150+
SELECT * FROM money_data;
151+
m
152+
---------
153+
$123.45
154+
(1 row)
155+
156+
DELETE FROM money_data;
157+
INSERT INTO money_data VALUES ('$123.454');
158+
SELECT * FROM money_data;
159+
m
160+
---------
161+
$123.45
162+
(1 row)
163+
164+
DELETE FROM money_data;
165+
INSERT INTO money_data VALUES ('$123.455');
166+
SELECT * FROM money_data;
167+
m
168+
---------
169+
$123.46
170+
(1 row)
171+
172+
DELETE FROM money_data;
173+
INSERT INTO money_data VALUES ('$123.456');
174+
SELECT * FROM money_data;
175+
m
176+
---------
177+
$123.46
178+
(1 row)
179+
180+
DELETE FROM money_data;
181+
INSERT INTO money_data VALUES ('$123.459');
182+
SELECT * FROM money_data;
183+
m
184+
---------
185+
$123.46
186+
(1 row)
187+

‎src/test/regress/expected/sanity_check.out

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -66,6 +66,7 @@ SELECT relname, relhasindex
6666
log_table | f
6767
lseg_tbl | f
6868
main_table | f
69+
money_data | f
6970
num_data | f
7071
num_exp_add | t
7172
num_exp_div | t
@@ -148,7 +149,7 @@ SELECT relname, relhasindex
148149
timetz_tbl | f
149150
tinterval_tbl | f
150151
varchar_tbl | f
151-
(137 rows)
152+
(138 rows)
152153

153154
--
154155
-- another sanity check: every system catalog that has OIDs should have

‎src/test/regress/output/misc.source

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -626,6 +626,7 @@ SELECT user_relns() AS user_relns
626626
log_table
627627
lseg_tbl
628628
main_table
629+
money_data
629630
num_data
630631
num_exp_add
631632
num_exp_div
@@ -666,7 +667,7 @@ SELECT user_relns() AS user_relns
666667
toyemp
667668
varchar_tbl
668669
xacttest
669-
(100 rows)
670+
(101 rows)
670671

671672
SELECT name(equipment(hobby_construct(text 'skywalking', text 'mer')));
672673
name

‎src/test/regress/parallel_schedule

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
# ----------
2-
# $PostgreSQL: pgsql/src/test/regress/parallel_schedule,v 1.45 2007/10/13 23:06:27 tgl Exp $
2+
# $PostgreSQL: pgsql/src/test/regress/parallel_schedule,v 1.46 2007/11/24 19:49:23 darcy Exp $
33
#
44
# By convention, we put no more than twenty tests in any one parallel group;
55
# this limits the number of connections needed to run the tests.
@@ -8,7 +8,7 @@
88
# ----------
99
# The first group of parallel tests
1010
# ----------
11-
test: boolean char name varchar text int2 int4 int8 oid float4 float8 bit numeric txid uuid enum
11+
test: boolean char name varchar text int2 int4 int8 oid float4 float8 bit numeric txid uuid enum money
1212

1313
# Depends on things setup during char, varchar and text
1414
test: strings

‎src/test/regress/sql/money.sql

Lines changed: 59 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,59 @@
1+
--
2+
-- MONEY
3+
--
4+
5+
CREATETABLEmoney_data (mmoney);
6+
7+
INSERT INTO money_dataVALUES ('123');
8+
SELECT*FROM money_data;
9+
SELECT m+'123'FROM money_data;
10+
SELECT m+'123.45'FROM money_data;
11+
SELECT m-'123.45'FROM money_data;
12+
SELECT m*2FROM money_data;
13+
SELECT m/2FROM money_data;
14+
15+
-- All true
16+
SELECT m='$123.00'FROM money_data;
17+
SELECT m!='$124.00'FROM money_data;
18+
SELECT m<='$123.00'FROM money_data;
19+
SELECT m>='$123.00'FROM money_data;
20+
SELECT m<'$124.00'FROM money_data;
21+
SELECT m>'$122.00'FROM money_data;
22+
23+
-- All false
24+
SELECT m='$123.01'FROM money_data;
25+
SELECT m!='$123.00'FROM money_data;
26+
SELECT m<='$122.99'FROM money_data;
27+
SELECT m>='$123.01'FROM money_data;
28+
SELECT m>'$124.00'FROM money_data;
29+
SELECT m<'$122.00'FROM money_data;
30+
31+
SELECT cashlarger(m,'$124.00')FROM money_data;
32+
SELECT cashsmaller(m,'$124.00')FROM money_data;
33+
SELECT cash_words(m)FROM money_data;
34+
SELECT cash_words(m+'1.23')FROM money_data;
35+
36+
DELETEFROM money_data;
37+
INSERT INTO money_dataVALUES ('$123.45');
38+
SELECT*FROM money_data;
39+
40+
DELETEFROM money_data;
41+
INSERT INTO money_dataVALUES ('$123.451');
42+
SELECT*FROM money_data;
43+
44+
DELETEFROM money_data;
45+
INSERT INTO money_dataVALUES ('$123.454');
46+
SELECT*FROM money_data;
47+
48+
DELETEFROM money_data;
49+
INSERT INTO money_dataVALUES ('$123.455');
50+
SELECT*FROM money_data;
51+
52+
DELETEFROM money_data;
53+
INSERT INTO money_dataVALUES ('$123.456');
54+
SELECT*FROM money_data;
55+
56+
DELETEFROM money_data;
57+
INSERT INTO money_dataVALUES ('$123.459');
58+
SELECT*FROM money_data;
59+

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp