WTF Bites
-
So, I'm guessing the char(1) takes 'T' or 'F'?
It does take
F
, though you may not have encountered it.
It stands forFILE_NOT_FOUND
.
-
@BernieTheBernie said in WTF Bites:
a boolean type (as opposed to boolean-typed) column from the program's database (SQL Server)
Are you sure it's not Oracle?
Because with Oracle, there is no boolean...Pretty sure, given that I had to actually peek the database schema/data on the server to find out what's what. Documentation? Wassat?
@BernieTheBernie said in WTF Bites:
So, I'm guessing the char(1) takes 'T' or 'F'?
It does take
F
, though you may not have encountered it.
It stands forFILE_NOT_FOUND
.The depressing thing is that this is not altogether impossible in this case...
-
Perhaps it was an Oracle DB moved to SQL Server?
-
@Medinoc Also unlikely. We're talking about a freeware, government-funded application that has been going for over 20 years and is supposed to be available to just about anyone (so... Windows-only).
I believe the default of the two DB engines available is actually Microsoft Jet. SQL Server is the other one.
-
-
@BernieTheBernie said in WTF Bites:
Perhaps it was an Oracle
DBprogrammer moved to SQL Server?
Now that's actually pretty likely.
-
@BernieTheBernie said in WTF Bites:
So, I'm guessing the char(1) takes 'T' or 'F'?
It does take
F
, though you may not have encountered it.
It stands forFILE_NOT_FOUND
.It could also take
W
,T
orF
as a triplet of options.
-
So, NULL is false and 'X' marks the spot.
C/C++ programmer brain damage: At least they used false-y and true-y values.
NULL
is not always false-y; SQL standard uses "troolean" logic (true
/false
/null
)I think this discussion missed the : NULL cannot be used by operators, including
=
andNOT
.NULL=NULL
,NULL='X'
andNOT(NULL)
are allNULL
; usingNULL
as a query parameter (WHERE flag=?
) does work in some DB/language combinations and does not in others. And then there'sGROUP BY CUBE
andLEFT JOIN
whereNULL
has two possible meanings and...In short: using
NULL
asfalse
is a failure of epic proportions, something that will continue breaking things in the future, in a new and funny ways.
-
Hey kids! How would you implement a boolean column in your relational database?
As soon as I read this, I knew where it was going. Though, I must say, it was even more dumb than usual.
The dumbest I've seen was just a 10 character field to hold a boolean value. And because it was a big field, not-a-boolean had started to be saved there as well causing since really interesting logic to read the boolean in there.
-
The really important question is: what is the Polish equivalent of Kevin?
-
@Kamil-Podlesak said in WTF Bites:
I think this discussion missed the : NULL cannot be used by operators, including
=
andNOT
.NULL=NULL
,NULL='X'
andNOT(NULL)
are allNULL
; usingNULL
as a query parameter (WHERE flag=?
) does work in some DB/language combinations and does not in others. And then there'sGROUP BY CUBE
andLEFT JOIN
whereNULL
has two possible meanings and...In short: using
NULL
asfalse
is a failure of epic proportions, something that will continue breaking things in the future, in a new and funny ways.While that's a significant and important problem, it is also - crucially - someone else's.
-
-
Status: Picture if you will, a "Contact list" which is just a folder full of folders loosely following the naming convention of "{name} {maybe number}", each containing no contents.
I learned about this "contact list" because apparently someone deleted the contents of the folder on the 14th and they just now noticed it was gone.
-
@Tsaukpaetra said in WTF Bites:
Damn. I hate it when people preempt the joke I was gonna make.
(: I know, not the same phone number.)
-
@sebastian-galczynski said in WTF Bites:
172M ./node_modules
You're like a little baby. Watch this:
449M node_modules/
And it's basically a backend for a not-particularly-complex CRUD, and only about 30% done in my estimation. This actually convinced me to use stored procedures for some basic sanity checks. I just don't trust this... stuff, and its authors.
Why in the world is a backend being built with node?
I try not to get involved with this stuff more than necessary so ICBW or or , but … that was the whole idea to begin with, wasn't it?
-
Hey kids! How would you implement a boolean column in your relational database?
As soon as I read this, I knew where it was going. Though, I must say, it was even more dumb than usual.
The dumbest I've seen was just a 10 character field to hold a boolean value. And because it was a big field, not-a-boolean had started to be saved there as well causing since really interesting logic to read the boolean in there.Everybody knows
CHAR(14)
is the minimum size for a boolean.
-
Why in the world is a backend being built with node?
I try not to get involved with this stuff more than necessary so ICBM
Yes, good idea. It's the only way to be sure.
-
Hey kids! How would you implement a boolean column in your relational database?
As soon as I read this, I knew where it was going. Though, I must say, it was even more dumb than usual.
The dumbest I've seen was just a 10 character field to hold a boolean value. And because it was a big field, not-a-boolean had started to be saved there as well causing since really interesting logic to read the boolean in there.Everybody knows
CHAR(14)
is the minimum size for a boolean.You could use a
CLOB
so you're future-proofed.
-
@Tsaukpaetra Who is the perpetrator of this atrocity? Why is that person trying to make SSDS look good by comparison?
-
@Tsaukpaetra Who is the perpetrator of this atrocity? Why is that person trying to make SSDS look good by comparison?
Two words: Doctor's office.
-
@Tsaukpaetra said in WTF Bites:
@Tsaukpaetra Who is the perpetrator of this atrocity? Why is that person trying to make SSDS look good by comparison?
Two words:
Doctor's office.Market Found
-
Everybody knows CHAR(14) is the minimum size for a boolean.
That is certainly
FILE_NOT_FOUND
.
-
@Tsaukpaetra said in WTF Bites:
I learned about this "contact list" because apparently someone deleted the contents of the folder on the 14th and they just now noticed it was gone.
Everyone knows that if you want an empty folder to stay around you should add a hidden file to it named
.keep_me
.
-
@PleegWat what's wrong with
...
?
-
@Gribnit Windows won't let you create it.
-
@PleegWat Nope.
-
@Rhywden
E_NO_REPRO
. What you have is probably a file called....txt
.When I try to rename a file from
foo.txt
to...
in Explorer, it complains that there already is a file with that name. Same as for..
. The error message is a different one than if I want to rename it to normal file name which actually already exists, in which case it asks "Do you want to renamefoo.txt
tobar (2).txt
?".Creating a file called
...
on an NFS mount Windows displays it as~1
.
-
@topspin
…
(ellipsis, one codepoint) does work.
-
@topspin Sorry, I did a and used my l33t Paint skills.
-
@topspin Sorry, I did a and used my l33t Paint skills.
Git is a better medium for this one.
-
Found this one referenced on a comment on the front page, in a post by Kleyguerth
https://www.youtube.com/watch?v=b-Fa6HtvGtQ
(in the https://thedailywtf.com/articles/comments/a-slice-of-spam article)
-
@Gribnit Windows won't let you create it.
Are you sure?
I am to boot Windows now, but I remember they are inconsistent about things. Some restrictions are implemented in the filesystem layer, but other are only implemented in explorer and cmd.exe, and some only apply to plain paths, but not the
\\?\
ones. I remember creating file with some funky name with cygwin that then couldn't be deleted or renamed or anything in explorer…
-
@Bulb Goes off and checks
Yup, WSL will let me create it. After creating an empty file in WSL, explorer says:
For clarity, this is an empty file, not a directory.
-
@PleegWat and thus, deletion is prevented.
-
@Rhywden
E_NO_REPRO
. What you have is probably a file called....txt
.When I try to rename a file from
foo.txt
to...
in Explorer, it complains that there already is a file with that name. Same as for..
. The error message is a different one than if I want to rename it to normal file name which actually already exists, in which case it asks "Do you want to renamefoo.txt
tobar (2).txt
?".Creating a file called
...
on an NFS mount Windows displays it as~1
.vim "..."
(yeah, I was in d:\download)
-
Hey! Stop your stupid shenanigans before I reboot all of you.
-
@PleegWat and thus, deletion is prevented.
Wait, that was your play all along?
You mad genius.
-
@PleegWat and thus, deletion is prevented.
Wait, that was your play all along?
You mad genius.It was the problem statement.
-
-
More aviation stupidity:
https://www.youtube.com/watch?v=-dXgDNqTJRo
TL;DW: Red Bull sponsored a stunt in which two pilots/skydivers planned to put their planes into a vertical dive, slowed by a giant speed brake to about the same speed as a skydiver in free-fall. They would then jump out of their respective planes, swap planes mid-air, level off, and resume normal flight. This would violate several FAA regulations, so they petitioned for an exemption. FAA said no. They did it anyway, and the stunt didn't quite go as planned, resulting in one of the planes crashing. (No injuries; the relevant pilot/skydiver deployed his parachute and landed safely.) The FAA is not amused.
-
@HardwareGeek said in WTF Bites:
The FAA is not amused.
Odds that another pilot losses their license?
-
@dcon Rather high. Permanently or temporarily? Likely both pilots, since they both broke the regulations.
-
@HardwareGeek said in WTF Bites:
@dcon Rather high. Permanently or temporarily? Likely both pilots, since they both broke the regulations.
Yeah, that's a bet I wouldn't want to actually make!
-
@HardwareGeek said in WTF Bites:
the stunt didn't quite go as planned, resulting in one of the planes crashing. (No injuries; the relevant pilot/skydiver deployed his parachute and landed safely.) The FAA is not amused.
I hope they got the opportunity to tell the guys: "See? We told you it was a Bad Idea™."
-
@Zerosquare That seems a little too light-hearted for what the FAA is (probably) going to do to them. It would be one thing if they'd just violated the regulations, but having been given an explicit "No" and doing it anyway is another level of misconduct, and I expect the FAA to come down harder than the crashed airplane did.
-
Hey kids! How would you implement a boolean column in your relational database?
As soon as I read this, I knew where it was going. Though, I must say, it was even more dumb than usual.
The dumbest I've seen was just a 10 character field to hold a boolean value. And because it was a big field, not-a-boolean had started to be saved there as well causing since really interesting logic to read the boolean in there.Everybody knows
CHAR(14)
is the minimum size for a boolean.You could use a
CLOB
so you're future-proofed.true
,false
, andFILE_NOT_FOUND
should be enough for everybody.
-
@HardwareGeek said in WTF Bites:
Because they failed to demonstrate any public benefit. Sponsorship commitments are not a public benefit.
I don't think this is the real problem. After all a bunch of other stunts did get their waivers. But it seems that the stunt wasn't all that well planned and prepared after all. Which isn't very like Red Bull, which sponsored many stunts over the years and had them much better prepared and did get them approved, but somehow they underestimated the preparation in this one.
-
-
CMake's UI / Qt has recently started having this idea that it should create its windows maximized horizontally. It's not useful, and I'm not amused.
*interlude*
tries to paste a screenshot for WTDWTF here.
WTDWTF says:
... very funny, but for once, I seem to agree.
*end interlude*75% of the original size. Black squares cover the configuration options & values. None of them are longer than indicated by the black square.
Edit: Additional annoyance. Even after resizing the window itself, the "Value" column stays wide for some reason. Whenever I try to edit a value, it scrolls the table such that only the "Value" column is visible.
-
@cvi Obviously, the column is of great value.