Stefan Manegold wrote:

On Mon, Jun 02, 2008 at 03:17:02PM +0000, Romulo Goncalves wrote:

...

Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv8577

Modified Files: Tag: SQL_2-24 authorization.SF-1430616.SQL.bat authorization.SF-1430616.SQL.sh Added Files: Tag: SQL_2-24 authorization.SF-1430616-drop_user.sql Log Message: If you create the user (voc) do not forget to drop it.

This was the reason to break some following tests which were trying to create user voc...

That's indeed the better solution than my renaming user "voc" to "voc2" in the later test. Thanks!

--- I was simply "too lazy" to check all the subsequent test that output some catalog statistics, and hence, might need to have their output approved, too. Did you check that?

That's the next step... ;)

Romulo

Stefan

...

Thanks Stefan for dectecting the problem...

--- NEW FILE: authorization.SF-1430616-drop_user.sql --- START TRANSACTION;

DROP USER "voc"; DROP SCHEMA "voc";

commit;

U authorization.SF-1430616.SQL.sh Index: authorization.SF-1430616.SQL.sh =================================================================== RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/authorization.SF-1430616.SQL.sh,v retrieving revision 1.2 retrieving revision 1.2.4.1 diff -u -d -r1.2 -r1.2.4.1 --- authorization.SF-1430616.SQL.sh 29 Oct 2007 20:11:51 -0000 1.2 +++ authorization.SF-1430616.SQL.sh 2 Jun 2008 15:16:59 -0000 1.2.4.1 @@ -17,4 +17,11 @@

Mlog -x "$MTIMEOUT mjclient -h $HOST -p $MAPIPORT -d ${TSTDB} -q"

+cat << EOF > .monetdb +user=monetdb +password=monetdb +EOF

+Mlog -x "$MTIMEOUT mjclient -h $HOST -p $MAPIPORT -d ${TSTDB} -f "$RELSRCDIR/authorization.SF-1430616-drop_user.sql""

rm -f .monetdb

U authorization.SF-1430616.SQL.bat Index: authorization.SF-1430616.SQL.bat =================================================================== RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/authorization.SF-1430616.SQL.bat,v retrieving revision 1.3 retrieving revision 1.3.4.1 diff -u -d -r1.3 -r1.3.4.1 --- authorization.SF-1430616.SQL.bat 29 Oct 2007 20:11:51 -0000 1.3 +++ authorization.SF-1430616.SQL.bat 2 Jun 2008 15:16:58 -0000 1.3.4.1 @@ -15,4 +15,9 @@

call mjclient -h %HOST% -p %MAPIPORT% -d %TSTDB% -q

+echo user=monetdb> .monetdb +echo password=monetdb>> .monetdb

+call mjclient -h %HOST% -p %MAPIPORT% -d %TSTDB% -f "%RELSRCDIR%\authorization.SF-1430616-drop_user.sql"

@del .monetdb

---

This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Monetdb-sql-checkins mailing list Monetdb-sql-checkins@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins