ydb/yql/essentials/tests/sql/suites/expr/longint_builtins.sql

/* postgres can not */
-- not supported on windows
$value = "1000000000000";
$negative = -1000000000000;
$longint = YQL::StrictFromString($value, AsAtom("Decimal"), AsAtom("32"), AsAtom("0"));
$negative_longint = CAST($negative AS Decimal(32,0));
$add = $longint + CAST("1111111111111111111111111111111" AS Decimal(32,0));
$div = $longint / CAST(1111 AS Decimal(32,0));
$mod = $longint % CAST(1111 AS Decimal(32,0));
$mul = $longint * CAST(333333333333333333 AS Decimal(32,0));
$sub = $longint - CAST("1111111111111111111111111111111" AS Decimal(32,0));
SELECT 
    $longint AS binary,
    YQL::ToString(YQL::Dec($longint)) AS to_string,
    CAST(YQL::Inc(Abs($negative_longint)) AS String) AS abs,
    CAST(YQL::Minus($add) AS String) AS add,
    CAST($div AS String) AS div,
    CAST($mod AS String) AS mod,
    CAST($mul AS String) AS mul,
    CAST($sub AS String) AS sub,
    $longint == YQL::Abs($negative_longint) AS eq,
    $div <= $longint AS cmp;