Message-ID: <09536b3a-2ec9-64da-8630-caf7d50c758c@proventis.net>
Date: Sun, 6 Feb 2022 10:07:15 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.5.0
To: pgsql-jdbc@lists.postgresql.org
Content-Language: en-US
From: Thomas Markus <t.markus@proventis.net>
Subject: org.postgresql.util.PSQLException: ERROR: value out of range:
 underflow
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0
X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-MessageData-0: 
	=?utf-8?B?Q3lDK2huNHdHQzVpVkZicTlYWmd0OXprUmFEUmhkRi8yZUtDS0w2K2RNTUxj?=
 =?utf-8?B?OU44cWkxRUkvTGhXWExJZFh3U2lCUlVvU2FFZTFiWEZBd0tLaEhaTU12VXVY?=
 =?utf-8?B?L0w5aFBpNmd0WVd4L3RjRDVtU1ZCb0YraGlKdEI4THd1MDBENGZhcFFkcjJU?=
 =?utf-8?B?anZsYy9SWmZ6am03dUs2YjJrVlkrN3FoNyt2L0xLRmxRVmdUYW05Rk5SS1No?=
 =?utf-8?B?WjBONHk0MVE4d3dJN3ltMHJ2OHRkQSs1Ymd3bWpoamREeGM3RElhSWNDOGJj?=
 =?utf-8?B?bDZwcDdNUjZmdElIcTVocVJ4dGJxVEh6N3o1d0ZxYStaOURJUTdPNGN1d3VI?=
 =?utf-8?B?STdyYXVIOTV3eER6bnkzY2VwQkZiSkQ1a01xbWNwRzIvcEtRMS9JUjcvRzB4?=
 =?utf-8?B?OGF0L2xzdkp5NlZ1aXU5TTgra0JVME1YUDIxYzBaVHFCWTlXS2k4QTdNMkk1?=
 =?utf-8?B?ZGlDY3VjRXpKZ2poRjJUWCthK1ZjQjBORUdNcm5oN2V5b2FJSmtoRk5aYlZD?=
 =?utf-8?B?dlBaYVgzelZyWndWYVAyb3ZvSWFHMXY2RkhyS3ZYbmdkckhWbXhWZTNHSXBs?=
 =?utf-8?B?cllnMjBMQkhneVdZbUtxbmE4YnRwUzdYL0RpejlTT1Rzdm5VWUpxSGxTeDJt?=
 =?utf-8?B?cmRocU9vVHlEOGEwSzlNcmNvdTY3aThRUytUdmtkWXpIc2VSeXo5OFJ1cnB0?=
 =?utf-8?B?UHRadzNnRHYvbWFVTzYzQ2F3dzlIYzViWlh2VWxueFh0UFlJUlhTZDBuTGtu?=
 =?utf-8?B?dDAyamExWGVYRFR2TlJ6STc1djZXclNtbmZaeCtqNEpod2xEbVRMdFU5dncw?=
 =?utf-8?B?NTdNc25sRzFDWkxxZVlsYzdkUGlnOUc4UnJsa2RNdHp1ZTVRYVJIOTIwZXlG?=
 =?utf-8?B?ZDk5enFFRXUwSFhDeVUrV213OWx5WjE5OWg0NWdqRDJ4bHVackJUQytZRHpp?=
 =?utf-8?B?MXFaWG5tVkdVaWx4WU8vZ0Z5QkFQamdTYXQxcktGdC9PblpST2k3dHRaWWQy?=
 =?utf-8?B?VzRGb2RGV0VRRy9KUzhORHluY05vbUxGQmNPcCtsZ2FYWnkwUFZqQ1djSWZ6?=
 =?utf-8?B?VVNBWkpGQk5jdHNCeUQyZGR0K1dBSFp4Y0d0KyttZmhEOWxBV0JjZEg0OEJT?=
 =?utf-8?B?RVdIOU9SNlhBYnc1Wjk4WmFMV005QzdtYURkNDRKRmRnVmdhVUh5ZVYyUXJp?=
 =?utf-8?B?NUlQUGI3VzlzSUl2MHFlazB2a2NxQXNJYlBEREQ1R2g1NnNxcXZhbENHTmZR?=
 =?utf-8?B?MDJ2TTBaYkpkaHlrNE5mRmVlUy9VNUhEN3lhUnBCaDJGMytIdW13amZvNm9U?=
 =?utf-8?B?WlpiUlpzaU1nQ3lRTTJENVRtSnl4RndtalpnRDRGNjhEUk5oQ3J1RmErWnNJ?=
 =?utf-8?B?TjMyN2R1YVFvTWFtT0J1V1B3aWFZaHBEaFhacitNQjdvUzhjYkZvWWllWnIy?=
 =?utf-8?B?cWlGMXRLYjllb1JzTFNTZFFVYW9WRHROa1gyWUhReGVXSTM4Q2NONGpPUURo?=
 =?utf-8?B?aGZNUVc3dG92N1NKUE13dnR2WTcxNzZtQlkzbFFuekIvVW93SzJIOUFROG03?=
 =?utf-8?B?OW9yckkyNGVpTVk5QkZKbEpQclhtLzZxdVczNkNseUFWSE1oSDVweEpCeFVE?=
 =?utf-8?B?cGUyajF3MFBGWjlabThzTHkyV0ltZGljR251K1dsQXRsTlBJQk95cWRNOWsz?=
 =?utf-8?B?R0dWZlJQbFQvTFJmcGlQR1VTbzVZTXFEd1B0amZzbUFsbVk5dFZBdG9BWCtu?=
 =?utf-8?B?RGd6Qk91UG9ZKzJ5RURuSGp6eTU1aWVBdjZZMThDdWJSZW04NDJHcWk0Um9C?=
 =?utf-8?B?Ym5BaDVNTlZQV0ZwVm5TWFZoMlhJL2lPQVVCTzVRZXNMLzRNdDRJTGM3ZUF3?=
 =?utf-8?B?VFpYdVExNHZEK1FPenh3ZFR4TlZOdFJXVGNWRG1URHduNU0rTVlZVHR3UUU3?=
 =?utf-8?B?em9aaVczQ1Bobzk4bzJWWndHQ2RaZzJOZG1yU01mTzhQcURsKzFkNG9Jb1VY?=
 =?utf-8?B?OUxPcHJIVzA3Q3FCc3JnT0htZWl1OExtekN5ZW5ZUlVmSFNoMnNvcHJzSWtJ?=
 =?utf-8?B?cHVST2dPMFFnSEJrcEpLUWw5US9WY0xyQzl1Qkt3MkNwUGlNaXZVT1NwcURw?=
 =?utf-8?B?c1VaMGtJcFpIc3dOV0dZZGlkVjJhYXVoSG5aZDFNVXZQbDd3N3VhQmo0c1A3?=
 =?utf-8?B?dEorUFdVSUo2RXpUMllHbU9VTHUvcWpNTG55MERuY3pBWlFNV2NDSUNjejBn?=
 =?utf-8?Q?3CS/L7a9rM0dh449UsWnKtBekzlAgg24v9tajxSkO8=3D?=
