Update of /cvsroot/monetdb/sql/src/test/Tests
In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv29119/src/test/Tests
Modified Files:
Tag: SQL_2-16
restart-sequence.stable.out
Log Message:
fixes for the following bugs
1) set role while user isn't granted that role succeeded incorrectly
2) role grants were incorrectly stored (cut/paste problem)
3) automatic sequence numbers (AUTO_INCREMENT and SERIAL) were
allways created in the 'sys' schema.
4) the schema part of sequence numbers statements was never used
5) the NEXT VALUE, get_value, restart should use the schema part of
the sequence number
Index: restart-sequence.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/restart-sequence.stable.out,v
retrieving revision 1.7
retrieving revision 1.7.4.1
diff -u -d -r1.7 -r1.7.4.1
--- restart-sequence.stable.out 24 Oct 2006 16:02:57 -0000 1.7
+++ restart-sequence.stable.out 16 Mar 2007 14:54:37 -0000 1.7.4.1
@@ -27,12 +27,12 @@
% 6, 3, 1, 1, 1, 1, 1, 5 # length
[ "mytest", "sys", 1, 0, 0, 1, 1, false ]
% . # table_name
-% next_value_for_mytest # name
+% next_value_for_sys # name
% bigint # type
% 1 # length
[ 1 ]
% . # table_name
-% next_value_for_mytest # name
+% next_value_for_sys # name
% bigint # type
% 1 # length
[ 2 ]
@@ -47,12 +47,12 @@
% 6, 3, 2, 1, 1, 1, 1, 5 # length
[ "mytest", "sys", 10, 0, 0, 1, 1, false ]
% . # table_name
-% next_value_for_mytest # name
+% next_value_for_sys # name
% bigint # type
% 2 # length
[ 10 ]
% . # table_name
-% next_value_for_mytest # name
+% next_value_for_sys # name
% bigint # type
% 2 # length
[ 11 ]
-------------------------------------------------------------------------
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
