Fw: bug in postgres 14.2

Dear
Here an update of our problem.
I have try some other things and it is still stranger:
select count(*) from bin.ggr => no problem (still it had the mulipolygon)
CREATE TABLE bin.ggr (    gid serial NOT NULL,
    objectid int4 NULL,
    naam varchar(64) NULL,
    "__gid" int2 NULL,
    ggrnaa varchar(50) NULL,
    niscode int4 NULL,
    geom gis.geometry(multipolygon, 31370) NULL,
    vmm_gem_id int4 NULL,
    CONSTRAINT ggr_pkey PRIMARY KEY (gid)
);
CREATE INDEX ggr_geom_idx ON bin.ggr USING gist (geom);
CREATE INDEX ggr_vmm_gem_id ON bin.ggr USING btree (vmm_gem_id);
but
select count(*) from trn.parkings => SQL Error [XX000]: ERROR: variable not found in subplan target list

CREATE TABLE trn.parkings (
    gid serial NOT NULL,
    "__gid" numeric(10) NULL,
    omschrijvi varchar(254) NULL,
    bron varchar(20) NULL,
    edit_wijz varchar(20) NULL,
    datum_dig varchar(24) NULL,
    locatieid numeric(10) NULL,
    opmerking varchar(30) NULL,
    park_id int4 NULL,
    geom gis.geometry(multipolygon, 31370) NULL,
    CONSTRAINT parkings_pkey PRIMARY KEY (gid)
);
CREATE INDEX parkings_geom_idx ON trn.parkings USING gist (geom);

The workaround can't we implement (to much work and to complex to change)

Met vriendelijke groetenDavid Van D

----- Forwarded Message ----- From: Van Droogenbroeck David <david_van_d(at)yahoo(dot)com>To: pgsql-bugs(at)lists(dot)postgresql(dot)org <pgsql-bugs(at)lists(dot)postgresql(dot)org>Sent: Tuesday, May 3, 2022, 10:17:28 AM GMT+2Subject: bug in postgres 14.2
Dear
we have found a bug in postgres 14.2.
select count(*) from wat.owl_v ov;the error is: org.jkiss.dbeaver.model.sql.DBSQLException: SQL Error [XX000]: ERROR: variable not found in subplan target list at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:133) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:513) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$0(SQLQueryJob.java:444) at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:171) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:431) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:816) at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:3435) at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:118) at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:171) at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:116) at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.java:4711) at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:105) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63) Caused by: org.postgresql.util.PSQLException: ERROR: variable not found in subplan target list at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2552) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2284) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:322) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:322) at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:308) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:284) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:279) at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JDBCStatementImpl.java:330) at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:130) ... 12 more
the DDL of the table is: CREATE TABLE wat.owl_v ( gid serial NOT NULL, waterlicha varchar(254) NULL, owl_naam varchar(254) NULL, orde varchar(254) NULL, gsd varchar(50) NULL, bekken_nr numeric(10) NULL, bekken_naa varchar(254) NULL, cat_code numeric(10) NULL, cat_naam varchar(254) NULL, typ_code varchar(254) NULL, type_naam varchar(254) NULL, statuut_co varchar(10) NULL, statuut_na varchar(254) NULL, asz varchar(20) NULL, lengte numeric NULL, geldig_van date NULL, geldig_tot date NULL, geom gis.geometry(multipolygon, 31370) NULL, vmm_vhaw_id int4 NULL, CONSTRAINT owl_v_pkey PRIMARY KEY (gid) ); CREATE INDEX owl_v_geom_idx ON wat.owl_v USING gist (geom); CREATE INDEX owl_v_vmm_vhaw_id ON wat.owl_v USING btree (vmm_vhaw_id); the most strange on the thing is, when we change the * into any of the fields of the table, We don't get an error.
I think the problem is something with multipolygon, because we have another table quite the same but with multilinestring and the query works without any problem CREATE TABLE wat.owl_l ( gid serial NOT NULL, waterlicha varchar(254) NULL, owl_naam varchar(254) NULL, orde varchar(254) NULL, sgd varchar(50) NULL, bekken_nr numeric(10) NULL, bekken_naa varchar(254) NULL, cat_code numeric(10) NULL, cat_naam varchar(254) NULL, type_code varchar(254) NULL, type_naam varchar(254) NULL, statuut_co varchar(10) NULL, statuut_na varchar(254) NULL, asz varchar(20) NULL, geldig_van date NULL, geldig_tot date NULL, lengte numeric NULL, geom gis.geometry(multilinestring, 31370) NULL, vmm_vhaw_id int4 NULL, CONSTRAINT owl_l_pkey PRIMARY KEY (gid) ); CREATE INDEX owl_l_geom_idx ON wat.owl_l USING gist (geom); CREATE INDEX owl_l_vmm_vhaw_id ON wat.owl_l USING btree (vmm_vhaw_id);
Kind regardsDavid Van D