[Firebird-devel] [FB-Tracker] Created: (CORE-6544) ambigious column name '...'

2021-04-20 Thread Alexander Muylaert (JIRA)
s me a correct, fast result, while the first one, returns a full table scan. What it should do... But it would have saved us many stupid hours of debugging if the ambiguous warning would have been thrown. A bit like in MS-SQL. kind regards Alexander -- This message is automatically gen

[Firebird-devel] [FB-Tracker] Created: (CORE-6542) Implementation of SUBSTRING for multi-byte character sets is inefficient

2021-04-16 Thread Vlad Khorsun (JIRA)
only then get substring of UTF16 string. This is simple but very inefficient especially for a long strings and small POSITION values. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/sec

[Firebird-devel] [FB-Tracker] Created: (CORE-6541) Restore backup on RawDevice (error during "open O_CREAT" operation for file "/dev/sda1")

2021-04-16 Thread Sascha Michel (JIRA)
ero of=/dev/sda1 bs=32k count=1000 oflag=sync 1000+0 records in 1000+0 records out 32768000 bytes (33 MB, 31 MiB) copied, 0.154765 s, 212 MB/s I have not found any other syntax for "raw devices", is there something new/different here ? -- This message is automatically generated by

[Firebird-devel] [FB-Tracker] Created: (CORE-6540) A way for a replication plugin to refuse attachment

2021-04-15 Thread Dimitry Sibiryakov (JIRA)
ication of this attachment for any reason (configuration option, "bad" user name, etc) with an optional error message. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure

[Firebird-devel] [FB-Tracker] Created: (CORE-6539) Replication plugin can crash engine returning nullptr from startTransaction() method

2021-04-15 Thread Dimitry Sibiryakov (JIRA)
reason) Firebird engine will crash trying to call transaction->tra_replicator->startSavepoint(). IMHO such situation must be handled gracefully by disabling replication of this transaction. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact

[Firebird-devel] [FB-Tracker] Created: (CORE-6538) Add support for Package Body Constants (or even Variables)

2021-04-15 Thread Anderson Farias (JIRA)
MY_LOCAL_VAR; END (...) -- 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] [FB-Tracker] Created: (CORE-6537) Supported replication protocol(s)

2021-04-09 Thread Dimitry Sibiryakov (JIRA)
Versions: 4.0 RC 1 Reporter: Dimitry Sibiryakov It would be good to have a way to find out which protocols (block formats) are supported by IReplicator interface. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the

[Firebird-devel] [FB-Tracker] Reopened: (CORE-6015) Segfault when using expression index with complex expression

2021-04-09 Thread Alexander Peshkov (JIRA)
lculated > which causes expression evaluation, execution of SP and tabke scan - which in > turn causes GC. I.e. we have unlimited recursion with obvious stack overflow > and segfault. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact

[Firebird-devel] [FB-Tracker] Created: (CORE-6536) The Large SQL crashes Firebird Server

2021-04-09 Thread Vadim Mescheryakov (JIRA)
ource. Implementation limit exceeded. block size exceeds implementation restriction." and it stills working -- 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 i

[Firebird-devel] [FB-Tracker] Created: (CORE-6535) View can not be subject of DML if it is declared WITH CHECK OPTION and COMPUTED-BY column present in the this view expression

2021-04-06 Thread Pavel Zotov (JIRA)
CHECK constraint on view or table V_CHECK_OF_MIXED_COLUMNS_SUM -At trigger 'CHECK_6' === Checked on WI-V4.0.0.2406; WI-V3.0.8.33435. PS. I could not find apropriate info in SQL:2011 about this case. Perhaps this is not a bug, so I've set priority to minor. -- This message

[Firebird-devel] [FB-Tracker] Created: (CORE-6534) Hash join cannot match records using some TIME ZONE / DECFLOAT keys

2021-04-05 Thread Dmitry Yemanov (JIRA)
; -- Values are surely equal: CONSTANT 1 select 1 from (select cast('+0' as double precision) as d from rdb$database) natural join (select cast('-0' as double precision) as d from rdb$database); -- OOPS! No record is returned! -- T

[Firebird-devel] [FB-Tracker] Created: (CORE-6533) In Firebird 4 RC1 Round () does not round up more to decimal numbers

2021-04-02 Thread Sergio Cavicchioli (JIRA)
integers No longer behaves like in Firebird 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

[Firebird-devel] [FB-Tracker] Created: (CORE-6532) Results of сoncatenation with blob has no info about collation of source columns (which are declared with such info)

2021-04-02 Thread Pavel Zotov (JIRA)
ffected: 0 ; - set sqlda_display on; select b1 ,b1 || b1 as "b1 || b1" ,c1 || cast(c1 as blob sub_type text character set utf8) collate name_coll as "c1 || cast(c1 as blob)" from test t rows 0; set sqlda_display off; --

