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

Reply via email to