Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG: SELECT SQL WHERE IN return wrong results
Message
From
06/10/2005 09:33:20
 
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro Beta
Title:
BUG: SELECT SQL WHERE IN return wrong results
Environment versions
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01056722
Message ID:
01056722
Views:
63
BB on Thread #1056683 report a old bug ( i post it some a long time ago on UT)

Observed: On VFP9 the result is correct,
but it is a indirect result ( NULL change the C++ path of the code ).
The code into VFP9 still to be bad
and it shows the face when we changes ENGINEBEHAVIOR:
CLEAR

CREATE CURSOR cTest (God N(4))
INSERT INTO cTest VALUES (2003)
INSERT INTO cTest VALUES (2003)
INSERT INTO cTest VALUES (2004)
INSERT INTO cTest VALUES (2004)

SET ENGINEBEHAVIOR 70
TEST()

SET ENGINEBEHAVIOR 80
TEST()

SET ENGINEBEHAVIOR 90

TEST()


PROCEDURE TEST

? "ENGINEBEHAVIOR",SET("EngineBehavior")

selectMax =[SELECT MAX(God) FROM cTest WHERE .F.]

&selectMax INTO CURSOR Test1

? _TALLY

SELECT * FROM cTest ;
WHERE God IN (&selectMax);
INTO CURSOR cMaxRec
? _TALLY
Reply
Map
View

Click here to load this message in the networking platform