这是什么情况?🤔
2022-08-15 09:52:28.485 UTC [31] ERROR: column reference "id" is ambiguous at character 8
2022-08-15 09:52:28.485 UTC [31] STATEMENT: SELECT id, coalesce(reblog_of_id, id) as status_id FROM "statuses" LEFT OUTER JOIN "accounts" ON "accounts"."id" = "statuses"."account_id" WHERE "statuses"."deleted_at" IS NULL AND ("accounts"."actor_type" NOT IN ($1, $2) AND "statuses"."local" = $3 OR "statuses"."uri" IS NULL) ORDER BY "statuses"."id" ASC LIMIT $4
@[email protected] 估计是不知道是 "accounts"."id" 还是 "statuses"."id" ,试试明确指定一下?
@[email protected] (*不知道 SELECT id
是哪一个表的 id 列
@Candinya 明天试一下。很诡异的是这个是ORM生成的查询,实在不应该
Fixed: ambiguous column names in
tootctl search deploy
https://github.com/mastodon/mastodon/pull/18993/files