github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/logictest/testdata/logic_test/cast (about)

     1  statement ok
     2  CREATE TABLE t45837 AS SELECT 1.25::decimal AS d
     3  
     4  # Test that decimals get rounded when casting.
     5  query T
     6  SELECT d::decimal(10,1) FROM t45837
     7  ----
     8  1.3
     9  
    10  statement ok
    11  CREATE TABLE t2 AS SELECT 18446744073709551616::FLOAT AS f
    12  
    13  statement error pgcode 22003 integer out of range
    14  SELECT f::int FROM t2
    15  
    16  # Regression test for #47327. Test that negative intervals are correctly
    17  # cast to a decimal.
    18  statement ok
    19  CREATE TABLE t0(c0 DECIMAL UNIQUE); INSERT INTO t0(c0) VALUES(0);
    20  
    21  statement ok
    22  CREATE TABLE t1(c0 DECIMAL); INSERT INTO t1(c0) VALUES(0);
    23  
    24  # Both of these queries should return no rows.
    25  query T
    26  SELECT t0.c0 FROM t0 WHERE t0.c0 BETWEEN t0.c0 AND INTERVAL '-1'::DECIMAL
    27  ----
    28  
    29  query T
    30  SELECT t1.c0 FROM t1 WHERE t1.c0 BETWEEN t1.c0 AND INTERVAL '-1'::DECIMAL
    31  ----