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

     1  select sleep();
     2  invalid argument function sleep, bad value []
     3  select sleep(1);
     4  sleep(1)
     5  0
     6  select sleep(1.5);
     7  sleep(1.5)
     8  0
     9  select sleep(null);
    10  invalid argument sleep, bad value input contains null
    11  select sleep(-1);
    12  invalid argument sleep, bad value input contains negative
    13  select sleep(-1.5);
    14  invalid argument sleep, bad value input contains negative
    15  create table t1 (a int,b int);
    16  insert into t1 values (1,1),(1,null);
    17  select sleep(a) from t1;
    18  sleep(a)
    19  0
    20  0
    21  select sleep(b) from t1;
    22  invalid argument sleep, bad value input contains null
    23  SELECT sleep(0);
    24  sleep(0)
    25  0
    26  SELECT sleep(1);
    27  sleep(1)
    28  0
    29  SELECT sleep(0.33);
    30  sleep(0.33)
    31  0
    32  SELECT sleep(-2);
    33  invalid argument sleep, bad value input contains negative
    34  SELECT sleep(-23.1);
    35  invalid argument sleep, bad value input contains negative
    36  DROP TABLE IF EXISTS sleep_01;
    37  CREATE TABLE sleep_01 (id int);
    38  SELECT * ,sleep(0.2) from sleep_01;
    39  id    sleep(0.2)
    40  INSERT INTO sleep_01 VALUES(273);
    41  SELECT *, sleep(1.2) FROM sleep_01;
    42  id    sleep(1.2)
    43  273    0
    44  SELECT *, sleep(0) FROM sleep_01;
    45  id    sleep(0)
    46  273    0
    47  INSERT INTO sleep_01 VALUES(-32783);
    48  SELECT *,sleep(0.2) FROM sleep_01;
    49  id    sleep(0.2)
    50  273    0
    51  -32783    0
    52  SELECT *,sleep(0) FROM sleep_01;
    53  id    sleep(0)
    54  273    0
    55  -32783    0
    56  INSERT INTO sleep_01 VALUES(0);
    57  SELECT * ,sleep(0.2) FROM sleep_01;
    58  id    sleep(0.2)
    59  273    0
    60  -32783    0
    61  0    0
    62  SELECT *, sleep(0) FROM sleep_01;
    63  id    sleep(0)
    64  273    0
    65  -32783    0
    66  0    0
    67  DROP TABLE IF EXISTS sleep_02;
    68  CREATE TABLE sleep_02 (id int, name VARCHAR(10), province VARCHAR(100) NOT NULL, address VARCHAR(100));
    69  INSERT INTO sleep_02 VALUES(1, '张三', '陕西', '大头村二组');
    70  INSERT INTO sleep_02 VALUES(2, '李四', '北京', '快乐村三组');
    71  INSERT INTO sleep_02 VALUES(3, '王五', '陕西', '美丽村四组');
    72  SELECT province, address, sleep(2) FROM sleep_02 WHERE name = '张三';
    73  province    address    sleep(2)
    74  陕西    大头村二组    0
    75  SELECT name, sleep(0.3) FROM sleep_02 WHERE address = '大头村二组' AND province = '陕西';
    76  name    sleep(0.3)
    77  张三    0
    78  SELECT *, sleep(0.2) FROM sleep_02 WHERE id = COS(0) + TAN(45);
    79  id    name    province    address    sleep(0.2)
    80  SELECT name, province, sleep(0.2) FROM sleep_02;
    81  name    province    sleep(0.2)
    82  张三    陕西    0
    83  李四    北京    0
    84  王五    陕西    0
    85  DROP TABLE IF EXISTS sleep_03;
    86  DROP TABLE IF EXISTS sleep_04;
    87  CREATE TABLE sleep_03(d INT,d1 VARCHAR(20), d2 BIGINT,PRIMARY KEY (d));
    88  CREATE TABLE sleep_04( d INT,d1 CHAR(20),d2 DATE,PRIMARY KEY (d));
    89  INSERT INTO sleep_03 VALUES (1,'lijklnfdsalj',19290988);
    90  INSERT INTO sleep_03 VALUES (2,'xlziblkfdi',1949100132);
    91  INSERT INTO sleep_03 VALUES (3,'ixioklakmaria',69456486);
    92  INSERT INTO sleep_03 VALUES (4,'brzilaiusd',6448781575);
    93  INSERT INTO sleep_04 VALUES (1,'usaisagoodnat','1970-01-02');
    94  INSERT INTO sleep_04 VALUES (2,'chanialfakbjap','1971-11-12');
    95  INSERT INTO sleep_04 VALUES (3,'indiaisashit','1972-09-09');
    96  INSERT INTO sleep_04 VALUES (4,'xingoporelka','1973-12-07');
    97  SELECT sleep_03.d, sleep(0) FROM sleep_03,sleep_04 WHERE sleep_03.d = sleep_04.d;
    98  d    sleep(0)
    99  1    0
   100  2    0
   101  3    0
   102  4    0
   103  SELECT sleep_03.d, sleep(0.1) FROM sleep_03;
   104  d    sleep(0.1)
   105  1    0
   106  2    0
   107  3    0
   108  4    0
   109  SELECT sleep_03.d, sleep_03.d1, sleep(0.4) FROM sleep_03 JOIN sleep_04 ON sleep_03.d = sleep_04.d;
   110  d    d1    sleep(0.4)
   111  1    lijklnfdsalj    0
   112  2    xlziblkfdi    0
   113  3    ixioklakmaria    0
   114  4    brzilaiusd    0
   115  SELECT sleep_03.d, sleep(1) FROM sleep_03 join sleep_04 on sleep_03.d=sleep_04.d;
   116  d    sleep(1)
   117  1    0
   118  2    0
   119  3    0
   120  4    0
   121  SELECT sleep_03.d, sleep(0.432)FROM sleep_03 right join sleep_04 on sleep_03.d=sleep_04.d;
   122  d    sleep(0.432)
   123  1    0
   124  2    0
   125  3    0
   126  4    0
   127  SELECT d, sleep(0.5) FROM sleep_03 ORDER BY d2 desc;
   128  d    sleep(0.5)
   129  4    0
   130  2    0
   131  3    0
   132  1    0
   133  select sleep();
   134  invalid argument function sleep, bad value []
   135  select sleep(1);
   136  sleep(1)
   137  0
   138  select sleep(1.5);
   139  sleep(1.5)
   140  0
   141  select sleep(null);
   142  invalid argument sleep, bad value input contains null
   143  select sleep(-1);
   144  invalid argument sleep, bad value input contains negative
   145  select sleep(-1.5);
   146  invalid argument sleep, bad value input contains negative
   147  create table t1 (a int,b int);
   148  table t1 already exists
   149  insert into t1 values (1,1),(1,null);
   150  select sleep(a) from t1;
   151  sleep(a)
   152  0
   153  0
   154  0
   155  0
   156  select sleep(b) from t1;
   157  invalid argument sleep, bad value input contains null