| From: | 下雨天 <chenzaini(at)qq(dot)com> |
|---|---|
| To: | pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | fix 'ERROR: could not identify a comparison function for type unknown' |
| Date: | 2023-10-31 03:15:54 |
| Message-ID: | tencent_CED800ACF698679D7C9D257F6E051FF9BC09@qq.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi, all:
when I execute simple sql,report ERROR:
postgres=# CREATE TABLE test_v(id int,name varchar(30));
CREATE TABLE
postgres=# insert into test_v values(9,'abc'),(9,'def'),(9,'gh'), (9,'gh');
INSERT 0 4
postgres=# explain (costs off) select distinct (id,name,'D3Q84xpymM',123,'123') from test_v;
QUERY PLAN
-------------------------------------------------------------
Unique
-> Sort
Sort Key: (ROW(id, name, 'D3Q84xpymM', 123, '123'))
-> Seq Scan on test_v
(4 rows)
postgres=# select distinct (id,name,'D3Q84xpymM',123,'123') from test_v;
ERROR: could not identify a comparison function for type unknown
PostgreSQL could not identify 'D3Q84xpymM' and '123' datatype:
we can allow an UNKNOWN type to change it to TEXT,
please check my patch.
Thanks!
| Attachment | Content-Type | Size |
|---|---|---|
| FD112B01@A84E6B19.6A714065.png.jpg | image/jpeg | 278.4 KB |
| error_fix.patch | application/octet-stream | 1.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Guo | 2023-10-31 03:25:44 | Re: Not deleted mentions of the cleared path |
| Previous Message | Amit Kapila | 2023-10-31 03:14:58 | Re: Is this a problem in GenericXLogFinish()? |