3
ASSERT TRIM(' abc ') = 'abc';
8
ASSERT TRIM('abc ') = 'abc';
9
ASSERT TRIM(' abc') = 'abc';
10
ASSERT CAST (TRIM(8 + 2.5) AS REAL) = 10.5;
11
ASSERT TRIM(' ab''c ') = 'ab''c';
15
DECLARE @A { @a, @b, @c };
16
SET @A[0][0] = 1.00001e-5;
17
SET @A[0][1] = 'I''m the game.';
18
SET @A[0][2] = 'I\'m the game.';
20
SET @A[1][1] = 'I''m the game.';
21
SET @A[1][2] = 'I\'m the game.';
22
SET @A[3][0] = 300001;
23
SET @A[3][1] = 'I''m ("the") game.';
24
SET @A[3][2] = 'I\'m (the) game.';
25
SET @B = CAST (@A AS STRING);
26
SET @C = CAST (@B AS RECORD);
27
ASSERT @A = @C AND @A <= @C AND @C >= @A;
29
ASSERT @C < @A AND @A <> @C;
31
ASSERT @C < @A AND @A <> @C;
34
ASSERT @A = @C AND @A <= @C AND @C >= @A;
36
DECLARE @A { @a, @b, @c };
45
SET @B = '(1, 2, 3) (1, 2) ( 1 , 2,3, 4) ';
46
SET @A = CAST (@B AS RECORD);
48
DECLARE @A { @a, @b, @c };
58
SET @B = '("abc", abc , abc) (1, 2, 3) ( 1 , 2,3, 4) ';
59
SET @A = CAST (@B AS RECORD);
63
ASSERT @B = CAST (@A AS INTEGER);
64
SET @C = CAST (CAST (@A AS INTEGER) AS STRING);
69
ASSERT @B = CAST (@A AS INTEGER);
70
SET @C = CAST (CAST (@A AS INTEGER) AS STRING);
75
ASSERT @B = CAST (@A AS REAL);
76
SET @C = CAST (CAST (@A AS REAL) AS STRING);
82
ASSERT @B = CAST (@A AS INTEGER);
83
ASSERT @C > CAST (@A AS INTEGER);
84
ASSERT CAST (@A AS INTEGER) = CAST (@C AS INTEGER);
88
ASSERT CAST (@A AS INTEGER) = 5;
89
ASSERT CAST (@A AS REAL) = 5.5;
90
ASSERT @A = CAST (5.5 AS RECORD);
93
SET @A[0][0] = '(I''m the game)';
94
SET @B = '(I''m the game)';
95
ASSERT @A = CAST (@B AS RECORD);