1--echo #
2--echo # Testing cs->cset->strtoll10()
3--echo #
4
5SELECT @@character_set_connection;
6
7SELECT CAST('1' AS UNSIGNED);
8SELECT CAST('12' AS UNSIGNED);
9SELECT CAST('123' AS UNSIGNED);
10SELECT CAST('1234' AS UNSIGNED);
11SELECT CAST('12345' AS UNSIGNED);
12SELECT CAST('123456' AS UNSIGNED);
13SELECT CAST('1234567' AS UNSIGNED);
14SELECT CAST('12345678' AS UNSIGNED);
15SELECT CAST('123456789' AS UNSIGNED);
16SELECT CAST('1234567891' AS UNSIGNED);
17SELECT CAST('12345678912' AS UNSIGNED);
18SELECT CAST('123456789123' AS UNSIGNED);
19SELECT CAST('1234567891234' AS UNSIGNED);
20SELECT CAST('12345678912345' AS UNSIGNED);
21SELECT CAST('123456789123456' AS UNSIGNED);
22SELECT CAST('1234567891234567' AS UNSIGNED);
23SELECT CAST('12345678912345678' AS UNSIGNED);
24SELECT CAST('123456789123456789' AS UNSIGNED);
25SELECT CAST('1234567891234567891' AS UNSIGNED);
26SELECT CAST('12345678912345678912' AS UNSIGNED);
27SELECT CAST('123456789123456789123' AS UNSIGNED);
28
29SELECT CAST('1x' AS UNSIGNED);
30SELECT CAST('12x' AS UNSIGNED);
31SELECT CAST('123x' AS UNSIGNED);
32SELECT CAST('1234x' AS UNSIGNED);
33SELECT CAST('12345x' AS UNSIGNED);
34SELECT CAST('123456x' AS UNSIGNED);
35SELECT CAST('1234567x' AS UNSIGNED);
36SELECT CAST('12345678x' AS UNSIGNED);
37SELECT CAST('123456789x' AS UNSIGNED);
38SELECT CAST('1234567891x' AS UNSIGNED);
39SELECT CAST('12345678912x' AS UNSIGNED);
40SELECT CAST('123456789123x' AS UNSIGNED);
41SELECT CAST('1234567891234x' AS UNSIGNED);
42SELECT CAST('12345678912345x' AS UNSIGNED);
43SELECT CAST('123456789123456x' AS UNSIGNED);
44SELECT CAST('1234567891234567x' AS UNSIGNED);
45SELECT CAST('12345678912345678x' AS UNSIGNED);
46SELECT CAST('123456789123456789x' AS UNSIGNED);
47SELECT CAST('1234567891234567891x' AS UNSIGNED);
48SELECT CAST('12345678912345678912x' AS UNSIGNED);
49SELECT CAST('123456789123456789123x' AS UNSIGNED);
50