[Firebird-devel] [FB-Tracker] Created: (CORE-5447) EXECUTE STATEMENT when starts with '--' (comment) issues "-Unexpected end of command - line 1, column ", value is invalid (2.5 ...
EXECUTE STATEMENT when starts with '--' (comment) issues "-Unexpected end of command - line 1, column ", value is invalid (2.5 ... 4.0) and can change randomly (only in 3.0, 4.0) - Key: CORE-5447 URL: http://tracker.firebirdsql.org/browse/CORE-5447 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0.1, 2.5.6, 4.0 Initial Reporter: Pavel Zotov Priority: Minor Run following script several times: recreate table test(x int); commit; set term ^; execute block as declare ddl varchar(128); begin ddl = '-- table ''test'' has no trigger, DROP TRIGGER is skipped.'; execute statement ddl; end ^ set term ;^ Output will be: ### FB 2.5 ### C:\FBTESTING\OLTP-EMUL\src>C:\FB\25sC\bin\isql /:e25 -i qq.sql Statement failed, SQLSTATE = 42000 Dynamic SQL Error -SQL error code = -104 -Unexpected end of command - line 1, column 1676729881 -At block line: 5, col: 3 After line 3 in file qq.sql For 2nd and subsequent runs: -Unexpected end of command - line 1, column 1676795417 -Unexpected end of command - line 1, column 1676729881 -Unexpected end of command - line 1, column 1676795417 -Unexpected end of command - line 1, column 1676729881 -Unexpected end of command - line 1, column 1676795417 (then these two numbers are alternated, no more new values) ### FB 4.0 ### C:\FBTESTING\OLTP-EMUL\src>isql /:e40 -i qq.sql Statement failed, SQLSTATE = 42000 Dynamic SQL Error -SQL error code = -104 -Unexpected end of command - line 1, column -106316575 -At block line: 5, col: 3 After line 3 in file qq.sql For 2nd and subsequent runs: -Unexpected end of command - line 1, column -100957727 -Unexpected end of command - line 1, column -105479711 -Unexpected end of command - line 1, column -105414175 -Unexpected end of command - line 1, column -105414175 -Unexpected end of command - line 1, column -95387167 -Unexpected end of command - line 1, column -89030175 (values of column seems to be changed randomly). -- 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 -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-5446) Regression (3.0 and 4.0): 'ALTER TABLE DROP CONSTRAINT , DROP ' can not be done when has reference to column
Regression (3.0 and 4.0): 'ALTER TABLE DROP CONSTRAINT , DROP ' can not be done when has reference to column -- Key: CORE-5446 URL: http://tracker.firebirdsql.org/browse/CORE-5446 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0.1, 4.0 Initial Reporter: Pavel Zotov Run following script (of course, one need to replace "C:\FBTESTING\OLTP-EMUL\src\droptest.fdb" with appropriate string): === shell del C:\FBTESTING\OLTP-EMUL\src\droptest.fdb 2>nul; create database 'localhost:C:\FBTESTING\OLTP-EMUL\src\droptest.fdb'; show version; set echo on; - 1 -- recreate table test(abc int not null); alter table test add foo int, add constraint pkey_for_abc primary key(abc) using index pkey_for_abc ; alter table test drop constraint pkey_for_abc ,drop foo ; commit; - 2 - recreate table test(abc int); alter table test add foo int not null, add constraint pkey_for_foo primary key(foo) using index pkey_for_foo ; commit; connect 'localhost:C:\FBTESTING\OLTP-EMUL\src\droptest.fdb'; alter table test drop constraint pkey_for_foo ,drop foo ; commit; - 3 -- recreate table test(abc int); alter table test add foo int not null, add constraint check_for_foo check(foo>0) ; commit; connect 'localhost:C:\FBTESTING\OLTP-EMUL\src\droptest.fdb'; alter table test drop constraint check_for_foo ,drop foo ; commit; - 4 - recreate table test(abc int); alter table test add foo int not null, add bar int, add constraint pkey_for_foo primary key(foo) using index pkey_for_foo, add constraint fkey_for_bar foreign key(bar) references test(foo) ; commit; connect 'localhost:C:\FBTESTING\OLTP-EMUL\src\droptest.fdb'; alter table test drop constraint fkey_for_bar ,drop constraint pkey_for_foo ; commit; - 5 --- recreate table test(abc int); alter table test add foo int not null, add bar int, add constraint pkey_for_foo primary key(foo) using index pkey_for_foo, add constraint fkey_for_bar foreign key(bar) references test(foo) ; commit; connect 'localhost:C:\FBTESTING\OLTP-EMUL\src\droptest.fdb'; alter table test drop constraint fkey_for_bar ,drop constraint pkey_for_foo ,drop bar ; commit; - 6 -- recreate table test(abc int); alter table test add foo int not null, add bar int, add constraint pkey_for_foo primary key(foo) using index pkey_for_foo, add constraint fkey_for_bar foreign key(bar) references test(foo) ; commit; connect 'localhost:C:\FBTESTING\OLTP-EMUL\src\droptest.fdb'; alter table test drop constraint fkey_for_bar ,drop constraint pkey_for_foo ,drop foo ; commit; === On 2.5.7.27038 no errors will be. On 3.0.2.32664 and 4.0.0.494 all 'ALTER TABLE' statements with dropping constraint which has reference to the field which is ALSO dropped in the same statement (after constraint) will FAIL. For example, test #2 will raise: Statement failed, SQLSTATE = 42000 unsuccessful metadata update -ALTER TABLE TEST failed -CONSTRAINT PKEY_FOR_FOO does not exist. Test #6 will issue: Statement failed, SQLSTATE = 27000 unsuccessful metadata update -ALTER TABLE TEST failed -action cancelled by trigger (1) to preserve data integrity -Cannot delete PRIMARY KEY being used in FOREIGN KEY definition. -At trigger 'RDB$TRIGGER_23' So, one need to 'split' drop such statements (make them run separately), i.e.: === alter table test drop constraint fkey_for_bar ; alter table test drop constraint pkey_for_foo ; alter table test drop foo ; === -- 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 -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Cancelling events
>I was not clear. You send op_cancel_events on main conneciton and > you get response at the same main connection. If you expect close of > secondary (aux) connection - no, it is closed with main one. Thanks. That's what I see from my side as well. -- Mgr. Jiří Činčura Independent IT Specialist -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Cancelling events
10.01.2017 21:29, Jiří Činčura wrote: >>Yes, you should got usual op_response > > I get a response on main connection, not on aux. There should be > something on aux as well? I was not clear. You send op_cancel_events on main conneciton and you get response at the same main connection. If you expect close of secondary (aux) connection - no, it is closed with main one. Hope it is more clear now. Vlad -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Aux connection closed with op_disconnect?
Thanks guys. That will make my life easier, I suppose. :) -- Mgr. Jiří Činčura Independent IT Specialist -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Cancelling events
>Yes, you should got usual op_response I get a response on main connection, not on aux. There should be something on aux as well? -- Mgr. Jiří Činčura Independent IT Specialist -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Aux connection closed with op_disconnect?
10.01.2017 19:22, Jiří Činčura wrote: > Hi *, > > when I call op_disconnect on main connection (the one from which I got > the aux connection details), the aux connection is closed as well. Is > that how it should be? Yes, of course Regards, Vlad -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Aux connection closed with op_disconnect?
On 01/10/17 20:22, Jiří Činčura wrote: > Hi *, > > when I call op_disconnect on main connection (the one from which I got > the aux connection details), the aux connection is closed as well. Is > that how it should be? > Definitely yes. -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Aux connection closed with op_disconnect?
Hi *, when I call op_disconnect on main connection (the one from which I got the aux connection details), the aux connection is closed as well. Is that how it should be? -- Mgr. Jiří Činčura Independent IT Specialist -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Cancelling events
Hi, do I get some response on aux connection after op_cancel_events? -- Mgr. Jiří Činčura Independent IT Specialist -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-5445) Cannot install on Debian Stretch/Testing because version of LibTomMath library
Cannot install on Debian Stretch/Testing because version of LibTomMath library -- Key: CORE-5445 URL: http://tracker.firebirdsql.org/browse/CORE-5445 Project: Firebird Core Issue Type: Bug Components: Installation Affects Versions: 3.0.2 Environment: Debian Stretch/Testing 64bit Reporter: Gabor Boros If try to install the actual snapshot got the next message: "Please install required library 'libtommath' before firebird, after it repeat firebird install" After installed libtommath1 package and try again got this: "/opt/firebird/bin/gsec: error while loading shared libraries: libtommath.so.0: cannot open shared object file: No such file or directory Fatal error running 'systemctl --quiet start firebird-superserver.service' - exiting" The /usr/lib/x86_64-linux-gnu directory contain a libtommath.so.1.0.0 file and a libtommath.so.1 symlink (to libtommath.so.1.0.0) . After create a symlink with name libtommath.so.0 to libtommath.so.1.0.0 can install the snapshot build successfully. -- 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 -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] FB3 - Linux 64bit snapshot install on Debian Stretch/Testing vs LibTomMath
2017. 01. 10. 12:16 keltezéssel, Alex Peshkoff írta: > Must say that I have no idea why was soname changed when actual API and > functions of the library remain backward compatible (in other case your > trick with symlink will not work). But anyway please add a bug to the > tracker - I will fix install. Done. http://tracker.firebirdsql.org/browse/CORE-5445 Gabor -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] FB3 - Linux 64bit snapshot install on Debian Stretch/Testing vs LibTomMath
On 01/10/17 13:47, Gabor Boros wrote: > Hi All, > > When try to install the actual snapshot on Debian Stretch/Testing got > the next message: > > "Firebird 3.0.2.32664-0.amd64 Installation > > Press Enter to start installation or ^C to abort > Please install required library 'libtommath' before firebird, after it > repeat firebird install" > > > After installed libtommath1 package and try again got this: > > "Firebird 3.0.2.32664-0.amd64 Installation > > Press Enter to start installation or ^C to abort > Extracting install data > Created symlink > /etc/systemd/system/multi-user.target.wants/firebird-superserver.service > → /lib/systemd/system/firebird-superserver.service. > Please enter new password for SYSDBA user: masterkey > /opt/firebird/bin/gsec: error while loading shared libraries: > libtommath.so.0: cannot open shared object file: No such file or directory > > Fatal error running 'systemctl --quiet start > firebird-superserver.service' - exiting" > > > The /usr/lib/x86_64-linux-gnu directory contain a libtommath.so.1.0.0 > file and a libtommath.so.1 symlink (to libtommath.so.1.0.0) . After > create a symlink with name libtommath.so.0 to libtommath.so.1.0.0 can > install the snapshot build successfully. Must say that I have no idea why was soname changed when actual API and functions of the library remain backward compatible (in other case your trick with symlink will not work). But anyway please add a bug to the tracker - I will fix install. -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] FB3 - Linux 64bit snapshot install on Debian Stretch/Testing vs LibTomMath
Hi All, When try to install the actual snapshot on Debian Stretch/Testing got the next message: "Firebird 3.0.2.32664-0.amd64 Installation Press Enter to start installation or ^C to abort Please install required library 'libtommath' before firebird, after it repeat firebird install" After installed libtommath1 package and try again got this: "Firebird 3.0.2.32664-0.amd64 Installation Press Enter to start installation or ^C to abort Extracting install data Created symlink /etc/systemd/system/multi-user.target.wants/firebird-superserver.service → /lib/systemd/system/firebird-superserver.service. Please enter new password for SYSDBA user: masterkey /opt/firebird/bin/gsec: error while loading shared libraries: libtommath.so.0: cannot open shared object file: No such file or directory Fatal error running 'systemctl --quiet start firebird-superserver.service' - exiting" The /usr/lib/x86_64-linux-gnu directory contain a libtommath.so.1.0.0 file and a libtommath.so.1 symlink (to libtommath.so.1.0.0) . After create a symlink with name libtommath.so.0 to libtommath.so.1.0.0 can install the snapshot build successfully. Gabor -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel