1
SELECT CAST("12" AS SIGNED);
4
SELECT CAST(12 AS SIGNED);
7
SELECT CAST(0 AS SIGNED);
10
SELECT CAST("0" AS SIGNED);
13
SELECT CAST(0.0 AS SIGNED);
16
SELECT CAST(0.1 AS SIGNED);
19
SELECT CAST(0.4 AS SIGNED);
22
SELECT CAST(0.5 AS SIGNED);
25
SELECT CAST(0.9 AS SIGNED);
28
SELECT CAST(10.1 AS SIGNED);
31
SELECT CAST("18446744073709551615" AS SIGNED);
32
ERROR HY000: Invalid cast to signed integer: 18446744073709551615
33
SELECT CAST(18446744073709551615 AS SIGNED);
34
ERROR HY000: Invalid cast to signed integer: 18446744073709551615
35
SELECT CAST(-1 AS SIGNED);
38
SELECT CAST(-18446744073709551614 AS SIGNED);
39
ERROR HY000: Invalid cast to signed integer: -18446744073709551614
40
SELECT CAST(-18446744073709551615 AS SIGNED);
41
ERROR HY000: Invalid cast to signed integer: -18446744073709551615
42
SELECT CAST("-1" AS SIGNED);
45
SELECT CAST("-18446744073709551614" AS SIGNED);
46
ERROR HY000: Invalid cast to signed integer: -18446744073709551614
47
SELECT CAST("-18446744073709551615" AS SIGNED);
48
ERROR HY000: Invalid cast to signed integer: -18446744073709551615
49
SELECT CAST(-1.1 AS SIGNED);
52
SELECT CAST(-18446744073709551614.1 AS SIGNED);
53
ERROR HY000: Invalid cast to signed integer: -18446744073709551614.1
54
SELECT CAST(-18446744073709551615.1 AS SIGNED);
55
ERROR HY000: Invalid cast to signed integer: -18446744073709551615.1
56
SELECT CAST("-1.1" AS SIGNED);
57
CAST("-1.1" AS SIGNED)
59
SELECT CAST("-18446744073709551614.1" AS SIGNED);
60
ERROR HY000: Invalid cast to signed integer: -18446744073709551614.1
61
SELECT CAST("-18446744073709551615.1" AS SIGNED);
62
ERROR HY000: Invalid cast to signed integer: -18446744073709551615.1
63
SELECT CAST(9223372036854775807 AS SIGNED);
64
CAST(9223372036854775807 AS SIGNED)
66
SELECT CAST(9223372036854775808 AS SIGNED);
67
ERROR HY000: Invalid cast to signed integer: 9223372036854775808
68
SELECT CAST(-9223372036854775809 AS SIGNED);
69
ERROR HY000: Invalid cast to signed integer: -9223372036854775809
70
SELECT CAST(-9223372036854775808 AS SIGNED);
71
CAST(-9223372036854775808 AS SIGNED)
73
SELECT CAST(-9223372036854775807 AS SIGNED);
74
CAST(-9223372036854775807 AS SIGNED)
76
SELECT CAST(-9223372036854775806 AS SIGNED);
77
CAST(-9223372036854775806 AS SIGNED)
79
SELECT CAST(-9223372036854775805 AS SIGNED);
80
CAST(-9223372036854775805 AS SIGNED)