[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. > > 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] -----------------------------------------------------------------------------