X-OriginatorOrg: proventis.net
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 362cccc3-9135-4116-37b1-08d9e9501244
X-MS-Exchange-CrossTenant-AuthSource: AM9PR02MB6850.eurprd02.prod.outlook.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-OriginalArrivalTime: 06 Feb 2022 09:07:16.3845
 (UTC)
X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted
X-MS-Exchange-CrossTenant-Id: 0e59f2ee-7c21-4d61-980f-e7d935278c0f
X-MS-Exchange-CrossTenant-MailboxType: HOSTED
X-MS-Exchange-CrossTenant-UserPrincipalName: 
 JGZcYwqtRqm4eOj7x/+zmokPtykCvfwSt+oqlKWUx8AaNTQBGs8LxruSAst5mlGdLz6usagCAU9u+w5U+iv9og==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: VI1PR02MB3775
List-Id: <pgsql-jdbc.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-jdbc@lists.postgresql.org>
List-Owner: <mailto:pgsql-jdbc-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-jdbc>
Archived-At: 
 <https://www.postgresql.org/message-id/09536b3a-2ec9-64da-8630-caf7d50c758c%40proventis.net>
Precedence: bulk

Hello

a customer got the exception "org.postgresql.util.PSQLException: ERROR: 
value out of range: underflow" without any stacktrace etc.
System is Linux with PG 12.2

Once I got a similar error in Oracle so I checked double values for edge 
cases (see below) but without success. This message is also not part of 
pgjdbc.

Has anyone any idea where this message may originate from? The only used 
datatypes for numbers are bigint, integer and double precision.

Thanks
Thomas

Test:

try (Statement s = c.createStatement()) {
     s.executeUpdate("create table x (x double precision)");
}
try (PreparedStatement p = c.prepareStatement("insert into x (x) values 
(?)")) {

     p.setDouble(1, Double.MIN_VALUE);
     p.executeUpdate();

     p.setDouble(1, -Double.MIN_VALUE);
     p.executeUpdate();

     p.setDouble(1, Double.MIN_NORMAL);
     p.executeUpdate();

     p.setDouble(1, -Double.MIN_NORMAL);
     p.executeUpdate();

     p.setDouble(1, Double.MAX_VALUE);
     p.executeUpdate();

     p.setDouble(1, -Double.MAX_VALUE);
     p.executeUpdate();

     p.setDouble(1, Double.NEGATIVE_INFINITY);
     p.executeUpdate();

     p.setDouble(1, Double.POSITIVE_INFINITY);
     p.executeUpdate();

     p.setDouble(1, Double.NaN);
     p.executeUpdate();

}