[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
=?UTF-8?B?R8OhYm9yIEZhcmthcw==?= <[EMAIL PROTECTED]> wrote:
select * from role
LEFT OUTER JOIN person_role on role.id = person_role.role_id
INNER JOIN person on person_role.person_id = person.id
Your work-around is to say "CROSS JOIN" here instead of
"INNER JOIN". The problem was the query optimizer being
overly agressive. Using CROSS JOIN in place of INNER JOIN
defeats the query optimizer and results in a correct run.
thanks for the help,
i think i will upgrade my sqlite3.
gabor
WHERE person.id=1;
5|admin|1|5|1|john
6|devel||||
i think it should only output the first row ( "5|admin|1|5|1=
|john" )
so, am i doing something wrong here?
(using ubuntu edgy, sqlite3 3.3.5)
This is fixed in 3.3.6. 3.3.8 is current.
http://www.sqlite.org/cvstrac/chngview?cn=3203
http://www.sqlite.org/cvstrac/tktview?tn=1830
--
D. Richard Hipp <[EMAIL PROTECTED]>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
