Update of /cvsroot/monetdb/sql/src/test/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv17226/src/test/Tests
Modified Files:
rank.stable.out.Five
Log Message:
removed 'explain' variable, ie no more set explain etc
but always use the statement modifiers debug, explain, profile
profile now only outputs the real, user and clk ticks per sec.
The old profile functionality is taken over by a new statement modifier
'record'
U rank.stable.out.Five
Index: rank.stable.out.Five
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/rank.stable.out.Five,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- rank.stable.out.Five 25 Feb 2008 22:28:00 -0000 1.1
+++ rank.stable.out.Five 1 Apr 2008 17:05:13 -0000 1.2
@@ -549,24 +549,17 @@
[ 216, "x", "double" ]
[ 217, "y", "double" ]
[ 218, "z", "double" ]
-[ 219, "x", "double" ]
-[ 220, "y", "double" ]
-[ 221, "z", "double" ]
-[ 222, "cape_date", "date" ]
-[ 223, "num_at_cape", "int" ]
-[ 224, "objid", "bigint" ]
-[ 225, "ra", "double" ]
-[ 226, "dec", "double" ]
-[ 227, "mode", "tinyint" ]
-[ 228, "value", "double" ]
-[ 229, "objid", "bigint" ]
-[ 230, "distance", "double" ]
-[ 231, "objid", "bigint" ]
-[ 232, "distance", "double" ]
-[ 233, "objid", "bigint" ]
-[ 234, "distance", "double" ]
-[ 235, "objid", "bigint" ]
-[ 236, "distance", "double" ]
+[ 219, "cape_date", "date" ]
+[ 220, "num_at_cape", "int" ]
+[ 221, "objid", "bigint" ]
+[ 222, "ra", "double" ]
+[ 223, "dec", "double" ]
+[ 224, "mode", "tinyint" ]
+[ 225, "value", "double" ]
+[ 226, "objid", "bigint" ]
+[ 227, "distance", "double" ]
+[ 228, "objid", "bigint" ]
+[ 229, "distance", "double" ]
% ., sys.columns, sys.columns # table_name
% foo, name, type # name
% int, varchar, varchar # type
@@ -643,17 +636,17 @@
[ 1, "aggr", "boolean" ]
[ 1, "side_effect", "boolean" ]
[ 1, "func_id", "int" ]
+[ 1, "type", "varchar" ]
[ 1, "type", "smallint" ]
[ 1, "type", "smallint" ]
-[ 1, "type", "smallint" ]
-[ 1, "type", "int" ]
-[ 1, "type", "varchar" ]
[ 1, "type", "varchar" ]
[ 1, "type", "int" ]
-[ 1, "type", "varchar" ]
[ 1, "type", "int" ]
-[ 1, "type", "varchar" ]
[ 1, "type", "int" ]
+[ 1, "type", "int" ]
+[ 1, "type", "varchar" ]
+[ 1, "type", "smallint" ]
+[ 1, "type", "varchar" ]
[ 1, "type_digits", "int" ]
[ 1, "type_digits", "int" ]
[ 1, "type_digits", "int" ]
@@ -666,8 +659,8 @@
[ 1, "number", "int" ]
[ 1, "number", "int" ]
[ 1, "number", "int" ]
-[ 1, "start", "bigint" ]
[ 1, "start", "timestamp" ]
+[ 1, "start", "bigint" ]
[ 1, "minvalue", "bigint" ]
[ 1, "maxvalue", "bigint" ]
[ 1, "increment", "bigint" ]
@@ -679,8 +672,8 @@
[ 1, "port", "int" ]
[ 1, "db", "char" ]
[ 1, "db_alias", "char" ]
-[ 1, "user", "char" ]
[ 1, "user", "varchar" ]
+[ 1, "user", "char" ]
[ 1, "password", "char" ]
[ 1, "language", "char" ]
[ 1, "query", "varchar" ]
@@ -733,8 +726,8 @@
[ 1, "nr", "int" ]
[ 1, "nr", "int" ]
[ 1, "temporary", "smallint" ]
-[ 1, "value", "varchar" ]
[ 1, "value", "double" ]
+[ 1, "value", "varchar" ]
[ 1, "fullname", "varchar" ]
[ 1, "fullname", "varchar" ]
[ 1, "default_schema", "int" ]
@@ -788,25 +781,18 @@
[ 1, "time_local", "timestamp" ]
[ 1, "time_tz", "timestamptz" ]
[ 1, "x", "double" ]
-[ 1, "x", "double" ]
-[ 1, "y", "double" ]
[ 1, "y", "double" ]
[ 1, "z", "double" ]
-[ 1, "z", "double" ]
[ 1, "cape_date", "date" ]
[ 1, "num_at_cape", "int" ]
[ 1, "objid", "bigint" ]
[ 1, "objid", "bigint" ]
[ 1, "objid", "bigint" ]
-[ 1, "objid", "bigint" ]
-[ 1, "objid", "bigint" ]
[ 1, "ra", "double" ]
[ 1, "dec", "double" ]
[ 1, "mode", "tinyint" ]
[ 1, "distance", "double" ]
[ 1, "distance", "double" ]
-[ 1, "distance", "double" ]
-[ 1, "distance", "double" ]
% ., sys.columns, sys.columns # table_name
% foo, name, type # name
% int, varchar, varchar # type
@@ -1028,25 +1014,18 @@
[ 1, "time_local", "timestamp" ]
[ 1, "time_tz", "timestamptz" ]
[ 1, "x", "double" ]
-[ 1, "x", "double" ]
[ 1, "y", "double" ]
-[ 1, "y", "double" ]
-[ 1, "z", "double" ]
[ 1, "z", "double" ]
[ 1, "cape_date", "date" ]
[ 1, "num_at_cape", "int" ]
[ 1, "objid", "bigint" ]
[ 1, "objid", "bigint" ]
[ 1, "objid", "bigint" ]
-[ 1, "objid", "bigint" ]
-[ 1, "objid", "bigint" ]
[ 1, "ra", "double" ]
[ 1, "dec", "double" ]
[ 1, "mode", "tinyint" ]
[ 1, "distance", "double" ]
[ 1, "distance", "double" ]
-[ 1, "distance", "double" ]
-[ 1, "distance", "double" ]
% ., sys.columns, sys.columns # table_name
% foo, name, type # name
% int, varchar, varchar # type
@@ -1081,212 +1060,205 @@
[ 28, "digits", "int" ]
[ 29, "distance", "double" ]
[ 29, "distance", "double" ]
-[ 29, "distance", "double" ]
-[ 29, "distance", "double" ]
-[ 33, "eclass", "int" ]
-[ 34, "event", "smallint" ]
-[ 34, "event", "smallint" ]
-[ 36, "exec", "int" ]
-[ 37, "explicit", "boolean" ]
-[ 38, "fullname", "varchar" ]
-[ 38, "fullname", "varchar" ]
-[ 40, "func", "varchar" ]
-[ 41, "func_id", "int" ]
-[ 42, "grantable", "int" ]
-[ 43, "grantor", "int" ]
-[ 43, "grantor", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 45, "id", "int" ]
-[ 75, "increment", "bigint" ]
-[ 76, "language", "char" ]
-[ 77, "login_id", "int" ]
-[ 78, "maxvalue", "bigint" ]
-[ 79, "minvalue", "bigint" ]
-[ 80, "mod", "varchar" ]
-[ 81, "mode", "tinyint" ]
-[ 82, "name", "varchar" ]
-[ 82, "name", "varchar" ]
-[ 82, "name", "varchar" ]
-[ 82, "name", "varchar" ]
-[ 82, "name", "varchar" ]
-[ 82, "name", "varchar" ]
-[ 82, "name", "varchar" ]
-[ 82, "name", "varchar" ]
-[ 82, "name", "varchar" ]
-[ 82, "name", "varchar" ]
-[ 82, "name", "varchar" ]
-[ 82, "name", "varchar" ]
-[ 82, "name", "varchar" ]
-[ 82, "name", "varchar" ]
-[ 82, "name", "varchar" ]
-[ 82, "name", "varchar" ]
-[ 82, "name", "varchar" ]
-[ 82, "name", "varchar" ]
-[ 82, "name", "varchar" ]
-[ 82, "name", "varchar" ]
-[ 82, "name", "varchar" ]
-[ 82, "name", "varchar" ]
-[ 104, "new_name", "varchar" ]
-[ 104, "new_name", "varchar" ]
-[ 106, "nr", "int" ]
-[ 106, "nr", "int" ]
-[ 108, "null", "boolean" ]
-[ 108, "null", "boolean" ]
-[ 108, "null", "boolean" ]
-[ 111, "num_at_cape", "int" ]
-[ 112, "number", "int" ]
-[ 112, "number", "int" ]
-[ 112, "number", "int" ]
-[ 112, "number", "int" ]
-[ 116, "obj_id", "int" ]
-[ 117, "object", "int" ]
-[ 118, "objid", "bigint" ]
-[ 118, "objid", "bigint" ]
-[ 118, "objid", "bigint" ]
-[ 118, "objid", "bigint" ]
-[ 118, "objid", "bigint" ]
-[ 123, "old_name", "varchar" ]
-[ 123, "old_name", "varchar" ]
-[ 125, "optimize", "int" ]
-[ 126, "orientation", "smallint" ]
-[ 126, "orientation", "smallint" ]
-[ 128, "owner", "int" ]
-[ 129, "parse", "int" ]
-[ 130, "password", "char" ]
-[ 131, "port", "int" ]
-[ 132, "predicate", "int" ]
-[ 133, "privileges", "int" ]
-[ 134, "query", "varchar" ]
-[ 134, "query", "varchar" ]
-[ 134, "query", "varchar" ]
-[ 134, "query", "varchar" ]
-[ 138, "ra", "double" ]
-[ 139, "radix", "int" ]
-[ 140, "rkey", "int" ]
-[ 140, "rkey", "int" ]
-[ 142, "role_id", "int" ]
-[ 143, "scale", "int" ]
-[ 144, "schema_id", "int" ]
-[ 144, "schema_id", "int" ]
-[ 144, "schema_id", "int" ]
-[ 144, "schema_id", "int" ]
-[ 144, "schema_id", "int" ]
-[ 144, "schema_id", "int" ]
-[ 150, "server", "char" ]
-[ 151, "side_effect", "boolean" ]
-[ 152, "sql", "boolean" ]
-[ 153, "sqlname", "varchar" ]
-[ 154, "start", "bigint" ]
-[ 155, "start", "timestamp" ]
-[ 156, "statement", "varchar" ]
-[ 156, "statement", "varchar" ]
-[ 158, "subject", "int" ]
-[ 159, "system", "boolean" ]
-[ 159, "system", "boolean" ]
-[ 159, "system", "boolean" ]
-[ 162, "systemname", "varchar" ]
-[ 163, "table_id", "int" ]
-[ 163, "table_id", "int" ]
-[ 163, "table_id", "int" ]
-[ 163, "table_id", "int" ]
-[ 163, "table_id", "int" ]
-[ 163, "table_id", "int" ]
-[ 163, "table_id", "int" ]
-[ 163, "table_id", "int" ]
-[ 163, "table_id", "int" ]
-[ 172, "temporary", "smallint" ]
-[ 173, "time", "smallint" ]
-[ 173, "time", "smallint" ]
-[ 175, "time_local", "timestamp" ]
-[ 176, "time_tz", "timestamptz" ]
-[ 177, "total", "int" ]
-[ 178, "trunc", "int" ]
-[ 178, "trunc", "int" ]
-[ 180, "type", "int" ]
-[ 180, "type", "int" ]
-[ 180, "type", "int" ]
-[ 180, "type", "int" ]
-[ 184, "type", "smallint" ]
-[ 184, "type", "smallint" ]
-[ 184, "type", "smallint" ]
-[ 187, "type", "varchar" ]
-[ 187, "type", "varchar" ]
-[ 187, "type", "varchar" ]
-[ 187, "type", "varchar" ]
-[ 191, "type_digits", "int" ]
-[ 191, "type_digits", "int" ]
-[ 191, "type_digits", "int" ]
-[ 191, "type_digits", "int" ]
-[ 195, "type_scale", "int" ]
-[ 195, "type_scale", "int" ]
-[ 195, "type_scale", "int" ]
-[ 195, "type_scale", "int" ]
-[ 199, "user", "char" ]
-[ 200, "user", "varchar" ]
-[ 201, "user_id", "int" ]
-[ 202, "val1", "int" ]
-[ 202, "val1", "int" ]
-[ 202, "val1", "int" ]
-[ 202, "val1", "int" ]
-[ 202, "val1", "int" ]
-[ 202, "val1", "int" ]
-[ 202, "val1", "int" ]
-[ 202, "val1", "int" ]
-[ 202, "val1", "int" ]
-[ 211, "val2", "varchar" ]
-[ 211, "val2", "varchar" ]
-[ 211, "val2", "varchar" ]
-[ 211, "val2", "varchar" ]
-[ 211, "val2", "varchar" ]
-[ 211, "val2", "varchar" ]
-[ 211, "val2", "varchar" ]
-[ 211, "val2", "varchar" ]
-[ 211, "val2", "varchar" ]
-[ 220, "val3", "double" ]
-[ 220, "val3", "double" ]
-[ 220, "val3", "double" ]
-[ 220, "val3", "double" ]
-[ 220, "val3", "double" ]
-[ 220, "val3", "double" ]
-[ 220, "val3", "double" ]
-[ 220, "val3", "double" ]
-[ 220, "val3", "double" ]
-[ 229, "value", "double" ]
-[ 230, "value", "varchar" ]
-[ 231, "x", "double" ]
-[ 231, "x", "double" ]
-[ 233, "y", "double" ]
-[ 233, "y", "double" ]
-[ 235, "z", "double" ]
-[ 235, "z", "double" ]
+[ 31, "eclass", "int" ]
+[ 32, "event", "smallint" ]
+[ 32, "event", "smallint" ]
+[ 34, "exec", "int" ]
+[ 35, "explicit", "boolean" ]
+[ 36, "fullname", "varchar" ]
+[ 36, "fullname", "varchar" ]
+[ 38, "func", "varchar" ]
+[ 39, "func_id", "int" ]
+[ 40, "grantable", "int" ]
+[ 41, "grantor", "int" ]
+[ 41, "grantor", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 43, "id", "int" ]
+[ 73, "increment", "bigint" ]
+[ 74, "language", "char" ]
+[ 75, "login_id", "int" ]
+[ 76, "maxvalue", "bigint" ]
+[ 77, "minvalue", "bigint" ]
+[ 78, "mod", "varchar" ]
+[ 79, "mode", "tinyint" ]
+[ 80, "name", "varchar" ]
+[ 80, "name", "varchar" ]
+[ 80, "name", "varchar" ]
+[ 80, "name", "varchar" ]
+[ 80, "name", "varchar" ]
+[ 80, "name", "varchar" ]
+[ 80, "name", "varchar" ]
+[ 80, "name", "varchar" ]
+[ 80, "name", "varchar" ]
+[ 80, "name", "varchar" ]
+[ 80, "name", "varchar" ]
+[ 80, "name", "varchar" ]
+[ 80, "name", "varchar" ]
+[ 80, "name", "varchar" ]
+[ 80, "name", "varchar" ]
+[ 80, "name", "varchar" ]
+[ 80, "name", "varchar" ]
+[ 80, "name", "varchar" ]
+[ 80, "name", "varchar" ]
+[ 80, "name", "varchar" ]
+[ 80, "name", "varchar" ]
+[ 80, "name", "varchar" ]
+[ 102, "new_name", "varchar" ]
+[ 102, "new_name", "varchar" ]
+[ 104, "nr", "int" ]
+[ 104, "nr", "int" ]
+[ 106, "null", "boolean" ]
+[ 106, "null", "boolean" ]
+[ 106, "null", "boolean" ]
+[ 109, "num_at_cape", "int" ]
+[ 110, "number", "int" ]
+[ 110, "number", "int" ]
+[ 110, "number", "int" ]
+[ 110, "number", "int" ]
+[ 114, "obj_id", "int" ]
+[ 115, "object", "int" ]
+[ 116, "objid", "bigint" ]
+[ 116, "objid", "bigint" ]
+[ 116, "objid", "bigint" ]
+[ 119, "old_name", "varchar" ]
+[ 119, "old_name", "varchar" ]
+[ 121, "optimize", "int" ]
+[ 122, "orientation", "smallint" ]
+[ 122, "orientation", "smallint" ]
+[ 124, "owner", "int" ]
+[ 125, "parse", "int" ]
+[ 126, "password", "char" ]
+[ 127, "port", "int" ]
+[ 128, "predicate", "int" ]
+[ 129, "privileges", "int" ]
+[ 130, "query", "varchar" ]
+[ 130, "query", "varchar" ]
+[ 130, "query", "varchar" ]
+[ 130, "query", "varchar" ]
+[ 134, "ra", "double" ]
+[ 135, "radix", "int" ]
+[ 136, "rkey", "int" ]
+[ 136, "rkey", "int" ]
+[ 138, "role_id", "int" ]
+[ 139, "scale", "int" ]
+[ 140, "schema_id", "int" ]
+[ 140, "schema_id", "int" ]
+[ 140, "schema_id", "int" ]
+[ 140, "schema_id", "int" ]
+[ 140, "schema_id", "int" ]
+[ 140, "schema_id", "int" ]
+[ 146, "server", "char" ]
+[ 147, "side_effect", "boolean" ]
+[ 148, "sql", "boolean" ]
+[ 149, "sqlname", "varchar" ]
+[ 150, "start", "bigint" ]
+[ 151, "start", "timestamp" ]
+[ 152, "statement", "varchar" ]
+[ 152, "statement", "varchar" ]
+[ 154, "subject", "int" ]
+[ 155, "system", "boolean" ]
+[ 155, "system", "boolean" ]
+[ 155, "system", "boolean" ]
+[ 158, "systemname", "varchar" ]
+[ 159, "table_id", "int" ]
+[ 159, "table_id", "int" ]
+[ 159, "table_id", "int" ]
+[ 159, "table_id", "int" ]
+[ 159, "table_id", "int" ]
+[ 159, "table_id", "int" ]
+[ 159, "table_id", "int" ]
+[ 159, "table_id", "int" ]
+[ 159, "table_id", "int" ]
+[ 168, "temporary", "smallint" ]
+[ 169, "time", "smallint" ]
+[ 169, "time", "smallint" ]
+[ 171, "time_local", "timestamp" ]
+[ 172, "time_tz", "timestamptz" ]
+[ 173, "total", "int" ]
+[ 174, "trunc", "int" ]
+[ 174, "trunc", "int" ]
+[ 176, "type", "int" ]
+[ 176, "type", "int" ]
+[ 176, "type", "int" ]
+[ 176, "type", "int" ]
+[ 180, "type", "smallint" ]
+[ 180, "type", "smallint" ]
+[ 180, "type", "smallint" ]
+[ 183, "type", "varchar" ]
+[ 183, "type", "varchar" ]
+[ 183, "type", "varchar" ]
+[ 183, "type", "varchar" ]
+[ 187, "type_digits", "int" ]
+[ 187, "type_digits", "int" ]
+[ 187, "type_digits", "int" ]
+[ 187, "type_digits", "int" ]
+[ 191, "type_scale", "int" ]
+[ 191, "type_scale", "int" ]
+[ 191, "type_scale", "int" ]
+[ 191, "type_scale", "int" ]
+[ 195, "user", "char" ]
+[ 196, "user", "varchar" ]
+[ 197, "user_id", "int" ]
+[ 198, "val1", "int" ]
+[ 198, "val1", "int" ]
+[ 198, "val1", "int" ]
+[ 198, "val1", "int" ]
+[ 198, "val1", "int" ]
+[ 198, "val1", "int" ]
+[ 198, "val1", "int" ]
+[ 198, "val1", "int" ]
+[ 198, "val1", "int" ]
+[ 207, "val2", "varchar" ]
+[ 207, "val2", "varchar" ]
+[ 207, "val2", "varchar" ]
+[ 207, "val2", "varchar" ]
+[ 207, "val2", "varchar" ]
+[ 207, "val2", "varchar" ]
+[ 207, "val2", "varchar" ]
+[ 207, "val2", "varchar" ]
+[ 207, "val2", "varchar" ]
+[ 216, "val3", "double" ]
+[ 216, "val3", "double" ]
+[ 216, "val3", "double" ]
+[ 216, "val3", "double" ]
+[ 216, "val3", "double" ]
+[ 216, "val3", "double" ]
+[ 216, "val3", "double" ]
+[ 216, "val3", "double" ]
+[ 216, "val3", "double" ]
+[ 225, "value", "double" ]
+[ 226, "value", "varchar" ]
+[ 227, "x", "double" ]
+[ 228, "y", "double" ]
+[ 229, "z", "double" ]
% sys., sys.columns, sys.columns # table_name
% foo, name, type # name
% int, varchar, varchar # type
@@ -1509,24 +1481,17 @@
[ 216, "x", "double" ]
[ 217, "y", "double" ]
[ 218, "z", "double" ]
-[ 219, "x", "double" ]
-[ 220, "y", "double" ]
-[ 221, "z", "double" ]
-[ 222, "cape_date", "date" ]
-[ 223, "num_at_cape", "int" ]
-[ 224, "objid", "bigint" ]
-[ 225, "ra", "double" ]
-[ 226, "dec", "double" ]
-[ 227, "mode", "tinyint" ]
-[ 228, "value", "double" ]
-[ 229, "objid", "bigint" ]
-[ 230, "distance", "double" ]
-[ 231, "objid", "bigint" ]
-[ 232, "distance", "double" ]
-[ 233, "objid", "bigint" ]
-[ 234, "distance", "double" ]
-[ 235, "objid", "bigint" ]
-[ 236, "distance", "double" ]
+[ 219, "cape_date", "date" ]
+[ 220, "num_at_cape", "int" ]
+[ 221, "objid", "bigint" ]
+[ 222, "ra", "double" ]
+[ 223, "dec", "double" ]
+[ 224, "mode", "tinyint" ]
+[ 225, "value", "double" ]
+[ 226, "objid", "bigint" ]
+[ 227, "distance", "double" ]
+[ 228, "objid", "bigint" ]
+[ 229, "distance", "double" ]
% ., sys.columns, sys.columns # table_name
% foo, name, type # name
% int, varchar, varchar # type
@@ -1603,17 +1568,17 @@
[ 1, "aggr", "boolean" ]
[ 1, "side_effect", "boolean" ]
[ 1, "func_id", "int" ]
+[ 1, "type", "varchar" ]
[ 1, "type", "smallint" ]
[ 1, "type", "smallint" ]
-[ 1, "type", "smallint" ]
-[ 1, "type", "int" ]
-[ 1, "type", "varchar" ]
[ 1, "type", "varchar" ]
[ 1, "type", "int" ]
-[ 1, "type", "varchar" ]
[ 1, "type", "int" ]
-[ 1, "type", "varchar" ]
[ 1, "type", "int" ]
+[ 1, "type", "int" ]
+[ 1, "type", "varchar" ]
+[ 1, "type", "smallint" ]
+[ 1, "type", "varchar" ]
[ 1, "type_digits", "int" ]
[ 1, "type_digits", "int" ]
[ 1, "type_digits", "int" ]
@@ -1626,8 +1591,8 @@
[ 1, "number", "int" ]
[ 1, "number", "int" ]
[ 1, "number", "int" ]
-[ 1, "start", "bigint" ]
[ 1, "start", "timestamp" ]
+[ 1, "start", "bigint" ]
[ 1, "minvalue", "bigint" ]
[ 1, "maxvalue", "bigint" ]
[ 1, "increment", "bigint" ]
@@ -1639,8 +1604,8 @@
[ 1, "port", "int" ]
[ 1, "db", "char" ]
[ 1, "db_alias", "char" ]
-[ 1, "user", "char" ]
[ 1, "user", "varchar" ]
+[ 1, "user", "char" ]
[ 1, "password", "char" ]
[ 1, "language", "char" ]
[ 1, "query", "varchar" ]
@@ -1693,8 +1658,8 @@
[ 1, "nr", "int" ]
[ 1, "nr", "int" ]
[ 1, "temporary", "smallint" ]
-[ 1, "value", "varchar" ]
[ 1, "value", "double" ]
+[ 1, "value", "varchar" ]
[ 1, "fullname", "varchar" ]
[ 1, "fullname", "varchar" ]
[ 1, "default_schema", "int" ]
@@ -1748,25 +1713,18 @@
[ 1, "time_local", "timestamp" ]
[ 1, "time_tz", "timestamptz" ]
[ 1, "x", "double" ]
-[ 1, "x", "double" ]
[ 1, "y", "double" ]
-[ 1, "y", "double" ]
-[ 1, "z", "double" ]
[ 1, "z", "double" ]
[ 1, "cape_date", "date" ]
[ 1, "num_at_cape", "int" ]
[ 1, "objid", "bigint" ]
[ 1, "objid", "bigint" ]
[ 1, "objid", "bigint" ]
-[ 1, "objid", "bigint" ]
-[ 1, "objid", "bigint" ]
[ 1, "ra", "double" ]
[ 1, "dec", "double" ]
[ 1, "mode", "tinyint" ]
[ 1, "distance", "double" ]
[ 1, "distance", "double" ]
-[ 1, "distance", "double" ]
-[ 1, "distance", "double" ]
% ., sys.columns, sys.columns # table_name
% foo, name, type # name
% int, varchar, varchar # type
@@ -1988,25 +1946,18 @@
[ 1, "time_local", "timestamp" ]
[ 1, "time_tz", "timestamptz" ]
[ 1, "x", "double" ]
-[ 1, "x", "double" ]
-[ 1, "y", "double" ]
[ 1, "y", "double" ]
[ 1, "z", "double" ]
-[ 1, "z", "double" ]
[ 1, "cape_date", "date" ]
[ 1, "num_at_cape", "int" ]
[ 1, "objid", "bigint" ]
[ 1, "objid", "bigint" ]
[ 1, "objid", "bigint" ]
-[ 1, "objid", "bigint" ]
-[ 1, "objid", "bigint" ]
[ 1, "ra", "double" ]
[ 1, "dec", "double" ]
[ 1, "mode", "tinyint" ]
[ 1, "distance", "double" ]
[ 1, "distance", "double" ]
-[ 1, "distance", "double" ]
-[ 1, "distance", "double" ]
% ., sys.columns, sys.columns # table_name
% foo, name, type # name
% int, varchar, varchar # type
@@ -2041,8 +1992,6 @@
[ 20, "digits", "int" ]
[ 21, "distance", "double" ]
[ 21, "distance", "double" ]
-[ 21, "distance", "double" ]
-[ 21, "distance", "double" ]
[ 22, "eclass", "int" ]
[ 23, "event", "smallint" ]
[ 23, "event", "smallint" ]
@@ -2131,8 +2080,6 @@
[ 47, "objid", "bigint" ]
[ 47, "objid", "bigint" ]
[ 47, "objid", "bigint" ]
-[ 47, "objid", "bigint" ]
-[ 47, "objid", "bigint" ]
[ 48, "old_name", "varchar" ]
[ 48, "old_name", "varchar" ]
[ 49, "optimize", "int" ]
@@ -2242,10 +2189,7 @@
[ 92, "value", "double" ]
[ 93, "value", "varchar" ]
[ 94, "x", "double" ]
-[ 94, "x", "double" ]
[ 95, "y", "double" ]
-[ 95, "y", "double" ]
-[ 96, "z", "double" ]
[ 96, "z", "double" ]
# 22:17:03 >
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
