valentina, error with DISCTINCT

[Christian - ChrisKatDev.com]

Le 7 avr. 09 à 14:35, Ruslan Zasukhin a écrit :

> On 4/7/09 2:55 PM, "Christian - ChrisKatDev.com" <christian at chriskatdev.com 
> >
> wrote:
>
>>> First of call can you download latest Vstudio
>>>   http://www.valentina-db.com/download/beta/
>>
>> no, verion 4 have a big problem when you dump database (xml or sql) :
>> you dont have "return" in file
>> this xml (or sql) are impossible to read !!
>> I continue with 3.6
>
> This present in Mantis?

no, sorry Ruslan, each day have 30 hours, horrible !!
... it's difficult in this time ;-)
>
> Christian, note I have told about latest 4.1 betas.
>
> Ivan you have hear about such bug?
>
>
> Also, Christian, you do not need dump wit 4.x
> You need only check this DISTINT query.
>
>
> Or just report issue to Mantis with db that reproduce.
>
>
>>> And check this query against your db?
>>
>> after several tests, it's appear that after make field indexed and
>> reindex all database ad field, it's ok now...
>> ???
>> distinct dont work with no indexed field ?
>
> No of course. Because it needs collect unique keys.
>
> But even if field was not indexed, engine self should care.
> Ivan please check this point.
>
>
> -- 
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina