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
|
apply 1.hcl
cmpshow users 1.sql
# Drop the "DESC" option from the key part.
apply 2.hcl
cmpshow users 2.sql
# Use of "columns" instead of "on" should not trigger a change.
synced 2-no-change.hcl
apply 3.hcl
cmpshow users 3.sql
-- 1.hcl --
schema "main" {}
table "users" {
schema = schema.main
column "rank" {
type = int
}
index "rank_idx" {
on {
desc = true
column = table.users.column.rank
}
}
}
-- 1.sql --
CREATE TABLE `users` (`rank` int NOT NULL)
CREATE INDEX `rank_idx` ON `users` (`rank` DESC)
-- 2.hcl --
schema "main" {}
table "users" {
schema = schema.main
column "rank" {
type = int
}
index "rank_idx" {
on {
column = table.users.column.rank
}
}
}
-- 2.sql --
CREATE TABLE "users" (`rank` int NOT NULL)
CREATE INDEX `rank_idx` ON `users` (`rank`)
-- 2-no-change.hcl --
schema "main" {}
table "users" {
schema = schema.main
column "rank" {
type = int
}
index "rank_idx" {
columns = [
table.users.column.rank,
]
}
}
-- 3.hcl --
schema "main" {}
table "users" {
schema = schema.main
column "rank" {
type = int
}
column "score" {
type = int
}
index "rank_score_idx" {
on {
column = table.users.column.rank
}
on {
column = table.users.column.score
desc = true
}
}
}
-- 3.sql --
CREATE TABLE "users" (`rank` int NOT NULL, `score` int NOT NULL)
CREATE INDEX `rank_score_idx` ON `users` (`rank`, `score` DESC)
|
