Sergey,
>Jim,
>
>You still missing the point. They fixed bugs in SQL Engine, nothing more. The ANSI compability was a result or the way of bug fixes not an addition to the bug fixes. As Gene mentioned in
Re: GROUP BY 1 no longer works Message #
754560, the discussion was about what make a default, VFP7 or VFP8 SQL Engine behavior.
So you are saying that the removal of memo allowability in DISTINCT select queries was a requirement to FIX the known bug?
And you are saying that the need to now include ALL SELECTed fields in GROUP BY was a requirement to FIX the known bug?
I don't think that either is the case, personally, but it is clear to me that at least the GROUP BY **can** be attributable to ANSI SQL compatability. I believe the both could have been fixed within the existing syntax - it's a simple matter of programming.
I agree that there were bugs and that they have fixed them. I don't feel that it was necessary to adopt ANSI IN ORDER TO FIX THEM.
Now I don't object that ANSI compatibility was implemented TOO, because I think that is a good thing for the future.
BUT it remains that I do not feel that the implementation we got was the optimal one. And it remains that we get what we get and have to live with it.
SNIP