From mboxrd@z Thu Jan 1 00:00:00 1970 From: Ian Jackson Subject: [OSSTEST PATCH 06/17] db updates: Make all INSERTs (except into steps) name columns explicitly Date: Fri, 30 Jun 2017 17:25:09 +0100 Message-ID: <1498839920-17025-7-git-send-email-ian.jackson@eu.citrix.com> References: <1498839920-17025-1-git-send-email-ian.jackson@eu.citrix.com> Mime-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 Return-path: Received: from mail6.bemta3.messagelabs.com ([195.245.230.39]) by lists.xenproject.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dQyje-0005jY-As for xen-devel@lists.xenproject.org; Fri, 30 Jun 2017 16:25:34 +0000 In-Reply-To: <1498839920-17025-1-git-send-email-ian.jackson@eu.citrix.com> List-Unsubscribe: , List-Post: List-Help: List-Subscribe: , Errors-To: xen-devel-bounces@lists.xen.org Sender: "Xen-devel" To: xen-devel@lists.xenproject.org Cc: Andrew Cooper , Wei Liu , Ian Jackson List-Id: xen-devel@lists.xenproject.org VGhpcyBtYWtlcyB0aGUgY29kZSBtb3JlIHJvYnVzdCBhZ2FpbnN0IHNjaGVtYSB1cGRhdGVzLiAg U3BlY2lmaWNhbGx5LAppZiBhbnkgY29sdW1ucyB3ZXJlIHRvIGJlIGRlbGV0ZWQsIHRoZXNlIHJ1 bmVzIHdvdWxkIGJyZWFrLiAgKEFsc28gaWYKYW55IGNvbHVtbiB3YXMgaW5zZXJ0ZWQgb3RoZXIg dGhhbiBhZnRlciB0aGUgZXhpc3RpbmcgY29sdW1ucywKYWx0aG91Z2ggdGhpcyBpcyBub3Qgc29t ZXRoaW5nIFBvc3RncmVzIGNhbiBjdXJyZW50bHkgZG8gQUlVSS4pCgpBZmZlY3RlZCB0YWJsZXMg YXJlOgogIGZsaWdodHNfaGFybmVzc190b3VjaGVkCiAgam9icwogIHJlc291cmNlcwogIHJ1bnZh cnMKICBzdGVwcwoKU2lnbmVkLW9mZi1ieTogSWFuIEphY2tzb24gPElhbi5KYWNrc29uQGV1LmNp dHJpeC5jb20+Ci0tLQogT3NzdGVzdC9Kb2JEQi9FeGVjdXRpdmUucG0gfCAgNCArKystCiBPc3N0 ZXN0L1Rlc3RTdXBwb3J0LnBtICAgICB8IDEyICsrKysrKysrKy0tLQogY3MtYWRqdXN0LWZsaWdo dCAgICAgICAgICAgfCAgNyArKysrLS0tCiBjcy1iaXNlY3Rpb24tc3RlcCAgICAgICAgICB8ICAz ICsrLQogbWctYWxsb2NhdGUgICAgICAgICAgICAgICAgfCAgMiArLQogbWctaG9zdHMgICAgICAg ICAgICAgICAgICAgfCAgMSArCiB0Y2wvSm9iREItRXhlY3V0aXZlLnRjbCAgICB8ICA0ICsrKy0K IDcgZmlsZXMgY2hhbmdlZCwgMjMgaW5zZXJ0aW9ucygrKSwgMTAgZGVsZXRpb25zKC0pCgpkaWZm IC0tZ2l0IGEvT3NzdGVzdC9Kb2JEQi9FeGVjdXRpdmUucG0gYi9Pc3N0ZXN0L0pvYkRCL0V4ZWN1 dGl2ZS5wbQppbmRleCA0NWFhYmQ0Li4wZDFiM2JlIDEwMDY0NAotLS0gYS9Pc3N0ZXN0L0pvYkRC L0V4ZWN1dGl2ZS5wbQorKysgYi9Pc3N0ZXN0L0pvYkRCL0V4ZWN1dGl2ZS5wbQpAQCAtMTkxLDcg KzE5MSw5IEBAIEVORAogCiAgICAgaWYgKCEkYWxyZWFkeSkgewogICAgICAgICAkZGJoX3Rlc3Rz LT5kbyg8PEVORCwge30sICRmbCwkcmV2KTsKLSAgICAgICAgICAgIElOU0VSVCBJTlRPIGZsaWdo dHNfaGFybmVzc190b3VjaGVkIFZBTFVFUyAoPyw/KQorICAgICAgICAgICAgSU5TRVJUIElOVE8g ZmxpZ2h0c19oYXJuZXNzX3RvdWNoZWQKKyAgICAgICAgICAgICAgICAgICAgICAgIChmbGlnaHQs IGhhcm5lc3MpCisgICAgICAgICAgICAgICAgIFZBTFVFUyAoPyw/KQogRU5ECiAgICAgfQogfQpk aWZmIC0tZ2l0IGEvT3NzdGVzdC9UZXN0U3VwcG9ydC5wbSBiL09zc3Rlc3QvVGVzdFN1cHBvcnQu cG0KaW5kZXggZTY1OTlkYi4uZjEwZDU2ZSAxMDA2NDQKLS0tIGEvT3NzdGVzdC9UZXN0U3VwcG9y dC5wbQorKysgYi9Pc3N0ZXN0L1Rlc3RTdXBwb3J0LnBtCkBAIC0zMDksNyArMzA5LDkgQEAgc3Vi IHN0b3JlX3J1bnZhciAoJCQpIHsKIAkJICBXSEVSRSBmbGlnaHQ9PyBBTkQgam9iPT8gQU5EIG5h bWU9PyBBTkQgc3ludGg9J3QnCiBFTkQKICAgICAgICAgJGRiaF90ZXN0cy0+ZG8oPDxFTkQse30s ICRmbGlnaHQsJGpvYiwgJHBhcmFtLCR2YWx1ZSk7Ci0gICAgICAgICAgICBJTlNFUlQgSU5UTyBy dW52YXJzIFZBTFVFUyAoPyw/LD8sPywndCcpCisgICAgICAgICAgICBJTlNFUlQgSU5UTyBydW52 YXJzCisgICAgICAgICAgICAgICAgICAgICAgICAoZmxpZ2h0LCBqb2IsIG5hbWUsIHZhbCwgc3lu dGgpCisgICAgICAgICAgICAgICAgIFZBTFVFUyAoPyw/LD8sPywndCcpCiBFTkQKICAgICB9KTsK ICAgICAkcnskcGFyYW19PSBnZXRfcnVudmFyKCRwYXJhbSwgIiRmbGlnaHQuJGpvYiIpOwpAQCAt MzY4LDcgKzM3MCw5IEBAIEVORAogCQkgIFdIRVJFIGZsaWdodD0/IEFORCBqb2I9PyBBTkQgbmFt ZT0/IEFORCBzeW50aD0ndCcKIEVORAogCSRkYmhfdGVzdHMtPmRvKDw8RU5ELCB1bmRlZiwgJGZs aWdodCwgJGpvYiwgJHBhcmFtLCAkdmFsdWUrMSk7Ci0gICAgICAgICAgICBJTlNFUlQgSU5UTyBy dW52YXJzIFZBTFVFUyAoPyw/LD8sPywndCcpCisgICAgICAgICAgICBJTlNFUlQgSU5UTyBydW52 YXJzCisgICAgICAgICAgICAgICAgICAgICAgICAoZmxpZ2h0LCBqb2IsIG5hbWUsIHZhbCwgc3lu dGgpCisgICAgICAgICAgICAgICAgIFZBTFVFUyAoPyw/LD8sPywndCcpCiBFTkQKICAgICB9KTsK ICAgICBsb2dtKCJydW52YXIgaW5jcmVtZW50OiAkcGFyYW09JHZhbHVlIik7CkBAIC0xNzc1LDcg KzE3NzksOSBAQCBFTkQKICAgICAgICAgICAgIGxvZ20oInNlbGVjdF9ldGhlciAkcHJlZml4Oi4u LiAkZXRoZXIgKGZpcnN0IGluIGZsaWdodCkiKTsKICAgICAgICAgfQogICAgICAgICAkZGJoX3Rl c3RzLT5kbyg8PEVORCwge30sICRmbGlnaHQsJGpvYiwkdm4sJGV0aGVyKTsKLSAgICAgICAgICAg IElOU0VSVCBJTlRPIHJ1bnZhcnMgVkFMVUVTICg/LD8sPyw/LCd0JykKKyAgICAgICAgICAgIElO U0VSVCBJTlRPIHJ1bnZhcnMKKyAgICAgICAgICAgICAgICAgICAgICAgIChmbGlnaHQsIGpvYiwg bmFtZSwgdmFsLCBzeW50aCkKKyAgICAgICAgICAgICAgICAgVkFMVUVTICg/LD8sPyw/LCd0JykK IEVORAogICAgICAgICBteSAkY2hrcm93PSAkZGJoX3Rlc3RzLT5zZWxlY3Ryb3dfaGFzaHJlZig8 PEVORCx7fSwgJGZsaWdodCk7CiAJICAgIFNFTEVDVCB2YWwsIGNvdW50KCopIEZST00gcnVudmFy cyBXSEVSRSBmbGlnaHQ9PwpkaWZmIC0tZ2l0IGEvY3MtYWRqdXN0LWZsaWdodCBiL2NzLWFkanVz dC1mbGlnaHQKaW5kZXggMDMyNTdhNi4uMGJlMTA0ZSAxMDA3NTUKLS0tIGEvY3MtYWRqdXN0LWZs aWdodAorKysgYi9jcy1hZGp1c3QtZmxpZ2h0CkBAIC0xOTYsMTEgKzE5NiwxMSBAQCBzdWIgY29w eV9qb2JzICgkJCkgewogICAgIG15ICgkc3JjZmxpZ2h0LCAkam9icykgPSBAXzsKICAgICBwcmVw X3JtX2pvYnMoKTsKICAgICBteSBAam9iX2NvcHlfcXMgPSBtYXAgeyAkZGJoX3Rlc3RzLT5wcmVw YXJlKCRfKSB9Ci0gICAgICAgICgiSU5TRVJUIElOVE8gam9icyIuCisgICAgICAgICgiSU5TRVJU IElOVE8gam9icyAoZmxpZ2h0LCBqb2IsIHJlY2lwZSwgc3RhdHVzKSIuCiAgICAgICAgICAiICAg ICBTRUxFQ1QgPywgam9iLCByZWNpcGUsICdxdWV1ZWQnIi4KICAgICAgICAgICIgICAgICAgRlJP TSBqb2JzIi4KICAgICAgICAgICIgICAgICBXSEVSRSBmbGlnaHQgPSA/IEFORCBqb2IgPSA/IiwK LSAgICAgICAgICJJTlNFUlQgSU5UTyBydW52YXJzIi4KKyAgICAgICAgICJJTlNFUlQgSU5UTyBy dW52YXJzIChmbGlnaHQsIGpvYiwgbmFtZSwgdmFsLCBzeW50aCkiLgogICAgICAgICAgIiAgICAg U0VMRUNUID8sIGpvYiwgbmFtZSwgdmFsLCAnZiciLgogICAgICAgICAgIiAgICAgICBGUk9NIHJ1 bnZhcnMiLgogICAgICAgICAgIiAgICAgIFdIRVJFIGZsaWdodCA9ID8gQU5EIGpvYiA9ID8gQU5E IE5PVCBzeW50aCIpOwpAQCAtMjQ2LDcgKzI0Niw4IEBAIHN1YiBjaGFuZ2VfX2NvcHlfam9icyB7 CiBvdXIgJHJ1bnZhcl9ybV9xID0gJGRiaF90ZXN0cy0+cHJlcGFyZQogICAgICgiREVMRVRFIEZS T00gcnVudmFycyBXSEVSRSBmbGlnaHQgPSA/IEFORCBqb2IgPSA/IEFORCBuYW1lID0gPyIpOwog b3VyICRydW52YXJfaW5zZXJ0X3EgPSAkZGJoX3Rlc3RzLT5wcmVwYXJlCi0gICAgKCJJTlNFUlQg SU5UTyBydW52YXJzIFZBTFVFUyAoPywgPywgPywgPywgJ2YnKSIpOworICAgICgiSU5TRVJUIElO VE8gcnVudmFycyAoZmxpZ2h0LCBqb2IsIG5hbWUsIHZhbCwgc3ludGgpIi4KKyAgICAgIiBWQUxV RVMgKD8sID8sID8sID8sICdmJykiKTsKIAogc3ViIHJ1bnZhcl9zZXQgKCQkJDskKSB7CiAgICAg bXkgKCRqb2IsICRuYW1lLCAkdmFsLCAkeHdoYXQpID0gQF87CmRpZmYgLS1naXQgYS9jcy1iaXNl Y3Rpb24tc3RlcCBiL2NzLWJpc2VjdGlvbi1zdGVwCmluZGV4IDc2ZjUwMTAuLjEzY2NkN2EgMTAw NzU1Ci0tLSBhL2NzLWJpc2VjdGlvbi1zdGVwCisrKyBiL2NzLWJpc2VjdGlvbi1zdGVwCkBAIC0x MjU1LDcgKzEyNTUsOCBAQCBFTkQKICAgICAgICAgICAgICIgZnJvbSAkY29weWZsaWdodClcbiI7 CiAKICAgICAgICAgJGRiaF90ZXN0cy0+ZG8oPDxFTkQsIHt9LCAkcG9wZmxpZ2h0LCRwb3Bqb2Is JHJlY2lwZSk7Ci0gICAgICAgICAgICBJTlNFUlQgSU5UTyBqb2JzIFZBTFVFUyAoPywgPywgPywg J3F1ZXVlZCcpCisgICAgICAgICAgICBJTlNFUlQgSU5UTyBqb2JzIChmbGlnaHQsIGpvYiwgcmVj aXBlLCBzdGF0dXMpCisgICAgICAgICAgICAgICAgICAgICAgVkFMVUVTICg/LCA/LCA/LCAncXVl dWVkJykKIEVORAogICAgICAgICAkZGJoX3Rlc3RzLT5kbyg8PEVORCwge30sICRwb3BmbGlnaHQs JHBvcGpvYik7CiAgICAgICAgICAgICBJTlNFUlQgSU5UTyBydW52YXJzICgKZGlmZiAtLWdpdCBh L21nLWFsbG9jYXRlIGIvbWctYWxsb2NhdGUKaW5kZXggNGYwMmNlNS4uZGFkYWMzYyAxMDA3NTUK LS0tIGEvbWctYWxsb2NhdGUKKysrIGIvbWctYWxsb2NhdGUKQEAgLTE4MCw3ICsxODAsNyBAQCBz dWIgYWxsb2NfMXJlc2NhbmQgKCQkKSB7CiAKICAgICBpZiAoJGFsbG9jYXRlICYmICRyZXN0eXBl IGVxICdzaGFyZS1mbGlnaHQnICYmICRzaGFyZWl4ID09ICR0aWQpIHsKIAkkZGJoX3Rlc3RzLT5k byg8PEVORCx7fSwKLSAgICAgICAgICAgIElOU0VSVCBJTlRPIHJlc291cmNlcworICAgICAgICAg ICAgSU5TRVJUIElOVE8gcmVzb3VyY2VzIChyZXN0eXBlLCByZXNuYW1lLCBzaGFyZWl4LCBvd250 YXNraWQpCiAgICAgICAgICAgICAgICAgIChTRUxFQ1QgPyBBUyByZXN0eXBlLAogICAgICAgICAg ICAgICAgICAgICAgICAgID8gQVMgcmVzbmFtZSwKICAgICAgICAgICAgICAgICAgICAgICAgICA/ IEFTIHNoYXJlaXgsCmRpZmYgLS1naXQgYS9tZy1ob3N0cyBiL21nLWhvc3RzCmluZGV4IGJkNjdh MGEuLjVjZGVjZTUgMTAwNzU1Ci0tLSBhL21nLWhvc3RzCisrKyBiL21nLWhvc3RzCkBAIC0xNzgs NiArMTc4LDcgQEAgc3ViIGNtZF9jcmVhdGVfbGlrZSAoKSB7CiAgICAgICAgIGZvcmVhY2ggbXkg JGRzdCAobCgkZHN0cykpIHsKICAgICAgICAgICAgICRkYmhfdGVzdHMtPmRvKDw8RU5ELHt9LCAk ZHN0LCRzcmMpOwogICAgICAgICAgICAgICAgIElOU0VSVCBJTlRPIHJlc291cmNlcworICAgICAg ICAgICAgICAgICAgICAgICAocmVzdHlwZSwgcmVzbmFtZSwgc2hhcmVpeCwgb3dudGFza2lkKQog ICAgICAgICAgICAgICAgIFNFTEVDVCByZXN0eXBlLAogICAgICAgICAgICAgICAgICAgICAgICA/ IEFTIHJlc25hbWUsCiAgICAgICAgICAgICAgICAgICAgICAgIDAgQVMgc2hhcmVpeCwKZGlmZiAt LWdpdCBhL3RjbC9Kb2JEQi1FeGVjdXRpdmUudGNsIGIvdGNsL0pvYkRCLUV4ZWN1dGl2ZS50Y2wK aW5kZXggNmI5YmNiMC4uNDE0YTc3ZSAxMDA2NDQKLS0tIGEvdGNsL0pvYkRCLUV4ZWN1dGl2ZS50 Y2wKKysrIGIvdGNsL0pvYkRCLUV4ZWN1dGl2ZS50Y2wKQEAgLTI4Miw3ICsyODIsOSBAQCBwcm9j IHNwYXduLXN0ZXAtYmVnaW4ge2ZsaWdodCBqb2IgdHMgc3RlcG5vdmFyfSB7CiAJCXNldCBzdGVw bm8gMQogCSAgICB9CiAJICAgIGRiLWV4ZWN1dGUgIgotCQlJTlNFUlQgSU5UTyBzdGVwcworCQlJ TlNFUlQgSU5UTyBzdGVwcyAoZmxpZ2h0LCBqb2IsIHN0ZXBubywKKyAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgc3RlcCwgc3RhdHVzLAorICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICB0ZXN0aWQpCiAJCSAgICBWQUxVRVMgKFtwZ19xdW90ZSAkZmxpZ2h0XSwgW3Bn X3F1b3RlICRqb2JdLCAkc3RlcG5vLAogCQkJICAgIFtwZ19xdW90ZSAkdHNdLCAncnVubmluZycs CiAJCQkgICAgJ1NUQVJUSU5HJykKLS0gCjIuMS40CgoKX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX18KWGVuLWRldmVsIG1haWxpbmcgbGlzdApYZW4tZGV2ZWxA bGlzdHMueGVuLm9yZwpodHRwczovL2xpc3RzLnhlbi5vcmcveGVuLWRldmVsCg==