github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/expression/set_variable.sql (about)

     1  SET @val = CAST(0 AS UNSIGNED);
     2  select @val;
     3  
     4  SET @val = CAST(0 AS bool);
     5  select @val;
     6  
     7  SET @val = CAST(0 AS varchar);
     8  select @val;
     9  
    10  SET @val = CAST(0 AS char);
    11  select @val;
    12  
    13  SET @val = CAST("2022-10-10" AS date);
    14  select @val;
    15  SET @val = CAST("2022-10-10" AS datetime);
    16  select @val;
    17  SET @val = CAST("2022-10-10" AS timestamp);
    18  select @val;
    19  
    20  SET @val = CAST('0' AS text);
    21  select @val;
    22  
    23  SET @val = CAST('0' AS blob);
    24  select @val;