Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nloXi-0002fh-2d for pgsql-bugs@arkaria.postgresql.org; Tue, 03 May 2022 09:10:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nloXg-0005fL-VB for pgsql-bugs@arkaria.postgresql.org; Tue, 03 May 2022 09:10:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nlnka-0001dd-R7 for pgsql-bugs@lists.postgresql.org; Tue, 03 May 2022 08:19:17 +0000 Received: from sonic308-35.consmr.mail.ne1.yahoo.com ([66.163.187.58]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nlnkY-0002vt-Sk for pgsql-bugs@lists.postgresql.org; Tue, 03 May 2022 08:19:16 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1651565951; bh=Pa1Ux3LN+y9sheWw491aZXbgJ3KA5IBdeRieLPixRbM=; h=Date:From:To:Subject:References:From:Subject:Reply-To; b=PF1uR9U1rRzwpD1E4ksdnu1ZkaIvuJ6nCBSGqhpR4neblZO1SxmPS4ZLmLOrAKdfXvc6i4O1dbDyREFzZ9zKicTyR2NGUDPC1PX6tHSs0RE6zi93Zlv16MTInMbd/7Z5kYa2IoYtbk8tsUVHasOjNia5BW4iyTGl84gY0nDUZIFOEZJY3xVIxTznayfWjCVGhP1cHpudma/RWlVgbfh5GhrTz+NfJkBSdMOEiHI5p1AirKnIIeJswzUEo024NVp4UzZYOJxexF89xUcqnjwRCvpfoxRpITAgFJNVbndPcb8YhDYPQp9ojsAMlmuecYzLF9Eyeh7fqPZcBFF9r2oitw== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1651565951; bh=CptfO1/filycatqFqPB/s7fPXIHVxSXCZnFPyyokoal=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=MR/2pgoAgapqBrYWRndDvxwDQV0q7dvldSdsV+elX3cfFqz2fWZD/1s4wNMVHelWwoal4AVJ+moIcEDHOdr4it/PyGKTGLKUuTlgF3mrDtOoaJgQtk0pHWg6AQ57FNky25by9unEIeR96FK1HJeABX4ZCVjgqhhftNYsOBlB8e+JV4zC1mpvp85WitskE9UY0o4Qg0EXHkt653kI1sD7dDdlcU8brFv86q0oksC23gTmqhBwSO4hjncJb1duotL09TbQ52JFuZUKWX6EvYgw8UV6awVEuJ7Y9aZMDuPVTv0HsK1IKrLVu1Lib65Iec0Y3RJkuztQreXcVzK+wz7FoA== X-YMail-OSG: rH4_ciUVM1nE1_qKaY7pHcQVf4ryPay2pNuYu0ra.Ayz.g5fw8S0j0VQfv5T2Gh COkz4Mntgg_CItQkKjpsuELJzO.dAgr8azyDHN41WryhWGQo73MypwJiPX0RUBovegok_Y3sgbHP 6po0qDFpJqsJCYcWcAgM560jRGJs6TnX_i9sL8heRYg7EzS4hutz8jK8VC_YWatIZsUXpVSfxjaD f5nVgVcki26_wKHX6vRJ_taT72Ox_KFjxUt.6v2pgB04EOLFf84DpA7JBAq_iAbPbTQJNtMOEGAQ NSCOD1SikCuVckiRu6rCV3k2vcphh6F7a0MibbIVjkNZNg.9mK_m7AmSly1jASQu9.7z_mqpVcOT ipqMwnjDChi6sLPGtRnS74LFxzimbNnveMmuw6rgIkk5wMfNISaRLVU3CcauA8Jyr..ub7w2j87r eQDUGXLDhPnWZEfKWp_bGl7O8BH3OmGSzPvXUOhZiC46JY_hFrFT1fJzPmF722Z8NBlVu3Jn1EdO H_gvxwoNxBOtmm33Xalep2kq_Y1fpvzI8DtpRs1f41gYoKkM8VVXJSofpAyqtSMlkx97EPdxWrES 5JCI5jFLOHkiNVu3lRA_l28oX6mpUxUkT01_kpFMJrikMl4QSIuEw26.VlD7XiSOJN5WVg1oImZ0 m0G6sYfLmUB2ik0voBrOtyo22KOPqyTF5heuVplEjP4gy7XTCLgxitQeZNDgRWxiSpN0XNIqQYeD ZHqEJzplajpa9J3.vp4WbAdUS9l4Ii2ADaoA54s_umVkgFAjQzfSsb6mw4PqUqWeVU.jBW7RAjwb X2nijmv5SFscjd.OvderJwRcOOfCKOWI9N2CsTgFsTu5zjHchktpzdTSRrFBbkxx_FcSfQuPTO4P MyLETZv3AmqfR_3_iK5_GMjbWX3BIDD8xjtZEIVozV0NtwuYGl0DN4gr_9S5tznI16R.bHCTunsT 6WyZvpgftqEtKfV6IyDxBgnqiT4yQcLKz1P.hoBu2902GkOLH_fUVW5YO26YGZzF.3HucRMAvo8y MNs0PVdpPCjU47AWiHNlI9b.2PjersgY_GHj5AeOqrkvcFgciM3l15Mr8HiLIju4rGjfoJEIzAhG 43Us9UFOA8JvVWtJ1ymyg8COvQRGls6XaF31RGUSHyPszmCOtmO1X1RDJomG8yeWDGvWAvayY8qD CKVKL42rrULjg5yerBTZYMANXTObrAsakkhn5G7lj8NJAYibXPW7olgjGGbeeK1.r76aSqRXvv1Y D9KhT1fQrwtpnULYaS4jMuoVqTITYX5YTtbUhWrsbg4d9iB09Ved8wFfvsBeRyauMAcJRF23kyUX TSSzXpCgxvx3T5oYzqJ_SNXkLRv7c9fgzJl20z6WCBqfj9P2JXdGom_FaLAjT874zj0eRN.iIiHO V4cI13gSmy0BSIrfL7AITGGrgQs5arx2RLsId1uj3AZTcCAMujW1JgWnmB3vBrZgRa9eF6pNVPpy 2hBZjK8hznQOwVjAQmLL3BRi3UL0MOMD0d69mf48G9EZjFe30OmvPTw0Se0f6VwIGl4J3OnaChty 64i0EASUXJFpfCCCzti3A3nb_ICfU6NZ0JhC5LHhyPnr.NE04Nh1mg1p5eh7qORqSybNJ21SP3iY iSO1naC5tOP9X8Wwcwt31RcBs3j06c2SG6iLhU2mzJg27dFDxbL7HP7livv0SsS0jKl7GKkPRub0 UKVwuQKG5lu3ETtC_FVVW1gq9u2EySjemC276Um1Km3UCCN3kw9UfaSXpcC5PZ6T8KSPSfvXtCJe fuwBrAQJ7t5Dfmp84KlHEReUcM9lL.gq4zX4YU81YiWUBJfPfnF5swpiMNnh0LDqlJlEEfc7PR82 l_4Cl5oZs3Wy_mfsNJecBJBl2Hs5cyswvIETTo.MplgaI4sk1r2NgI_nOHQp50hD4_DvGSB1t_D9 lsU4hvjnIziWNMKrMXiqPZSvkdxjw_fY3dOtB34TiHkrJn5zx_jIOwgoELW5NAhTPsRn2n5xsvXq XOMeWHTq5_L5zd3bNDR5GZdaIhEFgujgP5Bx3ojBTcrT.hHMm3mEpElxZ56Lm_pPCDsjYqxmI2ba waNvGUmz0l106RIxwkN4IAcyjl3JNqzfLV8yj_8HuEDfERFNEkPpwpJYcziZ4cCZSGwRfjnCuKsf SlAuGnULjkCGzdE7vULSbCGL5.F2RWFuClTXQHLN0LaBw.HWUB3jU6oZMZnVkMDj9KwbQ0iRZ6A9 ysooBqSs- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic308.consmr.mail.ne1.yahoo.com with HTTP; Tue, 3 May 2022 08:19:11 +0000 Date: Tue, 3 May 2022 08:17:28 +0000 (UTC) From: Van Droogenbroeck David To: "pgsql-bugs@lists.postgresql.org" Message-ID: <661039975.3830107.1651565848436@mail.yahoo.com> Subject: bug in postgres 14.2 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3830106_1304741091.1651565848433" References: <661039975.3830107.1651565848436.ref@mail.yahoo.com> X-Mailer: WebService/1.1.20118 YMailNorrin Content-Length: 14083 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_3830106_1304741091.1651565848433 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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 ta= rget list at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execu= teStatement(JDBCStatementImpl.java:133) at org.jkiss.dbeaver.ui.editors.sql= .execute.SQLQueryJob.executeStatement(SQLQueryJob.java:513) at org.jkiss.db= eaver.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.executeSingle= Query(SQLQueryJob.java:431) at org.jkiss.dbeaver.ui.editors.sql.execute.SQL= QueryJob.extractData(SQLQueryJob.java:816) at org.jkiss.dbeaver.ui.editors.= sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:3435) at org.jk= iss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJo= bDataRead.java:118) at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteR= ecover(DBExecUtils.java:171) at org.jkiss.dbeaver.ui.controls.resultset.Res= ultSetJobDataRead.run(ResultSetJobDataRead.java:116) at org.jkiss.dbeaver.u= i.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetView= er.java:4711) at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJo= b.java:105) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63) Ca= used by: org.postgresql.util.PSQLException: ERROR: variable not found in su= bplan target list at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorR= esponse(QueryExecutorImpl.java:2552) at org.postgresql.core.v3.QueryExecuto= rImpl.processResults(QueryExecutorImpl.java:2284) at org.postgresql.core.v3= .QueryExecutorImpl.execute(QueryExecutorImpl.java:322) at org.postgresql.jd= bc.PgStatement.executeInternal(PgStatement.java:481) at org.postgresql.jdbc= .PgStatement.execute(PgStatement.java:401) at org.postgresql.jdbc.PgStateme= nt.executeWithFlags(PgStatement.java:322) at org.postgresql.jdbc.PgStatemen= t.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.JDB= CStatementImpl.execute(JDBCStatementImpl.java:330) at org.jkiss.dbeaver.mod= el.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, wate= rlicha varchar(254) NULL, owl_naam varchar(254) NULL, orde varchar(254) NUL= L, 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 var= char(254) NULL, type_naam varchar(254) NULL, statuut_co varchar(10) NULL, s= tatuut_na varchar(254) NULL, asz varchar(20) NULL, lengte numeric NULL, gel= dig_van date NULL, geldig_tot date NULL, geom gis.geometry(multipolygon, 31= 370) 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 varcha= r(254) NULL, owl_naam varchar(254) NULL, orde varchar(254) NULL, sgd varcha= r(50) NULL, bekken_nr numeric(10) NULL, bekken_naa varchar(254) NULL, cat_c= ode numeric(10) NULL, cat_naam varchar(254) NULL, type_code varchar(254) NU= LL, type_naam varchar(254) NULL, statuut_co varchar(10) NULL, statuut_na va= rchar(254) NULL, asz varchar(20) NULL, geldig_van date NULL, geldig_tot dat= e 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 ------=_Part_3830106_1304741091.1651565848433 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Dear

we h= ave found a bug in postgres 14.2.

select count(= *) from wat.owl_v ov;
the error is:
=09org.jkiss.dbeaver.model.sql.DBSQLExceptio= n: SQL Error [XX000]: ERROR: variable not found in subplan target list
=09=09at org.jkiss.dbea= ver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementIm= pl.java:133)
=09=09= at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQ= LQueryJob.java:513)
=09=09= at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$0(SQL= QueryJob.java:444)
=09=09<= /span>at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecU= tils.java:171)
=09=09at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuer= y(SQLQueryJob.java:431)
= =09=09at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extrac= tData(SQLQueryJob.java:816)
=09=09at org.jkiss.dbeaver.ui.controls.resultset.ResultS= etJobDataRead.lambda$0(ResultSetJobDataRead.java:118)
=09=09at org.jkiss.dbeaver.model.exec.DB= ExecUtils.tryExecuteRecover(DBExecUtils.java:171)
=09=09at org.jkiss.dbeaver.ui.controls.resul= tset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:116)
=09=09at org.jkiss.dbeaver.ui.con= trols.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.ja= va:4711)
=09=09at o= rg.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:105)
<= div>=09=09at org.eclipse.core= .internal.jobs.Worker.run(Worker.java:63)
=09Caused by: org.postgresql.util.PSQLException: ERR= OR: variable not found in subplan target list
=09=09at org.postgresql.core.v3.QueryExecutorImp= l.receiveErrorResponse(QueryExecutorImpl.java:2552)
=09=09at org.postgresql.core.v3.QueryExe= cutorImpl.processResults(QueryExecutorImpl.java:2284)
=09=09at org.postgresql.core.v3.QueryExe= cutorImpl.execute(QueryExecutorImpl.java:322)
=09=09at org.postgresql.jdbc.PgStatement.execute= Internal(PgStatement.java:481)
=09=09at org.postgresql.jdbc.PgStatement.execute(PgStatement.ja= va:401)
=09=09at or= g.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:322)
<= div>=09=09at org.postgresql.j= dbc.PgStatement.executeCachedSql(PgStatement.java:308)
=09=09at org.postgresql.jdbc.PgStatemen= t.executeWithFlags(PgStatement.java:284)
=09=09at org.postgresql.jdbc.PgStatement.execute(PgSt= atement.java:279)
=09=09at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JD= BCStatementImpl.java:330)
= =09=09at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.ex= ecuteStatement(JDBCStatementImpl.java:130)
=09=09... 12 more

