{"capability":{"Key":"select-for-no-key-updateselect-for-key-share-lock-modes","SourceKind":"yaml","SourceDatabase":"center","SourceTable":"featurematrix.yaml","SourceKey":"SELECT FOR NO KEY UPDATE/SELECT FOR KEY SHARE lock modes","SourceHash":"1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd","Name":"SELECT FOR NO KEY UPDATE/SELECT FOR KEY SHARE lock modes","NameLocale":"en","GroupKey":"sql","GroupName":"SQL","GroupLocale":"en","Ordinal":15,"GroupOrder":3,"Facts":{"feature":{"description":"These prevent non-key-field row updates from locking foreign key rows.","name":"SELECT FOR NO KEY UPDATE/SELECT FOR KEY SHARE lock modes","versions":{"9.3":"Yes"}},"group":"SQL","versions":{"max":18,"min":8.1}},"Cells":[{"Version":"10","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.3","Supported":true,"Original":"Yes"},{"Version":"11","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.3","Supported":true,"Original":"Yes"},{"Version":"12","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.3","Supported":true,"Original":"Yes"},{"Version":"13","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.3","Supported":true,"Original":"Yes"},{"Version":"14","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.3","Supported":true,"Original":"Yes"},{"Version":"15","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.3","Supported":true,"Original":"Yes"},{"Version":"16","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.3","Supported":true,"Original":"Yes"},{"Version":"17","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.3","Supported":true,"Original":"Yes"},{"Version":"18","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.3","Supported":true,"Original":"Yes"},{"Version":"8.1","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"8.2","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"8.3","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"8.4","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.0","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.1","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.2","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.3","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.3","Supported":true,"Original":"Yes"},{"Version":"9.4","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.3","Supported":true,"Original":"Yes"},{"Version":"9.5","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.3","Supported":true,"Original":"Yes"},{"Version":"9.6","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.3","Supported":true,"Original":"Yes"}],"Texts":[{"Locale":"en","Title":"SELECT FOR NO KEY UPDATE/SELECT FOR KEY SHARE lock modes","BodyHTML":"\u003cp\u003eThese prevent non-key-field row updates from locking foreign key rows.\u003c/p\u003e\n","SourceHash":"1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd","ContentHash":"77369042b246ee2cfd863184ba03a07d8204141542bf749b1d389fc954596462","Payload":{"description":"These prevent non-key-field row updates from locking foreign key rows.","name":"SELECT FOR NO KEY UPDATE/SELECT FOR KEY SHARE lock modes","versions":{"9.3":"Yes"}}},{"Locale":"zh-Hans","Title":"SELECT FOR NO KEY UPDATE/SELECT FOR KEY SHARE 锁定模式","BodyHTML":"\u003cp\u003e这些模式防止非键字段的行更新锁定外键行。\u003c/p\u003e\n","SourceHash":"071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50","ContentHash":"8fc7df0548a93f2bdb2017f5e1b3f490450b569e97f3b46c6250614acb604813","Payload":{"description":"这些模式防止非键字段的行更新锁定外键行。","name":"SELECT FOR NO KEY UPDATE/SELECT FOR KEY SHARE 锁定模式"}}],"GroupTitles":{"en":"SQL","zh-Hans":"SQL"},"LegacyIDs":["242"]},"observed":true,"selected_cell":{"Version":"18","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.3","Supported":true,"Original":"Yes"},"selected_version":"18"}