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

     1  #INSERT, 0.5 format函数,generated always as, charset Latin1暂不支持
     2  #create table t1 (a double, b double, c double generated always as (format(atan(a,b),6)) virtual) charset latin1;
     3  #insert into t1 values (-2,2,default);
     4  #insert into t1 values (format(PI(),6),0,default);
     5  #select * from t1;
     6  #drop table t1;
     7  
     8  #INSERT
     9  create table t1 (a double, b double, c double );
    10  insert into t1 select -2,2,0.6;
    11  insert into t1 select PI(),6,0;
    12  select * from t1;
    13  drop table t1;
    14  
    15  #SELECT, EXTREME VALUE
    16  SELECT PI() AS DefaultPiValue;
    17  SELECT PI()+0.000000000000000000 AS PiValue;
    18  
    19  CREATE TABLE Circle(Circle_id INT,  Radius DECIMAL(10, 3) NOT NULL,PRIMARY KEY(Circle_id ));
    20  INSERT INTO Circle(Radius )
    21  VALUES
    22  (2 ),(3),(10 ),(12.5 ),(6.80),
    23  (4.60 ),(6),(20),(25) ;
    24  
    25  #算式运算
    26  
    27  SELECT * FROM Circle;
    28  SELECT Circle_id, Radius,
    29  PI() * Radius * Radius  AS Area,
    30  2 * PI() * Radius AS Perimeter
    31  FROM Circle;
    32  drop table Circle;
    33  
    34  
    35  #SELECT, distinct
    36  SELECT distinct PI();
    37  
    38  #算术操作
    39  SELECT PI()-3.1415;
    40  
    41  #WHERE
    42  drop table if exists t1;
    43  create table t1(a INT,  b float);
    44  insert into t1 values(1,3.1415), (2, 4.14);
    45  select * from t1 where pi()-b<0.1;
    46  drop table t1;
    47  
    48  
    49  
    50  #HAVING，比较操作
    51  drop table if exists t1;
    52  create table t1(a INT,  b float);
    53  insert into t1 values(1, 1.1), (2,2.2);
    54  select b from t1 group by b having b<pi();
    55  drop table t1;
    56  
    57  #嵌套
    58  select pi(),sin(pi()/2);
    59  
    60  #ON
    61  create table t1(a INT,  b float);
    62  create table t2(a INT,  b float);
    63  insert into t1 values(12124, -4213.413), (12124, -42413.409);
    64  insert into t2 values(14124, -4213.413), (984798, -980.409);
    65  SELECT t1.a, t2.a FROM t1 JOIN t2 ON (t1.b+pi() = t2.b+pi());
    66  drop table t1;
    67  drop table t2;
    68  
    69  
    70  #科学计数
    71  select pi()-1.04e5;