github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/eval/row (about)

     1  # Row
     2  
     3  eval
     4  ROW()
     5  ----
     6  ()
     7  
     8  # Row (tuple) comparisons.
     9  
    10  eval
    11  ROW(1) = ROW(1)
    12  ----
    13  true
    14  
    15  eval
    16  ROW(1, true) = (1, NOT false)
    17  ----
    18  true
    19  
    20  eval
    21  (1, 'a') = (1, 'a')
    22  ----
    23  true
    24  
    25  eval
    26  (1, 'a' || 1::char) = (1, 'a1')
    27  ----
    28  true
    29  
    30  eval
    31  (1+1, (2+2, (3+3))) = (2, (4, (6)))
    32  ----
    33  true
    34  
    35  eval
    36  (1, 'a') != (1, 'a')
    37  ----
    38  false
    39  
    40  eval
    41  (1, 'a') != (1, 'b')
    42  ----
    43  true
    44  
    45  eval
    46  (1, 2, 3) = (1, 2, 3)
    47  ----
    48  true
    49  
    50  eval
    51  (1, 2, 3) != (1, 2, 3)
    52  ----
    53  false
    54  
    55  eval
    56  (1, 2, 3) > (1, 2, 3)
    57  ----
    58  false
    59  
    60  eval
    61  (1, 2, 3) >= (1, 2, 3)
    62  ----
    63  true
    64  
    65  eval
    66  (1, 2, 3) < (1, 2, 3)
    67  ----
    68  false
    69  
    70  eval
    71  (1, 2, 3) <= (1, 2, 3)
    72  ----
    73  true
    74  
    75  eval
    76  (1, 2, 3) = (1, 2, 4)
    77  ----
    78  false
    79  
    80  eval
    81  (1, 2, 3) != (1, 2, 4)
    82  ----
    83  true
    84  
    85  eval
    86  (1, 2, 3) > (1, 2, 4)
    87  ----
    88  false
    89  
    90  eval
    91  (1, 2, 3) >= (1, 2, 4)
    92  ----
    93  false
    94  
    95  eval
    96  (1, 2, 4) = (1, 2, 3)
    97  ----
    98  false
    99  
   100  eval
   101  (1, 2, 4) != (1, 2, 3)
   102  ----
   103  true
   104  
   105  eval
   106  (1, 2, 4) > (1, 2, 3)
   107  ----
   108  true
   109  
   110  eval
   111  (1, 2, 4) >= (1, 2, 3)
   112  ----
   113  true
   114  
   115  # Row (tuple) comparisons with NULLs.
   116  
   117  eval
   118  (1, 2, 3) = (1, NULL, 3)
   119  ----
   120  NULL
   121  
   122  eval
   123  (1, 2, 3) != (1, NULL, 3)
   124  ----
   125  NULL
   126  
   127  eval
   128  (1, 2, 3) > (1, NULL, 3)
   129  ----
   130  NULL
   131  
   132  eval
   133  (1, 2, 3) >= (1, NULL, 3)
   134  ----
   135  NULL
   136  
   137  eval
   138  (1, 2, 3) = (0, NULL, 3)
   139  ----
   140  false
   141  
   142  eval
   143  (1, 2, 3) != (0, NULL, 3)
   144  ----
   145  true
   146  
   147  eval
   148  (1, 2, 3) > (0, NULL, 3)
   149  ----
   150  true
   151  
   152  eval
   153  (1, 2, 3) >= (0, NULL, 3)
   154  ----
   155  true
   156  
   157  eval
   158  (1, 2, 3) = (2, NULL, 3)
   159  ----
   160  false
   161  
   162  eval
   163  (1, 2, 3) != (2, NULL, 3)
   164  ----
   165  true
   166  
   167  eval
   168  (1, 2, 3) > (2, NULL, 3)
   169  ----
   170  false
   171  
   172  eval
   173  (1, 2, 3) >= (2, NULL, 3)
   174  ----
   175  false
   176  
   177  eval
   178  (1, 2, 3) = (1, NULL, 4)
   179  ----
   180  false
   181  
   182  eval
   183  (1, 2, 3) != (1, NULL, 4)
   184  ----
   185  true
   186  
   187  eval
   188  (1, 2, 3) > (1, NULL, 4)
   189  ----
   190  NULL
   191  
   192  eval
   193  (1, 2, 3) >= (1, NULL, 4)
   194  ----
   195  NULL
   196  
   197  eval
   198  (1, NULL, 3) = (1, 2, 3)
   199  ----
   200  NULL
   201  
   202  eval
   203  (1, NULL, 3) != (1, 2, 3)
   204  ----
   205  NULL
   206  
   207  eval
   208  (1, NULL, 3) > (1, 2, 3)
   209  ----
   210  NULL
   211  
   212  eval
   213  (1, NULL, 3) >= (1, 2, 3)
   214  ----
   215  NULL
   216  
   217  eval
   218  (1, NULL, 3) = (0, 2, 3)
   219  ----
   220  false
   221  
   222  eval
   223  (1, NULL, 3) != (0, 2, 3)
   224  ----
   225  true
   226  
   227  eval
   228  (1, NULL, 3) > (0, 2, 3)
   229  ----
   230  true
   231  
   232  eval
   233  (1, NULL, 3) >= (0, 2, 3)
   234  ----
   235  true
   236  
   237  eval
   238  (1, NULL, 3) = (2, 2, 3)
   239  ----
   240  false
   241  
   242  eval
   243  (1, NULL, 3) != (2, 2, 3)
   244  ----
   245  true
   246  
   247  eval
   248  (1, NULL, 3) > (2, 2, 3)
   249  ----
   250  false
   251  
   252  eval
   253  (1, NULL, 3) >= (2, 2, 3)
   254  ----
   255  false
   256  
   257  eval
   258  (1, NULL, 3) = (1, 2, 4)
   259  ----
   260  false
   261  
   262  eval
   263  (1, NULL, 3) != (1, 2, 4)
   264  ----
   265  true
   266  
   267  eval
   268  (1, NULL, 3) > (1, 2, 4)
   269  ----
   270  NULL
   271  
   272  eval
   273  (1, NULL, 3) >= (1, 2, 4)
   274  ----
   275  NULL
   276  
   277  # Tuple equality is equivalent to conjunctive equality.
   278  
   279  eval
   280  (1, 2, 3) = (1, 2, 3)
   281  ----
   282  true
   283  
   284  eval
   285  1 = 1 AND 2 = 2 AND 3 = 3
   286  ----
   287  true
   288  
   289  eval
   290  (1, 2, 3) = (2, 2, 3)
   291  ----
   292  false
   293  
   294  eval
   295  1 = 2 AND 2 = 2 AND 3 = 3
   296  ----
   297  false
   298  
   299  eval
   300  (1, 2, 4) = (1, 2, 3)
   301  ----
   302  false
   303  
   304  eval
   305  1 = 1 AND 2 = 2 AND 4 = 3
   306  ----
   307  false
   308  
   309  eval
   310  (NULL, 2, 3) = (1, 2, 3)
   311  ----
   312  NULL
   313  
   314  eval
   315  NULL = 1 AND 2 = 2 AND 3 = 3
   316  ----
   317  NULL
   318  
   319  eval
   320  (NULL, 2, 3) = (NULL, 2, 3)
   321  ----
   322  NULL
   323  
   324  eval
   325  NULL = NULL AND 2 = 2 AND 3 = 3
   326  ----
   327  NULL
   328  
   329  eval
   330  (NULL, 2, 3) = (NULL, 3, 3)
   331  ----
   332  false
   333  
   334  eval
   335  NULL = NULL AND 2 = 3 AND 3 = 3
   336  ----
   337  false
   338  
   339  eval
   340  (NULL, 2, 3) = (1, 2, NULL)
   341  ----
   342  NULL
   343  
   344  eval
   345  NULL = 1 AND 2 = 2 AND 3 = NULL
   346  ----
   347  NULL