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 1kkQio-0008AO-9a for pgsql-hackers@arkaria.postgresql.org; Wed, 02 Dec 2020 11:54:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kkQin-0004rM-7T for pgsql-hackers@arkaria.postgresql.org; Wed, 02 Dec 2020 11:54:57 +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 1kkQim-0004rF-2v for pgsql-hackers@lists.postgresql.org; Wed, 02 Dec 2020 11:54:57 +0000 Received: from forward1-smtp.messagingengine.com ([66.111.4.223]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kkQii-0000at-N6 for pgsql-hackers@postgresql.org; Wed, 02 Dec 2020 11:54:54 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailforward.nyi.internal (Postfix) with ESMTP id 5AFC619433E1 for ; Wed, 2 Dec 2020 06:54:51 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Wed, 02 Dec 2020 06:54:51 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-type:date:from:message-id :mime-version:subject:to:x-me-proxy:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm1; bh=/J4764LhHShaIlRERH8q5QBV8655k Yuf4T3NqvSWiBM=; b=q7YQFi2b9mlYzmUaYOLKNcLRtztMuxjNuSCpRB7WMmbUQ t3WFje8VE7JQKTER5pJrSon1KzFYsUYPFcbh+bat12mv2iS7qkHSFaE86J9ax+FD bvyh4yRECuMHqBR2w7q30okleAvQsimmreOM2pl+u9Bs/oOf9IdvN8M4msK5Er1g YZMNKMFwtV0z9XfZGsA/ln1flF40nOcgsfDvJVC+7b3hfZDiNRvhD+7ue10HM7vu bAYyadO6XZJ11EtUYcQACH+wVZaKJGySyb7RSnFHebzjo+Yw7hAEZKOKTaItiBQB hD9Rkwqi6twBHbY+RBI3dzL08ECfMpeQt9twH4h2w== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedujedrudeigedgfeehucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucenucfjughrpefhuffvohfkffgfgggtsehmtderre dtfeejnecuhfhrohhmpefrvghtvghrucfgihhsvghnthhrrghuthcuoehpvghtvghrrdgv ihhsvghnthhrrghuthesvghnthgvrhhprhhishgvuggsrdgtohhmqeenucggtffrrghtth gvrhhnpedvheekvdeggeelueehjefgkeeugeegjefgfeeggedtveehvefgtdefhffgtdfg vdenucfkphepkeejrddujeejrdejtddrudduudenucevlhhushhtvghrufhiiigvpedtne curfgrrhgrmhepmhgrihhlfhhrohhmpehpvghtvghrrdgvihhsvghnthhrrghuthesvghn thgvrhhprhhishgvuggsrdgtohhm X-ME-Proxy: Received: from april.pezone.net (p57b1466f.dip0.t-ipconnect.de [87.177.70.111]) by mail.messagingengine.com (Postfix) with ESMTPA id 4A31A1080063 for ; Wed, 2 Dec 2020 06:54:50 -0500 (EST) From: Peter Eisentraut Subject: SELECT INTO deprecation To: pgsql-hackers Organization: EnterpriseDB Message-ID: <96dc0df3-e13a-a85d-d045-d6e2c85218da@enterprisedb.com> Date: Wed, 2 Dec 2020 12:54:48 +0100 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="------------0E77FB5E87E724730B57A0B3" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------0E77FB5E87E724730B57A0B3 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit While reading about deprecating and removing various things in other threads, I was wondering about how deprecated SELECT INTO is. There are various source code comments about this, but the SELECT INTO reference page only contains soft language like "recommended". I'm proposing the attached patch to stick a more explicit deprecation notice right at the top. I also found some gratuitous uses of SELECT INTO in various tests and documentation (not ecpg or plpgsql of course). Here is a patch to adjust those to CREATE TABLE AS. I don't have a specific plan for removing top-level SELECT INTO altogether, but there is a nontrivial amount of code for handling it, so there would be some gain if it could be removed eventually. --------------0E77FB5E87E724730B57A0B3 Content-Type: text/plain; charset=UTF-8; x-mac-type="0"; x-mac-creator="0"; name="0001-Remove-gratuitous-uses-of-deprecated-SELECT-INTO.patch" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename*0="0001-Remove-gratuitous-uses-of-deprecated-SELECT-INTO.patch" RnJvbSBhM2FlNDI0ODM0MDMxN2FjMTU4MGMyNTc0NzJlMTM2MTg0MWJkNGIyIE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBQZXRlciBFaXNlbnRyYXV0IDxwZXRlckBlaXNlbnRy YXV0Lm9yZz4KRGF0ZTogV2VkLCAyIERlYyAyMDIwIDEyOjA5OjM5ICswMTAwClN1YmplY3Q6 IFtQQVRDSCAxLzJdIFJlbW92ZSBncmF0dWl0b3VzIHVzZXMgb2YgZGVwcmVjYXRlZCBTRUxF Q1QgSU5UTwoKQ1JFQVRFIFRBQkxFIEFTIGhhcyBiZWVuIHByZWZlcnJlZCBvdmVyIFNFTEVD VCBJTlRPIChvdXRzaWRlIG9mIGVjcGcKYW5kIFBML3BnU1FMKSBmb3IgYSBsb25nIHRpbWUu ICBUaGVyZSB3ZXJlIHN0aWxsIGEgZmV3IHVzZXMgb2YgU0VMRUNUCklOVE8gaW4gdGVzdHMg YW5kIGRvY3VtZW50YXRpb24sIHNvbWUgb2xkLCBzb21lIG1vcmUgcmVjZW50LiAgVGhpcwpj aGFuZ2VzIHRoZW0gdG8gQ1JFQVRFIFRBQkxFIEFTLiAgU29tZSBvY2N1cnJlbmNlcyBpbiB0 aGUgdGVzdHMgcmVtYWluCndoZXJlIHRoZXkgYXJlIHNwZWNpZmljYWxseSB0ZXN0aW5nIFNF TEVDVCBJTlRPIHBhcnNpbmcgb3Igc2ltaWxhci4KLS0tCiBjb250cmliL3NlcGdzcWwvZXhw ZWN0ZWQvbGFiZWwub3V0ICAgICAgICAgICAgICB8IDIgKy0KIGNvbnRyaWIvc2VwZ3NxbC9z cWwvbGFiZWwuc3FsICAgICAgICAgICAgICAgICAgIHwgMiArLQogZG9jL3NyYy9zZ21sL2hz dG9yZS5zZ21sICAgICAgICAgICAgICAgICAgICAgICAgfCAyICstCiBzcmMvYmluL3BnX2Jh c2ViYWNrdXAvdC8wMTBfcGdfYmFzZWJhY2t1cC5wbCAgICB8IDQgKystLQogc3JjL2Jpbi9w Z19jaGVja3N1bXMvdC8wMDJfYWN0aW9ucy5wbCAgICAgICAgICAgfCAyICstCiBzcmMvdGVz dC9yZWdyZXNzL2V4cGVjdGVkL2NyZWF0ZV9pbmRleC5vdXQgICAgICB8IDIgKy0KIHNyYy90 ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvY3JlYXRlX21pc2Mub3V0ICAgICAgIHwgMiArLQogc3Jj L3Rlc3QvcmVncmVzcy9leHBlY3RlZC9yYW5kb20ub3V0ICAgICAgICAgICAgfCAzICsrLQog c3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9zZWxlY3RfaW1wbGljaXQub3V0ICAgfCA2ICsr KystLQogc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9zZWxlY3RfaW1wbGljaXRfMS5vdXQg fCA2ICsrKystLQogc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9zZWxlY3RfaW1wbGljaXRf Mi5vdXQgfCA2ICsrKystLQogc3JjL3Rlc3QvcmVncmVzcy9zcWwvY3JlYXRlX2luZGV4LnNx bCAgICAgICAgICAgfCAyICstCiBzcmMvdGVzdC9yZWdyZXNzL3NxbC9jcmVhdGVfbWlzYy5z cWwgICAgICAgICAgICB8IDIgKy0KIHNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3JhbmRvbS5zcWwg ICAgICAgICAgICAgICAgIHwgMyArKy0KIHNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3NlbGVjdF9p bXBsaWNpdC5zcWwgICAgICAgIHwgNiArKysrLS0KIDE1IGZpbGVzIGNoYW5nZWQsIDMwIGlu c2VydGlvbnMoKyksIDIwIGRlbGV0aW9ucygtKQoKZGlmZiAtLWdpdCBhL2NvbnRyaWIvc2Vw Z3NxbC9leHBlY3RlZC9sYWJlbC5vdXQgYi9jb250cmliL3NlcGdzcWwvZXhwZWN0ZWQvbGFi ZWwub3V0CmluZGV4IDAzMDBiYzZmYjQuLmIxYjdkYjU1ZjYgMTAwNjQ0Ci0tLSBhL2NvbnRy aWIvc2VwZ3NxbC9leHBlY3RlZC9sYWJlbC5vdXQKKysrIGIvY29udHJpYi9zZXBnc3FsL2V4 cGVjdGVkL2xhYmVsLm91dApAQCAtNiw3ICs2LDcgQEAKIC0tCiBDUkVBVEUgVEFCTEUgdDEg KGEgaW50LCBiIHRleHQpOwogSU5TRVJUIElOVE8gdDEgVkFMVUVTICgxLCAnYWFhJyksICgy LCAnYmJiJyksICgzLCAnY2NjJyk7Ci1TRUxFQ1QgKiBJTlRPIHQyIEZST00gdDEgV0hFUkUg YSAlIDIgPSAwOworQ1JFQVRFIFRBQkxFIHQyIEFTIFNFTEVDVCAqIEZST00gdDEgV0hFUkUg YSAlIDIgPSAwOwogQ1JFQVRFIEZVTkNUSU9OIGYxICgpIFJFVFVSTlMgdGV4dAogICAgIEFT ICdTRUxFQ1Qgc2VwZ3NxbF9nZXRjb24oKScKICAgICBMQU5HVUFHRSBzcWw7CmRpZmYgLS1n aXQgYS9jb250cmliL3NlcGdzcWwvc3FsL2xhYmVsLnNxbCBiL2NvbnRyaWIvc2VwZ3NxbC9z cWwvbGFiZWwuc3FsCmluZGV4IGQxOWM2ZWRiNGMuLjc2ZTI2MWJlZTggMTAwNjQ0Ci0tLSBh L2NvbnRyaWIvc2VwZ3NxbC9zcWwvbGFiZWwuc3FsCisrKyBiL2NvbnRyaWIvc2VwZ3NxbC9z cWwvbGFiZWwuc3FsCkBAIC03LDcgKzcsNyBAQAogLS0KIENSRUFURSBUQUJMRSB0MSAoYSBp bnQsIGIgdGV4dCk7CiBJTlNFUlQgSU5UTyB0MSBWQUxVRVMgKDEsICdhYWEnKSwgKDIsICdi YmInKSwgKDMsICdjY2MnKTsKLVNFTEVDVCAqIElOVE8gdDIgRlJPTSB0MSBXSEVSRSBhICUg MiA9IDA7CitDUkVBVEUgVEFCTEUgdDIgQVMgU0VMRUNUICogRlJPTSB0MSBXSEVSRSBhICUg MiA9IDA7CiAKIENSRUFURSBGVU5DVElPTiBmMSAoKSBSRVRVUk5TIHRleHQKICAgICBBUyAn U0VMRUNUIHNlcGdzcWxfZ2V0Y29uKCknCmRpZmYgLS1naXQgYS9kb2Mvc3JjL3NnbWwvaHN0 b3JlLnNnbWwgYi9kb2Mvc3JjL3NnbWwvaHN0b3JlLnNnbWwKaW5kZXggMTRhMzZhZGUwMC4u MjU5MDRkOTU2MiAxMDA2NDQKLS0tIGEvZG9jL3NyYy9zZ21sL2hzdG9yZS5zZ21sCisrKyBi L2RvYy9zcmMvc2dtbC9oc3RvcmUuc2dtbApAQCAtODQxLDcgKzg0MSw3IEBAIDx0aXRsZT5T dGF0aXN0aWNzPC90aXRsZT4KICAgPHBhcmE+CiAgICBVc2luZyBhIHRhYmxlOgogPHByb2dy YW1saXN0aW5nPgotU0VMRUNUIChlYWNoKGgpKS5rZXksIChlYWNoKGgpKS52YWx1ZSBJTlRP IHN0YXQgRlJPTSB0ZXN0aHN0b3JlOworQ1JFQVRFIFRBQkxFIHN0YXQgQVMgU0VMRUNUIChl YWNoKGgpKS5rZXksIChlYWNoKGgpKS52YWx1ZSBGUk9NIHRlc3Roc3RvcmU7CiA8L3Byb2dy YW1saXN0aW5nPgogICA8L3BhcmE+CiAKZGlmZiAtLWdpdCBhL3NyYy9iaW4vcGdfYmFzZWJh Y2t1cC90LzAxMF9wZ19iYXNlYmFja3VwLnBsIGIvc3JjL2Jpbi9wZ19iYXNlYmFja3VwL3Qv MDEwX3BnX2Jhc2ViYWNrdXAucGwKaW5kZXggZjY3NGE3Yzk0ZS4uOWViYTdkOGQ3ZCAxMDA2 NDQKLS0tIGEvc3JjL2Jpbi9wZ19iYXNlYmFja3VwL3QvMDEwX3BnX2Jhc2ViYWNrdXAucGwK KysrIGIvc3JjL2Jpbi9wZ19iYXNlYmFja3VwL3QvMDEwX3BnX2Jhc2ViYWNrdXAucGwKQEAg LTUwMiwxMCArNTAyLDEwIEBACiAKICMgY3JlYXRlIHRhYmxlcyB0byBjb3JydXB0IGFuZCBn ZXQgdGhlaXIgcmVsZmlsZW5vZGVzCiBteSAkZmlsZV9jb3JydXB0MSA9ICRub2RlLT5zYWZl X3BzcWwoJ3Bvc3RncmVzJywKLQlxe1NFTEVDVCBhIElOVE8gY29ycnVwdDEgRlJPTSBnZW5l cmF0ZV9zZXJpZXMoMSwxMDAwMCkgQVMgYTsgQUxURVIgVEFCTEUgY29ycnVwdDEgU0VUIChh dXRvdmFjdXVtX2VuYWJsZWQ9ZmFsc2UpOyBTRUxFQ1QgcGdfcmVsYXRpb25fZmlsZXBhdGgo J2NvcnJ1cHQxJyl9CisJcXtDUkVBVEUgVEFCTEUgY29ycnVwdDEgQVMgU0VMRUNUIGEgRlJP TSBnZW5lcmF0ZV9zZXJpZXMoMSwxMDAwMCkgQVMgYTsgQUxURVIgVEFCTEUgY29ycnVwdDEg U0VUIChhdXRvdmFjdXVtX2VuYWJsZWQ9ZmFsc2UpOyBTRUxFQ1QgcGdfcmVsYXRpb25fZmls ZXBhdGgoJ2NvcnJ1cHQxJyl9CiApOwogbXkgJGZpbGVfY29ycnVwdDIgPSAkbm9kZS0+c2Fm ZV9wc3FsKCdwb3N0Z3JlcycsCi0JcXtTRUxFQ1QgYiBJTlRPIGNvcnJ1cHQyIEZST00gZ2Vu ZXJhdGVfc2VyaWVzKDEsMikgQVMgYjsgQUxURVIgVEFCTEUgY29ycnVwdDIgU0VUIChhdXRv dmFjdXVtX2VuYWJsZWQ9ZmFsc2UpOyBTRUxFQ1QgcGdfcmVsYXRpb25fZmlsZXBhdGgoJ2Nv cnJ1cHQyJyl9CisJcXtDUkVBVEUgVEFCTEUgY29ycnVwdDIgQVMgU0VMRUNUIGIgRlJPTSBn ZW5lcmF0ZV9zZXJpZXMoMSwyKSBBUyBiOyBBTFRFUiBUQUJMRSBjb3JydXB0MiBTRVQgKGF1 dG92YWN1dW1fZW5hYmxlZD1mYWxzZSk7IFNFTEVDVCBwZ19yZWxhdGlvbl9maWxlcGF0aCgn Y29ycnVwdDInKX0KICk7CiAKICMgc2V0IHBhZ2UgaGVhZGVyIGFuZCBibG9jayBzaXplcwpk aWZmIC0tZ2l0IGEvc3JjL2Jpbi9wZ19jaGVja3N1bXMvdC8wMDJfYWN0aW9ucy5wbCBiL3Ny Yy9iaW4vcGdfY2hlY2tzdW1zL3QvMDAyX2FjdGlvbnMucGwKaW5kZXggNGU0OTM0NTMyYS4u OGE4MWYzNmEwNiAxMDA2NDQKLS0tIGEvc3JjL2Jpbi9wZ19jaGVja3N1bXMvdC8wMDJfYWN0 aW9ucy5wbAorKysgYi9zcmMvYmluL3BnX2NoZWNrc3Vtcy90LzAwMl9hY3Rpb25zLnBsCkBA IC0yMSw3ICsyMSw3IEBAIHN1YiBjaGVja19yZWxhdGlvbl9jb3JydXB0aW9uCiAKIAkkbm9k ZS0+c2FmZV9wc3FsKAogCQkncG9zdGdyZXMnLAotCQkiU0VMRUNUIGEgSU5UTyAkdGFibGUg RlJPTSBnZW5lcmF0ZV9zZXJpZXMoMSwxMDAwMCkgQVMgYTsKKwkJIkNSRUFURSBUQUJMRSAk dGFibGUgQVMgU0VMRUNUIGEgRlJPTSBnZW5lcmF0ZV9zZXJpZXMoMSwxMDAwMCkgQVMgYTsK IAkJQUxURVIgVEFCTEUgJHRhYmxlIFNFVCAoYXV0b3ZhY3V1bV9lbmFibGVkPWZhbHNlKTsi KTsKIAogCSRub2RlLT5zYWZlX3BzcWwoJ3Bvc3RncmVzJywKZGlmZiAtLWdpdCBhL3NyYy90 ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvY3JlYXRlX2luZGV4Lm91dCBiL3NyYy90ZXN0L3JlZ3Jl c3MvZXhwZWN0ZWQvY3JlYXRlX2luZGV4Lm91dAppbmRleCAxOGJiOTJiODEwLi41ZmI4YzQ4 ZTk1IDEwMDY0NAotLS0gYS9zcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2NyZWF0ZV9pbmRl eC5vdXQKKysrIGIvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9jcmVhdGVfaW5kZXgub3V0 CkBAIC0xNTgyLDcgKzE1ODIsNyBAQCBEUk9QIFRBQkxFIHN5c2NvbF90YWJsZTsKIC0tCiAt LSBUZXN0cyBmb3IgSVMgTlVMTC9JUyBOT1QgTlVMTCB3aXRoIGItdHJlZSBpbmRleGVzCiAt LQotU0VMRUNUIHVuaXF1ZTEsIHVuaXF1ZTIgSU5UTyBvbmVrX3dpdGhfbnVsbCBGUk9NIG9u ZWs7CitDUkVBVEUgVEFCTEUgb25la193aXRoX251bGwgQVMgU0VMRUNUIHVuaXF1ZTEsIHVu aXF1ZTIgRlJPTSBvbmVrOwogSU5TRVJUIElOVE8gb25la193aXRoX251bGwgKHVuaXF1ZTEs dW5pcXVlMikgVkFMVUVTIChOVUxMLCAtMSksIChOVUxMLCBOVUxMKTsKIENSRUFURSBVTklR VUUgSU5ERVggb25la19udWxsdGVzdCBPTiBvbmVrX3dpdGhfbnVsbCAodW5pcXVlMix1bmlx dWUxKTsKIFNFVCBlbmFibGVfc2Vxc2NhbiA9IE9GRjsKZGlmZiAtLWdpdCBhL3NyYy90ZXN0 L3JlZ3Jlc3MvZXhwZWN0ZWQvY3JlYXRlX21pc2Mub3V0IGIvc3JjL3Rlc3QvcmVncmVzcy9l eHBlY3RlZC9jcmVhdGVfbWlzYy5vdXQKaW5kZXggY2VlMzVlZDAyZi4uNDFiYzRkNzc1MCAx MDA2NDQKLS0tIGEvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9jcmVhdGVfbWlzYy5vdXQK KysrIGIvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9jcmVhdGVfbWlzYy5vdXQKQEAgLTUs NyArNSw3IEBACiAtLQkoYW55IHJlc2VtYmxhbmNlIHRvIHJlYWwgbGlmZSBpcyBwdXJlbHkg Y29pbmNpZGVudGFsKQogLS0KIElOU0VSVCBJTlRPIHRlbmsyIFNFTEVDVCAqIEZST00gdGVu azE7Ci1TRUxFQ1QgKiBJTlRPIFRBQkxFIG9uZWsyIEZST00gb25lazsKK0NSRUFURSBUQUJM RSBvbmVrMiBBUyBTRUxFQ1QgKiBGUk9NIG9uZWs7CiBJTlNFUlQgSU5UTyBmYXN0X2VtcDQw MDAgU0VMRUNUICogRlJPTSBzbG93X2VtcDQwMDA7CiBTRUxFQ1QgKgogICAgSU5UTyBUQUJM RSBCcHJpbWUKZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvcmFuZG9t Lm91dCBiL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvcmFuZG9tLm91dAppbmRleCAzMDJj M2Q2MWM3Li5hOTE5YjI4ZDhkIDEwMDY0NAotLS0gYS9zcmMvdGVzdC9yZWdyZXNzL2V4cGVj dGVkL3JhbmRvbS5vdXQKKysrIGIvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9yYW5kb20u b3V0CkBAIC0yMyw3ICsyMyw4IEBAIElOVEVSU0VDVAogKDAgcm93cykKIAogLS0gY291bnQg cm91Z2hseSAxLzEwIG9mIHRoZSB0dXBsZXMKLVNFTEVDVCBjb3VudCgqKSBBUyByYW5kb20g SU5UTyBSQU5ET01fVEJMCitDUkVBVEUgVEFCTEUgUkFORE9NX1RCTCBBUworICBTRUxFQ1Qg Y291bnQoKikgQVMgcmFuZG9tCiAgIEZST00gb25layBXSEVSRSByYW5kb20oKSA8IDEuMC8x MDsKIC0tIHNlbGVjdCBhZ2FpbiwgdGhlIGNvdW50IHNob3VsZCBiZSBkaWZmZXJlbnQKIElO U0VSVCBJTlRPIFJBTkRPTV9UQkwgKHJhbmRvbSkKZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3Jl Z3Jlc3MvZXhwZWN0ZWQvc2VsZWN0X2ltcGxpY2l0Lm91dCBiL3NyYy90ZXN0L3JlZ3Jlc3Mv ZXhwZWN0ZWQvc2VsZWN0X2ltcGxpY2l0Lm91dAppbmRleCA2MWI0ODVmZGFhLi4yN2MwN2Rl OTJjIDEwMDY0NAotLS0gYS9zcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3NlbGVjdF9pbXBs aWNpdC5vdXQKKysrIGIvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9zZWxlY3RfaW1wbGlj aXQub3V0CkBAIC0yMDIsNyArMjAyLDggQEAgU0VMRUNUIGNvdW50KCopIEZST00gdGVzdF9t aXNzaW5nX3RhcmdldCB4LCB0ZXN0X21pc3NpbmdfdGFyZ2V0IHkKIAogLS0gICBncm91cCB3 L28gZXhpc3RpbmcgR1JPVVAgQlkgdGFyZ2V0IHVuZGVyIGFtYmlndW91cyBjb25kaXRpb24K IC0tICAgaW50byBhIHRhYmxlCi1TRUxFQ1QgY291bnQoKikgSU5UTyBUQUJMRSB0ZXN0X21p c3NpbmdfdGFyZ2V0MgorQ1JFQVRFIFRBQkxFIHRlc3RfbWlzc2luZ190YXJnZXQyIEFTCitT RUxFQ1QgY291bnQoKikKIEZST00gdGVzdF9taXNzaW5nX3RhcmdldCB4LCB0ZXN0X21pc3Np bmdfdGFyZ2V0IHkKIAlXSEVSRSB4LmEgPSB5LmEKIAlHUk9VUCBCWSB4LmIgT1JERVIgQlkg eC5iOwpAQCAtMzE4LDcgKzMxOSw4IEBAIExJTkUgMTogU0VMRUNUIGNvdW50KGIpIEZST00g dGVzdF9taXNzaW5nX3RhcmdldCB4LCB0ZXN0X21pc3NpbmdfdGFyLi4uCiAgICAgICAgICAg ICAgICAgICAgICBeCiAtLSAgIGdyb3VwIHcvbyBleGlzdGluZyBHUk9VUCBCWSB0YXJnZXQg dW5kZXIgYW1iaWd1b3VzIGNvbmRpdGlvbgogLS0gICBpbnRvIGEgdGFibGUKLVNFTEVDVCBj b3VudCh4LmIpIElOVE8gVEFCTEUgdGVzdF9taXNzaW5nX3RhcmdldDMKK0NSRUFURSBUQUJM RSB0ZXN0X21pc3NpbmdfdGFyZ2V0MyBBUworU0VMRUNUIGNvdW50KHguYikKIEZST00gdGVz dF9taXNzaW5nX3RhcmdldCB4LCB0ZXN0X21pc3NpbmdfdGFyZ2V0IHkKIAlXSEVSRSB4LmEg PSB5LmEKIAlHUk9VUCBCWSB4LmIvMiBPUkRFUiBCWSB4LmIvMjsKZGlmZiAtLWdpdCBhL3Ny Yy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvc2VsZWN0X2ltcGxpY2l0XzEub3V0IGIvc3JjL3Rl c3QvcmVncmVzcy9leHBlY3RlZC9zZWxlY3RfaW1wbGljaXRfMS5vdXQKaW5kZXggZjI3NzM3 NWViZi4uZDY3NTIxZThmOCAxMDA2NDQKLS0tIGEvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3Rl ZC9zZWxlY3RfaW1wbGljaXRfMS5vdXQKKysrIGIvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3Rl ZC9zZWxlY3RfaW1wbGljaXRfMS5vdXQKQEAgLTIwMiw3ICsyMDIsOCBAQCBTRUxFQ1QgY291 bnQoKikgRlJPTSB0ZXN0X21pc3NpbmdfdGFyZ2V0IHgsIHRlc3RfbWlzc2luZ190YXJnZXQg eQogCiAtLSAgIGdyb3VwIHcvbyBleGlzdGluZyBHUk9VUCBCWSB0YXJnZXQgdW5kZXIgYW1i aWd1b3VzIGNvbmRpdGlvbgogLS0gICBpbnRvIGEgdGFibGUKLVNFTEVDVCBjb3VudCgqKSBJ TlRPIFRBQkxFIHRlc3RfbWlzc2luZ190YXJnZXQyCitDUkVBVEUgVEFCTEUgdGVzdF9taXNz aW5nX3RhcmdldDIgQVMKK1NFTEVDVCBjb3VudCgqKQogRlJPTSB0ZXN0X21pc3NpbmdfdGFy Z2V0IHgsIHRlc3RfbWlzc2luZ190YXJnZXQgeQogCVdIRVJFIHguYSA9IHkuYQogCUdST1VQ IEJZIHguYiBPUkRFUiBCWSB4LmI7CkBAIC0zMTgsNyArMzE5LDggQEAgTElORSAxOiBTRUxF Q1QgY291bnQoYikgRlJPTSB0ZXN0X21pc3NpbmdfdGFyZ2V0IHgsIHRlc3RfbWlzc2luZ190 YXIuLi4KICAgICAgICAgICAgICAgICAgICAgIF4KIC0tICAgZ3JvdXAgdy9vIGV4aXN0aW5n IEdST1VQIEJZIHRhcmdldCB1bmRlciBhbWJpZ3VvdXMgY29uZGl0aW9uCiAtLSAgIGludG8g YSB0YWJsZQotU0VMRUNUIGNvdW50KHguYikgSU5UTyBUQUJMRSB0ZXN0X21pc3NpbmdfdGFy Z2V0MworQ1JFQVRFIFRBQkxFIHRlc3RfbWlzc2luZ190YXJnZXQzIEFTCitTRUxFQ1QgY291 bnQoeC5iKQogRlJPTSB0ZXN0X21pc3NpbmdfdGFyZ2V0IHgsIHRlc3RfbWlzc2luZ190YXJn ZXQgeQogCVdIRVJFIHguYSA9IHkuYQogCUdST1VQIEJZIHguYi8yIE9SREVSIEJZIHguYi8y OwpkaWZmIC0tZ2l0IGEvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9zZWxlY3RfaW1wbGlj aXRfMi5vdXQgYi9zcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3NlbGVjdF9pbXBsaWNpdF8y Lm91dAppbmRleCA5MWMzYTI0ZjkyLi43YTM1M2QwODYyIDEwMDY0NAotLS0gYS9zcmMvdGVz dC9yZWdyZXNzL2V4cGVjdGVkL3NlbGVjdF9pbXBsaWNpdF8yLm91dAorKysgYi9zcmMvdGVz dC9yZWdyZXNzL2V4cGVjdGVkL3NlbGVjdF9pbXBsaWNpdF8yLm91dApAQCAtMjAyLDcgKzIw Miw4IEBAIFNFTEVDVCBjb3VudCgqKSBGUk9NIHRlc3RfbWlzc2luZ190YXJnZXQgeCwgdGVz dF9taXNzaW5nX3RhcmdldCB5CiAKIC0tICAgZ3JvdXAgdy9vIGV4aXN0aW5nIEdST1VQIEJZ IHRhcmdldCB1bmRlciBhbWJpZ3VvdXMgY29uZGl0aW9uCiAtLSAgIGludG8gYSB0YWJsZQot U0VMRUNUIGNvdW50KCopIElOVE8gVEFCTEUgdGVzdF9taXNzaW5nX3RhcmdldDIKK0NSRUFU RSBUQUJMRSB0ZXN0X21pc3NpbmdfdGFyZ2V0MiBBUworU0VMRUNUIGNvdW50KCopCiBGUk9N IHRlc3RfbWlzc2luZ190YXJnZXQgeCwgdGVzdF9taXNzaW5nX3RhcmdldCB5CiAJV0hFUkUg eC5hID0geS5hCiAJR1JPVVAgQlkgeC5iIE9SREVSIEJZIHguYjsKQEAgLTMxOCw3ICszMTks OCBAQCBMSU5FIDE6IFNFTEVDVCBjb3VudChiKSBGUk9NIHRlc3RfbWlzc2luZ190YXJnZXQg eCwgdGVzdF9taXNzaW5nX3Rhci4uLgogICAgICAgICAgICAgICAgICAgICAgXgogLS0gICBn cm91cCB3L28gZXhpc3RpbmcgR1JPVVAgQlkgdGFyZ2V0IHVuZGVyIGFtYmlndW91cyBjb25k aXRpb24KIC0tICAgaW50byBhIHRhYmxlCi1TRUxFQ1QgY291bnQoeC5iKSBJTlRPIFRBQkxF IHRlc3RfbWlzc2luZ190YXJnZXQzCitDUkVBVEUgVEFCTEUgdGVzdF9taXNzaW5nX3Rhcmdl dDMgQVMKK1NFTEVDVCBjb3VudCh4LmIpCiBGUk9NIHRlc3RfbWlzc2luZ190YXJnZXQgeCwg dGVzdF9taXNzaW5nX3RhcmdldCB5CiAJV0hFUkUgeC5hID0geS5hCiAJR1JPVVAgQlkgeC5i LzIgT1JERVIgQlkgeC5iLzI7CmRpZmYgLS1naXQgYS9zcmMvdGVzdC9yZWdyZXNzL3NxbC9j cmVhdGVfaW5kZXguc3FsIGIvc3JjL3Rlc3QvcmVncmVzcy9zcWwvY3JlYXRlX2luZGV4LnNx bAppbmRleCA1NTMyNmViNDdiLi4zMzE2NzA5NjJlIDEwMDY0NAotLS0gYS9zcmMvdGVzdC9y ZWdyZXNzL3NxbC9jcmVhdGVfaW5kZXguc3FsCisrKyBiL3NyYy90ZXN0L3JlZ3Jlc3Mvc3Fs L2NyZWF0ZV9pbmRleC5zcWwKQEAgLTYwOSw3ICs2MDksNyBAQCBDUkVBVEUgSU5ERVggT04g c3lzY29sX3RhYmxlIChhKSBXSEVSRSBjdGlkID49ICcoMTAwMCwwKSc7CiAtLSBUZXN0cyBm b3IgSVMgTlVMTC9JUyBOT1QgTlVMTCB3aXRoIGItdHJlZSBpbmRleGVzCiAtLQogCi1TRUxF Q1QgdW5pcXVlMSwgdW5pcXVlMiBJTlRPIG9uZWtfd2l0aF9udWxsIEZST00gb25lazsKK0NS RUFURSBUQUJMRSBvbmVrX3dpdGhfbnVsbCBBUyBTRUxFQ1QgdW5pcXVlMSwgdW5pcXVlMiBG Uk9NIG9uZWs7CiBJTlNFUlQgSU5UTyBvbmVrX3dpdGhfbnVsbCAodW5pcXVlMSx1bmlxdWUy KSBWQUxVRVMgKE5VTEwsIC0xKSwgKE5VTEwsIE5VTEwpOwogQ1JFQVRFIFVOSVFVRSBJTkRF WCBvbmVrX251bGx0ZXN0IE9OIG9uZWtfd2l0aF9udWxsICh1bmlxdWUyLHVuaXF1ZTEpOwog CmRpZmYgLS1naXQgYS9zcmMvdGVzdC9yZWdyZXNzL3NxbC9jcmVhdGVfbWlzYy5zcWwgYi9z cmMvdGVzdC9yZWdyZXNzL3NxbC9jcmVhdGVfbWlzYy5zcWwKaW5kZXggZDBiMDRhODIxZi4u YzdkMGQwNjRjMyAxMDA2NDQKLS0tIGEvc3JjL3Rlc3QvcmVncmVzcy9zcWwvY3JlYXRlX21p c2Muc3FsCisrKyBiL3NyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2NyZWF0ZV9taXNjLnNxbApAQCAt OCw3ICs4LDcgQEAKIAogSU5TRVJUIElOVE8gdGVuazIgU0VMRUNUICogRlJPTSB0ZW5rMTsK IAotU0VMRUNUICogSU5UTyBUQUJMRSBvbmVrMiBGUk9NIG9uZWs7CitDUkVBVEUgVEFCTEUg b25lazIgQVMgU0VMRUNUICogRlJPTSBvbmVrOwogCiBJTlNFUlQgSU5UTyBmYXN0X2VtcDQw MDAgU0VMRUNUICogRlJPTSBzbG93X2VtcDQwMDA7CiAKZGlmZiAtLWdpdCBhL3NyYy90ZXN0 L3JlZ3Jlc3Mvc3FsL3JhbmRvbS5zcWwgYi9zcmMvdGVzdC9yZWdyZXNzL3NxbC9yYW5kb20u c3FsCmluZGV4IGFlNmI3MGExNTcuLjgxODdiMmMyODggMTAwNjQ0Ci0tLSBhL3NyYy90ZXN0 L3JlZ3Jlc3Mvc3FsL3JhbmRvbS5zcWwKKysrIGIvc3JjL3Rlc3QvcmVncmVzcy9zcWwvcmFu ZG9tLnNxbApAQCAtMTcsNyArMTcsOCBAQAogICBGUk9NIG9uZWsgT1JERVIgQlkgcmFuZG9t KCkgTElNSVQgMSk7CiAKIC0tIGNvdW50IHJvdWdobHkgMS8xMCBvZiB0aGUgdHVwbGVzCi1T RUxFQ1QgY291bnQoKikgQVMgcmFuZG9tIElOVE8gUkFORE9NX1RCTAorQ1JFQVRFIFRBQkxF IFJBTkRPTV9UQkwgQVMKKyAgU0VMRUNUIGNvdW50KCopIEFTIHJhbmRvbQogICBGUk9NIG9u ZWsgV0hFUkUgcmFuZG9tKCkgPCAxLjAvMTA7CiAKIC0tIHNlbGVjdCBhZ2FpbiwgdGhlIGNv dW50IHNob3VsZCBiZSBkaWZmZXJlbnQKZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3JlZ3Jlc3Mv c3FsL3NlbGVjdF9pbXBsaWNpdC5zcWwgYi9zcmMvdGVzdC9yZWdyZXNzL3NxbC9zZWxlY3Rf aW1wbGljaXQuc3FsCmluZGV4IGQ4MTU1MDQyMjIuLmRlM2FlZjhkODEgMTAwNjQ0Ci0tLSBh L3NyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3NlbGVjdF9pbXBsaWNpdC5zcWwKKysrIGIvc3JjL3Rl c3QvcmVncmVzcy9zcWwvc2VsZWN0X2ltcGxpY2l0LnNxbApAQCAtODYsNyArODYsOCBAQCBD UkVBVEUgVEFCTEUgdGVzdF9taXNzaW5nX3RhcmdldCAoYSBpbnQsIGIgaW50LCBjIGNoYXIo OCksIGQgY2hhcik7CiAKIC0tICAgZ3JvdXAgdy9vIGV4aXN0aW5nIEdST1VQIEJZIHRhcmdl dCB1bmRlciBhbWJpZ3VvdXMgY29uZGl0aW9uCiAtLSAgIGludG8gYSB0YWJsZQotU0VMRUNU IGNvdW50KCopIElOVE8gVEFCTEUgdGVzdF9taXNzaW5nX3RhcmdldDIKK0NSRUFURSBUQUJM RSB0ZXN0X21pc3NpbmdfdGFyZ2V0MiBBUworU0VMRUNUIGNvdW50KCopCiBGUk9NIHRlc3Rf bWlzc2luZ190YXJnZXQgeCwgdGVzdF9taXNzaW5nX3RhcmdldCB5CiAJV0hFUkUgeC5hID0g eS5hCiAJR1JPVVAgQlkgeC5iIE9SREVSIEJZIHguYjsKQEAgLTE0Miw3ICsxNDMsOCBAQCBD UkVBVEUgVEFCTEUgdGVzdF9taXNzaW5nX3RhcmdldCAoYSBpbnQsIGIgaW50LCBjIGNoYXIo OCksIGQgY2hhcik7CiAKIC0tICAgZ3JvdXAgdy9vIGV4aXN0aW5nIEdST1VQIEJZIHRhcmdl dCB1bmRlciBhbWJpZ3VvdXMgY29uZGl0aW9uCiAtLSAgIGludG8gYSB0YWJsZQotU0VMRUNU IGNvdW50KHguYikgSU5UTyBUQUJMRSB0ZXN0X21pc3NpbmdfdGFyZ2V0MworQ1JFQVRFIFRB QkxFIHRlc3RfbWlzc2luZ190YXJnZXQzIEFTCitTRUxFQ1QgY291bnQoeC5iKQogRlJPTSB0 ZXN0X21pc3NpbmdfdGFyZ2V0IHgsIHRlc3RfbWlzc2luZ190YXJnZXQgeQogCVdIRVJFIHgu YSA9IHkuYQogCUdST1VQIEJZIHguYi8yIE9SREVSIEJZIHguYi8yOwotLSAKMi4yOS4yCgo= --------------0E77FB5E87E724730B57A0B3 Content-Type: text/plain; charset=UTF-8; x-mac-type="0"; x-mac-creator="0"; name="0002-doc-Add-stronger-deprecation-language-to-SELECT-INTO.patch" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename*0="0002-doc-Add-stronger-deprecation-language-to-SELECT-INTO.pa"; filename*1="tch" RnJvbSBhN2RkZjE4ZDJjODkwMDVhZDYwMzVjZjFmNDAzODdjYTdlOTQ5NTY3IE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBQZXRlciBFaXNlbnRyYXV0IDxwZXRlckBlaXNlbnRy YXV0Lm9yZz4KRGF0ZTogV2VkLCAyIERlYyAyMDIwIDEyOjQ3OjAzICswMTAwClN1YmplY3Q6 IFtQQVRDSCAyLzJdIGRvYzogQWRkIHN0cm9uZ2VyIGRlcHJlY2F0aW9uIGxhbmd1YWdlIHRv IFNFTEVDVCBJTlRPCiByZWZlcmVuY2UgcGFnZQoKRXZlbiB0aG91Z2ggU0VMRUNUIElOVE8g KG5vdCBlY3BnLCBub3QgUEwvcGdTUUwpIGlzIHdpZGVseSByZWNvZ25pemVkCmFtb25nIGlu c2lkZXJzIHRvIGJlIGRlcHJlY2F0ZWQsIGFuZCB0aGVyZSBhcmUgc29tZSBzb3VyY2UgY29k ZQpjb21tZW50cyBhYm91dCB0aGlzLCB0aGUgU0VMRUNUIElOVE8gcmVmZXJlbmNlIHBhZ2Ug b25seSBjb250YWlucwp2YWd1ZSBsYW5ndWFnZSBsaWtlICJyZWNvbW1lbmRlZCIuICBUaGlz IGNoYW5nZSBwdXRzIGEgZGVwcmVjYXRpb24Kbm90aWNlIHJpZ2h0IGF0IHRoZSB0b3AuCi0t LQogZG9jL3NyYy9zZ21sL3JlZi9zZWxlY3RfaW50by5zZ21sIHwgNiArKysrKysKIDEgZmls ZSBjaGFuZ2VkLCA2IGluc2VydGlvbnMoKykKCmRpZmYgLS1naXQgYS9kb2Mvc3JjL3NnbWwv cmVmL3NlbGVjdF9pbnRvLnNnbWwgYi9kb2Mvc3JjL3NnbWwvcmVmL3NlbGVjdF9pbnRvLnNn bWwKaW5kZXggN2IzMjdkOWVlZS4uYjM3YWMzNDViMCAxMDA2NDQKLS0tIGEvZG9jL3NyYy9z Z21sL3JlZi9zZWxlY3RfaW50by5zZ21sCisrKyBiL2RvYy9zcmMvc2dtbC9yZWYvc2VsZWN0 X2ludG8uc2dtbApAQCAtNDIsNiArNDIsMTIgQEAKICA8cmVmc2VjdDE+CiAgIDx0aXRsZT5E ZXNjcmlwdGlvbjwvdGl0bGU+CiAKKyAgPHBhcmE+CisgICBUaGlzIGNvbW1hbmQgaXMgZGVw cmVjYXRlZC4gIFVzZSA8bGluaworICAgbGlua2VuZD0ic3FsLWNyZWF0ZXRhYmxlYXMiPjxj b21tYW5kPkNSRUFURSBUQUJMRSBBUzwvY29tbWFuZD48L2xpbms+CisgICBpbnN0ZWFkLgor ICA8L3BhcmE+CisKICAgPHBhcmE+CiAgICA8Y29tbWFuZD5TRUxFQ1QgSU5UTzwvY29tbWFu ZD4gY3JlYXRlcyBhIG5ldyB0YWJsZSBhbmQgZmlsbHMgaXQKICAgIHdpdGggZGF0YSBjb21w dXRlZCBieSBhIHF1ZXJ5LiAgVGhlIGRhdGEgaXMgbm90IHJldHVybmVkIHRvIHRoZQotLSAK Mi4yOS4yCgo= --------------0E77FB5E87E724730B57A0B3--