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

use crate::util::*;
testcase!(test);
fn test(mut glue: multisql::Glue) {
	/* TODO: #51
	assert_select!(glue,
		"VALUES (CONVERT('TIMESTAMP', '2001-02-03'))" => unnamed_0 = I64:
		(981158400)
	);*/
	assert_select!(glue,
		"VALUES (CONVERT('TIMESTAMP', '981158400', 'TIMESTAMP'))" => unnamed_0 = I64:
		(981158400)
	);
	assert_select!(glue,
		"VALUES (CONVERT('TIMESTAMP', '981158400', 0))" => unnamed_0 = I64:
		(981158400)
	);
	assert_select!(glue,
		"VALUES (CONVERT('TIMESTAMP', '2001-02-03', 'DATE'))" => unnamed_0 = I64:
		(981158400)
	);
	assert_error!(
		glue,
		"VALUES (CONVERT('TIMESTAMP', '2001-02-03', 'DATETIME'))"
	);
	assert_select!(glue,
		"VALUES (CONVERT('TIMESTAMP', '2001-02-03 04:05', 'DATETIME'))" => unnamed_0 = I64:
		(981173100)
	);
	assert_error!(glue, "VALUES (CONVERT('TIMESTAMP', '2001-02-03', 'TIME'))");
	assert_select!(glue,
		"VALUES (CONVERT('TIMESTAMP', '04:05', 'TIME'))" => unnamed_0 = I64:
		(14700)
	);
	assert_select!(glue,
		"VALUES (CONVERT('TIMESTAMP', '04:05:00', 'TIME'))" => unnamed_0 = I64:
		(14700)
	);
	assert_select!(glue,
		"VALUES (CONVERT('TIMESTAMP', '04:05:06', 'TIME'))" => unnamed_0 = I64:
		(14706)
	);

	assert_select!(glue,
		"VALUES (CONVERT('TIMESTAMP', '03/02/2001', 'DATE'))" => unnamed_0 = I64:
		(981158400)
	);

	assert_select!(glue,
		"VALUES (CONVERT('TIMESTAMP', '13/02/2001', 'DATE'))" => unnamed_0 = I64:
		(982022400)
	);
	assert_error!(glue, "VALUES (CONVERT('TIMESTAMP', '02/13/2001', 'DATE'))");
	assert_select!(glue,
		"VALUES (CONVERT('TIMESTAMP', '03-Feb-2001', 'DATE'))" => unnamed_0 = I64:
		(981158400)
	);
	assert_select!(glue,
		"VALUES (CONVERT('TIMESTAMP', '03-Feb-01', 'DATE'))" => unnamed_0 = I64:
		(981158400)
	);
	assert_select!(glue,
		"VALUES (CONVERT('TIMESTAMP', '03-Feb-2001', 32))" => unnamed_0 = I64:
		(981158400)
	);
	assert_select!(glue,
		"VALUES (CONVERT('TIMESTAMP', '03-Feb-01', 32))" => unnamed_0 = I64:
		(-62132745600 as i64)
	);
	assert_error!(glue, "VALUES (CONVERT('TIMESTAMP', '03-Feb-2001', 33))");
	assert_select!(glue,
		"VALUES (CONVERT('TIMESTAMP', '03-Feb-01', 33))" => unnamed_0 = I64:
		(981158400)
	);

	assert_select!(glue,
		"VALUES (CONVERT('TIMESTAMP', '03/02/2001', 61))" => unnamed_0 = I64:
		(981158400)
	);
	assert_select!(glue,
		"VALUES (CONVERT('TIMESTAMP', '03/02/2001 04:05', 60))" => unnamed_0 = I64:
		(981173100)
	);
	assert_select!(glue,
		"VALUES (CAST('03/02/2001 04:05' AS TIMESTAMP))" => unnamed_0 = Timestamp:
		(981173100)
	);
}