Change Details

create temporary table _temp_debtags_sha256 ( sha256 bytea primary key; ); insert into _temp_debtags_sha256 (sha256) values ( (decode(fb78f9b3c701509d42cb7709dc495b5723aedfe8b306cf60e3aaa73904a9015d, 'hex'), (decode(1aca7c611b16204ab8d9fbe9f228d2ad2f501c28ed8980fef4dbff99dfd38075, 'hex'), (decode(7d31ca0c5581148eb99de0c95c05f77114eadfd33ffd637cfbbf4e15bc797e9c, 'hex'), (decode(f128890f95ee43c6d126f032acf4e71ce26583ebee27bf391f4a502fa53cb42b, 'hex'), (decode(fb78f9b3c701509d42cb7709dc495b5723aedfe8b306cf60e3aaa73904a9015d, 'hex'), (decode(810c006b2c037aea6cea68536c6096a5ad2e38a92c20cbe2359a3a999404adf3, 'hex'), (decode(9e7d91ce58596e2fab20cc447891294be4960c6fc1ca7779e18a927c5b5c77d7, '[hex'), [...] (decode(159b80b4cb174260ab8495015c5ffc8775ea62fb2857aadebe7803af2cb24032, 'hex'), (decode(e206cfc453626fe957324b3b7396ee3a5d9bc3b1b84c326c0551fa60995e8197, 'hex'), (decode(610ebae9d6b7066c3960c81061210a7784c518fd1d87771ade04a5cfa2abad3f, 'hex') ); select content.sha1, content.sha256 from content inner join _temp_debtags_sha256 on _temp_debtags_sha256.sha256 = content.sha256;

begin; create temporary table _temp_debtags_sha256 ( sha256 sha256 ) on commit drop; COPY _temp_debtags_sha256 (sha256) FROM STDIN; \\xfb78f9b3c701509d42cb7709dc495b5723aedfe8b306cf60e3aaa73904a9015d \\x1aca7c611b16204ab8d9fbe9f228d2ad2f501c28ed8980fef4dbff99dfd38075 \\x610ebae9d6b7066c3960c81061210a7784c518fd1d87771ade04a5cfa2abad3f \. select t.sha256, sha1 from _temp_debtags_sha256 t left join content using (sha256); commit;

begin; create temporary table _temp_debtags_sha256 ( sha256 bytea primary key;sha256 ); insert into _temp_debtags_sha256 (sha256) values ( on commit drop; (decode(fb78f9b3c701509d42cb7709dc495b5723aedfe8b306cf60e3aaa73904a9015d, 'hex'), (decode(1aca7c611b16204ab8d9fbe9f228d2ad2f501c28ed8980fef4dbff99dfd38075, 'hex'),COPY _temp_debtags_sha256 (sha256) FROM STDIN; (decode(7d31ca0c5581148eb99de0c95c05f77114eadfd33ffd637cfbbf4e15bc797e9c, 'hex'),\\xfb78f9b3c701509d42cb7709dc495b5723aedfe8b306cf60e3aaa73904a9015d (decode(f128890f95ee43c6d126f032acf4e71ce26583ebee27bf391f4a502fa53cb42b, 'hex'),\\x1aca7c611b16204ab8d9fbe9f228d2ad2f501c28ed8980fef4dbff99dfd38075 (decode(fb78f9b3c701509d42cb7709dc495b5723aedfe8b306cf60e3aaa73904a9015d, 'hex'),\\x610ebae9d6b7066c3960c81061210a7784c518fd1d87771ade04a5cfa2abad3f (decode(810c006b2c037aea6cea68536c6096a5ad2e38a92c20cbe2359a3a999404adf3, 'hex'), (decode(9e7d91ce58596e2fab20cc447891294be4960c6fc1ca7779e18a927c5b5c77d7, '[hex'), [...]\. (decode(159b80b4cb174260ab8495015c5ffc8775ea62fb2857aadebe7803af2cb24032select t.sha256, 'hex'),sha1 (decode(e206cfc453626fe957324b3b7396ee3a5d9bc3b1b84c326c0551fa60995e8197, 'hex'),from _temp_debtags_sha256 t (decode(610ebae9d6b7066c3960c81061210a7784c518fd1d87771ade04a5cfa2abad3f, 'hex') ); select content.sha1,left join content.sha256 from contentusing (sha256); inner join _temp_debtags_sha256commit; on _temp_debtags_sha256.sha256 = content.sha256;