Open an internal Firebird database. Edit a new query. Try to chose an alias for one field. The alias would be ignored - the old name of the field will appear. It's a special problem when you try to use functions, which only work in the direct SQL-mode: SELECT "date", DATEADD(DAY,'5',"date") AS "date_new" FROM "table" In such a query there isn't shown any name for the field, which shows the added date. The fieldname will be empty. Take https://bugs.freedesktop.org/attachment.cgi?id=87557 for testing. Same works with the internal database in the same version of LO. Same works with the external Firebird database in LO 4.1.1.
Created attachment 109137 [details] Open the query - one field without fieldname When you run the query1, you could see one field without any fieldname. This field shows the same content as the next field. Open the query for editing. There are two fields with an alias: "Datum" AS "Date" and DATEADD(DAY, '5', "Datum") AS "NewDate". No alias is shown. "Datum" is shown for the third column and nothing for the fourth column.
(In reply to robert from comment #1) > Created attachment 109137 [details] > Open the query - one field without fieldname > > When you run the query1, you could see one field without any fieldname. This > field shows the same content as the next field. > > Open the query for editing. There are two fields with an alias: "Datum" AS > "Date" and DATEADD(DAY, '5', "Datum") AS "NewDate". No alias is shown. > "Datum" is shown for the third column and nothing for the fourth column. Sorry for my newbieness, but maybe it will be good to have "explain like I'm five" -style instructions for this: when I open the db and try to edit the query I get this error: The connection to the data source "Firebird_intern_query_no_alias" could not be established. SQL Status: HY000 The connection to the external data source could not be established. No SDBC driver was found for the URL 'sdbc:embedded:firebird'. What should I do to make it work?
(In reply to Beluga from comment #2) > > The connection to the data source "Firebird_intern_query_no_alias" could not > be established. SQL Status: HY000 The connection to the external data > source could not be established. No SDBC driver was found for the URL > 'sdbc:embedded:firebird'. Could be you haven't enabled internal firebird. Go to Tools → Options → LibreOffice → Advanced → Enable experimatenal features This should start the internal firebird for LO.
Created attachment 109146 [details] Backtrace of query edit crash I enabled experimental features, but now I'm getting a crash, when trying to edit the query :) Win 7 64-bit Version: 4.4.0.0.alpha2+ Build ID: 9229170920ab770624415c4330da57af5b1b5398 TinderBox: Win-x86@39, Branch:master, Time: 2014-11-09_03:16:43
(In reply to robert from comment #1) > Created attachment 109137 [details] > Open the query - one field without fieldname > > When you run the query1, you could see one field without any fieldname. This > field shows the same content as the next field. > > Open the query for editing. There are two fields with an alias: "Datum" AS > "Date" and DATEADD(DAY, '5', "Datum") AS "NewDate". No alias is shown. > "Datum" is shown for the third column and nothing for the fourth column. Ok, I ran the query on Linux and I see what you are describing: Datum for 3rd column and nothing for 4th. Version: 4.3.2.2.0+ Build ID: 4.3.2.2 Arch Linux build-1
Adding self to CC if not already on
** 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
Bug still exists with LO 5.1.0.3, OpenSUSE 42.1 Leap, 64bit rpm Linux.
Have tested it again while creating a view: The alias for a field will be created, if I create a view from a query, which doesn't show the alias. See bug76072. ... but the alias wouldn't be shown through the query-GUI. Tested with: Version: 5.3.0.0.alpha1+ Build ID: 5d39c2013374727b1c8f147b8b99d54402a7ff02 CPU Threads: 4; OS Version: Linux 4.1; UI Render: default; VCL: gtk2; Layout Engine: old; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2016-11-02_00:55:24 Locale: de-DE (de_DE.UTF-8); Calc: group
Robert: would it be possible to attach a file with Firebird 3.0 format? Indeed, I tried gbak conversion suggested in https://wiki.documentfoundation.org/Development/Base/FirebirdSQL but gbak version provided by Debian is from Firebird 3.0 (not 2.5 one) I suppose it's because of this version mismatch that gbak -backup firebird.fdb firebird.fbk gives: gbak: ERROR:Unable to complete network request to host "localhost". gbak: ERROR: Failed to establish a connection. gbak:Exiting before completion due to errors
After having installed firebird-server, I got the same initial error with gbak: gbak: ERROR:unsupported on-disk structure for file /home/julien/lo/bugs/70506_firebirdrobertalias/test/database/firebird.fdb; found 11.2, support 12.0 gbak:Exiting before completion due to errors
I installed Firebird 2.5 (superclassic) from Jessie Debian repo. Now I've got this: gbak: ERROR:operating system directive open failed gbak: ERROR: Permission denied gbak:Exiting before completion due to errors I gave a try to http://www.firebirdfaq.org/faq102/ but nothing. I confirm a webservice which would convert a odb with Fb 2.5 to an odb with Fb 3.0 could be very useful! :-)
Created attachment 128677 [details] Version 3.0 of original file I finally succeeded! I runned the command as root in /tmp So the complete procedure is: - install Firebird 2.5 - uncompress odb file - gbak -backup firebird.fdb firebird.fbk => so firebird.fdb is 2.5 and firebird.fbk is 2.5 - uninstall Firebird 2.5 - install Firebird 3.0 - gbak -c -v firebird.fbk firebird.fdb => so firebird.fdk is still 2.5 but firebird.fdb is 3.0 - change owner and rights of the file firebird.fdb - recompress all the elements (with the brand new firebird.fdb) - change extension from zip to odb Hope I haven't forgotten anything but above all, hope there's a simpler way! :-)
If I run the query, here is the header line: ID Name Datum DATEADD DATEADD And here are the console logs: warn:connectivity.firebird:12464:1:connectivity/source/drivers/firebird/DatabaseMetaData.cxx:1485: Not yet implemented warn:legacy.osl:12464:1:connectivity/source/drivers/firebird/DatabaseMetaData.cxx:1489: Not implemented yet! warn:connectivity.firebird:12464:1:connectivity/source/drivers/firebird/DatabaseMetaData.cxx:1485: Not yet implemented warn:legacy.osl:12464:1:connectivity/source/drivers/firebird/DatabaseMetaData.cxx:1489: Not implemented yet! warn:connectivity.firebird:12464:1:connectivity/source/drivers/firebird/DatabaseMetaData.cxx:1485: Not yet implemented warn:legacy.osl:12464:1:connectivity/source/drivers/firebird/DatabaseMetaData.cxx:1489: Not implemented yet! warn:connectivity.firebird:12464:1:connectivity/source/drivers/firebird/DatabaseMetaData.cxx:1485: Not yet implemented warn:legacy.osl:12464:1:connectivity/source/drivers/firebird/DatabaseMetaData.cxx:1489: Not implemented yet! warn:connectivity.firebird:12464:1:connectivity/source/drivers/firebird/DatabaseMetaData.cxx:1485: Not yet implemented warn:legacy.osl:12464:1:connectivity/source/drivers/firebird/DatabaseMetaData.cxx:1489: Not implemented yet! warn:connectivity.firebird:12464:1:connectivity/source/drivers/firebird/ResultSetMetaData.cxx:177: Column 'DATEADD' not found in database warn:connectivity.firebird:12464:1:connectivity/source/drivers/firebird/ResultSetMetaData.cxx:177: Column 'DATEADD' not found in database
(In reply to Julien Nabet from comment #13) > Created attachment 128677 [details] > Version 3.0 of original file > > I finally succeeded! > I runned the command as root in /tmp > > So the complete procedure is: > - install Firebird 2.5 > - uncompress odb file > - gbak -backup firebird.fdb firebird.fbk > => so firebird.fdb is 2.5 and firebird.fbk is 2.5 > - uninstall Firebird 2.5 > - install Firebird 3.0 > - gbak -c -v firebird.fbk firebird.fdb > => so firebird.fdk is still 2.5 but firebird.fdb is 3.0 > - change owner and rights of the file firebird.fdb > - recompress all the elements (with the brand new firebird.fdb) > - change extension from zip to odb > > Hope I haven't forgotten anything but above all, hope there's a simpler way! > :-) In the odb file, remove the fdb, and put the fbk in its place. That should suffice :) Something like: - install Firebird 2.5 - uncompress odb file - gbak -backup firebird.fdb firebird.fbk - rm firebird.fdb - change owner and rights of the file firebird.bk - recompress all the elements (with the brand new firebird.fbk) - change extension from zip to odb
(In reply to Lionel Elie Mamane from comment #15) > (In reply to Julien Nabet from comment #13) > > Created attachment 128677 [details] > > Version 3.0 of original file > > > > I finally succeeded! > > I runned the command as root in /tmp > > ... > > In the odb file, remove the fdb, and put the fbk in its place. That should > suffice :) > > Something like: > > - install Firebird 2.5 > - uncompress odb file > - gbak -backup firebird.fdb firebird.fbk > - rm firebird.fdb > - change owner and rights of the file firebird.bk > - recompress all the elements (with the brand new firebird.fbk) > - change extension from zip to odb Indeed, it works! Thank you for the tip, it saves some time! :-)
Wastack committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=ef1aee0f80d34b75b0d406abc708a0e8316fe5e8 tdf#70506 implement getColumnLabel function It will be available in 5.4.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Backport has been done too (see https://gerrit.libreoffice.org/#/c/32250/) So let's put this one to FIXED.
(backport to 5.3 branch only)
Wastack committed a patch related to this issue. It has been pushed to "libreoffice-5-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=cd961ccaadbe0e14512421ce91134dd7c601e7cf&h=libreoffice-5-3 tdf#70506 implement getColumnLabel function It will be available in 5.3.0.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Could confirm it works now with Version: 5.4.0.0.alpha0+ Build ID: 2a4cd80abcf9e515d1ce3b3a944b573bdc42bff2 CPU Threads: 4; OS Version: Linux 4.1; UI Render: default; VCL: kde4; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2016-12-22_00:18:04 Locale: de-DE (de_DE.UTF-8); Calc: group Thanks a lot, Wastack.
*** Bug 105195 has been marked as a duplicate of this bug. ***