Match Isolation Test

Test 1: Schema Existence

✅ Match schema `m_14` exists

Test 2: Views in Match Schema

Views/tables in m_14:

cal_rank (VIEW)
cal_rank_old (VIEW)
chat (VIEW)
chat2 (VIEW)
col (VIEW)
event (VIEW)
eventp (VIEW)
event_attack (VIEW)
fed (VIEW)
fed_apply (VIEW)
fed_forum (VIEW)
fed_planetcount (VIEW)
good (VIEW)
planet_type (VIEW)
project (VIEW)
project_user (VIEW)
race (VIEW)
restree (VIEW)
res_tree_type (VIEW)
server_settings (VIEW)
ship_class (VIEW)
ship_type (VIEW)
ship_user (VIEW)
tournament_war (VIEW)
trade_good_user (VIEW)
user (VIEW)
user_good (VIEW)
user_guide (VIEW)
user_pm (VIEW)
user_win (VIEW)

Test 3: User Data Isolation

Tournament users (gcdm.user): 5
Global users by match:
- Match 0: 1 users
- Match 5: 2 users
- Match 8: 2 users
- Match 9: 2 users
- Match 10: 2 users
- Match 11: 2 users
- Match 12: 2 users
- Match 13: 2 users
- Match 14: 9 users
- Match 15: 2 users
- Match 16: 2 users
- Match 17: 7 users
- Match 19: 2 users
- Match 20: 7 users
- Match 21: 7 users
- Match 22: 2 users
- Match 73: 2 users
- Match 74: 2 users
- Match 75: 7 users
- Match 76: 2 users
- Match 77: 2 users
- Match 78: 7 users
- Match 79: 2 users
- Match 80: 2 users
- Match 81: 7 users
- Match 82: 7 users
- Match 83: 2 users
- Match 84: 2 users
- Match 85: 2 users
- Match 86: 2 users
- Match 87: 2 users
- Match 88: 7 users
- Match 89: 3 users
- Match 90: 9 users
- Match 91: 2 users
- Match 92: 2 users
- Match 93: 2 users
- Match 94: 4 users
- Match 95: 2 users
- Match 96: 2 users
- Match 97: 7 users
- Match 98: 7 users
- Match 99: 7 users
- Match 100: 7 users
- Match 101: 7 users
- Match 102: 2 users
- Match 103: 7 users
- Match 104: 2 users
- Match 105: 2 users
- Match 106: 7 users
- Match 107: 7 users
- Match 108: 7 users
- Match 109: 7 users
- Match 110: 7 users
- Match 111: 7 users
- Match 112: 7 users
- Match 113: 7 users
- Match 114: 7 users
- Match 115: 7 users
- Match 116: 7 users
- Match 117: 7 users
- Match 118: 7 users
- Match 119: 7 users
- Match 120: 7 users
- Match 121: 7 users
- Match 122: 7 users
- Match 123: 7 users
- Match 124: 7 users
- Match 125: 7 users
- Match 126: 7 users
- Match 127: 7 users
- Match 128: 7 users
- Match 129: 7 users
- Match 130: 7 users
- Match 131: 7 users
- Match 132: 7 users
- Match 133: 7 users
- Match 134: 7 users
- Match 135: 7 users
- Match 136: 7 users
- Match 137: 7 users
- Match 138: 7 users
- Match 139: 7 users
- Match 140: 7 users
- Match 141: 7 users
- Match 142: 7 users
- Match 143: 7 users
- Match 144: 7 users
- Match 145: 7 users
- Match 146: 7 users
- Match 2722: 2 users
Match 14 visible users: 9
Match users:
- User 1: EvilRen (Fed: 1, Race: 5)
- User 100: Renegade (Fed: 2, Race: 3)
- User 1051: Renegade (Fed: 17, Race: 5)
- User 1052: EvilRen2 (Fed: 18, Race: 6)
- User 1551: [NPC]Hiedi (Fed: , Race: 1)
- User 1552: [NPC]Blasius (Fed: , Race: 6)
- User 1553: [NPC]Bernie (Fed: , Race: 4)
- User 1554: [NPC]Iris (Fed: , Race: 2)
- User 1555: [NPC]Char (Fed: , Race: 1)

