Most head-slapping feature in a language
-
@Forogar and I were having a chat about unintended programming features (ahem) due to things like: Javascript's truthy:
"1" == 1 is trueRexx:" Hello " == "Hello" and 0.0 == 0 is not the same as 0 == 0.0SQL:Len("hello") = Len("hello ")I'm just wondering what other family favourites there are out there. (Edited because clearly I’ve lost track of what’s up and what’s down)cheers Chris Maunder
Quote:
Len("hello") = Len("hello ")
I was thinking how char vs. varchar are treated in SQL and messed around trying to get the LEN('HELLO ') != LEN('HELLO') It's like an incorrect passing/appenidng/using VARCHAR(MAXLEN): if it passes through anything not of MAXLEN it's truncated (to 8K or, to 'HELLO'). Lesson learned, although I've not declared an actual char field [ >char(2) ] in years, and even that, only rarely.
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein
"If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010
-
@Forogar and I were having a chat about unintended programming features (ahem) due to things like: Javascript's truthy:
"1" == 1 is trueRexx:" Hello " == "Hello" and 0.0 == 0 is not the same as 0 == 0.0SQL:Len("hello") = Len("hello ")I'm just wondering what other family favourites there are out there. (Edited because clearly I’ve lost track of what’s up and what’s down)cheers Chris Maunder
Of those, I use only SQL, and it's worse than that. (Transact-SQL at least.) Remember that RTRIM and LTRIM remove only SPACEs, not all whitespace. Basically, LEN (and RTRIM and LTRIM) work on bytes, so it does the same things with VARBINARY as it does with VARCHAR. So I should not have been surprised when performing LEN on a VARBINARY ignores 0x32 at the end as well. :sigh:
-
@Forogar and I were having a chat about unintended programming features (ahem) due to things like: Javascript's truthy:
"1" == 1 is trueRexx:" Hello " == "Hello" and 0.0 == 0 is not the same as 0 == 0.0SQL:Len("hello") = Len("hello ")I'm just wondering what other family favourites there are out there. (Edited because clearly I’ve lost track of what’s up and what’s down)cheers Chris Maunder
Also remember that T-SQL != SQL. Just saying. Having been working with SQL server for a couple of years now I have to say that the string handling have a lot more to wish for. X|
Wrong is evil and must be defeated. - Jeff Ello
-
@Forogar and I were having a chat about unintended programming features (ahem) due to things like: Javascript's truthy:
"1" == 1 is trueRexx:" Hello " == "Hello" and 0.0 == 0 is not the same as 0 == 0.0SQL:Len("hello") = Len("hello ")I'm just wondering what other family favourites there are out there. (Edited because clearly I’ve lost track of what’s up and what’s down)cheers Chris Maunder
Well, in SQL:
Len('hello') = Len(' hello')
is false (5 = 6). This is my fave thing to do in a query window for a quick update:
IF (1=2)
BEGINBEGIN TRAN UPDATE [SomeTable] SET [someColumn] = 'someNewValue' WHERE [someID] = 0
ROLLBACK
COMMIT
END
I still get intellisense within the BEING/END area and, should I accidentally press F5 or run the silly thing w/o selecting the code to run, no harm done. Yeah, I know, gotta make sure I include the WHERE clause, and also BEGIN TRAN. I then select and run COMMIT.
The best way to improve Windows is run it on a Mac. The best way to bring a Mac to its knees is to run Windows on it. ~ my brother Jeff
-
Well, in SQL:
Len('hello') = Len(' hello')
is false (5 = 6). This is my fave thing to do in a query window for a quick update:
IF (1=2)
BEGINBEGIN TRAN UPDATE [SomeTable] SET [someColumn] = 'someNewValue' WHERE [someID] = 0
ROLLBACK
COMMIT
END
I still get intellisense within the BEING/END area and, should I accidentally press F5 or run the silly thing w/o selecting the code to run, no harm done. Yeah, I know, gotta make sure I include the WHERE clause, and also BEGIN TRAN. I then select and run COMMIT.
The best way to improve Windows is run it on a Mac. The best way to bring a Mac to its knees is to run Windows on it. ~ my brother Jeff
Officially, I actively choose to not slap myself becuz of a (programming) language's nuance(s). :doh:
The best way to improve Windows is run it on a Mac. The best way to bring a Mac to its knees is to run Windows on it. ~ my brother Jeff
-
@Forogar and I were having a chat about unintended programming features (ahem) due to things like: Javascript's truthy:
"1" == 1 is trueRexx:" Hello " == "Hello" and 0.0 == 0 is not the same as 0 == 0.0SQL:Len("hello") = Len("hello ")I'm just wondering what other family favourites there are out there. (Edited because clearly I’ve lost track of what’s up and what’s down)cheers Chris Maunder
-
@Forogar and I were having a chat about unintended programming features (ahem) due to things like: Javascript's truthy:
"1" == 1 is trueRexx:" Hello " == "Hello" and 0.0 == 0 is not the same as 0 == 0.0SQL:Len("hello") = Len("hello ")I'm just wondering what other family favourites there are out there. (Edited because clearly I’ve lost track of what’s up and what’s down)cheers Chris Maunder
You had me at Javascript baby! ;P
A new .NET Serializer All in one Menu-Ribbon Bar Taking over the world since 1371!
-
English! fish equals ghoti :cool: Ghoti - Wikipedia[^]
"If we don't change direction, we'll end up where we're going"
ghoti and chips today, yum! ;P
A new .NET Serializer All in one Menu-Ribbon Bar Taking over the world since 1371!
-
@Forogar and I were having a chat about unintended programming features (ahem) due to things like: Javascript's truthy:
"1" == 1 is trueRexx:" Hello " == "Hello" and 0.0 == 0 is not the same as 0 == 0.0SQL:Len("hello") = Len("hello ")I'm just wondering what other family favourites there are out there. (Edited because clearly I’ve lost track of what’s up and what’s down)cheers Chris Maunder
The point of === is that "1" == 1 but "1" !== 1, that is, "1" === 1 will return false, due to the differing types
-
@Forogar and I were having a chat about unintended programming features (ahem) due to things like: Javascript's truthy:
"1" == 1 is trueRexx:" Hello " == "Hello" and 0.0 == 0 is not the same as 0 == 0.0SQL:Len("hello") = Len("hello ")I'm just wondering what other family favourites there are out there. (Edited because clearly I’ve lost track of what’s up and what’s down)cheers Chris Maunder
I had a colleague who insisted on occasionally writing the (perfectly valid but ummm counter-intuitive) form
index[array]
in C. He also worked out some multi-dimensional extensions, which my marginal brain is too small to contain. And yes, he did have a shot at the The International Obfuscated C Code Contest[^] Cheers, Peter
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
-
The point of === is that "1" == 1 but "1" !== 1, that is, "1" === 1 will return false, due to the differing types
So obvious! :omg: :rolleyes: :laugh:
A new .NET Serializer All in one Menu-Ribbon Bar Taking over the world since 1371!
-
I had a colleague who insisted on occasionally writing the (perfectly valid but ummm counter-intuitive) form
index[array]
in C. He also worked out some multi-dimensional extensions, which my marginal brain is too small to contain. And yes, he did have a shot at the The International Obfuscated C Code Contest[^] Cheers, Peter
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
What a legend! :D
A new .NET Serializer All in one Menu-Ribbon Bar Taking over the world since 1371!
-
So obvious! :omg: :rolleyes: :laugh:
A new .NET Serializer All in one Menu-Ribbon Bar Taking over the world since 1371!
The reason programming pays well is that you need to learn how the languages work :)
-
@Forogar and I were having a chat about unintended programming features (ahem) due to things like: Javascript's truthy:
"1" == 1 is trueRexx:" Hello " == "Hello" and 0.0 == 0 is not the same as 0 == 0.0SQL:Len("hello") = Len("hello ")I'm just wondering what other family favourites there are out there. (Edited because clearly I’ve lost track of what’s up and what’s down)cheers Chris Maunder
I remember being frustrated by the fact C# 1.0 had a default container called ArrayList. Is it an Array, or a List? These are very different things. Is it a fancy container that somehow has worked out how to get the benefits of both? The documentation never said.
-
@Forogar and I were having a chat about unintended programming features (ahem) due to things like: Javascript's truthy:
"1" == 1 is trueRexx:" Hello " == "Hello" and 0.0 == 0 is not the same as 0 == 0.0SQL:Len("hello") = Len("hello ")I'm just wondering what other family favourites there are out there. (Edited because clearly I’ve lost track of what’s up and what’s down)cheers Chris Maunder
Try the Predict the Output Challenge (C#)[^]. It shows some fun C# quirks (especially part 1) with types, enumerables etc. :D
Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly
-
@Forogar and I were having a chat about unintended programming features (ahem) due to things like: Javascript's truthy:
"1" == 1 is trueRexx:" Hello " == "Hello" and 0.0 == 0 is not the same as 0 == 0.0SQL:Len("hello") = Len("hello ")I'm just wondering what other family favourites there are out there. (Edited because clearly I’ve lost track of what’s up and what’s down)cheers Chris Maunder
I'm sure your first one should be: ``` "1" == 1 is true ``` `===` specifically takes type into account. Javascript's type co-ercion can be a win or a lose, depending on what you want. If type matters, use `===` and `!==`
-
@Forogar and I were having a chat about unintended programming features (ahem) due to things like: Javascript's truthy:
"1" == 1 is trueRexx:" Hello " == "Hello" and 0.0 == 0 is not the same as 0 == 0.0SQL:Len("hello") = Len("hello ")I'm just wondering what other family favourites there are out there. (Edited because clearly I’ve lost track of what’s up and what’s down)cheers Chris Maunder
That kind of things already existed when our ancestors began to cast logic into silicon[^]. Of course, there also were well designed CPUs[^] that had exactly 256 opcodes, with only 0x68 being reserved as prefix for future expansions of the instruction set. And of course there are the opcodes 0xE0 - 0xEF, the 'Set X Register' instruction for registers 0x0 - 0xF, short SEX. Absolutely no confusion here.
I have lived with several Zen masters - all of them were cats. His last invention was an evil Lasagna. It didn't kill anyone, and it actually tasted pretty good.
-
@Forogar and I were having a chat about unintended programming features (ahem) due to things like: Javascript's truthy:
"1" == 1 is trueRexx:" Hello " == "Hello" and 0.0 == 0 is not the same as 0 == 0.0SQL:Len("hello") = Len("hello ")I'm just wondering what other family favourites there are out there. (Edited because clearly I’ve lost track of what’s up and what’s down)cheers Chris Maunder
Chris Maunder wrote:
SQL:
Len("hello") = Len("hello ")That is a fun one that I came across a while ago. for some reason SQL Server ignores the trailing spaces hence they match. LEN (Transact-SQL) - SQL Server | Microsoft Docs[^]
Every day, thousands of innocent plants are killed by vegetarians. Help end the violence EAT BACON
-
@Forogar and I were having a chat about unintended programming features (ahem) due to things like: Javascript's truthy:
"1" == 1 is trueRexx:" Hello " == "Hello" and 0.0 == 0 is not the same as 0 == 0.0SQL:Len("hello") = Len("hello ")I'm just wondering what other family favourites there are out there. (Edited because clearly I’ve lost track of what’s up and what’s down)cheers Chris Maunder
erm, typo?
"1" === 1 is false
"1" == 1 is true (truthy rather) -
Officially, I actively choose to not slap myself becuz of a (programming) language's nuance(s). :doh:
The best way to improve Windows is run it on a Mac. The best way to bring a Mac to its knees is to run Windows on it. ~ my brother Jeff
Re-read the OP. Chris didn't state he was going to slap his own head .... :laugh:
