在DB2 B8.2上发现一个现象,一个sql语句能把DB2服务db2syscs.exe停掉。此sql语句是有问题,应该报告sql语句错误。而不应该把DB2服务停掉。此sql语句如下:
select
rownumber() over() as rownumber_,
customer1_.id as col_0_0_,
customer1_.user_no as col_1_0_,
customer1_.user_name as col_2_0_,
customer1_.user_short_name as col_3_0_,
customer1_.identify_type as col_4_0_,
customer1_.identify_no as col_5_0_,
customer1_.operator as col_6_0_,
customer1_.registe_date as col_7_0_,
accountbo0_.account_no as col_8_0_,
accountbo0_.user_type as col_9_0_,
accountbo0_.account_type as col_10_0_,
accountbo0_.deposit_type as col_11_0_,
accountbo0_.main_card_no as col_12_0_,
accountbo0_.balance as col_13_0_,
accountbo0_.preassign_balance as col_14_0_,
accountbo0_.SERVICE_FEE_BALANCE as col_15_0_,
accountbo0_.credit_money as col_16_0_,
accountbo0_.low_money as col_17_0_,
accountbo0_.cash_limit as col_18_0_,
accountbo0_.owne_type as col_19_0_,
accountbo0_.account_status as col_20_0_,
accountbo0_.registe_date as col_21_0_,
accountbo0_.modify_date as col_22_0_,
accountbo0_.operator as col_23_0_,
accountbo0_.check_flag as col_24_0_,
accountbo0_.issue_status as col_25_0_,
accountbo0_.agent_no as col_26_0_,
identifyty2_.identify_type_no as identify1_4_0_,
operator3_.operator_no as operator1_11_1_,
operator4_.operator_no as operator1_11_2_,
identifyty2_.version as version4_0_,
identifyty2_.identify_type_name as identify3_4_0_,
identifyty2_.cancel_symbol as cancel4_4_0_,
operator3_.version as version11_1_,
operator3_.operator_name as operator3_11_1_,
operator3_.operator_password as operator4_11_1_,
operator3_.issuer_agent_no as issuer5_11_1_,
operator3_.cancel_symbol as cancel6_11_1_,
operator3_.remark as remark11_1_,
operator4_.version as version11_2_,
operator4_.operator_name as operator3_11_2_,
operator4_.operator_password as operator4_11_2_,
operator4_.issuer_agent_no as issuer5_11_2_,
operator4_.cancel_symbol as cancel6_11_2_,
operator4_.remark as remark11_2_
from
issue.a_account accountbo0_
inner join
issue.s_operator operator4_
on accountbo0_.operator=operator4_.operator_no,
issue.u_customers customer1_
inner join
issue.s_identify identifyty2_
on customer1_.identify_type=identifyty2_.identify_type_no
inner join
issue.s_operator operator3_
on customer1_.operator=operator3_.operator_no
where
accountbo0_.user_no=customer1_.user_no
and (
accountbo0_.account_no like '%1'
)
and accountbo0_.account_type=22