Update of /cvsroot/monetdb/sql/src/test/BugDay_2005-12-19_2.9.3/Tests
In directory
sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv29119/src/test/BugDay_2005-12-19_2.9.3/Tests
Modified Files:
Tag: SQL_2-16
default_next_value_for_non_ex_seq.SF.1246631.stable.err
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: default_next_value_for_non_ex_seq.SF.1246631.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-12-19_2.9.3/Tests/default_next_value_for_non_ex_seq.SF.1246631.stable.err,v
retrieving revision 1.2
retrieving revision 1.2.8.1
diff -u -d -r1.2 -r1.2.8.1
--- default_next_value_for_non_ex_seq.SF.1246631.stable.err 4 Mar 2006
16:44:16 -0000 1.2
+++ default_next_value_for_non_ex_seq.SF.1246631.stable.err 16 Mar 2007
14:54:37 -0000 1.2.8.1
@@ -68,16 +68,16 @@
# 13:41:25 > Mtimeout -timeout 60 MapiClient -lsql -u monetdb -P monetdb
--host=localhost --port=40245 <
default_next_value_for_non_ex_seq.SF.1246631.sql
# 13:41:25 >
-MAPI = [EMAIL PROTECTED]:32040
+MAPI = [EMAIL PROTECTED]:32629
QUERY = create table test1246631( i int default next value for non_ex_seq);
-ERROR = !NEXT VALUE FOR: no such sequence 'non_ex_seq'
-MAPI = [EMAIL PROTECTED]:32040
+ERROR = !NEXT VALUE FOR: no such sequence 'sys'.'non_ex_seq'
+MAPI = [EMAIL PROTECTED]:32629
QUERY = insert into test1246631;
ERROR = !INSERT INTO: no such table 'test1246631'
-MAPI = [EMAIL PROTECTED]:32040
+MAPI = [EMAIL PROTECTED]:32629
QUERY = select * from test1246631;
ERROR = !SELECT: no such table 'test1246631'
-MAPI = [EMAIL PROTECTED]:32040
+MAPI = [EMAIL PROTECTED]:32629
QUERY = insert into test1246631;
ERROR = !INSERT INTO: no such table 'test1246631'
-------------------------------------------------------------------------
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
