~stewart/drizzle/docs-improvements-1

« back to all changes in this revision

Viewing changes to tests/suite/cast/t/unsigned.test

• browse files at revision 1994.4.18
• compare with another revision
• download diff
• download tarball
• view history from revision 1994.4.18

Show diffs side-by-side

added

removed

tests/suite/cast/t/unsigned.test

 

1

SELECT CAST("12" AS UNSIGNED);

 

2

SELECT CAST(12 AS UNSIGNED);

 

3

SELECT CAST(0 AS UNSIGNED);

 

4

SELECT CAST("0" AS UNSIGNED);

 

5

 

 

6

 

 

7

# Check rounding issues for CAST

 

8

SELECT CAST(0.0 AS UNSIGNED);

 

9

SELECT CAST(0.1 AS UNSIGNED);

 

10

SELECT CAST(0.4 AS UNSIGNED);

 

11

SELECT CAST(0.5 AS UNSIGNED);

 

12

SELECT CAST(0.9 AS UNSIGNED);

 

13

SELECT CAST(10.1 AS UNSIGNED);

 

14

 

 

15

 

 

16

SELECT CAST("18446744073709551615" AS UNSIGNED);

 

17

SELECT CAST(18446744073709551615 AS UNSIGNED);

 

18

 

 

19

--error ER_INVALID_CAST_TO_UNSIGNED

 

20

SELECT CAST(-1 AS UNSIGNED);

 

21

--error ER_INVALID_CAST_TO_UNSIGNED

 

22

SELECT CAST(-18446744073709551614 AS UNSIGNED);

 

23

--error ER_INVALID_CAST_TO_UNSIGNED

 

24

SELECT CAST(-18446744073709551615 AS UNSIGNED);

 

25

 

 

26

--error ER_INVALID_CAST_TO_UNSIGNED

 

27

SELECT CAST("-1" AS UNSIGNED);

 

28

--error ER_INVALID_CAST_TO_UNSIGNED

 

29

SELECT CAST("-18446744073709551614" AS UNSIGNED);

 

30

--error ER_INVALID_CAST_TO_UNSIGNED

 

31

SELECT CAST("-18446744073709551615" AS UNSIGNED);

 

32

 

 

33

--error ER_INVALID_CAST_TO_UNSIGNED

 

34

SELECT CAST(-1.1 AS UNSIGNED);

 

35

--error ER_INVALID_CAST_TO_UNSIGNED

 

36

SELECT CAST(-18446744073709551614.1 AS UNSIGNED);

 

37

--error ER_INVALID_CAST_TO_UNSIGNED

 

38

SELECT CAST(-18446744073709551615.1 AS UNSIGNED);

 

39

 

 

40

--error ER_INVALID_CAST_TO_UNSIGNED

 

41

SELECT CAST("-1.1" AS UNSIGNED);

 

42

--error ER_INVALID_CAST_TO_UNSIGNED

 

43

SELECT CAST("-18446744073709551614.1" AS UNSIGNED);

 

44

--error ER_INVALID_CAST_TO_UNSIGNED

 

45

SELECT CAST("-18446744073709551615.1" AS UNSIGNED);

 

46

 

 

47

--error ER_INVALID_CAST_TO_UNSIGNED

 

48

SELECT CAST("-18446744073709551615.1" AS UNSIGNED);

 

49

 

 

50

SELECT CAST(-(-1) AS UNSIGNED);

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1