BUG #11266: failed to find conversion function from unknown to bigint
| От | zoulx1982@163.com | 
|---|---|
| Тема | BUG #11266: failed to find conversion function from unknown to bigint | 
| Дата | |
| Msg-id | 20140826062110.2532.26317@wrigleys.postgresql.org обсуждение исходный текст | 
| Ответы | Re: BUG #11266: failed to find conversion function from unknown to bigint | 
| Список | pgsql-bugs | 
The following bug has been logged on the website:
Bug reference:      11266
Logged by:          zoulx1982
Email address:      zoulx1982@163.com
PostgreSQL version: 9.4beta2
Operating system:   Win7
Description:
when i migrate my application from oracle to postgrs,
i encounter a query raise error "failed to find conversion function from
unknown to bigint"
the original query is very complicated, so i summarize a simple testcase:
create table t1(a varchar(10));
create table t2(x varchar(10), y bigint);
select s.*
from
(select a, null b from t1
group by a
) s
union all
select x,y from t2;--ERROR
postgres=# select version();
                            version
----------------------------------------------------------------
 PostgreSQL 9.5devel, compiled by Visual C++ build 1600, 32-bit
(1 row)
and when i remove the "group" clause, the query works well
or if i don't use sub-query, it can also work well, i.e.
select a, null b from t1 group by a union all select x,y from t2;
and
select s.* from (select a, null b from t1) s union all select x,y from t2;
is all OK.
is there parameters to avoid the issue without changing original sql,
or doe's somebody can fix the issue later ?
thanks.
		
	В списке pgsql-bugs по дате отправления: