8.4 RC1 union/nested select cast bug?

From: Eric Miller <eric_g_miller(at)yahoo(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: 8.4 RC1 union/nested select cast bug?
Date: 2009-06-25 23:44:05
Message-ID: 300814.4535.qm@web110404.mail.gq1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


With 8.4RC1, I get the following error with the SQL below.

ERROR: failed to find conversion function from unknown to character varying
SQL state: XX000

SELECT 0 AS "C1", cast('a' as varchar) AS "C2"
UNION ALL
SELECT 1 AS "C1", "X"."XX" AS "C2"
FROM ( SELECT NULL AS "XX" ) AS "X"
WHERE TRUE = FALSE

Compare that SQL to this:

SELECT 0 AS "C1", cast('a' as varchar) AS "C2"
UNION ALL
SELECT 1 AS "C1", NULL AS "C2"
WHERE TRUE = FALSE

The second works without the nested subquery.

I ran into SQL like the above when trying to use the Npgsql .Net driver 2.0.5 via Microsoft's Entity Framework (edmgen.exe). It happened against two different databases. Both have UTF-8 encoding and English, United States language.

--
Eric

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-06-26 00:50:02 Re: 8.4 RC1 union/nested select cast bug?
Previous Message Tom Lane 2009-06-25 21:55:19 PG 8.4 release will be delayed