[Firebird-devel] [FB-Tracker] Created: (CORE-6345) Server crashes on overflow of division result
Server crashes on overflow of division result - Key: CORE-6345 URL: http://tracker.firebirdsql.org/browse/CORE-6345 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 4.0 Beta 2 Environment: ISQL Version: WI-V4.0.0.2076 Firebird 4.0 Release Candidate 1 Server version: Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V4.0.0.2076 Firebird 4.0 Release Candidate 1" Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V4.0.0.2076 Firebird 4.0 Release Candidate 1/tcp (DESKTOP-E3INAFT)/P16:C" Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V4.0.0.2076 Firebird 4.0 Release Candidate 1/tcp (DESKTOP-E3INAFT)/P16:C" on disk structure version 13.0 Reporter: Simonov Denis Server crashes on overflow of division result SQL> select -922337203685477.5808/-1.0 from rdb$database; DIVIDE = Statement failed, SQLSTATE = 08006 Error reading data from the connection. firebird.log contains the following error entry DESKTOP-E3INAFT Thu Jun 25 19:27:24 2020 Interger overflow. The result of an integer operation caused the most significant bit of the result to carry. This exception will cause the Firebird server to terminate abnormally. -- 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-6191) Broken short C-style cast for literary 'NOW'
Broken short C-style cast for literary 'NOW'
Key: CORE-6191
URL: http://tracker.firebirdsql.org/browse/CORE-6191
Project: Firebird Core
Issue Type: Bug
Affects Versions: 4.0 Beta 1
Environment: windows 7 x64
Reporter: Simonov Denis
select
current_timestamp as t1,
timestamp 'now' as t2,
cast('now' as timestamp) as t3
from rdb$database
Overflow occurred during data type conversion.
conversion error from string "now".
If you comment out the column t2, then it works.
select
current_timestamp as t1,
-- timestamp 'now' as t2,
cast('now' as timestamp) as t3
from rdb$database
--
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-6078) Permissions for create or alter statements are not checked.
Permissions for create or alter statements are not checked. --- Key: CORE-6078 URL: http://tracker.firebirdsql.org/browse/CORE-6078 Project: Firebird Core Issue Type: Bug Components: Security Affects Versions: 3.0.4 Environment: Firebird 3.0.5.33139 Windows x64 Reporter: Simonov Denis create test$user password '123'; -- Unprivileged user -- connect to any database set term ! ; create procedure New_Procedure123 as begin end! set term ; ! --This operation is not defined for system tables. --unsuccessful metadata update. --CREATE PROCEDURE NEW_PROCEDURE123 failed. --There is no privilege for this operation. set term ! ; create or alter procedure New_Procedure123 as begin end! set term ; ! --sucessfull???! -- 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-5471) Add support for parts of the date and time in the clause RANGE window functions
Add support for parts of the date and time in the clause RANGE window functions
---
Key: CORE-5471
URL: http://tracker.firebirdsql.org/browse/CORE-5471
Project: Firebird Core
Issue Type: Improvement
Reporter: Simonov Denis
Priority: Minor
Currently RANGE clause supports only numeric values for PRECEDING and FOLLOWING
borders. However, if an expression in the ORDER BY clause is a type of
TIMESTAMP is difficult to set any interval except for days.
Example 1. Interval - 3 days
select
bydate,
total,
sum(total) over w as s_3days
from sales
window w as (order by bydate range between 3 preceding and current row)
Example 2. Interval - 3 hours
select
bydate,
total,
sum(total) over w as s_3hours
from sales
window w as (order by bydate range between 3 * 1.000 / 24 preceding and current
row)
The last example is not very beautiful. Oracle Database uses the following
syntax for time slots.
INTERVAL {YEAR | MONTH | DAY | HOUR | MINUTE | SECOND}
In this case, the second example would look like this
select
bydate,
total,
sum(total) over w as s_3hours
from sales
window w as (order by bydate range between interval 3 hour preceding and
current row)
--
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
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-5373) Error reuse reference cursor if one of the query field is computed using a subquery
Error reuse reference cursor if one of the query field is computed using a subquery --- Key: CORE-5373 URL: http://tracker.firebirdsql.org/browse/CORE-5373 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0.1 Reporter: Simonov Denis SET SQL DIALECT 3; SET TERM ^ ; CREATE PROCEDURE SP_TESP RETURNS ( RESULT SMALLINT) AS BEGIN SUSPEND; END^ SET TERM ; ^ CREATE TABLE TEST ( ID SMALLINT ); SET TERM ^ ; ALTER PROCEDURE SP_TESP RETURNS ( RESULT SMALLINT) AS begin result = 0; for select t.id,(select t.id+1 from rdb$database) as id_1 from test t as cursor c do begin if (c.id_1 between 0 and 1) then result=1; --if (c.id_1 between 2 and 3) then result=2; -- If uncommented error occurs. end suspend; end^ SET TERM ; ^ COMMIT WORK; If you uncomment the line indicated, the error occurs when compiling procedure: Unsuccessful execution caused by system error that does not preclude successful of subsequent statements. Error while parsing procedure SP_TEST`s BLR. invalid request BLR at offset 181. context already in use (BLR error). The reason to use a subquery (select t.id + 1 from rdb$database), if you remove it or replace the function of error disappears. -- 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 -- Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-5337) Regression: The cursor does not see the changes made earlier in the same executable block.
Regression: The cursor does not see the changes made earlier in the same executable block. -- Key: CORE-5337 URL: http://tracker.firebirdsql.org/browse/CORE-5337 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0.0 Reporter: Simonov Denis WI-V6.3.0.32483 Firebird 3.0 CREATE TABLE TEST ( ID INTEGER NOT NULL, VAL INTEGER NOT NULL ); execute block as begin insert into test (id, val) values (1, 100); insert into test (id, val) values (2, (select val from test where id = 1)); end The insert failed because a column definition includes validation constraints. validation error for column "TEST"."VAL", value "*** null ***". However, here is a code works without error. execute block as declare v integer; begin insert into test (id, val) values (1, 100); select val from test where id = 1 into :v; insert into test (id, val) values (2, :v); end This ticket is related with CORE-3362. -- 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-5304) Regression: Can not restore database with table contains field CHAR(n) and UTF8 character set
Regression: Can not restore database with table contains field CHAR(n) and UTF8
character set
-
Key: CORE-5304
URL: http://tracker.firebirdsql.org/browse/CORE-5304
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0.1, 4.0 Alpha 1
Environment: Windows 7 x64, Firebird 3.0.1.32552
Reporter: Simonov Denis
databases.conf contains
test = d:\fb\fb30\data\test.fdb
{
DefaultDbCachePages = 8K
}
In isql execute
set names utf8;
set sql dialect 3;
create database '127.0.0.1/3051:test'
user 'SYSDBA' password 'masterkey'
page_size 8192
default character set utf8;
create table t(
name char(10)
);
insert into t(name) values(null);
commit;
---
gbak -b -g -V -user SYSDBA -pas masterkey -se 127.0.0.1/3051:service_mgr test
d:\fb\fb30\data\test.dmp
work wothout error
rename test.fdb
--
gbak -c -V -user SYSDBA -pas masterkey -st TD -se 127.0.0.1/3
051:service_mgr d:\fb\fb30\data\test.dmp test
gbak: time delta
gbak:0.000 0.000 opened file d:\fb\fb30\data\test.dmp
gbak:0.001 0.001 transportable backup -- data in XDR format
gbak:0.001 0.000 backup file is compressed
gbak:0.001 0.000 backup version is 10
gbak:0.232 0.231 created database test, page_size 8192 bytes
gbak:0.237 0.004 started transaction
gbak: ERROR:arithmetic exception, numeric overflow, or string truncation
gbak: ERROR:string right truncation
gbak: ERROR:expected length 10, actual 40
gbak: ERROR:gds_$send failed
gbak: ERROR:Exiting before completion due to errors
gbak:Exiting before completion due to errors
If field name has type varchar(10) error not reproduced.
--
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
--
Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-5271) Regression: Can not create large index
Regression: Can not create large index -- Key: CORE-5271 URL: http://tracker.firebirdsql.org/browse/CORE-5271 Project: Firebird Core Issue Type: Bug Affects Versions: 4.0 Initial Environment: Windows 10 x64, WI-T4.0.0.246 Firebird 4.0 Reporter: Simonov Denis set names utf8; create database 'localhost/3054:test' user SYSDBA password 'masterkey' page_size 8192 default character set utf8; create table t1( id int not null, a int ); commit; set term !; execute block as declare i int = 0; begin while (i < 400) do begin insert into t1(id) values(:i); i = i + 1; end end! set term ;! commit; alter table t1 add constraint pk_t1 primary key (id); Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements. sort error. No free space found in temporary directories. operating system directive CreateFile failed. Синтаксическая ошибка в имени файла, имени папки или метке тома. . Empirically found that this error does not occur when you create any index, but only when sorting requires more memory than TempCacheLimit. For example here is a script runs without errors. create table t2( id int not null, a int ); commit; set term !; execute block as declare i int = 0; begin while (i < 4) do -- much smaller number of keys begin insert into t2(id) values(:i); i = i + 1; end end! set term ;! commit; alter table t2 add constraint pk_t2 primary key (id); commit; -- 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 -- What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-5133) "Alter sequence restart with" does not change the initial value
"Alter sequence restart with" does not change the initial value --- Key: CORE-5133 URL: http://tracker.firebirdsql.org/browse/CORE-5133 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0 RC2 Environment: WI-V3.0.0.32342 Firebird 3.0 Release Candidate 2 Reporter: Simonov Denis SQL> create sequence s1 start with 100 increment 2; SQL> show sequences; Generator S1, current value: 100, initial value: 100, increment: 2 SQL> alter sequence s1 restart with 5 increment 3; SQL> show sequences; Generator S1, current value: 5, initial value: 100, increment: 3 initial value should not be changed only if the statement alter sequence s1 restart; -- 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-5128) Allow to specify a prefix protocol for embedded
Allow to specify a prefix protocol for embedded --- Key: CORE-5128 URL: http://tracker.firebirdsql.org/browse/CORE-5128 Project: Firebird Core Issue Type: Improvement Reporter: Simonov Denis Priority: Minor Currently, in the connection string, you can specify one of the protocols work on the network inet, wnet, xnet. It would be nice to be able to specify a prefix to be used only for the embedded protocol without changing the configuration. embed://C:\db\ mydb.fdb -- 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 -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-5117) Firebird embedded hangs and crashes when disconnect if not called fb_shutdown function
Firebird embedded hangs and crashes when disconnect if not called fb_shutdown function -- Key: CORE-5117 URL: http://tracker.firebirdsql.org/browse/CORE-5117 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 2.5.5 Environment: Firebird 2.5.6.26976 and IBExpert Reporter: Simonov Denis -- 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 -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4975) Do not invalidate the package body when [CREATE OR] ALTER PACKAGE did not change the packet header
Do not invalidate the package body when [CREATE OR] ALTER PACKAGE did not change the packet header -- Key: CORE-4975 URL: http://tracker.firebirdsql.org/browse/CORE-4975 Project: Firebird Core Issue Type: Improvement Reporter: Simonov Denis Do not invalidate the package body when [CREATE OR] ALTER PACKAGE did not change the packet header. For example, adding comments or formatting source of the package header should not cause invalidation of the package body. Test: set list on; set term ^; - [ 1:begin ] create package pkg_test as begin procedure sp_test(a int); end ^ --- [ 1:end ] create package body pkg_test as begin procedure sp_test (a int) as begin end end ^ set term ;^ commit; select 'Before ALTER package statement, w/o any changes in it' as msg, p.rdb$package_name, p.rdb$valid_body_flag from rdb$packages p; set term ^; - [ 2:begin ] alter package pkg_test as begin -- My comment procedure sp_test(a int); end ^ --- [ 2:end ] set term ;^ commit; select 'After ALTER package statement, w/o any changes in it' as msg, p.rdb$package_name, p.rdb$valid_body_flag from rdb$packages p; set echo on; Output: ## MSG Before ALTER package statement, w/o any changes in it RDB$PACKAGE_NAME PKG_TEST RDB$VALID_BODY_FLAG 1 MSG After ALTER package statement, w/o any changes in it RDB$PACKAGE_NAME PKG_TEST RDB$VALID_BODY_FLAG 0 <-- Why? This modification should not make the package body invalid. -- 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-4969) Table PLG$USERS and view PLG$VIEW_USERS are not created automatically when you create a SYSDBA with Legacy_UserManager
Table PLG$USERS and view PLG$VIEW_USERS are not created automatically when you
create a SYSDBA with Legacy_UserManager
--
Key: CORE-4969
URL: http://tracker.firebirdsql.org/browse/CORE-4969
Project: Firebird Core
Issue Type: Bug
Components: Security
Affects Versions: 3.0 Beta 2
Environment: Windows 7 x64, Firebird 3.0.0.32060 x64
Reporter: Simonov Denis
Create database with standard Security Database. Then assign it as the Security
Database itself.
test = d:\fb\fb30\data\test.fdb
{
DefaultDbCachePages = 8K
TempCacheLimit = 512M
SecurityDatabase = test
WireCrypt = Enabled
AuthServer = Legacy_Auth
UserManager = Legacy_UserManager
}
And we are trying to initialize the SYSDBA.
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect test user sysdba;
Database: test, User: SYSDBA
SQL> create user sysdba password 'masterkey';
Statement failed, SQLSTATE = 42S02
add record error
-table PLG$VIEW_USERS is not defined
SQL>
OK. Change configuration
test = d:\fb\fb30\data\test.fdb
{
DefaultDbCachePages = 8K
TempCacheLimit = 512M
SecurityDatabase = test
WireCrypt = Enabled
AuthServer = Srp, Legacy_Auth
UserManager = Srp, Legacy_UserManager
}
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect test user sysdba;
Database: test, User: SYSDBA
SQL> create user sysdba password 'masterkey';
SQL> exit;
Trying to connect
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect 'localhost:test' user sysdba password 'masterkey';
Database: 'localhost:test', User: SYSDBA
SQL> set list on;
SQL> select * from sec$users;
Statement failed, SQLSTATE = 42S02
find/display record error
-table PLG$VIEW_USERS is not defined
SQL>
Apparently table PLG$USERS and view PLG$VIEW_USERS are predefined in
security3.fdb, but are not automatically created when initializing sysdba with
Legacy_UserManager.
In addition, we have a side effect - the unavailability SEC$USERS.
--
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-4954) The package procedure with value by default isn't called if this parameter isn't specified.
The package procedure with value by default isn't called if this parameter isn't specified. --- Key: CORE-4954 URL: http://tracker.firebirdsql.org/browse/CORE-4954 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0 Beta 2 Reporter: Simonov Denis set term ^; create package t1 as begin procedure p1(a int, b int = 1); procedure p2; end^ create package body t1 as begin procedure p1(a int, b int) as begin end procedure p2 as begin execute procedure p1(1); end end^ Statement failed, SQLSTATE = 07001 unsuccessful metadata update -CREATE PACKAGE BODY T1 failed -Dynamic SQL Error -Input parameter mismatch for procedure P1 If when calling the "p1" to specify both options, then there is no error. -- 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 -- Full-scale, agent-less Infrastructure Monitoring from a single dashboard Integrate with 40+ ManageEngine ITSM Solutions for complete visibility Physical-Virtual-Cloud Infrastructure monitoring from one console Real user monitoring with APM Insights and performance trend reports Learn More http://pubads.g.doubleclick.net/gampad/clk?id=247754911&iu=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4928) It is not possible to save the connection information in the ON CONNECT trigger, if the connection is created by the gbak
It is not possible to save the connection information in the ON CONNECT trigger, if the connection is created by the gbak - Key: CORE-4928 URL: http://tracker.firebirdsql.org/browse/CORE-4928 Project: Firebird Core Issue Type: Bug Components: Engine, SVCMGR Affects Versions: 3.0 Beta 2 Environment: WI-V3.0.0.32022 Reporter: Simonov Denis recreate table att_log (att_id int, att_name varchar(50), att_user varchar(31), att_addr varchar(25), att_prot varchar(15), att_auth varchar(15), att_dts timestamp default 'now'); commit; set term ^; create or alter trigger trg_connect active on connect as begin in autonomous transaction do insert into att_log(att_id, att_name, att_user, att_addr, att_prot, att_auth) select mon$attachment_id ,mon$attachment_name ,mon$user ,mon$remote_address ,mon$remote_protocol ,mon$auth_method from mon$attachments --where mon$attachment_id = current_connection ; end ^ set term ;^ commit; quit; If you try to make a backup gbak -b localhost/:C:\FBTESTING\qa\fbt-repo\tmp\E30.fdb C:\FBTESTING\qa\fbt-repo\tmp\E30.fbk gbak: ERROR:INSERT operation is not allowed for system table ATT_LOG gbak: ERROR:At trigger 'TRG_CONNECT' line: 4, col: 3 gbak:Exiting before completion due to errors or fbsvcmgr localhost:service_mgr action_backup dbname C:\FBTESTING\qa\fbt-repo\tmp\E30.fdb bkp_file C:\FBTESTING\qa\fbt-repo\tmp\E30.fbk INSERT operation is not allowed for system table ATT_LOG -At trigger 'TRG_CONNECT' line: 4, col: 3 -Exiting before completion due to errors -- 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-4909) The incorrect result HASH / MERGE JOIN in the fields of type VARCHAR with a trailing space
The incorrect result HASH / MERGE JOIN in the fields of type VARCHAR with a
trailing space
--
Key: CORE-4909
URL: http://tracker.firebirdsql.org/browse/CORE-4909
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0 Beta 2, 2.5.4
Reporter: Simonov Denis
RECREATE TABLE T (
V VARCHAR(10),
X INTEGER
);
INSERT INTO T (V, X) VALUES ('ww', 1);
INSERT INTO T (V, X) VALUES ('ww ', 2);
COMMIT;
--CREATE INDEX IDX_T_V ON T(V); -- If you remove the comment behavior changes
select
REPLACE(T1.V, ' ', '0') AS V1,
T1.X AS X1,
REPLACE(T2.V, ' ', '0') AS V2,
T2.X AS X2
from T T1 join T T2 on T1.V = T2.V
Firebird 3.0 Beta 2
PLAN HASH (T2 NATURAL, T1 NATURAL)
V1 X1 V2 X2
ww 1 ww 1
ww0 2 ww0 2
Firebird 2.5.5
PLAN MERGE (SORT (T2 NATURAL), SORT (T1 NATURAL))
V1 X1 V2 X2
ww 1 ww 1
ww0 2 ww0 2
Is replaced by the LEFT JOIN. There is only the optimizer can use NESTED LOOP
select
REPLACE(T1.V, ' ', '0') AS V1,
T1.X AS X1,
REPLACE(T2.V, ' ', '0') AS V2,
T2.X AS X2
from T T1 left join T T2 on T1.V = T2.V
Firebird 3.0 Beta 2 AND 2.5.5
PLAN JOIN (T1 NATURAL, T2 NATURAL)
V1 X1 V2 X2
ww 1 ww 1
ww 1 ww0 2
ww0 2 ww 1
ww0 2 ww0 2
If you uncomment the creation of the index, the result is the same as for a
LEFT JOIN, well, except for the plan.
--
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-4721) Hangs statistics collection by the service manager, if you change the database security in databases.conf
Hangs statistics collection by the service manager, if you change the database
security in databases.conf
-
Key: CORE-4721
URL: http://tracker.firebirdsql.org/browse/CORE-4721
Project: Firebird Core
Issue Type: Bug
Components: SVCMGR
Affects Versions: 3.0 Beta 1
Environment: Windows 7 x64, Firebird 3.0.0.31739 x64
Reporter: Simonov Denis
database.conf
horses = d:\fb\fb30\data\horses.fdb {
TempBlockSize = 2M
TempCacheLimit = 512M
DefaultDbCachePages = 32K
SecurityDatabase = horses
}
d:\fb\fb30>fbsvcmgr localhost:service_mgr user sysdba password masterkey
action_db_stats dbname horses sts_data_pages
Statistics show only the header, and then the server hangs. Download one of the
cores of about 100%.
If we point out when the same security database that set in databases.conf,
then statistics collection occurs normally.
d:\fb\fb30>fbsvcmgr localhost:service_mgr user sysdba password masterkey
expected_db horses action_db_stats dbname horses sts_data_pages
--
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
--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4702) Regression: The order for joining the tables is less than optimal in Firebird 2.x.
Regression: The order for joining the tables is less than optimal in Firebird 2.x. -- Key: CORE-4702 URL: http://tracker.firebirdsql.org/browse/CORE-4702 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0 Beta 1 Reporter: Simonov Denis Priority: Minor CREATE TABLE TRIAL ( CODE_TRIAL INTEGER NOT NULL, CODE_PRIZE INTEGER NOT NULL, BYDATE DATE ); CREATE TABLE PRIZE ( CODE_PRIZE INTEGER NOT NULL, NAMEVARCHAR(70) NOT NULL ); CREATE TABLE TRIAL_LINE ( CODE_TRIAL_LINE INTEGER NOT NULL, CODE_TRIAL INTEGER NOT NULL ); INSERT INTO PRIZE(CODE_PRIZE, NAME) WITH RECURSIVE T (N) AS ( SELECT 1 FROM RDB$DATABASE UNION ALL SELECT N+1 FROM T WHERE N < 1000 ) SELECT N+8000, '' FROM T; COMMIT; INSERT INTO TRIAL(CODE_TRIAL, CODE_PRIZE, BYDATE) WITH RECURSIVE T (N) AS ( SELECT 1 FROM RDB$DATABASE UNION ALL SELECT N+1 FROM T WHERE N < 1000 ) SELECT T1.N + (T2.N-1)*1000, MOD(T1.N, 20)+8001, DATEADD(T1.N DAY TO date '01.01.2000') FROM T T1, T T2 WHERE T1.N + (T2.N-1)*1000 < 10; COMMIT; INSERT INTO TRIAL_LINE(CODE_TRIAL_LINE, CODE_TRIAL) WITH RECURSIVE T (N) AS ( SELECT 1 FROM RDB$DATABASE UNION ALL SELECT N+1 FROM T WHERE N < 1000 ) SELECT T1.N + (T2.N-1)*1000, MOD(T1.N + (T2.N-1)*1000, 8)+1 FROM T T1, T T2 WHERE T1.N + (T2.N-1)*1000 < 15; COMMIT; ALTER TABLE TRIAL ADD CONSTRAINT PK_TRIAL PRIMARY KEY (CODE_TRIAL); ALTER TABLE PRIZE ADD CONSTRAINT PK_PRIZE PRIMARY KEY (CODE_PRIZE); ALTER TABLE TRIAL_LINE ADD CONSTRAINT PK_TRIAL_LINE PRIMARY KEY (CODE_TRIAL_LINE); ALTER TABLE TRIAL_LINE ADD CONSTRAINT FK_TRIAL_LINE_TRIAL FOREIGN KEY (CODE_TRIAL) REFERENCES TRIAL (CODE_TRIAL); ALTER TABLE TRIAL ADD CONSTRAINT FK_TRIAL_PRIZE FOREIGN KEY (CODE_PRIZE) REFERENCES PRIZE (CODE_PRIZE); CREATE INDEX IDX_BYDATE ON TRIAL(BYDATE); SELECT count(*) FROM TRIAL JOIN PRIZE ON PRIZE.CODE_PRIZE = TRIAL.CODE_PRIZE JOIN TRIAL_LINE ON TRIAL_LINE.CODE_TRIAL = TRIAL.CODE_TRIAL WHERE TRIAL.BYDATE between date '01.01.2000' AND date '31.12.2000'; In Firebird 2.5 PLAN JOIN (TRIAL INDEX (IDX_BYDATE), PRIZE INDEX (PK_PRIZE), TRIAL_LINE INDEX (FK_TRIAL_LINE_TRIAL)) COUNT 54751 Current memory = 138716136 Delta memory = 24 Max memory = 138766504 Elapsed time= 0.33 sec Buffers = 16384 Reads = 0 Writes 0 Fetches = 438079 In Firebird 3.0 PLAN JOIN (TRIAL INDEX (IDX_BYDATE), TRIAL_LINE INDEX (FK_TRIAL_LINE_TRIAL), PRIZE INDEX (PK_PRIZE)) COUNT = 54751 Current memory = 145145264 Delta memory = 0 Max memory = 145198152 Elapsed time= 0.432 sec Buffers = 16384 Reads = 0 Writes = 0 Fetches = 511076 -- 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 -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4657) Error when duplicating user in different plug-ins
Error when duplicating user in different plug-ins
-
Key: CORE-4657
URL: http://tracker.firebirdsql.org/browse/CORE-4657
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0 Beta 1
Environment: FB 3.0.0.31529 x64, Windows x64, ISQL
Reporter: Simonov Denis
Priority: Minor
Tried to create a SYSDBA Legacy_UserManager. In firebird.conf set UserManager =
Srp, Legacy_UserManager
In Srp SYSDBA already existed.
c:\Program Files\Firebird\Firebird_3_0>gsec -user sysdba
GSEC> add sysdba -pw masterkey -admin yes
GSEC> quit
SQL> connect 'localhost/3051:test' user 'sysdba' password 'masterkey';
Database: 'localhost/3051:test', User: sysdba
SQL> create user sysdba password 'masterkey' using plugin Legacy_UserManager;
Statement failed, SQLSTATE = 23000
add record error
-violation of PRIMARY or UNIQUE KEY constraint "INTEG_2" on table "PLG$USERS"
-Problematic key value is ("PLG$USER_NAME" = 'SYSDBA')
SQL> commit;
SQL> set list on;
SQL> select * from sec$users;
SEC$USER_NAME SYSDBA
SEC$FIRST_NAME
SEC$MIDDLE_NAME
SEC$LAST_NAME
SEC$ACTIVE
SEC$ADMIN
SEC$DESCRIPTION
SEC$PLUGIN Srp
SEC$USER_NAME SYSDBA
SEC$FIRST_NAME Sql
SEC$MIDDLE_NAME Server
SEC$LAST_NAME Administrator
SEC$ACTIVE
SEC$ADMIN
SEC$DESCRIPTION
SEC$PLUGIN Legacy_UserManager
SQL> show version;
ISQL Version: WI-T3.0.0.31529 Firebird 3.0 Beta 2
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T3.0.0.31529
Firebird 3.0 Beta 2"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T3.0.0.31529
Firebird 3.0 Beta 2/tcp (Den-PC)/P13:C"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T3.0.0.31529
Firebird 3.0 Beta 2/tcp (Den-PC)/P13:C"
on disk structure version 12.0
SQL>
Ie upon user is created and it can even connect via Legacy_Auth, but for some
reason when creating Firebird gives an error.
--
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
--
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4591) Push the predicate into derived tables or CTE with a window function if it uses the column on which the partitioning occurs
Push the predicate into derived tables or CTE with a window function if it uses the column on which the partitioning occurs --- Key: CORE-4591 URL: http://tracker.firebirdsql.org/browse/CORE-4591 Project: Firebird Core Issue Type: Improvement Components: Engine Environment: isql WI-T3.0.0.31385 Firebird 3.0 Beta 1 Reporter: Simonov Denis Push the predicate into derived tables or CTE with a window function if it uses the column on which the partitioning occurs. This is possible because it does not distort the result. The only condition is that all the windows were partitioned on the same columns. CONNECT 'localhost:test' USER 'SYSDBA' PASSWORD 'masterkey'; SET AUTODDL ON; RECREATE TABLE T ( ID INT NOT NULL, A INT ); SET TERM ^; EXECUTE BLOCK AS DECLARE I INT = 100; BEGIN WHILE (I > 0) DO BEGIN INSERT INTO T(ID, A) VALUES (:I, MOD(:I, 31)); I = I - 1; END END^ SET TERM ;^ COMMIT; ALTER TABLE T ADD CONSTRAINT PK_T PRIMARY KEY (ID); CREATE INDEX IDX_T_A ON T(A); SET STAT ON; SET EXPLAIN ON; OUTPUT NULL; WITH DT AS ( SELECT SUM(ID) OVER(PARTITION BY A) AS S, A FROM T ) SELECT S FROM DT WHERE A = 1 ROWS 1; Select Expression -> First N Records -> Filter -> Window -> Record Buffer (record length: 49) -> Sort (record length: 52, key length: 8) -> Window -> Record Buffer (record length: 25) -> Table "T" as "DT T" Full Scan Current memory = 85008912 Delta memory = 51144 Max memory = 153273472 Elapsed time= 5.909 sec Buffers = 16384 Reads = 0 Writes = 0 Fetches = 2026507 WITH DT AS ( SELECT SUM(ID) OVER(PARTITION BY A) AS S, A FROM T WHERE A = 1 ) SELECT S FROM DT ROWS 1; Select Expression -> First N Records -> Window -> Record Buffer (record length: 49) -> Sort (record length: 52, key length: 8) -> Window -> Record Buffer (record length: 25) -> Filter -> Table "T" as "DT T" Access By ID -> Bitmap -> Index "IDX_T_A" Range Scan (full match) Current memory = 85431800 Delta memory = 422888 Max memory = 153273472 Elapsed time= 0.179 sec Buffers = 16384 Reads = 0 Writes = 0 Fetches = 64568 -- 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-4572) Incorrect error for PSQL function when the number of actual arguments does not match the number of formal arguments.
Incorrect error for PSQL function when the number of actual arguments does not
match the number of formal arguments.
Key: CORE-4572
URL: http://tracker.firebirdsql.org/browse/CORE-4572
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 2
Environment: isql, Firebird WI-T3.0.0.31353 Firebird 3.0 Alpha 2
Reporter: Simonov Denis
Priority: Minor
Incorrect error for PSQL function when the number of actual arguments does
not match the number of formal arguments.
There are some functions and procedures.
CREATE OR ALTER FUNCTION GET_MNEMONIC (
AFIELD_NAME TYPE OF COLUMN RDB$TYPES.RDB$FIELD_NAME,
ATYPE TYPE OF COLUMN RDB$TYPES.RDB$TYPE)
RETURNS TYPE OF COLUMN RDB$TYPES.RDB$TYPE_NAME
AS
BEGIN
RETURN(SELECT
RDB$TYPE_NAME
FROM
RDB$TYPES
WHERE RDB$FIELD_NAME = :AFIELD_NAME
AND RDB$TYPE = :ATYPE);
END
CREATE OR ALTER PROCEDURE SP_GET_MNEMONIC (
AFIELD_NAME TYPE OF COLUMN RDB$TYPES.RDB$FIELD_NAME,
ATYPE TYPE OF COLUMN RDB$TYPES.RDB$TYPE)
RETURNS (
OUT TYPE OF COLUMN RDB$TYPES.RDB$TYPE_NAME)
AS
BEGIN
SELECT
RDB$TYPE_NAME
FROM
RDB$TYPES
WHERE RDB$FIELD_NAME = :AFIELD_NAME
AND RDB$TYPE = :ATYPE
INTO :OUT;
END
Use CONNECT or CREATE DATABASE to specify a database
SQL> set names win1251;
SQL> connect 'localhost:test' user 'sysdba' password 'masterkey';
Database: 'localhost:test', User: sysdba
SQL> select get_mnemonic('RDB$FIELD_TYPE', 14) as t from rdb$database;
T
===
TEXT
SQL> EXECUTE PROCEDURE SP_GET_MNEMONIC('RDB$FIELD_TYPE', 14);
OUT
===
TEXT
SQL> select get_mnemonic('RDB$FIELD_TYPE') as t from rdb$database;
Statement failed, SQLSTATE = 39000
invalid request BLR at offset 52
-function GET_MNEMONIC could not be matched
SQL> EXECUTE PROCEDURE SP_GET_MNEMONIC('RDB$FIELD_TYPE');
Statement failed, SQLSTATE = 07001
Dynamic SQL Error
-Input parameter mismatch for procedure SP_GET_MNEMONIC
It seems to me that the error message for PSQL functions should be the
same as for the procedure.
--
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
--
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4566) Incorrect size of the output argument when connection character set does not match the character set of the return argument
Incorrect size of the output argument when connection character set does not
match the character set of the return argument
---
Key: CORE-4566
URL: http://tracker.firebirdsql.org/browse/CORE-4566
Project: Firebird Core
Issue Type: Bug
Components: Charsets/Collation
Affects Versions: 3.0 Alpha 2
Reporter: Simonov Denis
Incorrect size of the output argument when connection character set does not
match the character set of the return argument.
Database created with character set win1251.
CREATE OR ALTER FUNCTION GET_MNEMONIC (
AFIELD_NAME TYPE OF COLUMN RDB$TYPES.RDB$FIELD_NAME,
ATYPE TYPE OF COLUMN RDB$TYPES.RDB$TYPE)
RETURNS TYPE OF COLUMN RDB$TYPES.RDB$TYPE_NAME
AS
begin
RETURN (SELECT RDB$TYPE_NAME
FROM RDB$TYPES
WHERE RDB$FIELD_NAME = :AFIELD_NAME
AND RDB$TYPE = :ATYPE);
end
Use CONNECT or CREATE DATABASE to specify a database
SQL> set names win1251;
SQL> connect 'localhost:test' user 'sysdba' password 'masterkey';
Database: 'localhost:horses', User: sysdba
SQL> select GET_MNEMONIC('MON$SHUTDOWN_MODE', 1) AS MNEMONIC
CON> from rdb$database;
MNEMONIC
==
Statement failed, SQLSTATE = 22001
arithmetic exception, numeric overflow, or string truncation
-string right truncation
-expected length 10, actual 19
SQL> select cast(GET_MNEMONIC('MON$SHUTDOWN_MODE', 1) as varchar(100)) AS
MNEMONIC
CON> from rdb$database;
MNEMONIC
===
MULTI_USER_SHUTDOWN
SQL> SELECT
CON> RDB$TYPE_NAME
CON> FROM
CON> RDB$TYPES
CON> WHERE RDB$FIELD_NAME = 'MON$SHUTDOWN_MODE'
CON> AND RDB$TYPE = 1;
RDB$TYPE_NAME
===
MULTI_USER_SHUTDOWN
--
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
--
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4539) Server does not accept the right plan
Server does not accept the right plan - Key: CORE-4539 URL: http://tracker.firebirdsql.org/browse/CORE-4539 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0 Beta 1 Environment: Windows 7 x64, ISQL Reporter: Simonov Denis Server does not accept the right plan SQL> set plan on; SQL> select count(*) CON> from horse CON> join color on horse.code_color = color.code_color CON> where horse.name = color.name; PLAN JOIN (COLOR NATURAL, HORSE INDEX (HORSE_IDX_NAME)) COUNT 48 add up plan in the previous query SQL> select count(*) CON> from horse CON> join color on horse.code_color = color.code_color CON> where horse.name = color.name CON> PLAN JOIN (COLOR NATURAL, HORSE INDEX (HORSE_IDX_NAME)); Statement failed, SQLSTATE = 42000 index HORSE_IDX_NAME cannot be used in the specified plan SQL> -- 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 -- Slashdot TV. Video for Nerds. Stuff that matters. http://tv.slashdot.org/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4522) DDL permission do not protect against removal BLOB filters
DDL permission do not protect against removal BLOB filters -- Key: CORE-4522 URL: http://tracker.firebirdsql.org/browse/CORE-4522 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0 Alpha 2 Reporter: Simonov Denis It seems that the DLL permissions protects not all objects. In particular, I conducted an experiment on BLOB filters. Creating a new filter is effectively prohibited for any user. But the removal could be unpriveleged user. Probable cause, it seems to me, in a lack of ownership for the filters. Unlike other objects in the system table RDB$FILTERS I did not see the field RDB$OWNER_NAME. Use CONNECT or CREATE DATABASE to specify a database SQL> connect 'localhost:test' user 'sysdba' password 'masterkey'; Database: 'localhost:test', User: sysdba SQL> show version; ISQL Version: WI-T3.0.0.31288 Firebird 3.0 Alpha 2 Server version: Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T3.0.0.31288 Firebird 3.0 Alpha 2" Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T3.0.0.31288 Firebird 3.0 Alpha 2/tcp (Den-PC)/P13:C" Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T3.0.0.31288 Firebird 3.0 Alpha 2/tcp (Den-PC)/P13:C" on disk structure version 12.0 SQL> DECLARE FILTER DESC_FILTER CON> INPUT_TYPE 1 CON> OUTPUT_TYPE -4 CON> ENTRY_POINT 'desc_filter' CON> MODULE_NAME 'FILTERLIB'; SQL> show filters; DESC_FILTER Quit from ISQL. Reconnect in the isql window leads to the crash server (see http://tracker.firebirdsql.org/browse/CORE-4506). Use CONNECT or CREATE DATABASE to specify a database SQL> connect 'localhost:test' user 'test' password 'test'; Database: 'localhost:test', User: test SQL> show filters; DESC_FILTER SQL> drop filter DESC_FILTER; SQL> show filters; There are no filters in this database SQL> show version; ISQL Version: WI-T3.0.0.31288 Firebird 3.0 Alpha 2 Server version: Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T3.0.0.31288 Firebird 3.0 Alpha 2" Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T3.0.0.31288 Firebird 3.0 Alpha 2/tcp (Den-PC)/P13:C" Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T3.0.0.31288 Firebird 3.0 Alpha 2/tcp (Den-PC)/P13:C" on disk structure version 12.0 SQL> DECLARE FILTER DESC_FILTER CON> INPUT_TYPE 1 CON> OUTPUT_TYPE -4 CON> ENTRY_POINT 'desc_filter' CON> MODULE_NAME 'FILTERLIB'; Statement failed, SQLSTATE = 42000 unsuccessful metadata update -DECLARE FILTER DESC_FILTER failed -There is no privilege for this operation SQL> -- 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-4518) Show in trace new counters have been added to the MON$RECORD_STATS
Show in trace new counters have been added to the MON$RECORD_STATS -- Key: CORE-4518 URL: http://tracker.firebirdsql.org/browse/CORE-4518 Project: Firebird Core Issue Type: Improvement Components: TRACEMGR Reporter: Simonov Denis The table MON$RECORD_STATS have added new columns: MON$RECORD_LOCKS MON$RECORD_WAITS MON$RECORD_CONFLICTS MON$VERSION_READS MON$FRAGMENT_READS However, in tracing these statistics not available. Table Natural IndexUpdateInsert Delete Backout Purge Expunge *** RDB$FIELDS2 RDB$RELATION_FIELDS 2 1 RDB$CHARACTER_SETS1 It would be good for the statements to add this information: LOCKS WAITS CONFLICTS VERSIONS FRAGMENTS -- 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-4506) Firebird server crashes when execute command show roles after reconnect
Firebird server crashes when execute command show roles after reconnect --- Key: CORE-4506 URL: http://tracker.firebirdsql.org/browse/CORE-4506 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0 Alpha 2 Environment: Windows 7 x64, ISQL Reporter: Simonov Denis SQL> create database 'localhost:test' user 'sysdba' password 'masterkey'; SQL> show version; ISQL Version: WI-T3.0.0.31272 Firebird 3.0 Alpha 2 Server version: Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T3.0.0.31272 Firebird 3.0 Alpha 2" Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T3.0.0.31272 Firebird 3.0 Alpha 2/tcp (s tation9)/P13:C" Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T3.0.0.31272 Firebird 3.0 Alpha 2/tcp (station9)/P13:C" on disk structure version 12.0 SQL> create user test password 'test'; SQL> create role r1; SQL> show roles; R1 SQL> create database 'localhost:test' user 'test' password 'test'; Commit current transaction (y/n)?y Committing. SQL> show roles; Crash. -- 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 -- Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight - the same software that powers the world's largest code search on Ohloh, the Black Duck Open Hub! Try it now. http://p.sf.net/sfu/bds Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4503) ISQL command SHOW USERS display only me
ISQL command SHOW USERS display only me --- Key: CORE-4503 URL: http://tracker.firebirdsql.org/browse/CORE-4503 Project: Firebird Core Issue Type: Bug Components: ISQL Affects Versions: 3.0 Alpha 2 Environment: Windows 7 x64, Firebird Version: WI-T3.0.0.31258 Firebird 3.0 Alpha 2, SuperServer Reporter: Simonov Denis Priority: Minor Use CONNECT or CREATE DATABASE to specify a database SQL> connect 'localhost:test' user 'sysdba' password 'masterkey'; Database: 'localhost:test', User: sysdba SQL> show users; Users in the database # SYSDBA SQL> set list on; SQL> select * from sec$users; SEC$USER_NAME SYSDBA SEC$FIRST_NAME SEC$MIDDLE_NAME SEC$LAST_NAME SEC$ACTIVE SEC$ADMIN SEC$DESCRIPTION SEC$USER_NAME TEST SEC$FIRST_NAME SEC$MIDDLE_NAME SEC$LAST_NAME SEC$ACTIVE SEC$ADMIN SEC$DESCRIPTION Since FB3 appeared pseudo table sec$users, you can use its commands to show users, rather than service api now. Command will show users could be more. In addition to the user name in the same output FIRST_NAME, MIDDLE_NAME, LAST_NAME, ACTIVE and ADMIN columns. -- 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 -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4477) Field RDB$MAP_TO_TYPE is not present in RDB$TYPES
Field RDB$MAP_TO_TYPE is not present in RDB$TYPES - Key: CORE-4477 URL: http://tracker.firebirdsql.org/browse/CORE-4477 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0 Alpha 2 Reporter: Simonov Denis Priority: Minor Field RDB$MAP_TO_TYPE of tables RDB$AUTH_MAPPING and SEC$GLOBAL_AUTH_MAPPING is not present in RDB$TYPES. -- 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 -- Open source business process management suite built on Java and Eclipse Turn processes into business applications with Bonita BPM Community Edition Quickly connect people, data, and systems into organized workflows Winner of BOSSIE, CODIE, OW2 and Gartner awards http://p.sf.net/sfu/Bonitasoft Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4471) Allow to specify plugin authorization statement EXECUTE STATEMENT
Allow to specify plugin authorization statement EXECUTE STATEMENT
-
Key: CORE-4471
URL: http://tracker.firebirdsql.org/browse/CORE-4471
Project: Firebird Core
Issue Type: Improvement
Components: Engine
Reporter: Simonov Denis
I have a problem with a bunch of 3 and Firebird Firebird 2.5 by operator
EXECUTE STATEMENT.
"335544472: Your user name and password are not defined. Ask your database
administrator to set up a Firebird login."
This occurs because the operator EXECUTE STATEMENT ON EXTERNAL DATA SOURCE
connected via SRP. Of course, you can change the authentication method, but it
will change immediately for the entire database. As I understand MAPPING can
solve the inverse problem (connect to Firebird 2.5 Firebird 3.0), but not the
one that I described. Maybe expand the operator EXECUTE STATEMENT so that it is
possible to specify authorization plugin?
EXECUTE STATEMENT { |: }
[()]
[ON EXTERNAL [DATA SOURCE] ]
[WITH {AUTONOMOUS | COMMON} TRANSACTION]
[USE PLUGIN ]
[AS USER [PASSWORD ]]
[WITH CALLER PRIVILEGES]
--
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
--
HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
Find What Matters Most in Your Big Data with HPCC Systems
Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing & Easy Data Exploration
http://p.sf.net/sfu/hpccsystems
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4451) Allow output to trace explain plan form.
Allow output to trace explain plan form. Key: CORE-4451 URL: http://tracker.firebirdsql.org/browse/CORE-4451 Project: Firebird Core Issue Type: Improvement Components: TRACEMGR Reporter: Simonov Denis Priority: Minor In Firebird 3 the opportunity to view the plan explain the form, but now you can see the trace only Legacy plan. You must add the option to trace configuration to select the form of the plan. -- 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 -- Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4440) isql crash without connect when execute command "show version"
isql crash without connect when execute command "show version" -- Key: CORE-4440 URL: http://tracker.firebirdsql.org/browse/CORE-4440 Project: Firebird Core Issue Type: Bug Components: ISQL Affects Versions: 3.0 Alpha 2 Environment: isql, windows 7 Reporter: Simonov Denis Priority: Minor isql crash without connect when execute command "show version" Use CONNECT or CREATE DATABASE to specify a database SQL> show version; window appears on the completion of Firebird SQL Server when the database connection is established crash does not occur Use CONNECT or CREATE DATABASE to specify a database SQL> connect 'localhost:test' user 'sysdba' password 'masterkey'; Database: 'localhost:test', User: sysdba SQL> show version; ISQL Version: WI-T3.0.0.31144 Firebird 3.0 Alpha 2 Server version: Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T3.0.0.31144 Firebird 3.0 Alpha 2" Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T3.0.0.31144 Firebird 3.0 Alpha 2/tcp (s tation9)/P13:C" Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T3.0.0.31144 Firebird 3.0 Alpha 2/tcp (station9)/P13:C" on disk structure version 12.0 SQL> -- 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 -- Time is money. Stop wasting it! Get your web API in 5 minutes. www.restlet.com/download http://p.sf.net/sfu/restlet Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4428) Make optimizer to consider MIN/MAX optimization when making decision about join order
Make optimizer to consider MIN/MAX optimization when making decision about join order - Key: CORE-4428 URL: http://tracker.firebirdsql.org/browse/CORE-4428 Project: Firebird Core Issue Type: Improvement Reporter: Simonov Denis it's extended ticket CORE-1482 create table t1 ( id int not null ); create table t2 ( id int not null, t1_id int not null ); set term ^; execute block as declare i int; begin i = 1; while (i <= 100) do begin insert into t1(id) values(:i); i = i + 1; end i = 1; while (i < 100) do begin insert into t2(id, t1_id) values(:i, :i / 10 + 1); i = i + 1; end end^ set term ;^ commit; alter table t1 add constraint pk_t1 primary key(id); alter table t2 add constraint pk_t2 primary key(id); alter table t2 add constraint fk_t2_t1 foreign key(t1_id) references t1(id); select min(t1.id) from t1 join t2 on t1.id = t2.t1_id; Select Expression -> Aggregate -> Nested Loop Join (inner) -> Table "T2" Full Scan -> Filter -> Table "T1" Access By ID -> Bitmap -> Index "PK_T1" Unique Scan MIN 1 Current memory = 11621440 Delta memory = 547712 Max memory = 11672536 Elapsed time= 3.302 sec Buffers = 2048 Reads = 11421 Writes = 0 Fetches = 6026958 <-- no good vs select min(t2.id) from t1 join t2 on t1.id = t2.t1_id; Select Expression -> Aggregate -> Nested Loop Join (inner) -> Table "T2" Access By ID -> Index "PK_T2" Full Scan -> Filter -> Table "T1" Access By ID -> Bitmap -> Index "PK_T1" Unique Scan MIN 1 Current memory = 11840168 Delta memory = 1672 Max memory = 11872248 Elapsed time= 0.058 sec Buffers = 2048 Reads = 0 Writes = 0 Fetches = 38 <-- good vs same as 1 query, but much faster select t1.id from t1 join t2 on t1.id = t2.t1_id order by t1.id rows 1; Select Expression -> First N Records -> Nested Loop Join (inner) -> Table "T1" Access By ID -> Index "PK_T1" Full Scan -> Filter -> Table "T2" Access By ID -> Bitmap -> Index "FK_T2_T1" Range Scan (full match) ID 1 Current memory = 11933608 Delta memory = 52288 Max memory = 11933760 Elapsed time= 0.062 sec Buffers = 2048 Reads = 0 Writes = 0 Fetches = 137 <-- good -- 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 -- "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE Instantly run your Selenium tests across 300+ browser/OS combos. Get unparalleled scalability from the best Selenium testing platform available Simple to use. Nothing to install. Get started now for free." http://p.sf.net/sfu/SauceLabs Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4414) Add the ability to specify a default role for deals CREATE / ALTER USER
Add the ability to specify a default role for deals CREATE / ALTER USER --- Key: CORE-4414 URL: http://tracker.firebirdsql.org/browse/CORE-4414 Project: Firebird Core Issue Type: Improvement Components: Engine Reporter: Simonov Denis Priority: Minor Add the ability to specify a default role for deals CREATE / ALTER USER. CREATE USER TEST PASSWORD 'test' DEFAULT ROLE MYROLE; ALTER USER TEST SET DEFAULT ROLE RDB $ ADMIN; This feature is present in such interbase 7.5 and above. This does not contradict the principles of roles, as in the sentence given only one role. This feature combines well with the recently introduced the ability to change roles without reconnecting CORE-1377. However, this does not negate the need for a rights group as an alternative roles. -- 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 -- "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE Instantly run your Selenium tests across 300+ browser/OS combos. Get unparalleled scalability from the best Selenium testing platform available. Simple to use. Nothing to install. Get started now for free." http://p.sf.net/sfu/SauceLabs Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4396) incorrect result query if it is execute through "execute statement"
incorrect result query if it is execute through "execute statement" --- Key: CORE-4396 URL: http://tracker.firebirdsql.org/browse/CORE-4396 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0 Alpha 2 Environment: isql, firebird 3.0.0.31070 Reporter: Simonov Denis Use CONNECT or CREATE DATABASE to specify a database SQL> connect 'localhost/3051:horses' user 'sysdba' password 'masterkey'; Database: 'localhost/3051:horses', User: sysdba SQL> select RDB$RELATION_ID from RDB$RELATIONS order by RDB$RELATION_ID rows 3; RDB$RELATION_ID === 0 1 2 SQL> set term ^; SQL> execute block CON> returns ( CON> id integer CON> ) CON> as CON> begin CON> for execute statement CON> 'select RDB$RELATION_ID from RDB$RELATIONS order by RDB$RELATION_ID rows 3' CON> on external 'localhost/3051:horses' as user 'sysdba' password 'masterkey' CON> into :id CON> do suspend; CON> end^ ID 0 0 0 SQL> set term ;^ SQL> -- 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 -- Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4391) Access violation in fbclient when using Legacy API
Access violation in fbclient when using Legacy API -- Key: CORE-4391 URL: http://tracker.firebirdsql.org/browse/CORE-4391 Project: Firebird Core Issue Type: Bug Components: API / Client Library Affects Versions: 3.0 Alpha 2 Environment: Firebird 3.0.0.31058 Reporter: Simonov Denis Attachments: fbtest.ini, fbtest.zip After changes in Legacy API IBExpert started giving out an error After changes in Legacy API IBExpert started giving out an error in case of the appeal to system tables. For example in case of execution of SQL query select * from rdb$database Access violation at address 6AEA0485 in module 'fbclient.dll'. Read of address 0012 I made a small aaplet with UIB use on Lazarus where it was succeeded to repeat this error -- 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 -- Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4359) non-priviledged user can insert and update rdb$database
non-priviledged user can insert and update rdb$database
---
Key: CORE-4359
URL: http://tracker.firebirdsql.org/browse/CORE-4359
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0 Alpha 2, 3.0 Alpha 1, 2.5.2 Update 1, 2.1.5 Update 1,
2.5.2, 2.1.5, 2.5.1, 2.1.4, 2.5.0, 2.1.3, 2.1.2, 2.1.1, 2.1.0, 2.5.3, 2.1.6
Reporter: Simonov Denis
SQL> connect 'localhost:test' user 'sysdba' password 'masterkey';
Database: 'localhost:test', User: sysdba
SQL> create user bob password 'bob';
SQL> connect 'localhost:test' user 'bob' password 'bob';
Commit current transaction (y/n)?y
Committing.
Database: 'localhost:test', User: bob
SQL> insert into rdb$database(rdb$security_class) values('');<-- Why?
SQL> commit;
SQL> select count(*) from rdb$database;
COUNT
=
2
SQL> delete from rdb$database;
Statement failed, SQLSTATE = 42000
[Firebird-devel] [FB-Tracker] Created: (CORE-4358) DDL_TRIGGER not fire on DDL operator COMMENT ON
DDL_TRIGGER not fire on DDL operator COMMENT ON
---
Key: CORE-4358
URL: http://tracker.firebirdsql.org/browse/CORE-4358
Project: Firebird Core
Issue Type: Improvement
Affects Versions: 3.0 Alpha 2
Reporter: Simonov Denis
DDL_TRIGGER not fire on DDL operator COMMENT ON
CREATE TABLE DDL_LOG (
ID INTEGER NOT NULL,
MOMENT DATE NOT NULL,
USER_NAMEVARCHAR(31) NOT NULL,
EVENT_TYPE VARCHAR(25) NOT NULL,
OBJECT_TYPE VARCHAR(25) NOT NULL,
DDL_EVENTVARCHAR(25) NOT NULL,
OBJECT_NAME VARCHAR(31) NOT NULL,
SQL_TEXT BLOB SUB_TYPE 1 SEGMENT SIZE 80 NOT NULL
);
ALTER TABLE DDL_LOG ADD PRIMARY KEY (ID);
SET TERM ^ ;
CREATE OR ALTER TRIGGER TRIG_DDL_LOG_AFTER
ACTIVE AFTER ANY DDL STATEMENT POSITION 0
AS
BEGIN
INSERT INTO DDL_LOG (ID,
MOMENT,
USER_NAME,
EVENT_TYPE,
OBJECT_TYPE,
DDL_EVENT,
OBJECT_NAME,
SQL_TEXT)
VALUES (NEXT VALUE FOR DDL_SEQ,
CURRENT_TIMESTAMP,
CURRENT_USER,
RDB$GET_CONTEXT('DDL_TRIGGER', 'EVENT_TYPE'),
RDB$GET_CONTEXT('DDL_TRIGGER', 'OBJECT_TYPE'),
RDB$GET_CONTEXT('DDL_TRIGGER', 'DDL_EVENT'),
RDB$GET_CONTEXT('DDL_TRIGGER', 'OBJECT_NAME'),
RDB$GET_CONTEXT('DDL_TRIGGER', 'SQL_TEXT'));
END^
SET TERM ; ^
-
set term ^;
create procedure p1
as
begin
end^
set term ;^
comment on procedure p1 is 'my proc';
drop procedure p1;
ID MOMENT USER_NAME EVENT_TYPE OBJECT_TYPE DDL_EVENT
OBJECT_NAME SQL_TEXT
1 04.03.2014 22:00:42 SYSDBA CREATE PROCEDURE CREATE
PROCEDUREP1
2 04.03.2014 22:00:42 SYSDBA DROP PROCEDURE DROP PROCEDURE
P1
--
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
--
Subversion Kills Productivity. Get off Subversion & Make the Move to Perforce.
With Perforce, you get hassle-free workflows. Merge that actually works.
Faster operations. Version large binaries. Built-in WAN optimization and the
freedom to use Git, Perforce or both. Make the move to Perforce.
http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4344) "no current record for fetch operation" when table inner join procedure inner join table
"no current record for fetch operation" when table inner join procedure inner join table - Key: CORE-4344 URL: http://tracker.firebirdsql.org/browse/CORE-4344 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0 Alpha 2 Environment: isql Reporter: Simonov Denis SET SQL DIALECT 3; SET NAMES WIN1251; CREATE DATABASE 'localhost:d:\fb\fb30\data\test.fdb' USER 'SYSDBA' PASSWORD 'masterkey' PAGE_SIZE 16384 DEFAULT CHARACTER SET WIN1251; CREATE TABLE T ( ID INTEGER NOT NULL, A INTEGER, B INTEGER ); INSERT INTO T (ID, A, B) VALUES (1, 2, 3); INSERT INTO T (ID, A, B) VALUES (2, 1, 3); INSERT INTO T (ID, A, B) VALUES (3, 3, 2); COMMIT WORK; ALTER TABLE T ADD PRIMARY KEY (ID); SET TERM ^ ; CREATE PROCEDURE MYPROC ( A INTEGER, C INTEGER) RETURNS ( B INTEGER) AS begin b = a + c; suspend; end^ SET TERM ; ^ SQL> select t3.* CON> from t t1 CON> join t t2 on t1.id = t2.a CON> left join myproc(t1.a, t2.a) p on 1=1 CON> join t t3 on p.b = t3.b; IDAB 123 123 213 213 SQL> select t3.* CON> from t t1 CON> join t t2 on t1.id = t2.a CON> join myproc(t1.a, t2.a) p on 1=1 CON> join t t3 on p.b = t3.b; IDAB Statement failed, SQLSTATE = 22000 no current record for fetch operation<-- Why? SQL> select p.* CON> from t t1 CON> join t t2 on t1.id = t2.a CON> join myproc(t1.a, t2.a) p on 1=1; B 3 3 6 -- 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 -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4330) not correct result function LAG, if the value OFFSET values are assigned from a table
not correct result function LAG, if the value OFFSET values are assigned from a table --- Key: CORE-4330 URL: http://tracker.firebirdsql.org/browse/CORE-4330 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0 Alpha 2 Reporter: Simonov Denis with t(a, b) as ( select 1, null from rdb$database union all select 2, 1 from rdb$database union all select 3, 2 from rdb$database union all select 4, 3 from rdb$database union all select 5, 2 from rdb$database ) select a, b, lag(a, b) over(order by a) as la from t A B LA 1 2 1 <-- incorrect 3 2 <-- incorrect 4 3 2 <-- incorrect 5 2 3 PostgreSQL return correct result with t(a, b) as ( select 1, null union all select 2, 1 union all select 3, 2 union all select 4, 3 union all select 5, 2 ) select a, b, lag(a, b) over(order by a) as la from t A B LA 1 2 1 1 3 2 1 4 3 1 5 2 3 -- 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 -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4321) ISQL does not destroy the SQL statement
ISQL does not destroy the SQL statement --- Key: CORE-4321 URL: http://tracker.firebirdsql.org/browse/CORE-4321 Project: Firebird Core Issue Type: Bug Components: ISQL Environment: Firebird 3.0.0.30854, isql Reporter: Simonov Denis SQL> connect 'localhost:test' user 'sysdba' password 'masterkey'; Database: 'localhost:test', User: sysdba SQL> select 1 from rdb$database; CONSTANT 1 SQL> select 1 from rdb$database; CONSTANT 1 SQL> select 1 from rdb$database; CONSTANT 1 SQL> select 1 from rdb$database; CONSTANT 1 SQL> select count(*) from mon$statements; COUNT = 5 SQL> commit; SQL> select count(*) from mon$statements; COUNT = 6 SQL> select 1 from rdb$database; CONSTANT 1 SQL> select 1 from rdb$database; CONSTANT 1 SQL> select 1 from rdb$database; CONSTANT 1 SQL> select 1 from rdb$database; CONSTANT 1 SQL> select count(*) from mon$statements; COUNT = 6 SQL> commit; SQL> select count(*) from mon$statements; COUNT = 12 SQL> In Firebird 2.5 query returns always the same value select count(*) from mon$statements; COUNT = 1 -- 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 -- CenturyLink Cloud: The Leader in Enterprise Cloud Services. Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical Workloads, Development Environments & Everything In Between. Get a Quote or Start a Free Trial Today. http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4320) Regression: isql crash when receiving statistics of execution of sql query
Regression: isql crash when receiving statistics of execution of sql query -- Key: CORE-4320 URL: http://tracker.firebirdsql.org/browse/CORE-4320 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0 Alpha 2 Environment: Windows 7 x64, isql, Firebird 3.0.0.30849 x64 Reporter: Simonov Denis c:\Program Files\Firebird\Firebird_3_0>isql Use CONNECT or CREATE DATABASE to specify a database SQL> SET NAMES WIN1251; SQL> CONNECT 'localhost/3051:test' USER 'sysdba' PASSWORD 'masterkey'; Database: 'localhost/3051:test', User: sysdba SQL> SELECT CON> T1_ID AS T1_ID, CON> SUM(ID) AS S CON> FROM T2 CON> GROUP BY 1; T1_ID S = 0 50500 1 49600 2 49700 3 49800 4 49900 5 5 6 50100 7 50200 8 50300 9 50400 SQL> SET STAT ON; SQL> SELECT CON> T1_ID AS T1_ID, CON> SUM(ID) AS S CON> FROM T2 CON> GROUP BY 1; There is a window to terminate the program Firebird SQL Server IBExpert through query is executed and statistics obtained -- 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 -- CenturyLink Cloud: The Leader in Enterprise Cloud Services. Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical Workloads, Development Environments & Everything In Between. Get a Quote or Start a Free Trial Today. http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4318) sub-optimal query execution inside PSQL block using parameters
sub-optimal query execution inside PSQL block using parameters -- Key: CORE-4318 URL: http://tracker.firebirdsql.org/browse/CORE-4318 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0 Alpha 2 Environment: Firebird 3.0.0.30837, isql Reporter: Simonov Denis SET ECHO ON; SET NAMES WIN1251; SET STAT ON; SET COUNT ON; SET AUTODDL ON; CONNECT 'localhost/3051:test' USER 'sysdba' PASSWORD 'masterkey'; CREATE TABLE T1 ( ID INTEGER NOT NULL ); CREATE TABLE T2 ( ID INTEGER NOT NULL, T1_ID INTEGER ); SET TERM ^; EXECUTE BLOCK AS DECLARE VARIABLE I INTEGER = 0; BEGIN WHILE (I < 1000) DO BEGIN I = I + 1; INSERT INTO T2(ID, T1_ID) VALUES(:I, MOD(:I, 10)); MERGE INTO T1 USING ( SELECT MOD(:I, 10) AS F FROM RDB$DATABASE ) SRC ON T1.ID = SRC.F WHEN NOT MATCHED THEN INSERT (ID) VALUES(SRC.F); END END^ SET TERM ;^ COMMIT; ALTER TABLE T1 ADD CONSTRAINT PK_T1 PRIMARY KEY (ID); ALTER TABLE T2 ADD CONSTRAINT PK_T2 PRIMARY KEY (ID); ALTER TABLE T2 ADD CONSTRAINT FK_T2_REF_T1 FOREIGN KEY (T1_ID) REFERENCES T1(ID); WITH T AS ( SELECT T1_ID AS T1_ID, SUM(ID) AS S FROM T2 GROUP BY 1 ) SELECT S FROM T WHERE T1_ID = 1; Select Expression -> Filter -> Aggregate -> Filter -> Table "T T2" Access By ID -> Index "FK_T2_REF_T1" Scan S = 49600 Records affected: 1 Current memory = 279233856 Delta memory = 8600 Max memory = 279289456 Elapsed time= 0.00 sec Buffers = 16384 Reads = 0 Writes 0 Fetches = 310 SET TERM ^; EXECUTE BLOCK RETURNS ( S INTEGER ) AS BEGIN WITH T AS ( SELECT T1_ID AS T1_ID, SUM(ID) AS S FROM T2 GROUP BY 1 ) SELECT S FROM T WHERE T1_ID = 1 INTO :S; SUSPEND; END^ Select Expression -> Singularity Check -> Filter -> Aggregate -> Filter -> Table "T T2" Access By ID -> Index "FK_T2_REF_T1" Scan S 49600 Records affected: 1 Current memory = 279241576 Delta memory = 7720 Max memory = 279289456 Elapsed time= 0.00 sec Buffers = 16384 Reads = 0 Writes 0 Fetches = 310 EXECUTE BLOCK RETURNS ( S INTEGER ) AS DECLARE VARIABLE V INTEGER = 1; BEGIN WITH T AS ( SELECT T1_ID AS T1_ID, SUM(ID) AS S FROM T2 GROUP BY 1 ) SELECT S FROM T WHERE T1_ID = :V INTO :S; SUSPEND; END^ Select Expression -> Singularity Check -> Filter -> Aggregate -> Table "T T2" Access By ID -> Index "FK_T2_REF_T1" Scan S 49600 Records affected: 1 Current memory = 279244168 Delta memory = 2592 Max memory = 279289456 Elapsed time= 0.01 sec Buffers = 16384 Reads = 0 Writes 0 Fetches = 3010 <-- This value is very large EXECUTE BLOCK RETURNS ( S INTEGER ) AS BEGIN WITH T AS ( SELECT T1_ID AS T1_ID, SUM(ID) AS S FROM T2 GROUP BY 1 ) SELECT S FROM T WHERE T1_ID = 1 INTO :S; SUSPEND; END^ Select Expression -> Singularity Check -> Filter -> Aggregate -> Filter -> Table "T T2" Access By ID -> Index "FK_T2_REF_T1" Scan S 49600 Records affected: 1 Current memory = 279242200 Delta memory = -1968 Max memory = 279289456 Elapsed time= 0.00 sec Buffers = 16384 Reads = 0 Writes 0 Fetches = 310 SET TERM ;^ QUIT; -- 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 -- CenturyLink Cloud: The Leader in Enterprise Cloud Services. Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical Workloads, Development Environments & Everything In Between. Get a Quote or Start a Free Trial Today. http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4301) User comment distorts non-ASCII characters
User comment distorts non-ASCII characters -- Key: CORE-4301 URL: http://tracker.firebirdsql.org/browse/CORE-4301 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0 Alpha 1 Environment: windows 7 x86, isql Reporter: Simonov Denis User comment distorts non-ASCII characters c:\Program Files\Firebird\Firebird_3_0>chcp 1251 Текущая кодовая страница: 1251 c:\Program Files\Firebird\Firebird_3_0>isql Use CONNECT or CREATE DATABASE to specify a database SQL> set names win1251; SQL> connect 'localhost/3051:test' user 'sysdba' password 'masterkey'; Database: 'localhost/3051:test', User: sysdba SQL> create table T1(id integer); SQL> commit; SQL> comment on table T1 is 'Моя таблица'; SQL> commit; SQL> select r.rdb$description as descr CON> from rdb$relations r CON> where r.rdb$relation_name = 'T1'; DESCR = 0:3 == DESCR: Моя таблица == SQL> create user user1 password '123'; SQL> commit; SQL> comment on user user1 is 'Новый пользователь'; SQL> commit; SQL> select u.sec$description as descr CON> from sec$users u CON> where u.sec$user_name = 'USER1'; DESCR = 0:5 == DESCR: ?? == SQL> -- 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 -- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4271) Crash engine in case of re-creation of an erratic body of a packet
Crash engine in case of re-creation of an erratic body of a packet
--
Key: CORE-4271
URL: http://tracker.firebirdsql.org/browse/CORE-4271
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 1
Environment: Windows 7 x86
Reporter: Simonov Denis
Use CONNECT or CREATE DATABASE to specify a database
SQL> set names win1251;
SQL> create database 'localhost/3051:d:/interbasedata/3.0/test.fdb' user
'sysdba' password 'masterkey' page_size 8192 DE
FAULT CHARACTER SET WIN1251;
SQL> SET TERM ^;
SQL>
SQL> CREATE OR ALTER PACKAGE PKG_SEQUENCE
CON> AS
CON> BEGIN
CON> PROCEDURE INITIALIZE(MIN_VALUE INTEGER, MAX_VALUE INTEGER, STEP INTEGER);
CON>
CON> FUNCTION GET_CURRENT_VALUE RETURNS INTEGER;
CON>
CON> FUNCTION NEXT_VALUE RETURNS INTEGER;
CON>
CON> FUNCTION IS_END RETURNS BOOLEAN;
CON> END^
SQL>
SQL> RECREATE PACKAGE BODY PKG_SEQUENCE
CON> AS
CON> BEGIN
CON>
CON> FUNCTION GET_MAX RETURNS INTEGER
CON> AS
CON> BEGIN
CON> RETURN CAST(RDB$GET_CONTEXT('USER_SESSION', 'MAX_VALUE') AS INTEGER);
CON> END
CON>
CON> FUNCTION SET_MAX(AVALUE INTEGER) RETURNS INTEGER
CON> AS
CON> BEGIN
CON> RDB$SET_CONTEXT('USER_SESSION', 'MAX_VALUE', AVALUE);
CON> RETURN AVALUE;
CON> END
CON>
CON> FUNCTION GET_MIN RETURNS INTEGER
CON> AS
CON> BEGIN
CON> RETURN CAST(RDB$GET_CONTEXT('USER_SESSION', 'MIN_VALUE') AS INTEGER);
CON> END
CON>
CON> FUNCTION SET_MIN(AVALUE INTEGER) RETURNS INTEGER
CON> AS
CON> BEGIN
CON> RDB$SET_CONTEXT('USER_SESSION', 'MIN_VALUE', AVALUE);
CON> RETURN AVALUE;
CON> END
CON>
CON> FUNCTION GET_STEP RETURNS INTEGER
CON> AS
CON> BEGIN
CON> RETURN CAST(RDB$GET_CONTEXT('USER_SESSION', 'STEP_VALUE') AS INTEGER);
CON> END
CON>
CON> FUNCTION SET_STEP(AVALUE INTEGER) RETURNS INTEGER
CON> AS
CON> BEGIN
CON> RDB$SET_CONTEXT('USER_SESSION', 'STEP_VALUE', AVALUE);
CON> RETURN AVALUE;
CON> END
CON>
CON> FUNCTION GET_CURRENT_VALUE RETURNS INTEGER
CON> AS
CON> BEGIN
CON> RETURN CAST(RDB$GET_CONTEXT('USER_SESSION', 'CURRENT_VALUE') AS
INTEGER);
CON> END
CON>
CON> FUNCTION SET_CURRENT_VALUE(AVALUE INTEGER) RETURNS INTEGER
CON> AS
CON> BEGIN
CON> RDB$SET_CONTEXT('USER_SESSION', 'CURRENT_VALUE', AVALUE);
CON> RETURN AVALUE;
CON> END
CON>
CON> FUNCTION NEXT_VALUE RETURNS INTEGER
CON> AS
CON> BEGIN
CON> IF (NOT IS_END()) THEN
CON> SET_CURRENT_VALUE(GET_CURRENT_VALUE() + GET_STEP());
CON> RETURN GET_CURRENT_VALUE();
CON> END
CON>
CON> FUNCTION IS_END RETURNS BOOLEAN
CON> AS
CON> BEGIN
CON> RETURN GET_CURRENT_VALUE() > GET_MAX();
CON> END
CON>
CON> PROCEDURE INITIALIZE(MIN_VALUE INTEGER, MAX_VALUE INTEGER, STEP INTEGER)
CON> AS
CON> BEGIN
CON> SET_MIN(MIN_VALUE);
CON> SET_MAX(MAX_VALUE);
CON> SET_STEP(STEP);
CON> SET_CURRENT_VALUE(MIN_VALUE);
CON> END
CON>
CON> END^
SQL>
SQL> EXECUTE BLOCK
CON> RETURNS (
CON> OUT INTEGER)
CON> AS
CON> BEGIN
CON> EXECUTE PROCEDURE PKG_SEQUENCE.INITIALIZE(10, 140, 5);
CON> OUT = PKG_SEQUENCE.GET_CURRENT_VALUE();
CON> SUSPEND;
CON> WHILE (NOT PKG_SEQUENCE.IS_END()) DO
CON> BEGIN
CON> OUT = PKG_SEQUENCE.NEXT_VALUE();
CON> SUSPEND;
CON> END
CON> END^
OUT
10
Statement failed, SQLSTATE = 2F000
Cannot execute function IS_END of the unimplemented package PKG_SEQUENCE
-At function 'PKG_SEQUENCE.NEXT_VALUE' line: 60, col: 5
SQL> RECREATE PACKAGE BODY PKG_SEQUENCE
CON> AS
CON> BEGIN
CON>
CON> FUNCTION GET_MAX RETURNS INTEGER
CON> AS
CON> BEGIN
CON> RETURN CAST(RDB$GET_CONTEXT('USER_SESSION', 'MAX_VALUE') AS INTEGER);
CON> END
CON>
CON> FUNCTION SET_MAX(AVALUE INTEGER) RETURNS INTEGER
CON> AS
CON> BEGIN
CON> RDB$SET_CONTEXT('USER_SESSION', 'MAX_VALUE', AVALUE);
CON> RETURN AVALUE;
CON> END
CON>
CON> FUNCTION GET_MIN RETURNS INTEGER
CON> AS
CON> BEGIN
CON> RETURN CAST(RDB$GET_CONTEXT('USER_SESSION', 'MIN_VALUE') AS INTEGER);
CON> END
CON>
CON> FUNCTION SET_MIN(AVALUE INTEGER) RETURNS INTEGER
CON> AS
CON> BEGIN
CON> RDB$SET_CONTEXT('USER_SESSION', 'MIN_VALUE', AVALUE);
CON> RETURN AVALUE;
CON> END
CON>
CON> FUNCTION GET_STEP RETURNS INTEGER
CON> AS
CON> BEGIN
CON> RETURN CAST(RDB$GET_CONTEXT('USER_SESSION', 'STEP_VALUE') AS INTEGER);
CON> END
CON>
CON> FUNCTION SET_STEP(AVALUE INTEGER) RETURNS INTEGER
CON> AS
CON> BEGIN
CON> RDB$SET_CONTEXT('USER_SESSION', 'STEP_VALUE', AVALUE);
CON> RETURN AVALUE;
CON> END
CON>
CON> FUNCTION GET_CURRENT_VALUE RETURNS INTEGER
CON> AS
CON> BEGIN
CON> RETURN CAST(RDB$GET_CONTEXT('USER_SESSION', 'CURRENT_VALUE') AS
INTEGER);
CON> END
CON>
CON> FUNCTION SET_CURRENT_VALUE(AVALUE INTEGER) RETURNS INTEGER
CON> AS
CON> BEGIN
CON> RDB$SET_CONTEXT('USER_SESSION', 'CURRENT_VALUE', A
[Firebird-devel] [FB-Tracker] Created: (CORE-4240) incorrect result recursive query in SQL query if more than one branch bypass
incorrect result recursive query in SQL query if more than one branch bypass
Key: CORE-4240
URL: http://tracker.firebirdsql.org/browse/CORE-4240
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 1
Reporter: Simonov Denis
The following query produces different results on 2.5 and 3.0
[SRC sql]WITH RECURSIVE H
AS (SELECT 1 AS CODE_HORSE,
2 AS CODE_FATHER,
3 AS CODE_MOTHER
FROM RDB$DATABASE
UNION ALL
SELECT 2 AS CODE_HORSE,
4 AS CODE_FATHER,
5 AS CODE_MOTHER
FROM RDB$DATABASE
UNION ALL
SELECT 3 AS CODE_HORSE,
4 AS CODE_FATHER,
5 AS CODE_MOTHER
FROM RDB$DATABASE
UNION ALL
SELECT 4 AS CODE_HORSE,
NULL AS CODE_FATHER,
NULL AS CODE_MOTHER
FROM RDB$DATABASE
UNION ALL
SELECT 5 AS CODE_HORSE,
NULL AS CODE_FATHER,
NULL AS CODE_MOTHER
FROM RDB$DATABASE),
R
AS (SELECT H.CODE_HORSE AS CODE_HORSE,
H.CODE_FATHER AS CODE_FATHER,
H.CODE_MOTHER AS CODE_MOTHER,
CAST('' AS VARCHAR(10)) AS MARK,
0 AS DEPTH
FROM H
WHERE H.CODE_HORSE = 1
UNION ALL
SELECT H.CODE_HORSE AS CODE_HORSE,
H.CODE_FATHER AS CODE_FATHER,
H.CODE_MOTHER AS CODE_MOTHER,
'F' || R.MARK AS MARK,
R.DEPTH + 1 AS DEPTH
FROM R
JOIN H ON R.CODE_FATHER = H.CODE_HORSE
WHERE R.DEPTH < 5
UNION ALL
SELECT H.CODE_HORSE AS CODE_HORSE,
H.CODE_FATHER AS CODE_FATHER,
H.CODE_MOTHER AS CODE_MOTHER,
'M' || R.MARK AS MARK,
R.DEPTH + 1 AS DEPTH
FROM R
JOIN H ON R.CODE_MOTHER = H.CODE_HORSE
WHERE R.DEPTH < 5)
SELECT *
FROM R [/SRC]
Result FB 2.5
[FIXED]CODE_HORSE CODE_FATHER CODE_MOTHER MARK DEPTH
1230
245 F 1
4FF2
5MF2
345 M 1
4FM2
5MM2 [/FIXED]
Result FB 3.0
[FIXED]CODE_HORSE CODE_FATHER CODE_MOTHER MARK DEPTH
1230
245 F 1
4FF2 [/FIXED]
In Firebird 3 result is not correct. Optimizer for some reason does not bypass
second branch of the recursive query.
--
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
--
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4234) run-time error if (f1()) if f1 returns a boolean
run-time error if (f1()) if f1 returns a boolean Key: CORE-4234 URL: http://tracker.firebirdsql.org/browse/CORE-4234 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0 Alpha 1 Reporter: Simonov Denis Use CONNECT or CREATE DATABASE to specify a database SQL> connect 'localhost/3051:horses' user 'sysdba' password 'masterkey'; Database: 'localhost/3051:horses', User: sysdba SQL> set term ^; SQL> execute block CON> returns (c integer) CON> as CON> DECLARE VARIABLE b boolean; CON> DECLARE function f1() returns boolean as CON> begin CON> return true; CON> end CON> begin CON> c = 0; CON> b = f1(); CON> --IF (f1()) THEN c = 1; CON> IF (b) THEN c = 1; CON> suspend; CON> end^ C 1 SQL> execute block CON> returns (c integer) CON> as CON> DECLARE VARIABLE b boolean; CON> DECLARE function f1() returns boolean as CON> begin CON> return true; CON> end CON> begin CON> c = 0; CON> b = f1(); CON> IF (f1()) THEN c = 1; CON> --IF (b) THEN c = 1; CON> suspend; CON> end^ Statement failed, SQLSTATE = 22000 Dynamic SQL Error -SQL error code = -104 -Invalid usage of boolean expression -- 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 -- LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99! 1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/22/13. http://pubads.g.doubleclick.net/gampad/clk?id=64545871&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4229) Bidirectional cursor is not positioned by the first call of FETCH LAST
Bidirectional cursor is not positioned by the first call of FETCH LAST -- Key: CORE-4229 URL: http://tracker.firebirdsql.org/browse/CORE-4229 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0 Alpha 1 Reporter: Simonov Denis Bidirectional cursor is not positioned by the first call of FETCH LAST EXECUTE BLOCK RETURNS ( NAME CHAR(31), RC INT) AS DECLARE C SCROLL CURSOR FOR ( SELECT RDB$FIELD_NAME FROM RDB$FIELDS); BEGIN OPEN C; FETCH FIRST FROM C INTO :NAME; RC = ROW_COUNT; SUSPEND; FETCH LAST FROM C INTO :NAME; RC = ROW_COUNT; SUSPEND; CLOSE C; END Result: NAME RC RDB$VIEW_CONTEXT1 RDB$19775 1 EXECUTE BLOCK RETURNS ( NAME CHAR(31), RC INT) AS DECLARE C SCROLL CURSOR FOR ( SELECT RDB$FIELD_NAME FROM RDB$FIELDS); BEGIN OPEN C; /* FETCH FIRST FROM C INTO :NAME; RC = ROW_COUNT; SUSPEND; */ FETCH LAST FROM C INTO :NAME; RC = ROW_COUNT; SUSPEND; CLOSE C; END Result: NAMERC -- 0 -- 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 -- LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99! 1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13. http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4207) Include COST for statement in mon$statements
Include COST for statement in mon$statements Key: CORE-4207 URL: http://tracker.firebirdsql.org/browse/CORE-4207 Project: Firebird Core Issue Type: Improvement Reporter: Simonov Denis In some cases it would be useful to have an estimate of the cost in a separate column of the table mon$statements. This extends the ticket CORE-2303. This would allow, for example, learn the 10 most costly in terms of cost requests. select * from mon$statements order by mon$statements.mon$cost desc rows 10 -- 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 -- Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4195) Allow connect to external databases, separate from execute statement
Allow connect to external databases, separate from execute statement Key: CORE-4195 URL: http://tracker.firebirdsql.org/browse/CORE-4195 Project: Firebird Core Issue Type: New Feature Reporter: Simonov Denis Priority: Minor The idea is to declare a connection to an external database in PSQL block and use it to execute statement. execute block as declare stt varchar(255) = 'select count(*) from rdb$relations'; declare cnt int; declare i int = 10; declare external source my_ext_source 'localhost:D:\TEST25.fdb' as user 'sysdba' password 'masterke'; begin open my_ext_source; while (i > 0) do begin execute statement (:stt) with autonomous transaction on external my_ext_source into :cnt; i = :i - 1; end close my_ext_source; end This will connect to the database only once, instead of connections and disconnections for each execution execute statement. -- 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 -- Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4181) isql should be able to use the new API
isql should be able to use the new API
--
Key: CORE-4181
URL: http://tracker.firebirdsql.org/browse/CORE-4181
Project: Firebird Core
Issue Type: Improvement
Components: ISQL
Affects Versions: 3.0 Alpha 1
Reporter: Simonov Denis
Priority: Minor
The current version of isql uses the old API. As a result, we have a limit on
the width of the sample in the 64K, and the length of the query. A simple
example demonstrates this:
select lpad('', 3, '1') as f1,
lpad('', 3, '1') as f2,
lpad('', 15000, '1') as f3
from rdb$database
Statement failed, SQLSTATE = 07002
SQL error code = -804
-SQLDA missing or incorrect version, or incorrect number/type of variables
SQL>
In Firebird appeared packages, their body can be quite long. And it turns out
that to run the script through isql to create the package will not work longer
than 64K. Dmitry Yemanov also spoke about the fact that it is desirable that
isql able to dynamically load a library fbclient in order to be able to work
with the old version.
--
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
--
Get 100% visibility into Java/.NET code with AppDynamics Lite!
It's a free troubleshooting tool designed for production.
Get down to code-level detail for bottlenecks, with <2% overhead.
Download for free and get started troubleshooting in minutes.
http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4167) Allow an alternate symbol redirects the flow to create a remote backup
Allow an alternate symbol redirects the flow to create a remote backup -- Key: CORE-4167 URL: http://tracker.firebirdsql.org/browse/CORE-4167 Project: Firebird Core Issue Type: Improvement Affects Versions: 2.5.2 Update 1 Environment: Windows 2008 R2, PowerShell Reporter: Simonov Denis Unfortunately the symbol ">" is reserved PowerShell interpreter. It is redirected to a file stream. Also reserved the symbol ">>". As a consequence, can not write a script remotely copy a database. Here is an example of broken releasenotes creates a backup in PowerShell fbsvcmgr remotehost: service_mgr-user sysdba-password XXX \ action_backup-dbname some.fdb-bkp_file stdout> some.fbk Does not work as an opposite example deployment backup. It is proposed to allow not to write a ">", or instead of writing a certain key word, of course retaining the ability to work with the existing syntax. -- 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 -- Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4160) Exceptions with parameters distort not ASCII characters
Exceptions with parameters distort not ASCII characters
---
Key: CORE-4160
URL: http://tracker.firebirdsql.org/browse/CORE-4160
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 1
Environment: database charset WIN1251
Reporter: Simonov Denis
recreate exception e_incorrect_value 'Некорректное значение @1';
execute block
as
begin
exception e_incorrect_value using('abc');
end
E_INCORRECT_VALUE.
Некорректное значение abc.
It's correct
execute block
as
begin
exception e_incorrect_value using('абв');
end
E_INCORRECT_VALUE.
Некорректное значение абв.
It's incorrect
--
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
--
Get your SQL database under version control now!
Version control is standard for application code, but databases havent
caught up. So what steps can you take to put your SQL databases under
version control? Why should you start doing it? Read more to find out.
http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4149) The rights for sequences in isql aren't displayed
The rights for sequences in isql aren't displayed - Key: CORE-4149 URL: http://tracker.firebirdsql.org/browse/CORE-4149 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0 Alpha 1 Environment: isql Reporter: Simonov Denis Database: 'localhost/3051:horses', User: sysdba SQL> show grant; /* Grant permissions for this database */ GRANT SELECT ON AGE TO PUBLIC SQL> grant usage on sequence age_gen to public; SQL> show grant; /* Grant permissions for this database */ GRANT SELECT ON AGE TO PUBLIC -- 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 -- See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4131) Error when processing an empty data set by window function, if reading indexed
Error when processing an empty data set by window function, if reading indexed -- Key: CORE-4131 URL: http://tracker.firebirdsql.org/browse/CORE-4131 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0 Initial Environment: Firebird 3.0.0.30472 x86 Windows 7 x86 Reporter: Simonov Denis when execute sql query select row_number() over(order by f.rdb$field_name) as rn, f.rdb$field_name as name from rdb$fields f where f.rdb$field_name = '00' Error message: The cursor identified in the UPDATE or DELETE statement is not positioned on a row. no current record for fetch operation. when execute sql query (non index read) select row_number() over(order by f.RDB$QUERY_NAME) as rn, f.RDB$QUERY_NAME as name from rdb$fields f where f.RDB$QUERY_NAME = 'ddd' Result is correct. RN NAME --- NULLNULL -- 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 -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4119) In compilation time of stored procedures not ASCII characters are distorted
In compilation time of stored procedures not ASCII characters are distorted Key: CORE-4119 URL: http://tracker.firebirdsql.org/browse/CORE-4119 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0 Initial Reporter: Simonov Denis In compilation time of stored procedures not ASCII characters are distorted c:\Program Files\Firebird\Firebird_3_0>isql Use CONNECT or CREATE DATABASE to specify a database SQL> set names win1251; SQL> create database 'localhost/3051:d:\interbasedata\3.0\test.fdb' user 'sysdba' password 'masterkey' default character set win1251; SQL> set term ^; SQL> create procedure myproc CON> as CON> begin CON> -- Моя процедура CON> end^ SQL> set term ;^ SQL> show procedure myproc; Procedure text: = begin -- Р?ВRРї Р+Р°ВRР¶Т?В¤Р?а end = Version 2.5.2 work is correct -- 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 -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4116) SIMILAR TO generates an error when the correct pattern
SIMILAR TO generates an error when the correct pattern
--
Key: CORE-4116
URL: http://tracker.firebirdsql.org/browse/CORE-4116
Project: Firebird Core
Issue Type: Bug
Affects Versions: 2.5.2 Update 1
Reporter: Simonov Denis
SELECT
CASE
WHEN '1.02,7' SIMILAR TO '[0-9]{1,2}\.[0-9]{2},[0-9]{1,2}' ESCAPE '\'
THEN 1
ELSE 0
END AS B
FROM RDB$DATABASE
Invalid String.
Invalid ESCAPE sequence.
if execute query
SELECT
CASE
WHEN '1.02,7' SIMILAR TO '[0-9]{1,2}\([0-9]{2},[0-9]{1,2}' ESCAPE '\'
THEN 1
ELSE 0
END AS B
FROM RDB$DATABASE
B
---
1 -- it's correct
--
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
--
This SF.net email is sponsored by Windows:
Build for Windows Store.
http://p.sf.net/sfu/windows-dev2dev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4108) Firebird crash when executing sql query "delete from mytable order by id desc rows 10"
Firebird crash when executing sql query "delete from mytable order by id desc rows 10" --- Key: CORE-4108 URL: http://tracker.firebirdsql.org/browse/CORE-4108 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0 Initial Environment: Windows 7 x86 IBExpert, isql Firebird 3.0.0.30431 Reporter: Simonov Denis Firebird crash when executing sql query CREATE TABLE MYTABLE ( IDINTEGER NOT NULL PRIMARY KEY, NAME VARCHAR(30) ); insert into mytable(id, name) select 1, 'a' from rdb$database union all select 2, 'b' from rdb$database union all select 3, 'c' from rdb$database; delete from mytable order by id desc rows 2; Statement failed, SQLSTATE = 08006 Error reading data from the connection. for 2.5.2 it works correctly -- 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 -- Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET Get 100% visibility into your production application - at no cost. Code-level diagnostics for performance bottlenecks with <2% overhead Download for free and get started troubleshooting in minutes. http://p.sf.net/sfu/appdyn_d2d_ap1 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-3943) Mailformed string error in case of the appeal to monitoring tables
Mailformed string error in case of the appeal to monitoring tables -- Key: CORE-3943 URL: http://tracker.firebirdsql.org/browse/CORE-3943 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0 Alpha 1 Environment: Windows 7 x86; Firebird 3.0.0.30085 isql, IBExpert Reporter: Simonov Denis Error in case of the appeal to monitoring tables select * from MON$ATTACHMENTS Invalid token. Malformed string. -- 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 -- Don't let slow site performance ruin your business. Deploy New Relic APM Deploy New Relic app performance management and know exactly what is happening inside your Ruby, Python, PHP, Java, and .NET app Try New Relic at no cost today and get our sweet Data Nerd shirt too! http://p.sf.net/sfu/newrelic-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-3899) row_number(), rank(), dense_rank() return BIGINT datatype in 1 dialect
row_number(), rank(), dense_rank() return BIGINT datatype in 1 dialect -- Key: CORE-3899 URL: http://tracker.firebirdsql.org/browse/CORE-3899 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0 Initial Reporter: Simonov Denis database in 1 dialect select row_number() over() from rdb$database Dynamic SQL Error. SQL error code = -804. Data type unknown. Client SQL dialect 1 does not support reference to BIGINT datatype. -- 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 -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-3883) Ambiguous field name in the trigger when it does a select from the table
Ambiguous field name in the trigger when it does a select from the table Key: CORE-3883 URL: http://tracker.firebirdsql.org/browse/CORE-3883 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0 Initial Reporter: Simonov Denis CREATE TABLE REGTYPE ( CODE_REGTYPE INTEGER NOT NULL, NAME VARCHAR(20), MULTIRECORD SMALLINT ); ALTER TABLE REGTYPE ADD CONSTRAINT PK_REGTYPE PRIMARY KEY (CODE_REGTYPE); CREATE TABLE REG ( CODE_REG INTEGER NOT NULL, CODE_REGTYPE INTEGER, CODE_HORSEINTEGER ); ALTER TABLE REG ADD CONSTRAINT PK_REG PRIMARY KEY (CODE_REG); SET TERM ^ ; /* Trigger: REG_BI0 */ CREATE OR ALTER TRIGGER REG_BI0 FOR REG ACTIVE BEFORE INSERT POSITION 0 AS BEGIN IF (EXISTS(SELECT 1 FROM REG INNER JOIN REGTYPE ON REG.CODE_REGTYPE = REGTYPE.CODE_REGTYPE WHERE REG.CODE_HORSE = NEW.CODE_HORSE AND REG.CODE_REGTYPE = NEW.CODE_REGTYPE AND REGTYPE.MULTIRECORD = 0)) THEN EXCEPTION E_DUPLICATE_REG; END ^ SET TERM ; ^ unsuccessful metadata update. CREATE OR ALTER TRIGGER REG_BI0 failed. Dynamic SQL Error. SQL error code = -204. Ambiguous field name between table REG and table REG . In Firebird 2.5.2 this trigger copile success. -- 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 -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-3880) Derivative tables on the basis of values of constants
Derivative tables on the basis of values of constants - Key: CORE-3880 URL: http://tracker.firebirdsql.org/browse/CORE-3880 Project: Firebird Core Issue Type: New Feature Reporter: Simonov Denis Add support derivative tables on the basis of values of constants SELECT * FROM (VALUES (1, 3), (1, 5)) AS T(A, B) Result: A B 1 3 1 5 -- 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 -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-3816) The explorer of Windows7 crash in attempt to enter into the control panel when Firebird2Control.cpl exists
The explorer of Windows7 crash in attempt to enter into the control panel when Firebird2Control.cpl exists -- Key: CORE-3816 URL: http://tracker.firebirdsql.org/browse/CORE-3816 Project: Firebird Core Issue Type: Bug Affects Versions: 2.0.7, 2.5.1, 2.1.4, 2.5.0, 2.0.6, 2.1.3, 2.1.2, 2.0.5, 2.1.1, 2.1.0 Environment: Windows 7 32bit Firebird 2.0, 2.1, 2.5 Reporter: Simonov Denis The explorer of Windows7 crash in attempt to enter into the control panel when Firebird2Control.cpl exists. After removal from Windows/System32 everything is normal -- 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 -- For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-3798) fb server die when carry out the LEFT + INNER JOIN
fb server die when carry out the LEFT + INNER JOIN -- Key: CORE-3798 URL: http://tracker.firebirdsql.org/browse/CORE-3798 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0 Alpha 1 Environment: Windows 7 32 bit, IBExpert Reporter: Simonov Denis CREATE TABLE TABLE1 ( IDINTEGER NOT NULL, NAME VARCHAR(30), ID_BREED INTEGER ); ALTER TABLE TABLE1 ADD CONSTRAINT PK_TABLE1 PRIMARY KEY (ID); CREATE TABLE TABLE2 ( ID INTEGER NOT NULL, ID_TABLE1 INTEGER ); ALTER TABLE TABLE2 ADD CONSTRAINT PK_TABLE2 PRIMARY KEY (ID); CREATE TABLE TABLE3 ( IDINTEGER NOT NULL, ID_BREED INTEGER ); ALTER TABLE TABLE3 ADD CONSTRAINT PK_TABLE3 PRIMARY KEY (ID); When execute or prepare this query fb server die SELECT TABLE2.ID FROM TABLE2 LEFT JOIN TABLE1 ON TABLE1.ID = TABLE2.ID_TABLE1 INNER JOIN TABLE3 ON TABLE1.ID_BREED = TABLE3.ID_BREED WHERE TABLE1.ID = :ID -- 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 -- This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-3753) The trigger together with the operator MERGE if in a condition of connection ON contains new isn't compiled
The trigger together with the operator MERGE if in a condition of connection ON contains new isn't compiled --- Key: CORE-3753 URL: http://tracker.firebirdsql.org/browse/CORE-3753 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0 Alpha 1 Environment: Windows 7, isql, fb 3.0.0.29768 Reporter: Simonov denis The trigger together with the operator MERGE if in a condition of connection ON contains new isn't compiled CREATE TABLE HORSE ( CODE_HORSE INTEGER NOT NULL, CODE_FATHER INTEGER DEFAULT -2 NOT NULL, CODE_MOTHER INTEGER DEFAULT -3 NOT NULL, NAMEVARCHAR(50) ); ALTER TABLE HORSE ADD CONSTRAINT PK_HORSE PRIMARY KEY (CODE_HORSE); CREATE TABLE COVER ( CODE_COVERINTEGER NOT NULL, CODE_FATHER INTEGER NOT NULL, CODE_MOTHER INTEGER NOT NULL, CODE_HORSEINTEGER NOT NULL ); ALTER TABLE COVER ADD CONSTRAINT PK_COVER PRIMARY KEY (CODE_COVER); ALTER TABLE COVER ADD CONSTRAINT FK_COVER_REF_FATHER FOREIGN KEY (CODE_FATHER) REFERENCES HORSE (CODE_HORSE); ALTER TABLE COVER ADD CONSTRAINT FK_COVER_REF_HORSE FOREIGN KEY (CODE_HORSE) REFERENCES HORSE (CODE_HORSE) ; ALTER TABLE COVER ADD CONSTRAINT FK_COVER_REF_MOTHER FOREIGN KEY (CODE_MOTHER) REFERENCES HORSE (CODE_HORSE); CREATE OR ALTER TRIGGER HORSE_AI FOR HORSE ACTIVE AFTER INSERT POSITION 0 AS BEGIN MERGE INTO COVER USING RDB$DATABASE AS TBL ON COVER.CODE_FATHER = NEW.CODE_FATHER AND COVER.CODE_MOTHER = NEW.CODE_MOTHER WHEN MATCHED THEN UPDATE SET CODE_HORSE = NEW.CODE_HORSE WHEN NOT MATCHED THEN INSERT (CODE_HORSE, CODE_FATHER, CODE_MOTHER) VALUES (NEW.CODE_HORSE, NEW.CODE_FATHER, NEW.CODE_MOTHER); END END^ Error: Statement failed, SQLSTATE = 42S22 unsuccefussful metadata update -CREATE OR ALTER TRIGGER HORSE_AI failed -Dynamic SQL Error -SQL error code = -206 -Column unknown -NEW.CODE_MOTHER On Firebird 2.5 it worked -- 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 -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
