[Libreoffice-bugs] [Bug 74172] Embedded Firebird : data type DECIMAL/ NUMERIC has been forgotten?

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=74172

Tamas Bunth  changed:

   What|Removed |Added

   Assignee|libreoffice-b...@lists.free |btom...@gmail.com
   |desktop.org |

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 74172] Embedded Firebird : data type DECIMAL/NUMERIC has been forgotten?

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=74172

--- Comment #13 from ribotb  ---
Hi,

Bug always present with :
Version: 5.1.0.2
Build ID: ecd3574d51754b043f865cf5bafee286d24db7cc
CPU Threads: 2; OS Version: Windows 6.1; UI Render: default; 
Locale : fr-FR (fr_FR)
on Win7/x86

Data typrs present in Base :

Biglnt [ BIGINT ]
Texte (fixe) [CHAR]
Integer [ INTEGER ]
Small Integer [ SMALLIrJT ]
Float[FLOAT]
Double [ DOUBLE PRECISION ]
Texte [ VARCHAR ]
Date [DATE]
Heure [TIME]
Date/Heure [TIMESTAMP ]
BLOB [BLOB]

Bernard

-- 
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 74172] Embedded Firebird : data type DECIMAL/NUMERIC has been forgotten?

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=74172

--- Comment #12 from rob...@familiegrosskopf.de ---
Bug still exists unde LO 5.1.0.2, OpenSUSE Leap 42.1, 64bit rpm Linux.

-- 
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 74172] Embedded Firebird : data type DECIMAL/NUMERIC has been forgotten?

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=74172

--- Comment #11 from QA Administrators  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present on a currently supported version of
LibreOffice (5.0.4 or later)  https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of
LibreOffice and your operating system, and any changes you see in the bug
behavior

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a short comment that includes your version of
LibreOffice and Operating System

Please DO NOT:

- Update the version field
- Reply via email (please reply directly on the bug tracker)
- Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not appropriate in this case)

If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so: 1. Download and install oldest version of LibreOffice
(usually 3.3 unless your bug pertains to a feature added after 3.3)

http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug 3. Leave a comment with your results. 4a. If the bug was
present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not
present in 3.3 - add "regression" to keyword


Feel free to come ask questions or to say hello in our QA chat:
http://webchat.freenode.net/?channels=libreoffice-qa

Thank you for your help!

-- The LibreOffice QA Team This NEW Message was generated on: 2016-01-17

-- 
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 74172] Embedded Firebird : data type DECIMAL/NUMERIC has been forgotten?

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=74172

--- Comment #10 from Julien Nabet serval2...@yahoo.fr ---
I noticed that DECIMAL and NUMERIC were in fact subtypes.
Here's part of code from firebird (isql/isql.h=
// Integral subtypes

const int MAX_INTSUBTYPES   = 2;
static const SCHAR* Integral_subtypes[] = {
UNKNOWN,   // Defined type, NTX: keyword
NUMERIC,   // NUMERIC, NTX: keyword
DECIMAL// DECIMAL, NTX: keyword
};

isql/extract.epp and isql/show.epp show that they're subtypes of SMALLINT,
INTEGER and BIGINT, example from first file :
438 if (isqlGlob.major_ods = ODS_VERSION10)
439 {
440 // Handle Integral subtypes NUMERIC and DECIMAL
441 if ((FLD.RDB$FIELD_TYPE == SMALLINT) ||
442(FLD.RDB$FIELD_TYPE == INTEGER)  ||  
443(FLD.RDB$FIELD_TYPE == BIGINT))  
444 {
445FOR FLD1 IN RDB$FIELDS WITH  
446 FLD1.RDB$FIELD_NAME EQ FLD.RDB$FIELD_NAME   
447  /* We are ODS = 10 and could be any Dialect */
448  if (!FLD1.RDB$FIELD_PRECISION.NULL)
449  {  
450  /* We are Dialect =3 since FIELD_PRECISION is non-NULL */
451  if (FLD1.RDB$FIELD_SUB_TYPE  0  
452   FLD1.RDB$FIELD_SUB_TYPE = MAX_INTSUBTYPES)   
453  {
454 sprintf (Print_buffer, %s(%d, %d),
455   Integral_subtypes[FLD1.RDB$FIELD_SUB_TYPE],   
456   FLD1.RDB$FIELD_PRECISION, 
457   -FLD1.RDB$FIELD_SCALE);   
458 precision_known = true;
459  }
460  }
461   END_FOR
462   ON_ERROR
463 ISQL_errmsg (isc_status);
464 return ps_ERR;
465   END_ERROR;
466 }
467 }

