Bug 130540 - FIREBIRD JDBC: Tableeditor will show all Integer-Types as Currency Format
Summary: FIREBIRD JDBC: Tableeditor will show all Integer-Types as Currency Format
Status: RESOLVED NOTOURBUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Connectivity
  Show dependency tree / graph
 
Reported: 2020-02-09 14:25 UTC by Robert Großkopf
Modified: 2021-07-13 18:15 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Screenshot shows currenbcy-format for integer as default-format (25.25 KB, image/png)
2020-02-09 14:25 UTC, Robert Großkopf 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2020-02-09 14:25:02 UTC 
Created attachment 157756 [details]
Screenshot shows currenbcy-format for integer as default-format

Connect to Firebird-Server through JDBC.
Try to create a Table.
Set one field as Integer (or BigInt, SmallInt ...).
All this fields will be shown as default with currency-format when inserting new values. 

Have a look at the attached screenshot. Shows this currency-format with 2 decimal places, which is totally wrong for a type, which couldn't save decimal-places at all.

Could be the bug isn't special JDBC. But with ODBC-for example, creating of tables leads to a crash here ...

All tested with
Version: 6.4.0.3
Build ID: b0a288ab3d2d4774cb44b62f04d5d28733ac6df8
CPU threads: 6; OS: Linux 4.12; UI render: default; VCL: kf5; 
Locale: de-DE (de_DE.UTF-8); UI-Language: en-US
Calc: threaded
Comment 1 Robert Großkopf 2021-07-13 18:14:51 UTC 
Had the same behavior in ODBC with MariaDB. Then changed the ODBC-driver and it has been gone. So I think is not our bug and I will close this one.