Changeset: 7fc2df61326d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7fc2df61326d
Modified Files:
sql/test/BugTracker-2010/Tests/store_function_argument_correctly.Bug-2750.stable.out
Branch: mtest
Log Message:
Updated the stable.out due to changeset a65cda0153f3
diffs (58 lines):
diff --git
a/sql/test/BugTracker-2010/Tests/store_function_argument_correctly.Bug-2750.stable.out
b/sql/test/BugTracker-2010/Tests/store_function_argument_correctly.Bug-2750.stable.out
---
a/sql/test/BugTracker-2010/Tests/store_function_argument_correctly.Bug-2750.stable.out
+++
b/sql/test/BugTracker-2010/Tests/store_function_argument_correctly.Bug-2750.stable.out
@@ -30,9 +30,50 @@ stdout of test 'store_function_argument_
% 1, 6, 7, 2 # length
[ "f", "result", "varchar", 10 ]
[ "f", "x", "varchar", 20 ]
-#drop function f;
+#CREATE TABLE branches (
+# bid int NOT NULL default '0',
+# cid tinyint NOT NULL default '0',
+# bdesc varchar(255) NOT NULL default '',
+# bloc char(3) NOT NULL default '');
+#INSERT INTO branches (bid, cid, bdesc, bloc) VALUES
+# (1011, 101, 'Corporate HQ', 'CA'),
+# (1012, 101, 'Accounting Department', 'NY'),
+# (1013, 101, 'Customer Grievances Department', 'KA'),
+# (1041, 104, 'Branch Office (East)', 'MA'),
+# (1042, 104, 'Branch Office (West)', 'CA'),
+# (1101, 110, 'Head Office', 'CA'),
+# (1031, 103, 'N Region HO', 'ME'),
+# (1032, 103, 'NE Region HO', 'CT'),
+# (1033, 103, 'NW Region HO', 'NY');
+[ 9 ]
+#CREATE TABLE clients (
+# cid tinyint NOT NULL default '0',
+# cname varchar(255) NOT NULL default '',
+# PRIMARY KEY (cid));
+#INSERT INTO clients (cid, cname) VALUES
+# (101, 'JV Real Estate'),
+# (102, 'ABC Talent Agency'),
+# (103, 'DMW Trading'),
+# (104, 'Rabbit Foods Inc'),
+# (110, 'Sharp Eyes Detective Agency');
+[ 5 ]
+#CREATE function client_id(cn VARCHAR (100)) RETURNS INT BEGIN RETURN SELECT
cid FROM clients c WHERE cname = cn; END;
+#SELECT client_id('Rabbit Foods Inc');
+% .%4 # table_name
+% %4 # name
+% int # type
+% 3 # length
+[ 104 ]
+#SELECT * from branches b where b.cid = client_id('Rabbit Foods Inc');
+% sys.b, sys.b, sys.b, sys.b # table_name
+% bid, cid, bdesc, bloc # name
+% int, tinyint, varchar, char # type
+% 4, 3, 20, 3 # length
+[ 1041, 104, "Branch Office (East)", "MA" ]
+[ 1042, 104, "Branch Office (West)", "CA" ]
+#ROLLBACK;
-# 19:53:00 >
-# 19:53:00 > Done.
-# 19:53:00 >
+# 14:37:59 >
+# 14:37:59 > "Done."
+# 14:37:59 >
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
