Changeset: f76552fac321 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f76552fac321
Modified Files:
sql/test/bugs/Tests/WHERE_and_multiple_LEFT_JOIN_incorrect_results-JIRA-43.stable.out
sql/test/pg_regress/Tests/timestamp.stable.out
sql/test/pg_regress/Tests/timestamptz.stable.out
sql/test/sys-schema/Tests/check_MaxStrLength_violations.stable.out
Branch: default
Log Message:
approved output
diffs (130 lines):
diff --git
a/sql/test/bugs/Tests/WHERE_and_multiple_LEFT_JOIN_incorrect_results-JIRA-43.stable.out
b/sql/test/bugs/Tests/WHERE_and_multiple_LEFT_JOIN_incorrect_results-JIRA-43.stable.out
---
a/sql/test/bugs/Tests/WHERE_and_multiple_LEFT_JOIN_incorrect_results-JIRA-43.stable.out
+++
b/sql/test/bugs/Tests/WHERE_and_multiple_LEFT_JOIN_incorrect_results-JIRA-43.stable.out
@@ -70,7 +70,7 @@ stdout of test 'WHERE_and_multiple_LEFT_
#INSERT INTO bar VALUES (1, 111), (1, 222);
[ 2 ]
#SELECT * FROM foo AS f LEFT JOIN bar AS b1 ON f.fooid = b1.fooid LEFT JOIN
bar AS b2 ON f.fooid = b2.fooid WHERE b1.barint > b2.barint;
-% .f, .f, .b1, .b1, .b2, .b2 # table_name
+% .f, .f, .b1, .b1, sys.b2, sys.b2 # table_name
% fooid, fooval, fooid, barint, fooid, barint # name
% int, varchar, int, int, int, int # type
% 1, 1, 1, 3, 1, 3 # length
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
@@ -68,25 +68,25 @@ stdout of test 'timestamp` in directory
#INSERT INTO TIMESTAMP_TBL VALUES (cast((select test_current_date from
test_current_date) + interval '1' DAY as timestamp));
[ 1 ]
#SELECT count(*) AS One FROM TIMESTAMP_TBL WHERE d1 = cast((select
test_current_date from test_current_date) as timestamp);
-% . # table_name
+% sys. # table_name
% one # name
% bigint # type
% 1 # length
[ 1 ]
#SELECT count(*) AS One FROM TIMESTAMP_TBL WHERE d1 = cast((select
test_current_date from test_current_date) + interval '1' DAY as timestamp);
-% . # table_name
+% sys. # table_name
% one # name
% bigint # type
% 1 # length
[ 1 ]
#SELECT count(*) AS One FROM TIMESTAMP_TBL WHERE d1 = cast((select
test_current_date from test_current_date) - interval '1' DAY as timestamp);
-% . # table_name
+% sys. # table_name
% one # name
% bigint # type
% 1 # length
[ 1 ]
#SELECT count(*) AS None FROM TIMESTAMP_TBL WHERE d1 = cast((select test_now
from test_now) as timestamp);
-% . # table_name
+% sys. # table_name
% none # name
% bigint # type
% 1 # length
@@ -99,7 +99,7 @@ stdout of test 'timestamp` in directory
#INSERT INTO TIMESTAMP_TBL VALUES ('now');
[ 1 ]
#SELECT count(*) AS two FROM TIMESTAMP_TBL WHERE d1 <= cast((select test_now
from test_now) as timestamp);
-% . # table_name
+% sys. # table_name
% two # name
% bigint # type
% 1 # length
@@ -487,8 +487,8 @@ stdout of test 'timestamp` in directory
[ 1997-02-11 01:32:01.00, 1.000000 ]
[ NULL, NULL ]
#SELECT d1, sql_sub(d1, cast('2001-12-12 23:22:21' as timestamp)) FROM
TIMESTAMP_TBL;
-% sys.timestamp_tbl, sys.%2 # table_name
-% d1, %2 # name
+% sys.timestamp_tbl, sys.%1 # table_name
+% d1, %1 # name
% timestamp, sec_interval # type
% 22, 14 # length
[ 1997-01-02 00:00:00.00, -156036141.000 ]
@@ -500,8 +500,8 @@ stdout of test 'timestamp` in directory
[ 1997-02-11 01:32:01.00, -152574620.000 ]
[ NULL, NULL ]
#SELECT d1, sql_sub(cast('2001-12-12 23:22:21' as timestamp), d1) FROM
TIMESTAMP_TBL;
-% sys.timestamp_tbl, .%2 # table_name
-% d1, %2 # name
+% sys.timestamp_tbl, .%1 # table_name
+% d1, %1 # name
% timestamp, sec_interval # type
% 22, 13 # length
[ 1997-01-02 00:00:00.00, 156036141.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
@@ -37,25 +37,25 @@ stdout of test 'timestamptz` in director
#INSERT INTO TIMESTAMPTZ_TBL VALUES (cast((select test_current_date from
test_current_date) - interval '1' DAY as timestamp));
[ 1 ]
#SELECT count(*) AS One FROM TIMESTAMPTZ_TBL WHERE d1 = cast((select
test_current_date from test_current_date) as timestamptz);
-% . # table_name
+% sys. # table_name
% one # name
% bigint # type
% 1 # length
[ 1 ]
#SELECT count(*) AS One FROM TIMESTAMPTZ_TBL WHERE d1 = cast((select
test_current_date from test_current_date) + interval '1' DAY as timestamp);
-% . # table_name
+% sys. # table_name
% one # name
% bigint # type
% 1 # length
[ 1 ]
#SELECT count(*) AS One FROM TIMESTAMPTZ_TBL WHERE d1 = cast((select
test_current_date from test_current_date) - interval '1' DAY as timestamp);
-% . # table_name
+% sys. # table_name
% one # name
% bigint # type
% 1 # length
[ 1 ]
#SELECT count(*) AS None FROM TIMESTAMPTZ_TBL WHERE d1 = cast((select test_now
from test_now) as timestamptz);
-% . # table_name
+% sys. # table_name
% none # name
% bigint # type
% 1 # length
@@ -68,7 +68,7 @@ stdout of test 'timestamptz` in director
#INSERT INTO TIMESTAMPTZ_TBL VALUES ('now');
[ 1 ]
#SELECT count(*) AS two FROM TIMESTAMPTZ_TBL WHERE d1 <= cast((select test_now
from test_now) as timestamptz);
-% . # table_name
+% sys. # table_name
% two # name
% bigint # type
% 1 # length
diff --git a/sql/test/sys-schema/Tests/check_MaxStrLength_violations.stable.out
b/sql/test/sys-schema/Tests/check_MaxStrLength_violations.stable.out
--- a/sql/test/sys-schema/Tests/check_MaxStrLength_violations.stable.out
+++ b/sql/test/sys-schema/Tests/check_MaxStrLength_violations.stable.out
@@ -689,7 +689,7 @@ stdout of test 'check_MaxStrLength_viola
% char, smallint, int, varchar # type
% 26, 1, 1, 0 # length
#SELECT '"sys"."users"."fullname"' as full_col_nm, 2024 as max_allowed_length,
length("fullname") as data_length, t."fullname" as data_value FROM
"sys"."users" t WHERE "fullname" IS NOT NULL AND length("fullname") > (select
type_digits from sys._columns where name = 'fullname' and table_id in (select
id from tables where name = 'users' and schema_id in (select id from
sys.schemas where name = 'sys')));
-% ., ., ., . # table_name
+% ., ., sys., sys. # table_name
% full_col_nm, max_allowed_length, data_length, data_value # name
% char, smallint, int, varchar # type
% 24, 1, 1, 0 # length
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
