Changeset: c02e25fa7c23 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c02e25fa7c23
Modified Files:
sql/test/BugTracker-2019/Tests/alter_table_drop_column.Bug-6749.stable.out
sql/test/BugTracker-2019/Tests/alter_table_set_schema.Bug-6701.stable.out
sql/test/BugTracker-2019/Tests/avg-changes-value-scale.Bug-6783.stable.out
sql/test/BugTracker-2019/Tests/correlated-subquery-aggregation.Bug-6714.stable.out
sql/test/BugTracker-2019/Tests/cte-union.Bug-6755.stable.out
sql/test/BugTracker-2019/Tests/date_trunc.stable.out
sql/test/BugTracker-2019/Tests/date_trunc_bulk.stable.out
sql/test/BugTracker-2019/Tests/filter_json_null.Bug-6773.stable.out
sql/test/BugTracker-2019/Tests/insert-into-select.Bug-6718.stable.out
sql/test/BugTracker-2019/Tests/isaUUID.Bug-6784.stable.out
sql/test/BugTracker-2019/Tests/merge-table-limit.Bug-6756.stable.out
sql/test/BugTracker-2019/Tests/next-get-value-bulk.Bug-6766.stable.out
sql/test/BugTracker-2019/Tests/outer-join-varchar.Bug-6776.stable.out
sql/test/BugTracker-2019/Tests/prod-decimals.Bug-6774.stable.out
sql/test/BugTracker-2019/Tests/r-date.Bug-6674.stable.out
sql/test/BugTracker-2019/Tests/rank-nan.Bug-6780.stable.out
sql/test/BugTracker-2019/Tests/select-char.Bug-6761.stable.out
sql/test/BugTracker-2019/Tests/select-distinct.Bug-6728.stable.out
sql/test/BugTracker-2019/Tests/select_window_function_and_asterisk.Bug-6722.stable.out
sql/test/BugTracker-2019/Tests/sequence-first-next-value.Bug-6743.stable.out
sql/test/BugTracker-2019/Tests/slow-inner-join.Bug-6737.stable.out
sql/test/BugTracker-2019/Tests/subselect-contradiction.Bug-6683.stable.out
sql/test/BugTracker-2019/Tests/subselect-count.Bug-6686.stable.out
sql/test/BugTracker-2019/Tests/subselect.Bug-6688.stable.out
sql/test/BugTracker-2019/Tests/subselect.Bug-6700.stable.out
sql/test/BugTracker-2019/Tests/sum-over-hge.Bug.6738.stable.out
sql/test/BugTracker-2019/Tests/sum-over-hge.Bug.6738.stable.out.int128
sql/test/BugTracker-2019/Tests/view-too-few-rows.Bug-6736.stable.out
Branch: sq2default
Log Message:
approved output
diffs (truncated from 1245 to 300 lines):
diff --git
a/sql/test/BugTracker-2019/Tests/alter_table_drop_column.Bug-6749.stable.out
b/sql/test/BugTracker-2019/Tests/alter_table_drop_column.Bug-6749.stable.out
--- a/sql/test/BugTracker-2019/Tests/alter_table_drop_column.Bug-6749.stable.out
+++ b/sql/test/BugTracker-2019/Tests/alter_table_drop_column.Bug-6749.stable.out
@@ -85,14 +85,14 @@ stdout of test 'alter_table_drop_column.
# MonetDB/GIS module loaded
# MonetDB/SQL module loaded
#select count(*) from objects inner join dependencies on objects.id =
dependencies.depend_id inner join columns on dependencies.id = columns.id inner
join tables on columns.table_id = tables.id where tables.name = 't';select
count(*) from dependencies inner join columns on dependencies.id = columns.id
inner join tables on columns.table_id = tables.id where tables.name =
't';select keys.type, keys.name, keys.rkey, keys.action from keys inner join
tables on tables.id = keys.table_id where tables.name = 't';select idxs.type,
idxs.name from idxs inner join tables on tables.id = idxs.table_id where
tables.name = 't';alter table t drop column b cascade;select count(*) from
objects inner join dependencies on objects.id = dependencies.depend_id inner
join columns on dependencies.id = columns.id inner join tables on
columns.table_id = tables.id where tables.name = 't';select count(*) from
dependencies inner join columns on dependencies.id = columns.id inner join
tables on columns.table_id =
tables.id where tables.name = 't';select keys.type, keys.name, keys.rkey,
keys.action from keys inner join tables on tables.id = keys.table_id where
tables.name = 't';select idxs.type, idxs.name from idxs inner join tables on
tables.id = idxs.table_id where tables.name = 't';
-% .L54 # table_name
-% L54 # name
+% .%25 # table_name
+% %25 # name
% bigint # type
% 1 # length
[ 2 ]
#select count(*) from objects inner join dependencies on objects.id =
dependencies.depend_id inner join columns on dependencies.id = columns.id inner
join tables on columns.table_id = tables.id where tables.name = 't';select
count(*) from dependencies inner join columns on dependencies.id = columns.id
inner join tables on columns.table_id = tables.id where tables.name =
't';select keys.type, keys.name, keys.rkey, keys.action from keys inner join
tables on tables.id = keys.table_id where tables.name = 't';select idxs.type,
idxs.name from idxs inner join tables on tables.id = idxs.table_id where
tables.name = 't';alter table t drop column b cascade;select count(*) from
objects inner join dependencies on objects.id = dependencies.depend_id inner
join columns on dependencies.id = columns.id inner join tables on
columns.table_id = tables.id where tables.name = 't';select count(*) from
dependencies inner join columns on dependencies.id = columns.id inner join
tables on columns.table_id =
tables.id where tables.name = 't';select keys.type, keys.name, keys.rkey,
keys.action from keys inner join tables on tables.id = keys.table_id where
tables.name = 't';select idxs.type, idxs.name from idxs inner join tables on
tables.id = idxs.table_id where tables.name = 't';
-% .L54 # table_name
-% L54 # name
+% .%23 # table_name
+% %23 # name
% bigint # type
% 1 # length
[ 2 ]
@@ -110,14 +110,14 @@ stdout of test 'alter_table_drop_column.
[ 0, "t_b_unique" ]
#select count(*) from objects inner join dependencies on objects.id =
dependencies.depend_id inner join columns on dependencies.id = columns.id inner
join tables on columns.table_id = tables.id where tables.name = 't';select
count(*) from dependencies inner join columns on dependencies.id = columns.id
inner join tables on columns.table_id = tables.id where tables.name =
't';select keys.type, keys.name, keys.rkey, keys.action from keys inner join
tables on tables.id = keys.table_id where tables.name = 't';select idxs.type,
idxs.name from idxs inner join tables on tables.id = idxs.table_id where
tables.name = 't';alter table t drop column b cascade;select count(*) from
objects inner join dependencies on objects.id = dependencies.depend_id inner
join columns on dependencies.id = columns.id inner join tables on
columns.table_id = tables.id where tables.name = 't';select count(*) from
dependencies inner join columns on dependencies.id = columns.id inner join
tables on columns.table_id =
tables.id where tables.name = 't';select keys.type, keys.name, keys.rkey,
keys.action from keys inner join tables on tables.id = keys.table_id where
tables.name = 't';select idxs.type, idxs.name from idxs inner join tables on
tables.id = idxs.table_id where tables.name = 't';
#select count(*) from objects inner join dependencies on objects.id =
dependencies.depend_id inner join columns on dependencies.id = columns.id inner
join tables on columns.table_id = tables.id where tables.name = 't';select
count(*) from dependencies inner join columns on dependencies.id = columns.id
inner join tables on columns.table_id = tables.id where tables.name =
't';select keys.type, keys.name, keys.rkey, keys.action from keys inner join
tables on tables.id = keys.table_id where tables.name = 't';select idxs.type,
idxs.name from idxs inner join tables on tables.id = idxs.table_id where
tables.name = 't';alter table t drop column b cascade;select count(*) from
objects inner join dependencies on objects.id = dependencies.depend_id inner
join columns on dependencies.id = columns.id inner join tables on
columns.table_id = tables.id where tables.name = 't';select count(*) from
dependencies inner join columns on dependencies.id = columns.id inner join
tables on columns.table_id =
tables.id where tables.name = 't';select keys.type, keys.name, keys.rkey,
keys.action from keys inner join tables on tables.id = keys.table_id where
tables.name = 't';select idxs.type, idxs.name from idxs inner join tables on
tables.id = idxs.table_id where tables.name = 't';
-% .L54 # table_name
-% L54 # name
+% .%25 # table_name
+% %25 # name
% bigint # type
% 1 # length
[ 0 ]
#select count(*) from objects inner join dependencies on objects.id =
dependencies.depend_id inner join columns on dependencies.id = columns.id inner
join tables on columns.table_id = tables.id where tables.name = 't';select
count(*) from dependencies inner join columns on dependencies.id = columns.id
inner join tables on columns.table_id = tables.id where tables.name =
't';select keys.type, keys.name, keys.rkey, keys.action from keys inner join
tables on tables.id = keys.table_id where tables.name = 't';select idxs.type,
idxs.name from idxs inner join tables on tables.id = idxs.table_id where
tables.name = 't';alter table t drop column b cascade;select count(*) from
objects inner join dependencies on objects.id = dependencies.depend_id inner
join columns on dependencies.id = columns.id inner join tables on
columns.table_id = tables.id where tables.name = 't';select count(*) from
dependencies inner join columns on dependencies.id = columns.id inner join
tables on columns.table_id =
tables.id where tables.name = 't';select keys.type, keys.name, keys.rkey,
keys.action from keys inner join tables on tables.id = keys.table_id where
tables.name = 't';select idxs.type, idxs.name from idxs inner join tables on
tables.id = idxs.table_id where tables.name = 't';
-% .L54 # table_name
-% L54 # name
+% .%23 # table_name
+% %23 # name
% bigint # type
% 1 # length
[ 0 ]
@@ -153,14 +153,14 @@ stdout of test 'alter_table_drop_column.
% int, int, int # type
% 1, 1, 1 # length
#drop table t;start transaction;create table t (a int, b int, c int);alter
table t add unique (b);select * from t;select count(*) from objects inner join
dependencies on objects.id = dependencies.depend_id inner join columns on
dependencies.id = columns.id inner join tables on columns.table_id = tables.id
where tables.name = 't';select count(*) from dependencies inner join columns on
dependencies.id = columns.id inner join tables on columns.table_id = tables.id
where tables.name = 't';select keys.type, keys.name, keys.rkey, keys.action
from keys inner join tables on tables.id = keys.table_id where tables.name =
't';select idxs.type, idxs.name from idxs inner join tables on tables.id =
idxs.table_id where tables.name = 't';alter table t drop column b
cascade;select count(*) from objects inner join dependencies on objects.id =
dependencies.depend_id inner join columns on dependencies.id = columns.id inner
join tables on columns.table_id = tables.id where tables.name = 't';select count
(*) from dependencies inner join columns on dependencies.id = columns.id inner
join tables on columns.table_id = tables.id where tables.name = 't';select
keys.type, keys.name, keys.rkey, keys.action from keys inner join tables on
tables.id = keys.table_id where tables.name = 't';select idxs.type, idxs.name
from idxs inner join tables on tables.id = idxs.table_id where tables.name =
't';select * from t;commit;select * from t;drop table t;
-% .L54 # table_name
-% L54 # name
+% .%25 # table_name
+% %25 # name
% bigint # type
% 1 # length
[ 2 ]
#drop table t;start transaction;create table t (a int, b int, c int);alter
table t add unique (b);select * from t;select count(*) from objects inner join
dependencies on objects.id = dependencies.depend_id inner join columns on
dependencies.id = columns.id inner join tables on columns.table_id = tables.id
where tables.name = 't';select count(*) from dependencies inner join columns on
dependencies.id = columns.id inner join tables on columns.table_id = tables.id
where tables.name = 't';select keys.type, keys.name, keys.rkey, keys.action
from keys inner join tables on tables.id = keys.table_id where tables.name =
't';select idxs.type, idxs.name from idxs inner join tables on tables.id =
idxs.table_id where tables.name = 't';alter table t drop column b
cascade;select count(*) from objects inner join dependencies on objects.id =
dependencies.depend_id inner join columns on dependencies.id = columns.id inner
join tables on columns.table_id = tables.id where tables.name = 't';select count
(*) from dependencies inner join columns on dependencies.id = columns.id inner
join tables on columns.table_id = tables.id where tables.name = 't';select
keys.type, keys.name, keys.rkey, keys.action from keys inner join tables on
tables.id = keys.table_id where tables.name = 't';select idxs.type, idxs.name
from idxs inner join tables on tables.id = idxs.table_id where tables.name =
't';select * from t;commit;select * from t;drop table t;
-% .L54 # table_name
-% L54 # name
+% .%23 # table_name
+% %23 # name
% bigint # type
% 1 # length
[ 2 ]
@@ -178,14 +178,14 @@ stdout of test 'alter_table_drop_column.
[ 0, "t_b_unique" ]
#drop table t;start transaction;create table t (a int, b int, c int);alter
table t add unique (b);select * from t;select count(*) from objects inner join
dependencies on objects.id = dependencies.depend_id inner join columns on
dependencies.id = columns.id inner join tables on columns.table_id = tables.id
where tables.name = 't';select count(*) from dependencies inner join columns on
dependencies.id = columns.id inner join tables on columns.table_id = tables.id
where tables.name = 't';select keys.type, keys.name, keys.rkey, keys.action
from keys inner join tables on tables.id = keys.table_id where tables.name =
't';select idxs.type, idxs.name from idxs inner join tables on tables.id =
idxs.table_id where tables.name = 't';alter table t drop column b
cascade;select count(*) from objects inner join dependencies on objects.id =
dependencies.depend_id inner join columns on dependencies.id = columns.id inner
join tables on columns.table_id = tables.id where tables.name = 't';select count
(*) from dependencies inner join columns on dependencies.id = columns.id inner
join tables on columns.table_id = tables.id where tables.name = 't';select
keys.type, keys.name, keys.rkey, keys.action from keys inner join tables on
tables.id = keys.table_id where tables.name = 't';select idxs.type, idxs.name
from idxs inner join tables on tables.id = idxs.table_id where tables.name =
't';select * from t;commit;select * from t;drop table t;
#drop table t;start transaction;create table t (a int, b int, c int);alter
table t add unique (b);select * from t;select count(*) from objects inner join
dependencies on objects.id = dependencies.depend_id inner join columns on
dependencies.id = columns.id inner join tables on columns.table_id = tables.id
where tables.name = 't';select count(*) from dependencies inner join columns on
dependencies.id = columns.id inner join tables on columns.table_id = tables.id
where tables.name = 't';select keys.type, keys.name, keys.rkey, keys.action
from keys inner join tables on tables.id = keys.table_id where tables.name =
't';select idxs.type, idxs.name from idxs inner join tables on tables.id =
idxs.table_id where tables.name = 't';alter table t drop column b
cascade;select count(*) from objects inner join dependencies on objects.id =
dependencies.depend_id inner join columns on dependencies.id = columns.id inner
join tables on columns.table_id = tables.id where tables.name = 't';select count
(*) from dependencies inner join columns on dependencies.id = columns.id inner
join tables on columns.table_id = tables.id where tables.name = 't';select
keys.type, keys.name, keys.rkey, keys.action from keys inner join tables on
tables.id = keys.table_id where tables.name = 't';select idxs.type, idxs.name
from idxs inner join tables on tables.id = idxs.table_id where tables.name =
't';select * from t;commit;select * from t;drop table t;
-% .L54 # table_name
-% L54 # name
+% .%25 # table_name
+% %25 # name
% bigint # type
% 1 # length
[ 0 ]
#drop table t;start transaction;create table t (a int, b int, c int);alter
table t add unique (b);select * from t;select count(*) from objects inner join
dependencies on objects.id = dependencies.depend_id inner join columns on
dependencies.id = columns.id inner join tables on columns.table_id = tables.id
where tables.name = 't';select count(*) from dependencies inner join columns on
dependencies.id = columns.id inner join tables on columns.table_id = tables.id
where tables.name = 't';select keys.type, keys.name, keys.rkey, keys.action
from keys inner join tables on tables.id = keys.table_id where tables.name =
't';select idxs.type, idxs.name from idxs inner join tables on tables.id =
idxs.table_id where tables.name = 't';alter table t drop column b
cascade;select count(*) from objects inner join dependencies on objects.id =
dependencies.depend_id inner join columns on dependencies.id = columns.id inner
join tables on columns.table_id = tables.id where tables.name = 't';select count
(*) from dependencies inner join columns on dependencies.id = columns.id inner
join tables on columns.table_id = tables.id where tables.name = 't';select
keys.type, keys.name, keys.rkey, keys.action from keys inner join tables on
tables.id = keys.table_id where tables.name = 't';select idxs.type, idxs.name
from idxs inner join tables on tables.id = idxs.table_id where tables.name =
't';select * from t;commit;select * from t;drop table t;
-% .L54 # table_name
-% L54 # name
+% .%23 # table_name
+% %23 # name
% bigint # type
% 1 # length
[ 0 ]
diff --git
a/sql/test/BugTracker-2019/Tests/alter_table_set_schema.Bug-6701.stable.out
b/sql/test/BugTracker-2019/Tests/alter_table_set_schema.Bug-6701.stable.out
--- a/sql/test/BugTracker-2019/Tests/alter_table_set_schema.Bug-6701.stable.out
+++ b/sql/test/BugTracker-2019/Tests/alter_table_set_schema.Bug-6701.stable.out
@@ -61,76 +61,76 @@ stdout of test 'alter_table_set_schema.B
% 1, 1, 1 # length
#create table sys.test2 (col1 serial);
#select count(*) as count_rows from tables where name = 'test2';
-% .L42 # table_name
+% .%10 # table_name
% count_rows # name
% bigint # type
% 1 # length
[ 1 ]
#select count(*) as count_rows from keys where table_id in (select id from
tables where name = 'test2');
-% sys.L44 # table_name
+% sys.%11 # table_name
% count_rows # name
% bigint # type
% 1 # length
[ 1 ]
#select count(*) as count_rows from objects where id in (select id from keys
where table_id in (select id from tables where name = 'test2'));
-% sys.L46 # table_name
+% sys.%12 # table_name
% count_rows # name
% bigint # type
% 1 # length
[ 1 ]
#ALTER TABLE sys.test2 SET SCHEMA profiler;
#select count(*) as count_rows from tables where name = 'test2';
-% .L42 # table_name
+% .%10 # table_name
% count_rows # name
% bigint # type
% 1 # length
[ 1 ]
#select count(*) as count_rows from keys where table_id in (select id from
tables where name = 'test2');
-% sys.L44 # table_name
+% sys.%11 # table_name
% count_rows # name
% bigint # type
% 1 # length
[ 1 ]
#select count(*) as count_rows from objects where id in (select id from keys
where table_id in (select id from tables where name = 'test2'));
-% sys.L46 # table_name
+% sys.%12 # table_name
% count_rows # name
% bigint # type
% 1 # length
[ 1 ]
#ALTER TABLE profiler.test2 SET SCHEMA json;
#select count(*) as count_rows from tables where name = 'test2';
-% .L42 # table_name
+% .%10 # table_name
% count_rows # name
% bigint # type
% 1 # length
[ 1 ]
#select count(*) as count_rows from keys where table_id in (select id from
tables where name = 'test2');
-% sys.L44 # table_name
+% sys.%11 # table_name
% count_rows # name
% bigint # type
% 1 # length
[ 1 ]
#select count(*) as count_rows from objects where id in (select id from keys
where table_id in (select id from tables where name = 'test2'));
-% sys.L46 # table_name
+% sys.%12 # table_name
% count_rows # name
% bigint # type
% 1 # length
[ 1 ]
#ALTER TABLE json.test2 SET SCHEMA sys;
#select count(*) as count_rows from tables where name = 'test2';
-% .L42 # table_name
+% .%10 # table_name
% count_rows # name
% bigint # type
% 1 # length
[ 1 ]
#select count(*) as count_rows from keys where table_id in (select id from
tables where name = 'test2');
-% sys.L44 # table_name
+% sys.%11 # table_name
% count_rows # name
% bigint # type
% 1 # length
[ 1 ]
#select count(*) as count_rows from objects where id in (select id from keys
where table_id in (select id from tables where name = 'test2'));
-% sys.L46 # table_name
+% sys.%12 # table_name
% count_rows # name
% bigint # type
% 1 # length
diff --git
a/sql/test/BugTracker-2019/Tests/avg-changes-value-scale.Bug-6783.stable.out
b/sql/test/BugTracker-2019/Tests/avg-changes-value-scale.Bug-6783.stable.out
--- a/sql/test/BugTracker-2019/Tests/avg-changes-value-scale.Bug-6783.stable.out
+++ b/sql/test/BugTracker-2019/Tests/avg-changes-value-scale.Bug-6783.stable.out
@@ -58,15 +58,15 @@ stdout of test 'avg-changes-value-scale.
#CREATE TABLE bug6783 (t TIMESTAMP);
#INSERT INTO bug6783 values ('1970-01-01 00:02:55.000000');
[ 1 ]
-#SELECT t - SYS.STR_TO_TIMESTAMP('0', '%s') FROM bug6783;
-% sys.L1 # table_name
-% L1 # name
+#SELECT t - SYS.STR_TO_TIMESTAMP('1970-01-01 00:00:00', '%Y-%m-%d %T') FROM
bug6783;
+% sys.%1 # table_name
+% %1 # name
% sec_interval # type
% 7 # length
[ 175.000 ]
-#SELECT AVG(t - SYS.STR_TO_TIMESTAMP('0', '%s')) FROM bug6783;
-% sys.L2 # table_name
-% L2 # name
+#SELECT AVG(t - SYS.STR_TO_TIMESTAMP('1970-01-01 00:00:00', '%Y-%m-%d %T'))
FROM bug6783;
+% sys.%1 # table_name
+% %1 # name
% double # type
% 24 # length
[ 175 ]
diff --git
a/sql/test/BugTracker-2019/Tests/correlated-subquery-aggregation.Bug-6714.stable.out
b/sql/test/BugTracker-2019/Tests/correlated-subquery-aggregation.Bug-6714.stable.out
---
a/sql/test/BugTracker-2019/Tests/correlated-subquery-aggregation.Bug-6714.stable.out
+++
b/sql/test/BugTracker-2019/Tests/correlated-subquery-aggregation.Bug-6714.stable.out
@@ -57,8 +57,8 @@ stdout of test 'correlated-subquery-aggr
[ 27 ]
#select func_id, (select name from functions_test f where f.id = func_id) as
name, max(number), count(*) from args_test
#group by func_id having count(*) > 8 order by func_id limit 12;
-% .args_test, .L2, .L3, .L4 # table_name
-% func_id, name, L3, L4 # name
+% .args_test, .%2, .%3, .%4 # table_name
+% func_id, name, %3, %4 # name
% int, varchar, int, bigint # type
% 4, 14, 2, 2 # length
[ 6743, "querylog_calls", 8, 9 ]
diff --git a/sql/test/BugTracker-2019/Tests/cte-union.Bug-6755.stable.out
b/sql/test/BugTracker-2019/Tests/cte-union.Bug-6755.stable.out
--- a/sql/test/BugTracker-2019/Tests/cte-union.Bug-6755.stable.out
+++ b/sql/test/BugTracker-2019/Tests/cte-union.Bug-6755.stable.out
@@ -59,9 +59,8 @@ stdout of test 'cte-union.Bug-6755` in d
#SELECT "Carrier", "Hour", SUM("PredictedArrDelay")
#FROM (SELECT * FROM t1 UNION SELECT * FROM t2) AS t
#GROUP BY "Carrier", "Hour"
-#ORDER BY "Carrier", "Hour";
-% sys.t, sys.t, sys.L25 # table_name
-% Carrier, Hour, L25 # name
+% sys.t, sys.t, sys.%20 # table_name
+% Carrier, Hour, %20 # name
% char, int, decimal # type
% 2, 1, 20 # length
#rollback;
diff --git a/sql/test/BugTracker-2019/Tests/date_trunc.stable.out
b/sql/test/BugTracker-2019/Tests/date_trunc.stable.out
--- a/sql/test/BugTracker-2019/Tests/date_trunc.stable.out
+++ b/sql/test/BugTracker-2019/Tests/date_trunc.stable.out
@@ -19,91 +19,87 @@ stdout of test 'date_trunc` in directory
# MonetDB/SQL module loaded
-# 08:07:24 >
-# 08:07:24 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-23934" "--port=33395"
-# 08:07:24 >
-
-#select date_trunc('microseconds', timestamp '2019-02-17 02:08:12.345678');
-% .L2 # table_name
-% L2 # name
+#select timestamp '2119-02-17 02:08:12.345678';
+% .%1 # table_name
+% %1 # name
% timestamp # type
% 26 # length
[ 2119-02-17 02:08:12.345678 ]
#select date_trunc('microseconds', timestamp '2119-02-17 02:08:12.345678');
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% timestamp # type
% 26 # length
[ 2119-02-17 02:08:12.345678 ]
#select date_trunc('milliseconds', timestamp '2119-02-17 02:08:12.345678');
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% timestamp # type
% 26 # length
[ 2119-02-17 02:08:12.345000 ]
#select date_trunc('second', timestamp '2119-02-17 02:08:12.345678');
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% timestamp # type
% 26 # length
[ 2119-02-17 02:08:12.000000 ]
#select date_trunc('minute', timestamp '2119-02-17 02:08:12.345678');
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% timestamp # type
% 26 # length
[ 2119-02-17 02:08:00.000000 ]
#select date_trunc('hour', timestamp '2119-02-17 02:08:12.345678');
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% timestamp # type
% 26 # length
[ 2119-02-17 02:00:00.000000 ]
#select date_trunc('day', timestamp '2119-02-17 02:08:12.345678');
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% timestamp # type
% 26 # length
[ 2119-02-17 00:00:00.000000 ]
#select date_trunc('week', timestamp '2119-02-17 02:08:12.345678');
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% timestamp # type
% 26 # length
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
