SQL编译的奇怪现象

db2level:db2v8.1 fixpack4

查询语句:

SELECT CASE num WHEN 0 THEN 0 ELSE money / num END
  FROM TABLE(
                            VALUES (10, 0)
                          ) AS t(money, num)
@

执行时,报错:“尝试用0做除数”。

稍微修改下,如下

SELECT CASE num WHEN 0 THEN 0 ELSE money / num END
  FROM TABLE(
                            VALUES (10, 0),
                                            (10, 0),
                                            (10, 0)
                          ) AS t(money, num)
@

执行成功!

请使用浏览器的分享功能分享到微信等