-- 
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 74172] Embedded Firebird : data type DECIMAL/NUMERIC has been forgotten?

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=74172

--- Comment #9 from Alex Thurgood ipla...@yahoo.co.uk ---
Adding self to CC if not already on

-- 
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 74172] Embedded Firebird : data type DECIMAL/NUMERIC has been forgotten?

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=74172

--- Comment #6 from Julien Nabet serval2...@yahoo.fr ---
Code pointer:
http://opengrok.libreoffice.org/xref/core/connectivity/source/drivers/firebird/DatabaseMetaData.cxx#947

Other I suppose

Doc pointers:
1) http://www.firebirdfaq.org/faq340/

In SQL Standard, NUMERIC is a more strict datatype which should enforce the
declared precision, while DECIMAL can accept more numbers than declared.
However, in Firebird, both types accept more numbers (i.e. they behave like
DECIMAL).

2) http://www.firebirdsql.org/en/sql-conformance/

NUMERIC is not compliant and represents almost the same semantics as DECIMAL

3) http://www.firebirdsql.org/en/firebird-technical-specifications/

Name: Numeric (precision, scale)
Size: Variable (16, 32, or 64 bits)
Range/Precision: specifies exactly precision digits of precision
Description: Example: Numeric(10,3) holds numbers accurately in the following
format: ppp.sss

Name: Decimal (precision, scale)
Size: Variable (16, 32, or 64 bits)
Range/Precision: specifies at least precision digits of precision
Description: Example: Numeric(10,3) holds numbers accurately in the following
format: ppp.sss


-- 
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 74172] Embedded Firebird : data type DECIMAL/NUMERIC has been forgotten?

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=74172

--- Comment #7 from Julien Nabet serval2...@yahoo.fr ---
Ref for data type:
offapi/com/sun/star/sdbc/DataType.idl

-- 
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 74172] Embedded Firebird : data type DECIMAL/NUMERIC has been forgotten?

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=74172

--- Comment #8 from Julien Nabet serval2...@yahoo.fr ---
I tried to begin to add NUMERIC and DECIMAL but I got this:
diff --git a/connectivity/source/drivers/firebird/DatabaseMetaData.cxx
b/connectivity/source/drivers/firebird/DatabaseMetaData.cxx
index bff558c..6850863 100644
--- a/connectivity/source/drivers/firebird/DatabaseMetaData.cxx
+++ b/connectivity/source/drivers/firebird/DatabaseMetaData.cxx
@@ -936,6 +936,20 @@ uno::Reference XResultSet  SAL_CALL
ODatabaseMetaData::getTypeInfo()
 sal_Int16(ColumnSearch::FULL)); // Searchable
 aRow[12] = new ORowSetValueDecorator(sal_True); // Autoincrement
 }
+// SQL_NUMERIC
+aRow[1] = new ORowSetValueDecorator(OUString(NUMERIC));
+aRow[2] = new
ORowSetValueDecorator(getColumnTypeFromFBType(SQL_NUMERIC));
+aRow[3] = new ORowSetValueDecorator(sal_Int16(15)); // Precision
+aRow[14] = new ORowSetValueDecorator(sal_Int16(1)); // Minimum scale
+aRow[15] = new ORowSetValueDecorator(sal_Int16(15)); // Max scale
+aResults.push_back(aRow);
+// SQL_DECIMAL
+aRow[1] = new ORowSetValueDecorator(OUString(DECIMAL));
+aRow[2] = new
ORowSetValueDecorator(getColumnTypeFromFBType(SQL_DECIMAL));
+aRow[3] = new ORowSetValueDecorator(sal_Int16(15)); // Precision
+aRow[14] = new ORowSetValueDecorator(sal_Int16(1)); // Minimum scale
+aRow[15] = new ORowSetValueDecorator(sal_Int16(15)); // Max scale
+aResults.push_back(aRow);

