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

[Koichi S. <koi...@gm...>]

Ashutosh, do you have a time to look into it?
---
Koichi Suzuki


2014-01-31 David E. Wheeler <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
>
>
>
> ------------------------------------------------------------------------------
> WatchGuard Dimension instantly turns raw network data into actionable
> security intelligence. It gives you real-time visual feedback on key
> security issues and trends.  Skip the complicated setup - simply import
> a virtual appliance and go from zero to informed in seconds.
> http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers