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

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

Hi there,

I’d like to release an updated version of Sqitch, but would like to resolve this issue, first. Anyone had a chance to look into it?

Thanks,

David

On Jan 30, 2014, at 5:35 PM, Koichi Suzuki <koi...@gm...> wrote:

> Ashutosh, do you have a time to look into it?
> 
> 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?