Re: BUG #15091: to_number() returns incorrect value

>>>>> "Tom" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

Tom> Tested at
Tom> http://rextester.com/l/oracle_online_compiler

>> The problem is that this tester is defaulting to a German locale and
>> using . as a thousands separator and , as decimal point, as shown by
>> this query:
>> select * from nls_session_parameters
>> where parameter in ('NLS_TERRITORY','NLS_NUMERIC_CHARACTERS')

Tom> Oh, thanks ... I was wondering what locale it had chosen, but did
Tom> not know how to find out.

I had to ask around to find a way that worked both on rextester.com and
on sqlfiddle.com (which also supports Oracle 11, and is where I usually
test oracle query compatibility things). It was the fact that the two
sites behaved differently for this query that got me looking at
parameter settings to begin with; sqlfiddle defaults to US locale.

--
Andrew (irc:RhodiumToad)