https://bugs.documentfoundation.org/show_bug.cgi?id=147408
Bug ID: 147408
Summary: EDIT Integer out of range overflows without message
Product: LibreOffice
Version: 7.3.0.3 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
When inserting an integer greater than the allowed range in a table, an
overflow occurs and the number is modified without displaying any message to
the user. That is, if in a SMALLINT we try to enter a positive number greater
than 32767, for example 33000, it becomes -32536 and does not warn the user.
However, if you try to do the insertion directly, for example with the
statement INSERT INTO "NUMS" (NUM) VALUES (33000), the database engine raises
an exception and shows a message to the user
Steps to Reproduce:
1. Create a table with a SMALLINT field or use the attached table
2. Open the table to enter data
3. Enter in the SMALLINT field a value out of range, e.g. 33000.
4. When you save the changes, the number becomes a different one, in case of
entering 33000 it becomes -32536.
To check that it is a problem of how Base handles the data, and not of the
underlying engine:
5. In the main menu select Tools > SQL
6. Execute the INSERT INTO "NUMS" (NUM) VALUES (33000) statement, or a similar
one adjusted to your field and table names.
7. You will receive a message that the data cannot be inserted.
Actual Results:
-32536 (a different number from the one inserted)
Expected Results:
A message warning about the invalidity of the data.
Reproducible: Always
User Profile Reset: No
Additional Info:
Tested wit Firebird embedded, HSQLDB embedded, Firebird external file, and
MariaDB server
Version: 7.3.0.3 (x64) / LibreOffice Community
Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL
--
You are receiving this mail because:
You are the assignee for the bug.
