Changeset: 336fadab45ac for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=336fadab45ac
Modified Files:
sql/test/BugTracker-2017/Tests/parsererror.Bug-6381.sql
sql/test/BugTracker-2017/Tests/parsererror.Bug-6381.stable.out
Branch: default
Log Message:
make test independend of object id's
diffs (62 lines):
diff --git a/sql/test/BugTracker-2017/Tests/parsererror.Bug-6381.sql
b/sql/test/BugTracker-2017/Tests/parsererror.Bug-6381.sql
--- a/sql/test/BugTracker-2017/Tests/parsererror.Bug-6381.sql
+++ b/sql/test/BugTracker-2017/Tests/parsererror.Bug-6381.sql
@@ -8,7 +8,7 @@ begin
end while;
return s;
END;
-select * from functions where name ='mycounter1';
+select name, func, "mod", language, "type", side_effect from functions where
name ='mycounter1';
-- This semantic identical function is not recognized
create function mycounter2()
@@ -21,7 +21,7 @@ begin
end while;
return s;
END;
-select * from functions where name ='mycounter2';
+select name, func, "mod", language, "type", side_effect from functions where
name ='mycounter2';
drop function mycounter1;
drop function mycounter2;
diff --git a/sql/test/BugTracker-2017/Tests/parsererror.Bug-6381.stable.out
b/sql/test/BugTracker-2017/Tests/parsererror.Bug-6381.stable.out
--- a/sql/test/BugTracker-2017/Tests/parsererror.Bug-6381.stable.out
+++ b/sql/test/BugTracker-2017/Tests/parsererror.Bug-6381.stable.out
@@ -34,12 +34,12 @@ Ready.
# end while;
# return s;
#END;
-#select * from functions where name ='mycounter1';
-% sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions # table_name
-% id, name, func, mod, language, type, side_effect, varres,
vararg, schema_id # name
-% int, varchar, varchar, varchar, int, int,
boolean, boolean, boolean, int # type
-% 4, 10, 123, 4, 1, 1, 5, 5, 5, 4 #
length
-[ 9027, "mycounter1", "create function mycounter1()\nreturns
integer\nbegin\n declare s int;\n while (true)\n do\n set s =1;\n end while;\n
return s;\nend;", "user", 2, 1, false, false, false, 2000 ]
+#select name, func, "mod", language, "type", side_effect from functions where
name ='mycounter1';
+% sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions # table_name
+% name, func, mod, language, type, side_effect # name
+% varchar, varchar, varchar, int, int, boolean # type
+% 10, 123, 4, 1, 1, 5 # length
+[ "mycounter1", "create function mycounter1()\nreturns integer\nbegin\n
declare s int;\n while (true)\n do\n set s =1;\n end while;\n return s;\nend;",
"user", 2, 1, false ]
#create function mycounter2()
#returns integer
#begin
@@ -50,12 +50,12 @@ Ready.
# end while;
# return s;
#END;
-#select * from functions where name ='mycounter2';
-% sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions # table_name
-% id, name, func, mod, language, type, side_effect, varres,
vararg, schema_id # name
-% int, varchar, varchar, varchar, int, int,
boolean, boolean, boolean, int # type
-% 4, 10, 130, 4, 1, 1, 5, 5, 5, 4 #
length
-[ 9030, "mycounter2", "create function mycounter2()\nreturns
integer\nbegin\n declare s int;\n while (select true)\n do\n set s =1;\n end
while;\n return s;\nend;", "user", 2, 1, false, false, false,
2000 ]
+#select name, func, "mod", language, "type", side_effect from functions where
name ='mycounter2';
+% sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions # table_name
+% name, func, mod, language, type, side_effect # name
+% varchar, varchar, varchar, int, int, boolean # type
+% 10, 130, 4, 1, 1, 5 # length
+[ "mycounter2", "create function mycounter2()\nreturns integer\nbegin\n
declare s int;\n while (select true)\n do\n set s =1;\n end while;\n return
s;\nend;", "user", 2, 1, false ]
#drop function mycounter1;
#drop function mycounter2;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
