Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory
sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv10921/src/test/BugTracker-2009/Tests
Modified Files:
POWER_vs_prod.SF-2596114.stable.out ambiguous_view.stable.err
copy_multiple_files.SF-2902320.stable.out
create_on_ro_db_crash.SF-2830238.stable.err
explain_gives_crash.SF-2741829.stable.err
explain_gives_crash.SF-2741829.stable.out
primekeyconstraint.SF-2783425.stable.err
reorder.SF-2770608.stable.out.32bit
set_history_and_drop_table.SF-2607045.stable.out
temp_table_fail_leaves_data.SF-2793286.stable.err
temporary_table_leftover.SF-2734713.stable.err
Log Message:
moved most of the DDL statements into mal
Index: create_on_ro_db_crash.SF-2830238.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/create_on_ro_db_crash.SF-2830238.stable.err,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- create_on_ro_db_crash.SF-2830238.stable.err 21 Sep 2009 14:14:15 -0000
1.2
+++ create_on_ro_db_crash.SF-2830238.stable.err 10 Jan 2010 15:33:37 -0000
1.3
@@ -5,12 +5,12 @@
# 21:37:20 > /usr/bin/python create_on_ro_db_crash.SF-2830238.py
create_on_ro_db_crash.SF-2830238
# 21:37:20 >
-MAPI = mone...@alf:39382
+MAPI = mone...@localhost:39621
QUERY = create table t2 (a int);
-ERROR = !schema statements cannot be executed on a readonly database.
-# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
-# builtin opt gdk_version = 1.32.0
-# builtin opt prefix = /ufs/niels/scratch/rc/Linux-x86_64
+ERROR = !MALException:(unknown):schema statements cannot be executed on a
readonly database.
+# builtin opt gdk_arch = 32biti686-pc-linux-gnu
+# builtin opt gdk_version = 1.35.0
+# builtin opt prefix = /home/niels/scratch/monetdb/Linux-i686
# builtin opt exec_prefix = ${prefix}
# builtin opt gdk_dbname = tst
# builtin opt gdk_dbfarm = ${prefix}/var/MonetDB
Index: copy_multiple_files.SF-2902320.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- copy_multiple_files.SF-2902320.stable.out 29 Nov 2009 10:33:13 -0000
1.2
+++ copy_multiple_files.SF-2902320.stable.out 10 Jan 2010 15:33:37 -0000
1.3
@@ -29,8 +29,9 @@
% .plan # table_name
% rel # name
% clob # type
-% 22 # length
-insert(sys.cm_tmp,
+% 54 # length
+insert(
+| table(sys.cm_tmp) [ cm_tmp.i, cm_tmp.%TID% NOT NULL ]
| union (
| | table [ cm_tmp.i ],
| | table [ cm_tmp.i ]
Index: set_history_and_drop_table.SF-2607045.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/set_history_and_drop_table.SF-2607045.stable.out,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -d -r1.10 -r1.11
--- set_history_and_drop_table.SF-2607045.stable.out 9 Oct 2009 15:43:17
-0000 1.10
+++ set_history_and_drop_table.SF-2607045.stable.out 10 Jan 2010 15:33:37
-0000 1.11
@@ -57,9 +57,9 @@
[ 4160 ]
[ 4163 ]
[ 4167 ]
-[ 4412 ]
-[ 4421 ]
-[ 4434 ]
+[ 4464 ]
+[ 4478 ]
+[ 4494 ]
Drop history
# 23:32:55 >
Index: temporary_table_leftover.SF-2734713.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/temporary_table_leftover.SF-2734713.stable.err,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- temporary_table_leftover.SF-2734713.stable.err 13 Dec 2009 20:33:16
-0000 1.3
+++ temporary_table_leftover.SF-2734713.stable.err 10 Jan 2010 15:33:37
-0000 1.4
@@ -78,21 +78,21 @@
# 19:21:38 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=30398
# 19:21:38 >
-MAPI = mone...@localhost:31523
+MAPI = mone...@localhost:38198
QUERY = blabla;
ERROR = !syntax error, unexpected IDENT in: "blabla"
-MAPI = mone...@localhost:31523
+MAPI = mone...@localhost:38198
QUERY = COMMIT;
ERROR = !SQLException:sql.trans:COMMIT: failed
-MAPI = mone...@localhost:31523
+MAPI = mone...@localhost:38198
QUERY = blabla;
ERROR = !syntax error, unexpected IDENT in: "blabla"
-MAPI = mone...@localhost:31523
+MAPI = mone...@localhost:38198
QUERY = COMMIT;
ERROR = !SQLException:sql.trans:COMMIT: failed
-MAPI = mone...@localhost:31523
+MAPI = mone...@localhost:38198
QUERY = drop table persistent_temopary;
-ERROR = !DROP TABLE: no such table 'persistent_temopary'
+ERROR = !SQLException:sql.catalog:DROP TABLE: no such table
'persistent_temopary'
# 19:21:38 >
# 19:21:38 > Done.
Index: explain_gives_crash.SF-2741829.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.stable.err,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- explain_gives_crash.SF-2741829.stable.err 26 Jul 2009 09:13:33 -0000
1.3
+++ explain_gives_crash.SF-2741829.stable.err 10 Jan 2010 15:33:37 -0000
1.4
@@ -71,18 +71,9 @@
# 22:45:54 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=35519
# 22:45:54 >
-MAPI = mone...@alf:35519
-QUERY = explain alter table blabla add constraint dada unique (id);
-ERROR = !schema statements are directly executed and therefore cannot be
debugged, explained, profiled, traced or used in a prepared statement
-MAPI = mone...@alf:35519
-QUERY = explain alter table blabla add constraint dada unique (id);
-ERROR = !schema statements are directly executed and therefore cannot be
debugged, explained, profiled, traced or used in a prepared statement
-MAPI = mone...@alf:35519
+MAPI = mone...@localhost:39621
QUERY = alter table blabla drop constraint dada;
ERROR = !ALTER TABLE: no such constraint 'dada'
-MAPI = mone...@alf:35519
-QUERY = explain alter table blabla add constraint dada unique (id);
-ERROR = !schema statements are directly executed and therefore cannot be
debugged, explained, profiled, traced or used in a prepared statement
# 22:45:54 >
# 22:45:54 > Done.
Index: ambiguous_view.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/ambiguous_view.stable.err,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- ambiguous_view.stable.err 26 Feb 2009 21:21:32 -0000 1.2
+++ ambiguous_view.stable.err 10 Jan 2010 15:33:37 -0000 1.3
@@ -79,15 +79,15 @@
# 20:07:37 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=38269
# 20:07:37 >
-MAPI = mone...@alf:38269
+MAPI = mone...@localhost:38198
QUERY = CREATE VIEW eur_kg_test AS
ERROR = !CREATE VIEW: duplicate column name dt_uom
-MAPI = mone...@alf:38269
+MAPI = mone...@localhost:38198
QUERY = select * from eur_kg_test;
ERROR = !SELECT: no such table 'eur_kg_test'
-MAPI = mone...@alf:38269
+MAPI = mone...@localhost:38198
QUERY = drop view eur_kg_test;
-ERROR = !DROP VIEW: unknown view 'eur_kg_test'
+ERROR = !SQLException:sql.catalog:DROP VIEW: unknown view 'eur_kg_test'
# 20:07:37 >
# 20:07:37 > Done.
Index: temp_table_fail_leaves_data.SF-2793286.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/temp_table_fail_leaves_data.SF-2793286.stable.err,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- temp_table_fail_leaves_data.SF-2793286.stable.err 8 Nov 2009 23:58:03
-0000 1.3
+++ temp_table_fail_leaves_data.SF-2793286.stable.err 10 Jan 2010 15:33:37
-0000 1.4
@@ -71,13 +71,10 @@
# 15:05:11 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=36217
# 15:05:11 >
-MAPI = mone...@alf:37416
-QUERY = create temporary table testpk (hello int, primary key(hello));
-ERROR = !CONSTRAINT: constraints on temporary tables are not supported
table sys.testpk does not exist
-MAPI = mone...@alf:37416
+MAPI = mone...@localhost:38198
QUERY = create temporary table testpk (hello int, primary key(hello));
-ERROR = !CONSTRAINT: constraints on temporary tables are not supported
+ERROR = !CREATE TABLE: name 'testpk' already in use
# 15:05:11 >
# 15:05:11 > Done.
Index: explain_gives_crash.SF-2741829.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- explain_gives_crash.SF-2741829.stable.out 30 May 2009 04:29:29 -0000
1.2
+++ explain_gives_crash.SF-2741829.stable.out 10 Jan 2010 15:33:37 -0000
1.3
@@ -21,12 +21,108 @@
Over..
-# 22:45:54 >
-# 22:45:54 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=35519
-# 22:45:54 >
+# 11:37:27 >
+# 11:37:27 > mclient -lsql -i --host=localhost --port=39621
+# 11:37:27 >
+% .explain # table_name
+% mal # name
+% clob # type
+% 0 # length
+function user.s0_1{autoCommit=true}():void;
+ sql.catalog(28,"sys",3008394056,0);
+barrier _46 := language.dataflow();
+ _6:bat[:oid,:int] := sql.bind("sys","blabla","id",0);
+ _9 := algebra.selectNotNil(_6);
+ _6:bat[:oid,:int] := nil:BAT;
+ _10:bat[:oid,:oid] := sql.bind_dbat("sys","blabla",1);
+ _12 := bat.reverse(_10);
+ _10:bat[:oid,:oid] := nil:BAT;
+ _13 := algebra.kdifference(_9,_12);
+ _9 := nil:BAT;
+ _12 := nil:BAT;
+ (ext20,grp18) := group.new(_13);
+ _13 := nil:BAT;
+ _16 := bat.mirror(ext20);
+ ext20 := nil:BAT;
+ _17:bat[:oid,:wrd] := aggr.count(grp18,grp18,_16);
+ grp18 := nil:BAT;
+ _16 := nil:BAT;
+ _18 := aggr.count(_17);
+ _19:wrd := aggr.sum(_17);
+ _17:bat[:oid,:wrd] := nil:BAT;
+ _20 := calc.isnil(_19);
+ _22 := calc.ifthenelse(_20,0:wrd,_19);
+ _23 := calc.!=(_18,_22);
+exit _46;
+ sql.assert(_23,"UPDATE: UNIQUE constraint 'blabla.dada' violated");
+end s0_1;
+% .explain # table_name
+% mal # name
+% clob # type
+% 0 # length
+function user.s1_1{autoCommit=true}():void;
+ sql.catalog(28,"sys",3009062784,0);
+barrier _46 := language.dataflow();
+ _6:bat[:oid,:int] := sql.bind("sys","blabla","id",0);
+ _9 := algebra.selectNotNil(_6);
+ _6:bat[:oid,:int] := nil:BAT;
+ _10:bat[:oid,:oid] := sql.bind_dbat("sys","blabla",1);
+ _12 := bat.reverse(_10);
+ _10:bat[:oid,:oid] := nil:BAT;
+ _13 := algebra.kdifference(_9,_12);
+ _9 := nil:BAT;
+ _12 := nil:BAT;
+ (ext20,grp18) := group.new(_13);
+ _13 := nil:BAT;
+ _16 := bat.mirror(ext20);
+ ext20 := nil:BAT;
+ _17:bat[:oid,:wrd] := aggr.count(grp18,grp18,_16);
+ grp18 := nil:BAT;
+ _16 := nil:BAT;
+ _18 := aggr.count(_17);
+ _19:wrd := aggr.sum(_17);
+ _17:bat[:oid,:wrd] := nil:BAT;
+ _20 := calc.isnil(_19);
+ _22 := calc.ifthenelse(_20,0:wrd,_19);
+ _23 := calc.!=(_18,_22);
+exit _46;
+ sql.assert(_23,"UPDATE: UNIQUE constraint 'blabla.dada' violated");
+end s1_1;
+% .explain # table_name
+% mal # name
+% clob # type
+% 0 # length
+function user.s0_1{autoCommit=true}():void;
+ sql.catalog(28,"sys",3006267824,0);
+barrier _46 := language.dataflow();
+ _6:bat[:oid,:int] := sql.bind("sys","blabla","id",0);
+ _9 := algebra.selectNotNil(_6);
+ _6:bat[:oid,:int] := nil:BAT;
+ _10:bat[:oid,:oid] := sql.bind_dbat("sys","blabla",1);
+ _12 := bat.reverse(_10);
+ _10:bat[:oid,:oid] := nil:BAT;
+ _13 := algebra.kdifference(_9,_12);
+ _9 := nil:BAT;
+ _12 := nil:BAT;
+ (ext20,grp18) := group.new(_13);
+ _13 := nil:BAT;
+ _16 := bat.mirror(ext20);
+ ext20 := nil:BAT;
+ _17:bat[:oid,:wrd] := aggr.count(grp18,grp18,_16);
+ grp18 := nil:BAT;
+ _16 := nil:BAT;
+ _18 := aggr.count(_17);
+ _19:wrd := aggr.sum(_17);
+ _17:bat[:oid,:wrd] := nil:BAT;
+ _20 := calc.isnil(_19);
+ _22 := calc.ifthenelse(_20,0:wrd,_19);
+ _23 := calc.!=(_18,_22);
+exit _46;
+ sql.assert(_23,"UPDATE: UNIQUE constraint 'blabla.dada' violated");
+end s0_1;
-# 22:45:54 >
-# 22:45:54 > Done.
-# 22:45:54 >
+# 11:37:28 >
+# 11:37:28 > Done.
+# 11:37:28 >
Index: POWER_vs_prod.SF-2596114.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -d -r1.8 -r1.9
--- POWER_vs_prod.SF-2596114.stable.out 9 Nov 2009 23:36:19 -0000 1.8
+++ POWER_vs_prod.SF-2596114.stable.out 10 Jan 2010 15:33:36 -0000 1.9
@@ -33,16 +33,16 @@
barrier _46 := language.dataflow();
_2:bat[:oid,:dbl] := sql.bind("sys","sf_2596114","x",0);
_7:bat[:oid,:dbl] := sql.bind("sys","sf_2596114","x",2);
+ _11:bat[:oid,:dbl] := sql.bind("sys","sf_2596114","x",1);
+ _14:bat[:oid,:oid] := sql.bind_dbat("sys","sf_2596114",1);
_9 := algebra.kdifference(_2,_7);
_2:bat[:oid,:dbl] := nil:BAT;
_10 := algebra.kunion(_9,_7);
_9 := nil:BAT;
_7:bat[:oid,:dbl] := nil:BAT;
- _11:bat[:oid,:dbl] := sql.bind("sys","sf_2596114","x",1);
_13 := algebra.kunion(_10,_11);
_10 := nil:BAT;
_11:bat[:oid,:dbl] := nil:BAT;
- _14:bat[:oid,:oid] := sql.bind_dbat("sys","sf_2596114",1);
_15 := bat.reverse(_14);
_14:bat[:oid,:oid] := nil:BAT;
_16 := algebra.kdifference(_13,_15);
@@ -65,16 +65,16 @@
barrier _45 := language.dataflow();
_2:bat[:oid,:dbl] := sql.bind("sys","sf_2596114","x",0);
_7:bat[:oid,:dbl] := sql.bind("sys","sf_2596114","x",2);
+ _11:bat[:oid,:dbl] := sql.bind("sys","sf_2596114","x",1);
+ _14:bat[:oid,:oid] := sql.bind_dbat("sys","sf_2596114",1);
_9 := algebra.kdifference(_2,_7);
_2:bat[:oid,:dbl] := nil:BAT;
_10 := algebra.kunion(_9,_7);
_9 := nil:BAT;
_7:bat[:oid,:dbl] := nil:BAT;
- _11:bat[:oid,:dbl] := sql.bind("sys","sf_2596114","x",1);
_13 := algebra.kunion(_10,_11);
_10 := nil:BAT;
_11:bat[:oid,:dbl] := nil:BAT;
- _14:bat[:oid,:oid] := sql.bind_dbat("sys","sf_2596114",1);
_15 := bat.reverse(_14);
_14:bat[:oid,:oid] := nil:BAT;
_16 := algebra.kdifference(_13,_15);
Index: primekeyconstraint.SF-2783425.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/primekeyconstraint.SF-2783425.stable.err,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- primekeyconstraint.SF-2783425.stable.err 7 Jun 2009 20:02:42 -0000
1.3
+++ primekeyconstraint.SF-2783425.stable.err 10 Jan 2010 15:33:37 -0000
1.4
@@ -69,10 +69,9 @@
# 08:02:34 > mclient -lsql -umonetdb -Pmonetdb --host=eir --port=30582
# 08:02:34 >
-MAPI = mone...@alf:38363
+MAPI = mone...@localhost:30291
QUERY = ALTER TABLE way_nds ADD CONSTRAINT pk_way_nds PRIMARY KEY (way, idx);
-ERROR = !SQLException:assert:CONSTRAINT PRIMARY KEY: NOT NULL constraint
violated for column way_nds.way
-
+ERROR = !SQLException:sql.catalog:ALTER TABLE: NOT NULL constraint violated
for column way_nds.way
# 08:02:34 >
# 08:02:34 > Done.
Index: reorder.SF-2770608.stable.out.32bit
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/reorder.SF-2770608.stable.out.32bit,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- reorder.SF-2770608.stable.out.32bit 29 Nov 2009 09:27:06 -0000 1.1
+++ reorder.SF-2770608.stable.out.32bit 10 Jan 2010 15:33:37 -0000 1.2
@@ -31,32 +31,33 @@
% 2, 9, 14, 2, 1, 2, 2, 1, 2, 9,
14, 2, 1, 2, 2, 1 # length
[ 0, "any", "any", 0, 0, 0, 0, 0, 0, "any",
"any", 0, 0, 0, 0, 0 ]
[ 1, "bat", "table", 0, 0, 0, 1, 0, 1,
"bat", "table", 0, 0, 0, 1, 0 ]
-[ 2, "bit", "boolean", 1, 0, 2, 2, 0, 2,
"bit", "boolean", 1, 0, 2, 2, 0 ]
-[ 3, "str", "char", 0, 0, 0, 3, 0, 3, "str",
"char", 0, 0, 0, 3, 0 ]
-[ 4, "str", "varchar", 0, 0, 0, 4, 0, 4,
"str", "varchar", 0, 0, 0, 4, 0 ]
-[ 5, "str", "clob", 0, 0, 0, 4, 0, 5, "str",
"clob", 0, 0, 0, 4, 0 ]
-[ 6, "bte", "tinyint", 8, 1, 2, 6, 0, 6,
"bte", "tinyint", 8, 1, 2, 6, 0 ]
-[ 7, "sht", "smallint", 16, 1, 2, 6, 0, 7,
"sht", "smallint", 16, 1, 2, 6, 0 ]
-[ 8, "oid", "oid", 31, 0, 2, 6, 0, 8, "oid",
"oid", 31, 0, 2, 6, 0 ]
-[ 9, "int", "int", 32, 1, 2, 6, 0, 9, "int",
"int", 32, 1, 2, 6, 0 ]
-[ 10, "wrd", "wrd", 32, 1, 2, 6, 0, 10, "wrd",
"wrd", 32, 1, 2, 6, 0 ]
-[ 11, "lng", "bigint", 64, 1, 2, 6, 0, 11,
"lng", "bigint", 64, 1, 2, 6, 0 ]
-[ 12, "bte", "decimal", 2, 1, 10, 8, 0, 12,
"bte", "decimal", 2, 1, 10, 8, 0 ]
-[ 13, "sht", "decimal", 4, 1, 10, 8, 0, 13,
"sht", "decimal", 4, 1, 10, 8, 0 ]
-[ 14, "int", "decimal", 9, 1, 10, 8, 0, 14,
"int", "decimal", 9, 1, 10, 8, 0 ]
-[ 15, "lng", "decimal", 19, 1, 10, 8, 0, 15,
"lng", "decimal", 19, 1, 10, 8, 0 ]
-[ 16, "flt", "real", 24, 2, 2, 9, 0, 16, "flt",
"real", 24, 2, 2, 9, 0 ]
-[ 17, "dbl", "double", 53, 2, 2, 9, 0, 17,
"dbl", "double", 53, 2, 2, 9, 0 ]
-[ 18, "int", "month_interval", 32, 0, 2, 7, 0,
18, "int", "month_interval", 32, 0, 2, 7, 0
]
-[ 19, "lng", "sec_interval", 19, 1, 10, 7, 0, 19,
"lng", "sec_interval", 19, 1, 10, 7, 0 ]
-[ 20, "daytime", "time", 7, 0, 0, 10, 0, 20,
"daytime", "time", 7, 0, 0, 10, 0 ]
-[ 21, "daytime", "timetz", 7, 1, 0, 10, 0,
21, "daytime", "timetz", 7, 1, 0, 10, 0
]
-[ 22, "date", "date", 0, 0, 0, 11, 0, 22, "date",
"date", 0, 0, 0, 11, 0 ]
-[ 23, "timestamp", "timestamp", 7, 0, 0, 12, 0,
23, "timestamp", "timestamp", 7, 0, 0, 12, 0
]
-[ 24, "timestamp", "timestamptz", 7, 1, 0, 12, 0,
24, "timestamp", "timestamptz", 7, 1, 0, 12, 0
]
-[ 25, "sqlblob", "blob", 0, 0, 0, 5, 0, 25,
"sqlblob", "blob", 0, 0, 0, 5, 0 ]
+[ 2, "ptr", "ptr", 0, 0, 0, 1, 0, 2, "ptr",
"ptr", 0, 0, 0, 1, 0 ]
+[ 3, "bit", "boolean", 1, 0, 2, 2, 0, 3,
"bit", "boolean", 1, 0, 2, 2, 0 ]
+[ 4, "str", "char", 0, 0, 0, 3, 0, 4, "str",
"char", 0, 0, 0, 3, 0 ]
+[ 5, "str", "varchar", 0, 0, 0, 4, 0, 5,
"str", "varchar", 0, 0, 0, 4, 0 ]
+[ 6, "str", "clob", 0, 0, 0, 4, 0, 6, "str",
"clob", 0, 0, 0, 4, 0 ]
+[ 7, "bte", "tinyint", 8, 1, 2, 6, 0, 7,
"bte", "tinyint", 8, 1, 2, 6, 0 ]
+[ 8, "sht", "smallint", 16, 1, 2, 6, 0, 8,
"sht", "smallint", 16, 1, 2, 6, 0 ]
+[ 9, "oid", "oid", 31, 0, 2, 6, 0, 9, "oid",
"oid", 31, 0, 2, 6, 0 ]
+[ 10, "int", "int", 32, 1, 2, 6, 0, 10, "int",
"int", 32, 1, 2, 6, 0 ]
+[ 11, "wrd", "wrd", 32, 1, 2, 6, 0, 11, "wrd",
"wrd", 32, 1, 2, 6, 0 ]
+[ 12, "lng", "bigint", 64, 1, 2, 6, 0, 12,
"lng", "bigint", 64, 1, 2, 6, 0 ]
+[ 13, "bte", "decimal", 2, 1, 10, 8, 0, 13,
"bte", "decimal", 2, 1, 10, 8, 0 ]
+[ 14, "sht", "decimal", 4, 1, 10, 8, 0, 14,
"sht", "decimal", 4, 1, 10, 8, 0 ]
+[ 15, "int", "decimal", 9, 1, 10, 8, 0, 15,
"int", "decimal", 9, 1, 10, 8, 0 ]
+[ 16, "lng", "decimal", 19, 1, 10, 8, 0, 16,
"lng", "decimal", 19, 1, 10, 8, 0 ]
+[ 17, "flt", "real", 24, 2, 2, 9, 0, 17, "flt",
"real", 24, 2, 2, 9, 0 ]
+[ 18, "dbl", "double", 53, 2, 2, 9, 0, 18,
"dbl", "double", 53, 2, 2, 9, 0 ]
+[ 19, "int", "month_interval", 32, 0, 2, 7, 0,
19, "int", "month_interval", 32, 0, 2, 7, 0
]
+[ 20, "lng", "sec_interval", 19, 1, 10, 7, 0, 20,
"lng", "sec_interval", 19, 1, 10, 7, 0 ]
+[ 21, "daytime", "time", 7, 0, 0, 10, 0, 21,
"daytime", "time", 7, 0, 0, 10, 0 ]
+[ 22, "daytime", "timetz", 7, 1, 0, 10, 0,
22, "daytime", "timetz", 7, 1, 0, 10, 0
]
+[ 23, "date", "date", 0, 0, 0, 11, 0, 23, "date",
"date", 0, 0, 0, 11, 0 ]
+[ 24, "timestamp", "timestamp", 7, 0, 0, 12, 0,
24, "timestamp", "timestamp", 7, 0, 0, 12, 0
]
+[ 25, "timestamp", "timestamptz", 7, 1, 0, 12, 0,
25, "timestamp", "timestamptz", 7, 1, 0, 12, 0
]
+[ 26, "sqlblob", "blob", 0, 0, 0, 5, 0, 26,
"sqlblob", "blob", 0, 0, 0, 5, 0 ]
-# 22:07:50 >
-# 22:07:50 > Done.
-# 22:07:50 >
+# 09:28:31 >
+# 09:28:31 > Done.
+# 09:28:31 >
------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
