Update of /cvsroot/monetdb/sql/src/test/Connections
In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv25122
Modified Files:
connections_default_values.sql connections_semantic.sql
connections_syntax.sql
Log Message:
Some improvements for the test.
Index: connections_semantic.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Connections/connections_semantic.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- connections_semantic.sql 24 Jan 2007 16:11:32 -0000 1.2
+++ connections_semantic.sql 22 Mar 2007 13:11:07 -0000 1.3
@@ -1,16 +1,16 @@
connect to 'localhost' port port_num database
'mTests_src_test_Connections_test1' as 'test_db' user 'monetdb' password
'monetdb' language 'sql';
-select * from connections;
+select server, db, db_alias, language from connections;
disconnect 'test_db';
-select * from connections;
+select server, db, db_alias, language from connections;
connect to 'localhost' port port_num database
'mTests_src_test_Connections_test1' as 'test_db' user 'monetdb' password
'monetdb' language 'sql';
connect to 'localhost' port port_num5 database
'mTests_src_test_Connections_test1' as 'test_db' user 'monetdb' password
'monetdb' language 'sql';
connect to 'localhost' port port_num database
'mTests_src_test_Connections_test1' as 'test' user 'monetdb' password 'monetdb'
language 'sql';
connect to 'localhost' port 4000 database 'dmo' as 'test_db' user 'monetdb'
password 'monetdb' language 'sql';
-select * from connections;
+select server, db, db_alias, language from connections;
disconnect 'test_db';
disconnect 'test_db';
connect to 'localhost' port port_num database
'mTests_src_test_Connections_test1' as 'test_db' user 'monetdb' password
'monetdb' language 'sql';
-select * from connections;
+select server, db, db_alias, language from connections;
disconnect ALL;
-select * from connections;
+select server, db, db_alias, language from connections;
disconnect 'test_tb';
Index: connections_default_values.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/Connections/connections_default_values.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- connections_default_values.sql 24 Jan 2007 16:11:32 -0000 1.2
+++ connections_default_values.sql 22 Mar 2007 13:11:07 -0000 1.3
@@ -1,9 +1,9 @@
-connect to 'localhost' database 'mTests_src_test_Connections_test1';
-select * from connections;
-disconnect 'localhost:port_num_mTests_src_test_Connections_test1';
+connect to 'localhost' port port_num database
'mTests_src_test_Connections_test1' user 'monetdb' password 'monetdb';
+select server, db, db_alias, language from connections;
+disconnect 'localhost_mTests_src_test_Connections_test1_monetdb';
connect to 'localhost' port port_num database
'mTests_src_test_Connections_test1' as 'test_db' user 'monetdb' password
'monetdb' language 'sql';
-connect to 'localhost' port port_num5 database
'mTests_src_test_Connections_test1' as 'test_db1' user 'monetdb' password
'monetdb' language 'sql';
-connect to 'localhost' port port_num database
'mTests_src_test_Connections_test1' as
'localhost:port_num_mTests_src_test_Connections_test1' user 'monetdb' password
'monetdb' language 'sql';
-connect to 'localhost' port port_num6 database
'mTests_src_test_Connections_test1';
-select * from connections;
+disconnect ALL;
+connect to 'localhost' port port_num database
'mTests_src_test_Connections_test1' as
'localhost_mTests_src_test_Connections_test1_monetdb' user 'monetdb' password
'monetdb' language 'sql';
+disconnect 'localhost_mTests_src_test_Connections_test1_monetdb';
+select server, db, db_alias, language from connections;
disconnect ALL;
Index: connections_syntax.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Connections/connections_syntax.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- connections_syntax.sql 24 Jan 2007 16:11:32 -0000 1.2
+++ connections_syntax.sql 22 Mar 2007 13:11:09 -0000 1.3
@@ -1,7 +1,7 @@
connect to 'localhost' port port_num database
'mTests_src_test_Connections_test1' as 'test_db_1' user 'monetdb' password
'monetdb' language 'sql';
disconnect ALL;
connect to 'localhost' port 34 database 'mTests_src_test_Connections_test1' as
'test_db_1' user 'monetdb' password 'monetdb' language 'sql';
-select * from connections;
+select server, db, db_alias, language from connections;
disconnect ALL;
connect to 'localhost' port port_num database
'mTests_src_test_Connections_test1' user 'monetdb' password 'monetdb' language
'sql';
disconnect ALL;
@@ -10,14 +10,14 @@
connect to 'localhost' port port_num database
'mTests_src_test_Connections_test1' as 'test_db_1' user 'monetdb' password
'monetdb';
disconnect ALL;
connect to 'localhost' database 'mTests_src_test_Connections_test1';
-select * from connections;
+select server, db, db_alias, language from connections;
disconnect ALL;
connect 'localhost' port port_num database 'mTests_src_test_Connections_test1'
as 'test_db_1' user 'monetdb' password 'monetdb' language 'sql';
-select * from connections;
+select server, db, db_alias, language from connections;
disconnect ALL;
connect to 'localhost' port port_num as 'test_db_1' user 'monetdb' password
'monetdb' language 'sql';
-select * from connections;
+select server, db, db_alias, language from connections;
disconnect ALL;
connect to 'localhost' port port_num database
'mTests_src_test_Connections_test1' as 'test_db' user 'monetdb' language 'sql';
-select * from connections;
-disconnect 'test_db';
+select server, db, db_alias, language from connections;
+disconnect 'test_db_1';
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
