To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=61887
Issue #:|61887
Summary:|Postgresql sdbc driver. Sum function return value as
|text not as integer
Component:|Database access
Version:|OOo 2.0.1
Platform:|All
URL:|
OS/Version:|All
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|none
Assigned to:|jbu
Reported by:|pba
------- Additional comments from [EMAIL PROTECTED] Fri Feb 10 02:54:16 -0800
2006 -------
Hi
Using postgresql-sdbc-0.7.0 (also tested with 0.6.2) and OO 2.0.1.
Create a simple postgresql table called "test"
---
id serial
value int4
---
Adding two rows in the table (by any method)
id value
1 10
2 11
Create a OO Base document from an existing postgresql database. Register the
database in OO, lets call is test and the file test.odb (not important).
Data from the table is listed fine.
Create a query in OO Base, lets call is Query1.
select sum(value) from test
Execute fine (in OO Base).
---
sum
21
---
Open OO Calc
Press F4
Select the query (Query1) from the list.
Drag the Query into an empty sheet
------
sum
21
------
The problem now is that setting the cursor over the "21" field reveals "'21" ie
that the sum is indeed a string rather than an integer.
If I do the same thing, i.e. create a new OO Base file, but using ODBC and go
through the same steps, the result in OO Calc is:
------
sum
21
------
i.e. now the 21 is a numerical value.
Notice the problem apparently only occurs for functions (I have only tested the
sum function). If instead my OO Base query is: select * from test
--------------
id value
1 10
2 11
--------------
then the result is the same (and correct) for both the sdbc and odbc connection.
I hope this is understandable, otherwise please ask for more information.
Thanks
/Poul
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
