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

     1  create table t1 (a double, b double, c double );
     2  insert into t1 select -2,2,0.6;
     3  insert into t1 select PI(),6,0;
     4  select * from t1;
     5  a	b	c
     6  -2.0	2.0	0.6
     7  3.141592653589793	6.0	0.0
     8  drop table t1;
     9  SELECT PI() AS DefaultPiValue;
    10  DefaultPiValue
    11  3.141593
    12  SELECT PI()+0.000000000000000000 AS PiValue;
    13  PiValue
    14  3.141592653589793
    15  CREATE TABLE Circle(Circle_id INT,  Radius DECIMAL(10, 3) NOT NULL,PRIMARY KEY(Circle_id ));
    16  INSERT INTO Circle(Radius )
    17  VALUES
    18  (2 ),(3),(10 ),(12.5 ),(6.80),
    19  (4.60 ),(6),(20),(25) ;
    20  invalid input: invalid default value for column 'circle_id'
    21  SELECT * FROM Circle;
    22  Circle_id	Radius
    23  SELECT Circle_id, Radius,
    24  PI() * Radius * Radius  AS Area,
    25  2 * PI() * Radius AS Perimeter
    26  FROM Circle;
    27  Circle_id	Radius	Area	Perimeter
    28  drop table Circle;
    29  SELECT distinct PI();
    30  PI()
    31  3.141593
    32  SELECT PI()-3.1415;
    33  pi() - 3.1415
    34  9.265358979293481E-5
    35  drop table if exists t1;
    36  create table t1(a INT,  b float);
    37  insert into t1 values(1,3.1415), (2, 4.14);
    38  select * from t1 where pi()-b<0.1;
    39  a	b
    40  1	3.1415
    41  2	4.14
    42  drop table t1;
    43  drop table if exists t1;
    44  create table t1(a INT,  b float);
    45  insert into t1 values(1, 1.1), (2,2.2);
    46  select b from t1 group by b having b<pi();
    47  b
    48  1.1
    49  2.2
    50  drop table t1;
    51  select pi(),sin(pi()/2);
    52  pi()	sin(pi()/2)
    53  3.141593	1.0
    54  create table t1(a INT,  b float);
    55  create table t2(a INT,  b float);
    56  insert into t1 values(12124, -4213.413), (12124, -42413.409);
    57  insert into t2 values(14124, -4213.413), (984798, -980.409);
    58  SELECT t1.a, t2.a FROM t1 JOIN t2 ON (t1.b+pi() = t2.b+pi());
    59  a	a
    60  12124	14124
    61  drop table t1;
    62  drop table t2;
    63  select pi()-1.04e5;
    64  pi()-1.04e5
    65  -103996.85840734642