Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG: COUNT(ICASE(exp,) without eOtherwiseResult!
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
BUG: COUNT(ICASE(exp,) without eOtherwiseResult!
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01005497
Message ID:
01005497
Views:
70
Expected: same result

Observed: when eOtherwiseResult is absent,
VFP return a Table of 1.
CLEAR

CREATE CURSOR RUNROWS (F1 L)

FOR K=1 TO 500
	APPEND BLANK
NEXT

? "ICASE(.T.,1,NULL)=ICASE(.T.,1)",ICASE(.T.,1,NULL)=ICASE(.T.,1)
SYS(3054,12)


SELECT COUNT(ICASE(.T.,1,NULL)) FROM RUNROWS
? _TALLY


SELECT COUNT(ICASE(.T.,1)) FROM RUNROWS
? _TALLY
SYS(3054,0)
Of course this bug is present on all the grouping functions:
MIN(),MAX()
SUM(),AVG() important !!!
Next
Reply
Map
View

Click here to load this message in the networking platform