Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wB60Q-000jNF-1p for pgsql-hackers@arkaria.postgresql.org; Fri, 10 Apr 2026 07:10:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wB60P-00A52D-03 for pgsql-hackers@arkaria.postgresql.org; Fri, 10 Apr 2026 07:10:17 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from <3danissimo@gmail.com>) id 1wB60O-00A525-1Y for pgsql-hackers@lists.postgresql.org; Fri, 10 Apr 2026 07:10:17 +0000 Received: from mail-yw1-x112a.google.com ([2607:f8b0:4864:20::112a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from <3danissimo@gmail.com>) id 1wB60M-00000000I5r-34ES for pgsql-hackers@postgresql.org; Fri, 10 Apr 2026 07:10:16 +0000 Received: by mail-yw1-x112a.google.com with SMTP id 00721157ae682-79495b1aaa7so18051467b3.1 for ; Fri, 10 Apr 2026 00:10:15 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775805014; cv=none; d=google.com; s=arc-20240605; b=JJfEnC36TJrGVX5Si0XYRJgSrpCa/TXjhdIQTv/A/6ETqPmliP5E8IYYVqRu9TwOkr 2/Et2n33FKSrZ6jPe1uLHk814gEcsCwPkxgflcKjCOMsMCCps+sBS7UH1+7snDMsHEYB F3tsSa8ULEM+OO+YT2XAXxtDbt6hcGYRmRj1mqJj02Blhwcw2zgGbOYwG0YXdv/F/hgk oQlDKcC3EyggojaRB3BUeksIs/BqUUnCH+Xx4BABIGIRQU6aR5ORGHw2+sqJsulIUrho ZdqBHlFmd1A//1HOxY63UOblciDRLXxNqCfEVRtfUQoelbo4p5FoHgX4cvEUJrTChf2t 9+ZA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=VATdssFqQpXgYOdOH4uSKZ5BVetFpyTdfje5fKDOn6s=; fh=SMFv1N9bE0/AuLP3G8J7FZc44V1NGUrp+dxIdb1tpZU=; b=c+5pcyuCdO3WM8y3Rh6LmpP5zTVmQxI2oGK2ox4nU53HLSwA18x9fCkgVcpnzKEQul W/j3BjP9dG9dBgt8FWuL9CDgVVjO1i/HKFprmoXBNMdcEPoTW/USBnMOnmcpg+VJIimT 3VHJFis5pa5anECy84OBONlBV8NlhtpFqOery18MgyIiwSLvSsbJVtrUeET7dPkQoKuj bfYs3Kp9BeEzs7Ojc5AOHIzdvxODibzK8FIBFXrwq2hpHlClEw3kCdmDmSa3nlTdSTrD eyaaPkfl2D8vqFLZ7F2P6cGqMuAAtYjcZN4i8/l+a6+e3W6iEl7p3ywRsQKzuFk/VubS u83Q==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1775805014; x=1776409814; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=VATdssFqQpXgYOdOH4uSKZ5BVetFpyTdfje5fKDOn6s=; b=jXXfdS9NeKu9aLneYjVoqmhqPgsGrQ9g7y9aRkLGZTwYPweMRVMMWdjHkjyTB0yM8v c1xb1fna7j/yMa36WyaRhfl81TVw/gSDnuyMbcx/4IJRTGidXOx65/FGWuUxejZUKiK/ hHSaELvKPeIhx1/XKjK9SobHMSB68mHOgN2h8At4ea5wm+DLGAmagEsq5dPnDtr4ovyf y7EHr8a0d4rl73yNx/zRGeqBHWrVCFHaFnt/loK3gRPzUv373Vas5bKREIKw6mTmEgiP vkOF3iXFI2tWw3NHOU6Lw4AaY2DH+iZ+o51fYiaAinkBCR1ybwqd8R073iQXVdjhGNyT 9dBg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775805014; x=1776409814; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=VATdssFqQpXgYOdOH4uSKZ5BVetFpyTdfje5fKDOn6s=; b=cgSp7b7XXGDYcaW71OeXh+ZBJqDKs3TYxxQA13OM4g+L17NeHKhMOIkToXlzTd5Dnf 0+BZC/z2LBiIbtCo2/tdW7l0gYKtoFTjadg9WLHq7fAcDwRJGEc2Yvmh887DuSEmwHfa YPFxejCePW7AlAGa0TK6zru/BIVAsVly9pGftCPrwINzDOV9zFRNqJhaM/TacRqo0sbk yPJ+CiU5YtSZTkvBqbLrgwiccb1wqXU0fDyWsZ7W2uE4EpkATzfWju2HifjlnHpOiaWh 8dyODTRhB+vUmdkGD3LB69exj3vrz1Tbt0KRZ0C8BNtQHqUSkB5p8UAd7JjS2x8PfaWS Tpmw== X-Forwarded-Encrypted: i=1; AJvYcCVdDHycUeRb+wjxLq/am9MIMh3BRdOaFaYBb87bPcnQ8pV9zXdILCdeQuVdVUX/n9TpFoulKKOp0XXvgme/@postgresql.org X-Gm-Message-State: AOJu0Yz/4dVwc1v7Eufg74o7KUkqMOQwURixwfmjYogBUJDg0aACx1dw Otg3L3fY+29ebME2TOMo1Diz+pShsXuGHQoOb2TvFDwCN2H5laKM+HXQcyodJxT8TfGqllig+zb VVgoKCt908ywLxWnGpTmjBlaKHFTlT2g= X-Gm-Gg: AeBDievplaZCyLprH2ew4uGAKLHDRK2j06aUFYrYTnZufXZN2E9qynGWm6RAzo0jPN2 sVULqkDFlkNtK/8WbbqmQ2ESTo1Nmzd0Z0v+07R7Kcx/nsxAJ19O0F30Dq2X/agcECAKOtXLAAP tglfN4BrrcBNhInUUHVOb/mZyRJj2Krent/l+QlW5MAiBpM0jGdl/uP7whfkLaPFXfOXV02EvDH bD6xcvDGxeMbc/HLob/mWH7xxPeaXro8JgQdNNVvYnmyBgV22X2PU2xQ+iwHRXnvIO38J1P1qzu sHdGIq2h X-Received: by 2002:a05:690c:6d84:b0:7a4:e4e5:38fb with SMTP id 00721157ae682-7af71089fddmr21616257b3.29.1775805014412; Fri, 10 Apr 2026 00:10:14 -0700 (PDT) MIME-Version: 1.0 References: <1a32fc83-df78-4774-97dc-2bb06dbb16e9@uni-muenster.de> <3529398.1774273446@sss.pgh.pa.us> <4075754.1774378690@sss.pgh.pa.us> <67637cf8-8cbf-4f86-8775-52aa0329972d@uni-muenster.de> <402bbc8d-728b-4467-8024-31c2bc101ead@uni-muenster.de> In-Reply-To: <402bbc8d-728b-4467-8024-31c2bc101ead@uni-muenster.de> From: Daniil Davydov <3danissimo@gmail.com> Date: Fri, 10 Apr 2026 14:10:02 +0700 X-Gm-Features: AQROBzA077OJ22ESlz45_oEIYL7QlppsyKxXiQCjqgWoSaPTfh75VrU7FeP4l7s Message-ID: Subject: Re: Fix bug with accessing to temporary tables of other sessions To: Jim Jones Cc: Soumya S Murali , Tom Lane , Stepan Neretin , PostgreSQL Hackers Content-Type: multipart/mixed; boundary="000000000000134e55064f15d36f" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000134e55064f15d36f Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, On Fri, Apr 10, 2026 at 12:46=E2=80=AFAM Jim Jones wrote: > > I guess a check in read_stream_begin_relation() > and in StartReadBuffersImpl() would be the best solution? If you agree, > could you add it in v16? Having both checks might look a bit redundant since the read stream will eventually call the StartReadBuffersImpl function. On the other hand, there= are many places which are checking this restriction even if subsequent function= s (from bufmgr) also have this check. So, I'll keep both checks and a bit reduce the comments in the bufmgr.c . BTW, what do you think about making this comment less "concrete"? : # SELECT via index scan from other session. # Sequential scans are blocked at read_stream_begin_relation(); index scans # bypass that path entirely and reach ReadBufferExtended() in bufmgr.c # (nbtree's _bt_getbuf calls ReadBuffer directly for individual page fetche= s). # enable_seqscan=3Doff forces the planner to use the index. I mean that if the described logic changes, this comment will become confus= ing. We can describe the test in general words. For example : # Index scans can use a different code path from the one sequential scans a= re # following. Make sure that we cannot access other sessions' temp tables du= ring # index scan either. Thank you for the comments! Please, see an updated set of patches. -- Best regards, Daniil Davydov --000000000000134e55064f15d36f Content-Type: text/x-patch; charset="US-ASCII"; name="v16-0002-Test-cross-session-access-on-temporary-tables.patch" Content-Disposition: attachment; filename="v16-0002-Test-cross-session-access-on-temporary-tables.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_mnsjxwqz0 RnJvbSAwN2RkNWVjZDIwNDQyMDY3OGExMDBiNjRhMDEzNDcyMjdmNGZlZjRmIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBKaW0gSm9uZXMgPGppbS5qb25lc0B1bmktbXVlbnN0ZXIuZGU+ CkRhdGU6IFdlZCwgOCBBcHIgMjAyNiAxNDo1Njo1NyArMDIwMApTdWJqZWN0OiBbUEFUQ0ggdjE2 IDIvMl0gVGVzdCBjcm9zcy1zZXNzaW9uIGFjY2VzcyBvbiB0ZW1wb3JhcnkgdGFibGVzCgotLS0K IHNyYy90ZXN0L21vZHVsZXMvdGVzdF9taXNjL21lc29uLmJ1aWxkICAgICAgICB8ICAgMSArCiAu Li4vdGVzdF9taXNjL3QvMDEyX3RlbXBfb2JqX211bHRpc2Vzc2lvbi5wbCAgfCAxMTcgKysrKysr KysrKysrKysrKysrCiAyIGZpbGVzIGNoYW5nZWQsIDExOCBpbnNlcnRpb25zKCspCiBjcmVhdGUg bW9kZSAxMDA2NDQgc3JjL3Rlc3QvbW9kdWxlcy90ZXN0X21pc2MvdC8wMTJfdGVtcF9vYmpfbXVs dGlzZXNzaW9uLnBsCgpkaWZmIC0tZ2l0IGEvc3JjL3Rlc3QvbW9kdWxlcy90ZXN0X21pc2MvbWVz b24uYnVpbGQgYi9zcmMvdGVzdC9tb2R1bGVzL3Rlc3RfbWlzYy9tZXNvbi5idWlsZAppbmRleCAx YjI1ZDk4ZjdmMy4uYTU0NTk5Y2MzMDEgMTAwNjQ0Ci0tLSBhL3NyYy90ZXN0L21vZHVsZXMvdGVz dF9taXNjL21lc29uLmJ1aWxkCisrKyBiL3NyYy90ZXN0L21vZHVsZXMvdGVzdF9taXNjL21lc29u LmJ1aWxkCkBAIC0yMCw2ICsyMCw3IEBAIHRlc3RzICs9IHsKICAgICAgICd0LzAwOV9sb2dfdGVt cF9maWxlcy5wbCcsCiAgICAgICAndC8wMTBfaW5kZXhfY29uY3VycmVudGx5X3Vwc2VydC5wbCcs CiAgICAgICAndC8wMTFfbG9ja19zdGF0cy5wbCcsCisgICAgICAndC8wMTJfdGVtcF9vYmpfbXVs dGlzZXNzaW9uLnBsJywKICAgICBdLAogICAgICMgVGhlIGluamVjdGlvbiBwb2ludHMgYXJlIGNs dXN0ZXItd2lkZSwgc28gZGlzYWJsZSBpbnN0YWxsY2hlY2sKICAgICAncnVubmluZ2NoZWNrJzog ZmFsc2UsCmRpZmYgLS1naXQgYS9zcmMvdGVzdC9tb2R1bGVzL3Rlc3RfbWlzYy90LzAxMl90ZW1w X29ial9tdWx0aXNlc3Npb24ucGwgYi9zcmMvdGVzdC9tb2R1bGVzL3Rlc3RfbWlzYy90LzAxMl90 ZW1wX29ial9tdWx0aXNlc3Npb24ucGwKbmV3IGZpbGUgbW9kZSAxMDA2NDQKaW5kZXggMDAwMDAw MDAwMDAuLjRkNTk5MTUyNzQwCi0tLSAvZGV2L251bGwKKysrIGIvc3JjL3Rlc3QvbW9kdWxlcy90 ZXN0X21pc2MvdC8wMTJfdGVtcF9vYmpfbXVsdGlzZXNzaW9uLnBsCkBAIC0wLDAgKzEsMTE3IEBA CisjIENvcHlyaWdodCAoYykgMjAyNiwgUG9zdGdyZVNRTCBHbG9iYWwgRGV2ZWxvcG1lbnQgR3Jv dXAKKwordXNlIHN0cmljdDsKK3VzZSB3YXJuaW5nczsKK3VzZSBQb3N0Z3JlU1FMOjpUZXN0OjpD bHVzdGVyOwordXNlIFBvc3RncmVTUUw6OlRlc3Q6OlV0aWxzOwordXNlIFBvc3RncmVTUUw6OlRl c3Q6OkJhY2tncm91bmRQc3FsOwordXNlIFRlc3Q6Ok1vcmU7CisKKyMgU2V0IHVwIGEgZnJlc2gg bm9kZQorbXkgJG5vZGUgPSBQb3N0Z3JlU1FMOjpUZXN0OjpDbHVzdGVyLT5uZXcoJ3RlbXBfbG9j aycpOworJG5vZGUtPmluaXQ7Ciskbm9kZS0+c3RhcnQ7CisKKyMgQ3JlYXRlIGEgbG9uZy1saXZl ZCBzZXNzaW9uCitteSAkcHNxbDEgPSAkbm9kZS0+YmFja2dyb3VuZF9wc3FsKCdwb3N0Z3Jlcycp OworCiskcHNxbDEtPnF1ZXJ5X3NhZmUoCisJcShDUkVBVEUgVEVNUCBUQUJMRSBmb28gQVMgU0VM RUNUIDQyIEFTIHZhbDspKTsKKworIyBDcmVhdGUgYW4gaW5kZXggc28gdGhlIGluZGV4LXNjYW4g cGF0aCAoUmVhZEJ1ZmZlckV4dGVuZGVkKSBjYW4gYmUgdGVzdGVkCiskcHNxbDEtPnF1ZXJ5X3Nh ZmUoCisJcShDUkVBVEUgSU5ERVggT04gZm9vKHZhbCk7KSk7CisKK215ICR0ZW1wc2NoZW1hID0g JG5vZGUtPnNhZmVfcHNxbCgKKyAgICAncG9zdGdyZXMnLAorICAgIHF7CisgICAgICBTRUxFQ1Qg bi5uc3BuYW1lCisgICAgICBGUk9NIHBnX2NsYXNzIGMKKyAgICAgIEpPSU4gcGdfbmFtZXNwYWNl IG4gT04gbi5vaWQgPSBjLnJlbG5hbWVzcGFjZQorICAgICAgV0hFUkUgcmVsbmFtZSA9ICdmb28n IEFORCByZWxwZXJzaXN0ZW5jZSA9ICd0JzsKKyAgICB9CispOworY2hvbXAgJHRlbXBzY2hlbWE7 CitvaygkdGVtcHNjaGVtYSA9fiAvXnBnX3RlbXBfXGQrJC8sICJnb3QgdGVtcCBzY2hlbWE6ICR0 ZW1wc2NoZW1hIik7CisKKworIyBTRUxFQ1QgVEVNUE9SQVJZIFRBQkxFIGZyb20gb3RoZXIgc2Vz c2lvbgorbXkgKCRzdGRvdXQsICRzdGRlcnIpOworJG5vZGUtPnBzcWwoCisgICAgJ3Bvc3RncmVz JywKKyAgICAiU0VMRUNUIHZhbCBGUk9NICR0ZW1wc2NoZW1hLmZvbzsiLAorICAgIHN0ZG91dCA9 PiBcJHN0ZG91dCwKKyAgICBzdGRlcnIgPT4gXCRzdGRlcnIKKyk7CitsaWtlKCRzdGRlcnIsIHFy L2Nhbm5vdCBhY2Nlc3MgdGVtcG9yYXJ5IHJlbGF0aW9ucyBvZiBvdGhlciBzZXNzaW9ucy8sCisg ICAgICdTRUxFQ1Qgb24gb3RoZXIgc2Vzc2lvbiB0ZW1wIHRhYmxlIGlzIG5vdCBhbGxvd2VkJyk7 CisKKyMgVVBEQVRFIFRFTVBPUkFSWSBUQUJMRSBmcm9tIG90aGVyIHNlc3Npb24KKyRub2RlLT5w c3FsKAorICAgICdwb3N0Z3JlcycsCisgICAgIlVQREFURSAkdGVtcHNjaGVtYS5mb28gU0VUIHZh bCA9IE5VTEw7IiwKKyAgICBzdGRlcnIgPT4gXCRzdGRlcnIKKyk7CitsaWtlKCRzdGRlcnIsIHFy L2Nhbm5vdCBhY2Nlc3MgdGVtcG9yYXJ5IHJlbGF0aW9ucyBvZiBvdGhlciBzZXNzaW9ucy8sCisg ICAgICdVUERBVEUgb24gb3RoZXIgc2Vzc2lvbiB0ZW1wIHRhYmxlIGlzIG5vdCBhbGxvd2VkJyk7 CisKKyMgREVMRVRFIHJlY29yZHMgZnJvbSBURU1QT1JBUlkgVEFCTEUgZnJvbSBvdGhlciBzZXNz aW9uCiskbm9kZS0+cHNxbCgKKyAgICAncG9zdGdyZXMnLAorICAgICJERUxFVEUgRlJPTSAkdGVt cHNjaGVtYS5mb287IiwKKyAgICBzdGRlcnIgPT4gXCRzdGRlcnIKKyk7CitsaWtlKCRzdGRlcnIs IHFyL2Nhbm5vdCBhY2Nlc3MgdGVtcG9yYXJ5IHJlbGF0aW9ucyBvZiBvdGhlciBzZXNzaW9ucy8s CisgICAgICdERUxFVEUgb24gb3RoZXIgc2Vzc2lvbiB0ZW1wIHRhYmxlIGlzIG5vdCBhbGxvd2Vk Jyk7CisKKyMgVFJVTkNBVEUgVEVNUE9SQVJZIFRBQkxFIGZyb20gb3RoZXIgc2Vzc2lvbgorJG5v ZGUtPnBzcWwoCisgICAgJ3Bvc3RncmVzJywKKyAgICAiVFJVTkNBVEUgVEFCTEUgJHRlbXBzY2hl bWEuZm9vOyIsCisgICAgc3RkZXJyID0+IFwkc3RkZXJyCispOworbGlrZSgkc3RkZXJyLCBxci9j YW5ub3QgdHJ1bmNhdGUgdGVtcG9yYXJ5IHRhYmxlcyBvZiBvdGhlciBzZXNzaW9ucy8sCisgICAg ICdUUlVOQ0FURSBvbiBvdGhlciBzZXNzaW9uIHRlbXAgdGFibGUgaXMgbm90IGFsbG93ZWQnKTsK KworIyBJTlNFUlQgSU5UTyBURU1QT1JBUlkgVEFCTEUgZnJvbSBvdGhlciBzZXNzaW9uCiskbm9k ZS0+cHNxbCgKKyAgICAncG9zdGdyZXMnLAorICAgICJJTlNFUlQgSU5UTyAkdGVtcHNjaGVtYS5m b28gVkFMVUVTICg3Myk7IiwKKyAgICBzdGRlcnIgPT4gXCRzdGRlcnIKKyk7CitsaWtlKCRzdGRl cnIsIHFyL2Nhbm5vdCBhY2Nlc3MgdGVtcG9yYXJ5IHJlbGF0aW9ucyBvZiBvdGhlciBzZXNzaW9u cy8sCisgICAgICdJTlNFUlQgSU5UTyBvbiBvdGhlciBzZXNzaW9uIHRlbXAgdGFibGUgaXMgbm90 IGFsbG93ZWQnKTsKKworIyBDT1BZIFRFTVBPUkFSWSBUQUJMRSBmcm9tIG90aGVyIHNlc3Npb24K KyRub2RlLT5wc3FsKAorICAgICdwb3N0Z3JlcycsCisgICAgIkNPUFkgJHRlbXBzY2hlbWEuZm9v IFRPIFNURE9VVDsiLAorICAgIHN0ZGVyciA9PiBcJHN0ZGVycgorKTsKK2xpa2UoJHN0ZGVyciwg cXIvY2Fubm90IGFjY2VzcyB0ZW1wb3JhcnkgcmVsYXRpb25zIG9mIG90aGVyIHNlc3Npb25zLywK KyAgICAgJ0NPUFkgb24gb3RoZXIgc2Vzc2lvbiB0ZW1wIHRhYmxlIGlzIGJsb2NrZWQnKTsKKwor IyBTRUxFQ1QgdmlhIGluZGV4IHNjYW4gZnJvbSBvdGhlciBzZXNzaW9uLgorIyBTZXF1ZW50aWFs IHNjYW5zIGFyZSBibG9ja2VkIGF0IHJlYWRfc3RyZWFtX2JlZ2luX3JlbGF0aW9uKCk7IGluZGV4 IHNjYW5zCisjIGJ5cGFzcyB0aGF0IHBhdGggZW50aXJlbHkgYW5kIHJlYWNoIFJlYWRCdWZmZXJF eHRlbmRlZCgpIGluIGJ1Zm1nci5jCisjIChuYnRyZWUncyBfYnRfZ2V0YnVmIGNhbGxzIFJlYWRC dWZmZXIgZGlyZWN0bHkgZm9yIGluZGl2aWR1YWwgcGFnZSBmZXRjaGVzKS4KKyMgZW5hYmxlX3Nl cXNjYW49b2ZmIGZvcmNlcyB0aGUgcGxhbm5lciB0byB1c2UgdGhlIGluZGV4LgorJG5vZGUtPnBz cWwoCisgICAgJ3Bvc3RncmVzJywKKyAgICAiU0VUIGVuYWJsZV9zZXFzY2FuID0gb2ZmOyBTRUxF Q1QgdmFsIEZST00gJHRlbXBzY2hlbWEuZm9vIFdIRVJFIHZhbCA9IDQyOyIsCisgICAgc3RkZXJy ID0+IFwkc3RkZXJyCispOworbGlrZSgkc3RkZXJyLCBxci9jYW5ub3QgYWNjZXNzIHRlbXBvcmFy eSByZWxhdGlvbnMgb2Ygb3RoZXIgc2Vzc2lvbnMvLAorICAgICAnaW5kZXggc2NhbiBvbiBvdGhl ciBzZXNzaW9uIHRlbXAgdGFibGUgaXMgbm90IGFsbG93ZWQgKGV4ZXJjaXNlcyBSZWFkQnVmZmVy RXh0ZW5kZWQgcGF0aCknKTsKKworIyBEUk9QIFRFTVBPUkFSWSBUQUJMRSBmcm9tIG90aGVyIHNl c3Npb24KK215ICRvayA9ICRub2RlLT5wc3FsKAorICAgICdwb3N0Z3JlcycsCisgICAgIkRST1Ag VEFCTEUgJHRlbXBzY2hlbWEuZm9vOyIKKyk7Citvaygkb2sgPT0gMCwgJ0RST1AgVEFCTEUgZXhl Y3V0ZWQgc3VjY2Vzc2Z1bGx5Jyk7CisKKyMgQ2xlYW4gdXAKKyRwc3FsMS0+cXVpdDsKKworZG9u ZV90ZXN0aW5nKCk7Ci0tIAoyLjQzLjAKCg== --000000000000134e55064f15d36f Content-Type: text/x-patch; charset="US-ASCII"; name="v16-0001-Prevent-access-to-other-sessions-temp-tables.patch" Content-Disposition: attachment; filename="v16-0001-Prevent-access-to-other-sessions-temp-tables.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_mnsjxwrb1 RnJvbSA2YjI1YjMwYmM5ODFkZDY0MjA3ODgwMTRmYWNlMTRhMTNiYjk0NjFkIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBEYW5paWwgRGF2aWRvdiA8ZC5kYXZ5ZG92QHBvc3RncmVzcHJv LnJ1PgpEYXRlOiBGcmksIDEwIEFwciAyMDI2IDEzOjUxOjE0ICswNzAwClN1YmplY3Q6IFtQQVRD SCB2MTYgMS8yXSBQcmV2ZW50IGFjY2VzcyB0byBvdGhlciBzZXNzaW9ucycgdGVtcCB0YWJsZXMK Ci0tLQogc3JjL2JhY2tlbmQvc3RvcmFnZS9haW8vcmVhZF9zdHJlYW0uYyB8IDEwICsrKysrKysr KysKIHNyYy9iYWNrZW5kL3N0b3JhZ2UvYnVmZmVyL2J1Zm1nci5jICAgfCAxNyArKysrKysrKysr KysrKystLQogMiBmaWxlcyBjaGFuZ2VkLCAyNSBpbnNlcnRpb25zKCspLCAyIGRlbGV0aW9ucygt KQoKZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL3N0b3JhZ2UvYWlvL3JlYWRfc3RyZWFtLmMgYi9z cmMvYmFja2VuZC9zdG9yYWdlL2Fpby9yZWFkX3N0cmVhbS5jCmluZGV4IGI2ZmNlNGU3Y2M2Li4y MTNmNjIwNmJhMiAxMDA2NDQKLS0tIGEvc3JjL2JhY2tlbmQvc3RvcmFnZS9haW8vcmVhZF9zdHJl YW0uYworKysgYi9zcmMvYmFja2VuZC9zdG9yYWdlL2Fpby9yZWFkX3N0cmVhbS5jCkBAIC03NzYs NiArNzc2LDE2IEBAIHJlYWRfc3RyZWFtX2JlZ2luX2ltcGwoaW50IGZsYWdzLAogCXVpbnQzMgkJ bWF4X3Bvc3NpYmxlX2J1ZmZlcl9saW1pdDsKIAlPaWQJCQl0YWJsZXNwYWNlX2lkOwogCisJLyoK KwkgKiBSZWplY3QgYXR0ZW1wdHMgdG8gcmVhZCBub24tbG9jYWwgdGVtcG9yYXJ5IHJlbGF0aW9u czsgd2Ugd291bGQgYmUKKwkgKiBsaWtlbHkgdG8gZ2V0IHdyb25nIGRhdGEgc2luY2Ugd2UgaGF2 ZSBubyB2aXNpYmlsaXR5IGludG8gdGhlIG93bmluZworCSAqIHNlc3Npb24ncyBsb2NhbCBidWZm ZXJzLgorCSAqLworCWlmIChyZWwgJiYgUkVMQVRJT05fSVNfT1RIRVJfVEVNUChyZWwpKQorCQll cmVwb3J0KEVSUk9SLAorCQkJCShlcnJjb2RlKEVSUkNPREVfRkVBVFVSRV9OT1RfU1VQUE9SVEVE KSwKKwkJCQkgZXJybXNnKCJjYW5ub3QgYWNjZXNzIHRlbXBvcmFyeSByZWxhdGlvbnMgb2Ygb3Ro ZXIgc2Vzc2lvbnMiKSkpOworCiAJLyoKIAkgKiBEZWNpZGUgaG93IG1hbnkgSS9PcyB3ZSB3aWxs IGFsbG93IHRvIHJ1biBhdCB0aGUgc2FtZSB0aW1lLiAgVGhhdAogCSAqIGN1cnJlbnRseSBtZWFu cyBhZHZpY2UgdG8gdGhlIGtlcm5lbCB0byB0ZWxsIGl0IHRoYXQgd2Ugd2lsbCBzb29uIHJlYWQu CmRpZmYgLS1naXQgYS9zcmMvYmFja2VuZC9zdG9yYWdlL2J1ZmZlci9idWZtZ3IuYyBiL3NyYy9i YWNrZW5kL3N0b3JhZ2UvYnVmZmVyL2J1Zm1nci5jCmluZGV4IDNjYzBiMGJkZDkyLi42NTMyNzgx NDBmYiAxMDA2NDQKLS0tIGEvc3JjL2JhY2tlbmQvc3RvcmFnZS9idWZmZXIvYnVmbWdyLmMKKysr IGIvc3JjL2JhY2tlbmQvc3RvcmFnZS9idWZmZXIvYnVmbWdyLmMKQEAgLTc5NSw3ICs3OTUsNyBA QCBQcmVmZXRjaEJ1ZmZlcihSZWxhdGlvbiByZWxuLCBGb3JrTnVtYmVyIGZvcmtOdW0sIEJsb2Nr TnVtYmVyIGJsb2NrTnVtKQogCQlpZiAoUkVMQVRJT05fSVNfT1RIRVJfVEVNUChyZWxuKSkKIAkJ CWVyZXBvcnQoRVJST1IsCiAJCQkJCShlcnJjb2RlKEVSUkNPREVfRkVBVFVSRV9OT1RfU1VQUE9S VEVEKSwKLQkJCQkJIGVycm1zZygiY2Fubm90IGFjY2VzcyB0ZW1wb3JhcnkgdGFibGVzIG9mIG90 aGVyIHNlc3Npb25zIikpKTsKKwkJCQkJIGVycm1zZygiY2Fubm90IGFjY2VzcyB0ZW1wb3Jhcnkg cmVsYXRpb25zIG9mIG90aGVyIHNlc3Npb25zIikpKTsKIAogCQkvKiBwYXNzIGl0IG9mZiB0byBs b2NhbGJ1Zi5jICovCiAJCXJldHVybiBQcmVmZXRjaExvY2FsQnVmZmVyKFJlbGF0aW9uR2V0U21n cihyZWxuKSwgZm9ya051bSwgYmxvY2tOdW0pOwpAQCAtOTM2LDcgKzkzNiw3IEBAIFJlYWRCdWZm ZXJFeHRlbmRlZChSZWxhdGlvbiByZWxuLCBGb3JrTnVtYmVyIGZvcmtOdW0sIEJsb2NrTnVtYmVy IGJsb2NrTnVtLAogCWlmIChSRUxBVElPTl9JU19PVEhFUl9URU1QKHJlbG4pKQogCQllcmVwb3J0 KEVSUk9SLAogCQkJCShlcnJjb2RlKEVSUkNPREVfRkVBVFVSRV9OT1RfU1VQUE9SVEVEKSwKLQkJ CQkgZXJybXNnKCJjYW5ub3QgYWNjZXNzIHRlbXBvcmFyeSB0YWJsZXMgb2Ygb3RoZXIgc2Vzc2lv bnMiKSkpOworCQkJCSBlcnJtc2coImNhbm5vdCBhY2Nlc3MgdGVtcG9yYXJ5IHJlbGF0aW9ucyBv ZiBvdGhlciBzZXNzaW9ucyIpKSk7CiAKIAkvKgogCSAqIFJlYWQgdGhlIGJ1ZmZlciwgYW5kIHVw ZGF0ZSBwZ3N0YXQgY291bnRlcnMgdG8gcmVmbGVjdCBhIGNhY2hlIGhpdCBvcgpAQCAtMTMxNyw2 ICsxMzE3LDEyIEBAIFJlYWRCdWZmZXJfY29tbW9uKFJlbGF0aW9uIHJlbCwgU01nclJlbGF0aW9u IHNtZ3IsIGNoYXIgc21ncl9wZXJzaXN0ZW5jZSwKIAllbHNlCiAJCXBlcnNpc3RlbmNlID0gc21n cl9wZXJzaXN0ZW5jZTsKIAorCS8qIHNlZSBjb21tZW50cyBpbiBSZWFkQnVmZmVyRXh0ZW5kZWQg Ki8KKwlpZiAocmVsICE9IE5VTEwgJiYgUkVMQVRJT05fSVNfT1RIRVJfVEVNUChyZWwpKQorCQll cmVwb3J0KEVSUk9SLAorCQkJCShlcnJjb2RlKEVSUkNPREVfRkVBVFVSRV9OT1RfU1VQUE9SVEVE KSwKKwkJCQkgZXJybXNnKCJjYW5ub3QgYWNjZXNzIHRlbXBvcmFyeSByZWxhdGlvbnMgb2Ygb3Ro ZXIgc2Vzc2lvbnMiKSkpOworCiAJaWYgKHVubGlrZWx5KG1vZGUgPT0gUkJNX1pFUk9fQU5EX0NM RUFOVVBfTE9DSyB8fAogCQkJCSBtb2RlID09IFJCTV9aRVJPX0FORF9MT0NLKSkKIAl7CkBAIC0x MzkzLDYgKzEzOTksMTMgQEAgU3RhcnRSZWFkQnVmZmVyc0ltcGwoUmVhZEJ1ZmZlcnNPcGVyYXRp b24gKm9wZXJhdGlvbiwKIAkJaW9fb2JqZWN0ID0gSU9PQkpFQ1RfUkVMQVRJT047CiAJfQogCisK KwkvKiBzZWUgY29tbWVudHMgaW4gUmVhZEJ1ZmZlckV4dGVuZGVkICovCisJaWYgKG9wZXJhdGlv bi0+cmVsICE9IE5VTEwgJiYgUkVMQVRJT05fSVNfT1RIRVJfVEVNUChvcGVyYXRpb24tPnJlbCkp CisJCWVyZXBvcnQoRVJST1IsCisJCQkJKGVycmNvZGUoRVJSQ09ERV9GRUFUVVJFX05PVF9TVVBQ T1JURUQpLAorCQkJCSBlcnJtc2coImNhbm5vdCBhY2Nlc3MgdGVtcG9yYXJ5IHJlbGF0aW9ucyBv ZiBvdGhlciBzZXNzaW9ucyIpKSk7CisKIAlmb3IgKGludCBpID0gMDsgaSA8IGFjdHVhbF9uYmxv Y2tzOyArK2kpCiAJewogCQlib29sCQlmb3VuZDsKLS0gCjIuNDMuMAoK --000000000000134e55064f15d36f--