mprovement
Components: Engine
Reporter: Karol Bieniaszewski
Please provide place where "Invalid usage of boolean expression" occur
eg. line number and col
now finding this in big query is really hard
--
This message is automatically generated by JIRA.
-
If you think it
Reporter: Karol Bieniaszewski
As proposed by Mark Rotteveel on support list
please provide DDL to change file name of external table
ALTER TABLE ALTER EXTERNAL [FILE]
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the
Components: Engine
Affects Versions: 3.0.4
Reporter: Karol Bieniaszewski
modify udr pascal sample gen_rows and compile with Delphi (maybe this is
unreleated to Delphi)
---
change result to:
result: Array[0.199] of AnsiChar
Reporter: Karol Bieniaszewski
I know that someone can think that this is tool feature like isql or something
like this.
But it can not have same performance like engine itself have.
It should be as fast as it is for external tables now - but as we know external
tables can work only
Affects Versions: 3.0.3, 3.0.4
Environment: WI-V3.0.4.32954 Firebird 3.0
DATABASE WITH CHARSET WIN1250
Reporter: Karol Bieniaszewski
Try
SELECT S.SEC$USER_NAME, SA.* FROM SEC$USERS S LEFT JOIN SEC$USER_ATTRIBUTES SA
ON SA.SEC$USER_NAME=S.SEC$USER_NAME WHERE S.SEC$USER_NAME LIKE
Components: Documentation, Engine
Affects Versions: 3.0.4
Reporter: Karol Bieniaszewski
Few thinks about not null constraint and its name - i do not know if this
should be as one ticket or some releated tickets
1. Specification of NOT NULL constraint is undocumented feature avaiable for
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.4
Reporter: Karol Bieniaszewski
Database WIN1250 (if matter)
-OK--
SELECT 1 AS "Suma wszystkich INSP_ID rosnącoo" FROM RD
: Bug
Components: Engine
Affects Versions: 3.0.3, 3.0.4
Reporter: Karol Bieniaszewski
Attachments: TESTPLAN.7z
This is releated to old CORE-5020 but now i have reproductible test case with
sample database
restore attached database backup
run the query
SELECT
Components: Engine
Affects Versions: 3.0.3, 3.0.4
Reporter: Karol Bieniaszewski
We are in point of migration of database from Interbase to Firebird and
encountered slownes.
Below query run slow ~1s. With same shema this query run instant on Interbase.
We have analysed all
: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.3, 3.0.4
Reporter: Karol Bieniaszewski
SELECT r.RDB$GENERATOR_NAME, r.RDB$GENERATOR_ID, r.RDB$SYSTEM_FLAG,
r.RDB$DESCRIPTION, r.RDB$SECURITY_CLASS, r.RDB$OWNER_NAME,
r.RDB$INITIAL_VALUE
Affects Versions: 3.0.3, 3.0.4
Environment: WI-V3.0.3.32897 Firebird 3.0
Reporter: Karol Bieniaszewski
Attachments: testCOREHang.7z
We try to migrate database from Interbase to Firebird but query hang on FB -
with same query plan
restore attached database backup
there
Components: Engine
Reporter: Karol Bieniaszewski
When we run query with ambigous field name e.g.
SELECT 1 FROM RDB$RELATIONS R INNER JOIN RDB$RELATION_FIELDS RF ON
RF.RDB$RELATION_NAME=R.RDB$RELATION_NAME WHERE RDB$RELATION_NAME='abc'
we got fully descriptive message
://tracker.firebirdsql.org/browse/CORE-5634
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.3
Reporter: Karol Bieniaszewski
I do not know if this is releated to but i use Legacy user manager
CREATE USER KBIENIASZEWSKI PASSWORD
Reporter: Karol Bieniaszewski
If you consider new functions then much common will be
Of course it's just a suggestion of a name and syntax,
MODIFY_DATE([SET] {DAY | MONTH | YEAR } FOR )
MODIFY_DATE(DAY 1 FOR '2017-09-22') -- 2017-09-01
MODIFY_DATE(MONTH 1
: Improvement
Reporter: Karol Bieniaszewski
Priority: Minor
Will be good to see in which expression index exception was raised and at last
that exception was raised by calculated index at all.
e.g.
CREATE TABLE TEST
(
ID INTEGER,
WARTOSC NUMERIC(16,2)
);
CREATE INDEX
Issue Type: New Feature
Components: Engine
Reporter: Karol Bieniaszewski
Please add to engine counters to catch situations:
- Sort IO directed into temporary files
- temporary files, used for GTT
- any other disk operations not monitored already by engine
Will be good
Issue Type: New Feature
Components: Engine
Affects Versions: 3.0.0
Reporter: Karol Bieniaszewski
Please provide ability to tell Firebird "do not touch" explicitly stored plan
now we can store plan within query itself
SELECT
...
FROM
...
PLAN ..
Type: Improvement
Reporter: Karol Bieniaszewski
For query like this Firebird remove unnescessary sorting but only if we order
by first column
SELECT
R.RDB$RELATION_NAME, R.RDB$DBKEY_LENGTH
FROM
RDB$RELATIONS R
UNION
SELECT
R.RDB$RELATION_NAME, R.RDB$DBKEY_LENGTH
Components: Engine
Reporter: Karol Bieniaszewski
Please add to context variables transaction start timestamp
CURRENT_TRANSACTION_START_TIME
something like other context variables CURRENT_TRANSACTION, CURRENT_TIME
It is usefull for e.g. audit - to have whole transaction operations marked
Project: Firebird Core
Issue Type: Improvement
Components: Engine
Reporter: Karol Bieniaszewski
Will be good to see that Firebird do not fetch streem if non correlated filter
expresion evaluated to false
is uppose simplest possible case is:
SELECT * FROM RDB
Add build in TRY_CAST function
---
Key: CORE-5378
URL: http://tracker.firebirdsql.org/browse/CORE-5378
Project: Firebird Core
Issue Type: New Feature
Components: Engine
Reporter: Karol
://tracker.firebirdsql.org/browse/CORE-5309
Project: Firebird Core
Issue Type: Bug
Components: GBAK
Affects Versions: 3.0.1
Reporter: Karol Bieniaszewski
gbak:restoring data for table RIDO_MESSAGE
Database restore canceled 14:50:46 due to IBPP exception:
*** IBPP
Project: Firebird Core
Issue Type: New Feature
Components: Engine, GBAK
Reporter: Karol Bieniaszewski
We have now possibility to divide database into multiple files (i call this
"Database speces").
This feature extend usability of this feature.
Project: Firebird Core
Issue Type: New Feature
Components: GBAK
Reporter: Karol Bieniaszewski
Hi,
now when we do backup it store only index definition without data
it is ok from backup time POV and backup size POV
but restore time is increased by need of
/ Client Library
Affects Versions: 3.0 RC 1
Reporter: Karol Bieniaszewski
creation of new database on fb2.5 throught fb3 client failed
*** IBPP::SQLException ***
Context: Database::Create
Message: isc_dsql_execute_immediate failed
SQL Message : -902
Unsuccessful execution caused by a
Type: Bug
Components: Engine
Affects Versions: 3.0 RC 1
Reporter: Karol Bieniaszewski
CREATE TABLE TEST1
(
ID INTEGER NOT NULL CONSTRAINT PK_TEST1 PRIMARY KEY
);
CREATE TABLE TEST2
(
ID INTEGER NOT NULL CONSTRAINT PK_TEST2 PRIMARY KEY,
ID_1 INTEGER NOT NULL
);
commit;
SET
lause)"
-
Key: CORE-5024
URL: http://tracker.firebirdsql.org/browse/CORE-5024
Project: Firebird Core
Issue Type: Improvement
Components: Engine
Reporter: Karol Bieniaszewski
Priority: Minor
Invalid expression in the s
CORE-5023
URL: http://tracker.firebirdsql.org/browse/CORE-5023
Project: Firebird Core
Issue Type: Improvement
Reporter: Karol Bieniaszewski
Now when we try to add new NOT NULL field to table
and when we do not specify default we got error
Please add more i
: Bug
Components: Engine
Affects Versions: 3.0 RC 1
Reporter: Karol Bieniaszewski
composite index order - ORDER BY ZF.ID, KONT_ID (IXA_FK__ID__KONT_ID)
cause not using referencing index (FK_ZF__K)
CREATE TABLE ZF
(
ID INTEGER NOT NULL PRIMARY KEY,
KONT_ID INTEGER NOT
: 3.0 RC 1
Reporter: Karol Bieniaszewski
Simplified case
CREATE TABLE ZF
(
ID INTEGER NOT NULL PRIMARY KEY,
KONT_ID INTEGER NOT NULL
);
CREATE TABLE U
(
ID INTEGER NOT NULL PRIMARY KEY,
KONT_ID INTEGER NOT NULL
);
CREATE TABLE K
(
ID INTEGER NOT NULL PRIMARY KEY
);
commit;
INSERT
-4843
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Beta 2
Environment: WI-T3.0.0.31877 Firebird 3.0 Beta 2
Reporter: Karol Bieniaszewski
Try to create procedure with select form not existent table or with
Components: Engine
Reporter: Karol Bieniaszewski
Previously - i suppose in FB2.5.3 it was able to declare below udf function
But now it is not - in FB2.5.4 and also in FB3
DECLARE EXTERNAL FUNCTION IMPORT_CSV_BLOB
cstring(32000), cstring(496), cstring(8000), cstring(16000
: GBAK
Environment: Windows Server 2008 R2 Datacenter
WI-T3.0.0.31855 Firebird 3.0 Beta 2
WI-V2.5.4.26822 Firebird 2.5
Reporter: Karol Bieniaszewski
Attachments: plemiona_meta.fbk
I try to migrate my database from FB2.5 but it raise error also if i use only
metadata backup
Reporter: Karol Bieniaszewski
example
SELECT
*
FROM
RDB$RELATION_FIELDS RF
left join RDB$RELATIONS R on R.RDB$SYSTEM_FLAG = RF.RDB$FIELD_POSITION
WHERE
RF.RDB$RELATION_NAME BETWEEN 'RDB$RELATIONS' AND 'RDB$RELATIONS2'
PLAN JOIN (RF INDEX (RDB$INDEX_4),
: Engine
Affects Versions: 3.0 Beta 2
Reporter: Karol Bieniaszewski
Query work on FB2.5.3 but not work on current FB3 (WI-T3.0.0.31844 Firebird 3.0
Beta 2)
SQL Message : -206
Column does not belong to referenced table
Engine Code: 335544569
Engine Message :
Dynamic SQL Error
SQL
: Improvement
Reporter: Karol Bieniaszewski
Will be good to see a way to build dynamic list of parameters for execute
statement at procedure run-time
now we have only possibility to specify parameters known at procedure creation
time like
EXECUTE STATEMENT (VAR_SQL) (PARAM_X := aaa
: Bug
Components: Engine
Affects Versions: 3.0 Beta 2
Reporter: Karol Bieniaszewski
1. If you run this query unmodified you got "normal error"
"Too many Contexts of Relation/Procedure/Views. Maximum allowed is 256."
2. comment last select marked a
Issue Type: Bug
Reporter: Karol Bieniaszewski
I read that to get unlimited text of explained plan i should look into
TMP$STATEMENTS
but i got limited text in MON$EXPLAINED_PLAN in MON$STATEMENTS for some big
query
it end after 14 808 bytes as
"Select Expression
-"
no
"SuperIndex" for string serching
Key: CORE-4687
URL: http://tracker.firebirdsql.org/browse/CORE-4687
Project: Firebird Core
Issue Type: New Feature
Components: Engine
Repor
Parameterized Generator
---
Key: CORE-4446
URL: http://tracker.firebirdsql.org/browse/CORE-4446
Project: Firebird Core
Issue Type: New Feature
Reporter: Karol Bieniaszewski
Real life case - i do not know
Reporter: Karol Bieniaszewski
Now we have
similar to
substring(xxx SIMILAR
but will be good to see simple possibility to get
- match count
- n-th match
- replace (CORE-2510)
for example we have now 4 custom udf for this
//replace all matches
function REG_REPLACE(const SDane, Pattern
Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 1
Environment: Windows XP
Reporter: Karol Bieniaszewski
Priority: Critical
I create new database by Flamerobin with WIN1250 and Page 16K
Firebird is in version 3.0.0.30573 Win32
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 1
Environment: Windows XP Prof SP3
Reporter: Karol Bieniaszewski
Priority: Critical
I do all by flamerobin
1. Create 2 databases - i use
://tracker.firebirdsql.org/browse/CORE-4039
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.2, 2.5.3
Reporter: Karol Bieniaszewski
CREATE TABLE AAA
(
ID SMALLINT NOT NULL PRIMARY KEY
);
CREATE TABLE BBB
(ID SMALLINT NOT NULL PRIMARY KEY
Issue Type: New Feature
Components: Engine
Reporter: Karol Bieniaszewski
This is design bug i think
but engine rejects creation of unique constraint on fields placed in different
order what is not the same at all
i simplify sample to deps scenario but in my app this was
Issue Type: New Feature
Components: Engine
Reporter: Karol Bieniaszewski
Priority: Minor
I know that we can write udf(and we have it) - but binary operations are common
and will be good to see this functions supported by engine itself
1. BIN_BIT(VALUE
: Engine
Reporter: Karol Bieniaszewski
Will be good to see feature to create temporary indexes for some query
Sometimes permanent index is not good and can slowdown inserts and other
operations
but some query without index can run to long without index
this can be don in two ways
1
"no current record for fetch operation"
---
Key: CORE-3693
URL: http://tracker.firebirdsql.org/browse/CORE-3693
Project: Firebird Core
Issue Type: Bug
Reporter: Karol Bieniaszewsk
Components: GBAK
Reporter: Karol Bieniaszewski
Hi,
is possible to see feature to order at backup or restore process
(i suppose at backup this will be simpler to implement but i do not know
internal FB work)
ordering data in pages for table in some way
example invoices
in normal
Issue Type: Improvement
Components: GBAK
Affects Versions: 2.1.4, 2.1.5
Environment: Windows
Reporter: Karol Bieniaszewski
Situation
DefaultDbCachePages e.g. 131072
1. On serwer is database e.g 3GB test.fdb
2. we do backup process test.bak
3. we restore
Issue Type: Bug
Components: Engine
Affects Versions: 2.1.4, 2.1.5
Reporter: Karol Bieniaszewski
Priority: Minor
### metadata ###
CREATE TABLE TEST_TREE
(
ID INTEGER NOT NULL,
ID_HEADER INTEGER
Affects Versions: 2.1.4, 2.1.5
Environment: Windows XP, Windows 2003 Server
Reporter: Karol Bieniaszewski
i simplify query for system tables only
and test on FB2.1.4.408 and on recent snapshot FB2.1.5.18427
after run this query server crash
SELECT LPAD(SUBSTRING(R.RDB
operation
---
Key: CORE-3480
URL: http://tracker.firebirdsql.org/browse/CORE-3480
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.1.4
Reporter: Karol Bieniaszews
: Engine
Affects Versions: 2.1.4
Reporter: Karol Bieniaszewski
BIN_OR and BIN_AND not work with more arguments then 2
SELECT BIN_OR(1, 2, 4) FROM RDB$DATABASE
give
SQL Message : -171
Invalid data type, length, or value
Engine Code: 335544439
Engine Message :
function BIN_OR
ew Feature
Components: Engine
Affects Versions: 2.1.4
Reporter: Karol Bieniaszewski
Priority: Minor
normally update statement allow somethink like this
update table1 set field1 = coalesce(field1, 0) + 1 where id=5
but
UPDATE OR INSERT INTO table1(id, field1
-3448
Project: Firebird Core
Issue Type: New Feature
Reporter: Karol Bieniaszewski
now only two field is accesible by contexst variable from MON$ATTACHEMENTS
MON$ATTACHMENTS_ID is accessible by CURRENT_CONNECTION
MON$USER is accessible by CURRENT_USER
will be good
101 - 156 of 156 matches
Mail list logo