[Firebird-devel] [FB-Tracker] Created: (CORE-6531) COMPUTED BY column looses charset and collate of source field when is either of type BLOB or VARCHAR casted to BLOB

2021-04-02 Thread Pavel Zotov (JIRA)
01: sqltype: 520 BLOB Nullable scale: 0 subtype: 1 len: 8 charset: 0 NONE : name: CALC_B1 alias: CALC_B1 : table: TEST owner: SYSDBA 02: sqltype: 520 BLOB Nullable scale: 0 subtype: 1 len: 8 charset: 0 NONE : name: CALC_C1 alias: CALC_C1 : table: TEST owner: SYSDBA Records affected:

[Firebird-devel] [FB-Tracker] Created: (CORE-6530) Comments to SP parameter (typed within SP header declaration) can be lost in metadata extraction script (if parameter is declared *without* DEFAULT o

2021-04-02 Thread Pavel Zotov (JIRA)
or. This "feature" can be considered as inconvenience rather than real bug. -- 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 i

[Firebird-devel] [FB-Tracker] Created: (CORE-6529) Error "no current record for fetch operation" when sorting by a long international string

2021-04-01 Thread Dmitry Yemanov (JIRA)
insert into t select rpad('asd', 1000, '+') from rdb$database; -- no commit here! select f from t order by 1; -- ERROR -- Statement failed, SQLSTATE = 22000 -- no current record for fetch operation -- This message is automatically generated by JIRA. - If you think it was se

[Firebird-devel] [FB-Tracker] Created: (CORE-6528) Connect to database that contains broken pages can lead to FB crash

2021-03-30 Thread Pavel Zotov (JIRA)
characters (near the beginning of file); 2) stack-trace-when-connect-to-broken-DB.7z and dump-when-connect-to-broken-DB.7z -- stack trace and dump when trying to connect to this DB (checked on LI-V4.0.0.2394) -- This message is automatically generated by JIRA. - If you think it was sent

[Firebird-devel] [FB-Tracker] Created: (CORE-6527) Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata

2021-03-28 Thread Pavel Zotov (JIRA)
nd https://github.com/FirebirdSQL/firebird/commit/32e74743f84d4f37c81ff31d6ae8431f7676cdbd -- 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

[Firebird-devel] [FB-Tracker] Created: (CORE-6526) AV in engine when StatementTimeout is active for user statement and some internal DSQL statement was executed as part of overall execution process

2021-03-28 Thread Vlad Khorsun (JIRA)
Zotov with much more complex scenario. -- 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.atlassi

[Firebird-devel] [FB-Tracker] Created: (CORE-6525) segfaults in fbclient

2021-03-26 Thread Alexander Peshkov (JIRA)
Reporter: Alexander Peshkov Des -- 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

[Firebird-devel] [FB-Tracker] Created: (CORE-6524) Various segfaults in fbclient

2021-03-26 Thread Alexander Peshkov (JIRA)
Peshkov This security-sensitive bug was reported to me privately, and I see no use in making it publicly known before release of fixed version and giving people time to upgrade. Details as always in restricted access. -- This message is automatically generated by JIRA. - If you think it was sent

[Firebird-devel] [FB-Tracker] Created: (CORE-6523) Bedpari Escort Bangalore

2021-03-25 Thread Bed Pari (JIRA)
/whitefield-bangalore.html https://www.bedpari.com/escorts-services-mg-road.html -- 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

[Firebird-devel] [FB-Tracker] Created: (CORE-6521) CAST of Infinity values to FLOAT doesn't work

2021-03-24 Thread Lukas Eder (JIRA)
overflow, or > string truncation; numeric value is out of range [SQLState:22003, ISC error > code:335544916] See also this Stack Overflow question: https://stackoverflow.com/q/66763171/521799 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly

[Firebird-devel] [FB-Tracker] Created: (CORE-6520) Invalid time zone (+08). Falling back to displacement

2021-03-22 Thread Basil A. Sidorov (JIRA)
/firebird/bin/fbguard: guardian starting /opt/firebird/bin/firebird vm-centos-7.local Mon Mar 22 17:05:23 2021 Invalid time zone (+08). Falling back to displacement. -- -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the

[Firebird-devel] [FB-Tracker] Created: (CORE-6519) Freeing a statement using DSQL_drop or DSQL_unprepare should send free packet immediately

2021-03-20 Thread Mark Rotteveel (JIRA)
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

[Firebird-devel] [FB-Tracker] Created: (CORE-6518) Wrong message when connecting to tiny trash database file

2021-03-18 Thread Alexander Peshkov (JIRA)
, but page appears encrypted -- 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

