[Libreoffice-bugs] [Bug 117090] EDITING: Firebird: migration: View definitions are lost from embedded hsql files using functions unknown to Firebird

[bugzilla-daemon]

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

--- Comment #20 from Robert Großkopf  ---
Bug is still the same with LO 7.5.3.2 on OpenSUSE 15.4 64bit rpm Linux

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 117090] EDITING: Firebird: migration: View definitions are lost from embedded hsql files using functions unknown to Firebird

[bugzilla-daemon]

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

--- Comment #19 from QA Administrators  ---
Dear Robert Großkopf,

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://web.libera.chat/?settings=#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] [Bug 117090] EDITING: Firebird: migration: View definitions are lost from embedded hsql files using functions unknown to Firebird

[bugzilla-daemon]

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

--- Comment #18 from Robert Großkopf  ---
Bug still exists in LO 7.1.3.2 on OpenSUSE 15.2 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
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117090] EDITING: Firebird: migration: View definitions are lost from embedded hsql files using functions unknown to Firebird

[bugzilla-daemon]

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

--- Comment #17 from QA Administrators  ---
Dear Robert Großkopf,

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 117090] EDITING: Firebird: migration: View definitions are lost from embedded hsql files using functions unknown to Firebird

[bugzilla-daemon]

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

Julien Nabet  changed:

   What|Removed |Added

 CC||silvain-dupertuis@bluewin.c
   ||h

--- Comment #16 from Julien Nabet  ---
*** Bug 125161 has been marked as a duplicate of this bug. ***

-- 
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 117090] EDITING: Firebird: migration: View definitions are lost from embedded hsql files using functions unknown to Firebird

[bugzilla-daemon]

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

--- Comment #15 from Justin L  ---
(In reply to Justin L from comment #14)
> My migration of attachment 147302 [details] has the same problem
The wiki documentation nicely gave me all the information I needed to convert
CONCAT and SUBSTRING to mutually compatible forms, and with that the migration
succeeds. A few bugs in number conversion, but overall a fairly impressive
achievement at this point.

-- 
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 117090] EDITING: Firebird: migration: View definitions are lost from embedded hsql files using functions unknown to Firebird

[bugzilla-daemon]

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

Justin L  changed:

   What|Removed |Added

 CC||jl...@mail.com

--- Comment #14 from Justin L  ---
My migration of attachment 147302 has the same problem mentioned by Robert, so
I thought I would include it as a sample. The wiki page mentioned in Comment 11
is very helpful.

Better error messages certainly would be helpful. Last62onMaster's MORE error
details gives me a box with two errors that I can't select and the description
is blank.

-- 
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 117090] EDITING: Firebird: migration: View definitions are lost from embedded hsql files using functions unknown to Firebird

[bugzilla-daemon]

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

Alex Thurgood  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=12
   ||0237

-- 
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 117090] EDITING: Firebird: migration: View definitions are lost from embedded hsql files using functions unknown to Firebird

[bugzilla-daemon]

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

--- Comment #13 from Drew Jensen  ---
(In reply to Gerhard Weydt from comment #12)
> Hi Drew,

Howdy Gerhard,

sorry, that was poorly typed on my part.

What I intended is best stated as, I will try to assemble the type of
information you asked about on that page. 

The final thought was just a mention of the wiki native language support, given
how it is structured.

In fact I was looking at that page earlier today with the same thoughts, which
are that it is time to put some specifics as to what is working and not.  

Looking at the release schedule on the wiki I note a possible beta 2 on the
11th of this month, am using that for my working target for updating the
Migration Assistant page with where it is at, by that date.

-- 
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 117090] EDITING: Firebird: migration: View definitions are lost from embedded hsql files using functions unknown to Firebird

[bugzilla-daemon]

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

--- Comment #12 from Gerhard Weydt  ---
Hi Drew,

I know you are a frequent contributor on these pages as regards database
migration, and I assume that you are a native english speaker (which I am not).
I appreciate your contributions on errors regarding the migration from HSQLB to
Firebird. But I simply don't understand your remarks.
The link you provide doesn't add anything to the fundamental question I posed.
And the remaining text is simply not intelligible for me, there seem to be too
much typing errors etc.
For example: "That page is in the structure for nl groups to have translate if
they choose." This sentence is in my opinion grammatically incorrect in such a
high degree that I simply can't understand it.

