Comments on: Variables ambiguities in names and values https://shlomi-noach.github.io/blog/mysql/variables-ambiguities-in-names-and-values Blog by Shlomi Noach Tue, 06 Mar 2012 21:27:54 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: Rick James https://shlomi-noach.github.io/blog/mysql/variables-ambiguities-in-names-and-values/comment-page-1#comment-74142 Tue, 06 Mar 2012 21:27:54 +0000 https://shlomi-noach.github.io/blog/?p=793#comment-74142 The programming public is Boolean-challenged. I get so irritated every time I see (in any of several languages)
if () x = TRUE else x = FALSE;

The equivalence of 0/false/off and 1/true/on will be hard to ‘teach’, regardless of which way you go.

I do agree that consistency would be nice. Fortunately, MySQL is usually forgiving.

Another frustration: The flags that are done by there presence/absence, perhaps including
log-slave-updates
skip-external-locking

]]> By: INFORMATION_SCHEMA.GLOBAL_STATUS: watch out | code.openark.org https://shlomi-noach.github.io/blog/mysql/variables-ambiguities-in-names-and-values/comment-page-1#comment-4879 Wed, 14 Oct 2009 19:03:40 +0000 https://shlomi-noach.github.io/blog/?p=793#comment-4879 […] There are a few ON/OFF values (I’ve expressed my opinion and concerns on these here and here; why not just use 0/1?). SSL_CIPHER seems like the only variable which can get long enough […]

]]> By: Jay Pipes https://shlomi-noach.github.io/blog/mysql/variables-ambiguities-in-names-and-values/comment-page-1#comment-1752 Thu, 30 Apr 2009 17:58:12 +0000 https://shlomi-noach.github.io/blog/?p=793#comment-1752 Hi! Yep, the Drizzle community, as Devananda mentioned, is currently discussing this. The thread in questions starts here:

https://lists.launchpad.net/drizzle-discuss/msg03804.html

Cheers!

Jay

]]> By: Devananda https://shlomi-noach.github.io/blog/mysql/variables-ambiguities-in-names-and-values/comment-page-1#comment-1726 Wed, 29 Apr 2009 05:12:30 +0000 https://shlomi-noach.github.io/blog/?p=793#comment-1726 Yes, this has annoyed me too, particularly early on. There’s a discussion right now about refactoring the configuration management for Drizzle into a plugin, hopefully fixing this can be included in that project 🙂

]]> By: Pavel https://shlomi-noach.github.io/blog/mysql/variables-ambiguities-in-names-and-values/comment-page-1#comment-1722 Tue, 28 Apr 2009 13:30:34 +0000 https://shlomi-noach.github.io/blog/?p=793#comment-1722 Thanks for the post. Before I got used to the ambiguity, I kept looking into the docs. Having a single notation would be something to look forward to in both drizzle and mysql.

]]> By: ahmad https://shlomi-noach.github.io/blog/mysql/variables-ambiguities-in-names-and-values/comment-page-1#comment-1716 Tue, 28 Apr 2009 08:34:23 +0000 https://shlomi-noach.github.io/blog/?p=793#comment-1716 you are right. there should be a standard for this.

]]>