一个SQL语句能够使DB2服务停止

 在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

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值