[Libreoffice-bugs] [Bug 123368] Firebird Migration of Existing Database Error on Importing Table Name with space
https://bugs.documentfoundation.org/show_bug.cgi?id=123368 sdritc...@gmail.com changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |WORKSFORME --- Comment #8 from sdritc...@gmail.com --- QA Administrators, To test I downloaded "hsqldb test file" and followed the Steps to Reproduce. I can confirm the error messgae did not appear in LO version 6.4.7.2 which is the version I have installed. Per your request I'll mark as RESOLVED-WORKSFORME. Thanks for following up on this. -- 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 123368] Firebird Migration of Existing Database Error on Importing Table Name with space
https://bugs.documentfoundation.org/show_bug.cgi?id=123368 --- Comment #7 from QA Administrators --- Dear sdritchey, 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 with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. 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) from https://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: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- 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 123368] Firebird Migration of Existing Database Error on Importing Table Name with space
https://bugs.documentfoundation.org/show_bug.cgi?id=123368 Xisco Faulí changed: What|Removed |Added Blocks||116968 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=116968 [Bug 116968] [META] Migrating existing embedded HSQLDB databases to Firebird -- 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 123368] Firebird Migration of Existing Database Error on Importing Table Name with space
https://bugs.documentfoundation.org/show_bug.cgi?id=123368 Xisco Faulí changed: What|Removed |Added OS|Mac OS X (All) |All CC||xiscofa...@libreoffice.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 123368] Firebird Migration of Existing Database Error on Importing Table Name with space
https://bugs.documentfoundation.org/show_bug.cgi?id=123368 Julien Nabet changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 CC||btom...@gmail.com, ||lio...@mamane.lu --- Comment #6 from Julien Nabet --- Thank you for your feedback, I could reproduce this. Tamas: debugging a bit on gdb shows the pb is in utils::getTableNameFromStmt See https://opengrok.libreoffice.org/xref/core/dbaccess/source/filter/hsqldb/utils.cxx?r=6a736800#92 This method is called from CREATE TABLE and ALTER TABLE statements. We can't do like in https://cgit.freedesktop.org/libreoffice/core/commit/?id=2a08db9a0473e2f87715aacfc7b481beaa490dcf since we got: ALTER TABLE \"Plant Database\" ALTER COLUMN \"ID\" RESTART WITH 1497 With no space in table, perhaps we would have had this: ALTER TABLE Plant_Database ALTER COLUMN \"ID\" RESTART WITH 1497 So can't test the presence of ". In brief, it shows we need to use a real sql parser here because for the moment we're using only bandaid fixes. Of course, it's more easy to tell than to do I suppose, if not, it should have already be implemented. -- 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 123368] Firebird Migration of Existing Database Error on Importing Table Name with space
https://bugs.documentfoundation.org/show_bug.cgi?id=123368 --- Comment #5 from sdritc...@gmail.com --- I've attached two test databases, one with a space in the table name and one without. The one without the space converts as expected. The one with the space shows the error message in the screenshot above. -- 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 123368] Firebird Migration of Existing Database Error on Importing Table Name with space
https://bugs.documentfoundation.org/show_bug.cgi?id=123368 sdritc...@gmail.com changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- 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 123368] Firebird Migration of Existing Database Error on Importing Table Name with space
https://bugs.documentfoundation.org/show_bug.cgi?id=123368 --- Comment #4 from sdritc...@gmail.com --- Created attachment 149167 --> https://bugs.documentfoundation.org/attachment.cgi?id=149167&action=edit hsqldb test file, without space in table name -- 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 123368] Firebird Migration of Existing Database Error on Importing Table Name with space
https://bugs.documentfoundation.org/show_bug.cgi?id=123368 --- Comment #3 from sdritc...@gmail.com --- Created attachment 149166 --> https://bugs.documentfoundation.org/attachment.cgi?id=149166&action=edit hsqldb test file -- 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 123368] Firebird Migration of Existing Database Error on Importing Table Name with space
https://bugs.documentfoundation.org/show_bug.cgi?id=123368 Julien Nabet changed: What|Removed |Added CC||serval2...@yahoo.fr Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #2 from Julien Nabet --- On pc Debian x86-64 with master sources updated yesterday, I don't reproduce this. Could you attach an example file? -- 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 123368] Firebird Migration of Existing Database Error on Importing Table Name with space
https://bugs.documentfoundation.org/show_bug.cgi?id=123368 --- Comment #1 from sdritc...@gmail.com --- Created attachment 149165 --> https://bugs.documentfoundation.org/attachment.cgi?id=149165&action=edit error message screenshot -- 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