the DDL = of the table is:
=09CREATE TABLE wat.owl_v (
= =09=09gid serial NOT NULL,
=09=09waterlicha varchar(254) NULL,
=09=09owl_naam varchar(254) NULL,
=09=09orde varchar(254) NULL= ,
=09=09gsd varchar= (50) NULL,
=09=09be= kken_nr numeric(10) NULL,
= =09=09bekken_naa varchar(254) NULL,
=09=09cat_code numeric(10) NULL,
=09=09cat_naam varchar(254) NULL,
=09=09typ_code varchar= (254) NULL,
=09=09t= ype_naam varchar(254) NULL,
=09=09statuut_na varchar(254) NULL,
=09=09asz varchar(20) NULL,
=
=09=09lengte numeric NUL= L,
=09=09geldig_van= date NULL,
=09=09g= eldig_tot date NULL,
=09= =09geom gis.geometry(multipolygon, 31370) NULL,
=09=09vmm_vhaw_id int4 NULL,
=09=09CONSTRAINT owl_v= _pkey PRIMARY KEY (gid)
= =09);
=09CRE= ATE INDEX owl_v_geom_idx ON wat.owl_v USING gist (geom);
=09CREATE INDEX owl_v_vmm_vhaw_id ON = wat.owl_v USING btree (vmm_vhaw_id);
=09
the most strange on the thing is, when we c= hange the * into any of the fields of the table, We don't get an error.

