Changeset: 43581140940f for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=43581140940f
Modified Files:
sql/test/BugTracker-2013/Tests/nestedcalls.sql
sql/test/BugTracker-2013/Tests/nestedcalls.stable.out
Branch: Feb2013
Log Message:
Make test independent of sys.tables.
diffs (68 lines):
diff --git a/sql/test/BugTracker-2013/Tests/nestedcalls.sql
b/sql/test/BugTracker-2013/Tests/nestedcalls.sql
--- a/sql/test/BugTracker-2013/Tests/nestedcalls.sql
+++ b/sql/test/BugTracker-2013/Tests/nestedcalls.sql
@@ -1,7 +1,10 @@
+CREATE TABLE tnc (name VARCHAR(10));
+INSERT INTO tnc VALUES ('test');
+
CREATE FUNCTION bottom()
RETURNS TABLE (name string)
BEGIN
- RETURN select name from tables;
+ RETURN select name from tnc;
END;
CREATE FUNCTION leaf1()
@@ -40,3 +43,4 @@ DROP FUNCTION leaf3;
DROP FUNCTION leaf2;
DROP FUNCTION leaf1;
DROP FUNCTION bottom;
+DROP TABLE tnc;
diff --git a/sql/test/BugTracker-2013/Tests/nestedcalls.stable.out
b/sql/test/BugTracker-2013/Tests/nestedcalls.stable.out
--- a/sql/test/BugTracker-2013/Tests/nestedcalls.stable.out
+++ b/sql/test/BugTracker-2013/Tests/nestedcalls.stable.out
@@ -48,6 +48,9 @@ Ready.
# 09:11:23 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-1158" "--port=37677"
# 09:11:23 >
+#CREATE TABLE tnc (name VARCHAR(10));
+#INSERT INTO tnc VALUES ('test');
+[ 1 ]
#CREATE FUNCTION bottom()
#RETURNS TABLE (name string)
#BEGIN
@@ -81,26 +84,26 @@ Ready.
% .L1 # table_name
% L1 # name
% wrd # type
-% 2 # length
-[ 35 ]
+% 1 # length
+[ 1 ]
#SELECT count(*) FROM leaf1();
% .L1 # table_name
% L1 # name
% wrd # type
-% 2 # length
-[ 29 ]
+% 1 # length
+[ 1 ]
#SELECT count(*) FROM leaf2();
% .L1 # table_name
% L1 # name
% wrd # type
-% 2 # length
-[ 29 ]
+% 1 # length
+[ 1 ]
#SELECT count(*) FROM leaf3();
% .L1 # table_name
% L1 # name
% wrd # type
-% 2 # length
-[ 29 ]
+% 1 # length
+[ 1 ]
#DROP FUNCTION leaf3;
#DROP FUNCTION leaf2;
#DROP FUNCTION leaf1;
_______________________________________________
checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
