-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathtestexp_mysql_then_pg
152 lines (134 loc) · 9.28 KB
/
testexp_mysql_then_pg
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
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
?column?
---------------
RUNNING TESTS
(1 row)
INSERT 0 1
?column?
--------------------------------------------------------------------------------------------------------------------------------------------------------------
OUR FIRST OP CAUSED THE PGRTI FIELD TO BE CREATED if we dont wait a few seconds all the operations will be queued before we are done creating the structures
(1 row)
pg_sleep
----------
(1 row)
?column?
-----------------------------------------------------
check that the before insert trigger runs only once
(1 row)
INSERT 0 1
emp_id | emp_name | emp_dept_id | trigg_count
--------+------------------------------------------------------------+-------------+-------------
1 | emp - 1 | 1 |
2 | MYSQL_first_op | 1 |
3 | emp - 3 | 1 |
4 | emp - 4 | 2 |
5 | emp - 5 TRIGGER UPDATED! TRIGGER UPDATED! TRIGGER UPDATED! | 1 | 3
6 | MYSQL2 TRIGGER UPDATED! | 2 | 1
7 | MYSQLINSERT-- insert trigger mod! | 2 | 1
8 | firsop_pg insert trigger mod! | 2 | 1
9 | runoncealice insert trigger mod! | 2 | 1
(9 rows)
?column?
-----------------------------
check before update trigger
(1 row)
UPDATE 1
emp_id | emp_name | emp_dept_id | trigg_count
--------+------------------------------------------------------------+-------------+-------------
1 | emp - 1 | 1 |
2 | MYSQL_first_op | 1 |
3 | pgupdate-- TRIGGER UPDATED! | 1 | 1
4 | emp - 4 | 2 |
5 | emp - 5 TRIGGER UPDATED! TRIGGER UPDATED! TRIGGER UPDATED! | 1 | 3
6 | MYSQL2 TRIGGER UPDATED! | 2 | 1
7 | MYSQLINSERT-- insert trigger mod! | 2 | 1
8 | firsop_pg insert trigger mod! | 2 | 1
9 | runoncealice insert trigger mod! | 2 | 1
(9 rows)
?column?
-----------------------------------------------------
check before insert trigger: we cannot insert id 42
(1 row)
INSERT 0 0
emp_id | emp_name | emp_dept_id | trigg_count
--------+------------------------------------------------------------+-------------+-------------
1 | emp - 1 | 1 |
2 | MYSQL_first_op | 1 |
3 | pgupdate-- TRIGGER UPDATED! | 1 | 1
4 | emp - 4 | 2 |
5 | emp - 5 TRIGGER UPDATED! TRIGGER UPDATED! TRIGGER UPDATED! | 1 | 3
6 | MYSQL2 TRIGGER UPDATED! | 2 | 1
7 | MYSQLINSERT-- insert trigger mod! | 2 | 1
8 | firsop_pg insert trigger mod! | 2 | 1
9 | runoncealice insert trigger mod! | 2 | 1
(9 rows)
?column?
--------------------------------------------------
check before insert trigger: we can insert id 43
(1 row)
INSERT 0 1
emp_id | emp_name | emp_dept_id | trigg_count
--------+------------------------------------------------------------+-------------+-------------
1 | emp - 1 | 1 |
2 | MYSQL_first_op | 1 |
3 | pgupdate-- TRIGGER UPDATED! | 1 | 1
4 | emp - 4 | 2 |
5 | emp - 5 TRIGGER UPDATED! TRIGGER UPDATED! TRIGGER UPDATED! | 1 | 3
6 | MYSQL2 TRIGGER UPDATED! | 2 | 1
7 | MYSQLINSERT-- insert trigger mod! | 2 | 1
8 | firsop_pg insert trigger mod! | 2 | 1
9 | runoncealice insert trigger mod! | 2 | 1
43 | alice insert trigger mod! | 2 | 1
(10 rows)
?column?
----------------------------------------------------
check before update trigger: we cannot update id 4
(1 row)
UPDATE 0
emp_id | emp_name | emp_dept_id | trigg_count
--------+------------------------------------------------------------+-------------+-------------
1 | emp - 1 | 1 |
2 | MYSQL_first_op | 1 |
3 | pgupdate-- TRIGGER UPDATED! | 1 | 1
4 | emp - 4 | 2 |
5 | emp - 5 TRIGGER UPDATED! TRIGGER UPDATED! TRIGGER UPDATED! | 1 | 3
6 | MYSQL2 TRIGGER UPDATED! | 2 | 1
7 | MYSQLINSERT-- insert trigger mod! | 2 | 1
8 | firsop_pg insert trigger mod! | 2 | 1
9 | runoncealice insert trigger mod! | 2 | 1
43 | alice insert trigger mod! | 2 | 1
(10 rows)
?column?
----------------------------------------------------
check before delete trigger: we cannot delete id 4
(1 row)
DELETE 0
emp_id | emp_name | emp_dept_id | trigg_count
--------+------------------------------------------------------------+-------------+-------------
1 | emp - 1 | 1 |
2 | MYSQL_first_op | 1 |
3 | pgupdate-- TRIGGER UPDATED! | 1 | 1
4 | emp - 4 | 2 |
5 | emp - 5 TRIGGER UPDATED! TRIGGER UPDATED! TRIGGER UPDATED! | 1 | 3
6 | MYSQL2 TRIGGER UPDATED! | 2 | 1
7 | MYSQLINSERT-- insert trigger mod! | 2 | 1
8 | firsop_pg insert trigger mod! | 2 | 1
9 | runoncealice insert trigger mod! | 2 | 1
43 | alice insert trigger mod! | 2 | 1
(10 rows)
?column?
------------------
test delete id 1
(1 row)
DELETE 1
emp_id | emp_name | emp_dept_id | trigg_count
--------+------------------------------------------------------------+-------------+-------------
2 | MYSQL_first_op | 1 |
3 | pgupdate-- TRIGGER UPDATED! | 1 | 1
4 | emp - 4 | 2 |
5 | emp - 5 TRIGGER UPDATED! TRIGGER UPDATED! TRIGGER UPDATED! | 1 | 3
6 | MYSQL2 TRIGGER UPDATED! | 2 | 1
7 | MYSQLINSERT-- insert trigger mod! | 2 | 1
8 | firsop_pg insert trigger mod! | 2 | 1
9 | runoncealice insert trigger mod! | 2 | 1
43 | alice insert trigger mod! | 2 | 1
(9 rows)