Justin Fletcher <[EMAIL PROTECTED]> wrote:
> do_test select1-11.2.2 {
> execsql2 {
> SELECT * FROM t3, t4;
> }
> } {a 3 b 4 a 3 b 4}
>
> Can someone explain how the test can be correct ?
>
This comes about because of duplicate column names.
The execsql2 procedure looks at all column names in
the result set, then returns the value associated with
each column name. So in the example above, it looks
at columns named "a", "b", "a", and "b", in that order.
But both "a" and "b" are ambiguous names. So it picks
the value that corresponds to the column that is last
in the list.
This is goofy, perhaps, but it is the way the test
system works.
--
D. Richard Hipp <[EMAIL PROTECTED]>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
