github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/function/func_string_rtrim_ltrim.result (about) 1 SELECT RTRIM('barbar '); 2 RTRIM('barbar ') 3 barbar 4 SELECT LTRIM(' barbar'); 5 LTRIM(' barbar') 6 barbar 7 SELECT ' geeksforgeeks' As OriginalString, 8 LTRIM (' geeksforgeeks') AS LeftTrimmedString; 9 OriginalString LeftTrimmedString 10 geeksforgeeks geeksforgeeks 11 SELECT ' MySQL' AS String, RTRIM ('MySQL') AS Tstring; 12 String Tstring 13 MySQL MySQL 14 select cast(rtrim(' 20.06 ') as decimal(19,2)); 15 cast(rtrim( 20.06 ) as decimal(19, 2)) 16 20.06 17 select cast(rtrim(ltrim(' 20.06 ')) as decimal(19,2)); 18 cast(rtrim(ltrim(' 20.06 ')) as decimal(19,2)) 19 20.06 20 select concat_ws(':',ltrim(' left '),':',rtrim(' right '),':'); 21 concat_ws(':',ltrim(' left '),':',rtrim(' right '),':') 22 left ::: right:: 23 CREATE TABLE t (a int NOT NULL); 24 INSERT INTO t values(21123); 25 SELECT 1 FROM t WHERE rtrim(a & NULL); 26 '&' operator is not supported now 27 SELECT 1 FROM t WHERE ltrim(a & NULL); 28 '&' operator is not supported now 29 DROP TABLE t; 30 drop table if exists `Ｔ１`; 31 drop table if exists `Ｔ２`; 32 drop table if exists `Ｔ３`; 33 drop table if exists `Ｔ４`; 34 drop table if exists `Ｔ５`; 35 drop table if exists `Ｔ６`; 36 drop table if exists `Ｔ７`; 37 drop table if exists `Ｔ８`; 38 drop table if exists `Ｔ９`; 39 CREATE TABLE `Ｔ１` (`Ｃ１` char(80)); 40 CREATE TABLE `Ｔ２` (`Ｃ１` char(80)); 41 CREATE TABLE `Ｔ３` (`Ｃ１` char(80)); 42 CREATE TABLE `Ｔ４` (`Ｃ１` char(80)); 43 CREATE TABLE `Ｔ５` (`Ｃ１` char(80)); 44 CREATE TABLE `Ｔ６` (`Ｃ１` char(80)); 45 CREATE TABLE `Ｔ７` (`Ｃ１` char(80)); 46 CREATE TABLE `Ｔ８` (`Ｃ１` char(80)); 47 CREATE TABLE `Ｔ９` (`Ｃ１` char(80)); 48 INSERT INTO `Ｔ１` VALUES ('ｱｲｳｴｵ'); 49 INSERT INTO `Ｔ１` VALUES ('ｱｲｳｴｵ '); 50 INSERT INTO `Ｔ１` VALUES ('ｱｲｳｴｵ '); 51 INSERT INTO `Ｔ１` VALUES ('ｱｲｳｴｵ '); 52 INSERT INTO `Ｔ１` VALUES ('ｱｲｳｴｵ '); 53 INSERT INTO `Ｔ１` VALUES ('ｱｲｳｴｵ '); 54 INSERT INTO `Ｔ１` VALUES ('ｱｲｳｴｵ '); 55 INSERT INTO `Ｔ２` VALUES ('あいうえお'); 56 INSERT INTO `Ｔ２` VALUES ('あいうえお '); 57 INSERT INTO `Ｔ２` VALUES ('あいうえお '); 58 INSERT INTO `Ｔ２` VALUES ('あいうえお '); 59 INSERT INTO `Ｔ２` VALUES ('あいうえお '); 60 INSERT INTO `Ｔ２` VALUES ('あいうえお '); 61 INSERT INTO `Ｔ２` VALUES ('あいうえお '); 62 INSERT INTO `Ｔ３` VALUES ('龔龖龗龞龡'); 63 INSERT INTO `Ｔ３` VALUES ('龔龖龗龞龡 '); 64 INSERT INTO `Ｔ３` VALUES ('龔龖龗龞龡 '); 65 INSERT INTO `Ｔ３` VALUES ('龔龖龗龞龡 '); 66 INSERT INTO `Ｔ３` VALUES ('龔龖龗龞龡 '); 67 INSERT INTO `Ｔ３` VALUES ('龔龖龗龞龡 '); 68 INSERT INTO `Ｔ３` VALUES ('龔龖龗龞龡 '); 69 INSERT INTO `Ｔ４` VALUES ('ｱｲｳｴｵ'); 70 INSERT INTO `Ｔ４` VALUES ('ｱｲｳｴｵ '); 71 INSERT INTO `Ｔ４` VALUES ('ｱｲｳｴｵ '); 72 INSERT INTO `Ｔ４` VALUES ('ｱｲｳｴｵ '); 73 INSERT INTO `Ｔ４` VALUES ('ｱｲｳｴｵ '); 74 INSERT INTO `Ｔ４` VALUES ('ｱｲｳｴｵ '); 75 INSERT INTO `Ｔ４` VALUES ('ｱｲｳｴｵ '); 76 INSERT INTO `Ｔ５` VALUES ('あいうえお'); 77 INSERT INTO `Ｔ５` VALUES ('あいうえお '); 78 INSERT INTO `Ｔ５` VALUES ('あいうえお '); 79 INSERT INTO `Ｔ５` VALUES ('あいうえお '); 80 INSERT INTO `Ｔ５` VALUES ('あいうえお '); 81 INSERT INTO `Ｔ５` VALUES ('あいうえお '); 82 INSERT INTO `Ｔ５` VALUES ('あいうえお '); 83 INSERT INTO `Ｔ６` VALUES ('龔龖龗龞龡'); 84 INSERT INTO `Ｔ６` VALUES ('龔龖龗龞龡 '); 85 INSERT INTO `Ｔ６` VALUES ('龔龖龗龞龡 '); 86 INSERT INTO `Ｔ６` VALUES ('龔龖龗龞龡 '); 87 INSERT INTO `Ｔ６` VALUES ('龔龖龗龞龡 '); 88 INSERT INTO `Ｔ６` VALUES ('龔龖龗龞龡 '); 89 INSERT INTO `Ｔ６` VALUES ('龔龖龗龞龡 '); 90 INSERT INTO `Ｔ７` VALUES ('ｱｲｳｴｵ'); 91 INSERT INTO `Ｔ７` VALUES ('ｱｲｳｴｵ '); 92 INSERT INTO `Ｔ７` VALUES ('ｱｲｳｴｵ '); 93 INSERT INTO `Ｔ７` VALUES ('ｱｲｳｴｵ '); 94 INSERT INTO `Ｔ７` VALUES ('ｱｲｳｴｵ '); 95 INSERT INTO `Ｔ７` VALUES ('ｱｲｳｴｵ '); 96 INSERT INTO `Ｔ７` VALUES ('ｱｲｳｴｵ '); 97 INSERT INTO `Ｔ８` VALUES ('あいうえお'); 98 INSERT INTO `Ｔ８` VALUES ('あいうえお '); 99 INSERT INTO `Ｔ８` VALUES ('あいうえお '); 100 INSERT INTO `Ｔ８` VALUES ('あいうえお '); 101 INSERT INTO `Ｔ８` VALUES ('あいうえお '); 102 INSERT INTO `Ｔ８` VALUES ('あいうえお '); 103 INSERT INTO `Ｔ８` VALUES ('あいうえお '); 104 INSERT INTO `Ｔ９` VALUES ('龔龖龗龞龡'); 105 INSERT INTO `Ｔ９` VALUES ('龔龖龗龞龡 '); 106 INSERT INTO `Ｔ９` VALUES ('龔龖龗龞龡 '); 107 INSERT INTO `Ｔ９` VALUES ('龔龖龗龞龡 '); 108 INSERT INTO `Ｔ９` VALUES ('龔龖龗龞龡 '); 109 INSERT INTO `Ｔ９` VALUES ('龔龖龗龞龡 '); 110 INSERT INTO `Ｔ９` VALUES ('龔龖龗龞龡 '); 111 SELECT RTRIM(`Ｃ１`) from `Ｔ１`; 112 RTRIM(`Ｃ１`) 113 ｱｲｳｴｵ 114 ｱｲｳｴｵ 115 ｱｲｳｴｵ 116 ｱｲｳｴｵ 117 ｱｲｳｴｵ 118 ｱｲｳｴｵ 119 ｱｲｳｴｵ 120 SELECT RTRIM(`Ｃ１`) from `Ｔ２`; 121 RTRIM(`Ｃ１`) 122 あいうえお 123 あいうえお 124 あいうえお 125 あいうえお 126 あいうえお 127 あいうえお 128 あいうえお 129 SELECT RTRIM(`Ｃ１`) from `Ｔ３`; 130 RTRIM(`Ｃ１`) 131 龔龖龗龞龡 132 龔龖龗龞龡 133 龔龖龗龞龡 134 龔龖龗龞龡 135 龔龖龗龞龡 136 龔龖龗龞龡 137 龔龖龗龞龡 138 SELECT RTRIM(`Ｃ１`) from `Ｔ４`; 139 RTRIM(`Ｃ１`) 140 ｱｲｳｴｵ 141 ｱｲｳｴｵ 142 ｱｲｳｴｵ 143 ｱｲｳｴｵ 144 ｱｲｳｴｵ 145 ｱｲｳｴｵ 146 ｱｲｳｴｵ 147 SELECT RTRIM(`Ｃ１`) from `Ｔ５`; 148 RTRIM(`Ｃ１`) 149 あいうえお 150 あいうえお 151 あいうえお 152 あいうえお 153 あいうえお 154 あいうえお 155 あいうえお 156 SELECT RTRIM(`Ｃ１`) from `Ｔ６`; 157 RTRIM(`Ｃ１`) 158 龔龖龗龞龡 159 龔龖龗龞龡 160 龔龖龗龞龡 161 龔龖龗龞龡 162 龔龖龗龞龡 163 龔龖龗龞龡 164 龔龖龗龞龡 165 SELECT RTRIM(`Ｃ１`) from `Ｔ７`; 166 RTRIM(`Ｃ１`) 167 ｱｲｳｴｵ 168 ｱｲｳｴｵ 169 ｱｲｳｴｵ 170 ｱｲｳｴｵ 171 ｱｲｳｴｵ 172 ｱｲｳｴｵ 173 ｱｲｳｴｵ 174 SELECT RTRIM(`Ｃ１`) from `Ｔ８`; 175 RTRIM(`Ｃ１`) 176 あいうえお 177 あいうえお 178 あいうえお 179 あいうえお 180 あいうえお 181 あいうえお 182 あいうえお 183 SELECT RTRIM(`Ｃ１`) from `Ｔ９`; 184 RTRIM(`Ｃ１`) 185 龔龖龗龞龡 186 龔龖龗龞龡 187 龔龖龗龞龡 188 龔龖龗龞龡 189 龔龖龗龞龡 190 龔龖龗龞龡 191 龔龖龗龞龡 192 DROP TABLE `Ｔ１`; 193 DROP TABLE `Ｔ２`; 194 DROP TABLE `Ｔ３`; 195 DROP TABLE `Ｔ４`; 196 DROP TABLE `Ｔ５`; 197 DROP TABLE `Ｔ６`; 198 DROP TABLE `Ｔ７`; 199 DROP TABLE `Ｔ８`; 200 DROP TABLE `Ｔ９`; 201 drop table if exists `Ｔ１`; 202 drop table if exists `Ｔ２`; 203 drop table if exists `Ｔ３`; 204 drop table if exists `Ｔ４`; 205 drop table if exists `Ｔ５`; 206 drop table if exists `Ｔ６`; 207 drop table if exists `Ｔ７`; 208 drop table if exists `Ｔ８`; 209 drop table if exists `Ｔ９`; 210 SELECT RTRIM(NULL); 211 RTRIM(NULL) 212 null 213 SELECT LTRIM(NULL); 214 LTRIM(NULL) 215 null 216 SELECT RTRIM("你好 "); 217 RTRIM("你好 ") 218 你好 219 SELECT LTRIM(" 你好"); 220 LTRIM(" 你好") 221 你好 222 drop table if exists t1; 223 create table t1(a varchar(255)); 224 insert into t1 select (RTRIM("2017-06-15 ")); 225 insert into t1 select (LTRIM(" 2019-06-25")); 226 insert into t1 select (RTRIM("2017-06-15 ")); 227 insert into t1 select ("2017-06-15 "); 228 select distinct RTRIM(ltrim(a)),LTRIM(rtrim(a)) from t1; 229 RTRIM(ltrim(a)) LTRIM(rtrim(a)) 230 2017-06-15 2017-06-15 231 2019-06-25 2019-06-25 232 drop table t1; 233 drop table if exists t1; 234 create table t1(a INT, b datetime); 235 insert into t1 values(1, "2017-06-15 "),(1, "2019-06-25 "),(2, " 2019-06-25 "),(3, " 2019-06-25 "); 236 select b from t1 group by b having rtrim(ltrim(b))>"2018-01-01"; 237 b 238 2019-06-25 00:00:00 239 drop table t1; 240 create table t1(a INT, b date); 241 create table t2(a INT, b date); 242 insert into t1 values(1, " 2012-10-12 "),(2, " 2004-04-24. "),(3, " 2008-12-04. "),(4, " 2012-03-23. "); 243 invalid argument parsedate, bad value 2004-04-24. 244 insert into t2 values(1, " 2013-04-30 "),(2, " 1994-10-04 "),(3, " 2018-06-04 "),(4, " 2012-10-12 "); 245 SELECT t1.a, t2.a FROM t1 JOIN t2 ON (rtrim(ltrim(t1.b)) = ltrim(rtrim(t2.b))); 246 a a 247 drop table t1; 248 drop table t2; 249 SELECT RTRIM(space(100000000)+"123"); 250 invalid input: the space count is greater than max allowed value 8000 251 SELECT LTRIM("123"+space(100000000)); 252 invalid input: the space count is greater than max allowed value 8000 253 SELECT LTRIM(" 1241241^&@%#^*^!@#&*(!&"); 254 LTRIM(" 1241241^&@%#^*^!@#&*(!&") 255 1241241^&@%#^*^!@#&*(!& 256 SELECT RTRIM("1241241^&@%#^*^!@#&*(!& "); 257 RTRIM("1241241^&@%#^*^!@#&*(!& ") 258 1241241^&@%#^*^!@#&*(!& 259 SELECT RTRIM(" 123 "); 260 RTRIM(" 123 ") 261 123 262 SELECT RTRIM(123124); 263 RTRIM(123124) 264 123124 265 SELECT RTRIM(123.41231); 266 RTRIM(123.41231) 267 123.41231 268 SELECT LTRIM(" 123"); 269 LTRIM(" 123") 270 123 271 SELECT LTRIM(123124); 272 LTRIM(123124) 273 123124 274 SELECT LTRIM(123.41231); 275 LTRIM(123.41231) 276 123.41231