STAY FOOLISH!

How to calculate the infinite product by SQL Description I needed to calculate the infinite product in the creating ETL script. So I thought the solution to calculate it in the SQL. The following way is the solution I thought. Premise Use the standard SQL Code WITH sample_table AS ( SELECT 2 AS n1, 4 AS n2 UNION ALL SELECT 4 , 8 UNION ALL SELECT 10 , 20 UNION ALL SELECT 10 , 20 ) SELECT * FROM sample_table UNION ALL SELECT CAST ( EXP ( SUM ( LOG (n1))) AS INT64) AS inf_product1, CAST ( EXP ( SUM ( LOG (n2))) AS INT64) AS inf_product2 FROM sample_table The infinite product (∏) is able to convert to the total addition formula. ∏n1 ≒ e Σlog e n1 ∏n2 ≒ e Σlog e n2 Finally Actually, this calculated value is an approximation. So if you want an accurate number, this solution cannot use.

How to get the Phabricator's ticket No. by using the commit hash of git Description Sometimes, we would like to check that the release branch has only completed task's commit. For example, we must prove to be not including unapproved commit in the release branch at IT audit. So, I write the operation to get the Phabricator's ticket No. Operations Get the commit-hash First of all, we get the difference of commits between the current branch and previous branch with git log command. git log --pretty=oneline $OLD_BRANCH..$NEW_BRANCH | awk '{print $1}' $OLD_BRANCH: Previous release branch $NEW_BRANCH: Current release branch Get the repository-ID Secondly, we need to get the repository's PHID to get the commit PHID. You can get it to use phid.lookup command. echo '{"names": ["$REPOSITORY_NAME"]}' | arc call-conduit --c...