You are on max_string_size=extended? What Oracle-Client?
Can you do a
select lengthb(hu), lengthc(hu) from (select 'ääää....äää' as hu from dual)
where hu likec '%a%');
Regards
Willy
-----Original-Nachricht-----
Von: "Ingrid Voigt" <giantpanda@xxxxxxx>
An: oracle-l@xxxxxxxxxxxxx
Datum: 08/08/17 15:56
Betreff: Comparison of long Strings - Bug?
Hi everybody,
the following produces reproducible crashes of Oracle instances on a customer's
and our systems (test and dev, no production involved so far):
OS: Windows 2012 R2
Oracle: 11.2, 12.1 and 12.2
NLS_CHARACTER_SET: AL32UTF8
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_LANG: GERMAN_GERMANY.WE8MSWIN1252 (our system)
AMERICAN_AMERICA.AL32UTF8 (customer system)
NLS_COMP: LINGUISTIC
NLS_SORT: GERMAN (AMERICAN)
select hu from (select 'ääää....äää' as hu from dual) where hu likec '%a%');
with 334 or more 'ä'
or
select hu from (select 'zzzz....zzz' as hu from dual) where hu likec '%s%');
with 1001 or more 'z'
This causes the instance to go down and the Windows service to crash.
Nothing in alertlog, no trace files, but the Windows event log has
Pfad der fehlerhaften Anwendung:
c:\oracle\product\12.1.0\dbhome_1\bin\ORACLE.EXE
Pfad des fehlerhaften Moduls:
c:\oracle\product\12.1.0\dbhome_1\bin\orasnls12.dll
(or orasnls11.dll for Oracle 11).
No crashes if the comparison character is contained in the string. No crashes
for
like, like2, like4. No changes with max_string_size=extended.
No crashes for NLS_CHARACTERSET=WE8MSWIN1252.
Has anybody seen something like this before or is this a Go-Open-a-SR-Bug?
Thanks for your assistence
Ingrid
-- //www.freelists.org/webpage/oracle-l
