github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/function/func_string_reverse.test (about)

     1  #SELECT 
     2  SELECT REVERSE('abc');
     3  -- @separator:table
     4  select reverse('abc'),reverse('abcd');
     5  
     6  #NULL
     7  select reverse(NULL);
     8  
     9  
    10  #嵌套, 子查询
    11  #0.5暂不支持
    12  #CREATE TABLE t1(id INT);
    13  #INSERT INTO t1 VALUES (1),(2),(3),(4);
    14  #SELECT REVERSE(EXISTS(SELECT * FROM t1));
    15  #DROP TABLE t1;
    16  
    17  #WHERE
    18  create table t1 (a varchar(20));
    19  insert into t1 values ("empty"),(""),("hello");
    20  -- @separator:table
    21  select a,reverse(a) from t1 where reverse(a)="olleh";
    22  drop table t1;
    23  
    24  #字符集
    25  
    26  drop table if exists `Ｔ１`;
    27  drop table if exists `Ｔ２`;
    28  drop table if exists `Ｔ３`;
    29  drop table if exists `Ｔ４`;
    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  CREATE TABLE `Ｔ１` (`Ｃ１` char(50), INDEX(`Ｃ１`));
    36  CREATE TABLE `Ｔ２` (`Ｃ１` char(50), INDEX(`Ｃ１`));
    37  CREATE TABLE `Ｔ３` (`Ｃ１` char(50), INDEX(`Ｃ１`));
    38  CREATE TABLE `Ｔ４` (`Ｃ１` char(50), INDEX(`Ｃ１`));
    39  CREATE TABLE `Ｔ５` (`Ｃ１` char(50), INDEX(`Ｃ１`));
    40  CREATE TABLE `Ｔ６` (`Ｃ１` char(50), INDEX(`Ｃ１`));
    41  CREATE TABLE `Ｔ７` (`Ｃ１` char(50), INDEX(`Ｃ１`));
    42  CREATE TABLE `Ｔ８` (`Ｃ１` char(50), INDEX(`Ｃ１`));
    43  CREATE TABLE `Ｔ９` (`Ｃ１` char(50), INDEX(`Ｃ１`));
    44  INSERT INTO `Ｔ１` VALUES ('ｱｲｳｴｵ');
    45  INSERT INTO `Ｔ２` VALUES ('あいうえお');
    46  INSERT INTO `Ｔ３` VALUES ('龔龖龗龞龡');
    47  INSERT INTO `Ｔ４` VALUES ('ｱｲｳｴｵ');
    48  INSERT INTO `Ｔ５` VALUES ('あいうえお');
    49  INSERT INTO `Ｔ６` VALUES ('龔龖龗龞龡');
    50  INSERT INTO `Ｔ７` VALUES ('ｱｲｳｴｵ');
    51  INSERT INTO `Ｔ８` VALUES ('あいうえお');
    52  INSERT INTO `Ｔ９` VALUES ('龔龖龗龞龡');
    53  SELECT REVERSE(`Ｃ１`) FROM `Ｔ１`;
    54  SELECT REVERSE(`Ｃ１`) FROM `Ｔ２`;
    55  SELECT REVERSE(`Ｃ１`) FROM `Ｔ３`;
    56  SELECT REVERSE(`Ｃ１`) FROM `Ｔ４`;
    57  SELECT REVERSE(`Ｃ１`) FROM `Ｔ５`;
    58  SELECT REVERSE(`Ｃ１`) FROM `Ｔ６`;
    59  SELECT REVERSE(`Ｃ１`) FROM `Ｔ７`;
    60  SELECT REVERSE(`Ｃ１`) FROM `Ｔ８`;
    61  SELECT REVERSE(`Ｃ１`) FROM `Ｔ９`;
    62  DROP TABLE `Ｔ１`;
    63  DROP TABLE `Ｔ２`;
    64  DROP TABLE `Ｔ３`;
    65  DROP TABLE `Ｔ４`;
    66  DROP TABLE `Ｔ５`;
    67  DROP TABLE `Ｔ６`;
    68  DROP TABLE `Ｔ７`;
    69  DROP TABLE `Ｔ８`;
    70  DROP TABLE `Ｔ９`;
    71  
    72  
    73  #中文
    74  SELECT REVERSE("你好");
    75  SELECT REVERSE("再 见");
    76  
    77  
    78  #HAVING & 算术运算, INSERT INTO
    79  drop table if exists t1;
    80  create table t1(a varchar(255));
    81  insert into t1 select (reverse("abc"));
    82  insert into t1 select (reverse("bcd"));
    83  insert into t1 select (reverse("def"));
    84  insert into t1 select (reverse("xyz"));
    85  insert into t1 select (reverse("1a1"));
    86  select a from t1 group by a having reverse(a)=reverse(a);
    87  drop table t1;
    88  
    89  #DISTINCT,ON CONDITION
    90  drop table if exists t1;
    91  drop table if exists t2;
    92  create table t1(a INT,  b varchar(255));
    93  create table t2(a INT,  b varchar(255));
    94  insert into t1 values(1, "abc"),(1, "bbb"),(3, "aaa"),(4, "2012");
    95  insert into t2 values(1, "abc"),(1, "aaa"),(3, "cba"),(4, "2012");
    96  SELECT distinct t1.a, t2.a FROM t1 JOIN t2 ON (reverse(t1.b) = reverse(t2.b));
    97  drop table t1;
    98  drop table t2;
    99  
   100  #EXTREME VALUE
   101  SELECT REVERSE("@($)@($#)_@(#");
   102  -- @separator:table
   103  SELECT REVERSE(space(500)+space(600));
   104  #DATA TYPES
   105  SELECT REVERSE(123124);
   106  SELECT REVERSE(123.124);
   107  SELECT REVERSE(0.3414);
   108  
   109  SELECT REVERSE("2023-04-24");
   110  SELECT REVERSE("10:03:23.021412");
   111  
   112  
   113