Changeset: 052ca06a2133 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=052ca06a2133
Modified Files:
Branch: default
Log Message:
Merge.
diffs (truncated from 461 to 300 lines):
diff -r 91ed80c2af53 -r 052ca06a2133
sql/src/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851.stable.err
---
a/sql/src/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851.stable.err
Wed Jul 14 15:33:50 2010 +0200
+++
b/sql/src/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851.stable.err
Wed Jul 14 15:34:11 2010 +0200
@@ -11,46 +11,7 @@
# 15:55:37 >
-# 13:42:19 > sql
+# 15:55:38 >
+# 15:55:38 > Done.
+# 15:55:38 >
-
-# 13:42:20 > sql
-
-MAPI = mone...@eir:36604
-QUERY = INSERT INTO "foreign" VALUES(1, 1, 1, 1);
-
-MAPI = mone...@eir:36604
-QUERY = INSERT INTO "foreign" VALUES(2, 2, 2, 2);
-
-MAPI = mone...@eir:36604
-QUERY = INSERT INTO "foreign" VALUES(3, 1, 2, 2);
-
-MAPI = mone...@eir:36604
-QUERY = INSERT INTO "foreign" VALUES(4, 2, 2, 1);
-
-MAPI = mone...@eir:36604
-QUERY = INSERT INTO "foreign" VALUES(5, 2, 1, 1);
-
-MAPI = mone...@eir:36604
-QUERY = INSERT INTO "foreign" VALUES(6, 1, 2, 1);
-
-MAPI = mone...@eir:36604
-QUERY = INSERT INTO "foreign" VALUES(7, 1, 1, 2);
-
-MAPI = mone...@eir:36604
-QUERY = SELECT * FROM allnewtriples;
-
-MAPI = mone...@eir:36604
-QUERY = SELECT * FROM "foreign";
-
-MAPI = mone...@eir:36604
-QUERY = COMMIT;
-
-
-# 13:42:20 > sqldump
-
-
-# 13:42:20 >
-# 13:42:20 > Done.
-# 13:42:20 >
-
diff -r 91ed80c2af53 -r 052ca06a2133
sql/src/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851.stable.out
---
a/sql/src/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851.stable.out
Wed Jul 14 15:33:50 2010 +0200
+++
b/sql/src/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851.stable.out
Wed Jul 14 15:34:11 2010 +0200
@@ -31,210 +31,42 @@
[ 1 ]
[ 1 ]
[ 1 ]
-#msqldump tables Wed Jul 14 13:42:20 2010
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+% sys.allnewtriples, sys.allnewtriples, sys.allnewtriples,
sys.allnewtriples, sys.allnewtriples # table_name
+% id, subject, predicate, object, explicit # name
+% int, int, int, int, boolean # type
+% 1, 1, 1, 1, 5 # length
+[ 1, 1, 1, 1, false ]
+[ 2, 1, 1, 2, false ]
+[ 3, 1, 2, 1, false ]
+[ 4, 2, 1, 1, false ]
+[ 5, 1, 2, 2, false ]
+[ 6, 2, 2, 1, false ]
+[ 7, 2, 2, 2, false ]
+% sys.foreign, sys.foreign, sys.foreign, sys.foreign # table_name
+% id, subject, predicate, object # name
+% int, int, int, int # type
+% 1, 1, 1, 1 # length
+[ 1, 1, 1, 1 ]
+[ 2, 2, 2, 2 ]
+[ 3, 1, 2, 2 ]
+[ 4, 2, 2, 1 ]
+[ 5, 2, 1, 1 ]
+[ 6, 1, 2, 1 ]
+[ 7, 1, 1, 2 ]
+
+# 14:58:14 >
+# 14:58:14 > Mtimeout -timeout 60 msqldump -umonetdb -Pmonetdb
--host=localhost --port=33326
+# 14:58:14 >
START TRANSACTION;
-CREATE SEQUENCE "sys"."vaultid" AS INTEGER;
SET SCHEMA "sys";
-create function degrees(r double)
-returns double
- return r*180/pi();
-create function radians(d double)
-returns double
- return d*pi()/180;
-CREATE TABLE "sys"."url_test" (
- "theurl" url,
- "name" CHARACTER LARGE OBJECT
-);
-CREATE TABLE "sys"."queryhistory" (
- "id" bigint NOT NULL,
- "defined" TIMESTAMP,
- "name" CHARACTER LARGE OBJECT,
- "query" CHARACTER LARGE OBJECT,
- "parse" bigint,
- "optimize" bigint,
- CONSTRAINT "queryhistory_id_pkey" PRIMARY KEY ("id")
-);
-CREATE TABLE "sys"."callhistory" (
- "id" bigint,
- "ctime" TIMESTAMP,
- "arguments" CHARACTER LARGE OBJECT,
- "execute" bigint,
- "result" bigint,
- "foot" bigint,
- "memory" bigint,
- "tuples" bigint,
- "inblock" bigint,
- "oublock" bigint
-);
-create view querylog as
-select qd.*, ql.ctime, ql.arguments, ql.exec, ql.result, ql.foot, ql.memory,
ql.tuples, ql.inblock, ql.oublock from queryhistory qd, callhistory ql
-where qd.id = ql.id;
--- the signature is used in the kernel, don't change it
-create procedure keepquery(
- i wrd,
- query string,
- parse bigint,
- optimize bigint)
-begin
- insert into queryhistory
- values(i, now(), user, query, parse, optimize);
-end;
--- the signature is used in the kernel, don't change it
-create procedure keepcall(
- id wrd, -- references query plan
- ctime timestamp, -- time the first statement was executed
- arguments string,
- xtime bigint, -- time from the first statement until result
export
- rtime bigint, -- time to ship the result to the client
- foot bigint, -- footprint for all bats in the plan
- memory bigint, -- storage size of intermediates created
- tuples wrd, -- number of tuples in the result set
- inblock bigint, -- number of physical blocks read
- oublock bigint -- number of physical blocks written
-)
-begin
- insert into callhistory
- values( id, ctime, arguments, xtime, rtime,
- foot, memory, tuples, inblock, oublock );
-end;
-create procedure resethistory()
-begin
- delete from callhistory;
- delete from queryhistory;
-end;
--- The contents of this file are subject to the MonetDB Public License
--- Version 1.1 (the "License"); you may not use this file except in
--- compliance with the License. You may obtain a copy of the License at
--- http://monetdb.cwi.nl/Legal/MonetDBLicense-1.1.html
---
--- Software distributed under the License is distributed on an "AS IS"
--- basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
--- License for the specific language governing rights and limitations
--- under the License.
---
--- The Original Code is the MonetDB Database System.
---
--- The Initial Developer of the Original Code is CWI.
--- Copyright August 2008-2010 MonetDB B.V.
--- All Rights Reserved.
-
---Schema s has a dependency on user u
-create function dependencies_schemas_on_users()
-returns table (sch varchar(100), usr varchar(100), dep_type varchar(32))
-return table (select s.name, u.name, 'DEP_USER' from schemas as s, users u
where u.default_schema = s.id);
---User (owner) has a dependency in schema s
-create function dependencies_owners_on_schemas()
-returns table (sch varchar(100), usr varchar(100), dep_type varchar(32))
-return table (select a.name, s.name, 'DEP_SCHEMA' from schemas as s, auths a
where s.owner = a.id);
---Table t has a dependency on view v
-create function dependencies_tables_on_views()
-returns table (sch varchar(100), usr varchar(100), dep_type varchar(32))
-return table (select t.name, v.name, 'DEP_VIEW' from tables as t, tables as v,
dependencies as dep where t.id = dep.id and v.id = dep.depend_id and
dep.depend_type = 5 and v.type = 1);
---Table t has a dependency on index i
-create function dependencies_tables_on_indexes()
-returns table (sch varchar(100), usr varchar(100), dep_type varchar(32))
-return table (select t.name, i.name, 'DEP_INDEX' from tables as t, idxs as i
where i.table_id = t.id and i.name not in (select name from keys) and t.type =
0);
---Table t has a dependency on trigger tri
-
-create function dependencies_tables_on_triggers()
-returns table (sch varchar(100), usr varchar(100), dep_type varchar(32))
-return table ((select t.name, tri.name, 'DEP_TRIGGER' from tables as t,
triggers as tri where tri.table_id = t.id) union (select t.name, tri.name,
'DEP_TRIGGER' from triggers tri, tables t, dependencies dep where dep.id = t.id
and dep.depend_id =tri.id and dep.depend_type = 8));
---Table t has a dependency on foreign key k
-create function dependencies_tables_on_foreignkeys()
-returns table (sch varchar(100), usr varchar(100), dep_type varchar(32))
-return table (select t.name, fk.name, 'DEP_FKEY' from tables as t, keys as k,
keys as fk where fk.rkey = k.id and k.table_id = t.id);
---Table t has a dependency on function f
-create function dependencies_tables_on_functions()
-returns table (sch varchar(100), usr varchar(100), dep_type varchar(32))
-return table (select t.name, f.name, 'DEP_FUNC' from functions as f, tables as
t, dependencies as dep where t.id = dep.id and f.id = dep.depend_id and
dep.depend_type = 7 and t.type = 0);
---Column c has a dependency on view v
-create function dependencies_columns_on_views()
-returns table (sch varchar(100), usr varchar(100), dep_type varchar(32))
-return table (select c.name, v.name, 'DEP_VIEW' from columns as c, tables as
v, dependencies as dep where c.id = dep.id and v.id = dep.depend_id and
dep.depend_type = 5 and v.type = 1);
---Column c has a dependency on key k
-create function dependencies_columns_on_keys()
-returns table (sch varchar(100), usr varchar(100), dep_type varchar(32))
-return table (select c.name, k.name, 'DEP_KEY' from columns as c, keycolumns
as kc, keys as k where kc."column" = c.name and kc.id = k.id and k.table_id =
c.table_id and k.rkey = -1);
---Column c has a dependency on index i
-create function dependencies_columns_on_indexes()
-returns table (sch varchar(100), usr varchar(100), dep_type varchar(32))
-return table (select c.name, i.name, 'DEP_INDEX' from columns as c, keycolumns
as kc, idxs as i where kc."column" = c.name and kc.id = i.id and c.table_id =
i.table_id and i.name not in (select name from keys));
---Column c has a dependency on function f
-create function dependencies_columns_on_functions()
-returns table (sch varchar(100), usr varchar(100), dep_type varchar(32))
-return table (select c.name, f.name, 'DEP_FUNC' from functions as f, columns
as c, dependencies as dep where c.id = dep.id and f.id = dep.depend_id and
dep.depend_type = 7);
---Column c has a dependency on trigger tri
-create function dependencies_columns_on_triggers()
-returns table (sch varchar(100), usr varchar(100), dep_type varchar(32))
-return table (select c.name, tri.name, 'DEP_TRIGGER' from columns as c,
triggers as tri, dependencies as dep where dep.id = c.id and dep.depend_id
=tri.id and dep.depend_type = 8);
---View v has a dependency on function f
-create function dependencies_views_on_functions()
-returns table (sch varchar(100), usr varchar(100), dep_type varchar(32))
-return table (select v.name, f.name, 'DEP_FUNC' from functions as f, tables as
v, dependencies as dep where v.id = dep.id and f.id = dep.depend_id and
dep.depend_type = 7 and v.type = 1);
---View v has a dependency on trigger tri
-create function dependencies_views_on_triggers()
-returns table (sch varchar(100), usr varchar(100), dep_type varchar(32))
-return table (select v.name, tri.name, 'DEP_TRIGGER' from tables as v,
triggers as tri, dependencies as dep where dep.id = v.id and dep.depend_id
=tri.id and dep.depend_type = 8 and v.type = 1);
---Function f1 has a dependency on function f2
-create function dependencies_functions_on_functions()
-returns table (sch varchar(100), usr varchar(100), dep_type varchar(32))
-return table (select f1.name, f2.name, 'DEP_FUNC' from functions as f1,
functions as f2, dependencies as dep where f1.id = dep.id and f2.id =
dep.depend_id and dep.depend_type = 7);
---Function f1 has a dependency on trigger tri
-create function dependencies_functions_os_triggers()
-returns table (sch varchar(100), usr varchar(100), dep_type varchar(32))
-return table (select f.name, tri.name, 'DEP_TRIGGER' from functions as f,
triggers as tri, dependencies as dep where dep.id = f.id and dep.depend_id
=tri.id and dep.depend_type = 8);
---Key k has a dependency on foreign key fk
-create function dependencies_keys_on_foreignkeys()
-returns table (sch varchar(100), usr varchar(100), dep_type varchar(32))
-return table (select k.name, fk.name, 'DEP_FKEY' from keys as k, keys as fk
where fk.rkey = k.id);
--- Scientific database section
--- The contents of this file are subject to the MonetDB Public License
--- Version 1.1 (the "License"); you may not use this file except in
--- compliance with the License. You may obtain a copy of the License at
--- http://monetdb.cwi.nl/Legal/MonetDBLicense-1.1.html
---
--- Software distributed under the License is distributed on an "AS IS"
--- basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
--- License for the specific language governing rights and limitations
--- under the License.
---
--- The Original Code is the MonetDB Database System.
---
--- The Initial Developer of the Original Code is CWI.
--- Copyright August 2008-2010 MonetDB B.V.
--- All Rights Reserved.
-
-create function ms_stuff( s1 varchar(32), st int, len int, s3 varchar(32))
-returns varchar(32)
-begin
- declare res varchar(32), aux varchar(32);
- declare ofset int;
- set ofset = 0;
- set res = substring(s1,ofset,st-1);
- set res = res || s3;
- set ofset = length(s1)-len;
- set aux = substring(s1,ofset, len);
- set res = res || aux;
- return res;
-end;
-create function ms_round(num float, precision int, truncat int)
-returns float
-begin
- if (truncat = 0)
- then return round(num, precision);
- else return round(floor(num), precision);
- end if;
-end;
-CREATE TABLE "sys"."vault" (
- "vid" int NOT NULL DEFAULT next value for
"sys"."vaultid",
- "kind" CHARACTER LARGE OBJECT,
- "source" CHARACTER LARGE OBJECT,
- "target" CHARACTER LARGE OBJECT,
- "refresh" boolean,
- "cached" TIMESTAMP,
- CONSTRAINT "vault_vid_pkey" PRIMARY KEY ("vid")
-);
CREATE TABLE "sys"."allnewtriples" (
"id" int NOT NULL,
"subject" int NOT NULL,
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
