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?
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
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
>
>
--
| Dr. Stefan Manegold | mailto:[EMAIL PROTECTED] |
| CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ |
| 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 |
| The Netherlands | Fax : +31 (20) 592-4312 |
-------------------------------------------------------------------------
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-developers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-developers