That elongated, streamlined shell made me assume this was a joke or hoax at first.
Deebster
I hadn't heard about the carrot disclosure stuff, but I hope this doesn't become a common thing. Just saying "I can hack you" with some purported output from a script is pretty useless feedback.
Can you also fly them at 90°? I'm thinking about flags like Japan 🇯🇵 where is the same or the UK 🇬🇧 where most couldn't tell.
Recently while troubleshooting I've found a lot of deleted comments with dozens of people saying thanks, often for years afterwards. Reddit annoyed their most valuable posters and we're all paying for it.
Making encryption cheaper to implement for IoT stuff is definitely a good thing, although bugs that won't ever be patched will likely continue to be the main problem.
Defcon 33 just finished with no news about a backdoor (remember Dual_EC_DRBG), so that's nice.
It's equivalent because UNION removes duplicates; the behaviour you're describing happens with UNION ALL. Since both queries are article.*, both halves will have the same columns and the dedupe will be successful.
UNION is less efficient because of this deduplication, but it's the default since that's what most people want. If that matters then you'd be correct that a JOIN version will be more efficient (possibly depending on indexes present and sql engine).
To be clear, the command is made with modern C++, not the icons (which come from nerd fonts or the dev's equivalent).
That won't show if results are equivalent, only if the query plans are matching, which they won't be (at least before the SQL engine's optimisations).
There aren't any joins in either query (and only one table involved), so that quoted bit of documentation isn't relevant.
Order aside, the two results would be identical In the same way that 2(4 + 3) = 2×4 + 2×3
Interestingly, I can see that post in infosec's copy, which suggests that p.dev has accepted and federated it. I know that there was a problem with indexing posts on p.dev a while ago, perhaps it's still an issue.


I made a rubber duck for all your debugging needs: