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
>> [EMAIL PROTECTED]
>> https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
>>
>>
>
-------------------------------------------------------------------------
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
