Fakebook-Database/testViews.sql at main · qingyaoz/Fakebook-Database · GitHub

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
-- "no rows selected" expected for all commands

-- Test View_User_Information
SELECT * FROM project1.Public_User_Information
MINUS SELECT * FROM View_User_Information;

SELECT * FROM View_User_Information
MINUS SELECT * FROM project1.Public_User_Information;


-- Test View_Are_Friends
SELECT LEAST(user1_id, user2_id),  GREATEST(user1_id, user2_id)
FROM project1.Public_Are_Friends
MINUS SELECT LEAST(user1_id, user2_id),  GREATEST(user1_id, user2_id)
FROM View_Are_Friends;

SELECT LEAST(user1_id, user2_id),  GREATEST(user1_id, user2_id)
FROM View_Are_Friends
MINUS SELECT LEAST(user1_id, user2_id),  GREATEST(user1_id, user2_id)
FROM project1.Public_Are_Friends;


-- Test View_Photo_Information
SELECT * FROM project1.Public_Photo_Information
MINUS SELECT * FROM View_Photo_Information;

SELECT * FROM View_Photo_Information
MINUS SELECT * FROM project1.Public_Photo_Information;


-- Test View_Event_Information
SELECT * FROM project1.Public_Event_Information
MINUS SELECT * FROM View_Event_Information;

SELECT * FROM View_Event_Information
MINUS SELECT * FROM project1.Public_Event_Information;

-- Test View_Tag_Information
SELECT * FROM project1.Public_Tag_Information
MINUS SELECT * FROM View_Tag_Information;

SELECT * FROM View_Tag_Information
MINUS SELECT * FROM project1.Public_Tag_Information;