[Postgres-xc-developers] ERROR: unexpected varno 6 in JOIN RTE 5

[David E. W. <da...@ju...>]

XCers,

Sqitch has a query that looks like this:

            INSERT INTO tags (
                   tag_id
                 , tag
                 , project
                 , change_id
                 , note
                 , committer_name
                 , committer_email
                 , planned_at
                 , planner_name
                 , planner_email
            )
            SELECT tid, tg, proj, chid, n, name, email, at, pname, pemail FROM ( VALUES
        (?, ?, ?, ?, ?, ?, ?, ?::timestamptz, ?, ?)
            ) i(tid, tg, proj, chid, n, name, email, at, pname, pemail)
              LEFT JOIN tags ON i.tid = tags.tag_id
             WHERE tags.tag_id IS NULL

Works fine on 8.4-9.3, but XC does not like it:

    ERROR:  unexpected varno 6 in JOIN RTE 5

I have no idea what that means. I tried renaming some of the column aliases in the VALUES subselect, but it made not difference. Any ideas?

Thanks,

David