Postgres Pro
Downloads
Home   >   mailing lists

Re: LLVM jit and window functions on a temporary table - Mailing list pgsql-bugs

From Tom Lane
Subject Re: LLVM jit and window functions on a temporary table
Date
Msg-id 17175.1532205188@sss.pgh.pa.us
Whole thread Raw
In response to LLVM jit and window functions on a temporary table  (Dmitry Dolgov <9erthalion6@gmail.com>)
Responses Re: LLVM jit and window functions on a temporary table
List pgsql-bugs
Tree view 
Dmitry Dolgov <9erthalion6@gmail.com> writes:
> While testing PostgreSQL instance with enabled jit I found out another
> interesting problem:
> ...
> gdb shows that in tuplestore_select_read_pointer somehow the value of ptr is -1

Is that current HEAD, or back a bit?  We just fixed a non-JIT-related
bug with similar symptoms:

Author: Tom Lane <tgl@sss.pgh.pa.us>
Branch: master [ff4f88916] 2018-07-11 12:07:20 -0400
Branch: REL_11_STABLE [8893d48e7] 2018-07-11 12:07:21 -0400

    Fix bugs with degenerate window ORDER BY clauses in GROUPS/RANGE mode.

and your query does look like it matches that, since the f1=f2 clause
renders the ORDER BY degenerate.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #15289: Type inference of parameters in prepared statementscan sometimes fail or succeed, depending...
Next
From: Nick Farmer
Date:
Subject: Re: BUG #15289: Type inference of parameters in prepared statementscan sometimes fail or succeed, depending...