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

     1  SELECT LEFT('ABCDEFG', 2);
     2  left(ABCDEFG, 2)
     3  AB
     4  SELECT LEFT('ABCDEFG', 0);
     5  left(ABCDEFG, 0)
     6  
     7  SELECT LEFT('ABCDEFG', -1);
     8  left(ABCDEFG, -1)
     9  
    10  SELECT LEFT('ABCDEFG', 2+1);
    11  left(ABCDEFG, 2 + 1)
    12  ABC
    13  SELECT LEFT('ABCDEFG', ABS(-2));
    14  left(ABCDEFG, abs(-2))
    15  AB
    16  SELECT LEFT('ABCDEFG', COS(0));
    17  left(ABCDEFG, cos(0))
    18  A
    19  SELECT LEFT('ABCDEFG', LENGTH('KING'));
    20  left(ABCDEFG, length(KING))
    21  ABCD
    22  SELECT LEFT('ABCDEFG', NULL);
    23  left(ABCDEFG, null)
    24  null
    25  SELECT LEFT(NULL, 1);
    26  left(null, 1)
    27  null
    28  SELECT LEFT(NULL, 0);
    29  left(null, 0)
    30  null
    31  SELECT LEFT(NULL, -1);
    32  left(null, -1)
    33  null
    34  DROP TABLE IF EXISTS t;
    35  CREATE TABLE t(
    36  id INT,
    37  str1 VARCHAR(20),
    38  str2 CHAR(20),
    39  PRIMARY KEY (id)
    40  );
    41  INSERT INTO t VALUES (123456, 'anike1001@gmail.com', 'googood'), (123457, 'nitin5438@yahoo.com','hainghing');
    42  SELECT LEFT(id, 3), LEFT(str1, 5), LEFT(str2, 5) FROM t;
    43  left(id, 3)    left(str1, 5)    left(str2, 5)
    44  123    anike    googo
    45  123    nitin    haing
    46  SELECT LEFT(id, '1'), LEFT(str1, '1'), LEFT(str2, '1') FROM t;
    47  left(id, 1)    left(str1, 1)    left(str2, 1)
    48  1    a    g
    49  1    n    h
    50  SELECT LEFT(id, LENGTH(str1)/1-1), LEFT(str1, 1) FROM t;
    51  left(id, length(str1) / 1 - 1)    left(str1, 1)
    52  123456    a
    53  123457    n
    54  SELECT LEFT(id, FIND_IN_SET('b','a,b,c,d')), LEFT(str2, EMPTY(str1)) FROM t;
    55  left(id, find_in_set(b, a,b,c,d))    left(str2, empty(str1))
    56  12    
    57  12    
    58  SELECT LEFT(id, '-1'), LEFT(str1, '0') FROM t;
    59  left(id, -1)    left(str1, 0)
    60      
    61      
    62  SELECT LEFT(id, '1'+2), LEFT(str1, '1'+'1'), LEFT(str2, '1'+'0') FROM t;
    63  [unknown result because it is related to issue#5510]
    64  DROP TABLE IF EXISTS t;
    65  CREATE TABLE t(
    66  id INT,
    67  d1 DATE,
    68  d2 DATETIME,
    69  d3 TIMESTAMP,
    70  PRIMARY KEY (id)
    71  );
    72  INSERT INTO t VALUES (1, '2020-01-01', '2020-01-01 12:12:12', '2020-02-02 06:06:06.163');
    73  INSERT INTO t VALUES (2, '2021-11-11', '2021-01-11 23:23:23', '2021-12-12 16:16:16.843');
    74  SELECT LEFT(d1, MONTH(d1)), LEFT(d2, DAY(d2)) FROM t;
    75  left(d1, month(d1))    left(d2, day(d2))
    76  2    2
    77  2021-11-11    2021-01-11 
    78  SELECT LEFT(d2, LENGTH(d2)) FROM t;
    79  left(d2, length(d2))
    80  2020-01-01 12:12:12
    81  2021-01-11 23:23:23
    82  SELECT LEFT(d1, SIN(0)+MONTH(d1)) FROM t;
    83  left(d1, sin(0) + month(d1))
    84  2
    85  2021-11-11
    86  SELECT LEFT(d1, COS(10)+MONTH(d1)) FROM t;
    87  left(d1, cos(10) + month(d1))
    88  
    89  2021-11-11
    90  CREATE TABLE t(
    91  d INT,
    92  d1 BIGINT,
    93  d2 FLOAT,
    94  d3 DOUBLE,
    95  PRIMARY KEY (id)
    96  );
    97  [unknown result because it is related to issue#5511]
    98  DROP TABLE IF EXISTS t;
    99  CREATE TABLE t(
   100  d INT,
   101  d1 BIGINT,
   102  d2 FLOAT,
   103  d3 DOUBLE,
   104  PRIMARY KEY (d)
   105  );
   106  INSERT INTO t VALUES (1,101210131014,50565056.5566,80898089.8899);
   107  INSERT INTO t VALUES (2,46863515648464,9876453.3156153,6486454631564.156153489);
   108  SELECT LEFT(d1,3), LEFT(d2,4), LEFT(d3,5) FROM t;
   109  [unknown result because it is related to issue#5513]
   110  SELECT LEFT(d1,LENGTH(d1)), LEFT(d2,LENGTH(d2)) FROM t;
   111  [unknown result because it is related to issue#5513]
   112  DROP TABLE IF EXISTS t;
   113  DROP TABLE IF EXISTS t1;
   114  CREATE TABLE t(
   115  d INT,
   116  d1 VARCHAR(20),
   117  d2 BIGINT,
   118  PRIMARY KEY (d)
   119  );
   120  CREATE TABLE t1(
   121  d INT,
   122  d1 CHAR(20),
   123  d2 DATE,
   124  PRIMARY KEY (d)
   125  );
   126  INSERT INTO t VALUES (1,'lijklnfdsalj',19290988), (2,'xlziblkfdi',1949100132);
   127  INSERT INTO t VALUES (3,'ixioklakmaria',69456486), (4,'brzilaiusd',6448781575);
   128  INSERT INTO t1 VALUES (1,'usaisagoodnat','1970-01-02'),(2,'chanialfakbjap','1971-11-12');
   129  INSERT INTO t1 VALUES (3,'indiaisashit','1972-09-09'),(4,'xingoporelka','1973-12-07');
   130  SELECT t.d, LEFT(t.d1,FIND_IN_SET('d','a,b,c,d')) FROM t;
   131  d    left(t.d1, find_in_set(d, a,b,c,d))
   132  1    lijk
   133  2    xlzi
   134  3    ixio
   135  4    brzi
   136  SELECT t.d, LEFT(t.d2, FIND_IN_SET('d','a,b,c,d')), LEFT(t1.d1, ABS(-3)+1) FROM t,t1 WHERE t.d = t1.d;
   137  d    left(t.d2, find_in_set(d, a,b,c,d))    left(t1.d1, abs(-3) + 1)
   138  1    1929    usai
   139  2    1949    chan
   140  3    6945    indi
   141  4    6448    xing
   142  SELECT t.d, LEFT(t1.d2, NULL) FROM t JOIN t1 ON t.d = t1.d;
   143  d    left(t1.d2, null)
   144  1    null
   145  2    null
   146  3    null
   147  4    null
   148  SELECT t.d, LEFT(t1.d2, BIN(1)) FROM t RIGHT JOIN t1 ON t.d = t1.d;
   149  d    left(t1.d2, bin(1))
   150  1    1
   151  2    1
   152  3    1
   153  4    1
   154  SELECT t.d, LEFT(t1.d2, BIN(2)) FROM t RIGHT JOIN t1 ON t.d = t1.d;
   155  d    left(t1.d2, bin(2))
   156  1    1970-01-02
   157  2    1971-11-12
   158  3    1972-09-09
   159  4    1973-12-07
   160  DROP TABLE IF EXISTS t;
   161  DROP TABLE IF EXISTS t1;