Hi J Decker,
I've got the amalgamation patch working now. However it seems the alias of
subquery isn't processed correctly.
The full SQL:
SELECT "posts".*, "tagMaps".*, "topics".* FROM (SELECT * FROM "articles"
WHERE "gmt_deleted" IS NULL) AS "posts" LEFT JOIN "tag_maps" AS "tagMaps" ON
"posts"."id" = "tagMaps"."target_id" AND "tagMaps"."target_type" = 0 LEFT JOIN
"tags" AS "topics" ON "tagMaps"."tag_id" = "topics"."id" AND "topics"."type" = 1
The columns of articles have both their table and table alias point to
`articles`. I believe the alias should be `posts`.
Jake
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
