FW: RE: My 1.0 wish list

[EA Durbin]

>From: Hans Leidekker <hans at it.vu.nl>
>To: wine-devel at winehq.org
>CC: "EA Durbin" <ead1234 at hotmail.com>
>Subject: Re: FW: RE: My 1.0 wish list
>Date: Sun, 4 Jun 2006 09:49:47 +0200
>
>On Sunday 04 June 2006 09:08, EA Durbin wrote:
>
> > I wrote a quick test in wine/dlls/msi/tests/db.c to add a 2nd row to the
>
>Could you share it?
>
> > database that was being created, then I inserted the `id` of 8 into it 
>and
> > then I ran the query SELECT * FROM phone where `id` > 6, and it returned
> > the correct results with `id` of 8. But in the actual wine installer 
>code a
>
>Is the table in db.c comparable? Does it have the same fields and types?
>Also, you're using > in your select but the failing select statement has >=
>which may make a difference.
>
>  -Hans


It shouldnt matter whether its >= or >, they both return the wrong results 
in the actual msi installer and the right results in db.c.

I have enclosed my tests, I tested these against the America's Army database 
installer and I have double checked the actual contents of the msi file in 
ORCA.

I've packaged up some tests and included them with this email.

Here are some queries that have returned the wrong results

SELECT * FROM `Media` WHERE `LastSequence` > 15
SELECT * FROM `File` WHERE `Sequence` > 10

SELECT * FROM `Media` WHERE `LastSequence` >= 15
SELECT * FROM `File` WHERE `Sequence` >= 10

-------------- next part --------------
A non-text attachment was scrubbed...
Name: tests.tar.gz
Type: application/x-gzip
Size: 412032 bytes
Desc: not available
Url : http://www.winehq.org/pipermail/wine-devel/attachments/20060604/0dd0ffae/tests.tar-0001.bin