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

>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.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)