Oracle有几个SQL WTF问题。

Oracle将空字符串处理为null。 在“<>”比较中处理空值。 创建表WTF(键数为主键，动物varchar2(10)); 插入WTF值(1，'dog'); Insert into WTF values (2， "); Insert into WTF values (3，'cat'); Select * from WTF where animal <> 'cat';

唯一返回的行是(1，'dog')行。

在fortran中(当然是77，可能在95中也是如此)，未声明的变量和以I到N开头的参数(“In”组)将是INTEGER，所有其他未声明的变量和参数将是REAL(源)。这与“在某些情况下可选的空白”相结合，导致了最著名的错误之一。

正如弗雷德·韦伯在1990年的《另类民间传说:计算机》一书中所说:

I worked at Nasa during the summer of 1963. The group I was working in was doing preliminary work on the Mission Control Center computer systems and programs. My office mate had the job of testing out an orbit computation program which had been used during the Mercury flights. Running some test data with known answers through it, he was getting answers that were close, but not accurate enough. So, he started looking for numerical problems in the algorithm, checking to make sure his tests data was really correct, etc. After a couple of weeks with no results, he came across a DO statement, in the form: DO 10 I=1.10 This statement was interpreted by the compiler (correctly) as: DO10I = 1.10 The programmer had clearly intended: DO 10 I = 1, 10 After changing the . to a , the program results were correct to the desired accuracy. Apparently, the program's answers had been "good enough" for the sub-orbital Mercury flights, so no one suspected a bug until they tried to get greater accuracy, in anticipation of later orbital and moon flights. As far as I know, this particular bug was never blamed for any actual failure of a space flight, but the other details here seem close enough that I'm sure this incident is the source of the DO story.

我认为这是一个很大的WTF，如果DO10I被作为DO10I，并且反过来，因为隐式声明被认为是类型REAL。这是个很棒的故事。

JCL条件返回执行。

//STEP02 EXEC PGM=PROG02,COND=(4,GT,STEP01) .

该特性允许您根据前面步骤的返回代码运行或不运行某个步骤。真是个不错的功能。

除了一些小功能，把逻辑颠倒过来。

首先，如果条件为真，则不运行步骤。

其次，4 GT,STEP01实际上意味着“如果STEP01的返回码大于4”

因此，整个过程意味着“如果来自STEP01的返回代码大于4，则不要运行此步骤”。这与“如果4大于来自STEP01的返回代码，则运行步骤”的简单解释几乎相同，但并不完全相同。

考虑到你唯一认真看待这些事情的时间是凌晨2点30分左右，电话另一端是一个疯狂的夜班接线员，这种双重模糊会导致严重的头痛。

在Java中:

int[] numbers() {
  return null;
}

可以写成:

int numbers() [] {
  return null;
}

这是我的两分钱。在c++中:

int* t = new int(15);
delete t;

Java中有标记的break和continue语句。

它们允许你通过一次突破突破多个控制块。