[Firebird-devel] [FB-Tracker] Created: (CORE-6517) Regression: CREATE DATABASE fails with 'Token unknown' error when DB name is enclosed in double quotes and 'DEFAULT CHARACTER SET' is specified after

2021-03-17 Thread Pavel Zotov (JIRA)
ne 1, column 17 -"c:\temp\112.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

[Firebird-devel] [FB-Tracker] Created: (CORE-6516) Protect included tomcrypt library from being overwritten by system package

2021-03-16 Thread Alexander Peshkov (JIRA)
fore we include tomcrypt library in 'universal' binaries for linux but it can be easily overwritten with system package. Problematic library should be placed in a way that it will be always used by our binaries instead system one. -- This message is automatically generated by JIRA. -

[Firebird-devel] [FB-Tracker] Created: (CORE-6515) Please allow collation sequence clause in CREATE/ALTER DATABASE statement

2021-03-15 Thread An Pham (JIRA)
with domain is tied to specific length. -- 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] [FB-Tracker] Created: (CORE-6514) "Macro substitution" can add more?

2021-03-11 Thread freeman35 (JIRA)
ebird.conf "Macro substitution" can add more? dir_Pro_I = C:\project\A_1 dir_Pro_II = C:\project\A_2 dir_Pro_IV=C:\project\A_4 etc so can use in database.conf my_db_I = $(dir_Pro_I)/pr_2021.fdb my_db_II = $(dir_Pro_II)/pr_II_abc.fdb regards -- This message is automatically generated by

[Firebird-devel] [FB-Tracker] Created: (CORE-6513) databases.conf line end of char need.

2021-03-11 Thread freeman35 (JIRA)
example ";" so get error. can do this? -- 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/sof

[Firebird-devel] [FB-Tracker] Created: (CORE-6512) DatabaseAccess = Restrict not working

2021-03-11 Thread freeman35 (JIRA)
3.0.7 & firebird 4rc1 -- 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/

[Firebird-devel] [FB-Tracker] Created: (CORE-6511) Allow parenthesized query expression for standard-compliance

2021-03-11 Thread Mark Rotteveel (JIRA)
ing alternative: ``` [ ] [ ] [ ] ``` Adriano wrote the attached patch. -- 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

[Firebird-devel] [FB-Tracker] Created: (CORE-6510) Require exactly correct page size in DPB when creating database, reject wrong values

2021-03-09 Thread Alexander Peshkov (JIRA)
page size. That behavior appera s to be very suspicious - looks like it may cause only problems. -- 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

[Firebird-devel] [FB-Tracker] Created: (CORE-6509) Segfault when gfix requests for database page buffer more memory than available from OS

2021-03-09 Thread Alexander Peshkov (JIRA)
Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 4.0 RC 1 Environment: linux Reporter: Alexander Peshkov gfix -buf {huge-value} any.fdb cause segfault -- This message is automatically generated by JIRA. - If you think it was sent

[Firebird-devel] [FB-Tracker] Created: (CORE-6508) CAST of floating point types yields unnecessary string truncation error and does not conform to SQL standard requirements

