|
1
|
SELECT c.change_id, change_key,
|
|
2
|
owner_account_id "owner",
|
|
3
|
DATE(c.created_on) date,
|
|
4
|
dest_project_name project,
|
|
5
|
array_agg(p.revision)
|
|
6
|
FROM changes c JOIN patch_sets p ON c.change_id = p.change_id
|
|
7
|
WHERE c.change_id IN (
|
|
8
|
301
|
|
9
|
, 304
|
|
10
|
, 405
|
|
11
|
, 406
|
|
12
|
, 408
|
|
13
|
, 409
|
|
14
|
, 412
|
|
15
|
, 318
|
|
16
|
, 221
|
|
17
|
, 324
|
|
18
|
, 230
|
|
19
|
, 236
|
|
20
|
, 338
|
|
21
|
, 343
|
|
22
|
, 344
|
|
23
|
, 345
|
|
24
|
, 347
|
|
25
|
, 348
|
|
26
|
, 349
|
|
27
|
, 351
|
|
28
|
, 353
|
|
29
|
, 356
|
|
30
|
, 357
|
|
31
|
, 358
|
|
32
|
, 359
|
|
33
|
, 260
|
|
34
|
, 360
|
|
35
|
, 361
|
|
36
|
, 362
|
|
37
|
, 363
|
|
38
|
, 267
|
|
39
|
, 279
|
|
40
|
, 280
|
|
41
|
, 284
|
|
42
|
, 386
|
|
43
|
, 387
|
|
44
|
, 389
|
|
45
|
, 291
|
|
46
|
, 292
|
|
47
|
, 299
|
|
48
|
, 27997
|
|
49
|
, 27198
|
|
50
|
, 750
|
|
51
|
, 327
|
|
52
|
, 751
|
|
53
|
)
|
|
54
|
GROUP BY c.change_id
|
|
55
|
ORDER BY c.change_id
|
|
56
|
;
|
|
57
|
change_id | change_key | owner | date | project | array_agg
|
|
58
|
-----------+-------------------------------------------+---------+------------+--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|
|
59
|
221 | I9dfdb07cbd62180533bfef29dc2a907a919eedb4 | 1000013 | 2012-06-19 | core | {80934cb53de92fa68f7c5b4c82d4e10832c9ca05,45a4e5478b791445ab8b55ffe8a653f6b135218d}
|
|
60
|
230 | I4fce5215272fc90f39c9e05d3f3604734a8aebe3 | 1000025 | 2012-06-21 | core | {2ec82f3f70012fc450302d7f926b102042019266,56548a66eb2f692ef9deeda77ba58d4b93e15d1e}
|
|
61
|
236 | I334e3403f91ff6884ef1e3a6a64149c284926726 | 1000071 | 2012-06-25 | core | {e09d82e4831e4b5902a8164b41ead08bf79f6052,80fe1d5dbc66d5ce7e52a53160a327651d3d6674}
|
|
62
|
260 | Ie769c9a65e85f91395b3495fadb6f5e688cbe9af | 1000011 | 2012-07-05 | core | {385b9bf38a8e545837614e9206669a3f5f4a8431,ada37444914014847b9fe079c2bfd206953a037d}
|
|
63
|
267 | I3ac2e8e3219c12be84ce38cb98342f0dce0d6476 | 1000011 | 2012-07-08 | core | {1b64dcc64a371d571480b9001b185c77516892e0,d831e0d7dec9bc68947340401483a44abaa2eb62,3f5c542e1ff054bda7c49e2a153097e8f6ec88e0,829ee1c8ea3915794895ce578f0b9ea39ab99ba4}
|
|
64
|
279 | I8435bd94a44744c5af7a3abdbeb99e8f7cf0af24 | 1000025 | 2012-07-09 | core | {107a17441ec95e0173f0eec7e3e8b22c411b9155,5ab6d6d6cfd8eeb03c3816698488fc23f5a04c0e}
|
|
65
|
280 | Ifd2e2f1108f44d5816783bf67f11e500eea0c170 | 1000034 | 2012-07-09 | core | {f6a6abcfa1c37b189ac7365e074065b50fe06266,09ad6ff9195efd24fc2c96f258a01d7625ccc151}
|
|
66
|
284 | Ib61a679221d0eddea61358024d31c90464dccefb | 1000002 | 2012-07-10 | core | {a7b18843abdba54826c7102da274e43339e8350c,3f5c03fca70a262ac0943a8ef7e1d25efa4ec5e7}
|
|
67
|
291 | Id9eef27636c5c74857ed05b891514bee70903c3b | 1000091 | 2012-07-11 | core | {f9c4c16ef00b9c30955d4a25da3a32df77395a22,fdcc4fc75d05a6b2defa54690894f9e701029c3f,ad5765925a87ecc293c2752847ce3535b7fa1e9d,0cfd1bc5769846f4abfcbebf3b7f089b70c870eb}
|
|
68
|
292 | I40922cd1357ff473c251681f7280ba53b3060feb | 1000011 | 2012-07-11 | core | {4c0d99be51aaf3a02398307586bac813926b8368,4dc96f2e94ac0df79f42103963039304fae85609}
|
|
69
|
299 | Ic12ff70e95953de44ef5798131150669d07a5445 | 1000091 | 2012-07-12 | core | {cf3f3d0c64add4874424d507c128cba42b6a414b,df0197e68c4e60adc02da97dea7f7cb7853d7a91}
|
|
70
|
301 | I1988da8c07729eb99d3f53f71b8f950df29a7361 | 1000091 | 2012-07-12 | core | {a6a569ad4b2fec67765b19680413c404ccbba39c,4f1917cf87c23027333f81224c408018940070f7}
|
|
71
|
304 | I7e6f495eb56c0d6004c2e427b7fe9c3c09c7206f | 1000084 | 2012-07-13 | core | {0fb6b6228865913c6f581c88436ba406aa7deb24,304ea934857f77d8a4f032c89656a4c5ee7715bf}
|
|
72
|
318 | I89d89cedb5e27e2a05b1ecc13569e4899d1743d2 | 1000034 | 2012-07-16 | core | {b4b9089febc190fc2d6b57c9b7277ccc41cd958f,e681c79e85b3b5925a192fc03834dd35a94dbc49}
|
|
73
|
324 | I7a9a2c1f9c42405ceb28b1c90c25fd4151fba6fb | 1000025 | 2012-07-16 | core | {ecc5d6ad7090575d1de314f783f340d8db270abf,6b2232cf442150d7ef78a9e0efeaf3c00f9a578f}
|
|
74
|
327 | I2b0c1f0a82afba6ccc2400d21ccc10b50f5be16d | 1000020 | 2012-07-17 | dev-tools | {876b8c3445d8f906ef80ac025b6f81edc6d8f7eb,4db367a03d001fec0795a442618dd834c903dee7,2c10647602f938ec212338d10acd42b08316f0a3}
|
|
75
|
338 | I73cd4c901aa003abec43f55948c184672d2e14ff | 1000105 | 2012-07-22 | core | {d3fc6cee10906a87f88530292733f22f075ce412,0132b7ba6c8b304c8e8b5b072c3494d035064744}
|
|
76
|
343 | Ibea6bbfe747af160728b838c6ee236fd8f89671d | 1000002 | 2012-07-25 | core | {9b3439da8455704f0226dcdaee5f77eee15484c9,2c4b9f435040292160c4c2e31878e1bf6a56b550,ad8fa45f77f6e19f2517cb3b904f0a4b1435c5bb}
|
|
77
|
344 | I1cd77dd7b47eec6bf8709b225ecf0d070f9bb869 | 1000044 | 2012-07-25 | core | {af60b575449e70d6548130e4c2a81fd8e1064a69,62b7c0317aabe071dd0d5047207d55e6cbcc9f94}
|
|
78
|
345 | Ic87c9c4f51af4da963835ac7311d998e69f61156 | 1000101 | 2012-07-25 | core | {a6b3cf0c3a8db345790f14bce2438718a3d79de1,7f51a434994e2931b499c767d2700664663da8f9}
|
|
79
|
347 | I77cd68b96452896d4eec9f4bbd5200bd65d77f2a | 1000011 | 2012-07-27 | core | {2bce7038dfd16d892862cc5a1f20f58cdecc43cd,0fb0c0219c6326bb731d607919fd1a7ab7b6a6fa}
|
|
80
|
348 | I2d9ef3b346d4b10b99b67d0934d63d59f6119f97 | 1000013 | 2012-07-27 | core | {5b521e2cc22a35d92b93f96a28e39d68413e61dc,926006e13c82923c4e18aa7b5707aaebb9243e50}
|
|
81
|
349 | I2d9ef3b346d4b10b99b67d0934d63d59f6119f97 | 1000013 | 2012-07-27 | core | {904b873fb457cc41e7007750bf9a55e79df2d1c5,f5e3cc98399208e42fd270768054ca2ed6498d7f}
|
|
82
|
351 | I5a25e1f55bdc2b475df2af04b711fd808d95cdaf | 1000002 | 2012-07-31 | core | {7eda325adaeedc72145ccd282d589e1cb98d2a07,156db697330762e0fa10dca61efa8124451fd35a,2f5dd6f2e5d7ec28bb9a8065cb73859904df2c65}
|
|
83
|
353 | I9366de24414fa10e292e42df08a9658d90e5c1c1 | 1000103 | 2012-08-01 | core | {c23eb13306d07b1739fa019284e68910b511f935,c1b4dd5132e85f851c3a8c12353dfae66671d565,58a006894657a20d79d7e43c454f7f3a76ace171,dbeaa343fd492205aeb588f0e788b3ea97c8a0ed}
|
|
84
|
356 | I555e029092b453b2276a57fb4d384b18696d6e48 | 1000105 | 2012-08-01 | core | {257e722a3f2190285fed9ba323d81f861dc0dbd2,57516eecf867ab14e97c5c874e35e28c6c2190f6,e44f93b9fd6f54a55fcb372eb2a59c4d4a9ba922,5296084f39a7f5c940069ae854cb8f47cf0bf9d4}
|
|
85
|
357 | I8fe2b28f44ee61fc0f1438de3681fd86b16d29ae | 1000013 | 2012-08-02 | core | {4cba3763a78bb8fcadd817c26cdb44abd0da358b,4c869c8a580de02c9009866ff51c04bbaf34e2e4}
|
|
86
|
358 | I36d574c5f7915d732c6c158fadb91b6032370a01 | 1000013 | 2012-08-02 | core | {f40697f95fd1a39f1c2fa5123b96dd546027746b,67c8ef54577b6fc79e497bfbb824034cc624eada}
|
|
87
|
359 | I8fe2b28f44ee61fc0f1438de3681fd86b16d29ae | 1000013 | 2012-08-02 | core | {298c5ee77f11ef0c6042205d360eea87b28f5625,ca1764185f5645da6ebb3fb014135382fe76880c}
|
|
88
|
360 | Ic6896f7c795d7d303bf7589a74afb937d4a8e8b5 | 1000013 | 2012-08-02 | core | {3efa1eccc11dd5a6c79f9a027dcb8e51921ebf96,9db15e7aec2be68c669af907906b67e1d609891d}
|
|
89
|
361 | Ic6896f7c795d7d303bf7589a74afb937d4a8e8b5 | 1000013 | 2012-08-02 | core | {e92c823bac6faef3a1528189c4f42e11a5e51825,cad72708d8270c96d84237ef1eed964015f1b7ba}
|
|
90
|
362 | Idb37cd23a58816bd16c725fda49a2f9875450e79 | 1000084 | 2012-08-02 | core | {648ceca41c20f4d5b81ac51d422643a7908f6fd2,94a3ac34538806777fcd89656ba045f4f6557f5c}
|
|
91
|
363 | I266772035435a7c623beb0c0f66fc88e6316be8e | 1000084 | 2012-08-02 | core | {90109c7ac5f211027b7759b9e383a687ed90601a,e63d3164930c31589ecf019f8cab8ec1f36440f8}
|
|
92
|
386 | I2fb2004f2f755ce337ddd1419acf2510f17622f3 | 1000013 | 2012-08-10 | core | {e4c094d2a5e46842036e745cf0aad610b6ef0bcc,80cc70af446d0a3f10eef6764894e8732a347f5b}
|
|
93
|
387 | I2fb2004f2f755ce337ddd1419acf2510f17622f3 | 1000013 | 2012-08-10 | core | {47295965ebcedc3f912469855698b55bab9fb931,0ccd58dbcd555ebae2eacbb667ac901b1f732088}
|
|
94
|
389 | I43c792fdba59feafd761bde8529a8683c07bf3d3 | 1000047 | 2012-08-11 | core | {ce20624aa58180a96e426ff7022759603c940531,0b3e29038fb345226499d3e458404c375641db3b}
|
|
95
|
405 | Iee8541ff9e88139648d45f08968476f2b1d4e1b3 | 1000013 | 2012-08-13 | core | {51898e38ba3bd3edd3647f621aaeb769c2323a25,dde714498e3c05cee3fcbfec7eb881d0fa556394}
|
|
96
|
406 | Iee8541ff9e88139648d45f08968476f2b1d4e1b3 | 1000013 | 2012-08-13 | core | {339988050f2471558650a9179eb01e19cfd98acb,e23ad6d72a4dc39e7e9e117aa274527b26ad2a2a}
|
|
97
|
408 | I967b75b54a330692fb88783609e714d016506f89 | 1000103 | 2012-08-13 | core | {befd67df4fa581c8b025d23508ca9c6a09a23c12,70e11ed80127083562f55d6658900152dd1670ca}
|
|
98
|
409 | I0d6f3f5521d32dad1ffaa8675d5f43c7d7fa7cea | 1000147 | 2012-08-13 | core | {fca34b3ba34ca60de99c3d26de67880f79bfc358,d20bc5f5fabdec588a7245e772b176a0d9a3d272}
|
|
99
|
412 | Icb567a848162bcee072476e817cc82278bddfd99 | 1000132 | 2012-08-14 | core | {c685a5ce955ef4ac35f1d6a58aab35f40bfe4ba7,fd4e4cb57927dfeaee8dd0352f5d7722b97058fe,0170200c8912703defde61ca57c9d4e826d32873}
|
|
100
|
750 | I149cc8a4ddfcbc2bfdb7c9c2402efafb40999a59 | 1000003 | 2012-10-02 | dictionaries | {ce1a4352c1dd4dde7c549eb31d1d40d56704fcbf,5f275675ff472ec6c8147697c4a149e1ce5f968c}
|
|
101
|
751 | Iccfc83d5e9ec87802e88f83da1181493630805ea | 1000003 | 2012-10-02 | translations | {1cedc35912b00c4f2d1edd04b676d06f46501872,f83717cf73f4549d9ae09bc557d59316d4165394}
|
|
102
|
27198 | If790a0c065ff3aa109ae4d3c0305d19846dfa1f0 | 1001339 | 2016-07-13 | core | {2ddf84d56b7a6aec58d15d3cf7f4b0824e398e60,14a1a0dc13bbae52de12f5eae0bd4feaab4f4f23,485d3860b04948d788ec32309ce085895562220e,65bd246a8134b629727d99a9c546a55be871a9e2,dfd5db04e8aec8ddd896c9535adc764211530a18,8347b160e4a6b1b3b3045d9cd0525641b2482f1e,d1b3b18cb26b2dbc1870bcddf72ffb2ff0f04e9a,d27039355df46ec96df5bad98d2363defa40c334,e7ca10c9a3c13e191b2b46ea82af75bb7f1bf098,21fcc4956f869b78894163e54ac86a5bfe8478fc,6f4bf2d9c65b3db882b52a926a325e58a7798d12}
|
|
103
|
27997 | Ida358e8212a79da51cee5857a25a2842ae4dffa3 | 1001374 | 2016-08-08 | core | {ea336a5172436808a889e7cc4423522f42789445}
|
|
104
|
(45 rows)
|
|
105
|
|