-- 
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 117090] EDITING: Firebird: migration: View definitions are lost from embedded hsql files using functions unknown to Firebird

[bugzilla-daemon]

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

--- Comment #11 from Drew Jensen  ---
(In reply to Gerhard Weydt from comment #10)
> Looking at all the bug reports regarding the migration to Firebird that have
> already been entered one must conclude that it will be impossible to cover
> all eventualities that might be happening at the conversion. 
...
> 3) I understand that the old HSQLDB is still stored within the database
> document aftre the migration. If so, then proposal 2) would perhaps be
> unnecessary, but only if there is an easy way to access this content, and
> the information how to access it is adequately published. I don't know
> where, but the migration process should supply a link or information where
> to find it.

So, I would see that as  this page on the wiki
https://wiki.documentfoundation.org/Documentation/FirebirdMigration 

It is a good spot to cover specifics as to what is handled by the Migratioin
Assistant at the moment and as it releases. (and what is not)

With beta the current build and RC coming up this is good time to update that,
with the RC there should be some specificity to that, with reference to major
open issues but otherwise what is expected in release.

That page is in the structure for nl groups to have translate if they choose.

-- 
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 117090] EDITING: Firebird: migration: View definitions are lost from embedded hsql files using functions unknown to Firebird

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

   Priority|medium  |high
   Severity|normal  |major

-- 
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 117090] EDITING: Firebird: migration: View definitions are lost from embedded hsql files using functions unknown to Firebird

[bugzilla-daemon]

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

--- Comment #10 from Gerhard Weydt  ---
Looking at all the bug reports regarding the migration to Firebird that have
already been entered one must conclude that it will be impossible to cover all
eventualities that might be happening at the conversion. But it seems that the
conversion strategy still supposes that this can be done.
The impossibility of arriving at a 100 % conversion to Firebird should be
recognised. The efforts to get at near to 100 % as possible should certainly be
continued, because it is indispensable that the migration works generally. But
we must face the fact that there will be some cases not covered by the
migration routines, no matter how long we try to complete the migration code;
and I think there is not even time to try to arrive at a "complete" process,
because there is some deadline for the migration to Firebird.
So there should be an easy way to access all the information of features that
caused problems when migrating a database document from HSQLDB to Firebird,
such that it is quite easy to supply the (hopefully rare) missing features to
the migrated Firebird database manually.
As I have not enough insight into the details of the migration process, I can
only offer some general ideas:
1) The easiest way (regarding implementation) would be to supply a very serious
warning, when a database document should be converted, to always do this, first
of all, with a copy, or to save a copy beforehand, so that one always has an
original document to refer to, in case of problems.
2) Unfortunately, some people might ignore even this serious warning, so a
prompt to save the old state with a differnt name would perhaps be helpful.
3) I understand that the old HSQLDB is still stored within the database
document aftre the migration. If so, then proposal 2) would perhaps be
unnecessary, but only if there is an easy way to access this content, and the
information how to access it is adequately published. I don't know where, but
the migration process should supply a link or information where to find it.

-- 
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 117090] EDITING: Firebird: migration: View definitions are lost from embedded hsql files using functions unknown to Firebird

[bugzilla-daemon]

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

--- Comment #9 from rob...@familiegrosskopf.de ---
(In reply to Xisco Faulí from comment #8)
> I'm wondering, if we should, at least, warn the users the view definitions
> will be lost if they try to save the database when an error has been
> encountered?

Better would be: Save all views, which couldn't be transformed to
Firebird-views, as queries in direct SQL-mode. So users could change the
functions, which are working in another way/with other name in Firebird.
Afterwards you could be able to take this queries and define the views.

-- 
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 117090] EDITING: Firebird: migration: View definitions are lost from embedded hsql files using functions unknown to Firebird

[bugzilla-daemon]

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

--- Comment #8 from Xisco Faulí  ---
I'm wondering, if we should, at least, warn the users the view definitions will
be lost if they try to save the database when an error has been encountered?

-- 
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 117090] EDITING: Firebird: migration: View definitions are lost from embedded hsql files using functions unknown to Firebird

[bugzilla-daemon]

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

--- Comment #7 from Lionel Elie Mamane  ---
Yes, there is an existing parsing mechanism!
connectivity/source/parse/

-- 
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 117090] EDITING: Firebird: migration: View definitions are lost from embedded hsql files using functions unknown to Firebird

