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

     1  # IS DISTINCT FROM can be used to compare NULLs "safely".
     2  
     3  eval
     4  0 IS DISTINCT FROM 0
     5  ----
     6  false
     7  
     8  eval
     9  0 IS DISTINCT FROM 1
    10  ----
    11  true
    12  
    13  eval
    14  0 IS DISTINCT FROM NULL
    15  ----
    16  true
    17  
    18  eval
    19  NULL IS DISTINCT FROM NULL
    20  ----
    21  false
    22  
    23  eval
    24  NULL IS DISTINCT FROM 1
    25  ----
    26  true
    27  
    28  eval
    29  0 IS NOT DISTINCT FROM 0
    30  ----
    31  true
    32  
    33  eval
    34  0 IS NOT DISTINCT FROM 1
    35  ----
    36  false
    37  
    38  eval
    39  0 IS NOT DISTINCT FROM NULL
    40  ----
    41  false
    42  
    43  eval
    44  NULL IS NOT DISTINCT FROM NULL
    45  ----
    46  true
    47  
    48  eval
    49  NULL IS NOT DISTINCT FROM 1
    50  ----
    51  false
    52  
    53  eval
    54  (1, NULL) IS NOT DISTINCT FROM (1, NULL)
    55  ----
    56  true
    57  
    58  eval
    59  (1, NULL) IS DISTINCT FROM (1, NULL)
    60  ----
    61  false
    62  
    63  eval
    64  (NULL, 1) IS NOT DISTINCT FROM (NULL, 1)
    65  ----
    66  true
    67  
    68  eval
    69  (NULL, 1) IS DISTINCT FROM (NULL, 1)
    70  ----
    71  false
    72  
    73  eval
    74  (1, NULL) IS NOT DISTINCT FROM (2, NULL)
    75  ----
    76  false
    77  
    78  eval
    79  (1, NULL) IS DISTINCT FROM (2, NULL)
    80  ----
    81  true
    82  
    83  eval
    84  (NULL, 1) IS NOT DISTINCT FROM (NULL, 2)
    85  ----
    86  false
    87  
    88  eval
    89  (NULL, 1) IS DISTINCT FROM (NULL, 2)
    90  ----
    91  true
    92  
    93  eval
    94  ((NULL, NULL), (1, NULL)) IS NOT DISTINCT FROM ((NULL, NULL), (1, NULL))
    95  ----
    96  true
    97  
    98  eval
    99  ((NULL, NULL), (1, NULL)) IS DISTINCT FROM ((NULL, NULL), (1, NULL))
   100  ----
   101  false
   102  
   103  eval
   104  ARRAY[1,2,3] IS DISTINCT FROM ARRAY[1,2,3]
   105  ----
   106  false
   107  
   108  eval
   109  ARRAY['foo','bar','baz'] IS DISTINCT FROM ARRAY['foo','bar','baz']
   110  ----
   111  false
   112  
   113  eval
   114  ARRAY[1,2,3] IS DISTINCT FROM ARRAY[1,2,4]
   115  ----
   116  true
   117  
   118  eval
   119  ARRAY[1,2,3] IS NOT DISTINCT FROM ARRAY[1,2,3]
   120  ----
   121  true
   122  
   123  eval
   124  ARRAY['foo','bar','baz'] IS NOT DISTINCT FROM ARRAY['foo','bar','baz']
   125  ----
   126  true
   127  
   128  eval
   129  ARRAY[1,2,3] IS DISTINCT FROM NULL
   130  ----
   131  true
   132  
   133  eval
   134  ARRAY[1,2,3] IS NOT DISTINCT FROM NULL
   135  ----
   136  false
   137  
   138  eval
   139  NULL::INT[] IS DISTINCT FROM NULL::INT[]
   140  ----
   141  false