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

     1  drop table if exists t1;
     2  create table t1 (
     3  name varchar(10),
     4  level smallint unsigned);
     5  insert into t1 values ('string',1);
     6  select reverse("123"+space(level)+"456") from t1;
     7  reverse(123 + space(level) + 456)
     8  654 321
     9  select concat_ws("abc", name,space(level)), concat_ws("abc",name, space(level)) from t1;
    10  concat_ws(abc, name, space(level))	concat_ws(abc, name, space(level))
    11  stringabc 	stringabc 
    12  drop table t1;
    13  create table t1 (a varchar(16383));
    14  insert into t1 select space(50000);
    15  invalid input: the space count is greater than max allowed value 8000
    16  select length(a) from t1;
    17  length(a)
    18  drop table t1;
    19  select space(5),concat_ws('*',space(5),'*');
    20  space(5)	concat_ws(*, space(5), *)
    21       	     **
    22  select space(-1);
    23  space(-1)
    24  
    25  select space(-4294967295);
    26  space(-4294967295)
    27  
    28  select space(4294967295);
    29  invalid input: the space count is greater than max allowed value 8000
    30  select space(-4294967296);
    31  space(-4294967296)
    32  
    33  select space(4294967296);
    34  invalid input: the space count is greater than max allowed value 8000
    35  select space(-4294967297);
    36  space(-4294967297)
    37  
    38  select space(4294967297);
    39  invalid input: the space count is greater than max allowed value 8000
    40  select space(-18446744073709551615);
    41  Data truncation: data out of range: data type uint64, value '-18446744073709551615'
    42  select space(18446744073709551615);
    43  invalid input: the space count is greater than max allowed value 8000
    44  select space(-18446744073709551616);
    45  Data truncation: data out of range: data type uint64, value '-18446744073709551616'
    46  select space(18446744073709551616);
    47  the space count exceeds maxallowedCount 8000
    48  select space(-18446744073709551617);
    49  Data truncation: data out of range: data type uint64, value '-18446744073709551617'
    50  select space(18446744073709551617);
    51  the space count exceeds maxallowedCount 8000
    52  SELECT space(9223372036854775808);
    53  invalid input: the space count is greater than max allowed value 8000
    54  SELECT length(space(9223372036854775809));
    55  invalid input: the space count is greater than max allowed value 8000
    56  SELECT SPACE(NULL);
    57  space(null)
    58  null
    59  SELECT SPACE(12)+"123";
    60  space(12) + 123
    61              123
    62  SELECT SPACE(12314.14123)+"123";
    63  invalid input: the space count is greater than max allowed value 8000
    64  SELECT SPACE("1231")+"123";
    65  space(1231) + 123
    66                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 123
    67  SELECT SPACE("2012-03-12")+"123";
    68  invalid argument cast to int, bad value 2012-03-12
    69  CREATE TABLE t(i BIGINT UNSIGNED);
    70  INSERT INTO t values(9223372036854775808);
    71  SELECT space(i) FROM t;
    72  invalid input: the space count is greater than max allowed value 8000
    73  DROP TABLE t;
    74  SELECT space(1073741824);
    75  invalid input: the space count is greater than max allowed value 8000
    76  SELECT TO_DATE(SPACE(2),'1');
    77  to_date(space(2), 1)
    78  null
    79  drop table if exists t1;
    80  create table t1(a INT);
    81  insert into t1 values(1),(1),(2),(3);
    82  select a from t1 group by a having space(a)="   ";
    83  a
    84  3
    85  drop table t1;
    86  drop table if exists t1;
    87  create table t1(a INT,  b date);
    88  insert into t1 values(1, "2012-10-12"),(2, "2004-04-24"),(3, "2008-12-04"),(4, "2012-03-23");
    89  select * from t1 where space(a)=" ";
    90  a	b
    91  1	2012-10-12
    92  drop table t1;
    93  drop table if exists t1;
    94  drop table if exists t2;
    95  create table t1(a INT,  b date);
    96  create table t2(a INT,  b date);
    97  insert into t1 values(1, "2012-10-12"),(1, "2004-04-24"),(3, "2008-12-04"),(4, "2012-03-23");
    98  insert into t2 values(1, "2013-04-30"),(1, "1994-10-04"),(3, "2018-06-04"),(4, "2012-10-12");
    99  SELECT distinct t1.a, t2.a FROM t1 JOIN t2 ON (space(t1.a) = space(t2.a));
   100  a	a
   101  1	1
   102  3	3
   103  4	4
   104  drop table t1;
   105  drop table t2;
   106  SELECT space("你好")+"你好";
   107  invalid argument cast to int, bad value 你好