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
|
# Skip MySQL 5.6 as it does not support generated columns.
! only mysql56
apply 1.hcl
cmphcl 1.inspect.hcl
-- 1.hcl --
schema "$db" {
charset = "$charset"
collate = "$collate"
}
table "users" {
schema = schema.$db
column "a" {
type = bool
null = true
}
column "b" {
type = bool
null = true
as = "a"
}
column "c" {
type = bool
null = true
as {
type = STORED
expr = "b"
}
}
column "d e" {
null = false
type = varchar(255)
}
column "d $" {
null = false
type = varchar(255)
}
index "idx_1" {
columns = [column["d e"]]
}
index "idx_2" {
columns = [column["d $"]]
}
}
-- 1.inspect.hcl --
table "users" {
schema = schema.$db
column "a" {
null = true
type = bool
}
column "b" {
null = true
type = bool
as {
expr = "`a`"
type = VIRTUAL
}
}
column "c" {
null = true
type = bool
as {
expr = "`b`"
type = STORED
}
}
column "d e" {
null = false
type = varchar(255)
}
column "d $" {
null = false
type = varchar(255)
}
index "idx_1" {
columns = [column["d e"]]
}
index "idx_2" {
columns = [column["d $"]]
}
}
schema "$db" {
charset = "$charset"
collate = "$collate"
}
|
