Incorrect FROM-clause (postgres)
Reported by szymon | June 5th, 2009 @ 03:10 AM
This code:
gives us this kind of error:
query:
SELECT "articles"."id", "articles"."title" FROM "articles"
INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" INNER
JOIN
"articles" ON "taggings"."article_id" = "articles"."id" WHERE
"tags"."tag" = 'sometag' GROUP BY "articles"."id",
"articles"."title" ORDER BY "articles"."id"
is invalid. should be (i think):
SELECT "articles"."id", "articles"."title" FROM "tags"
INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" INNER
JOIN
"articles" ON "taggings"."article_id" = "articles"."id" WHERE
"tags"."tag" = 'sometag' GROUP BY "articles"."id",
"articles"."title" ORDER BY "articles"."id"
Comments and changes to this ticket
-
Dan Kubb (dkubb) June 16th, 2009 @ 03:40 AM
- Assigned user set to “Dan Kubb (dkubb)”
- State changed from “unconfirmed” to “accepted”
- Milestone set to “0.10.0”
-
Dan Kubb (dkubb) October 4th, 2009 @ 09:33 PM
- Tag changed from “0.10.0, adapter, dataobjects, postgres, postgresql” to “adapter, dataobjects, postgres, postgresql”
- Milestone changed from “0.10.0” to “0.10.2”
[project:id#20609 not-tagged:"0.10.0" milestone:id#51895 bulk edit command]
-
Dan Kubb (dkubb) February 1st, 2010 @ 04:33 PM
- Milestone changed from “0.10.2” to “1.0.0”
-
-
-
Dan Kubb (dkubb) February 2nd, 2010 @ 02:47 AM
- State changed from “accepted” to “confirmed”
Please Sign in or create a free account to add a new ticket.
With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.
Create new ticket
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile »
Dan Kubb (dkubb)
szymon