On Tue, April 11, 2006 7:04, Alec Thomas said:
> Well, I answered my own question by installing Postgres. The boys on
> #postgresql educated me to the fact that you can not refer to a column
> alias in the WHERE clause. Annoying, but there you have it. It appears
> it is just a lack of strictness on SQLite's part that allows it to work.
>
> Please try this patch:
>
> Index: tractags/ticket.py
> ==================================================================
> --- tractags/ticket.py (revision 230)
> +++ tractags/ticket.py (working copy)
> @@ -29,7 +29,7 @@
> tags = set(tags)
> names = set(names)
> args = []
> - sql = "SELECT id, %s, %s AS allfields FROM ticket" %
> (','.join(self.fields),
> + sql = "SELECT * FROM (SELECT id, %s, %s AS allfields FROM
> ticket) s" % (','.join(self.fields),
> '||'.join(["COALESCE(%s, '')" % f for f in self.fields]))
> constraints = []
> if names:
>
I take it that this implies that I must check-out the TracTags trunk
again, apply the patch, and then rebuild the egg? Correct?
Regards,
Jim
--
*** e-mail is NOT a secure channel ***
James B. Byrne mailto:ByrneJB.<token>@Harte-Lyne.ca
Harte & Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3CE delivery <token> = hal
_______________________________________________
Trac mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac
