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