警惕:一条直接让数据库服务器挂机的查询SQL
Create table t_document(id integer);
select
rownumber() over(order by
id,id desc
) as rownumber_
from
t_document
order by id,id desc
写hql时，不小心对同一条件排序了两次！大家可以试试！！
幸好发现及时，否则上了生产后果不堪设想啊！
17同行回答
不好意思,好几个月没进论坛，感谢各位的关注，
我的数据库版本为db2exc_950_WIN_x86(1).zip，这个问题还在
SELECT
ROWNUMBER() OVER(ORDER BY ID,ID DESC) AS ROWNUMBER_
FROM DB2ADMIN.T_DOCUMENT
ORDER BY ID,ID DESC收起
我的数据库版本为db2exc_950_WIN_x86(1).zip，这个问题还在
SELECT
ROWNUMBER() OVER(ORDER BY ID,ID DESC) AS ROWNUMBER_
FROM DB2ADMIN.T_DOCUMENT
ORDER BY ID,ID DESC收起
浏览1094
没问题 (9.7):
db2 => create table t_document(id integer)
DB20000I The SQL command completed successfully.
db2 => select rownumber() over(order by id,id desc) as rownumber_ from t_document order by id,id desc
ROWNUMBER_
--------------------
0 record(s) selected.
db2 => insert into t_document values (1)
DB20000I The SQL command completed successfully.
db2 => insert into t_document values (2)
DB20000I The SQL command completed successfully.
db2 => select rownumber() over(order by id,id desc) as rownumber_ from t_document order by id,id desc
ROWNUMBER_
--------------------
1
2
2 record(s) selected.收起
db2 => create table t_document(id integer)
DB20000I The SQL command completed successfully.
db2 => select rownumber() over(order by id,id desc) as rownumber_ from t_document order by id,id desc
ROWNUMBER_
--------------------
0 record(s) selected.
db2 => insert into t_document values (1)
DB20000I The SQL command completed successfully.
db2 => insert into t_document values (2)
DB20000I The SQL command completed successfully.
db2 => select rownumber() over(order by id,id desc) as rownumber_ from t_document order by id,id desc
ROWNUMBER_
--------------------
1
2
2 record(s) selected.收起
浏览1112
谁能分析下原因，难道是DB2被整晕了！收起
浏览1103
DB2的优化器没有那么差劲滴。你dynexpln看看执行计划就知道。
具体为什么导致服务器挂机，最直接应该先看日志。收起
具体为什么导致服务器挂机，最直接应该先看日志。收起
浏览1092