Changeset: b894c0c862cd for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b894c0c862cd
Modified Files:
sql/test/pg_regress/Tests/alter_table.stable.out
sql/test/pg_regress/Tests/horology.stable.out
sql/test/pg_regress/Tests/interval.stable.out
sql/test/pg_regress/Tests/interval.stable.out.int128
sql/test/pg_regress/Tests/reltime.stable.out
sql/test/pg_regress/Tests/time.stable.out
sql/test/pg_regress/Tests/timestamp.stable.out
sql/test/pg_regress/Tests/timestamptz.stable.out
sql/test/pg_regress/Tests/timetz.stable.out
Branch: Jul2015
Log Message:
A sec_interval result column now reports length of 14 instead of 0.
Approved all changed .stable.out files to resolve testweb errors.
diffs (290 lines):
diff --git a/sql/test/pg_regress/Tests/alter_table.stable.out
b/sql/test/pg_regress/Tests/alter_table.stable.out
--- a/sql/test/pg_regress/Tests/alter_table.stable.out
+++ b/sql/test/pg_regress/Tests/alter_table.stable.out
@@ -64,7 +64,7 @@ Ready.
% sys.tmp, sys.tmp, sys.tmp, sys.tmp, sys.tmp,
sys.tmp, sys.tmp, sys.tmp, sys.tmp, sys.tmp,
sys.tmp, sys.tmp, sys.tmp, sys.tmp, sys.tmp,
sys.tmp, sys.tmp, sys.tmp, sys.tmp, sys.tmp,
sys.tmp, sys.tmp, sys.tmp, sys.tmp, sys.tmp,
sys.tmp # table_name
% initial, a, b, c, d, e, f, g, h,
i, j, k, l, m, n, p, q, r, s,
t, u, v, w, x, y, z # name
% int, int, clob, clob, double, double, smallint, clob, clob,
char, clob, int, clob, clob, clob, clob, clob, clob, clob,
clob, clob, timestamp, sec_interval, clob, clob, clob # type
-% 1, 1, 4, 4, 24, 24, 1, 17, 24, 1,
62, 6, 5, 3, 15, 13, 9, 17, 21, 17,
20, 26, 0, 17, 17, 9 # length
+% 1, 1, 4, 4, 24, 24, 1, 17, 24, 1,
62, 6, 5, 3, 15, 13, 9, 17, 21, 17,
20, 26, 14, 17, 17, 9 # length
[ NULL, 4, "name", "text", 4.1, 4.1, 2,
"(4.1,4.1,3.1,3.1)", "Mon May 1 00:30:30 1995", "c", "{Mon May 1
00:30:30 1995, Monday Aug 24 14:43:07 1992, epoch}", 314159, "(1,1)",
"512", "1 2 3 4 5 6 7 8", "magnetic disk", "(1.1,1.1)",
"(4.1,4.1,3.1,3.1)", "(0,2,4.1,4.1,3.1,3.1)", "(4.1,4.1,3.1,3.1)",
"[\"epoch\" \"infinity\"]", 2014-11-14 16:27:15.000000, 3610.000,
"{1.0,2.0,3.0,4.0}", "{1.0,2.0,3.0,4.0}", "{1,2,3,4}" ]
#DROP TABLE tmp;
#CREATE TABLE tmp (
@@ -108,7 +108,7 @@ Ready.
% sys.tmp, sys.tmp, sys.tmp, sys.tmp, sys.tmp,
sys.tmp, sys.tmp, sys.tmp, sys.tmp, sys.tmp,
sys.tmp, sys.tmp, sys.tmp, sys.tmp, sys.tmp,
sys.tmp, sys.tmp, sys.tmp, sys.tmp, sys.tmp,
sys.tmp, sys.tmp, sys.tmp, sys.tmp, sys.tmp,
sys.tmp # table_name
% initial, a, b, c, d, e, f, g, h,
i, j, k, l, m, n, p, q, r, s,
t, u, v, w, x, y, z # name
% int, int, clob, clob, double, double, smallint, clob, clob,
char, clob, int, clob, clob, clob, clob, clob, clob, clob,
clob, clob, timestamp, sec_interval, clob, clob, clob # type
-% 1, 1, 4, 4, 24, 24, 1, 17, 24, 1,
62, 6, 5, 3, 15, 13, 9, 17, 21, 17,
20, 26, 0, 17, 17, 9 # length
+% 1, 1, 4, 4, 24, 24, 1, 17, 24, 1,
62, 6, 5, 3, 15, 13, 9, 17, 21, 17,
20, 26, 14, 17, 17, 9 # length
[ NULL, 4, "name", "text", 4.1, 4.1, 2,
"(4.1,4.1,3.1,3.1)", "Mon May 1 00:30:30 1995", "c", "{Mon May 1
00:30:30 1995, Monday Aug 24 14:43:07 1992, epoch}", 314159, "(1,1)",
"512", "1 2 3 4 5 6 7 8", "magnetic disk", "(1.1,1.1)",
"(4.1,4.1,3.1,3.1)", "(0,2,4.1,4.1,3.1,3.1)", "(4.1,4.1,3.1,3.1)",
"[\"epoch\" \"infinity\"]", 2014-11-14 23:59:59.900000, 3610.000,
"{1.0,2.0,3.0,4.0}", "{1.0,2.0,3.0,4.0}", "{1,2,3,4}" ]
#DROP TABLE tmp;
#CREATE TABLE tmp (regtable int);
diff --git a/sql/test/pg_regress/Tests/horology.stable.out
b/sql/test/pg_regress/Tests/horology.stable.out
--- a/sql/test/pg_regress/Tests/horology.stable.out
+++ b/sql/test/pg_regress/Tests/horology.stable.out
@@ -52,14 +52,14 @@ Ready.
% .L, sys.L, .L, sys.L # table_name
% 16, timestamp, gpstime_zero, difference # name
% char, timestamptz, timestamptz, sec_interval # type
-% 0, 32, 32, 0 # length
+% 0, 32, 32, 14 # length
#SELECT '' AS "226", d1.f1 AS timestamp1, d2.f1 AS timestamp2, d1.f1 - d2.f1
AS difference
# FROM TEMP_TIMESTAMP d1, TEMP_TIMESTAMP d2
# ORDER BY timestamp1, timestamp2, difference;
% .L, sys.L, sys.L, sys.L # table_name
% 226, timestamp1, timestamp2, difference # name
% char, timestamptz, timestamptz, sec_interval # type
-% 0, 32, 32, 0 # length
+% 0, 32, 32, 14 # length
#DROP TABLE TEMP_TIMESTAMP;
# 17:11:19 >
diff --git a/sql/test/pg_regress/Tests/interval.stable.out
b/sql/test/pg_regress/Tests/interval.stable.out
--- a/sql/test/pg_regress/Tests/interval.stable.out
+++ b/sql/test/pg_regress/Tests/interval.stable.out
@@ -29,7 +29,7 @@ Ready.
% .L1 # table_name
% Five hours # name
% sec_interval # type
-% 0 # length
+% 14 # length
[ -5.000 ]
#CREATE TABLE INTERVAL_TBL (f1 interval second);
#INSERT INTO INTERVAL_TBL (f1) VALUES ('1.2345');
@@ -46,7 +46,7 @@ Ready.
% .L, sys.interval_tbl # table_name
% ten, f1 # name
% char, sec_interval # type
-% 0, 0 # length
+% 0, 14 # length
[ "", 1.234 ]
[ "", 63513504000.000 ]
[ "", -5670419503621183.312 ]
@@ -59,7 +59,7 @@ Ready.
% .L, sys.r1, sys.r2 # table_name
% fortyfive, f1, f1 # name
% char, sec_interval, sec_interval # type
-% 0, 0, 0 # length
+% 0, 14, 14 # length
[ "", -1363962815083169.272, -5670419503621183.312 ]
[ "", -1.000, -5670419503621183.312 ]
[ "", -1.000, -1363962815083169.272 ]
@@ -74,7 +74,7 @@ Ready.
% .L, sys.interval_tbl # table_name
% ten, f1 # name
% char, sec_interval # type
-% 0, 0 # length
+% 0, 14 # length
[ "", 63513504000.000 ]
[ "", 1.234 ]
[ "", -1.000 ]
@@ -84,13 +84,13 @@ Ready.
% sys.L1 # table_name
% L1 # name
% sec_interval # type
-% 0 # length
+% 14 # length
[ -5670419503621183.312 ]
#select max(f1) from interval_tbl;
% sys.L1 # table_name
% L1 # name
% sec_interval # type
-% 0 # length
+% 14 # length
[ 63513504000.000 ]
#select count(f1) from interval_tbl;
% sys.L1 # table_name
diff --git a/sql/test/pg_regress/Tests/interval.stable.out.int128
b/sql/test/pg_regress/Tests/interval.stable.out.int128
--- a/sql/test/pg_regress/Tests/interval.stable.out.int128
+++ b/sql/test/pg_regress/Tests/interval.stable.out.int128
@@ -29,7 +29,7 @@ Ready.
% .L1 # table_name
% Five hours # name
% sec_interval # type
-% 0 # length
+% 14 # length
[ -5.000 ]
#CREATE TABLE INTERVAL_TBL (f1 interval second);
#INSERT INTO INTERVAL_TBL (f1) VALUES ('1.2345');
@@ -46,7 +46,7 @@ Ready.
% .L, sys.interval_tbl # table_name
% ten, f1 # name
% char, sec_interval # type
-% 0, 0 # length
+% 0, 14 # length
[ "", 1.234 ]
[ "", 63513504000.000 ]
[ "", -5670419503621183.312 ]
@@ -59,7 +59,7 @@ Ready.
% .L, sys.r1, sys.r2 # table_name
% fortyfive, f1, f1 # name
% char, sec_interval, sec_interval # type
-% 0, 0, 0 # length
+% 0, 14, 14 # length
[ "", -1363962815083169.272, -5670419503621183.312 ]
[ "", -1.000, -5670419503621183.312 ]
[ "", -1.000, -1363962815083169.272 ]
@@ -74,7 +74,7 @@ Ready.
% .L, sys.interval_tbl # table_name
% ten, f1 # name
% char, sec_interval # type
-% 0, 0 # length
+% 0, 14 # length
[ "", 63513504000.000 ]
[ "", 1.234 ]
[ "", -1.000 ]
@@ -90,13 +90,13 @@ Ready.
% sys.L1 # table_name
% L1 # name
% sec_interval # type
-% 0 # length
+% 14 # length
[ -5670419503621183.312 ]
#select max(f1) from interval_tbl;
% sys.L1 # table_name
% L1 # name
% sec_interval # type
-% 0 # length
+% 14 # length
[ 63513504000.000 ]
#select sum(cast(f1 as decimal(22,3))) from interval_tbl;
% sys.L2 # table_name
diff --git a/sql/test/pg_regress/Tests/reltime.stable.out
b/sql/test/pg_regress/Tests/reltime.stable.out
--- a/sql/test/pg_regress/Tests/reltime.stable.out
+++ b/sql/test/pg_regress/Tests/reltime.stable.out
@@ -29,7 +29,7 @@ Ready.
% .L, sys.reltime_tbl # table_name
% six, f1 # name
% char, sec_interval # type
-% 0, 0 # length
+% 0, 14 # length
#SELECT '' AS fifteen, r1.*, r2.*
# FROM RELTIME_TBL r1, RELTIME_TBL r2
# WHERE r1.f1 > r2.f1
@@ -37,7 +37,7 @@ Ready.
% .L, sys.r1, sys.r2 # table_name
% fifteen, f1, f1 # name
% char, sec_interval, sec_interval # type
-% 0, 0, 0 # length
+% 0, 14, 14 # length
#DROP TABLE RELTIME_TBL;
# 15:01:55 >
diff --git a/sql/test/pg_regress/Tests/time.stable.out
b/sql/test/pg_regress/Tests/time.stable.out
--- a/sql/test/pg_regress/Tests/time.stable.out
+++ b/sql/test/pg_regress/Tests/time.stable.out
@@ -194,7 +194,7 @@ Ready.
% sys.time_tbl, sys.L1 # table_name
% f1, sql_sub_f1 # name
% time, sec_interval # type
-% 11, 0 # length
+% 11, 14 # length
[ 00:00:00.00, -84141.000 ]
[ 01:00:00.00, -80541.000 ]
[ 12:00:00.00, -40941.000 ]
@@ -205,7 +205,7 @@ Ready.
% sys.time_tbl, .L1 # table_name
% f1, sql_sub_single_value # name
% time, sec_interval # type
-% 11, 0 # length
+% 11, 14 # length
[ 00:00:00.00, 84141.000 ]
[ 01:00:00.00, 80541.000 ]
[ 12:00:00.00, 40941.000 ]
diff --git a/sql/test/pg_regress/Tests/timestamp.stable.out
b/sql/test/pg_regress/Tests/timestamp.stable.out
--- a/sql/test/pg_regress/Tests/timestamp.stable.out
+++ b/sql/test/pg_regress/Tests/timestamp.stable.out
@@ -190,7 +190,7 @@ Ready.
% .L, sys.L1 # table_name
% 54, diff # name
% char, sec_interval # type
-% 0, 0 # length
+% 0, 14 # length
[ "", 0.000 ]
[ "", 11045.000 ]
[ "", 3461521.000 ]
@@ -205,7 +205,7 @@ Ready.
% .L2, sys.L3 # table_name
% 54, diff # name
% char, sec_interval # type
-% 0, 0 # length
+% 0, 14 # length
[ "", 0.000 ]
[ "", 11045.000 ]
[ "", 3461521.000 ]
@@ -544,7 +544,7 @@ Ready.
% sys.timestamp_tbl, sys.L1 # table_name
% d1, sql_sub_d1 # name
% timestamp, sec_interval # type
-% 22, 0 # length
+% 22, 14 # length
[ 1997-01-02 00:00:00.00, -156036141.000 ]
[ 1997-01-02 03:04:05.00, -156025096.000 ]
[ 1997-02-11 01:32:01.00, -152574620.000 ]
@@ -557,7 +557,7 @@ Ready.
% sys.timestamp_tbl, .L1 # table_name
% d1, sql_sub_single_value # name
% timestamp, sec_interval # type
-% 22, 0 # length
+% 22, 14 # length
[ 1997-01-02 00:00:00.00, 156036141.000 ]
[ 1997-01-02 03:04:05.00, 156025096.000 ]
[ 1997-02-11 01:32:01.00, 152574620.000 ]
diff --git a/sql/test/pg_regress/Tests/timestamptz.stable.out
b/sql/test/pg_regress/Tests/timestamptz.stable.out
--- a/sql/test/pg_regress/Tests/timestamptz.stable.out
+++ b/sql/test/pg_regress/Tests/timestamptz.stable.out
@@ -206,7 +206,7 @@ Ready.
% .L, sys.L1 # table_name
% 54, diff # name
% char, sec_interval # type
-% 0, 0 # length
+% 0, 14 # length
[ "", 0.000 ]
[ "", 11045.000 ]
[ "", 3461521.000 ]
@@ -220,7 +220,7 @@ Ready.
% .L2, sys.L3 # table_name
% 54, diff # name
% char, sec_interval # type
-% 0, 0 # length
+% 0, 14 # length
[ "", 0.000 ]
[ "", 11045.000 ]
[ "", 3461521.000 ]
@@ -557,7 +557,7 @@ Ready.
% sys.timestamptz_tbl, sys.L1 # table_name
% d1, sql_sub_d1 # name
% timestamptz, sec_interval # type
-% 28, 0 # length
+% 28, 14 # length
[ 1997-01-02 01:00:00.00+01:00, -156036141.000 ]
[ 1997-01-02 04:04:05.00+01:00, -156025096.000 ]
[ 1997-02-11 02:32:01.00+01:00, -152574620.000 ]
@@ -570,7 +570,7 @@ Ready.
% sys.timestamptz_tbl, .L1 # table_name
% d1, sql_sub_single_value # name
% timestamptz, sec_interval # type
-% 28, 0 # length
+% 28, 14 # length
[ 1997-01-02 01:00:00.00+01:00, 156036141.000 ]
[ 1997-01-02 04:04:05.00+01:00, 156025096.000 ]
[ 1997-02-11 02:32:01.00+01:00, 152574620.000 ]
diff --git a/sql/test/pg_regress/Tests/timetz.stable.out
b/sql/test/pg_regress/Tests/timetz.stable.out
--- a/sql/test/pg_regress/Tests/timetz.stable.out
+++ b/sql/test/pg_regress/Tests/timetz.stable.out
@@ -123,13 +123,13 @@ Ready.
% sys.timetz_tbl, sys.L1 # table_name
% f1, sql_sub_f1 # name
% timetz, sec_interval # type
-% 17, 0 # length
+% 17, 14 # length
[ NULL, NULL ]
#SELECT f1, sql_sub(cast('23:22:21' as timetz), f1) FROM TIMETZ_TBL;
% sys.timetz_tbl, .L1 # table_name
% f1, sql_sub_single_value # name
% timetz, sec_interval # type
-% 17, 0 # length
+% 17, 14 # length
[ NULL, NULL ]
#DROP TABLE TIMETZ_TBL;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
