ORACLE:
SELECT *
FROM TABLE1 B
LEFT JOIN TABLE2 P ON P.CODE_VALUE = B.ITEM_TYPE
AND P.CODE_SORT_ID = '144'
WHERE 1 = 1
AND B.ORG_NO IN
(SELECT T.ORG_NO FROM TABLE3 T WHERE T.ORG_NO LIKE '324010001%');
执行上面语句报错
FROM TABLE1 B
LEFT JOIN TABLE2 P ON P.CODE_VALUE = B.ITEM_TYPE
AND P.CODE_SORT_ID = '144'
WHERE 1 = 1
AND B.ORG_NO IN
(SELECT T.ORG_NO FROM TABLE3 T WHERE T.ORG_NO LIKE '324010001%');
执行上面语句报错
下面是不报错语句
1、SELECT *
FROM TABLE1 B
LEFT JOIN TABLE2 P ON P.CODE_VALUE = B.ITEM_TYPE
AND P.CODE_SORT_ID = '144'
WHERE 1 = 1
AND B.ORG_NO IN
(SELECT T.ORG_NO FROM TABLE3 T WHERE T.ORG_NO LIKE '%324010001%');
2、SELECT *
FROM TABLE1 B
LEFT JOIN TABLE2 P ON P.CODE_VALUE = B.ITEM_TYPE
AND P.CODE_SORT_ID = '144'
WHERE 1 = 1
AND B.ORG_NO IN
(SELECT T.ORG_NO FROM TABLE3T WHERE T.ORG_NO LIKE '32401%');
两条都不报错
第一句比第二局少了一个%
第三局少了两个0。。
错误日志:
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x0, PC: [0x1fff2a4, kkogbro()+192]
*** 2015-01-07 13:48:37.381
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kkogbro()+192] [SIGSEGV] [Address not mapped to object] [0x000000000] [] [
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
Cannot find symbol
Cannot find symbol
Cannot find symbol
ksedst()+31 call ksedst1() 000000001 ? 000000001 ?
000000000 ? 000000000 ?
000000000 ? 000000001 ?
ksedmp()+610 call ksedst() 000000001 ? 000000001 ?
000000000 ? 000000000 ?
000000000 ? 000000001 ?
ssexhd()+630 call ksedmp() 000000003 ? 000000001 ?
000000000 ? 000000000 ?
000000000 ? 000000001 ?
<0x383380f500> call ssexhd() 00000000B ? 7F70E4B6CBF0 ?
7F70E4B6CAC0 ? 000000000 ?
000000000 ? 000000001 ?
----------------------------------------------------------------------------------------------------------------------------
重启数据库 ,不行;;
删除表重新建,不行。
查看数据库版本 10.0.2.0 版本太低 ,版本自身Bug 13631324 。
升级数据库:
http://blog.csdn.net/aaaaaaaa2000/article/details/7577474