github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/logictest/testdata/logic_test/cluster_version (about)

     1  # LogicTest: local-v1.1@v1.0-noupgrade
     2  
     3  query T
     4  SHOW CLUSTER SETTING version
     5  ----
     6  1.0
     7  
     8  query T
     9  SELECT crdb_internal.node_executable_version()
    10  ----
    11  1.1
    12  
    13  user testuser
    14  
    15  statement error only users with the admin role are allowed to SET CLUSTER SETTING
    16  SET CLUSTER SETTING version = '2.0'
    17  
    18  user root
    19  
    20  statement error invalid version ba.na.na: strconv.ParseInt: parsing "ba": invalid syntax
    21  SET CLUSTER SETTING version = 'ba.na-na'
    22  
    23  statement error invalid version 1.0.0.0
    24  SET CLUSTER SETTING version = '1.0.0.0'
    25  
    26  statement error invalid version 1.0-0.0
    27  SET CLUSTER SETTING version = '1.0-0.0'
    28  
    29  statement error cannot upgrade to 2.0: node running 1.1
    30  SET CLUSTER SETTING version = '2.0'
    31  
    32  statement error cannot upgrade to 2.1: node running 1.1
    33  SET CLUSTER SETTING version = '2.1'
    34  
    35  statement error node at 1\.1 cannot run 0\.9 \(minimum version is 1\.0\)
    36  SET CLUSTER SETTING version = '0.9'
    37  
    38  statement ok
    39  SET CLUSTER SETTING version = '1.0-0'
    40  
    41  query T
    42  SHOW CLUSTER SETTING version
    43  ----
    44  1.0
    45  
    46  # Can skip versions on unstable patch upgrades.
    47  statement ok
    48  SET CLUSTER SETTING version = '1.0-500'
    49  
    50  query T
    51  SHOW CLUSTER SETTING version
    52  ----
    53  1.0-500
    54  
    55  statement error cannot upgrade to 1.2: node running 1.1
    56  SET CLUSTER SETTING version = '1.2'
    57  
    58  statement ok
    59  SET CLUSTER SETTING version = crdb_internal.node_executable_version()
    60  
    61  statement error versions cannot be downgraded \(attempting to downgrade from 1.1 to 1.0-2\)
    62  SET CLUSTER SETTING version = '1.0-2'
    63  
    64  query T
    65  SHOW CLUSTER SETTING version
    66  ----
    67  1.1
    68  
    69  statement ok
    70  SET CLUSTER SETTING version = '1.1'
    71  
    72  statement error cannot upgrade to 1.1-999: node running 1.1
    73  SET CLUSTER SETTING version = '1.1-999'
    74  
    75  statement error cannot RESET this cluster setting
    76  RESET CLUSTER SETTING version