Lines Matching refs:CAST
730 49 "CAST ( EXPR AS integer )"
731 50 "CAST ( EXPR AS 'abcd' )"
732 51 "CAST ( EXPR AS 'ab$ $cd' )"
1415 # Test statements related to CAST expressions.
1417 # EVIDENCE-OF: R-20854-17109 A CAST conversion is similar to the
1419 # value except that with the CAST operator the conversion always takes
1431 typeof(CAST(X'555655' as TEXT)), CAST(X'555655' as TEXT),
1432 typeof(CAST('1.23abc' as REAL)), CAST('1.23abc' as REAL),
1433 typeof(CAST(4.5 as INTEGER)), CAST(4.5 as INTEGER)
1437 # result of the CAST expression is also NULL.
1439 do_expr_test e_expr-27.2.1 { CAST(NULL AS integer) } null {}
1440 do_expr_test e_expr-27.2.2 { CAST(NULL AS text) } null {}
1441 do_expr_test e_expr-27.2.3 { CAST(NULL AS blob) } null {}
1442 do_expr_test e_expr-27.2.4 { CAST(NULL AS number) } null {}
1454 do_expr_test e_expr-27.3.1 { CAST('abc' AS blob) } blob abc
1455 do_expr_test e_expr-27.3.2 { CAST('def' AS shobblob_x) } blob def
1456 do_expr_test e_expr-27.3.3 { CAST('ghi' AS abbLOb10) } blob ghi
1462 do_qexpr_test e_expr-27.4.1 { CAST('ghi' AS blob) } X'676869'
1463 do_qexpr_test e_expr-27.4.2 { CAST(456 AS blob) } X'343536'
1464 do_qexpr_test e_expr-27.4.3 { CAST(1.78 AS blob) } X'312E3738'
1469 do_qexpr_test e_expr-27.4.4 { CAST('ghi' AS blob) } X'670068006900'
1470 do_qexpr_test e_expr-27.4.5 { CAST(456 AS blob) } X'340035003600'
1471 do_qexpr_test e_expr-27.4.6 { CAST(1.78 AS blob) } X'31002E0037003800'
1477 do_qexpr_test e_expr-27.4.7 { CAST('ghi' AS blob) } X'006700680069'
1478 do_qexpr_test e_expr-27.4.8 { CAST(456 AS blob) } X'003400350036'
1479 do_qexpr_test e_expr-27.4.9 { CAST(1.78 AS blob) } X'0031002E00370038'
1488 do_expr_test e_expr-28.1.1 { CAST (X'676869' AS text) } text ghi
1489 do_expr_test e_expr-28.1.2 { CAST (X'670068006900' AS text) } text g
1494 do_expr_test e_expr-28.1.3 { CAST (X'676869' AS text) == 'ghi' } integer 0
1495 do_expr_test e_expr-28.1.4 { CAST (X'670068006900' AS text) } text ghi
1504 do_expr_test e_expr-28.2.1 { CAST (1 AS text) } text 1
1505 do_expr_test e_expr-28.2.2 { CAST (45 AS text) } text 45
1506 do_expr_test e_expr-28.2.3 { CAST (-45 AS text) } text -45
1507 do_expr_test e_expr-28.2.4 { CAST (8.8 AS text) } text 8.8
1508 do_expr_test e_expr-28.2.5 { CAST (2.3e+5 AS text) } text 230000.0
1509 do_expr_test e_expr-28.2.6 { CAST (-2.3e-5 AS text) } text -2.3e-05
1510 do_expr_test e_expr-28.2.7 { CAST (0.0 AS text) } text 0.0
1511 do_expr_test e_expr-28.2.7 { CAST (0 AS text) } text 0
1516 do_expr_test e_expr-29.1.1 { CAST (X'312E3233' AS REAL) } real 1.23
1517 do_expr_test e_expr-29.1.2 { CAST (X'3233302E30' AS REAL) } real 230.0
1518 do_expr_test e_expr-29.1.3 { CAST (X'2D392E3837' AS REAL) } real -9.87
1519 do_expr_test e_expr-29.1.4 { CAST (X'302E30303031' AS REAL) } real 0.0001
1525 CAST (X'31002E0032003300' AS REAL) } real 1.23
1527 CAST (X'3200330030002E003000' AS REAL) } real 230.0
1529 CAST (X'2D0039002E0038003700' AS REAL) } real -9.87
1531 CAST (X'30002E003000300030003100' AS REAL) } real 0.0001
1540 do_expr_test e_expr-29.2.1 { CAST('1.23abcd' AS REAL) } real 1.23
1541 do_expr_test e_expr-29.2.2 { CAST('1.45.23abcd' AS REAL) } real 1.45
1542 do_expr_test e_expr-29.2.3 { CAST('-2.12e-01ABC' AS REAL) } real -0.212
1543 do_expr_test e_expr-29.2.4 { CAST('1 2 3 4' AS REAL) } real 1.0
1548 do_expr_test e_expr-29.3.1 { CAST(' 1.23abcd' AS REAL) } real 1.23
1549 do_expr_test e_expr-29.3.2 { CAST(' 1.45.23abcd' AS REAL) } real 1.45
1550 do_expr_test e_expr-29.3.3 { CAST(' -2.12e-01ABC' AS REAL) } real -0.212
1551 do_expr_test e_expr-29.3.4 { CAST(' 1 2 3 4' AS REAL) } real 1.0
1556 do_expr_test e_expr-29.4.1 { CAST('' AS REAL) } real 0.0
1557 do_expr_test e_expr-29.4.2 { CAST('not a number' AS REAL) } real 0.0
1558 do_expr_test e_expr-29.4.3 { CAST('XXI' AS REAL) } real 0.0
1563 do_expr_test e_expr-30.1.1 { CAST(X'313233' AS INTEGER) } integer 123
1564 do_expr_test e_expr-30.1.2 { CAST(X'2D363738' AS INTEGER) } integer -678
1566 CAST(X'31303030303030' AS INTEGER)
1569 CAST(X'2D31313235383939393036383432363234' AS INTEGER)
1576 do_expr_test e_expr-30.1.5 { CAST(X'003100320033' AS INTEGER) } integer 123
1577 do_expr_test e_expr-30.1.6 { CAST(X'002D003600370038' AS INTEGER) } integer -678
1579 CAST(X'0031003000300030003000300030' AS INTEGER)
1582 CAST(X'002D0031003100320035003800390039003900300036003800340032003600320034' AS INTEGER)
1593 do_expr_test e_expr-30.2.1 { CAST('123abcd' AS INT) } integer 123
1594 do_expr_test e_expr-30.2.2 { CAST('14523abcd' AS INT) } integer 14523
1595 do_expr_test e_expr-30.2.3 { CAST('-2.12e-01ABC' AS INT) } integer -2
1596 do_expr_test e_expr-30.2.4 { CAST('1 2 3 4' AS INT) } integer 1
1601 do_expr_test e_expr-30.3.1 { CAST(' 123abcd' AS INT) } integer 123
1602 do_expr_test e_expr-30.3.2 { CAST(' 14523abcd' AS INT) } integer 14523
1603 do_expr_test e_expr-30.3.3 { CAST(' -2.12e-01ABC' AS INT) } integer -2
1604 do_expr_test e_expr-30.3.4 { CAST(' 1 2 3 4' AS INT) } integer 1
1609 do_expr_test e_expr-30.4.1 { CAST('' AS INTEGER) } integer 0
1610 do_expr_test e_expr-30.4.2 { CAST('not a number' AS INTEGER) } integer 0
1611 do_expr_test e_expr-30.4.3 { CAST('XXI' AS INTEGER) } integer 0
1613 # EVIDENCE-OF: R-08980-53124 The CAST operator understands decimal
1616 # result of the CAST is always zero.
1617 do_expr_test e_expr-30.5.1 { CAST('0x1234' AS INTEGER) } integer 0
1618 do_expr_test e_expr-30.5.2 { CAST('0X1234' AS INTEGER) } integer 0
1624 do_expr_test e_expr-31.1.1 { CAST(3.14159 AS INTEGER) } integer 3
1625 do_expr_test e_expr-31.1.2 { CAST(1.99999 AS INTEGER) } integer 1
1626 do_expr_test e_expr-31.1.3 { CAST(-1.99999 AS INTEGER) } integer -1
1627 do_expr_test e_expr-31.1.4 { CAST(-0.99999 AS INTEGER) } integer 0
1635 do_expr_test e_expr-31.2.1 { CAST(2e+50 AS INT) } integer 9223372036854775807
1636 do_expr_test e_expr-31.2.2 { CAST(-2e+50 AS INT) } integer -9223372036854775808
1638 CAST(-9223372036854775809.0 AS INT)
1641 CAST(9223372036854775809.0 AS INT)
1657 do_expr_test e_expr-32.1.1 { CAST('45' AS NUMERIC) } integer 45
1658 do_expr_test e_expr-32.1.2 { CAST('45.0' AS NUMERIC) } integer 45
1659 do_expr_test e_expr-32.1.3 { CAST('45.2' AS NUMERIC) } real 45.2
1660 do_expr_test e_expr-32.1.4 { CAST('11abc' AS NUMERIC) } integer 11
1661 do_expr_test e_expr-32.1.5 { CAST('11.1abc' AS NUMERIC) } real 11.1
1662 do_expr_test e_expr-32.1.6 {CAST( '9.223372036e14' AS NUMERIC)} integer 922337203600000
1663 do_expr_test e_expr-32.1.7 {CAST('-9.223372036e14' AS NUMERIC)} integer -922337203600000
1665 set expr {CAST( '9.223372036e15' AS NUMERIC)}
1670 set expr {CAST('-9.223372036e15' AS NUMERIC)}
1678 do_expr_test e_expr-32.1.20 { CAST('9223372036854775807' AS numeric) } \
1680 do_expr_test e_expr-32.1.21 { CAST('9223372036854775808' AS numeric) } \
1682 do_expr_test e_expr-32.1.22 { CAST('-9223372036854775808' AS numeric) } \
1684 do_expr_test e_expr-32.1.23 { CAST('-9223372036854775809' AS numeric) } \
1691 do_expr_test e_expr-32.2.1 { CAST(13.0 AS NUMERIC) } real 13.0
1692 do_expr_test e_expr-32.2.2 { CAST(13.5 AS NUMERIC) } real 13.5
1695 CAST(-9223372036854775808 AS NUMERIC)
1698 CAST(9223372036854775807 AS NUMERIC)
1701 CAST('9223372036854775807 ' AS NUMERIC)
1704 CAST(' 9223372036854775807 ' AS NUMERIC)
1707 CAST(' ' AS NUMERIC)
1726 SELECT typeof(CAST(x AS NUMERIC)), CAST(x AS NUMERIC)||'' FROM t1;
1755 1 { CAST(123 AS BLOB) } 1
1756 2 { CAST('' AS BLOB) } 0
1757 3 { CAST('abcd' AS BLOB) } 1
1759 4 { CAST(X'abcd' AS TEXT) } 1
1760 5 { CAST(X'' AS TEXT) } 0