The Daily WTF: Curious Perversions in Information Technology

GalacticCowboy · 2006-04-12 Reply Admin

Anonymous:
Anonymous:

I hate Oracle and everything it stands for. If you like Oracle, then I'm sorry, but you have an illness. If you are forced to use Oracle because your management doesn't know better, then I'm also sorry.

tdog

I am curious what you feel is a valid alternative ;) Though I tend to agree, I might guess that your DB of choice might also be a steaming pile of crap (unless you are talking about Postgres, then, never mind.). But, if you are talking about SQL server, gadzooks! SQL server is teh WORST db there is (yes Alex, worse than MySQL).

This comment applies to both of you...

Based on what? What evidence or proof do you have, and based upon what features, arguments, etc? All RDBMS' have their pros and cons. Your argument is similar to saying that any Pontiac is the spawn of the devil, based upon the fact that some Fieros had a minor problem of catching fire...

Frankly, if I've got a mission-critical project and I need five 9's on reliability, Oracle is probably about the only thing I'd consider. Conversely, if I'm writing a basic package, Oracle is massive overkill.

RyuO · 2006-04-12 Reply Admin

GalacticCowboy:
Anonymous:
Anonymous:

I hate Oracle and everything it stands for. If you like Oracle, then I'm sorry, but you have an illness. If you are forced to use Oracle because your management doesn't know better, then I'm also sorry.

tdog

I am curious what you feel is a valid alternative ;) Though I tend to agree, I might guess that your DB of choice might also be a steaming pile of crap (unless you are talking about Postgres, then, never mind.). But, if you are talking about SQL server, gadzooks! SQL server is teh WORST db there is (yes Alex, worse than MySQL).

This comment applies to both of you...

Based on what? What evidence or proof do you have, and based upon what features, arguments, etc? All RDBMS' have their pros and cons. Your argument is similar to saying that any Pontiac is the spawn of the devil, based upon the fact that some Fieros had a minor problem of catching fire...

Frankly, if I've got a mission-critical project and I need five 9's on reliability, Oracle is probably about the only thing I'd consider. Conversely, if I'm writing a basic package, Oracle is massive overkill.

GalacticCowboy nailed it. Any software that has stood the test of time has its place, even Weblogic [^o)] Oracle is unchallenged in its main niche, so they must be doing something right.

Could the first guy have been talking about Oracle Corporation, not Oracle the DBMS? I don't much like Java's wacky inheritance rules, but I don't say "I hate Sun and everything it stands for"

2006-04-12 Reply Admin

Enric Naval and Makonk -

It looks like SecretGeek saw your errors and has fixed both W2SCG and W3SCG. In fact the example text in W3SCG inludes both "fightin'" and "cussin'". Yeehaw, good work all!!

FB

2006-04-13 Reply Admin

mrsticks1982:

even their light footprint is still 2gb!!! "Oracle is the Devil"

2gb=150mb ah well.

Enric Naval · 2006-04-13 Reply Admin

Anonymous:
Enric Naval and Makonk -

It looks like SecretGeek saw your errors and has fixed both W2SCG and W3SCG. In fact the example text in W3SCG inludes both "fightin'" and "cussin'". Yeehaw, good work all!!

FB

Well... I used "cussin´" because it was on the example text. A very nice WTF: the code chokes on some of the example tokens the programmer himself is providing!

And I dind't warn the programmer myself because a)the add comment link is broken b)there are several posts for the second generator, but none for the third one. Way to go, SecretGeek! Solve the problems on your website! I have finally found his email address in the about link, so I'll email him about this.

secretGeek · 2006-04-14 Reply Admin

thanks Enric, Makonk, FB et al.

I've seen the error but haven't fixed it yet. the 'world's third simplest code generator' isn't actually released yet, the url has just been leaked a few times

When it is released this problem will be fixed, and i'll remove the google ads as well.

Man do i feel dumb, having to log in to daily-wtf to explain my bugs....:$

