Created attachment 146702 [details]
Open the form in this database - firebird-error apperars
Open the attached database.
Open the form.
An error appears:
*Dynamic SQL Error
*SQL error code = -206
*At line 1, column 94
Connection to subform is impossible. Works well with LO 220.127.116.11, fails with LO 18.104.22.168 on OpenSUSE 64bit rpm Linux.
Created attachment 146703 [details]
bt from error message
Seeing the bt, it seems the pb concerns parameter substitution.
See https://bugs.documentfoundation.org/show_bug.cgi?id=117053#c15 to fix this.
Confirmed on ubuntu 16.04 x64 with Version: 22.214.171.124.alpha1+
Build ID: 726c18db3215ec74135f51365322a6b531f328af
CPU threads: 2; OS: Linux 4.4; UI render: default; VCL: gtk3;
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2018-11-03_19:38:55
Locale: en-US (en_US.UTF-8); Calc: threaded
Unconfirmed with Version: 126.96.36.199.alpha1+
Build ID: 637d96a25926e299fff5b4cf5a0055b1d171b23b
CPU threads: 2; OS: Linux 4.4; UI render: default; VCL: gtk2;
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-11-17_23:45:59
Locale: en-US (en_US.UTF-8); Calc: group
with 'experimental features' on
(In reply to Julien Nabet from comment #2)
> Seeing the bt, it seems the pb concerns parameter substitution.
> See https://bugs.documentfoundation.org/show_bug.cgi?id=117053#c15 to fix
It will be a problem for every person, which has created forms with subforms with Base before LO 6.1. This will be the normal behaviour for all forms with subforms in Firebird-databases created before LO 6.1. So every old form with subform will fail.
The database has been created with an older LO-version for Base-Handbuch. I have just migrated it with the migration-tool. Then I heard from other people forms with subforms doesn't work since LO 6.1 together with Firebird. So I tested this and could see the problem.
I also created a Firebird-database for an article for Linux magazine. There subforms will work well, because it has been created with Lo 6.1.2
This couldn't be a right fixing of a bug: Set old forms as buggy and let users create new *.odb-files for work around this "fix".
One hint to parameter:
<db:driver-settings db:parameter-name-substitution="true" />
This isn't set when creating a Firebird-file when migrating from an old HSQLDB. It will be set to "false" instead.
Tested with LO 188.8.131.52 and also LO 184.108.40.206.alpha1
(In reply to Robert Großkopf from comment #5)
> One hint to parameter:
> <db:driver-settings db:parameter-name-substitution="true" />
> This isn't set when creating a Firebird-file when migrating from an old
> HSQLDB. It will be set to "false" instead.
> Tested with LO 220.127.116.11 and also LO 18.104.22.168.alpha1
There must be wrong code created in the migration-tool. New created databases don't content any information for
I could delete
in wrong migrated databases and the subforms will work.
This seems to have begun at the below commit.
Adding Cc: to Lionel Elie Mamane ; Could you possibly take a look at this one?
484b7c29140d62210c35713b2bb2a9502155f7f9 is the first bad commit
Author: Jenkins Build User <email@example.com>
Date: Thu Jan 4 12:04:35 2018 +0100
author Lionel Elie Mamane <firstname.lastname@example.org> 2018-01-02 22:49:31 +0100
committer Lionel Elie Mamane <email@example.com> 2018-01-04 07:50:22 +0100
commit a29d97e6ddab8ec002ba9827bd5fc874117712e0 (patch)
parent 1bbadad79d91005dc18a3c1e34de14d02660f6ab (diff)
tdf#104986 move named parameters substitution into generic layer
*** This bug has been marked as a duplicate of bug 117589 ***