2021-03-08 Thread Mark Rotteveel (JIRA)
(10e0 as char(20)) from rdb$database` should produce the string '1.0e1' (or maybe '1e1', but that would not fullfil the " consists of a single that is not '0' (zero), followed by a and an " part of the rule. -- This message is automatically generated by

[Firebird-devel] [FB-Tracker] Created: (CORE-6507) Implement SQL standard FORMAT clause for CAST between string types and datetime types

2021-03-08 Thread Mark Rotteveel (JIRA)
| | | ::= | YYY | YY | Y ::= | RR ::= MM ::= DD ::= DDD ::= HH | HH12 ::= HH24 ::= MI ::= SS ::= S ::= FF1 | FF2 | FF3 | FF4 | FF5 | FF6 | FF7 | FF8 | FF9 ::= A.M. | P.M. ::= TZH ::= TZM "&qu

[Firebird-devel] [FB-Tracker] Created: (CORE-6506) Error in SELECT SUM () of a field of type DECIMAL (18, 6)

2021-03-07 Thread Sergio Cavicchioli (JIRA)
this error: Error: *** IBPP::LogicException *** Context: RowImpl::AllocVariables Message: Found an unknown sqltype ! -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure

[Firebird-devel] [FB-Tracker] Created: (CORE-6505) ISQL is adding an unnecessary COMMIT WORK statement to the extracted metadata script before starting the Stored functions headers/bodies statements

2021-03-06 Thread Luciano Mendes (JIRA)
M_BINTODEC (BIN_NUMBER VARCHAR(63) CHARACTER SET WIN1252) RETURNS BIGINT AS BEGIN END^ SET TERM ; ^ 2- Extract the Metadata script using the ISQL.exe and check all the instructions (see lines 4 and 15 from DDL.SQL attached) -- This message is automatically generated by JIRA. - If you think it was sent

[Firebird-devel] [FB-Tracker] Created: (CORE-6504) Provide same results for date arithmetics when date is changed by values near +/-max(bigint)

2021-03-05 Thread Pavel Zotov (JIRA)
he range for valid dates 2) WI-V3.0.8.33423 C:\FB\30SS>echo set heading off; select date '01.02.2020' + 9223372036854775807 from rdb$database; | isql employee -z 2020-01-31 SQL> C:\FB\30SS>echo set heading off; select date '01.02.2020' - (-9223372036854775808) from rdb$

[Firebird-devel] [FB-Tracker] Created: (CORE-6503) Attempt to create database with page_size >= 65536 leads to createing DB with actual page size = 4k or 8k, but not 32k as it would be

2021-03-05 Thread Pavel Zotov (JIRA)
n/isql -q | grep -i "page_size" Database: /var/tmp/tmp_page_size_4gb.fdb PAGE_SIZE 8192 # echo "create database '/var/tmp/tmp_page_size_4gb.fdb' page_size 4294967297; show database; drop database;" | /var/tmp/fb40tmp/bin/isql -q | grep -i "page_size" Databa

[Firebird-devel] [FB-Tracker] Created: (CORE-6502) Stored procedure isn't able to execute statement 'GRANT'

2021-03-04 Thread Roman Simakov (JIRA)
Bug Affects Versions: 4.0 RC 1 Reporter: Roman Simakov The engine executing GRANT from a stored procedure with SQL SECURITY DEFINER runned from another user with EXECUTE privilege raises the error "User cannot write to RDB$USER_PRIVILEGES" -- This message is automatically ge

[Firebird-devel] [FB-Tracker] Created: (CORE-6501) Segfault when shutting down database which got encrypted by another process

2021-03-03 Thread Alexander Peshkov (JIRA)
ed 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

[Firebird-devel] [FB-Tracker] Created: (CORE-6500) Trace: provide ability to see STATEMENT RESTART events (or their count)

2021-03-02 Thread Pavel Zotov (JIRA)
statement. It will be useful to see this event in the trace log: either like " () EXECUTE_STATEMENT_RESTART" or in statistics table. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.

[Firebird-devel] [FB-Tracker] Created: (CORE-6499) Regression: gstat with switch -t executed via services fails with "found unknown switch" error

2021-02-26 Thread Pavel Cisar (JIRA)
by string containing '-t tablename'. This works just fine with firebird 3.0.5, 3.0.6 and 4.0 Beta 2, but fails on 3.0.7 and 4.0 RC1 with "found unknown switch" error message. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact on

[Firebird-devel] [FB-Tracker] Created: (CORE-6498) Firebird server stops to listen to new connections after error in nbackup service

2021-02-25 Thread Alexander Peshkov (JIRA)
but does not listen on port 3050 any more. -- 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

[Firebird-devel] [FB-Tracker] Created: (CORE-6497) Fb4 RC1 synchronous replication to localhost hang on disconnect

2021-02-24 Thread Lucas Schatz (JIRA)
ot;show table;quit;" | /opt/firebird/bin/isql localhost:/db/primary.fdb #Table is created echo "show table;quit;" | /opt/firebird/bin/isql localhost:/db/replica.fdb #Table is replicated No error in replication.log nor firebird.log -- This message is automatically genera

[Firebird-devel] [FB-Tracker] Created: (CORE-6496) string_to_datetime and '\0' symbol

2021-02-24 Thread Kovalenko Dmitry (JIRA)
at, Firebird can't translate to BOOLEAN the string with '\0' symbol (for example "TRUE\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.

[Firebird-devel] [FB-Tracker] Created: (CORE-6495) string_to_datetime and y2k problem

2021-02-24 Thread Kovalenko Dmitry (JIRA)
oks to the CURRENT year, but adjust the two-digit year number on 1900 or 2000. When current year will be more than 2050, this code will return strange result. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators:

[Firebird-devel] [FB-Tracker] Created: (CORE-6494) Inconsistent translation "string->timestamp->string->timestamp" and first dialect

2021-02-24 Thread Kovalenko Dmitry (JIRA)
))as TIMESTAMP)as varchar(64)) from DUAL RESULT: 2-DEC-1983 -- 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://ww

[Firebird-devel] [FB-Tracker] Created: (CORE-6493) Connecting to DB with any user/password

2021-02-21 Thread Haik Hairapetyan (JIRA)
specify a database Could you please explain the matter? Thank you. -- 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.a

[Firebird-devel] [FB-Tracker] Created: (CORE-6492) Add TIME and TIMESTAMP to EXTRACT to be able to obtain UTC value of WITH TIME ZONE types.

2021-02-21 Thread Mark Rotteveel (JIRA)
STAMP WITHOUT TIME ZONE (current_date + 00:00:00 as time) This solution would be non-standard, but would provide a nice symmetry with EXTRACT(TIMEZONE_HOUR FROM ...) and EXTRACT(TIMEZONE_MINUTE FROM ...) -- This message is automatically generated by JIRA. - If you think it was sent incorrect

[Firebird-devel] [FB-Tracker] Reopened: (CORE-6487) FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last

2021-02-17 Thread Mark Rotteveel (JIRA)
that any > move out of bounds of the result set, will position the cursor immediately > before the first row (position = 0) or immediately after the last row > (position = last + 1). This would also match the behaviour specified in ODBC > for SQLFetchScroll(), and in JDBC for ResultSet.absol

[Firebird-devel] [FB-Tracker] Created: (CORE-6490) Wrong error message when executing ALTER ROLE without ALTER ANY ROLE

2021-02-16 Thread Mark Rotteveel (JIRA)
expect: """ Statement failed, SQLSTATE = 28000 unsuccessful metadata update -ALTER ROLE RDB$ADMIN failed -no permission for ALTER access to ROLE RDB$ADMIN -Effective user is TESTUSER """ -- This message is automatically generated by JIRA. - If you think it was sent

[Firebird-devel] [FB-Tracker] Created: (CORE-6489) User without ALTER ANY ROLE privilege can use COMMENT ON ROLE

2021-02-16 Thread Mark Rotteveel (JIRA)
XYZ failed -no permission for ALTER access to ROLE RDB$ADMIN -Effective user is TESTUSER """ -- 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

[Firebird-devel] [FB-Tracker] Created: (CORE-6488) Event delivery could be missed when local (XNET) protocol is used

2021-02-15 Thread Vlad Khorsun (JIRA)
artificial manipulation by running threads using debugger. It might explain why it was not detected so far, since XNET was introduced. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure

[Firebird-devel] [FB-Tracker] Created: (CORE-6487) FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last

2021-02-15 Thread Mark Rotteveel (JIRA)
ODBC for SQLFetchScroll(), and in JDBC for ResultSet.absolute(int) and ResultSet.relative(int) -- 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

[Firebird-devel] [FB-Tracker] Created: (CORE-6486) FETCH RELATIVE has an off by one error for the first row

2021-02-14 Thread Mark Rotteveel (JIRA)
. Using FETCH RELATIVE 2 FROM c will return (3,1) instead of (2,1). It seems to behave as if the first row was already fetched, but using FETCH RELATIVE 0 FROM c will produce error "Cursor C is not positioned in a valid record". -- This message is automatically generated by JIRA. - If yo

[Firebird-devel] [FB-Tracker] Created: (CORE-6485) Provide time zone ids constants in public headers

2021-02-13 Thread Dimitry Sibiryakov (JIRA)
/ Client Library Reporter: Dimitry Sibiryakov It would be nice if client applications could use named constants working with types with time zones instead of magic numbers. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the

[Firebird-devel] [FB-Tracker] Created: (CORE-6484) Firebird can't count records from a subquery with unnamed column

2021-02-08 Thread JIRA
column name specified for column number 2 in derived table T {code} however, it works fine in other DBMSes, like PostgreSQL, MySQL or even in a non-DBMS, like SQLite. 😕 I'm not Firebird expert, but it sounds like a bug. -- This message is automatically generated by JIRA. - If yo

[Firebird-devel] [FB-Tracker] Created: (CORE-6483) Firebird can't count records from a subquery with unnamed column

2021-02-07 Thread JIRA
column name specified for column number 2 in derived table T {code} however, it works fine in other DBMSes, like PostgreSQL, MySQL or even in a non-DBMS, like SQLite. 😕 I'm not Firebird expert, but it sounds like a bug. -- This message is automatically generated by JIRA. - If yo

[Firebird-devel] [FB-Tracker] Created: (CORE-6482) System table with keywords

2021-02-05 Thread Maxim Kuzmin (JIRA)
(LOCALTIME, SQLSTATE, INSERTING/DELETING/UPDATING). Therefore we need a table of words with the flag "Reserved" and "Reserved in the future". -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tra

[Firebird-devel] [FB-Tracker] Created: (CORE-6481) Dialect 1. Not consistent result of two expressions with divide of NUMERIC with scale

2021-02-02 Thread Kovalenko Dmitry (JIRA)
-- 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 ma

[Firebird-devel] [FB-Tracker] Created: (CORE-6480) Multiple sum query cause ad incorrect SQLDA structure error

2021-02-02 Thread William Pristia (JIRA)
statement. Incorrect values within SQLDA structure. -- 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/

[Firebird-devel] [FB-Tracker] Created: (CORE-6479) COMMENT ON USER can only apply comment on user defined by the default usermanager plugin

2021-01-31 Thread Mark Rotteveel (JIRA)
t; The following will succeed: comment on user test1 is 'comment on user test1'; The following will fail: comment on user test2 is `comment on user test2'; [336723990] [HY000]: Resource Exception. record not found for user: TEST2 -- This message is automatically generated by

