github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/function/func_string_reverse.result (about)

     1  SELECT REVERSE('abc');
     2  reverse(abc)
     3  cba
     4  select reverse('abc'),reverse('abcd');
     5  reverse(abc)	reverse(abcd)
     6  cba	dcba
     7  select reverse(NULL);
     8  reverse(null)
     9  null
    10  create table t1 (a varchar(20));
    11  insert into t1 values ("empty"),(""),("hello");
    12  select a,reverse(a) from t1 where reverse(a)="olleh";
    13  a	reverse(a)
    14  hello	olleh
    15  drop table t1;
    16  drop table if exists `Ｔ１`;
    17  drop table if exists `Ｔ２`;
    18  drop table if exists `Ｔ３`;
    19  drop table if exists `Ｔ４`;
    20  drop table if exists `Ｔ５`;
    21  drop table if exists `Ｔ６`;
    22  drop table if exists `Ｔ７`;
    23  drop table if exists `Ｔ８`;
    24  drop table if exists `Ｔ９`;
    25  CREATE TABLE `Ｔ１` (`Ｃ１` char(50), INDEX(`Ｃ１`));
    26  CREATE TABLE `Ｔ２` (`Ｃ１` char(50), INDEX(`Ｃ１`));
    27  CREATE TABLE `Ｔ３` (`Ｃ１` char(50), INDEX(`Ｃ１`));
    28  CREATE TABLE `Ｔ４` (`Ｃ１` char(50), INDEX(`Ｃ１`));
    29  CREATE TABLE `Ｔ５` (`Ｃ１` char(50), INDEX(`Ｃ１`));
    30  CREATE TABLE `Ｔ６` (`Ｃ１` char(50), INDEX(`Ｃ１`));
    31  CREATE TABLE `Ｔ７` (`Ｃ１` char(50), INDEX(`Ｃ１`));
    32  CREATE TABLE `Ｔ８` (`Ｃ１` char(50), INDEX(`Ｃ１`));
    33  CREATE TABLE `Ｔ９` (`Ｃ１` char(50), INDEX(`Ｃ１`));
    34  INSERT INTO `Ｔ１` VALUES ('ｱｲｳｴｵ');
    35  INSERT INTO `Ｔ２` VALUES ('あいうえお');
    36  INSERT INTO `Ｔ３` VALUES ('龔龖龗龞龡');
    37  INSERT INTO `Ｔ４` VALUES ('ｱｲｳｴｵ');
    38  INSERT INTO `Ｔ５` VALUES ('あいうえお');
    39  INSERT INTO `Ｔ６` VALUES ('龔龖龗龞龡');
    40  INSERT INTO `Ｔ７` VALUES ('ｱｲｳｴｵ');
    41  INSERT INTO `Ｔ８` VALUES ('あいうえお');
    42  INSERT INTO `Ｔ９` VALUES ('龔龖龗龞龡');
    43  SELECT REVERSE(`Ｃ１`) FROM `Ｔ１`;
    44  REVERSE(`Ｃ１`)
    45  ｵｴｳｲｱ
    46  SELECT REVERSE(`Ｃ１`) FROM `Ｔ２`;
    47  REVERSE(`Ｃ１`)
    48  おえういあ
    49  SELECT REVERSE(`Ｃ１`) FROM `Ｔ３`;
    50  REVERSE(`Ｃ１`)
    51  龡龞龗龖龔
    52  SELECT REVERSE(`Ｃ１`) FROM `Ｔ４`;
    53  REVERSE(`Ｃ１`)
    54  ｵｴｳｲｱ
    55  SELECT REVERSE(`Ｃ１`) FROM `Ｔ５`;
    56  REVERSE(`Ｃ１`)
    57  おえういあ
    58  SELECT REVERSE(`Ｃ１`) FROM `Ｔ６`;
    59  REVERSE(`Ｃ１`)
    60  龡龞龗龖龔
    61  SELECT REVERSE(`Ｃ１`) FROM `Ｔ７`;
    62  REVERSE(`Ｃ１`)
    63  ｵｴｳｲｱ
    64  SELECT REVERSE(`Ｃ１`) FROM `Ｔ８`;
    65  REVERSE(`Ｃ１`)
    66  おえういあ
    67  SELECT REVERSE(`Ｃ１`) FROM `Ｔ９`;
    68  REVERSE(`Ｃ１`)
    69  龡龞龗龖龔
    70  DROP TABLE `Ｔ１`;
    71  DROP TABLE `Ｔ２`;
    72  DROP TABLE `Ｔ３`;
    73  DROP TABLE `Ｔ４`;
    74  DROP TABLE `Ｔ５`;
    75  DROP TABLE `Ｔ６`;
    76  DROP TABLE `Ｔ７`;
    77  DROP TABLE `Ｔ８`;
    78  DROP TABLE `Ｔ９`;
    79  SELECT REVERSE("你好");
    80  reverse(你好)
    81  好你
    82  SELECT REVERSE("再 见");
    83  reverse(再 见)
    84  见 再
    85  drop table if exists t1;
    86  create table t1(a varchar(255));
    87  insert into t1 select (reverse("abc"));
    88  insert into t1 select (reverse("bcd"));
    89  insert into t1 select (reverse("def"));
    90  insert into t1 select (reverse("xyz"));
    91  insert into t1 select (reverse("1a1"));
    92  select a from t1 group by a having reverse(a)=reverse(a);
    93  a
    94  cba
    95  dcb
    96  fed
    97  zyx
    98  1a1
    99  drop table t1;
   100  drop table if exists t1;
   101  drop table if exists t2;
   102  create table t1(a INT,  b varchar(255));
   103  create table t2(a INT,  b varchar(255));
   104  insert into t1 values(1, "abc"),(1, "bbb"),(3, "aaa"),(4, "2012");
   105  insert into t2 values(1, "abc"),(1, "aaa"),(3, "cba"),(4, "2012");
   106  SELECT distinct t1.a, t2.a FROM t1 JOIN t2 ON (reverse(t1.b) = reverse(t2.b));
   107  a	a
   108  1	1
   109  3	1
   110  4	4
   111  drop table t1;
   112  drop table t2;
   113  SELECT REVERSE("@($)@($#)_@(#");
   114  reverse(@($)@($#)_@(#)
   115  #(@_)#$(@)$(@
   116  SELECT REVERSE(space(500)+space(600));
   117  reverse(space(500) + space(600))
   118                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
   119  SELECT REVERSE(123124);
   120  reverse(123124)
   121  421321
   122  SELECT REVERSE(123.124);
   123  reverse(123.124)
   124  421.321
   125  SELECT REVERSE(0.3414);
   126  reverse(0.3414)
   127  4143.0
   128  SELECT REVERSE("2023-04-24");
   129  reverse(2023-04-24)
   130  42-40-3202
   131  SELECT REVERSE("10:03:23.021412");
   132  reverse(10:03:23.021412)
   133  214120.32:30:01