Changeset: 7852bf0c9a3c for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7852bf0c9a3c
Added Files:
sql/test/pg_regress/Tests/plpgsql.stable.err
sql/test/pg_regress/Tests/plpgsql.stable.out
Branch: default
Log Message:
adding 2 new output files
diffs (truncated from 2188 to 300 lines):
diff --git a/sql/test/pg_regress/Tests/plpgsql.stable.err
b/sql/test/pg_regress/Tests/plpgsql.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/test/pg_regress/Tests/plpgsql.stable.err
@@ -0,0 +1,1508 @@
+stderr of test 'plpgsql` in directory 'sql/test/pg_regress` itself:
+
+
+# 18:00:05 >
+# 18:00:05 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=37199" "--set"
"mapi_usock=/var/tmp/mtest-11277/.s.monetdb.37199" "--set" "monet_prompt="
"--forcemito" "--set" "mal_listing=2"
"--dbpath=/ufs/dinther/INSTALL/var/MonetDB/mTests_sql_test_pg_regress" "--set"
"mal_listing=0"
+# 18:00:05 >
+
+# builtin opt gdk_dbpath = /ufs/dinther/INSTALL/var/monetdb5/dbfarm/demo
+# builtin opt gdk_debug = 0
+# builtin opt gdk_vmtrim = no
+# builtin opt monet_prompt = >
+# builtin opt monet_daemon = no
+# builtin opt mapi_port = 50000
+# builtin opt mapi_open = false
+# builtin opt mapi_autosense = false
+# builtin opt sql_optimizer = default_pipe
+# builtin opt sql_debug = 0
+# cmdline opt gdk_nr_threads = 0
+# cmdline opt mapi_open = true
+# cmdline opt mapi_port = 37199
+# cmdline opt mapi_usock = /var/tmp/mtest-11277/.s.monetdb.37199
+# cmdline opt monet_prompt =
+# cmdline opt mal_listing = 2
+# cmdline opt gdk_dbpath =
/ufs/dinther/INSTALL/var/MonetDB/mTests_sql_test_pg_regress
+# cmdline opt mal_listing = 0
+# cmdline opt gdk_debug = 536870922
+
+# 18:00:05 >
+# 18:00:05 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-11277" "--port=37199"
+# 18:00:05 >
+
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create unique index Room_rno on Room using btree (roomno bpchar_ops);
+ERROR = !syntax error, unexpected USING, expecting '(' in: "create unique
index room_rno on room using"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create unique index WSlot_name on WSlot using btree (slotname
bpchar_ops);
+ERROR = !syntax error, unexpected USING, expecting '(' in: "create unique
index wslot_name on wslot using"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create unique index PField_name on PField using btree (name text_ops);
+ERROR = !syntax error, unexpected USING, expecting '(' in: "create unique
index pfield_name on pfield using"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create unique index PSlot_name on PSlot using btree (slotname
bpchar_ops);
+ERROR = !syntax error, unexpected USING, expecting '(' in: "create unique
index pslot_name on pslot using"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create unique index PLine_name on PLine using btree (slotname
bpchar_ops);
+ERROR = !syntax error, unexpected USING, expecting '(' in: "create unique
index pline_name on pline using"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create unique index Hub_name on Hub using btree (name bpchar_ops);
+ERROR = !syntax error, unexpected USING, expecting '(' in: "create unique
index hub_name on hub using"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create unique index HSlot_name on HSlot using btree (slotname
bpchar_ops);
+ERROR = !syntax error, unexpected USING, expecting '(' in: "create unique
index hslot_name on hslot using"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create index HSlot_hubname on HSlot using btree (hubname bpchar_ops);
+ERROR = !syntax error, unexpected USING, expecting '(' in: "create index
hslot_hubname on hslot using"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create unique index System_name on System using btree (name text_ops);
+ERROR = !syntax error, unexpected USING, expecting '(' in: "create unique
index system_name on system using"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create unique index IFace_name on IFace using btree (slotname
bpchar_ops);
+ERROR = !syntax error, unexpected USING, expecting '(' in: "create unique
index iface_name on iface using"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create unique index PHone_name on PHone using btree (slotname
bpchar_ops);
+ERROR = !syntax error, unexpected USING, expecting '(' in: "create unique
index phone_name on phone using"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create function tg_room_au() returns trigger as '
+ begin
+ if new.roomno != old.roomno then
+ update WSlot set roomno = new.roomno where roomno = old.roomno;
+ end if;
+ return new;
+ COMMIT;
+ ' language 'plpgsql';
+ERROR = !syntax error, unexpected TRIGGER in: "create function tg_room_au()
returns trigger"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create trigger tg_room_au after update
+ on Room for each row execute procedure tg_room_au();
+ERROR = !syntax error, unexpected PROCEDURE, expecting ':' in: "create trigger
tg_room_au after update
+ ! on room for each row execute procedure"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create function tg_room_ad() returns trigger as '
+ begin
+ delete from WSlot where roomno = old.roomno;
+ return old;
+ COMMIT;
+ ' language 'plpgsql';
+ERROR = !syntax error, unexpected TRIGGER in: "create function tg_room_ad()
returns trigger"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create trigger tg_room_ad after delete
+ on Room for each row execute procedure tg_room_ad();
+ERROR = !syntax error, unexpected PROCEDURE, expecting ':' in: "create trigger
tg_room_ad after delete
+ ! on room for each row execute procedure"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create function tg_wslot_biu() returns trigger as $$
+ begin
+ if count(*) = 0 from Room where roomno = new.roomno then
+ raise exception 'Room % does not exist', new.roomno;
+ERROR = !syntax error, unexpected TRIGGER in: "create function tg_wslot_biu()
returns trigger"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = end if;
+ERROR = !syntax error, unexpected END in: "end"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = return new;
+ERROR = !syntax error, unexpected RETURN in: "return"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = COMMIT;
+ERROR = !COMMIT: not allowed in auto commit mode
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = $$ language plpgsql;
+ERROR = !unexpected symbol ($)
+ !unexpected symbol ($)
+ !syntax error, unexpected LANGUAGE in: "language"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create trigger tg_wslot_biu before insert or update
+ on WSlot for each row execute procedure tg_wslot_biu();
+ERROR = !syntax error, unexpected OR, expecting ON in: "create trigger
tg_wslot_biu before insert or"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create function tg_pfield_au() returns trigger as '
+ begin
+ if new.name != old.name then
+ update PSlot set pfname = new.name where pfname = old.name;
+ end if;
+ return new;
+ COMMIT;
+ ' language 'plpgsql';
+ERROR = !syntax error, unexpected TRIGGER in: "create function tg_pfield_au()
returns trigger"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create trigger tg_pfield_au after update
+ on PField for each row execute procedure tg_pfield_au();
+ERROR = !syntax error, unexpected PROCEDURE, expecting ':' in: "create trigger
tg_pfield_au after update
+ ! on pfield for each row execute procedure"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create function tg_pfield_ad() returns trigger as '
+ begin
+ delete from PSlot where pfname = old.name;
+ return old;
+ COMMIT;
+ ' language 'plpgsql';
+ERROR = !syntax error, unexpected TRIGGER in: "create function tg_pfield_ad()
returns trigger"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create trigger tg_pfield_ad after delete
+ on PField for each row execute procedure tg_pfield_ad();
+ERROR = !syntax error, unexpected PROCEDURE, expecting ':' in: "create trigger
tg_pfield_ad after delete
+ ! on pfield for each row execute procedure"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create function tg_pslot_biu() returns trigger as $proc$
+ declare
+ pfrec record;
+ERROR = !syntax error, unexpected TRIGGER in: "create function tg_pslot_biu()
returns trigger"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = rename new to ps;
+ERROR = !syntax error, unexpected RENAME in: "rename"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = begin
+ select into pfrec * from PField where name = ps.pfname;
+ERROR = !syntax error, unexpected BEGIN in: "begin"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = if not found then
+ raise exception $$Patchfield "%" does not exist$$, ps.pfname;
+ERROR = !syntax error, unexpected IF in: "if"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = end if;
+ERROR = !syntax error, unexpected END in: "end"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = return ps;
+ERROR = !syntax error, unexpected RETURN in: "return"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = COMMIT;
+ERROR = !COMMIT: not allowed in auto commit mode
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = $proc$ language plpgsql;
+ERROR = !unexpected symbol ($)
+ !syntax error, unexpected IDENT in: "proc"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create trigger tg_pslot_biu before insert or update
+ on PSlot for each row execute procedure tg_pslot_biu();
+ERROR = !syntax error, unexpected OR, expecting ON in: "create trigger
tg_pslot_biu before insert or"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create function tg_system_au() returns trigger as '
+ begin
+ if new.name != old.name then
+ update IFace set sysname = new.name where sysname = old.name;
+ end if;
+ return new;
+ COMMIT;
+ ' language 'plpgsql';
+ERROR = !syntax error, unexpected TRIGGER in: "create function tg_system_au()
returns trigger"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create trigger tg_system_au after update
+ on System for each row execute procedure tg_system_au();
+ERROR = !syntax error, unexpected PROCEDURE, expecting ':' in: "create trigger
tg_system_au after update
+ ! on system for each row execute procedure"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create function tg_iface_biu() returns trigger as $$
+ declare
+ sname text;
+ERROR = !syntax error, unexpected TRIGGER in: "create function tg_iface_biu()
returns trigger"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = sysrec record;
+ERROR = !syntax error, unexpected IDENT in: "sysrec"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = begin
+ select into sysrec * from system where name = new.sysname;
+ERROR = !syntax error, unexpected BEGIN in: "begin"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = if not found then
+ raise exception $q$system "%" does not exist$q$, new.sysname;
+ERROR = !syntax error, unexpected IF in: "if"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = end if;
+ERROR = !syntax error, unexpected END in: "end"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = sname := 'IF.' || new.sysname;
+ERROR = !syntax error, unexpected IDENT in: "sname"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = sname := sname || '.';
+ERROR = !syntax error, unexpected IDENT in: "sname"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = sname := sname || new.ifname;
+ERROR = !syntax error, unexpected IDENT in: "sname"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = if length(sname) > 20 then
+ raise exception 'IFace slotname "%" too long (20 char max)',
sname;
+ERROR = !syntax error, unexpected IF in: "if"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = end if;
+ERROR = !syntax error, unexpected END in: "end"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = new.slotname := sname;
+ERROR = !syntax error, unexpected sqlNEW in: "new"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = return new;
+ERROR = !syntax error, unexpected RETURN in: "return"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = COMMIT;
+ERROR = !COMMIT: not allowed in auto commit mode
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = $$ language plpgsql;
+ERROR = !unexpected symbol ($)
+ !unexpected symbol ($)
+ !syntax error, unexpected LANGUAGE in: "language"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create trigger tg_iface_biu before insert or update
+ on IFace for each row execute procedure tg_iface_biu();
+ERROR = !syntax error, unexpected OR, expecting ON in: "create trigger
tg_iface_biu before insert or"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create function tg_hub_a() returns trigger as '
+ declare
+ hname text;
+ dummy integer;
+ begin
+ if tg_op = ''INSERT'' then
+ dummy := tg_hub_adjustslots(new.string, 0, new.nslots);
+ return new;
+ end if;
+ if tg_op = ''UPDATE'' then
+ if new.name != old.name then
+ update HSlot set hubname = new.name where hubname =
old.name;
+ end if;
+ dummy := tg_hub_adjustslots(new.string, old.nslots, new.nslots);
+ return new;
+ end if;
+ if tg_op = ''DELETE'' then
+ dummy := tg_hub_adjustslots(old.string, old.nslots, 0);
+ERROR = !syntax error, unexpected TRIGGER in: "create function tg_hub_a()
returns trigger"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create trigger tg_hub_a after insert or update or delete
+ on Hub for each row execute procedure tg_hub_a();
+ERROR = !syntax error, unexpected OR, expecting ON in: "create trigger
tg_hub_a after insert or"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create function tg_hub_adjustslots(hname bpchar,
+ERROR = !type (bpchar) unknown in: "create function tg_hub_adjustslots(hname
bpchar,"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = oldnslots integer,
+ newnslots integer)
+ returns integer as '
+ begin
+ if newnslots = oldnslots then
+ return 0;
+ end if;
+ if newnslots < oldnslots then
+ delete from HSlot where hubname = hname and slotno > newnslots;
+ return 0;
+ end if;
+ for i in oldnslots + 1 .. newnslots loop
+ insert into HSlot (slotname, hubname, slotno, slotlink)
+ values (''HS.dummy'', hname, i, '''');
+ end loop;
+ return 0;
+ end
+ ' language 'plpgsql';
+ERROR = !syntax error, unexpected IDENT in: "oldnslots"
+MAPI = (monetdb) /var/tmp/mtest-11277/.s.monetdb.37199
+QUERY = create function tg_hslot_biu() returns trigger as '
+ declare
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
