https://bugs.documentfoundation.org/show_bug.cgi?id=125162
--- Comment #20 from Silvain Dupertuis ---
I have prepared some REGEX transformation commands to solve the problems I have
encountered so that I could made most of the adaptations by handling the
internal text files of the ZIP odb file.
https://bugs.documentfoundation.org/show_bug.cgi?id=125162
Xisco Faulí changed:
What|Removed |Added
CC||xiscofa...@libreoffice.org
https://bugs.documentfoundation.org/show_bug.cgi?id=125162
--- Comment #18 from Robert Großkopf ---
One hint for the problem reported in the bug:
The with { oj } have created by the GUI and HSQLDB. When I create a query
with RIGHT OUTER JOIN in the GUI with Firebird an LO 6.4.3.1 it will
https://bugs.documentfoundation.org/show_bug.cgi?id=125162
--- Comment #17 from Robert Großkopf ---
(In reply to Silvain Dupertuis from comment #16)
> With my present version (6.3.5.2 on Ubuntu 18.04), I no longer see any tool
> to migrate to Firebird and the migration is no longer suggested at
https://bugs.documentfoundation.org/show_bug.cgi?id=125162
--- Comment #16 from Silvain Dupertuis ---
With my present version (6.3.5.2 on Ubuntu 18.04), I no longer see any tool to
migrate to Firebird and the migration is no longer suggested at start-up of a
base document.
As for the problem I
https://bugs.documentfoundation.org/show_bug.cgi?id=125162
Silvain Dupertuis changed:
What|Removed |Added
Ever confirmed|1 |0
https://bugs.documentfoundation.org/show_bug.cgi?id=125162
Silvain Dupertuis changed:
What|Removed |Added
CC||silvain-dupertuis@bluewin.c
https://bugs.documentfoundation.org/show_bug.cgi?id=125162
Alex Thurgood changed:
What|Removed |Added
Ever confirmed|0 |1
https://bugs.documentfoundation.org/show_bug.cgi?id=125162
QA Administrators changed:
What|Removed |Added
Status|NEEDINFO|UNCONFIRMED
Ever
https://bugs.documentfoundation.org/show_bug.cgi?id=125162
--- Comment #13 from QA Administrators ---
[Automated Action] NeedInfo-To-Unconfirmed
--
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing
https://bugs.documentfoundation.org/show_bug.cgi?id=125162
--- Comment #12 from Silvain Dupertuis ---
Created attachment 156098
--> https://bugs.documentfoundation.org/attachment.cgi?id=156098=edit
Example of modifications of a query when migrating to Firebird
--
You are receiving this mail
https://bugs.documentfoundation.org/show_bug.cgi?id=125162
--- Comment #11 from QA Administrators ---
Dear Silvain Dupertuis,
This bug has been in NEEDINFO status with no change for at least
6 months. Please provide the requested information as soon as
possible and mark the bug as UNCONFIRMED.
https://bugs.documentfoundation.org/show_bug.cgi?id=125162
--- Comment #9 from Alex Thurgood ---
@Silvain :
the "{oj" construct is a leftover from ODBC compliant processing.
There used to be a property under Advanced Properties of the database
connection which could be toggled on/off. This
https://bugs.documentfoundation.org/show_bug.cgi?id=125162
--- Comment #10 from Alex Thurgood ---
How to find the advanced configuration tool:
Select Tools->Options->Advanced
Click on "Expert Configuration"
When that dialog opens, enter 'hsqldb' or 'firebird' and click on 'search'
The setting
https://bugs.documentfoundation.org/show_bug.cgi?id=125162
Alex Thurgood changed:
What|Removed |Added
See Also||https://bugs.documentfounda
https://bugs.documentfoundation.org/show_bug.cgi?id=125162
--- Comment #8 from Alex Thurgood ---
I seem to recall that there was a recent-ish change that might have affected
the {OJ} parsing.
--
You are receiving this mail because:
You are the assignee for the
https://bugs.documentfoundation.org/show_bug.cgi?id=125162
Alex Thurgood changed:
What|Removed |Added
Status|UNCONFIRMED |NEEDINFO
Ever confirmed|0
https://bugs.documentfoundation.org/show_bug.cgi?id=125162
Julien Nabet changed:
What|Removed |Added
CC|serval2...@yahoo.fr |
--- Comment #6 from Julien
https://bugs.documentfoundation.org/show_bug.cgi?id=125162
--- Comment #5 from Silvain Dupertuis ---
I meant: works well with the SQL editer, not the graphic editor...
--
You are receiving this mail because:
You are the assignee for the bug.___
https://bugs.documentfoundation.org/show_bug.cgi?id=125162
--- Comment #4 from Silvain Dupertuis ---
Created attachment 151588
--> https://bugs.documentfoundation.org/attachment.cgi?id=151588=edit
Test base with 3 tables and queries with INNER JOINS
The base contains a persones table and a
https://bugs.documentfoundation.org/show_bug.cgi?id=125162
--- Comment #3 from Silvain Dupertuis ---
Migrating to Firbird, transformation of queries with JOIN works well with the
graphic editor:
FROM { oj ... RIGHT OUTER JOIN …}
replaced by
FROM ( oj ... RIGHT OUTER JOIN ...)
But using the
https://bugs.documentfoundation.org/show_bug.cgi?id=125162
--- Comment #2 from Silvain Dupertuis ---
For the FROM { oj ... } but, I tried to apply the regex
search
FROM\s*\{\s*oj([^}]*)\}
replace
FROM (\1)
it works if there is no embedding similar construct
--
You are receiving this mail
https://bugs.documentfoundation.org/show_bug.cgi?id=125162
Julien Nabet changed:
What|Removed |Added
CC||serval2...@yahoo.fr
https://bugs.documentfoundation.org/show_bug.cgi?id=125162
Julien Nabet changed:
What|Removed |Added
Summary|SQL Syntax incorrect for|SQL Syntax incorrect for
24 matches
Mail list logo