Changeset: d3c38eadffec for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d3c38eadffec Modified Files: sql/test/sciql/Tests/01_create_01.stable.out sql/test/sciql/Tests/01_create_13.stable.out sql/test/sciql/Tests/01_create_14.stable.out sql/test/sciql/Tests/01_create_15.stable.out sql/test/sciql/Tests/01_create_16.stable.out sql/test/sciql/Tests/01_create_18.stable.out sql/test/sciql/Tests/02_update_01.stable.out sql/test/sciql/Tests/02_update_02.stable.out sql/test/sciql/Tests/02_update_03.stable.out sql/test/sciql/Tests/02_update_04.stable.out sql/test/sciql/Tests/02_update_05.stable.out sql/test/sciql/Tests/03_delete_01.stable.out sql/test/sciql/Tests/04_insert_01.stable.out sql/test/sciql/Tests/04_insert_03.stable.out sql/test/sciql/Tests/04_insert_06.stable.out sql/test/sciql/Tests/04_insert_07.stable.out sql/test/sciql/Tests/05_select_01.stable.out Branch: sciql Log Message:
more approve stable out due to changes in Mtest output and length of double in serialisation diffs (truncated from 467 to 300 lines): diff --git a/sql/test/sciql/Tests/01_create_01.stable.out b/sql/test/sciql/Tests/01_create_01.stable.out --- a/sql/test/sciql/Tests/01_create_01.stable.out +++ b/sql/test/sciql/Tests/01_create_01.stable.out @@ -19,18 +19,16 @@ stdout of test '01_create_01` in directo Ready. -Over.. - -# 13:50:46 > -# 13:50:46 > mclient -lsql -ftest -i -e --host=jarl --port=31258 -# 13:50:46 > +# 11:12:52 > +# 11:12:52 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=jarl" "--port=33649" +# 11:12:52 > #CREATE ARRAY ary(x TINYINT DIMENSION[4], y BIGINT DIMENSION[-5], v FLOAT DEFAULT 3.7); #SELECT * FROM ary; % sys.ary, sys.ary, sys.ary # table_name % x, y, v # name % tinyint, bigint, double # type -% 1, 2, 22 # length +% 1, 2, 24 # length [ 0, 0, 3.7 ] [ 0, -1, 3.7 ] [ 0, -2, 3.7 ] diff --git a/sql/test/sciql/Tests/01_create_13.stable.out b/sql/test/sciql/Tests/01_create_13.stable.out --- a/sql/test/sciql/Tests/01_create_13.stable.out +++ b/sql/test/sciql/Tests/01_create_13.stable.out @@ -19,18 +19,16 @@ stdout of test '01_create_13` in directo Ready. -Over.. - -# 23:29:49 > -# 23:29:49 > mclient -lsql -ftest -i -e --host=jarl --port=31678 -# 23:29:49 > +# 11:12:54 > +# 11:12:54 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=jarl" "--port=33649" +# 11:12:54 > #CREATE ARRAY ary (dimx INT DIMENSION[17:3:27], dimy INT DIMENSION[31:2:40], dimz INT DIMENSION[0:5:19], v1 FLOAT DEFAULT 0.43, v2 FLOAT DEFAULT 3.3, v3 INT DEFAULT 999); #SELECT * FROM ary; % sys.ary, sys.ary, sys.ary, sys.ary, sys.ary, sys.ary # table_name % dimx, dimy, dimz, v1, v2, v3 # name % int, int, int, double, double, int # type -% 2, 2, 2, 22, 22, 3 # length +% 2, 2, 2, 24, 24, 3 # length [ 17, 31, 0, 0.43, 3.3, 999 ] [ 17, 31, 5, 0.43, 3.3, 999 ] [ 17, 31, 10, 0.43, 3.3, 999 ] diff --git a/sql/test/sciql/Tests/01_create_14.stable.out b/sql/test/sciql/Tests/01_create_14.stable.out --- a/sql/test/sciql/Tests/01_create_14.stable.out +++ b/sql/test/sciql/Tests/01_create_14.stable.out @@ -31,7 +31,7 @@ Over.. % sys.stripes, sys.stripes, sys.stripes # table_name % x, y, v # name % int, int, double # type -% 1, 1, 22 # length +% 1, 1, 24 # length [ 0, 1, 0 ] [ 0, 3, 0 ] [ 1, 1, 0 ] diff --git a/sql/test/sciql/Tests/01_create_15.stable.out b/sql/test/sciql/Tests/01_create_15.stable.out --- a/sql/test/sciql/Tests/01_create_15.stable.out +++ b/sql/test/sciql/Tests/01_create_15.stable.out @@ -31,7 +31,7 @@ Over.. % sys.diagonal, sys.diagonal, sys.diagonal # table_name % x, y, v # name % int, int, double # type -% 1, 1, 22 # length +% 1, 1, 24 # length [ 0, 0, 0 ] [ 1, 1, 0 ] [ 2, 2, 0 ] diff --git a/sql/test/sciql/Tests/01_create_16.stable.out b/sql/test/sciql/Tests/01_create_16.stable.out --- a/sql/test/sciql/Tests/01_create_16.stable.out +++ b/sql/test/sciql/Tests/01_create_16.stable.out @@ -20,18 +20,16 @@ stdout of test '01_create_16` in directo Ready. # SQL catalog created, loading sql scripts once -Over.. - -# 13:13:44 > -# 13:13:44 > mclient -lsql -ftest -i -e --host=jarl --port=33096 -# 13:13:44 > +# 11:12:55 > +# 11:12:55 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=jarl" "--port=33649" +# 11:12:55 > #CREATE ARRAY sparse( x integer DIMENSION[4], y integer DIMENSION[4], v float DEFAULT 0.0 CHECK(v>=0.0)); #SELECT * FROM sparse; % sys.sparse, sys.sparse, sys.sparse # table_name % x, y, v # name % int, int, double # type -% 1, 1, 22 # length +% 1, 1, 24 # length [ 0, 0, 0 ] [ 0, 1, 0 ] [ 0, 2, 0 ] diff --git a/sql/test/sciql/Tests/01_create_18.stable.out b/sql/test/sciql/Tests/01_create_18.stable.out --- a/sql/test/sciql/Tests/01_create_18.stable.out +++ b/sql/test/sciql/Tests/01_create_18.stable.out @@ -20,11 +20,9 @@ stdout of test '01_create_18` in directo Ready. # SQL catalog created, loading sql scripts once -Over.. - -# 13:35:39 > -# 13:35:39 > mclient -lsql -ftest -i -e --host=jarl --port=33039 -# 13:35:39 > +# 11:12:56 > +# 11:12:56 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=jarl" "--port=33649" +# 11:12:56 > #CREATE ARRAY ary(x INTEGER DIMENSION[1:1:10]); #SELECT * FROM ary; diff --git a/sql/test/sciql/Tests/02_update_01.stable.out b/sql/test/sciql/Tests/02_update_01.stable.out --- a/sql/test/sciql/Tests/02_update_01.stable.out +++ b/sql/test/sciql/Tests/02_update_01.stable.out @@ -20,18 +20,16 @@ stdout of test '02_update_01` in directo Ready. # SQL catalog created, loading sql scripts once -Over.. - -# 14:43:30 > -# 14:43:30 > mclient -lsql -ftest -i -e --host=jarl --port=34781 -# 14:43:30 > +# 11:12:57 > +# 11:12:57 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=jarl" "--port=33649" +# 11:12:57 > #CREATE ARRAY matrix (x INT DIMENSION[4], y INT DIMENSION[4], v FLOAT DEFAULT 0.0); #SELECT * FROM matrix; % sys.matrix, sys.matrix, sys.matrix # table_name % x, y, v # name % int, int, double # type -% 1, 1, 22 # length +% 1, 1, 24 # length [ 0, 0, 0 ] [ 0, 1, 0 ] [ 0, 2, 0 ] @@ -54,7 +52,7 @@ Over.. % sys.matrix, sys.matrix, sys.matrix # table_name % x, y, v # name % int, int, double # type -% 1, 1, 22 # length +% 1, 1, 24 # length [ 0, 0, 0 ] [ 0, 1, -1 ] [ 0, 2, -2 ] diff --git a/sql/test/sciql/Tests/02_update_02.stable.out b/sql/test/sciql/Tests/02_update_02.stable.out --- a/sql/test/sciql/Tests/02_update_02.stable.out +++ b/sql/test/sciql/Tests/02_update_02.stable.out @@ -31,7 +31,7 @@ Over.. % sys.diagonal, sys.diagonal, sys.diagonal # table_name % x, y, v # name % int, int, double # type -% 1, 1, 22 # length +% 1, 1, 24 # length [ 0, 0, 0 ] [ 1, 1, 0 ] [ 2, 2, 0 ] @@ -42,7 +42,7 @@ Over.. % sys.diagonal, sys.diagonal, sys.diagonal # table_name % x, y, v # name % int, int, double # type -% 1, 1, 22 # length +% 1, 1, 24 # length [ 0, 0, 0 ] [ 1, 1, 2 ] [ 2, 2, 4 ] diff --git a/sql/test/sciql/Tests/02_update_03.stable.out b/sql/test/sciql/Tests/02_update_03.stable.out --- a/sql/test/sciql/Tests/02_update_03.stable.out +++ b/sql/test/sciql/Tests/02_update_03.stable.out @@ -31,7 +31,7 @@ Over.. % sys.stripes, sys.stripes, sys.stripes # table_name % x, y, v # name % int, int, double # type -% 1, 1, 22 # length +% 1, 1, 24 # length [ 0, 1, 0 ] [ 0, 3, 0 ] [ 1, 1, 0 ] @@ -46,7 +46,7 @@ Over.. % sys.stripes, sys.stripes, sys.stripes # table_name % x, y, v # name % int, int, double # type -% 2, 1, 22 # length +% 2, 1, 24 # length [ -1, 1, 0 ] [ -1, 3, 0 ] [ 0, 1, 0 ] diff --git a/sql/test/sciql/Tests/02_update_04.stable.out b/sql/test/sciql/Tests/02_update_04.stable.out --- a/sql/test/sciql/Tests/02_update_04.stable.out +++ b/sql/test/sciql/Tests/02_update_04.stable.out @@ -32,7 +32,7 @@ Over.. % sys.matrix, sys.matrix, sys.matrix # table_name % x, y, v # name % int, int, double # type -% 1, 1, 22 # length +% 1, 1, 24 # length [ 0, 0, 3.927 ] [ 0, 1, 3.927 ] [ 0, 2, 3.927 ] diff --git a/sql/test/sciql/Tests/02_update_05.stable.out b/sql/test/sciql/Tests/02_update_05.stable.out --- a/sql/test/sciql/Tests/02_update_05.stable.out +++ b/sql/test/sciql/Tests/02_update_05.stable.out @@ -32,7 +32,7 @@ Over.. % sys.matrix, sys.matrix, sys.matrix # table_name % x, y, v # name % int, int, double # type -% 1, 1, 22 # length +% 1, 1, 24 # length [ 0, 0, 0 ] [ 0, 1, -1 ] [ 0, 2, -2 ] @@ -55,7 +55,7 @@ Over.. % sys.matrix, sys.matrix, sys.matrix # table_name % x, y, v # name % int, int, double # type -% 1, 1, 22 # length +% 1, 1, 24 # length [ 0, 0, 0 ] [ 0, 1, 0 ] [ 0, 2, 0 ] diff --git a/sql/test/sciql/Tests/03_delete_01.stable.out b/sql/test/sciql/Tests/03_delete_01.stable.out --- a/sql/test/sciql/Tests/03_delete_01.stable.out +++ b/sql/test/sciql/Tests/03_delete_01.stable.out @@ -20,18 +20,16 @@ stdout of test '03_delete_01` in directo Ready. # SQL catalog created, loading sql scripts once -Over.. - -# 14:58:15 > -# 14:58:15 > mclient -lsql -ftest -i -e --host=jarl --port=34170 -# 14:58:15 > +# 11:12:58 > +# 11:12:58 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=jarl" "--port=33649" +# 11:12:58 > #CREATE ARRAY matrix (x INT DIMENSION[4], y INT DIMENSION[4], v FLOAT DEFAULT 0.0); #SELECT * FROM matrix; % sys.matrix, sys.matrix, sys.matrix # table_name % x, y, v # name % int, int, double # type -% 1, 1, 22 # length +% 1, 1, 24 # length [ 0, 0, 0 ] [ 0, 1, 0 ] [ 0, 2, 0 ] @@ -54,7 +52,7 @@ Over.. % sys.matrix, sys.matrix, sys.matrix # table_name % x, y, v # name % int, int, double # type -% 1, 1, 22 # length +% 1, 1, 24 # length [ 0, 0, 0 ] [ 0, 1, 0 ] [ 0, 2, 0 ] diff --git a/sql/test/sciql/Tests/04_insert_01.stable.out b/sql/test/sciql/Tests/04_insert_01.stable.out --- a/sql/test/sciql/Tests/04_insert_01.stable.out +++ b/sql/test/sciql/Tests/04_insert_01.stable.out @@ -20,18 +20,16 @@ stdout of test '04_insert_01` in directo Ready. # SQL catalog created, loading sql scripts once -Over.. - # 15:14:17 > -# 15:14:17 > mclient -lsql -ftest -i -e --host=jarl --port=33220 +# 15:14:17 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=jarl" "--port=32652" # 15:14:17 > #CREATE ARRAY matrix (x INT DIMENSION[4], y INT DIMENSION[4], v FLOAT DEFAULT 0); #SELECT * FROM matrix; -% sys.matrix, sys.matrix, sys.matrix # table_name +% sys.matrix_0401, sys.matrix_0401, sys.matrix_0401 # table_name % x, y, v # name % int, int, double # type -% 1, 1, 22 # length +% 1, 1, 24 # length [ 0, 0, 0 ] [ 0, 1, 0 ] [ 0, 2, 0 ] @@ -51,10 +49,10 @@ Over.. #UPDATE matrix SET v = (x + y) * 100; [ 16 ] #SELECT * FROM matrix; -% sys.matrix, sys.matrix, sys.matrix # table_name +% sys.matrix_0401, sys.matrix_0401, sys.matrix_0401 # table_name % x, y, v # name % int, int, double # type -% 1, 1, 22 # length +% 1, 1, 24 # length _______________________________________________ Checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
