Aw: Comparison of long Strings - Bug?
From: <rogel_at_web.de>
Date: Tue, 8 Aug 2017 18:32:01 +0200
Message-ID: <trinity-d45e666c-a16a-4e9d-a568-ac4e3c8fb2fc-1502209921825_at_3capp-webde-bs45>
-- http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 08 2017 - 18:32:01 CEST
Date: Tue, 8 Aug 2017 18:32:01 +0200
Message-ID: <trinity-d45e666c-a16a-4e9d-a568-ac4e3c8fb2fc-1502209921825_at_3capp-webde-bs45>
Hi Ingrid,
definitely a "Go-Open-a-SR-Bug".
I really enjoy it.
Regards,
Matthias
Gesendet: Dienstag, 08. August 2017 um 15:56 Uhr
Von: "Ingrid Voigt" <giantpanda_at_gmx.net>
An: oracle-l_at_freelists.org
Betreff: Comparison of long Strings - Bug?
Von: "Ingrid Voigt" <giantpanda_at_gmx.net>
An: oracle-l_at_freelists.org
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