中国开发网: 论坛: 程序员情感CBD: 贴子 161849
疯子张
普通的SQL会把服务器搞宕机么?
informix下,执行这两个查询,数据库立即宕掉。
SELECT acceptbill.id as id,acceptbill.bill_id as
bill_id,acceptbill.billno1 as billno1,acceptbill.billno2 as
billno2,acceptbill.billno3 as billno3,acceptbill.billno4 as
billno4,acceptbill.billno as billno,acceptbill.bill_amt as
bill_amt,acceptbill.sign_dt as sign_dt,acceptbill.bill_due_dt as
bill_due_dt,acceptbill.maker as maker,acceptbill.maker_code as
maker_code,acceptbill.maker_id as maker_id,acceptbill.maker_bank as
maker_bank,acceptbill.payee as payee,acceptbill.payee_id as
payee_id,acceptbill.payee_code as payee_code,acceptbill.unloos_flag as
unloos_flag,acceptbill.accepter_id as accepter_id,acceptbill.accepter as
accepter,acceptbill.fee_rate as fee_rate,acceptbill.fee_income as
fee_income,acceptbill.accept_id as accept_id,acceptbill.bill_sts as
bill_sts,acceptbill.cust_no as cust_no,acceptbill.loan_id as
loan_id,acceptbill.lose_sts as lose_sts,unloose.unloos_dt as
unloos_dt,unloose.coll_amt as coll_amt,acceptbill2.impr_amount as
impr_amount FROM acceptbill left join unloose on
acceptbill.bill_id=unloose.bill_id left join acceptbill2 on
acceptbill.bill_id=acceptbill2.bill_id WHERE (((acceptbill.branch_id LIKE
?) AND (acceptbill.sign_dt>=?) AND (acceptbill.sign_dt<=?)))


select count(*) as totalsize from acceptbill left join unloose on
acceptbill.bill_id=unloose.bill_id left join acceptbill2 on
acceptbill.bill_id=acceptbill2.bill_id where (((acceptbill.branch_id like
?) and (acceptbill.sign_dt>=?) and (acceptbill.sign_dt<=?)))
几年前,技术抛弃了我;现在,我抛弃了技术。


相关信息:


欢迎光临本社区,您还没有登录,不能发贴子。请在 这里登录