[Firebird-devel] [FB-Tracker] Created: (CORE-6478) gbak discard replicate mode

2021-01-30 Thread Dimitry Sibiryakov (JIRA)
Reporter: Dimitry Sibiryakov Priority: Minor gbak neither store nor restore replica mode. As the result it is reset to NONE after backup-restore cycle. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http

[Firebird-devel] [FB-Tracker] Created: (CORE-6477) Rare race condition in Plugin Manager could lead to the server crash

2021-01-28 Thread Vlad Khorsun (JIRA)
: Bug Components: Engine Affects Versions: 3.0.7 Reporter: Vlad Khorsun Attachments: stack.txt -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure

[Firebird-devel] [FB-Tracker] Created: (CORE-6476) Call to Services API on 1st FB instance blocks start of audit session in 2nd FB instance for 130 seconds

2021-01-28 Thread Pavel Zotov (JIRA)
t = Enabled WireCryptPlugin = ChaCha, Arc4 = Config file for 2nd FB: = AuditTraceConfigFile = "C:\FBTESTING\qa\fbt-repo\tmp\tmp_c5993_audit.cfg" AuthClient = Srp AuthServer = Srp BugcheckAbort = 1 IpcName = tmp_ipc_5993 RemoteServiceName = tmp_fbs_5993 RemoteServicePort = 57456

