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

use crate::util::*;
testcase!(test);
fn test(mut glue: multisql::Glue) {
	make_basic_table!(glue);

	assert_select!(glue, r#"
		WITH cte AS (
			SELECT
				a
			FROM
				basic
		)
		SELECT
			a
		FROM
			cte
	"# => a = I64: (1));

	assert_select!(glue, r#"
		WITH cte_0 AS (
			SELECT
				a
			FROM
				basic
		), cte_1 AS (
			SELECT
				a
			FROM
				cte_0
		)
		SELECT
			a
		FROM
			cte_1
	"# => a = I64: (1));

	/* TODO: #107
		glue.execute(
			r#"
		WITH cte_0 AS (
			SELECT
				a
			FROM
				cte_1
		), cte_1 AS (
			SELECT
				a
			FROM
				basic
		)
		SELECT
			a
		FROM
			cte_0
	"#,
		)
		.expect_err("CTE is not simultaneous");
		*/

	glue.execute("CREATE TABLE basic_insert (a INTEGER)")
		.unwrap();

	assert_select!(glue, r#"
		WITH basic_inserted AS (
			INSERT INTO basic_insert
			SELECT
				a
			FROM
				basic
		)
		SELECT
			a
		FROM
			basic_inserted
	"# => a = I64: (1));

	assert_select!(glue, r#"
		SELECT
			a
		FROM
			basic_insert
	"# => a = I64: (1));
}