Log for YSITD
r(theta) = ......
找 r(t1) = r(t2), t1 = t2 + n* 2pi 和 r(t1) = -r(t2), t1 = t2 + (2n+1) * pi
找 r(t1) = r(t2), t1 = t2 + n* 2pi 和 r(t1) = -r(t2), t1 = t2 + (2n+1) * pi
That is, you need to find if r is injective or not. If it is injective, no intersection could possibly occur. Otherwise, construct an example to show that r is, in fact, not injective.
That simply amounts to finding distinct elements in domain that gets mapped to the same "point" in codomain
r is a function that maps the parameter of your choice to its corresponding point!
就，我最近在爬 crtsh 阿，遇到一個問題
https://gist.github.com/s3131212/3fff123960c050ad0827e52e36980612
https://gist.github.com/s3131212/3fff123960c050ad0827e52e36980612
就，`x509_altnames(sub.CERTIFICATE) SUBJECT_ALT_NAME,` 這行，當某一筆 record 沒有 subject alternative name 的時候，他會直接選不到那一個 row，當我不 select 這個 column 時結果就正常
但這很奇怪RRRRRRRR 至少以前我寫過的所有 DB，如果 select 到沒有值的 column 就只是給我一個 null 而已，不會讓那個 row 直接消失（其他 column 是有 value 的）
我會了
你可以這樣寫
例如
你可以這樣寫
COALESCE((SELECT x509_altNames(sub.CERTIFICATE)), NULL) altnames例如
SELECT min(sub.CERTIFICATE_ID) ID,
min(sub.ISSUER_CA_ID) ISSUER_CA_ID,
array_agg(DISTINCT sub.NAME_VALUE) NAME_VALUES,
x509_subjectName(sub.CERTIFICATE) SUBJECT_NAME,
x509_notBefore(sub.CERTIFICATE) NOT_BEFORE,
x509_notAfter(sub.CERTIFICATE) NOT_AFTER,
COALESCE((SELECT x509_altNames(sub.CERTIFICATE)), NULL) altnames
FROM (SELECT *
FROM certificate_and_identities cai
WHERE plainto_tsquery('embedded.one.microsoft.com') @@ identities(cai.CERTIFICATE)
AND cai.NAME_VALUE ILIKE ('%' || 'embedded.one.microsoft.com' || '%')
LIMIT 1
) sub
GROUP BY sub.CERTIFICATE;SELECT min(sub.CERTIFICATE_ID) ID,
min(sub.ISSUER_CA_ID) ISSUER_CA_ID,
array_agg(DISTINCT sub.NAME_VALUE) NAME_VALUES,
x509_subjectName(sub.CERTIFICATE) SUBJECT_NAME,
x509_notBefore(sub.CERTIFICATE) NOT_BEFORE,
x509_notAfter(sub.CERTIFICATE) NOT_AFTER,
array_agg(san) alt_names
FROM (SELECT *
FROM certificate_and_identities cai
WHERE plainto_tsquery('embedded.one.microsoft.com') @@ identities(cai.CERTIFICATE)
AND cai.NAME_VALUE ILIKE ('%' || 'embedded.one.microsoft.com' || '%')
LIMIT 10000
) sub LEFT OUTER JOIN LATERAL (SELECT x509_altNames(sub.CERTIFICATE)) san ON TRUE
GROUP BY sub.CERTIFICATE;這樣應該可以
好像是因為這樣寫會直接把 record 存進 array 裡面
像這樣應該就不會了
像這樣應該就不會了
SELECT min(sub.CERTIFICATE_ID) ID,
min(sub.ISSUER_CA_ID) ISSUER_CA_ID,
array_agg(DISTINCT sub.NAME_VALUE) NAME_VALUES,
x509_subjectName(sub.CERTIFICATE) SUBJECT_NAME,
x509_notBefore(sub.CERTIFICATE) NOT_BEFORE,
x509_notAfter(sub.CERTIFICATE) NOT_AFTER,
array_agg(san.value) alt_names
FROM (SELECT *
FROM certificate_and_identities cai
WHERE plainto_tsquery('embedded.one.microsoft.com') @@ identities(cai.CERTIFICATE)
AND cai.NAME_VALUE ILIKE ('%' || 'embedded.one.microsoft.com' || '%')
LIMIT 10000
) sub LEFT OUTER JOIN LATERAL (SELECT x509_altNames(sub.CERTIFICATE)) san(value) ON TRUE
GROUP BY sub.CERTIFICATE;