https://bugs.documentfoundation.org/show_bug.cgi?id=116890
--- Comment #32 from Gerhard Schaber ---
Intuitively I would expect rs.columns.ElementNames to return the aliases, just
like the UI shows the aliases. But I don't know whether this would break
anything with the other databases.
--
You a
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
--- Comment #31 from Julien Nabet ---
(In reply to Gerhard Schaber from comment #27, #28, #29, #30)
>...
> Or do you suggest to generally use rs.metadata.getcolumnlabel directly
> instead of rs.columns.elementnames in the macro itself?
I
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
--- Comment #30 from Gerhard Schaber ---
Or do you suggest to generally use rs.metadata.getcolumnlabel directly instead
of rs.columns.elementnames in the macro itself?
--
You are receiving this mail because:
You are the assignee for the
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
--- Comment #29 from Gerhard Schaber ---
So in my opinion, the code fragment in preparedstatement and resultset shoud
use xMetaData->getColumnLabel instead of xMetaData->getColumnName. Only, if
getColumnLabel is empty, it could use getCol
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
--- Comment #28 from Gerhard Schaber ---
For both the prepared statement and result set?
--
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing l
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
--- Comment #27 from Gerhard Schaber ---
If there is an alias for the column, can you use that one instead of the unique
CONSTANT name?
--
You are receiving this mail because:
You are the assignee for the bug.___
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
Julien Nabet changed:
What|Removed |Added
Status|NEW |RESOLVED
Resolution|---
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
--- Comment #25 from Commit Notification
---
Julien Nabet committed a patch related to this issue.
It has been pushed to "libreoffice-6-0":
http://cgit.freedesktop.org/libreoffice/core/commit/?id=0d78d17249a58d95b4aa2e8fe09f08e22f20c407
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
Commit Notification changed:
What|Removed |Added
Whiteboard|target:6.1.0|target:6.1.0 target:6.0.4
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
Commit Notification changed:
What|Removed |Added
Whiteboard||target:6.1.0
--
You are r
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
--- Comment #24 from Commit Notification
---
Julien Nabet committed a patch related to this issue.
It has been pushed to "master":
http://cgit.freedesktop.org/libreoffice/core/commit/?id=dc823f5fa4a5d2eca56297b9045e5962536c00f9
tdf#116
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
--- Comment #23 from Julien Nabet ---
(In reply to Lionel Elie Mamane from comment #22)
> (In reply to Julien Nabet from comment #21)
> > (In reply to Lionel Elie Mamane from comment #17)
>
...
> This means the difference is in LibreOffi
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
--- Comment #22 from Lionel Elie Mamane ---
(In reply to Julien Nabet from comment #21)
> (In reply to Lionel Elie Mamane from comment #17)
>> If in one case, several columns have the same name "CONSTANT" and in the
>> other case all col
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
--- Comment #21 from Julien Nabet ---
(In reply to Lionel Elie Mamane from comment #17)
> ...
> To be clear, the two cases are (in Gerhard's code):
>
> oResult = oPrepStatement.executeQuery
> ccols = oPrepStatement.Columns
>
> and
>
>
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
--- Comment #20 from Lionel Elie Mamane ---
(In reply to Gerhard Schaber from comment #16)
> In any case, with Firebird in a macro, when I use the columns from the
> result set, the constant columns are numbered, but with the
> prepareds
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
--- Comment #19 from Lionel Elie Mamane ---
Rah... Second test case, this time correct, is:
Sub Main
Dim DBDocUI as Object
on error resume next
DBDocUI = ThisDatabaseDocument.currentController
if not DBDoc
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
--- Comment #18 from Lionel Elie Mamane ---
(In reply to Lionel Elie Mamane from comment #17)
Sorry, wrong test code. One test case is:
Sub Main
Dim DBDocUI as Object
on error resume next
DBDocUI = ThisDatabaseDoc
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
--- Comment #17 from Lionel Elie Mamane ---
It still seems the problem with Firebird-in-Libreoffice preparedstatement is
that the columns collection is constructed with duplicate column names, which
means duplicates are dropped.
This cou
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
--- Comment #16 from Gerhard Schaber ---
Yes, I am aware that in the macro always the alias is used fpr HSQLDB. I was
just wondering, if LO uses the original column name anywhere and whether the
constant columns are replaced with the alia
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
--- Comment #15 from Lionel Elie Mamane ---
(In reply to Gerhard Schaber from comment #14)
> getColumnName returns the original name according to the manual.
It does not make much sense to me, but it seems you are right. A very clear
so
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
--- Comment #14 from Gerhard Schaber ---
According to
https://docs.oracle.com/javase/7/docs/api/java/sql/ResultSetMetaData.html#getColumnLabel(int)
there is a difference between getColumnLabel and getColumnName. Maybe constant
columns are
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
--- Comment #13 from Gerhard Schaber ---
The UI also shows the aliases.
--
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-b
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
--- Comment #12 from Julien Nabet ---
I submitted this patch on gerrit:
https://gerrit.libreoffice.org/#/c/52662/
--
You are receiving this mail because:
You are the assignee for the bug.___
L
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
--- Comment #11 from Julien Nabet ---
Created attachment 141243
--> https://bugs.documentfoundation.org/attachment.cgi?id=141243&action=edit
bt with debug symbols
I attached bt corresponding to the location where we get column names.
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
--- Comment #10 from Lionel Elie Mamane ---
(In reply to Julien Nabet from comment #8)
> I also noticed the difference between sqlname and aliasname for CONSTANT,
> eg:
> (gdb) p m_pSqlda->sqlvar[column-1].sqlname
> $34 = "CONSTANT", '\
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
--- Comment #9 from Julien Nabet ---
Forgot to tell I started from these logs repeated several times:
warn:legacy.osl:14544:14544:dbaccess/source/core/api/column.cxx:204:
OColumns::append: Column already exists
warn:legacy.osl:14544:14544
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
--- Comment #8 from Julien Nabet ---
On pc Debian x6-64 with master sources updated today, I could reproduce this.
I noticed that in
/home/julien/lo/libreoffice/connectivity/source/drivers/firebird/ResultSetMetaData.cxx,
connectivity::fir
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
--- Comment #7 from Gerhard Schaber ---
Correction, when I use the columns of the result set, the number of the columns
is correct, but the empty ones are all named CONSTANT where is empty for
the first empty column, and an increasing nu
https://bugs.documentfoundation.org/show_bug.cgi?id=116890
Gerhard Schaber changed:
What|Removed |Added
Summary|Firebird: empty columns |Firebird: empty columns
29 matches
Mail list logo