bundling multiple database queries and getting a result

[Dr. Hawkins]

It is now bug 10940 http://quality.runrev.com/show_bug.cgi?id=10940.

I've confirmed in 6.0.1 commercial, and a 6.0.1 standalone, as well.

I've also seen that SQLite returns incorrect results.

  put "BEGIN TRANSACTION;" & cr into dcmd
>    put "SELECT '1', * FROM testtable WHERE ky='cat';" & cr after dcmd
>    put "SELECT '2', dat FROM testtable WHERE ky='chicken';" & cr after dcmd
>    put "SELECT '3', ky FROM testtable ;" & cr after dcmd
>    put "SELECT '4', ky, ky FROM testtable WHERE ky='chicken' ;" & cr after
> dcmd
>    put "SELECT '5', ky FROM testtable WHERE ky='cat';" & cr after dcmd
>
>    put "COMMIT" & cr after dcmd
>

when I switch from 2 to 1 fields, the result for the last field of the last
line of the prior query continues to report:

1    cat    a lazy animal
2    a tasty bird    a lazy animal
3    cat    a lazy animal
3    chicken    a lazy animal
4    chicken    chicken
5    cat    chicken

*sigh*
-- 
Dr. Richard E. Hawkins, Esq.
(702) 508-8462