cache lookup failed for function 4

[simovesterinen]

Hi,

When having many columns like in this example there is an error:

ERROR: cache lookup failed for function 4
********** Error **********

ERROR: cache lookup failed for function 4
SQL state: XX000

Example query:

SELECT CAST(3 as integer) as perspective_, (cs_as_array((qq).group_by,'i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4'))[1]:: integer AS A0051, (cs_as_array((qq).group_by,'i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4'))[2]::integer AS A0051_name, (cs_as_array((qq).group_by,'i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4'))[3]:: integer AS A0050, (cs_as_array((qq).group_by,'i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4'))[4]::integer AS A0050_name, (cs_as_array((qq).group_by,'i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4'))[5]:: integer AS A0049, (cs_as_array((qq).group_by,'i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4'))[6]::integer AS A0049_name, (cs_as_array((qq).group_by,'i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4'))[7]:: integer AS A0048, (cs_as_array((qq).group_by,'i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4'))[8]::integer AS A0048_name, (cs_as_array((qq).group_by,'i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4'))[9]:: integer AS A0047, (cs_as_array((qq).group_by,'i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4'))[10]::integer AS A0047_name, (cs_as_array((qq).group_by,'i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4'))[11]:: integer AS A0046, (cs_as_array((qq).group_by,'i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4'))[12]::integer AS A0046_name, (cs_as_array((qq).group_by,'i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4'))[13]:: integer AS A0045, (cs_as_array((qq).group_by,'i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4'))[14]::integer AS A0045_name, (cs_as_array((qq).group_by,'i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4'))[15]:: integer AS A0044, (cs_as_array((qq).group_by,'i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4'))[16]::integer AS A0044_name, (cs_as_array((qq).group_by,'i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4'))[17]:: integer AS A0043, (cs_as_array((qq).group_by,'i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4'))[18]::integer AS A0043_name, (cs_as_array((qq).group_by,'i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4'))[19]:: integer AS A0042, (cs_as_array((qq).group_by,'i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4i4'))[20]::integer AS A0042_name
from Kirjanpito_Omistajat_imcs_4_get('Native') q
, cs_project_agg(cs_hash_sum(q.M0022,q.A0051||q.A0051_name||q.A0050||q.A0050_name||q.A0049||q.A0049_name||q.A0048||q.A0048_name||q.A0047||q.A0047_name||q.A0046||q.A0046_name||q.A0045||q.A0045_name||q.A0044||q.A0044_name||q.A0043||q.A0043_name||q.A0042||q.A0042_name),null,false) qq