[Firebird-devel] [FB-Tracker] Created: (CORE-6475) Memory leak when running EXECUTE STATEMENT with named parameters

2021-01-23 Thread Vlad Khorsun (JIRA)
Components: API / Client Library Affects Versions: 4.0 Beta 2 Reporter: Vlad Khorsun The small memory leak (96 bytes per named parameter) was introduced with CORE-5658 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one

[Firebird-devel] [FB-Tracker] Created: (CORE-6474) Report replica mode through isc_database_info, MON$DATABASE and SYSTEM context

2021-01-23 Thread Mark Rotteveel (JIRA)
. The reported mode should be - none (database is a primary or standalone) - read-only - read-write -- 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

[Firebird-devel] [FB-Tracker] Created: (CORE-6473) Align parsing between alias and path parts of databases.conf

2021-01-22 Thread Basil A. Sidorov (JIRA)
"some path" = "anoter_path" # is error but must be valid Left (alias itself) and right (path) parts of alias definition must be parsed by single ruleset with all OS-depended (case sensitive) and Firebird macros features. -- This message is automatically generated by JIRA. - If you

[Firebird-devel] [FB-Tracker] Created: (CORE-6472) Wrong byte order on UUIDs in gstat and monitoring output

2021-01-22 Thread Dimitry Sibiryakov (JIRA)
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

[Firebird-devel] [FB-Tracker] Created: (CORE-6471) Add MON$ELAPSED_TIME to MON$STATEMENTS

2021-01-20 Thread Karol Bieniaszewski (JIRA)
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

[Firebird-devel] [FB-Tracker] Created: (CORE-6470) Provide ability to suppress localized messages in error stack (or make them to be encoded to required charset, say 'utf8')

2021-01-20 Thread Pavel Zotov (JIRA)
n who will not be able to translate from english messages related to file/process access. Or at least to use goodle translate. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/A

[Firebird-devel] [FB-Tracker] Created: (CORE-6469) Provide ability to see in the trace log actions related to session management (e.g. ALTER SESSION RESET)

2021-01-18 Thread Pavel Zotov (JIRA)
back and TRA_8 appeared - without explicit command to finish 1st of them). It will be good to see explicitly mentioned session-level statement between ROLLBACK and START Tx statements. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact

[Firebird-devel] [FB-Tracker] Created: (CORE-6468) Wire compression causes sporadic "Error reading data from the connection." errors.

2021-01-14 Thread michalk1 (JIRA)
t matter, just it's length. - When the error arises, other connections continue to run (at least for some time), which means that the problem is not caused by a server crash. It is just the single connection that drops out. - So far i couldn't reproduce the problem against Linux server, it

[Firebird-devel] [FB-Tracker] Created: (CORE-6467) Not all SQL comments preserved in CREATE PROCEDURE like before

