Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lK6Ak-0003mW-2o for pgsql-bugs@arkaria.postgresql.org; Wed, 10 Mar 2021 21:15:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lK6Ai-0004Cj-QL for pgsql-bugs@arkaria.postgresql.org; Wed, 10 Mar 2021 21:15:12 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lK5em-0007Tp-TJ for pgsql-bugs@lists.postgresql.org; Wed, 10 Mar 2021 20:42:13 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lK5eg-0000XZ-Fb for pgsql-bugs@lists.postgresql.org; Wed, 10 Mar 2021 20:42:12 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=uC444uxQG7l9oYz5KkiN5I1iwB6U7NsKERhlwAF4q98=; b=k1qKW5EH0/Uy6MSKLFZR+QaBVh Jsqr4PHeSJhKHX6mWImIc0xu/1KH3TXe/2rOYiWIJNh+O4sFrKN1c2+APtGtHPBEDjEl807aN+Gy9 s68CLdOxkl2wQNfs6M2cIX/vxiRc6+3TOn+NsUb+8VI4luqKppj1fvi0eJPrF7/MdsAv1VitQ0i2n adiWTSwHkswVbVeaJo1wrNcSvuz3HNJNHeAYEbAResJX+uQZB8mojiy3s19tlVrLooqNyGgYFoZyQ 86/UurxvW0olfWCEnhzcua4tSKh/pIQ2v4mDI1MzkuCNXs8Eog/HqIR+Qj1mUb/lMmDzcaizXCYHn bgEUGBLg==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lK5ee-0007Fb-V5 for pgsql-bugs@lists.postgresql.org; Wed, 10 Mar 2021 20:42:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lK5ec-00038e-4f for pgsql-bugs@lists.postgresql.org; Wed, 10 Mar 2021 20:42:02 +0000 Content-Type: multipart/mixed; boundary="===============2359335122562855322==" MIME-Version: 1.0 Subject: BUG #16919: Unexpected precision loss in NUMERIC type during text cast, math operations To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: levi@leviaul.com Reply-To: levi@leviaul.com, pgsql-bugs@lists.postgresql.org Date: Wed, 10 Mar 2021 20:41:32 +0000 Message-ID: <16919-64fff49d97341054@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2359335122562855322== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjkxOQpMb2dnZWQgYnk6ICAgICAgICAgIExldmkgQXVsCkVtYWlsIGFk ZHJlc3M6ICAgICAgbGV2aUBsZXZpYXVsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDEzLjIKT3Bl cmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjAuMDQuMiAoeDg2XzY0KSwgTGludXgga2VybmVsIDUu NC4wCkRlc2NyaXB0aW9uOiAgICAgICAgCgpTaW1wbGUgb3BlcmF0aW9ucyBvbiBOVU1FUklDLCBz dXBwb3NlZGx5IGFuIGFyYml0cmFyeS1wcmVjaXNpb24gdHlwZSzCoGFyZQpoYXZpbmcgdW5leHBl Y3RlZCByZXN1bHRzIGZvciBtZToNCg0KU0VMRUNUICAgICAnMTIzNDU2Nzg5MDEyMzQ1Njc4OTAx MjM0NTY3ODkwMTIzNDU2Nzg5MDEyMzQ1Njc4OTAnOjpudW1lcmljOw0KLS0gZXhwZWN0ZWQgMTIz NDU2Nzg5MDEyMzQ1Njc4OTAxMjM0NTY3ODkwMTIzNDU2Nzg5MDEyMzQ1Njc4OTANCi0tICAgICAg Z290IDEyMzQ1Njc4OTAxMjM0NTY3ODkwMTIzNDU2Nzg5MDEyMzQ1Njc4OTAwMDAwMDAwMDAwDQoN ClNFTEVDVCAoKCcxMjM0NTY3ODkwMTIzNDU2Nzg5MDEyMzQ1Njc4OTAnOjpudW1lcmljKSAqCign MTAwMDAwMDAwMDAwMDAwMDAwMDAwJzo6bnVtZXJpYykpICsgKCcxMjM0NTY3ODkwMTIzNDU2Nzg5 MCc6Om51bWVyaWMpOw0KLS0gZXhwZWN0ZWQgMTIzNDU2Nzg5MDEyMzQ1Njc4OTAxMjM0NTY3ODkw MTIzNDU2Nzg5MDEyMzQ1Njc4OTANCi0tICAgICAgZ290IDEyMzQ1Njc4OTAxMjM0NTY3ODkwMTIz NDU2Nzg5MDEyMzQ1Njc4OTAwMDAwMDAwMDAwDQoNCkNvcnJlY3QgcmVzdWx0cyBjYW4gYmUgYXR0 YWluZWQgYnkgcmVwbGFjaW5nIE5VTUVSSUMgaW4gdGhlIGFib3ZlIHdpdGgKcGdtcCdzIG1weiB0 eXBlLg0KDQpBbHNvLCB0aGlzIHByZWNpc2lvbiBsb3NzIGRvZXNuJ3Qgb2NjdXIgd2l0aCB0aGUg aW50ZXJuYWwgX251bWVyaWMKYXJyYXktbWVtYmVyIHR5cGU6DQoNClNFTEVDVCAgICAKJ3sxMjM0 NTY3ODkwMTIzNDU2Nzg5MDEyMzQ1Njc4OTAxMjM0NTY3ODkwMTIzNDU2Nzg5MH0nOjpudW1lcmlj W107DQotLSBleHBlY3RlZCB7MTIzNDU2Nzg5MDEyMzQ1Njc4OTAxMjM0NTY3ODkwMTIzNDU2Nzg5 MDEyMzQ1Njc4OTB9DQotLSAgICAgIGdvdCB7MTIzNDU2Nzg5MDEyMzQ1Njc4OTAxMjM0NTY3ODkw MTIzNDU2Nzg5MDEyMzQ1Njc4OTB9DQoNCkkndmUgdmVyaWZpZWQgd2l0aCBkZWJ1Z19wcmludF9w YXJzZSB0aGF0IG5vdGhpbmcgc3RyYW5nZSBpcyBnb2luZyBvbiB3aXRoCmltcGxpY2l0IGNhc3Rz IG92ZXJyaWRpbmcgdGhlIGRlZmF1bHRzOyB0aGUgbmF0aXZlIGZ1bmN0aW9uIG51bWVyaWNfaW4g aXMKYmVpbmcgY2FsbGVkIGhlcmUuIChBbmQgZXZlbiBpZiBpdCB3ZXJlbid0LCBoYXZpbmcgYW4g b3ZlcnJpZGRlbiAodGV4dCBUTwpudW1lcmljKSBjYXN0IHdvdWxkbid0IGFsc28gYmUgYWZmZWN0 aW5nIHRoZSBtYXRoLW9wIHJlc3VsdCBhYm92ZSwgYXMgaXQKb3BlcmF0ZXMgdXBvbiBhcHBhcmVu dGx5LWxvc3NsZXNzIGlucHV0cyB3aGlsZSBzdGlsbCBhY2hpZXZpbmcgYSBsb3NzeQpyZXN1bHQu KQoK --===============2359335122562855322==--