3 ms·

Just had a look (https://github.com/duckdb/duckdb/issues/9399 https://github.com/duckdb/duckdb/issues/9399). Yeah it's worrying that such a trivial query return

Just had a look (https://github.com/duckdb/duckdb/issues/9399 https://github.com/duckdb/duckdb/issues/9399). Yeah it's worrying that such a trivial query returned incorrect results - but credit to the Devs for getting it fixed quickly. To my knowledge the only databases that can be described as "military-grade" in terms of testing are SQLite and Postgres.

nyanpasu64 3y ago
Apparently DuckDB requires your real-life name to file an online bug report, bucking every norm of online handles for communication, as well as enabling doxxers and stalkers to find and trace people in real life.
- Cthulhu_ 3y ago
  It's the same with a lot of open source contributions; those need to do so for legal and copyright reasons. If you're afraid of doxxing and / or stalking though, at least you have the choice to not contribute. You can still post somewhere else and ask someone else to make the report for you if need be.
  - monsieurbanana 3y ago
    I'm not aware of any other open source project that required a real name just to file a bug
- sega_sai 3y ago
  Yes, that was a surprising requirement when submitting a bug report. (I understand patches may need to be like that due to copyright issues)
- deleted 3y ago
  [deleted]
- silverlyra 3y ago
  I looked at the bug report form and for context it links to a post “Dear anonymous internet user asking for help” https://berthub.eu/articles/posts/anonymous-help/ https://berthub.eu/articles/posts/anonymous-help/ It seems to be about wanting to know who you're talking to when providing free support for an open-source project, and whether the person submitting an issue is using the project for personal use or within an organization. > If I don’t know who you are, am I enabling you to build the new Turkish censorship infrastructure, or helping you implement [Russian internet blocking] more efficiently? These are two examples that actually happened by the way.
Cthulhu_ 3y ago
What about Oracle and MSSQL? I'd imagine that especially the former would be "military-grade" (whatever that entails)
- burgos_thrw 3y ago
  Even Postgres has its share of the bugs, e.g. simple search shows https://www.postgresql.org/message-id/CAGckUK2GLF%3Dd9J5ErEWgK5x8ECqCw4equnq3jEzrqtfJw%2BiHYw%40mail.gmail.com https://www.postgresql.org/message-id/CAGckUK2GLF%3Dd9J5ErEW... Oracle might be military grade because they have the entire web page on how to report wrong results bugs: https://support.oracle.com/knowledge/Oracle%20Cloud/150895_1.html https://support.oracle.com/knowledge/Oracle%20Cloud/150895_1... https://support.oracle.com/knowledge/Oracle%20Database%20Products/2914196_1.html https://support.oracle.com/knowledge/Oracle%20Database%20Pro... etc. Query engines are (not)surprisingly complex software products. Add to that the constant (and aggressive, due to the competition in the field) evolution and adition of the new features that can interact with every existing feature in any existing context and you have a perfect environment for bugs to appear.
code_biologist 3y ago
I'm not sure if the fix is reassuring or not: https://github.com/duckdb/duckdb/pull/9411/files https://github.com/duckdb/duckdb/pull/9411/files
- sega_sai 3y ago
  I certainly liked that the added the problematic query to the list of tests, which I think is a healthy sign.

nyanpasu64 3y ago

Apparently DuckDB requires your real-life name to file an online bug report, bucking every norm of online handles for communication, as well as enabling doxxers and stalkers to find and trace people in real life.

Cthulhu_ 3y ago
It's the same with a lot of open source contributions; those need to do so for legal and copyright reasons. If you're afraid of doxxing and / or stalking though, at least you have the choice to not contribute. You can still post somewhere else and ask someone else to make the report for you if need be.
- monsieurbanana 3y ago
  I'm not aware of any other open source project that required a real name just to file a bug
sega_sai 3y ago
Yes, that was a surprising requirement when submitting a bug report. (I understand patches may need to be like that due to copyright issues)
deleted 3y ago
[deleted]
silverlyra 3y ago
I looked at the bug report form and for context it links to a post “Dear anonymous internet user asking for help” https://berthub.eu/articles/posts/anonymous-help/ https://berthub.eu/articles/posts/anonymous-help/ It seems to be about wanting to know who you're talking to when providing free support for an open-source project, and whether the person submitting an issue is using the project for personal use or within an organization. > If I don’t know who you are, am I enabling you to build the new Turkish censorship infrastructure, or helping you implement [Russian internet blocking] more efficiently? These are two examples that actually happened by the way.

Cthulhu_ 3y ago

What about Oracle and MSSQL? I'd imagine that especially the former would be "military-grade" (whatever that entails)

burgos_thrw 3y ago
Even Postgres has its share of the bugs, e.g. simple search shows https://www.postgresql.org/message-id/CAGckUK2GLF%3Dd9J5ErEWgK5x8ECqCw4equnq3jEzrqtfJw%2BiHYw%40mail.gmail.com https://www.postgresql.org/message-id/CAGckUK2GLF%3Dd9J5ErEW... Oracle might be military grade because they have the entire web page on how to report wrong results bugs: https://support.oracle.com/knowledge/Oracle%20Cloud/150895_1.html https://support.oracle.com/knowledge/Oracle%20Cloud/150895_1... https://support.oracle.com/knowledge/Oracle%20Database%20Products/2914196_1.html https://support.oracle.com/knowledge/Oracle%20Database%20Pro... etc. Query engines are (not)surprisingly complex software products. Add to that the constant (and aggressive, due to the competition in the field) evolution and adition of the new features that can interact with every existing feature in any existing context and you have a perfect environment for bugs to appear.

code_biologist 3y ago

I'm not sure if the fix is reassuring or not: https://github.com/duckdb/duckdb/pull/9411/files https://github.com/duckdb/duckdb/pull/9411/files

sega_sai 3y ago
I certainly liked that the added the problematic query to the list of tests, which I think is a healthy sign.