I think the problem is something with multipolygon, b= ecause we have another table quite the same but with multilinestring and th= e query works without any problem
=09CREATE TABLE wat.owl_l (
=09=09gid serial NOT NULL,
=09=09waterlicha varchar(254) NULL,
=09=09owl_naam varchar(254= ) NULL,
=09=09orde = varchar(254) NULL,
=09=09<= /span>sgd varchar(50) NULL,
=09=09bekken_naa varchar(254) NULL,
=09=09cat_code numeric(10) NULL,
=09=09cat_naam varch= ar(254) NULL,
=09=09type_code varchar(254) NULL,
=09=09type_naam varchar(254) NULL,
=09=09statuut_co varchar(10) NULL,
=09=09statuut_na varchar(254) NU= LL,
=09=09asz varch= ar(20) NULL,
=09=09= geldig_van date NULL,
=09= =09geldig_tot date NULL,
=09=09lengte numeric NULL,
=09=09geom gis.geometry(multilinestring, 31370)= NULL,
=09=09vmm_vh= aw_id int4 NULL,
=09=09CONSTRAINT owl_l_pkey PRIMARY KEY (gid)
=09);
=09CREATE INDEX owl_l_geom_idx ON wat.owl_l USING gist (geom);<= /div>
=09CREATE INDEX owl= _l_vmm_vhaw_id ON wat.owl_l USING btree (vmm_vhaw_id);

=
Kind regards
David Van D

------=_Part_3830106_1304741091.1651565848433--