BUG #11825: "select lead('literal text') ..." -> could not determine polymorphic type

From: casey(at)cloudera(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #11825: "select lead('literal text') ..." -> could not determine polymorphic type
Date: 2014-10-29 21:45:31
Message-ID: 20141029214531.6149.49378@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 11825
Logged by: casey
Email address: casey(at)cloudera(dot)com
PostgreSQL version: 9.3.5
Operating system: ubuntu 14.04
Description:

Some analytic functions such as LEAD/FIRST_VALUE don't accept char literals
as input, an example is below. This came up randomly during some testing. I
don't have a good use case for such a query and it's easy to workaround but
it seems odd so I thought I'd report it.

functional=# select version();
version

------------------------------------------------------------------------------------------------------
PostgreSQL 9.3.5 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu
4.8.2-19ubuntu1) 4.8.2, 64-bit
(1 row)

functional=# create table empty (c int);
CREATE TABLE
functional=# SELECT LEAD('a') OVER () FROM empty;
ERROR: could not determine polymorphic type because input has type
"unknown"

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2014-10-29 22:15:59 Re: BUG #11638: Transaction safety fails when constraints are dropped and analyze is done
Previous Message skeefe 2014-10-29 19:27:58 BUG #11824: Postgres Restoring the same file multiple times