maybe it's a bug of Oracle?
用id做条件,却得到了另外一个值:
select id from table where id=1;
得到的结果却是2,呵呵
以前还有次类似情况:
同事发现的问题,很奇怪。
如下sql语句,select rowd from table where pk=v1;
AAASwBAA9AAAY9tAA/
AAASwBAA9AAAY9tAA/
AAASwBAA9AAAY9tABA
AAASwBAA9AAAY9tABA
AAASwBAA9AAAY9tABB
AAASwBAA9AAAY9tABC
AAASwBAA9AAAY9tABF
AAASwBAA9AAAY9tABG
AAASwBAA9AAAY9tABH
AAASwBAA9AAAY9tABI
AAASwBAA9AAAY9tABJ
还是同一张表,还一个查询select rowid from table where unid=v2
AAASwBAA9AAAY9tAA/
AAASwBAA9AAAY9tABA
AAASwBAA9AAAY9tABB
AAASwBAA9AAAY9tABC
AAASwBAA9AAAY9tABD
AAASwBAA9AAAY9tABE
AAASwBAA9AAAY9tABF
AAASwBAA9AAAY9tABG
AAASwBAA9AAAY9tABH
AAASwBAA9AAAY9tABI
AAASwBAA9AAAY9tABJ
比较一下,很吃惊吧。
查询的结果确实应该是11条记录。但第一个查询结果居然得到了两组相同的rowid
环境是oracle 9i,在HP平台
不知大家是否遇到过类似问题?欢迎大家讨论讨论原因看!