Test 4: Colony Data Isolation

Tournament colonies (gcdm.col): 5
Global colonies by match:
- Match 13: 4 colonies
- Match 14: 7 colonies
- Match 17: 6 colonies
- Match 19: 2 colonies
- Match 20: 7 colonies
- Match 21: 5 colonies
- Match 22: 2 colonies
- Match 73: 2 colonies
- Match 74: 2 colonies
- Match 75: 7 colonies
- Match 76: 2 colonies
- Match 77: 2 colonies
- Match 78: 7 colonies
- Match 79: 2 colonies
- Match 80: 2 colonies
- Match 81: 7 colonies
- Match 82: 7 colonies
- Match 83: 2 colonies
- Match 84: 2 colonies
- Match 85: 2 colonies
- Match 86: 2 colonies
- Match 87: 6 colonies
- Match 88: 7 colonies
- Match 89: 3 colonies
- Match 90: 19 colonies
- Match 91: 2 colonies
- Match 92: 2 colonies
- Match 93: 8 colonies
- Match 94: 7 colonies
- Match 95: 2 colonies
- Match 96: 2 colonies
- Match 97: 7 colonies
- Match 98: 7 colonies
- Match 99: 7 colonies
- Match 100: 7 colonies
- Match 101: 7 colonies
- Match 102: 2 colonies
- Match 103: 9 colonies
- Match 104: 2 colonies
- Match 105: 2 colonies
- Match 106: 7 colonies
- Match 107: 19 colonies
- Match 108: 7 colonies
- Match 109: 7 colonies
- Match 110: 7 colonies
- Match 111: 7 colonies
- Match 112: 17 colonies
- Match 113: 7 colonies
- Match 114: 14 colonies
- Match 115: 7 colonies
- Match 116: 7 colonies
- Match 117: 7 colonies
- Match 118: 7 colonies
- Match 119: 13 colonies
- Match 120: 7 colonies
- Match 121: 7 colonies
- Match 122: 7 colonies
- Match 123: 7 colonies
- Match 124: 7 colonies
- Match 125: 12 colonies
- Match 126: 7 colonies
- Match 127: 7 colonies
- Match 128: 7 colonies
- Match 129: 7 colonies
- Match 130: 7 colonies
- Match 131: 7 colonies
- Match 132: 15 colonies
- Match 133: 7 colonies
- Match 134: 7 colonies
- Match 135: 7 colonies
- Match 136: 7 colonies
- Match 137: 11 colonies
- Match 138: 12 colonies
- Match 139: 7 colonies
- Match 140: 8 colonies
- Match 141: 15 colonies
- Match 142: 7 colonies
- Match 143: 15 colonies
- Match 144: 14 colonies
- Match 145: 15 colonies
- Match 146: 7 colonies
Match 14 visible colonies: 7
Colony breakdown:
- User 1051: 1 colonies, 100 total population
- User 1052: 1 colonies, 200 total population
- User 1551: 1 colonies, 200 total population
- User 1552: 1 colonies, 200 total population
- User 1553: 1 colonies, 200 total population
- User 1554: 1 colonies, 200 total population
- User 1555: 1 colonies, 200 total population

Test 5: Write Isolation Test

Testing if writes to match schema properly isolate data...

⚠️ Write test failed (this may be expected): Duplicate entry '999' for key 'PRIMARY'

Test 6: Application Context

Application.ds: gcdm
Request match ID: 0
Session match ID: 0
Database layer: main

🎯 Test Results Summary

If the match schema exists and users/colonies are properly filtered, the data leakage should be resolved. Users in match 14 should only see their match-specific data.