But I got this:
/home/julien/compile-libreoffice/libreoffice/connectivity/source/drivers/firebird/DatabaseMetaData.cxx:
In member function ‘virtual
com::sun::star::uno::Referencecom::sun::star::sdbc::XResultSet
connectivity::firebird::ODatabaseMetaData::getTypeInfo()’:
/home/julien/compile-libreoffice/libreoffice/connectivity/source/drivers/firebird/DatabaseMetaData.cxx:941:69:
error: ‘SQL_NUMERIC’ was not declared in this scope
 aRow[2] = new
ORowSetValueDecorator(getColumnTypeFromFBType(SQL_NUMERIC));
 ^
/home/julien/compile-libreoffice/libreoffice/connectivity/source/drivers/firebird/DatabaseMetaData.cxx:948:69:
error: ‘SQL_DECIMAL’ was not declared in this scope
 aRow[2] = new
ORowSetValueDecorator(getColumnTypeFromFBType(SQL_DECIMAL));
 ^
I've got no idea where these must be declared, any idea?

-- 
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 74172] Embedded Firebird : data type DECIMAL/NUMERIC has been forgotten?

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=74172

Julien Nabet serval2...@yahoo.fr changed:

   What|Removed |Added

 Status|NEW |NEEDINFO
 CC||serval2...@yahoo.fr

--- Comment #3 from Julien Nabet serval2...@yahoo.fr ---
On pc Debian x86-64 with master sources updated yesterday or 4.2 sources
updated some days ago, I don't reproduce this (or perhaps missed the point).

For the test, could you give a try to 4.2 daily build (see
http://dev-builds.libreoffice.org/daily/libreoffice-4-2/) or master sources
(future 4.3.0) daily build (see
http://dev-builds.libreoffice.org/daily/master/)

-- 
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 74172] Embedded Firebird : data type DECIMAL/NUMERIC has been forgotten?

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=74172

Julien Nabet serval2...@yahoo.fr changed:

   What|Removed |Added

 Status|NEEDINFO|NEW

--- Comment #4 from Julien Nabet serval2...@yahoo.fr ---
Forget my last comment.

-- 
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 74172] Embedded Firebird : data type DECIMAL/NUMERIC has been forgotten?

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=74172

--- Comment #5 from ribotb rib...@gmail.com ---
Hi,
I forgot ;-))

I verified with version 4.3.0.0.alpha1+
Build ID: 20778b037c688759a4dc46acb8aeb66c9d1290cc
TinderBox: Win-x86@39, Branch:master, Time: 2014-05-03_23:16:12

Data type DECIMAL/NUMERIC is not present.

Regards,
Bernard

-- 
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 74172] Embedded Firebird : data type DECIMAL/NUMERIC has been forgotten?

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=74172

--- Comment #2 from ribotb rib...@gmail.com ---
Adding as blocker for making Firebird the default

-- 
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 74172] Embedded Firebird : data type DECIMAL/NUMERIC has been forgotten?

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=74172

ribotb rib...@gmail.com changed:

   What|Removed |Added

 Blocks||51780

-- 
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 74172] Embedded Firebird : data type DECIMAL/NUMERIC has been forgotten?

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=74172

rob...@familiegrosskopf.de changed:

   What|Removed |Added

   Hardware|x86 (IA32)  |All
 OS|Windows (All)   |All
 Status|UNCONFIRMED |NEW
 CC||rob...@familiegrosskopf.de
 Ever confirmed|0   |1

--- Comment #1 from rob...@familiegrosskopf.de ---
Can confirm this for OpenSUSE 12.3 64bit and L= 4.2.0.4.
No possibility to save a Decimal value.

-- 
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