2021-01-12 Thread Martijn Tonies (JIRA)
gt; /* test */ > declare variable v varchar(20); > begin > > This comment is preserved in Firebird 2.5, but not in Firebird 3. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/s

[Firebird-devel] [FB-Tracker] Created: (CORE-6466) Seems Firebird removes comments before the first line of code

2021-01-12 Thread Sergio Toniutti (JIRA)
*/ int_b=int_a+int_c+2; suspend; end ^^ SET TERM ; ^^ Thanks, Sergio -- 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

[Firebird-devel] [FB-Tracker] Created: (CORE-6465) Dropping table fails after creating indexes

2021-01-08 Thread Jacob Lee (JIRA)
oard'); SQL> insert into test (name) values ('monitor'); SQL> delete from test; SQL> select * from test; SQL> drop table test; Statement failed, SQLSTATE = 42000 unsuccessful metadata update -object TABLE "TEST" is in use SQL> drop database; SQL>

[Firebird-devel] [FB-Tracker] Created: (CORE-6464) ES/EDS and ExtConnPool problem: EDS-connection may see old value of generator if it is established twise and interval is less than ExtConnPoolLifeTim

2021-01-06 Thread Pavel Zotov (JIRA)
? MSG point-3 DTS 2021-01-07 10:30:16.3380 Does sequence 'g_eds_test' exists ? => NO, it doesn't === bye-bye from SQL === As you can see, sequence is recreated every time. But its *OLD* value (123) still v

[Firebird-devel] [FB-Tracker] Created: (CORE-6463) Confusing message (conversion error from STRING " ") when use parametrized ES and "?" has no explicit CAST()

2021-01-06 Thread Pavel Zotov (JIRA)
finitely looks weird (there is no any text variables / parameters in this example). Perhaps, it will be better to change this message back to 2.5.x ? -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.

[Firebird-devel] [FB-Tracker] Created: (CORE-6462) Implement for LEAD, LAG, FIRST_VALUE, LAST_VALUE and NTH_VALUE

2021-01-06 Thread Mark Rotteveel (JIRA)
f WDX. C) Let TXN be the number of values in TX. I) If TXN = 0 (zero) or if TXN < RN, then the value of is the null value. II) Case: 1) If FROM LAST is specified, then the value of is the m-th value of TX, where m = (TXN - RN + 1). 2) Otherwise, the value of is the m-th value of TX, where m = RN

[Firebird-devel] [FB-Tracker] Created: (CORE-6461) isc_dsql_execute2 failed

2021-01-01 Thread Hafedh TRIMECHE (JIRA)
Firebird consistency check (missing pointer page in DPM_data_pages (243), file: dpm.cpp line: 779) Total execution time: 0.190s -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.or

[Firebird-devel] [FB-Tracker] Created: (CORE-6460) Incorrect query result when using named window

2020-12-27 Thread Adriano dos Santos Fernandes (JIRA)
rtition), doDsqlPass(dsqlScratch, this->order ? this->order : window->order), doDsqlPass(dsqlScratch, this->extent ? this->extent : window->extent), this->exclusion ? this->exclusion : window->exclusion); and it works for me. Probably you have better idea.

[Firebird-devel] [FB-Tracker] Created: (CORE-6459) Columbased encryption

2020-12-23 Thread Jan Kohlmeyer (JIRA)
Reporter: Jan Kohlmeyer I wish a columbased encryption like in Interbase. I want so set a few columns in a table encrypted with a default value. If i do not have a decryption key and I select the column, i get the default value. Regards. -- This message is automatically generated by JIRA. - If

[Firebird-devel] [FB-Tracker] Created: (CORE-6458) Impossible to cancel query

2020-12-22 Thread Artyom Smirnov (JIRA)
oken after merging query restart functionality (9ac2238c3d3552c35530606ba91a7752e5bab05c). -- 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 informati

[Firebird-devel] [FB-Tracker] Created: (CORE-6457) Internal error. Database page XXXXXXXX had been changed during backup (page SCN=YYYYYYY, backup SCN=ZZZZZZZZ)

