github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/eval/boolean (about) 1 eval 2 false AND true 3 ---- 4 false 5 6 eval 7 false AND NULL 8 ---- 9 false 10 11 eval 12 false AND false 13 ---- 14 false 15 16 eval 17 true AND true 18 ---- 19 true 20 21 eval 22 true AND false 23 ---- 24 false 25 26 eval 27 true AND NULL 28 ---- 29 NULL 30 31 eval 32 NULL AND true 33 ---- 34 NULL 35 36 eval 37 NULL AND false 38 ---- 39 false 40 41 eval 42 NULL AND NULL 43 ---- 44 NULL 45 46 eval 47 false OR true 48 ---- 49 true 50 51 eval 52 false OR NULL 53 ---- 54 NULL 55 56 eval 57 false OR false 58 ---- 59 false 60 61 eval 62 true OR true 63 ---- 64 true 65 66 eval 67 true OR false 68 ---- 69 true 70 71 eval 72 true OR NULL 73 ---- 74 true 75 76 eval 77 NULL OR true 78 ---- 79 true 80 81 eval 82 NULL OR false 83 ---- 84 NULL 85 86 eval 87 NULL OR NULL 88 ---- 89 NULL 90 91 eval 92 NOT false 93 ---- 94 true 95 96 eval 97 NOT true 98 ---- 99 false 100 101 eval 102 NOT NULL 103 ---- 104 NULL 105 106 # Boolean expressions short-circuit the evaluation. 107 108 eval 109 false AND (2 = 1) 110 ---- 111 false 112 113 eval 114 true OR (3 = 1) 115 ---- 116 true