[Firebird-devel] [FB-Tracker] Created: (CORE-6352) libtommath library cant be found / installation abort
libtommath library cant be found / installation abort -- Key: CORE-6352 URL: http://tracker.firebirdsql.org/browse/CORE-6352 Project: Firebird Core Issue Type: Bug Components: Installation Affects Versions: 4.0 Beta 2 Environment: Virtual machine Ubuntu 20.04 x86_64 / Installation Firebird4.0 beta Reporter: Fredi Niklaus Preparing steps: 1. downlaod package Firebird-4.0.0.1436-Beta1.i686 2. unpacking tar (directory /opt/firebird) The start of sudo ./install.sh ends after "Press Enter to start installation" with "Please install required library 'libtommath' before firebird, after it repeat firebird install" After search in found the issue CORE-5445 and other pages Steps to solve : 1. Installed libtommath (sudo apt-get -y install libtommath1) Checked logs -> no error, (but amd64-Version?) 2. made two new simlink to libtommath.so.1.0.1 (one as /usr/lib/x86_64-linux-gnu/libtommath.so.0 and one as /usr/lib/x86_64-linux-gnu/libtommath.so.1) 3. tried to start installation firebird -> aborted with same error 4. added new simlink to libtommath.so.1.0.1 into installation directory 5. tried to start installation firebird -> aborted with same error As far as i see, these are all options i have. Others told, they are able to run the installation after the simlink's . In my case, the error is still pending. (I never get to the point where i can set a password.) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-6351) Computed field could be wrongly evaluated as NULL
Computed field could be wrongly evaluated as NULL
-
Key: CORE-6351
URL: http://tracker.firebirdsql.org/browse/CORE-6351
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.6
Reporter: Vlad Khorsun
The sample is based on much more complex case sent to me by user privately.
1. Prepare metatada
create table t1
(
id int,
f1 computed by ('abcd'),
f2 computed by ('xyz')
);
commit;
set term ^;
create or alter procedure p_t1 (id int)
returns (val varchar(32))
as
begin
val = 'unknown';
select f2 from t1 where id = :id
into :val;
suspend;
end^
set term ;^
commit;
alter table t1
alter f1 computed by ((select val from p_t1(id)));
alter table t1
alter f2 computed by ('id = ' || id);
commit;
insert into t1 values (1);
commit;
exit;
2. Test OK
select val from p_t1(1);
VAL
id = 1
select * from t1;
ID F1 F2
1 id = 1 id = 1
exit;
3. Test FAIL
select * from t1;
ID F1 F2
1id = 1
select val from p_t1(1);
VAL
exit;
The issue happens when:
- table contains at least two caclulated fields
- first calc field contains expression with PSQL object which used second calc
field
- the table metadata is loaded into metadata cache before metadata of PSQL
object mentioned above
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-6350) gbak does not restore SP with plan, when -I switch used
gbak does not restore SP with plan, when -I switch used --- Key: CORE-6350 URL: http://tracker.firebirdsql.org/browse/CORE-6350 Project: Firebird Core Issue Type: Bug Components: GBAK Affects Versions: 3.0.6 Environment: FB 3.0.3, Windows Server 2008 R2 (Windows 10) Reporter: Anatoliy Schegolskiy When gbak -I used, there is an error appeared, see below. And then the restore database does not contain any stored procedures. Error while parsing procedure HP_INSERT_FIOLIST's BLR. index FIOLIST_NAME1 cannot be used in the specified plan. there is no index FIOLIST_NAME3 for table FIOLIST. unknown ISC error 336330835. I suppose, the reason is usage of plan clause in stored procedure queries. The proposal is to ignore saved query plan in the stored procedure source, when. -I or -M switches used. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