[bugzilla-daemon]

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

Julien Nabet  changed:

   What|Removed |Added

 CC||lio...@mamane.lu,
   ||serval2...@yahoo.fr

--- Comment #6 from Julien Nabet  ---
Just for curiosity, would it be ok to detect the presence of CONCAT (as a
function, not as a variable called CONCAT1 for example) and display a warning
message inviting the user to change CONCAT syntax to || syntax before
migrating?

Indeed, replacing CONCAT syntax with || syntax is not easy since:
- you can have imbricated CONCAT => recursive algo
- you can have some spaces before/after concat, parenthesis, ...
- you can have values named 
- you must find matching end parenthesis of the beginning parenthesis of the
CONCAT
I found some algo which are not straightforward and that they don't even take
into account parenthesis as values + deal with values declared with quote or
double quotes: eg :
CONCAT(a, ')', CONCAT(b, ")", c))

Unless there's an existing parsing mechanism to call which would already know
how to deal with all 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 117090] EDITING: Firebird: migration: View definitions are lost from embedded hsql files using functions unknown to Firebird

[bugzilla-daemon]

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

--- Comment #5 from Tamas Bunth  ---
Sorry, I posted to the wrong bug.

-- 
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 117090] EDITING: Firebird: migration: View definitions are lost from embedded hsql files using functions unknown to Firebird

[bugzilla-daemon]

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

--- Comment #4 from Tamas Bunth  ---
This can be related:

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

-- 
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 117090] EDITING: Firebird: migration: View definitions are lost from embedded hsql files using functions unknown to Firebird

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

   Keywords||bibisected, bisected
 CC||xiscofa...@libreoffice.org

--- Comment #3 from Xisco Faulí  ---
The error message started to be shown after

author  Tamas Bunth    2018-04-14 20:56:26
+0200
committer   Tamás Bunth  2018-04-15 21:29:02 +0200
commit  098b84ff26212d5bee30f16848fac90d061e8b14 (patch)
tree4726d2fe470207e48222621129bbbe886601b073
parent  22cfac8edeb3371e458b9f9533478c6e5a81287e (diff)
tdf#116954 dbahsql: migrate views too

-- 
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 117090] EDITING: Firebird: migration: View definitions are lost from embedded hsql files using functions unknown to Firebird

[bugzilla-daemon]

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

--- Comment #2 from Gerhard Weydt  ---
I created a comment, but it was lost when I added the attachment (I still have
to learn how bugzilla works). So here is again my comment which the attachment
created in Comment 1 belongs to:
I can confirm the problem with Concat independently for one of my own databases
in
Version: 6.1.0.0.alpha0+
Build ID: 9c4eaa7b81a40d97fe49b85272b40bfeaaf44f86
CPU threads: 4; OS: Windows 10.0; UI render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2018-04-16_03:31:36
Locale: de-DE (de_DE); Calc: group

-- 
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 117090] EDITING: Firebird: migration: View definitions are lost from embedded hsql files using functions unknown to Firebird

[bugzilla-daemon]

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

Gerhard Weydt  changed:

   What|Removed |Added

 CC||gerhard.we...@t-online.de

--- Comment #1 from Gerhard Weydt  ---
Created attachment 141471
  --> https://bugs.documentfoundation.org/attachment.cgi?id=141471=edit
Error message for Concat

-- 
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 117090] EDITING: Firebird: migration: View definitions are lost from embedded hsql files using functions unknown to Firebird

[bugzilla-daemon]

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

V Stuart Foote  changed:

   What|Removed |Added

 Blocks|116944  |116968


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=116944
[Bug 116944] Firebird-migration must happen only after user consent and advise
to backup data prior to migration at 6.1
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 117090] EDITING: Firebird: migration: View definitions are lost from embedded hsql files using functions unknown to Firebird

[bugzilla-daemon]

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

V Stuart Foote  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||btom...@gmail.com,
   ||vstuart.fo...@utsa.edu
 Blocks||116944
Summary|EDITING: firebird:  |EDITING: Firebird:
   |migration: View definitions |migration: View definitions
   |are lost from embedded hsql |are lost from embedded hsql
   |files with unknown  |files using functions
   |functions   |unknown to Firebird
 Ever confirmed|0   |1


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=116944
[Bug 116944] Firebird-migration must happen only after user consent and advise
to backup data prior to migration at 6.1
-- 
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