Test Case

[EA Durbin]

This is as close as I will be able to come to including a test case, as this 
is how I obtained my results.

Here is my code, and the resulting logs.

Here are some patches I used, just a quick hack of the existing wine code, 
to run a query and iterate through the results. As you'll see in the 
enclosed results, this query is returning the results of Sequence <  8 even 
though the query called for Sequence >= 8.

trace:msi:msiobj_release 0x7efcad60
trace:msi:msiobj_release object 0x7efcad60 destroyed
trace:msi:MSI_ViewFetch 0x7efda640 0x7fb8f9f8
trace:msi:ITERATE_QueryTest File Sequence: 2
trace:msi:msiobj_release 0x7efcad60
trace:msi:msiobj_release object 0x7efcad60 destroyed
trace:msi:MSI_ViewFetch 0x7efda640 0x7fb8f9f8
trace:msi:ITERATE_QueryTest File Sequence: 1
trace:msi:msiobj_release 0x7efcad60
trace:msi:msiobj_release object 0x7efcad60 destroyed
trace:msi:MSI_ViewFetch 0x7efda640 0x7fb8f9f8
trace:msi:ITERATE_QueryTest File Sequence: 3
trace:msi:msiobj_release 0x7efcad60
trace:msi:msiobj_release object 0x7efcad60 destroyed
trace:msi:MSI_ViewFetch 0x7efda640 0x7fb8f9f8
trace:msi:ITERATE_QueryTest File Sequence: 5
trace:msi:msiobj_release 0x7efcad60
trace:msi:msiobj_release object 0x7efcad60 destroyed
trace:msi:MSI_ViewFetch 0x7efda640 0x7fb8f9f8
trace:msi:ITERATE_QueryTest File Sequence: 4
f8

And when I queried the Media Table WHERE LastSequence >= 20, it returns 
LastSequence < 20,

trace:msi:ACTION_InstallFiles DEBUGGING SELECT * FROM Media WHERE 
LastSequence >= 20
trace:msi:MSI_ViewExecute 0x7efde0f0 (nil)
trace:msi:MSI_ViewFetch 0x7efde0f0 0x7fb8f9f8
trace:msi:ITERATE_QueryTest Last Sequence: 6
trace:msi:ITERATE_QueryTest Disk Id: 1
trace:msi:ITERATE_QueryTest CAB: L"Disk1.cab"
trace:msi:msiobj_release 0x7efe0900
trace:msi:msiobj_release object 0x7efe0900 destroyed
trace:msi:MSI_ViewFetch 0x7efde0f0 0x7fb8f9f8
trace:msi:ITERATE_QueryTest Last Sequence: 14
trace:msi:ITERATE_QueryTest Disk Id: 2

hence its broken.

And this query is the same, regardless of the platform WHERE VALUE >= test 
condition, is WHERE value is Greater than or equal test condition, on any 
SQL implementation, MSI, mysql, postgre, ORACLE, etc. etc., wine's 
implementation is broken.

[Mike McCormack]

EA Durbin wrote:
> This is as close as I will be able to come to including a test case, as 
> this is how I obtained my results.

If you want me to fix the problem, please submit a regression test to 
wine-patches with a todo_wine{} around the code that doesn't work.

thanks,

Mike