vitess.io/vitess@v0.16.2/go/vt/vttablet/tabletserver/planbuilder/testdata/lock_cases.txt (about)

     1  # is_free_lock is safe outside of reserved connection
     2  "select is_free_lock('foo') from dual"
     3  {
     4    "PlanID": "Select",
     5    "TableName": "dual",
     6    "Permissions": [
     7      {
     8        "TableName": "dual",
     9        "Role": 0
    10      }
    11    ],
    12    "FullQuery": "select is_free_lock('foo') from dual limit :#maxLimit"
    13  }
    14  
    15  # is_used_lock is safe outside of reserved connection
    16  "select is_used_lock('foo') from dual"
    17  {
    18    "PlanID": "Select",
    19    "TableName": "dual",
    20    "Permissions": [
    21      {
    22        "TableName": "dual",
    23        "Role": 0
    24      }
    25    ],
    26    "FullQuery": "select is_used_lock('foo') from dual limit :#maxLimit"
    27  }
    28  
    29  # release_all_locks is safe outside of reserved connection
    30  "select release_all_locks() from dual"
    31  {
    32    "PlanID": "Select",
    33    "TableName": "dual",
    34    "Permissions": [
    35      {
    36        "TableName": "dual",
    37        "Role": 0
    38      }
    39    ],
    40    "FullQuery": "select release_all_locks() from dual limit :#maxLimit"
    41  }
    42  
    43  # release_lock is safe outside of reserved connection
    44  "select release_lock('foo') from dual"
    45  {
    46    "PlanID": "Select",
    47    "TableName": "dual",
    48    "Permissions": [
    49      {
    50        "TableName": "dual",
    51        "Role": 0
    52      }
    53    ],
    54    "FullQuery": "select release_lock('foo') from dual limit :#maxLimit"
    55  }
    56  
    57  # impossible lock query is safe outside of reserved connection
    58  "select get_lock('foo', 10) from dual where 1 != 1"
    59  {
    60    "PlanID": "SelectImpossible",
    61    "TableName": "dual",
    62    "Permissions": [
    63      {
    64        "TableName": "dual",
    65        "Role": 0
    66      }
    67    ],
    68    "FullQuery": "select get_lock('foo', 10) from dual where 1 != 1 limit :#maxLimit"
    69  }
    70  
    71  # get_lock cannot be executed outside of reserved connection
    72  "select get_lock('foo', 10) from dual"
    73  {
    74    "PlanID": "SelectLockFunc",
    75    "TableName": "dual",
    76    "Permissions": [
    77      {
    78        "TableName": "dual",
    79        "Role": 0
    80      }
    81    ],
    82    "FullQuery": "select get_lock('foo', 10) from dual limit :#maxLimit",
    83    "NeedsReservedConn": true
    84  }