View can not be subject of DML if it is declared WITH CHECK OPTION and
COMPUTED-BY column present in the this view expression
-
Key: CORE-6535
Results of сoncatenation with blob has no info about collation of source
columns (which are declared with such info)
Key: CORE-6532
URL:
COMPUTED BY column looses charset and collate of source field when is
either of type BLOB or VARCHAR casted to BLOB
---
Key: CORE-6531
URL:
Connect to database that contains broken pages can lead to FB crash
---
Key: CORE-6528
URL: http://tracker.firebirdsql.org/browse/CORE-6528
Project: Firebird Core
Issue Type:
Regression: inline comment of SP parameter with closing parenthesis leads to
incorrect SQL when trying to extract metadata
--
Key: CORE-6527
Regression: CREATE DATABASE fails with 'Token unknown' error when DB name is
enclosed in double quotes and 'DEFAULT CHARACTER SET' is specified after DB name
Provide same results for date arithmetics when date is changed by values near
+/-max(bigint)
Key: CORE-6504
URL: http://tracker.firebirdsql.org/browse/CORE-6504
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
-
Key:
Trace: provide ability to see STATEMENT RESTART events (or their count)
---
Key: CORE-6500
URL: http://tracker.firebirdsql.org/browse/CORE-6500
Project: Firebird Core
Issue
Call to Services API on 1st FB instance blocks start of audit session in 2nd FB
instance for 130 seconds
Key: CORE-6476
URL:
Provide ability to suppress localized messages in error stack (or make them to
be encoded to required charset, say 'utf8')
--
Key: CORE-6470
Provide ability to see in the trace log actions related to session management
(e.g. ALTER SESSION RESET)
Key: CORE-6469
URL:
ES/EDS and ExtConnPool problem: EDS-connection may see old value of generator
if it is established twise and interval is less than ExtConnPoolLifeTime (even
when generator is RECREATED every time)
Confusing message (conversion error from STRING " ") when use parametrized ES
and "?" has no explicit CAST()
Key: CORE-6463
URL:
SET SQLDA_DISPLAY ON: different text of message for parameterized expression
starting from second run
-
Key: CORE-6447
URL:
Regression in FB 4.x when PSQL code has recursive SP calls: crash instead of
SQLSTATE = 54001 ("Too many concurrent executions...")
---
Key: CORE-6445
Srp plugin keeps connection after database has been removed for ~10 seconds
(SS and SC).
-
Key: CORE-6441
URL: http://tracker.firebirdsql.org/browse/CORE-6441
Provide ability to specify file to fetch password when use CONNECT command in
SQL scenario
--
Key: CORE-6423
URL: http://tracker.firebirdsql.org/browse/CORE-6423
Error message "expected length N, actual M" contains wrong value of M when
charset UTF8 is used in the field declaration of a table
---
Key: CORE-6414
Error message "malformed string' is issued instead of "expected: N, actual : M"
when UTF-8 charset is used and default value for declared column is greater
than this column length
FB crashes on attempt to create table with number of fields greater than 5460.
--
Key: CORE-6411
URL: http://tracker.firebirdsql.org/browse/CORE-6411
Project: Firebird Core
Attribute 'multi-user maintenance' can not be seen if 'backup-lock' was set
before this
Key: CORE-6402
URL: http://tracker.firebirdsql.org/browse/CORE-6402
Provide ability to read actual DB header attributes when DB is in backup-lock
state
---
Key: CORE-6399
URL: http://tracker.firebirdsql.org/browse/CORE-6399
Project:
Trace. Provide ability to watch time of *preparing* statement when it is
greater than some threshold (similar to time_threshold for log_statement_finish)
ISQL: provide ability to run it from with "-i
Values less than -2147483648 can not be spicified in the INCREMENT BY clause a
column defined as GENERATED AS IDENTITY
--
Key: CORE-6365
URL:
LEAD() and LAG() do not allow to specify 3rd argument ("DEFAULT" value when
pointer is out of scope) of INT128 datatype.
Key: CORE-6357
URL:
ROUND() of INT128 number requires is to be explicitly cased to INT128
-
Key: CORE-6356
URL: http://tracker.firebirdsql.org/browse/CORE-6356
Project: Firebird Core
Issue
TRUNC() does not accept second argument = -128 (but show it as required
boundary in error message)
--
Key: CORE-6355
URL:
INT128 has problems with some PSQL objects
--
Key: CORE-6353
URL: http://tracker.firebirdsql.org/browse/CORE-6353
Project: Firebird Core
Issue Type: Bug
Reporter: Pavel Zotov
See scripts
Alternate quoting does not work on some particular cases
Key: CORE-6340
URL: http://tracker.firebirdsql.org/browse/CORE-6340
Project: Firebird Core
Issue Type: Bug
Regression in FB 4.x: error "Implementation of text subtype not located"
on attempt to use some collations defined in fbintl.conf
-
Key:
Attempt to violate constraint for domain-based BLOB field raises message that
does not relates to actual problem
Key: CORE-6297
URL:
Statement "CREATE DOMAIN [dm_name] as BIGINT" raises "numeric value is out of
range" if its default value is -9223372036854775808
--
Key: CORE-6291
CREATE DOMAIN can not use DEFAULT clause with HEX literal if another domain has
been created before this statement
--
Key: CORE-6290
URL:
gbak with PIPE to stdout: invalid content if user '-se :service_mgr'
command switch
-
Key: CORE-6264
URL: http://tracker.firebirdsql.org/browse/CORE-6264
Regression: crash when built-in function LEFT() or RIGHT() missed 2nd argument
(number of characters to be taken).
--
Key: CORE-6251
URL:
Ability to create database with length more than 255 characters should be
prohibited
Key: CORE-6248
URL: http://tracker.firebirdsql.org/browse/CORE-6248
Project:
Presense of 'WITH CHECK OPTION' in a view DDL disallows UPDATE statement if
user has been granted to update some (NOT ALL) columns of this view
---
DECFLOAT. Implement high-accuracy algorithm for SUM of values with exponenta
greater than 34.
-
Key: CORE-6242
URL: http://tracker.firebirdsql.org/browse/CORE-6242
Compiler can make more rigorous check for presense of RETURNS(...) clause in SP
header when SP body contains SUSPEND.
-
Key: CORE-6239
URL:
DECFLOAT: subtraction Num1 - Num2 leads to "Decimal float overflow" if Num2 is
specified in scientific notation and less than max double (
1.7976931348623157e308 )
FB crashes when evaluating too long expression
--
Key: CORE-6223
URL: http://tracker.firebirdsql.org/browse/CORE-6223
Project: Firebird Core
Issue Type: Bug
Components: Engine
DECFLOAT values and queries with ORDER BY and/or windowed (analitical) functions
Key: CORE-6219
URL: http://tracker.firebirdsql.org/browse/CORE-6219
Project: Firebird
COUNT(DISTINCT ) leads FB to crash when there are duplicate
values of this field
Key: CORE-6218
URL: http://tracker.firebirdsql.org/browse/CORE-6218
Command "ISQL -X" can not extract ROLE name when use multi-byte charset for
connection (4.x only is affected)
-
Key: CORE-6211
URL:
FB crash because TraceSvcJrd::checkPrivileges can pass NULL in 'alias'
--
Key: CORE-6204
URL: http://tracker.firebirdsql.org/browse/CORE-6204
Project: Firebird Core
Issue
FB crashes when database is in full shutdown and several sessions make attempts
to attach to this DB in infinite loop (3.0 SuperServer only is affected)
Provide ablity to change SUBTYPE of blob field
--
Key: CORE-6195
URL: http://tracker.firebirdsql.org/browse/CORE-6195
Project: Firebird Core
Issue Type: Improvement
Components: Engine
Length of INPUT parameter in SQLDA depends on whether it is enclosed in
COALESCE() or no.
-
Key: CORE-6187
URL: http://tracker.firebirdsql.org/browse/CORE-6187
Original content of column which is involved into ENCRYPT() is displayed as
distorted view after this call
--
Key: CORE-6186
URL:
Some (wrong ?) parameters of ENCRYPT() leads FB to crash
Key: CORE-6185
URL: http://tracker.firebirdsql.org/browse/CORE-6185
Project: Firebird Core
Issue Type: Bug
Affects
CREATE [OR ALTER] USER statement with GRANT ADMIN ROLE: TAGS is allowed to be
specified only in the end of statement in such case (discrepancy with
documentation)
ExtConnPoolLifeTime acts as countdown for activity in MOST RECENT database (of
several) rather then separate for each of used databases
---
Key:
Trace: provide details about current nbackup activity when it merges delta with
main DB file
Key: CORE-6180
URL: http://tracker.firebirdsql.org/browse/CORE-6180
Trace: provide info about number of GEN_ID() calls, separately for each
generator
-
Key: CORE-6178
URL: http://tracker.firebirdsql.org/browse/CORE-6178
Project: Firebird
Provide ability to manage users from security.db when connected to read-only
(user)-DB
--
Key: CORE-6152
URL: http://tracker.firebirdsql.org/browse/CORE-6152
fbsvcmgr action_repair rpr_list_limbo_trans does not show list of transactions
in LIMBO state
--
Key: CORE-6141
URL: http://tracker.firebirdsql.org/browse/CORE-6141
Increase max length of buffer that contains ID of transactions in limbo state
(that can be seen by 'gfix -list ')
-
Key: CORE-6140
URL:
Regression: can not obtain list of transactions in limbo state when use API
---
Key: CORE-6139
URL: http://tracker.firebirdsql.org/browse/CORE-6139
Project: Firebird Core
Allow GTT which was created with "on commit preserve rows" option to be
writeable in read-only databases
-
Key: CORE-6136
URL:
Win_Sspi in the list of auth plugins leads message about failed login to be
changed (from 'Your user name and password are not defined...' to 'Missing
security context ...')
Invocation of 'gfix -shut full -force 0 localhost:/path/to/db' leads FB to crash
Key: CORE-6103
URL: http://tracker.firebirdsql.org/browse/CORE-6103
Project: Firebird
Attempt to drop existing user randomly fails with "336723990 : record not found
for user" on Classic (4.0 only is affected)
---
Key: CORE-6080
Provide ability to see current state of DB encryption
-
Key: CORE-6048
URL: http://tracker.firebirdsql.org/browse/CORE-6048
Project: Firebird Core
Issue Type: Improvement
Boolean 'IS' operator can raise 'Token unknown' error in execute statement
(when immediately followed by named parameter)
-
Key: CORE-6041
gbak issues "Your user name and password are not defined" instead of "database
shutdown" when command switch "-fe(tch_password) ..." is specified with correct
password in file
Altering trigger can lead FB to crash
-
Key: CORE-5994
URL: http://tracker.firebirdsql.org/browse/CORE-5994
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.8
Regression: ROLE does not passed in ES/EDS (specifying it in the statement is
ignored)
--
Key: CORE-5985
URL: http://tracker.firebirdsql.org/browse/CORE-5985
Add name of database for every message which can relate to DB
-
Key: CORE-5984
URL: http://tracker.firebirdsql.org/browse/CORE-5984
Project: Firebird Core
Issue Type: Improvement
Command "show table mon$attachments;" does not issue mon$wire* fields
-
Key: CORE-5978
URL: http://tracker.firebirdsql.org/browse/CORE-5978
Project: Firebird Core
Issue
Provide connection_id for attachment which had problems on client side with
adding 104/110 error in firebird.log
Key: CORE-5964
URL:
Bug in SIMILAR TO when adding numeric quantifier as bound for repetetion of
expression leads to empty resultset
---
Key: CORE-5957
URL:
Validation: provide ability to filter messages by severity (e.g. prohibit
output of warnings, only errors are interested)
-
Key: CORE-5944
SIMILAR TO does not return result when invalid pattern is used (with two
adjacent special characters that should be escaped but aren't)
---
Key:
Attempt to create mapping with non-ascii user name which is encoded in
SINGLE-BYTE codepage (win 1251) leads to '-Malformed string' message.
Regression: can not launch trace if its 'database' section contains regexp
pattern with curvy brackets to enclose quantifier
-
Key: CORE-5907
Command 'REVOKE ALL ON ALL FROM ' lead server to crash
---
Key: CORE-5858
URL: http://tracker.firebirdsql.org/browse/CORE-5858
Project: Firebird Core
Issue Type: Bug
Optimizer must take in account result of previous evaluation of separate values
in "NOT IN( ...)"-list
--
Key: CORE-5850
URL:
Nested aggregation is allowed
-
Key: CORE-5848
URL: http://tracker.firebirdsql.org/browse/CORE-5848
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.3, 2.5.8, 4.0
CREATE VIEW issues "Implementation of text subtype 512 not located"
---
Key: CORE-5846
URL: http://tracker.firebirdsql.org/browse/CORE-5846
Project: Firebird Core
Issue Type:
mon$statements can "skipor contains incorrect data in mon$state
---
Key: CORE-5839
URL: http://tracker.firebirdsql.org/browse/CORE-5839
Project: Firebird Core
Issue Type: Bug
ALTER CURRENT USER fails with "no permission for <...> TABLE PLG$SRP" if
current user: 1) has NO admin role and 2) wants to modify his own TAGS list
GRANT ADMIN ROLE (in CREATE USER statement) can be specified only before 'USING
PLUGIN' if clause TAGS present
--
Key: CORE-5826
URL:
Client gets SQLSTATE = 28000 ("user/password not defined") if WireCrypt =
Disabled is used on client side. Rather error SQLSTATE = 08006 ("Error
occurred... check server firebird.log") should be raised
Provide ability to filter activity IPv4/v6 mask(s)
--
Key: CORE-5816
URL: http://tracker.firebirdsql.org/browse/CORE-5816
Project: Firebird Core
Issue Type: Improvement
Components:
ROW_COUNT is incremented by 1 all subsequent UPDATE statements that are
executed within cursor and actually can affect only 1 record
-
Key:
User who is allowed to manage other users must have this ability WITHOUT need
to grant him RDB$ADMIN role (which is related to admin tasks in "main" database
rather than in security_db)
Regression: FB crashes when trying to recreate table that is in use by DML
(3.0.3; 3.0.4; 4.0.0)
Key: CORE-5756
URL: http://tracker.firebirdsql.org/browse/CORE-5756
ISQL does not understand inline comment ("--") in CONNECT statement
---
Key: CORE-5751
URL: http://tracker.firebirdsql.org/browse/CORE-5751
Project: Firebird Core
Issue Type:
Add ability to see in mon$attachments: 1) whether some attach was notified
that he must be deleted; 2) timestamp of such notification
--
Key:
Exception "unknown table" should be raised instead of "unknown columns" on
attempt to create index for non-existent table
-
Key: CORE-5738
Trace: add hash value for text of every executed statement
--
Key: CORE-5736
URL: http://tracker.firebirdsql.org/browse/CORE-5736
Project: Firebird Core
Issue Type: Improvement
Add ability to use "install.sh -path /opt/my_path" without need to install FB
first in the default folder ("/opt/firebird")
---
Key: CORE-5724
Trace config with misplaced "{" lead firebird to crash
--
Key: CORE-5706
URL: http://tracker.firebirdsql.org/browse/CORE-5706
Project: Firebird Core
Issue Type: Bug
Components:
Exception "no current record for fetch operation" appears after delete attach
in mon$attachments with specifying 'order by' clause
--
Key: CORE-5684
FB 3.0 crashes when trying to RE_create two tables and define master-detail
link between them using text fields with different character sets
-
Regression in 3.0+: message "CTE 'X' has cyclic dependencies" appear when 'X'
is alias for resultset and there is previous CTE part with the same name 'X' in
the query
SIMILAR TO is slower than LIKE for hundred times on trivial pattern matching
with varchar datatype.
---
Key: CORE-5664
URL:
Message "Operating system call munmap failed. Error code 12" can apper in
firebird.log under heavy load (2.5.x, CS, SC)
---
Key: CORE-5643
URL:
1 - 100 of 458 matches
Mail list logo
