[Libreoffice-bugs] [Bug 67179] EDITING: JDBC - Firebird: Integer-fields formatted with wrong field properties
https://bugs.freedesktop.org/show_bug.cgi?id=67179 Lionel Elie Mamane lio...@mamane.lu changed: What|Removed |Added See Also||https://bugs.freedesktop.or ||g/show_bug.cgi?id=71414 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 67179] EDITING: JDBC - Firebird: Integer-fields formatted with wrong field properties
https://bugs.freedesktop.org/show_bug.cgi?id=67179 Alex Thurgood ipla...@yahoo.co.uk changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTOURBUG --- Comment #9 from Alex Thurgood ipla...@yahoo.co.uk --- Setting this as NOTOURBUG in view of Mark's helpful comments. I have opened bug 71256 for the currency formatting issue. Alex -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 67179] EDITING: JDBC - Firebird: Integer-fields formatted with wrong field properties
https://bugs.freedesktop.org/show_bug.cgi?id=67179 Alex Thurgood ipla...@yahoo.co.uk changed: What|Removed |Added See Also||https://bugs.freedesktop.or ||g/show_bug.cgi?id=71256 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 67179] EDITING: JDBC - Firebird: Integer-fields formatted with wrong field properties
https://bugs.freedesktop.org/show_bug.cgi?id=67179 Alex Thurgood ipla...@yahoo.co.uk changed: What|Removed |Added Status|RESOLVED|CLOSED -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 67179] EDITING: JDBC - Firebird: Integer-fields formatted with wrong field properties
https://bugs.freedesktop.org/show_bug.cgi?id=67179 --- Comment #10 from Lionel Elie Mamane lio...@mamane.lu --- I don't quite agree with the NOTOURBUG assessment. Essentially, what Mark is saying is that LibreOffice blindly assumes NUM_PREC_RADIX == 10, but we should check its value and react accordingly. Some of the treatment of NUM_PREC_RADIX was wrongly removed in a series of make code warning-free commits back in ... 2006. I reinstated it, but that was just storing the value in LibreOffice's internal datastructures, there is still no use of it made... EasyHack maybe? -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 67179] EDITING: JDBC - Firebird: Integer-fields formatted with wrong field properties
https://bugs.freedesktop.org/show_bug.cgi?id=67179 Alex Thurgood ipla...@yahoo.co.uk changed: What|Removed |Added CC||ipla...@yahoo.co.uk --- Comment #7 from Alex Thurgood ipla...@yahoo.co.uk --- Note that the formatting bug, i.e. where integer is set to currency format described by Robert also appears in the native embedded firebird driver, at least on Mac OSX in my latest master build. Alex -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 67179] EDITING: JDBC - Firebird: Integer-fields formatted with wrong field properties
https://bugs.freedesktop.org/show_bug.cgi?id=67179 --- Comment #8 from Andrzej J.R. Hunt andr...@ahunt.org --- (In reply to comment #7) Note that the formatting bug, i.e. where integer is set to currency format described by Robert also appears in the native embedded firebird driver, at least on Mac OSX in my latest master build. Alex I too noticed that for some reason the native driver likes to use currency a lot. That is in fact very weird, given that isCurrency in ResultSetMetaData is currently hard-coded to return false (not yet implemented), so this shouldn't ever be a currency. I suspect there is some underlying weirdness within Base itself which I'll try and investigate. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 67179] EDITING: JDBC - Firebird: Integer-fields formatted with wrong field properties
https://bugs.freedesktop.org/show_bug.cgi?id=67179 --- Comment #4 from Popa Adrian Marius map...@gmail.com --- I have asked on Firebird Java mailing list about this issue and here is the thread http://tech.groups.yahoo.com/group/Firebird-Java/message/10968 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 67179] EDITING: JDBC - Firebird: Integer-fields formatted with wrong field properties
https://bugs.freedesktop.org/show_bug.cgi?id=67179 --- Comment #5 from Mark Rotteveel m...@lawinegevaar.nl --- I am the developer of Jaybird (the JDBC driver for Firebird). The actual bugs is in the creation stage where the length is displayed as 32 (or 64 for BIGINT). The 'problem' is that Jaybird 2.2.3 (and earlier) in DatabaseMetaData.getTypeInfo() returns the binary precision (ie 32 base 2) of the datatype, while the getColumns() method declares it in decimal (ie 10 base 10) precision. See section 4.4.2 of SQL:2011 Foundation: An exact numeric type has a precision P and a scale S. P is a positive integer that determines the number of significant digits in a particular radix R, where R is either 2 or 10. The value of 32 comes from getTypeInfo()[1] (column PRECISION, combined with column NUM_PREC_RADIX). Jaybird 2.2.3 returns 32 base 2 for integer (64 base 2 for BIGINT and 16 base 2 for SMALLINT. The value of 10 shown after creation comes from DatabaseMetaData.getColumns()[1] (column COLUMN_SIZE, combined with column NUM_PREC_RADIX). Jaybird returns 10 here if the column is an integer, and 19 for a bigint and 5 for a smallint (all with base 10 as specified in NUM_PREC_RADIX). This has been changed for the upcoming 2.3 release of Jaybird, so getTypeInfo() uses the same base as getColumns (ie base 10). On the Libre Office side, if this is intended to always display the number of digits (characters), it can be achieved by transforming the values using: ceil(log(power(NUM_PREC_RADIX, COLUMN_SIZE))/log(NUM_PREC_RADIX)) (with log = 10log, power = power function, ceil = ceiling function). For 32 base 2 this will yield 20 for bigint, which is not entirely correct (it should be 19 for the signed bigint that Firebird has), but it is close enough for most purposes. For numbers in base 10 this will simply return the original value. Changing this will yield another bug with current versions of Jaybird, as getTypeInfo() incorrectly uses radix 2 for other lengths as well (those lengths are specified in base 10, but NUM_PREC_RADIX reports 2). [1] http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getTypeInfo() [2] http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getColumns(java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String) -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 67179] EDITING: JDBC - Firebird: Integer-fields formatted with wrong field properties
https://bugs.freedesktop.org/show_bug.cgi?id=67179 --- Comment #6 from Mark Rotteveel m...@lawinegevaar.nl --- I scheduled a change in Jaybird to fix this for Jaybird 2.2.4 as well: http://tracker.firebirdsql.org/browse/JDBC-317 As it will take a while before 2.3 is released. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 67179] EDITING: JDBC - Firebird: Integer-fields formatted with wrong field properties
https://bugs.freedesktop.org/show_bug.cgi?id=67179 rob...@familiegrosskopf.de changed: What|Removed |Added Attachment #82825|text/plain |image/png mime type|| -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 67179] EDITING: JDBC - Firebird: Integer-fields formatted with wrong field properties
https://bugs.freedesktop.org/show_bug.cgi?id=67179 --- Comment #1 from rob...@familiegrosskopf.de --- Created attachment 82826 -- https://bugs.freedesktop.org/attachment.cgi?id=82826action=edit Integer field after saving: lenth is changed to 10. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 67179] EDITING: JDBC - Firebird: Integer-fields formatted with wrong field properties
https://bugs.freedesktop.org/show_bug.cgi?id=67179 Julien Nabet serval2...@yahoo.fr changed: What|Removed |Added CC||andr...@ahunt.org, ||serval2...@yahoo.fr --- Comment #2 from Julien Nabet serval2...@yahoo.fr --- Andrzej: one for you? -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 67179] EDITING: JDBC - Firebird: Integer-fields formatted with wrong field properties
https://bugs.freedesktop.org/show_bug.cgi?id=67179 --- Comment #3 from Andrzej J.R. Hunt andr...@ahunt.org --- Hi -- I wouldn't know much about this unfortunately (I'm working on the native firebird driver which avoids going through JDBC -- which will eventually work with external and remote dbs). However assuming this is jaybird specific and doesn't happen with other jdbc databases then it could be a jaybird specific probem, otherwise it'll probably be a jdbc driver problem. Probably worth testing there to determine where exactly the problem lies -- testing 4.0 on openSuse 12.2 64 bit the embedded hsqldb (which uses jdbc) seems to work fine, i.e. field length starts at 5, 10, 100 etc. (depending on type) and stays such after closing and reopening. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
