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 1l6L8A-0006Ms-Gz for pgsql-hackers@arkaria.postgresql.org; Sun, 31 Jan 2021 22:23:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l6L89-0001bb-C1 for pgsql-hackers@arkaria.postgresql.org; Sun, 31 Jan 2021 22:23:41 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l6L89-0001bT-1F for pgsql-hackers@lists.postgresql.org; Sun, 31 Jan 2021 22:23:41 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l6L86-0005j1-KP for pgsql-hackers@postgresql.org; Sun, 31 Jan 2021 22:23:40 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 10VMNPRV3242133; Sun, 31 Jan 2021 17:23:25 -0500 From: Tom Lane To: Alexander Korotkov cc: Pavel Stehule , Dmitry Dolgov <9erthalion6@gmail.com>, Dian M Fay , Andres Freund , Justin Pryzby , David Steele , Nikita Glukhov , Alvaro Herrera , David Fetter , Thomas Munro , Oleksandr Shulgin , Robert Haas , Michael Paquier , Oleg Bartunov , Peter Eisentraut , PostgreSQL Hackers Subject: Re: [HACKERS] [PATCH] Generic type subscripting In-reply-to: References: <20210120190857.vvtwtabubwxzeraq@localhost> <20210121115851.3kwqkyks4irvf452@localhost> Comments: In-reply-to Alexander Korotkov message dated "Sun, 31 Jan 2021 23:55:38 +0300" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <3242131.1612131805.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Sun, 31 Jan 2021 17:23:25 -0500 Message-ID: <3242132.1612131805@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Alexander Korotkov writes: > Pushed with minor cleanup. thorntail seems unhappy: https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=3Dthorntail&dt=3D2= 021-01-31%2020%3A58%3A12 =3D=3D=3D=3D=3D=3D-=3D-=3D=3D=3D=3D=3D=3D stack trace: pgsql.build/src/tes= t/regress/tmp_check/data/core =3D=3D=3D=3D=3D=3D-=3D-=3D=3D=3D=3D=3D=3D [New LWP 2266507] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/sparc64-linux-gnu/libthread_db.so.1"= . Core was generated by `postgres: nm regression [local] SELECT = '. Program terminated with signal SIGILL, Illegal instruction. #0 0x000001000075c410 in jsonb_subscript_check_subscripts (state=3D, op=3D0x10000d852b0, econtext=3D) at /home/nm/far= m/sparc64_deb10_gcc_64_ubsan/HEAD/pgsql.build/../pgsql/src/backend/utils/a= dt/jsonbsubs.c:198 198 for (int i =3D 0; i < sbsrefstate->numupper; i++) #0 0x000001000075c410 in jsonb_subscript_check_subscripts (state=3D, op=3D0x10000d852b0, econtext=3D) at /home/nm/far= m/sparc64_deb10_gcc_64_ubsan/HEAD/pgsql.build/../pgsql/src/backend/utils/a= dt/jsonbsubs.c:198 #1 0x00000100003e55c0 in ExecInterpExpr (state=3D0x10000d85068, econtext=3D= 0x10000d85660, isnull=3D0x7feffa2fbbc) at /home/nm/farm/sparc64_deb10_gcc_= 64_ubsan/HEAD/pgsql.build/../pgsql/src/backend/executor/execExprInterp.c:1= 402 #2 0x00000100003de4bc in ExecInterpExprStillValid (state=3D0x10000d85068,= econtext=3D0x10000d85660, isNull=3D0x7feffa2fbbc) at /home/nm/farm/sparc6= 4_deb10_gcc_64_ubsan/HEAD/pgsql.build/../pgsql/src/backend/executor/execEx= prInterp.c:1765 #3 0x000001000054fbd4 in ExecEvalExprSwitchContext (isNull=3D0x7feffa2fbb= c, econtext=3D, state=3D0x10000d85068) at /home/nm/farm/spa= rc64_deb10_gcc_64_ubsan/HEAD/pgsql.build/../pgsql/src/include/executor/exe= cutor.h:315 #4 evaluate_expr (expr=3D, result_type=3D, = result_typmod=3D, result_collation=3D) at /h= ome/nm/farm/sparc64_deb10_gcc_64_ubsan/HEAD/pgsql.build/../pgsql/src/backe= nd/optimizer/util/clauses.c:4533 #5 0x00000100005513b8 in eval_const_expressions_mutator (node=3D0x10000dc= e218, context=3D0x7feffa30108) at /home/nm/farm/sparc64_deb10_gcc_64_ubsan= /HEAD/pgsql.build/../pgsql/src/backend/optimizer/util/clauses.c:2883 #6 0x00000100004b4968 in expression_tree_mutator (node=3D0x10000cc10e8, m= utator=3D0x1000054fca4 , context=3D0x7feff= a30108) at /home/nm/farm/sparc64_deb10_gcc_64_ubsan/HEAD/pgsql.build/../pg= sql/src/backend/nodes/nodeFuncs.c:2762 #7 0x000001000054fd0c in eval_const_expressions_mutator (node=3D0x10000cc= 10e8, context=3D0x7feffa30108) at /home/nm/farm/sparc64_deb10_gcc_64_ubsan= /HEAD/pgsql.build/../pgsql/src/backend/optimizer/util/clauses.c:3312 #8 0x00000100004b52d0 in expression_tree_mutator (node=3D0x10000cc1140, m= utator=3D0x1000054fca4 , context=3D0x7feff= a30108) at /home/nm/farm/sparc64_deb10_gcc_64_ubsan/HEAD/pgsql.build/../pg= sql/src/backend/nodes/nodeFuncs.c:3050 #9 0x000001000054fd0c in eval_const_expressions_mutator (node=3D0x10000cc= 1140, context=3D0x7feffa30108) at /home/nm/farm/sparc64_deb10_gcc_64_ubsan= /HEAD/pgsql.build/../pgsql/src/backend/optimizer/util/clauses.c:3312 #10 0x000001000055284c in eval_const_expressions (root=3D0x10000dcdca0, no= de=3D0x10000cc1140) at /home/nm/farm/sparc64_deb10_gcc_64_ubsan/HEAD/pgsql= .build/../pgsql/src/backend/optimizer/util/clauses.c:2034 #11 0x0000010000523134 in preprocess_expression (root=3D0x10000dcdca0, exp= r=3D0x10000cc1140, kind=3D) at /home/nm/farm/sparc64_deb10_= gcc_64_ubsan/HEAD/pgsql.build/../pgsql/src/backend/optimizer/plan/planner.= c:1088 #12 0x000001000052ed3c in subquery_planner (glob=3D, parse=3D= 0x10000cc0350, parent_root=3D, hasRecursion=3D, tuple_fraction=3D0) at /home/nm/farm/sparc64_deb10_gcc_64_ubsan/HEAD/p= gsql.build/../pgsql/src/backend/optimizer/plan/planner.c:765 #13 0x0000010000531afc in standard_planner (parse=3D0x10000cc0350, query_s= tring=3D, cursorOptions=3D, boundParams=3D0x= 0) at /home/nm/farm/sparc64_deb10_gcc_64_ubsan/HEAD/pgsql.build/../pgsql/s= rc/backend/optimizer/plan/planner.c:402 #14 0x0000010000696d6c in pg_plan_query (querytree=3D0x10000cc0350, query_= string=3D0x10000cbf340 "select ('123'::jsonb)['a'];", cursorOptions=3D, boundParams=3D0x0) at /home/nm/farm/sparc64_deb10_gcc_64_ubsa= n/HEAD/pgsql.build/../pgsql/src/backend/tcop/postgres.c:876 #15 0x0000010000696f14 in pg_plan_queries (querytrees=3D0x10000dcdbb0, que= ry_string=3D0x10000cbf340 "select ('123'::jsonb)['a'];", cursorOptions=3D<= optimized out>, boundParams=3D0x0) at /home/nm/farm/sparc64_deb10_gcc_64_u= bsan/HEAD/pgsql.build/../pgsql/src/backend/tcop/postgres.c:967 #16 0x00000100006976e4 in exec_simple_query (query_string=3D0x10000cbf340 = "select ('123'::jsonb)['a'];") at /home/nm/farm/sparc64_deb10_gcc_64_ubsan= /HEAD/pgsql.build/../pgsql/src/backend/tcop/postgres.c:1159 #17 0x000001000069a0e0 in PostgresMain (argc=3D, argv=3D, dbname=3D, username=3D) at /ho= me/nm/farm/sparc64_deb10_gcc_64_ubsan/HEAD/pgsql.build/../pgsql/src/backen= d/tcop/postgres.c:4394 #18 0x00000100005a94ec in BackendRun (port=3D0x10000ce4000) at /home/nm/fa= rm/sparc64_deb10_gcc_64_ubsan/HEAD/pgsql.build/../pgsql/src/backend/postma= ster/postmaster.c:4484 #19 BackendStartup (port=3D0x10000ce4000) at /home/nm/farm/sparc64_deb10_g= cc_64_ubsan/HEAD/pgsql.build/../pgsql/src/backend/postmaster/postmaster.c:= 4206 #20 ServerLoop () at /home/nm/farm/sparc64_deb10_gcc_64_ubsan/HEAD/pgsql.b= uild/../pgsql/src/backend/postmaster/postmaster.c:1730 #21 0x00000100005aaa0c in PostmasterMain (argc=3D, argv=3D0= x10000cb9ff0) at /home/nm/farm/sparc64_deb10_gcc_64_ubsan/HEAD/pgsql.build= /../pgsql/src/backend/postmaster/postmaster.c:1402 #22 0x00000100000db054 in main (argc=3D, argv=3D0x10000cb9f= f0) at /home/nm/farm/sparc64_deb10_gcc_64_ubsan/HEAD/pgsql.build/../pgsql/= src/backend/main/main.c:209 $1 =3D {si_signo =3D 4, si_errno =3D 0, si_code =3D 4, _sifields =3D {_pad= =3D {256, 7717904, 5, 0 }, _kill =3D {si_pid =3D 256, s= i_uid =3D 7717904}, _timer =3D {si_tid =3D 256, si_overrun =3D 7717904, si= _sigval =3D {sival_int =3D 5, sival_ptr =3D 0x500000000}}, _rt =3D {si_pid= =3D 256, si_uid =3D 7717904, si_sigval =3D {sival_int =3D 5, sival_ptr =3D= 0x500000000}}, _sigchld =3D {si_pid =3D 256, si_uid =3D 7717904, si_statu= s =3D 5, si_utime =3D 0, si_stime =3D 0}, _sigfault =3D {si_addr =3D 0x100= 0075c410 }, _sigpoll =3D {si_band =3D= 1099519345680, si_fd =3D 5}}} regards, tom lane