github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/operator/not_regexp_operator.result (about) 1 SELECT 'Corn' NOT REGEXP 'Corn' AS 'Corn'; 2 Corn 3 false 4 SELECT 'Acorn' NOT REGEXP 'Corn' AS 'Acorn'; 5 Acorn 6 true 7 SELECT 'Corner' NOT REGEXP 'Corn' AS 'Corner'; 8 Corner 9 false 10 SELECT 'Cheese' NOT REGEXP 'Corn' AS 'Cheese'; 11 Cheese 12 true 13 SELECT 'Corn' NOT REGEXP '^Co' AS 'Corn'; 14 Corn 15 false 16 SELECT 'Acorn' NOT REGEXP '^Co' AS 'Acorn'; 17 Acorn 18 true 19 SELECT 'Cheese' NOT REGEXP '^Co' AS 'Cheese'; 20 Cheese 21 true 22 SELECT 'Corn' NOT REGEXP 'rn$' AS 'Corn'; 23 Corn 24 false 25 SELECT 'Acorn' NOT REGEXP 'rn$' AS 'Acorn'; 26 Acorn 27 false 28 SELECT 'Cheese' NOT REGEXP 'rn$' AS 'Cheese'; 29 Cheese 30 true 31 SELECT 'Corn' NOT REGEXP '.' AS 'Corn'; 32 Corn 33 false 34 SELECT 'Cheese' NOT REGEXP '.' AS 'Cheese'; 35 Cheese 36 false 37 SELECT 'Corn' NOT REGEXP '^C.rn$' AS 'Corn'; 38 Corn 39 false 40 SELECT 'Crn' NOT REGEXP '^C.rn$' AS 'Crn'; 41 Crn 42 true 43 SELECT 'Tweet' NOT REGEXP '^Tw..t$' AS 'Tweet'; 44 Tweet 45 false 46 SELECT 'Tweat' NOT REGEXP '^Tw..t$' AS 'Tweat'; 47 Tweat 48 false 49 SELECT 'Tweet' NOT REGEXP '^Tw.t$' AS 'Tweet'; 50 Tweet 51 true 52 SELECT 'Twit' NOT REGEXP '^Tw..t$' AS 'Twit'; 53 Twit 54 true 55 SELECT 'Tweet' NOT REGEXP '^Tw.{2}t$' AS 'Tweet'; 56 Tweet 57 false 58 SELECT 'Tweat' NOT REGEXP '^Tw.{2}t$' AS 'Tweat'; 59 Tweat 60 false 61 SELECT 'Tweet' NOT REGEXP '^Tw.{1}t$' AS 'Tweet'; 62 Tweet 63 true 64 SELECT 'Twit' NOT REGEXP '^Tw.{2}t$' AS 'Twit'; 65 Twit 66 true 67 SELECT 'Twet' NOT REGEXP '^Twe*t$' AS 'Twet'; 68 Twet 69 false 70 SELECT 'Tweet' NOT REGEXP '^Twe*t$' AS 'Tweet'; 71 Tweet 72 false 73 SELECT 'Tweeet' NOT REGEXP '^Twe*t$' AS 'Tweeet'; 74 Tweet 75 false 76 SELECT 'Twt' NOT REGEXP '^Twe*t$' AS 'Twt'; 77 Twt 78 false 79 SELECT 'Twit' NOT REGEXP '^Twe*t$' AS 'Twit'; 80 Twit 81 true 82 SELECT 'Twiet' NOT REGEXP '^Twe*t$' AS 'Twiet'; 83 Twiet 84 true 85 SELECT 'Tweit' NOT REGEXP '^Twe*t$' AS 'Tweit'; 86 Tweit 87 true 88 SELECT 'Twet' NOT REGEXP '^Twe+t$' AS 'Twet'; 89 Twet 90 false 91 SELECT 'Tweet' NOT REGEXP '^Twe+t$' AS 'Tweet'; 92 Tweet 93 false 94 SELECT 'Tweeet' NOT REGEXP '^Twe+t$' AS 'Tweeet'; 95 Tweeet 96 false 97 SELECT 'Twt' NOT REGEXP '^Twe+t$' AS 'Twt'; 98 Twt 99 true 100 SELECT 'Twit' NOT REGEXP '^Twe+t$' AS 'Twit'; 101 Twit 102 true 103 SELECT 'Twiet' NOT REGEXP '^Twe+t$' AS 'Twiet'; 104 Twiet 105 true 106 SELECT 'Tweit' NOT REGEXP '^Twe+t$' AS 'Tweit'; 107 Tweit 108 true 109 SELECT 'Tweet' NOT REGEXP 'Tw|et' AS 'Tweet'; 110 Tweet 111 false 112 SELECT 'For Let' NOT REGEXP 'Tw|et' AS 'For Let'; 113 For Let 114 false 115 SELECT 'Banana' NOT REGEXP 'Tw|et' AS 'Banana'; 116 Banana 117 true 118 SELECT 'Cat' NOT REGEXP 'Cat|Dog' AS 'Cat'; 119 Cat 120 false 121 SELECT 'Dog' NOT REGEXP 'Cat|Dog' AS 'Dog'; 122 Dog 123 false 124 SELECT 'Doggone' NOT REGEXP 'Cat|Dog' AS 'Doggone'; 125 Doggone 126 false 127 SELECT 'Banana' NOT REGEXP 'Cat|Dog' AS 'Banana'; 128 Banana 129 true 130 SELECT 'Banana' NOT REGEXP '(an)*' AS 'Banana'; 131 Banana 132 false 133 SELECT 'Land' NOT REGEXP '(an)*' AS 'Land'; 134 Land 135 false 136 SELECT 'Cheese' NOT REGEXP '(an)*' AS 'Cheese'; 137 Cheese 138 false 139 SELECT 'Banana' NOT REGEXP '^B(an)*d$' AS 'Banana'; 140 Banana 141 true 142 SELECT 'Band' NOT REGEXP '^B(an)*d$' AS 'Band'; 143 Band 144 false 145 SELECT 'Bald' NOT REGEXP '^B(an)*d$' AS 'Bald'; 146 Bald 147 true 148 SELECT 'Bad' NOT REGEXP '^B(an)*d$' AS 'Bad'; 149 Bad 150 true 151 SELECT 'Tweeet' NOT REGEXP 'e{3}' AS 'Tweeet'; 152 Tweeet 153 false 154 SELECT 'Tweet' NOT REGEXP 'e{3}' AS 'Tweet'; 155 Tweet 156 true 157 SELECT 'Tweet 123' NOT REGEXP '[0-9]' AS 'Tweet123'; 158 Tweet123 159 false 160 SELECT 'Tweet ABC' NOT REGEXP '[0-9]' AS 'TweetABC'; 161 TweetABC 162 true 163 SELECT 'Tweet 123' NOT REGEXP '[A-Z]' AS 'Tweet123'; 164 Tweet123 165 false 166 SELECT 'ABC' NOT REGEXP '[A-Z]' AS 'ABC'; 167 ABC 168 false 169 SELECT '123' NOT REGEXP '[A-Z]' AS '123'; 170 123 171 true 172 SELECT '123' NOT REGEXP '[1-3]' AS '123'; 173 123 174 false 175 SELECT '012' NOT REGEXP '[1-3]' AS '012'; 176 012 177 false 178 SELECT '045' NOT REGEXP '[1-3]' AS '045'; 179 045 180 true 181 SELECT '123' NOT REGEXP '[^1-3]' AS '123'; 182 123 183 true 184 SELECT '012' NOT REGEXP '[^1-3]' AS '012'; 185 012 186 false 187 SELECT '045' NOT REGEXP '[^1-3]' AS '045'; 188 045 189 false 190 create table t1(a int, b varchar(100)); 191 insert into t1 values(1 , "PowerSlave"); 192 insert into t1 values(2 , "Powerage"); 193 insert into t1 values( 3 , "Singing Down the Lane" ); 194 insert into t1 values(4 , "Ziltoid the Omniscient"); 195 insert into t1 values(5 , "Casualties of Cool"); 196 insert into t1 values( 6 , "Epicloud"); 197 insert into t1 values(7 , "Somewhere in Time"); 198 insert into t1 values(8 , "Piece of Mind"); 199 insert into t1 values( 9 , "Killers"); 200 insert into t1 values(10 , "No Prayer for the Dying"); 201 insert into t1 values(11 , "No Sound Without Silence"); 202 insert into t1 values(12 , "Big Swing Face"); 203 insert into t1 values(13 , "Blue Night"); 204 insert into t1 values(14 , "Eternity"); 205 insert into t1 values(15 , "Scandinavia"); 206 insert into t1 values(16 , "Long Lost Suitcase"); 207 insert into t1 values(17 , "Praise and Blame"); 208 insert into t1 values(18 , "Along Came Jones"); 209 insert into t1 values(19 , "All Night Wrong"); 210 insert into t1 values(20 , "The Sixteen Men of Tain"); 211 SELECT a, b 212 FROM t1 213 WHERE b NOT REGEXP '^Power'; 214 a b 215 3 Singing Down the Lane 216 4 Ziltoid the Omniscient 217 5 Casualties of Cool 218 6 Epicloud 219 7 Somewhere in Time 220 8 Piece of Mind 221 9 Killers 222 10 No Prayer for the Dying 223 11 No Sound Without Silence 224 12 Big Swing Face 225 13 Blue Night 226 14 Eternity 227 15 Scandinavia 228 16 Long Lost Suitcase 229 17 Praise and Blame 230 18 Along Came Jones 231 19 All Night Wrong 232 20 The Sixteen Men of Tain 233 drop table t1;