Roundup Tracker - Issues

Issue 1585496

classification
search on keywork broken w/ mysql 5
Type: Severity: normal
Components: Database Versions:
process
Status: closed fixed
:
: richard : richard
Priority: normal :

Created on 2006-10-27 00:39 by anonymous, last changed 2006-10-27 00:39 by anonymous.

Messages
msg2321 Author: [hidden] (anonymous) Date: 2006-10-27 00:39
back_mysql.py is creating sql like:

select distinct(_issue.id),rhs0_._order from 
_issue,issue_topic LEFT OUTER JOIN _priority as rhs0_ 
on _issue._priority=rhs0_.id where 
_issue.id=issue_top...

mixing the two join syntaxes isn't valid.

i hacked it by changing line 768 to:

        frum = ' join '.join(frum)

cheesy because there's no "on" so it does a cartesian 
join, but it works.
History
Date User Action Args
2006-10-27 00:39:35anonymouscreate