2020-12-21 Thread Lucas Schatz (JIRA)
the same time (improbable) I`d opened a topic at Google FbSupport, but no response there... so maybe here someone could give more info if I should be concerned or not about this error https://groups.google.com/g/firebird-support/c/zZUHHfO3s-4 Thanks -- This message is automatically generated

[Firebird-devel] [FB-Tracker] Reopened: (CORE-5197) Segfault when process exits with active sweep thread

2020-12-18 Thread Alexander Peshkov (JIRA)
et attached to database > (i.e. very fast) process does not wait for sweep thread to complete and > begins cleanup with sweep starting which almost for sure causes access > violation. -- This message is automatically generated by JIRA. - If you think it was sent i

[Firebird-devel] [FB-Tracker] Created: (CORE-6456) Add trace info about read query in packets

2020-12-14 Thread Karol Bieniaszewski (JIRA)
rated 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

[Firebird-devel] [FB-Tracker] Created: (CORE-6455) MON$TRANSACTION not returning the expected transactions in combination with C# UDR

2020-11-30 Thread Alexander Muylaert (JIRA)
he attached log file? -- 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] [FB-Tracker] Created: (CORE-6454) Problem to connect to database after standard installation

2020-11-27 Thread Gregor Kobler (JIRA)
t the installation program only by double-clicking. The installation only works correctly if you select right mouse button and "run as administrator". I have only seen this behavior on a few PCs and these were managed by a central IT department (e.g. a university) -- This message is automa

[Firebird-devel] [FB-Tracker] Created: (CORE-6453) EXECUTE STATEMENT fails on FB 4.x if containing time/timestamp with time zone parameters

2020-11-25 Thread Adriano dos Santos Fernandes (JIRA)
db$database'; sttm = 'select current_timestamp from rdb$database'; -- lead to fail with = Statement failed, SQLSTATE = 07002 Dynamic SQL Error -SQLDA error -Data type unknown -at SQLVAR index 0 = No such problem in FB 3.x, and I could not find anything about this in README

[Firebird-devel] [FB-Tracker] Created: (CORE-6450) Races in cache of opened security databases

2020-11-18 Thread Alexander Peshkov (JIRA)
sage 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 inter

[Firebird-devel] [FB-Tracker] Created: (CORE-6449) Selectable store procedure return inserted values - join not working in FB3

2020-11-18 Thread Tomas Beran (JIRA)
in 2.5.9 return Hi select T.TEXT from TEST_PROCEDURE('Hi') P left outer join TEST_TABLE T on T.PKID = P.PKID; -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administr

[Firebird-devel] [FB-Tracker] Created: (CORE-6447) SET SQLDA_DISPLAY ON: different text of message for parameterized expression starting from second run

2020-11-16 Thread Pavel Zotov (JIRA)
fields where current_timestamp = ? and current_time = ?; . . . Statement failed, SQLSTATE = 07002 Dynamic SQL Error -SQLDA error -Wrong number of parameters (expected 2, got 0) <<<<<<<<<<< [ 2 ] -- This message is automatically generated by JIRA. - If you think it was sent i

[Firebird-devel] [FB-Tracker] Created: (CORE-6446) CLOOP envelopes is wrong in IStatus

2020-11-16 Thread Dimitry Sibiryakov (JIRA)
Reporter: Dimitry Sibiryakov If CLOOP envelope in IStatusImpl::getErrors()/getWarnings() catch an exception it returns null pointer and crash the engine. It should return pointer to a static array the same as BaseStatusWrapper::catchException(). -- This message is automatically generated by JIRA

[Firebird-devel] [FB-Tracker] Created: (CORE-6445) Regression in FB 4.x when PSQL code has recursive SP calls: crash instead of SQLSTATE = 54001 ("Too many concurrent executions...")

2020-11-14 Thread Pavel Zotov (JIRA)
_Auth BugCheckAbort = 1 DefaultDbCachePages = 2 ExtConnPoolLifeTime = 10 ExtConnPoolSize = 10 ExternalFileAccess = Full FileSystemCacheThreshold = 65536K IpcName = fb40_SS KeyHolderPlugin = KeyHolder LockHashSlots = 22111 LockMemSize = 5M MaxUnflushedWrites = -1 MaxUnflushedWriteTime = -1 ReadCon

[Firebird-devel] [FB-Tracker] Created: (CORE-6444) Ability to query Firebird configuration using SQL

2020-11-11 Thread Vlad Khorsun (JIRA)
structures when required and instance is kept at SQL query level. For security reasons access is allowed to the SYSDBA/OWNER only (it could be changed before release). Non-privileged user see empty content, no error is raised (also could be changed). -- This message is automatically generated

[Firebird-devel] [FB-Tracker] Created: (CORE-6443) UDF Plugin will crash Firebird at linux

2020-11-11 Thread Sorien (JIRA)
; } it srashes also when i try to replace VARCHAR(300) BY DESCRIPTOR with CString -- 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 J

[Firebird-devel] [FB-Tracker] Created: (CORE-6442) Massive Update force Deadlocks

2020-11-10 Thread Andreas Steibl (JIRA)
y end; If i start two instances and make these massive updates, i get a deadlock. if i start instance 1 with 1 updates, and instance 2 with 1000 updates, i get no error, only if i start both instances with at leats 1 updates. -- This message is automatically generated by JIRA. - If yo

  1   2   3   4   5   6   7   8   9   10   >