multisql 0.4.3

MultiSQL
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108

use crate::util::*;
testcase!(test);
fn test(mut glue: multisql::Glue) {
	assert_select!(glue,
		"VALUES (IFNULL(NULL, 1))" => unnamed_0 = I64:
		(1)
	);
	assert_select!(glue,
		"VALUES (IFNULL(0, 1))" => unnamed_0 = I64:
		(0)
	);
	assert_select!(glue,
		"VALUES (NULLIF(0, 1))" => unnamed_0 = I64:
		(0)
	);
	assert_select!(glue,
		"VALUES (NULLIF(1, 0))" => unnamed_0 = I64:
		(1)
	);
	assert_select!(glue,
		"VALUES (NULLIF(1, 1))" => unnamed_0 = I64:
		(_)
	);
	assert_select!(glue,
		"VALUES (NULLIF(NULL, 1))" => unnamed_0 = I64:
		(_)
	);
	assert_select!(glue,
		"VALUES (NULLIF(1, NULL))" => unnamed_0 = I64:
		(1)
	);
	assert_select!(glue,
		"VALUES (NULLIF(1, 'String'))" => unnamed_0 = I64:
		(1)
	); // Should this be an error?

	assert_select!(glue,
		"VALUES (IIF(TRUE, 0, 1))" => unnamed_0 = I64:
		(0)
	);
	assert_select!(glue,
		"VALUES (IIF(FALSE, 0, 1))" => unnamed_0 = I64:
		(1)
	);
	assert_select!(glue,
		"VALUES (IIF(1=1, 0, 1))" => unnamed_0 = I64:
		(0)
	);
	assert_select!(glue,
		"VALUES (IIF(1=0, 0, 1))" => unnamed_0 = I64:
		(1)
	);
	assert_select!(glue,
		"VALUES (IIF(NULL=0, 0, 1))" => unnamed_0 = I64:
		(1)
	);
	assert_select!(glue,
		"VALUES (IIF(0=1, 'String', 1))" => unnamed_0 = I64:
		(1)
	);
	assert_select!(glue,
		"VALUES (IIF(1=1, 'String', 1))" => unnamed_0 = Str:
		(String::from("String"))
	);

	assert_select!(glue,
		"VALUES (LEN('Test'))" => unnamed_0 = I64:
		(4)
	);
	assert_select!(glue,
		"VALUES (LEN('Test test'))" => unnamed_0 = I64:
		(9)
	);
	/* TODO: #71
	assert_select!(glue,
		"VALUES (LEN(NULL))" => unnamed_0 = I64:
		(_)
	);*/

	assert_select!(glue,
		"VALUES (ROUND(1.7), ROUND(1.2), ROUND(0.9), ROUND(10000.7))" => unnamed_0 = F64, unnamed_1 = F64, unnamed_2 = F64, unnamed_3 = F64:
		(2.0, 1.0, 1.0, 10001.0)
	);

	assert_select!(glue,
		"VALUES (POW(2, 2), POW(10, 3))" => unnamed_0 = I64, unnamed_1 = I64:
		(4, 1000)
	);

	assert_select!(glue,
		"VALUES ('Hello!', REPLACE('Hello!', '!', '?'), REPLACE('Hello!!!', '!', '?'))" => unnamed_0 = Str, unnamed_1 = Str, unnamed_2 = Str:
		(String::from("Hello!"), String::from("Hello?"), String::from("Hello???"))
	);

	assert_select!(glue,
		"VALUES (CONCAT('Aee', 'Bee'), CONCAT('Aee', 'Bee', 'Cee'))" => unnamed_0 = Str, unnamed_1 = Str:
		(String::from("AeeBee"), String::from("AeeBeeCee"))
	);

	assert_success!(glue, "VALUES (CONCAT('Aee', 'Bee', 'Cee', NULL))");
	assert_success!(glue, "VALUES (UUID())");
	assert_success!(glue, "VALUES (RAND(), RAND(2, 300), RAND(-10,10))");
	assert_error!(glue, "VALUES (RAND(1))");

	glue.execute("VALUES (IIF(NULL, 0, 1))").unwrap_err(); // Should this be an error?
	glue.execute("VALUES (IIF(7, 0, 1))").unwrap_err();
	glue.execute("VALUES (LEN(100))").unwrap_err();
}