Home -> Mailing Lists -> Oracle-L -> Aw: Re: Comparison of long Strings - Bug?

Aw: Re: Comparison of long Strings - Bug?

From: Ingrid Voigt <giantpanda_at_gmx.net>
Date: Tue, 8 Aug 2017 21:07:08 +0200
Message-ID: <trinity-3bc15343-83aa-49a7-9625-959612f32e74-1502219227988_at_3capp-gmx-bs15> 







max_string_size=extended:   Crashes in both cases.



 



Oracle Client:  The queries were run directly on the database server.



So the same as the database.



 



select lengthb(hu), lengthc(hu):   Crashes for both.



 



One more detail: No crashes with NLS_COMP = BINARY.



 



 



I'll open a SR tomorrow morning.

 



 



Thanks everybody.



Ingrid



 



 





Gesendet: Dienstag, 08. August 2017 um 16:40 Uhr

Von: "Wilhelm Klotz" <willyk_at_kbi-gmbh.de>

An: oracle-l_at_freelists.org, giantpanda_at_gmx.net

Betreff: Re: Comparison of long Strings - Bug?







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@gmx.net>

An: oracle-l@freelists.org

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



 





-- http://www.freelists.org/webpage/oracle-l











--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 08 2017 - 21:07:08 CEST












Original text of this message