search

knizhnik / imcs

In-Memory Columnar Store extension for PostgreSQL
Apache License 2.0
203 stars 33 forks source link

TABLE_project ERROR: function return row and query-specified return row do not match #23

Closed amutu closed 10 years ago

amutu commented 10 years ago

when use in the From Clause,the TBLE_project get error: postgres=# select * from samp3_project(samp3_get());
NOTICE: IMCS command: project ERROR: function return row and query-specified return row do not match DETAIL: Returned type bigint at ordinal position 1, but query expects timestamp without time zone.

while run the function as select list, it is ok: postgres=# select samp3_project(samp3_get()); NOTICE: IMCS command: project

samp3_project

(631950263,2191a6ae264f1058fb01a0084a73b509,"2014-02-23 00:00:07") (294969415,dc8028c36369b682d695c360f19ccf17,"2014-02-23 00:00:07") (778660501,31eae0cfda948b3c3852c5cbf2e63659,"2014-02-23 00:00:07") ...

this also OK: postgres=# select samp3_project(t) from samp3_get() as t;
NOTICE: IMCS command: project

samp3_project

(631950263,2191a6ae264f1058fb01a0084a73b509,"2014-02-23 00:00:07") (294969415,dc8028c36369b682d695c360f19ccf17,"2014-02-23 00:00:07") (778660501,31eae0cfda948b3c3852c5cbf2e63659,"2014-02-23 00:00:07") (667438543,f2dbd4d6a989ba4f539a661a4212458f,"2014-02-23 00:00:07") ...

amutu commented 10 years ago

sorry for the noise,this has been fixed by the https://github.com/knizhnik/imcs/commit/9a2c2615ebf8ad3c354c92e17ea33b3732fdd2a0