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

     1  SET @val = CAST(0 AS UNSIGNED);
     2  select @val;
     3  @val
     4  0
     5  SET @val = CAST(0 AS bool);
     6  select @val;
     7  @val
     8  false
     9  SET @val = CAST(0 AS varchar);
    10  select @val;
    11  @val
    12  0
    13  SET @val = CAST(0 AS char);
    14  select @val;
    15  @val
    16  0
    17  SET @val = CAST("2022-10-10" AS date);
    18  select @val;
    19  @val
    20  2022-10-10
    21  SET @val = CAST("2022-10-10" AS datetime);
    22  select @val;
    23  @val
    24  2022-10-10 00:00:00
    25  SET @val = CAST("2022-10-10" AS timestamp);
    26  select @val;
    27  @val
    28  2022-10-10 00:00:00
    29  SET @val = CAST('0' AS text);
    30  select @val;
    31  @val
    32  0
    33  SET @val = CAST('0' AS blob);
    34  select @val;
    35  @val
    36  0