========== QUERY : SELECT * FROM R, S, T WHERE R.a = S.a and S.a = T.a; java -ea -classpath .:./javacc.jar:./je-3.3.82.jar CommandLine Data command> Query: on tables [R, S, T] with predicates: [R.a = S.a, S.a = T.a] selecting: [] ========================================= Query Plan ======================================== Hash Join operator with predicate S.a = T.a Hash Join operator with predicate R.a = S.a Scan operator on R Scan operator on S Scan operator on T ============================================================================================= ------------------------------------------------------------------------- R.a S.a T.a ------------------------------------------------------------------------- 0 0 0 10000 10000 10000 ------------------------------------------------------------------------- command> -------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------- ========== QUERY : SELECT * FROM users, friends WHERE userid = 'user10' and userid = userid1; java -ea -classpath .:./javacc.jar:./je-3.3.82.jar CommandLine Data command> Query: on tables [users, friends] with predicates: [null.userid = Constant: 'user10', null.userid = null.userid1] selecting: [] ========================================= Query Plan ======================================== Hash Join operator with predicate users.userid = friends.userid1 Scan operator on users with predicates: users.userid = Constant: 'user10' Scan operator on friends ============================================================================================= ------------------------------------------------------------------------- users.userid users.name friends.friends_pk friends.userid1 friends.userid2 ------------------------------------------------------------------------- 'user10' 'Carol Evans' 13 'user10' 'user0' 'user10' 'Carol Evans' 51 'user10' 'user1' 'user10' 'Carol Evans' 99 'user10' 'user3' 'user10' 'Carol Evans' 195 'user10' 'user7' 'user10' 'Carol Evans' 270 'user10' 'user11' 'user10' 'Carol Evans' 272 'user10' 'user12' 'user10' 'Carol Evans' 274 'user10' 'user15' 'user10' 'Carol Evans' 276 'user10' 'user20' 'user10' 'Carol Evans' 278 'user10' 'user21' 'user10' 'Carol Evans' 280 'user10' 'user26' 'user10' 'Carol Evans' 282 'user10' 'user29' 'user10' 'Carol Evans' 284 'user10' 'user32' 'user10' 'Carol Evans' 286 'user10' 'user38' 'user10' 'Carol Evans' 288 'user10' 'user45' 'user10' 'Carol Evans' 290 'user10' 'user62' 'user10' 'Carol Evans' 292 'user10' 'user64' 'user10' 'Carol Evans' 294 'user10' 'user69' 'user10' 'Carol Evans' 296 'user10' 'user98' 'user10' 'Carol Evans' 298 'user10' 'user104' ------------------------------------------------------------------------- command> -------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------- ========== QUERY : SELECT * FROM users, friends WHERE userid = 'user' and userid = userid1; java -ea -classpath .:./javacc.jar:./je-3.3.82.jar CommandLine Data command> Query: on tables [users, friends] with predicates: [null.userid = Constant: 'user', null.userid = null.userid1] selecting: [] ========================================= Query Plan ======================================== Hash Join operator with predicate users.userid = friends.userid1 Scan operator on users with predicates: users.userid = Constant: 'user' Scan operator on friends ============================================================================================= ------------------------------------------------------------------------- users.userid users.name friends.friends_pk friends.userid1 friends.userid2 ------------------------------------------------------------------------- ------------------------------------------------------------------------- command> -------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------- ========== QUERY : SELECT * FROM users, friends WHERE userid = 'user' and userid = userid1 and userid1 = 'user'; java -ea -classpath .:./javacc.jar:./je-3.3.82.jar CommandLine Data command> Query: on tables [users, friends] with predicates: [null.userid = Constant: 'user', null.userid = null.userid1, null.userid1 = Constant: 'user'] selecting: [] ========================================= Query Plan ======================================== Hash Join operator with predicate users.userid = friends.userid1 Scan operator on users with predicates: users.userid = Constant: 'user' Scan operator on friends with predicates: friends.userid1 = Constant: 'user' ============================================================================================= ------------------------------------------------------------------------- users.userid users.name friends.friends_pk friends.userid1 friends.userid2 ------------------------------------------------------------------------- ------------------------------------------------------------------------- command> -------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------- ========== QUERY : SELECT * FROM members, friends WHERE members.userid = 'user5' and members.userid = friends.userid1; java -ea -classpath .:./javacc.jar:./je-3.3.82.jar CommandLine Data command> Query: on tables [members, friends] with predicates: [members.userid = Constant: 'user5', members.userid = friends.userid1] selecting: [] ========================================= Query Plan ======================================== Hash Join operator with predicate members.userid = friends.userid1 Scan operator on members with predicates: members.userid = Constant: 'user5' Scan operator on friends ============================================================================================= ------------------------------------------------------------------------- members.members_pk members.userid members.groupid friends.friends_pk friends.userid1 friends.userid2 ------------------------------------------------------------------------- 27 'user5' 'group1' 9 'user5' 'user0' 27 'user5' 'group1' 125 'user5' 'user4' 27 'user5' 'group1' 154 'user5' 'user6' 27 'user5' 'group1' 156 'user5' 'user7' 27 'user5' 'group1' 158 'user5' 'user9' 27 'user5' 'group1' 160 'user5' 'user26' 27 'user5' 'group1' 162 'user5' 'user27' 27 'user5' 'group1' 164 'user5' 'user35' 27 'user5' 'group1' 166 'user5' 'user59' 27 'user5' 'group1' 168 'user5' 'user61' 27 'user5' 'group1' 170 'user5' 'user72' 28 'user5' 'group2' 9 'user5' 'user0' 28 'user5' 'group2' 125 'user5' 'user4' 28 'user5' 'group2' 154 'user5' 'user6' 28 'user5' 'group2' 156 'user5' 'user7' 28 'user5' 'group2' 158 'user5' 'user9' 28 'user5' 'group2' 160 'user5' 'user26' 28 'user5' 'group2' 162 'user5' 'user27' 28 'user5' 'group2' 164 'user5' 'user35' 28 'user5' 'group2' 166 'user5' 'user59' 28 'user5' 'group2' 168 'user5' 'user61' 28 'user5' 'group2' 170 'user5' 'user72' 29 'user5' 'group30' 9 'user5' 'user0' 29 'user5' 'group30' 125 'user5' 'user4' 29 'user5' 'group30' 154 'user5' 'user6' 29 'user5' 'group30' 156 'user5' 'user7' 29 'user5' 'group30' 158 'user5' 'user9' 29 'user5' 'group30' 160 'user5' 'user26' 29 'user5' 'group30' 162 'user5' 'user27' 29 'user5' 'group30' 164 'user5' 'user35' 29 'user5' 'group30' 166 'user5' 'user59' 29 'user5' 'group30' 168 'user5' 'user61' 29 'user5' 'group30' 170 'user5' 'user72' 30 'user5' 'group32' 9 'user5' 'user0' 30 'user5' 'group32' 125 'user5' 'user4' 30 'user5' 'group32' 154 'user5' 'user6' 30 'user5' 'group32' 156 'user5' 'user7' 30 'user5' 'group32' 158 'user5' 'user9' 30 'user5' 'group32' 160 'user5' 'user26' 30 'user5' 'group32' 162 'user5' 'user27' 30 'user5' 'group32' 164 'user5' 'user35' 30 'user5' 'group32' 166 'user5' 'user59' 30 'user5' 'group32' 168 'user5' 'user61' 30 'user5' 'group32' 170 'user5' 'user72' ------------------------------------------------------------------------- command> -------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------- ========== QUERY : SELECT * FROM members, friends, status WHERE members.userid = 'user1' and members.userid = friends.userid1 and status.userid = members.userid; java -ea -classpath .:./javacc.jar:./je-3.3.82.jar CommandLine Data command> Query: on tables [members, friends, status] with predicates: [members.userid = Constant: 'user1', members.userid = friends.userid1, status.userid = members.userid] selecting: [] ========================================= Query Plan ======================================== Hash Join operator with predicate members.userid = status.userid Hash Join operator with predicate members.userid = friends.userid1 Scan operator on members with predicates: members.userid = Constant: 'user1' Scan operator on friends Scan operator on status ============================================================================================= ------------------------------------------------------------------------- members.members_pk members.userid members.groupid friends.friends_pk friends.userid1 friends.userid2 status.status_pk status.userid status.status_number status.text ------------------------------------------------------------------------- ------------------------------------------------------------------------- command> -------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------- ========== QUERY : SELECT * FROM members, friends, status WHERE members.userid = 'user2' and members.userid = friends.userid1 and status.userid = members.userid; java -ea -classpath .:./javacc.jar:./je-3.3.82.jar CommandLine Data command> Query: on tables [members, friends, status] with predicates: [members.userid = Constant: 'user2', members.userid = friends.userid1, status.userid = members.userid] selecting: [] ========================================= Query Plan ======================================== Hash Join operator with predicate members.userid = status.userid Hash Join operator with predicate members.userid = friends.userid1 Scan operator on members with predicates: members.userid = Constant: 'user2' Scan operator on friends Scan operator on status ============================================================================================= ------------------------------------------------------------------------- members.members_pk members.userid members.groupid friends.friends_pk friends.userid1 friends.userid2 status.status_pk status.userid status.status_number status.text ------------------------------------------------------------------------- 7 'user2' 'group0' 3 'user2' 'user0' 1 'user2' 0 'This is status update number 0 by user2' 7 'user2' 'group0' 41 'user2' 'user1' 1 'user2' 0 'This is status update number 0 by user2' 7 'user2' 'group0' 70 'user2' 'user6' 1 'user2' 0 'This is status update number 0 by user2' 7 'user2' 'group0' 72 'user2' 'user8' 1 'user2' 0 'This is status update number 0 by user2' 7 'user2' 'group0' 74 'user2' 'user20' 1 'user2' 0 'This is status update number 0 by user2' 7 'user2' 'group0' 76 'user2' 'user23' 1 'user2' 0 'This is status update number 0 by user2' 7 'user2' 'group0' 78 'user2' 'user24' 1 'user2' 0 'This is status update number 0 by user2' 7 'user2' 'group0' 80 'user2' 'user31' 1 'user2' 0 'This is status update number 0 by user2' 7 'user2' 'group0' 82 'user2' 'user43' 1 'user2' 0 'This is status update number 0 by user2' 7 'user2' 'group0' 84 'user2' 'user68' 1 'user2' 0 'This is status update number 0 by user2' 7 'user2' 'group0' 86 'user2' 'user81' 1 'user2' 0 'This is status update number 0 by user2' 7 'user2' 'group0' 88 'user2' 'user105' 1 'user2' 0 'This is status update number 0 by user2' 8 'user2' 'group2' 3 'user2' 'user0' 1 'user2' 0 'This is status update number 0 by user2' 8 'user2' 'group2' 41 'user2' 'user1' 1 'user2' 0 'This is status update number 0 by user2' 8 'user2' 'group2' 70 'user2' 'user6' 1 'user2' 0 'This is status update number 0 by user2' 8 'user2' 'group2' 72 'user2' 'user8' 1 'user2' 0 'This is status update number 0 by user2' 8 'user2' 'group2' 74 'user2' 'user20' 1 'user2' 0 'This is status update number 0 by user2' 8 'user2' 'group2' 76 'user2' 'user23' 1 'user2' 0 'This is status update number 0 by user2' 8 'user2' 'group2' 78 'user2' 'user24' 1 'user2' 0 'This is status update number 0 by user2' 8 'user2' 'group2' 80 'user2' 'user31' 1 'user2' 0 'This is status update number 0 by user2' 8 'user2' 'group2' 82 'user2' 'user43' 1 'user2' 0 'This is status update number 0 by user2' 8 'user2' 'group2' 84 'user2' 'user68' 1 'user2' 0 'This is status update number 0 by user2' 8 'user2' 'group2' 86 'user2' 'user81' 1 'user2' 0 'This is status update number 0 by user2' 8 'user2' 'group2' 88 'user2' 'user105' 1 'user2' 0 'This is status update number 0 by user2' 9 'user2' 'group12' 3 'user2' 'user0' 1 'user2' 0 'This is status update number 0 by user2' 9 'user2' 'group12' 41 'user2' 'user1' 1 'user2' 0 'This is status update number 0 by user2' 9 'user2' 'group12' 70 'user2' 'user6' 1 'user2' 0 'This is status update number 0 by user2' 9 'user2' 'group12' 72 'user2' 'user8' 1 'user2' 0 'This is status update number 0 by user2' 9 'user2' 'group12' 74 'user2' 'user20' 1 'user2' 0 'This is status update number 0 by user2' 9 'user2' 'group12' 76 'user2' 'user23' 1 'user2' 0 'This is status update number 0 by user2' 9 'user2' 'group12' 78 'user2' 'user24' 1 'user2' 0 'This is status update number 0 by user2' 9 'user2' 'group12' 80 'user2' 'user31' 1 'user2' 0 'This is status update number 0 by user2' 9 'user2' 'group12' 82 'user2' 'user43' 1 'user2' 0 'This is status update number 0 by user2' 9 'user2' 'group12' 84 'user2' 'user68' 1 'user2' 0 'This is status update number 0 by user2' 9 'user2' 'group12' 86 'user2' 'user81' 1 'user2' 0 'This is status update number 0 by user2' 9 'user2' 'group12' 88 'user2' 'user105' 1 'user2' 0 'This is status update number 0 by user2' 10 'user2' 'group17' 3 'user2' 'user0' 1 'user2' 0 'This is status update number 0 by user2' 10 'user2' 'group17' 41 'user2' 'user1' 1 'user2' 0 'This is status update number 0 by user2' 10 'user2' 'group17' 70 'user2' 'user6' 1 'user2' 0 'This is status update number 0 by user2' 10 'user2' 'group17' 72 'user2' 'user8' 1 'user2' 0 'This is status update number 0 by user2' 10 'user2' 'group17' 74 'user2' 'user20' 1 'user2' 0 'This is status update number 0 by user2' 10 'user2' 'group17' 76 'user2' 'user23' 1 'user2' 0 'This is status update number 0 by user2' 10 'user2' 'group17' 78 'user2' 'user24' 1 'user2' 0 'This is status update number 0 by user2' 10 'user2' 'group17' 80 'user2' 'user31' 1 'user2' 0 'This is status update number 0 by user2' 10 'user2' 'group17' 82 'user2' 'user43' 1 'user2' 0 'This is status update number 0 by user2' 10 'user2' 'group17' 84 'user2' 'user68' 1 'user2' 0 'This is status update number 0 by user2' 10 'user2' 'group17' 86 'user2' 'user81' 1 'user2' 0 'This is status update number 0 by user2' 10 'user2' 'group17' 88 'user2' 'user105' 1 'user2' 0 'This is status update number 0 by user2' 11 'user2' 'group20' 3 'user2' 'user0' 1 'user2' 0 'This is status update number 0 by user2' 11 'user2' 'group20' 41 'user2' 'user1' 1 'user2' 0 'This is status update number 0 by user2' 11 'user2' 'group20' 70 'user2' 'user6' 1 'user2' 0 'This is status update number 0 by user2' 11 'user2' 'group20' 72 'user2' 'user8' 1 'user2' 0 'This is status update number 0 by user2' 11 'user2' 'group20' 74 'user2' 'user20' 1 'user2' 0 'This is status update number 0 by user2' 11 'user2' 'group20' 76 'user2' 'user23' 1 'user2' 0 'This is status update number 0 by user2' 11 'user2' 'group20' 78 'user2' 'user24' 1 'user2' 0 'This is status update number 0 by user2' 11 'user2' 'group20' 80 'user2' 'user31' 1 'user2' 0 'This is status update number 0 by user2' 11 'user2' 'group20' 82 'user2' 'user43' 1 'user2' 0 'This is status update number 0 by user2' 11 'user2' 'group20' 84 'user2' 'user68' 1 'user2' 0 'This is status update number 0 by user2' 11 'user2' 'group20' 86 'user2' 'user81' 1 'user2' 0 'This is status update number 0 by user2' 11 'user2' 'group20' 88 'user2' 'user105' 1 'user2' 0 'This is status update number 0 by user2' 12 'user2' 'group23' 3 'user2' 'user0' 1 'user2' 0 'This is status update number 0 by user2' 12 'user2' 'group23' 41 'user2' 'user1' 1 'user2' 0 'This is status update number 0 by user2' 12 'user2' 'group23' 70 'user2' 'user6' 1 'user2' 0 'This is status update number 0 by user2' 12 'user2' 'group23' 72 'user2' 'user8' 1 'user2' 0 'This is status update number 0 by user2' 12 'user2' 'group23' 74 'user2' 'user20' 1 'user2' 0 'This is status update number 0 by user2' 12 'user2' 'group23' 76 'user2' 'user23' 1 'user2' 0 'This is status update number 0 by user2' 12 'user2' 'group23' 78 'user2' 'user24' 1 'user2' 0 'This is status update number 0 by user2' 12 'user2' 'group23' 80 'user2' 'user31' 1 'user2' 0 'This is status update number 0 by user2' 12 'user2' 'group23' 82 'user2' 'user43' 1 'user2' 0 'This is status update number 0 by user2' 12 'user2' 'group23' 84 'user2' 'user68' 1 'user2' 0 'This is status update number 0 by user2' 12 'user2' 'group23' 86 'user2' 'user81' 1 'user2' 0 'This is status update number 0 by user2' 12 'user2' 'group23' 88 'user2' 'user105' 1 'user2' 0 'This is status update number 0 by user2' 13 'user2' 'group31' 3 'user2' 'user0' 1 'user2' 0 'This is status update number 0 by user2' 13 'user2' 'group31' 41 'user2' 'user1' 1 'user2' 0 'This is status update number 0 by user2' 13 'user2' 'group31' 70 'user2' 'user6' 1 'user2' 0 'This is status update number 0 by user2' 13 'user2' 'group31' 72 'user2' 'user8' 1 'user2' 0 'This is status update number 0 by user2' 13 'user2' 'group31' 74 'user2' 'user20' 1 'user2' 0 'This is status update number 0 by user2' 13 'user2' 'group31' 76 'user2' 'user23' 1 'user2' 0 'This is status update number 0 by user2' 13 'user2' 'group31' 78 'user2' 'user24' 1 'user2' 0 'This is status update number 0 by user2' 13 'user2' 'group31' 80 'user2' 'user31' 1 'user2' 0 'This is status update number 0 by user2' 13 'user2' 'group31' 82 'user2' 'user43' 1 'user2' 0 'This is status update number 0 by user2' 13 'user2' 'group31' 84 'user2' 'user68' 1 'user2' 0 'This is status update number 0 by user2' 13 'user2' 'group31' 86 'user2' 'user81' 1 'user2' 0 'This is status update number 0 by user2' 13 'user2' 'group31' 88 'user2' 'user105' 1 'user2' 0 'This is status update number 0 by user2' 14 'user2' 'group32' 3 'user2' 'user0' 1 'user2' 0 'This is status update number 0 by user2' 14 'user2' 'group32' 41 'user2' 'user1' 1 'user2' 0 'This is status update number 0 by user2' 14 'user2' 'group32' 70 'user2' 'user6' 1 'user2' 0 'This is status update number 0 by user2' 14 'user2' 'group32' 72 'user2' 'user8' 1 'user2' 0 'This is status update number 0 by user2' 14 'user2' 'group32' 74 'user2' 'user20' 1 'user2' 0 'This is status update number 0 by user2' 14 'user2' 'group32' 76 'user2' 'user23' 1 'user2' 0 'This is status update number 0 by user2' 14 'user2' 'group32' 78 'user2' 'user24' 1 'user2' 0 'This is status update number 0 by user2' 14 'user2' 'group32' 80 'user2' 'user31' 1 'user2' 0 'This is status update number 0 by user2' 14 'user2' 'group32' 82 'user2' 'user43' 1 'user2' 0 'This is status update number 0 by user2' 14 'user2' 'group32' 84 'user2' 'user68' 1 'user2' 0 'This is status update number 0 by user2' 14 'user2' 'group32' 86 'user2' 'user81' 1 'user2' 0 'This is status update number 0 by user2' 14 'user2' 'group32' 88 'user2' 'user105' 1 'user2' 0 'This is status update number 0 by user2' ------------------------------------------------------------------------- command> -------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------