Update of /cvsroot/monetdb/sql/src/test/Tests
In directory
sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv1687/sql/src/test/Tests
Modified Files:
Tag: Feb2010
big-example.stable.out cast_str2num.stable.out
example-queries.stable.out example.stable.out
median_stdev.stable.out zones2.stable.out
Log Message:
Enable mclient -ftest for MIL, MAL, and SQL.
The stable output was changed using a program, so may contain inappropriate
changes.
On the whole, testing should improve since we should not get minor differences
in floating point numbers anymore.
Index: example-queries.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/example-queries.stable.out,v
retrieving revision 1.26
retrieving revision 1.26.10.1
diff -u -d -r1.26 -r1.26.10.1
--- example-queries.stable.out 7 Dec 2008 17:31:30 -0000 1.26
+++ example-queries.stable.out 27 Jan 2010 13:54:06 -0000 1.26.10.1
@@ -35,30 +35,30 @@
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
+[ 9, "testx", 9.1 ]
% sys.example_view, sys.example_view, sys.example_view # table_name
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
+[ 9, "testx", 9.1 ]
# 12:36:50 >
# 12:36:50 > Done.
Index: median_stdev.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/median_stdev.stable.out,v
retrieving revision 1.1
retrieving revision 1.1.12.1
diff -u -d -r1.1 -r1.1.12.1
--- median_stdev.stable.out 20 Jun 2008 18:40:57 -0000 1.1
+++ median_stdev.stable.out 27 Jan 2010 13:54:06 -0000 1.1.12.1
@@ -53,9 +53,9 @@
% groupid, stdev # name
% int, double # type
% 1, 22 # length
-[ 1, 5.3141321022345691 ]
-[ 2, 2.598076211353316 ]
-[ 3, 23.41340428045439 ]
+[ 1, 5.314132102 ]
+[ 2, 2.598076211 ]
+[ 3, 23.41340428 ]
[ 4, 0 ]
[ 5, 0 ]
Index: big-example.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/big-example.stable.out,v
retrieving revision 1.29
retrieving revision 1.29.10.1
diff -u -d -r1.29 -r1.29.10.1
--- big-example.stable.out 12 Dec 2008 22:28:26 -0000 1.29
+++ big-example.stable.out 27 Jan 2010 13:54:05 -0000 1.29.10.1
@@ -74,20 +74,20 @@
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
% sys.example_view, sys.example_view, sys.example_view # table_name
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
# 12:36:56 >
# 12:36:56 > Mtimeout -timeout 60 MapiClient -lsql -u monetdb -P monetdb
--host=localhost --port=45579 < big-example_s01.sql
@@ -102,30 +102,30 @@
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
+[ 9, "testx", 9.1 ]
% sys.example_view, sys.example_view, sys.example_view # table_name
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
+[ 9, "testx", 9.1 ]
# 12:36:56 >
# 12:36:56 > Mtimeout -timeout 60 MapiClient -lsql -u monetdb -P monetdb
--host=localhost --port=45579 < big-example_s02.sql
@@ -135,20 +135,20 @@
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 5, "xtest", 0.90000000000000002 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 5, "xtest", 0.9 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
+[ 9, "testx", 9.1 ]
% sys.example_view, sys.example_view, sys.example_view # table_name
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
[ 8, "texxst", 0.0001 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
+[ 9, "testx", 9.1 ]
# 12:36:56 >
# 12:36:56 > Mtimeout -timeout 60 MapiClient -lsql -u monetdb -P monetdb
--host=localhost --port=45579 < big-example_s03.sql
@@ -168,20 +168,20 @@
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
% sys.example_view, sys.example_view, sys.example_view # table_name
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
# 12:36:56 >
# 12:36:56 > Mtimeout -timeout 60 MapiClient -lsql -u monetdb -P monetdb
--host=localhost --port=45579 < big-example_s05.sql
@@ -191,18 +191,18 @@
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
[ 3 ]
% sys.example, sys.example, sys.example # table_name
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 5, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
# 12:36:56 >
# 12:36:56 > Mtimeout -timeout 60 MapiClient -lsql -u monetdb -P monetdb
--host=localhost --port=45579 < big-example_s06.sql
@@ -222,20 +222,20 @@
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
% sys.example_view, sys.example_view, sys.example_view # table_name
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
# 12:36:56 >
# 12:36:56 > Mtimeout -timeout 60 MapiClient -lsql -u monetdb -P monetdb
--host=localhost --port=45579 < big-example_s08.sql
@@ -245,35 +245,35 @@
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
[ 1 ]
% sys.example, sys.example, sys.example # table_name
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
[ 1 ]
% sys.example, sys.example, sys.example # table_name
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
[ 8, "texxst", 0.0001 ]
[ 1 ]
% sys.example, sys.example, sys.example # table_name
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 5, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
# 12:36:56 >
# 12:36:56 > Mtimeout -timeout 60 MapiClient -lsql -u monetdb -P monetdb
--host=localhost --port=45579 < big-example_s09.sql
@@ -293,20 +293,20 @@
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
% sys.example_view, sys.example_view, sys.example_view # table_name
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
# 12:36:56 >
# 12:36:56 > Mtimeout -timeout 60 MapiClient -lsql -u monetdb -P monetdb
--host=localhost --port=45579 < big-example_s11.sql
@@ -316,19 +316,19 @@
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
[ 2 ]
% sys.example, sys.example, sys.example # table_name
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 5, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
# 12:36:56 >
# 12:36:56 > Mtimeout -timeout 60 MapiClient -lsql -u monetdb -P monetdb
--host=localhost --port=45579 < big-example_s12.sql
@@ -348,20 +348,20 @@
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
% sys.example_view, sys.example_view, sys.example_view # table_name
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
# 12:36:57 >
# 12:36:57 > Mtimeout -timeout 60 MapiClient -lsql -u monetdb -P monetdb
--host=localhost --port=45579 < big-example_s14.sql
@@ -371,18 +371,18 @@
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
[ 3 ]
% sys.example, sys.example, sys.example # table_name
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
[ 5, "xtest", -1 ]
[ 8, "texxst", -1 ]
[ 9, "testx", -1 ]
@@ -405,20 +405,20 @@
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
% sys.example_view, sys.example_view, sys.example_view # table_name
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
# 12:36:57 >
# 12:36:57 > Mtimeout -timeout 60 MapiClient -lsql -u monetdb -P monetdb
--host=localhost --port=45579 < big-example_s17.sql
@@ -428,30 +428,30 @@
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
[ 1 ]
% sys.example, sys.example, sys.example # table_name
% val1, val2, val3 # name
% int, varchar, double # type
% 2, 6, 22 # length
-[ -5, "xtest", 0.90000000000000002 ]
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
+[ -5, "xtest", 0.9 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
[ 1 ]
% sys.example, sys.example, sys.example # table_name
% val1, val2, val3 # name
% int, varchar, double # type
% 2, 6, 22 # length
-[ -5, "testx", 9.0999999999999996 ]
-[ -5, "xtest", 0.90000000000000002 ]
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
+[ -5, "testx", 9.1 ]
+[ -5, "xtest", 0.9 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
[ 8, "texxst", 0.0001 ]
[ 1 ]
% sys.example, sys.example, sys.example # table_name
@@ -459,10 +459,10 @@
% int, varchar, double # type
% 2, 6, 22 # length
[ -5, "texxst", 0.0001 ]
-[ -5, "testx", 9.0999999999999996 ]
-[ -5, "xtest", 0.90000000000000002 ]
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
+[ -5, "testx", 9.1 ]
+[ -5, "xtest", 0.9 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
# 12:36:57 >
# 12:36:57 > Mtimeout -timeout 60 MapiClient -lsql -u monetdb -P monetdb
--host=localhost --port=45579 < big-example_s18.sql
@@ -482,20 +482,20 @@
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
% sys.example_view, sys.example_view, sys.example_view # table_name
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
# 12:36:57 >
# 12:36:57 > Mtimeout -timeout 60 MapiClient -lsql -u monetdb -P monetdb
--host=localhost --port=45579 < big-example_s20.sql
@@ -505,21 +505,21 @@
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
[ 2 ]
% sys.example, sys.example, sys.example # table_name
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 7, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
[ 8, "updated", 0.0001 ]
-[ 9, "updated", 9.0999999999999996 ]
+[ 9, "updated", 9.1 ]
# 12:36:57 >
# 12:36:57 > Mtimeout -timeout 60 MapiClient -lsql -u monetdb -P monetdb
--host=localhost --port=45579 < big-example_s21.sql
@@ -539,20 +539,20 @@
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
% sys.example_view, sys.example_view, sys.example_view # table_name
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
# 12:36:57 >
# 12:36:57 > Mtimeout -timeout 60 MapiClient -lsql -u monetdb -P monetdb
--host=localhost --port=45579 < big-example_s23.sql
Index: zones2.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/zones2.stable.out,v
retrieving revision 1.4
retrieving revision 1.4.10.1
diff -u -d -r1.4 -r1.4.10.1
--- zones2.stable.out 21 Dec 2008 19:38:22 -0000 1.4
+++ zones2.stable.out 27 Jan 2010 13:54:06 -0000 1.4.10.1
@@ -29,12 +29,12 @@
% degrees_single_value # name
% double # type
% 22 # length
-[ -5.7295779513082321 ]
+[ -5.729577951 ]
% . # table_name
% degrees_single_value # name
% double # type
% 22 # length
-[ -5.7295779513082321 ]
+[ -5.729577951 ]
# 21:09:18 >
# 21:09:18 > Done.
Index: example.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/example.stable.out,v
retrieving revision 1.28
retrieving revision 1.28.10.1
diff -u -d -r1.28 -r1.28.10.1
--- example.stable.out 7 Dec 2008 17:31:30 -0000 1.28
+++ example.stable.out 27 Jan 2010 13:54:06 -0000 1.28.10.1
@@ -36,20 +36,20 @@
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
% sys.example_view, sys.example_view, sys.example_view # table_name
% val1, val2, val3 # name
% int, varchar, double # type
% 1, 6, 22 # length
-[ 0, "texst", 99999.100000000006 ]
-[ 1, "test", 0.10000000000000001 ]
-[ 5, "xtest", 0.90000000000000002 ]
+[ 0, "texst", 99999.1 ]
+[ 1, "test", 0.1 ]
+[ 5, "xtest", 0.9 ]
[ 8, "texxst", 0.0001 ]
-[ 9, "testx", 9.0999999999999996 ]
+[ 9, "testx", 9.1 ]
# 12:36:49 >
# 12:36:49 > Done.
Index: cast_str2num.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/cast_str2num.stable.out,v
retrieving revision 1.17
retrieving revision 1.17.10.1
diff -u -d -r1.17 -r1.17.10.1
--- cast_str2num.stable.out 7 Dec 2008 17:31:30 -0000 1.17
+++ cast_str2num.stable.out 27 Jan 2010 13:54:06 -0000 1.17.10.1
@@ -37,110 +37,110 @@
% i, f # name
% int, double # type
% 1, 22 # length
-[ 1, 0.10000000000000001 ]
+[ 1, 0.1 ]
% sys.t, sys.t # table_name
% i, f # name
% int, double # type
% 1, 22 # length
-[ 1, 0.10000000000000001 ]
+[ 1, 0.1 ]
% sys.t, sys.t # table_name
% i, f # name
% int, double # type
% 1, 22 # length
-[ 1, 0.10000000000000001 ]
+[ 1, 0.1 ]
% sys.t, sys.t # table_name
% i, f # name
% int, double # type
% 1, 22 # length
-[ 1, 0.10000000000000001 ]
+[ 1, 0.1 ]
% sys.t, sys.t # table_name
% i, f # name
% int, double # type
% 1, 22 # length
-[ 1, 0.10000000000000001 ]
-[ 2, 0.20000000000000001 ]
+[ 1, 0.1 ]
+[ 2, 0.2 ]
% sys.t, sys.t # table_name
% i, f # name
% int, double # type
% 1, 22 # length
-[ 1, 0.10000000000000001 ]
-[ 2, 0.20000000000000001 ]
+[ 1, 0.1 ]
+[ 2, 0.2 ]
% sys.t, sys.t # table_name
% i, f # name
% int, double # type
% 1, 22 # length
-[ 1, 0.10000000000000001 ]
-[ 2, 0.20000000000000001 ]
+[ 1, 0.1 ]
+[ 2, 0.2 ]
% sys.t, sys.t # table_name
% i, f # name
% int, double # type
% 1, 22 # length
-[ 1, 0.10000000000000001 ]
-[ 2, 0.20000000000000001 ]
+[ 1, 0.1 ]
+[ 2, 0.2 ]
% sys.t, sys.t # table_name
% i, f # name
% int, double # type
% 1, 22 # length
-[ 2, 0.20000000000000001 ]
+[ 2, 0.2 ]
% sys.t, sys.t # table_name
% i, f # name
% int, double # type
% 1, 22 # length
-[ 2, 0.20000000000000001 ]
+[ 2, 0.2 ]
% sys.t, sys.t # table_name
% i, f # name
% int, double # type
% 1, 22 # length
-[ 2, 0.20000000000000001 ]
+[ 2, 0.2 ]
% sys.t, sys.t # table_name
% i, f # name
% int, double # type
% 1, 22 # length
-[ 2, 0.20000000000000001 ]
+[ 2, 0.2 ]
% sys.t, sys.t # table_name
% i, f # name
% int, double # type
% 1, 22 # length
-[ 2, 0.20000000000000001 ]
-[ 3, 0.29999999999999999 ]
+[ 2, 0.2 ]
+[ 3, 0.3 ]
% sys.t, sys.t # table_name
% i, f # name
% int, double # type
% 1, 22 # length
-[ 2, 0.20000000000000001 ]
-[ 3, 0.29999999999999999 ]
+[ 2, 0.2 ]
+[ 3, 0.3 ]
% sys.t, sys.t # table_name
% i, f # name
% int, double # type
% 1, 22 # length
-[ 2, 0.20000000000000001 ]
-[ 3, 0.29999999999999999 ]
+[ 2, 0.2 ]
+[ 3, 0.3 ]
% sys.t, sys.t # table_name
% i, f # name
% int, double # type
% 1, 22 # length
-[ 2, 0.20000000000000001 ]
-[ 3, 0.29999999999999999 ]
+[ 2, 0.2 ]
+[ 3, 0.3 ]
% sys.t, sys.t # table_name
% i, f # name
% int, double # type
% 1, 22 # length
-[ 3, 0.29999999999999999 ]
+[ 3, 0.3 ]
% sys.t, sys.t # table_name
% i, f # name
% int, double # type
% 1, 22 # length
-[ 3, 0.29999999999999999 ]
+[ 3, 0.3 ]
% sys.t, sys.t # table_name
% i, f # name
% int, double # type
% 1, 22 # length
-[ 3, 0.29999999999999999 ]
+[ 3, 0.3 ]
% sys.t, sys.t # table_name
% i, f # name
% int, double # type
% 1, 22 # length
-[ 3, 0.29999999999999999 ]
+[ 3, 0.3 ]
# 12:36:53 >
# 12:36:53 > Done.
------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