cheers lb

http://secretGeek.net

Carlovski · 2006-04-18 Reply Admin

Oracle database - great.

Oracle development tools and utilities absolutely terrible - buggy, unintuitive and do strange things like this.

2006-05-10 Reply Admin

Here is the actual template used.....

begin
if '#1#' = 'NUMBER' and length('#1#')>0 and length('#2#')>0 then
execute immediate 'alter table "#OBJECT_OWNER#"."#OBJECT_NAME#" add(#0# #1#(#2#, #3#))';
elsif '#1#' = 'INTEGER' or
('#1#' = 'NUMBER' and length('#1#')>0 and length('#2#')=0) or
'#1#' = 'VARCHAR2' then
execute immediate 'alter table "#OBJECT_OWNER#"."#OBJECT_NAME#" add(#0# #1#(#2#))';
else
execute immediate 'alter table "#OBJECT_OWNER#"."#OBJECT_NAME#" add(#0# #1#)';
end if;
end;

2006-06-20 Reply Admin

And, as has been pointed out, this is badly broken. Obviously every instance of '#1#' = 'NUMBER' and length('#1#')>0 is ridiculous, and as several people have mentioned every clause containing and length('#2#')=0 is broken too.

What I don't think has been much mentioned is that the length checks appear to be on the wrong inputs: change every occurrence of length('#2#')to length('#3#'), and change length('#1#')to length('#2#'), and it makes much more sense: if precision and scale are both specified and the datatype is NUMBER, issue a statement with precision and scale; if the type is INTEGER or VARCHAR2 or NUMBER with precision but no scale, issue a statement with precision specified; otherwise issue a statement without precision or scale.

Now that would make sense, and then it would only be the length(x)=0 stuff that would be broken. (Though I admit it's rather sad to have to say about a very short piece of code that if only a major problem had been fixed, it would only be broken in one way.) But for a template to be checking obviously the wrong inputs in released code is pretty WTF-worthy.

2006-07-03 Reply Admin

Anonymous:

Anyone care to explain the difference between the following 3 items?
add(FIREDATE DATE(, ))
add(FIREDATE DATE())

add(FIREDATE DATE)

Is there a difference?

Therein likes the WTF...

2006-07-05 Reply Admin

Bugfree. Yeah right.

I remember well a (quite nasty) view we made which gave unpredictable results. We contacted support and (and I have to say: that is real competence) within one or two days it was patched.

There is a certaintity of 100% that Oracle is NOT bugfree (I think they do a good job though)

I don't know about the security vulnerabilities - but in 99% of the cases possible vulnerabilities are caused by incompetent / clumpsy dba and operators.

2009-06-15 Reply Admin

Well, at least it wont generate a type such as "Orable"

2009-08-20 Reply Admin

I tried the same on a MySQL database with phpMyAdmin and it came up with this code:

ALTER TABLE `emp` ADD `firedate` DATE NULL

Captcha: sagaciter (wouldn't that be a fun job?)

2023-12-08

Comment held for moderation.

2023-12-08 Reply Admin

http://envico.co.kr/bbs/board.php?bo_table=s4_3&wr_id=43215 Very good article! We are linking to this particularly great content on our site. Keep up the great writing. http://wood-max.co.kr/bbs/board.php?bo_table=free&wr_id=90680 http://www.summerband.co.kr/bbs/board.php?bo_table=qa&wr_id=75109

2024-01-14

Comment held for moderation.

2024-01-14 Reply Admin

This Week's Most Remarkable Stories About Accident Injury Claim Compensation best auto accident attorney (http://shypo.gsdt.kr/)

2024-05-08 Reply Admin

10 Healthy Pornstar UK Kayleigh Wanless Habits Top Pornstars

2024-05-25 Reply Admin

The Reasons Porn Star Kayleigh Wanless Has Become The Obsession Of Everyone In 2023 photo

Orable Generated Code

Leave a comment on “Orable Generated Code”