e out why it prefere Windows temp instead.. Maybe in some point FB
eat whole space (20GB) of O:\temp and go there. DB size was 7GB.
But in all current tests FB never go to C:\WINDOWS\TEMP.
Maybe the reason of bugcheck was releated to my SSD use…
Regards,
Karol Bieniaszewski
Firebird-Devel mailing
Firebird 3.0
ACTION
AVG_TIMES_PER_MINUTE
AVG_ELAPSED_MS
SUCCESSFUL_TIMES_DONE
JOB_BEG
JOB_END
*** OVERALL *** for 180 minutes:
3968.06
16426
714251
2018-10-28 20:00
2018-10-28 23:00
Regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists
823177
2018-10-29 23:59
2018-10-30 03:00
Regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Windows 10 64bit.
Regards,
Karol Bieniaszewski
What platform? Windows server and Windows client?
Gabor
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net
to fix this? I see that this table realy does not exists win
resulted database
PS> i have addded many wait commands and echo to your script,
because without it, script failed many times (some timings problem or Windows
10 releated problem).
Too fast computer…
Regards,
Karol Bieniaszewski
Fireb
Great tip! Thats it. Thank you
Regards,
Karol Bieniaszewski
Od: Dimitry Sibiryakov
Wysłano: sobota, 27 października 2018 11:31
Do: firebird-devel@lists.sourceforge.net
Temat: Re: [Firebird-devel] OLTP run problem
27.10.2018 10:49, Karol Bieniaszewski wrote:
> What can i do to
Where can i find this OLTP stress test software
I like to see my numbers
Regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
)
I have tried gfix -validate -full but it run 1 hour and do not return and do
not write more info into log.
In proces manager i se that it read only 1 921 600 bytes but it still
increassing really slow.
I do not have core dump because engine did not crashed.
What next?
regards,
Karol
This time no luck.
All work ok for 3 hours.
Whole test without any problems.
I will investigate this more. If i found something i will back here.
regards,
Karol Bieniaszewski
Od: Dimitry Sibiryakov
Wysłano: sobota, 27 października 2018 15:35
Do: firebird-devel@lists.sourceforge.net
Temat: Re
ement failed, SQLSTATE = 28000
modify record error
-Install incomplete, please read the Compatibility chapter in the release notes
for this version
SQL>
Is this procedure somechow different under FB4 now?
regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.
Forgot it
CREATE !!! not alter first
Regards,
Karol Bieniaszewski
Od: Karol Bieniaszewski
Wysłano: poniedziałek, 29 października 2018 18:16
Do: For discussion among Firebird Developers
Temat: [Firebird-devel] Firebird4 sysdba install different then in FB3?
I can not add sysdba to Firebird4
this?
Or engine send them required state of parameters/variables?
regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
select custom_count_plus_1000(1) from rdb$database where 1 = 0 --
returns 1000
create aggregate function custom_count_plus_1000 (i integer) returns (o
integer)
as
begin
if agg_finished then
Begin
if agg_i>0 then
o = agg_i; else
o = 1000;
end;
end
regar
ody of this function
-- do whatever you want
o= o + 1;
if (agg_finished) then
o = o + 1000;
end
Maybe you can mix this with your proposition
Regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
have more then one parameter?
e.g first param will have ignore null and second not.
What walue will have then first parameter when we write ignore null for it?
Pozdrawiam,
Karol Bieniaszewski
Od: Karol Bieniaszewski
Wysłano: niedziela, 30 września 2018 09:01
Do: For discussion among Firebird Developer
rebird, udr, user POV?
Regards,
Karol Bieniaszewski
Od: Karol Bieniaszewski
Wysłano: sobota, 29 września 2018 19:29
Temat: [Firebird-devel] ODP: ODP: User-defined aggregate functions
>>Your syntax looks too much like a normal function, which I think is
>>confusing.
For me this is posit
D WHEN FETCHED DO WHEN FINISHED DO
This is only my humble opinion, but i do not like suspend concept here.
Engine know when provide values and when it need result from agg.
See my previous email (with „Agg_result_needed”) and criticize it if you see
any problems there.
regards,
Karol Bieniaszewski
lems with it?
Udr will also work simple with this, it only must be informed about agg_i and
agg_finished by param to udr function.
Pozdrawiam,
Karol Bieniaszewski
Od: Mark Rotteveel
Wysłano: sobota, 29 września 2018 17:46
Do: firebird-devel@lists.sourceforge.net
Temat: Re: [Firebird-devel] ODP: User
sefull.
With only SNAPSHOT_CN we have same problem as with OAT.
Regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
>> Do not know why but 25% of users continue downloading i86 firebird binaries
Because they need fbclient.dll in 32 bit version for 32bit projects
Regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
>> Afraid only after fb4-beta release.
Hard to wait
but thank you for your honest answer
I believe that FB4 beta will be available soon
regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
be very grateful for that.
Regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
ple?
Especially in the second one?
Regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
resources.
And as any feature it require future maitenance.
But without this, speed of string manipulations is not efficient and database
require to have optimized speed in every possible aspect.
Regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
75801
2019-02-13 00:07
2019-02-13 01:07
Regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
ersion: WI-T4.0.0.1435 Firebird 4.0 Beta 1
SUCCESSFUL TIMES DONE: 282094 vs 901743
Regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
is not problem in Delphi, then i suppose no problem in Firebird too.
User should know what he do and on what data.
e.g. a[5][2] can be one dimension array (index 5) of Varchar (second char) – no
problem for me.
Regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lis
PAGE_SIZE
SuperServer 2.5.9
P:\DB\OLTP2.FDB
ON
2
262144
8192
ACTION
AVG_TIMES_PER_MINUTE
AVG_ELAPSED_MS
SUCCESSFUL_TIMES_DONE
JOB_BEG
JOB_END
*** OVERALL *** for 60 minutes:
1263.35
46980
75801
2019-02-13 00:07
2019-02-13 01:07
Regards,
Karol Bieniaszewski
Firebird-Devel mailing
5.9
P:\DB\OLTP2.FDB
ON
2
262144
8192
ACTION
AVG_TIMES_PER_MINUTE
AVG_ELAPSED_MS
SUCCESSFUL_TIMES_DONE
JOB_BEG
JOB_END
*** OVERALL *** for 60 minutes:
6414.48
1786
384869
2019-02-14 19:56
2019-02-14 20:56
Regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
>> I thought that OLTP tests operated on a fixed dataset size.
Starting point is the same record count, but during test, new documents are
created.
And if server is faster (and better SMP) then more new documents are created.
Regards,
Karol Bieniaszewski
Firebird-Devel mailing lis
Do you have permanent (dummy) connection to Firebird3 SS database?
If not connect to database and then run test.
Permanent connection cause to do not clear SuperServer cache.
Regards,
Karol Bieniaszewski
Od: Gabor Boros
Wysłano: czwartek, 24 stycznia 2019 10:30
Do: firebird-devel
>> as the field stores the UTC time
I know naive but..
If conversion table is not available then if it is stored as utc why not
showing it as
„15:09:49 UTC”?
PS. one more dll is not the problem for me, but maybe for others..
regards,
Karol Bieniaszewski
Firebird-Devel mailing lis
Thank you for pointing this out.
Really good description in the article
Regards,
Karol Bieniaszewski
Od: Adriano dos Santos Fernandes
Wysłano: piątek, 26 kwietnia 2019 18:23
Do: For discussion among Firebird Developers
Temat: [Firebird-devel] Open-sourcing F14 for memory-efficient hash tables
Better show your commands in isql then we can reproduce problem.
Regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
r steps (following my comments above) and get no error (FB 2.5).
I have tested this by 2 instances of Flamerobin.
But i have tested this under FB3 (WI-V3.0.4.32989 Firebird 3.0) not 2.5.
I have not 2.5 installed as i have migrated all to FB3.
Regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
You have right, there is a bug and the big one!
I suppose that index of Foreign Key is not validated by existence of value in
the record itself and its (the record version) transaction numer is not
compared to snapshot number.
Please report a bug to the tracker.
regards,
Karol Bieniaszewski
Hi
First you must download fixed version of Firebird (current one on the official
page is not working properly).
Look into http://tracker.firebirdsql.org/browse/CORE-5888.
There is a link for fixed version provided by Alexander Peshkov.
Look if it is working for you.
Regards,
Karol
s to reproduce
this.
Regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
of RDB$GET_TRANSACTION_CN.
But it still do not use and index to query. And my question was about optimize
this part to use an expression index somehow.
Regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
nsaction 1
3. Start transaction 2 snapshot
4. Start transaction 3 snapshot
5. Start transaction 4 read commited
>> See RDB$GET_TRANSACTION_CN, described at
>> doc/sql.extensions/README.builtin_functions.txt
Super
Regards,
Karol Bieniaszewski
Firebird-Devel mailing list,
Ach now i understand. It is point view for current transaction, which record
versions it see.
Very usefull, thank you.
Regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
May i ask if this is big developmenet cost to support it on the client side api?
Maybe it is shorter time than this disscussion
I try make this discussion lighter
Regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird
In my humble opinion it should be released ASAP or 3.0.6 should be removed from
download.
As this is about several server hangs regressions.
regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
s like
>> insert into t (b) values (:b);
Only need to set flag for blob in that situations and in next assignment create
new one with flag set to false
Regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
was using same machine, big cache and second run of the queries.
regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
>> If feature belongs to both lists - is it allowed or denied?
Please explain how?
>> If it does not belong to both them?
Its usege should be considered as use at own risk.
regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourcefor
.
Master/slave is technical thing. It is in any electronic with magistral.
And think about. If i write white people i am rasist or only when i write black
people? I suppose in non of this. There must be some violence against people.
In software there is not.
regards,
Karol Bieniaszewski
Firebird-Devel
>> we may have black list instead white list like now.
As always better is to have both black + white.
Regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
As in title – Firebird tracker „Service Temporarily Unavailable”.
And i do not suppose it is good practice to provide server details:
„Apache/2.2.3 (CentOS) Server at tracker.firebirdsql.org Port 80”
regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https
Really great feature
but i am worried about the title „package (FB 5.0)”.
Is it for FB4 or for the future version FB5?
regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Settings written to database only, not stored outside.
Then there is not something like the „defaults”.
There many other scenarions not only 1/0.
It can be date and time stored into generator values and more…
I think about replicating generators at all.
regards,
Karol Bieniaszewski
Od: Dimitry
or 0 (off).
regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
as it was accepted
and preffered.
It only require some rework for publicity or simply show it as draft and then
extend/correct.
regards,
Karol Bieniaszewski
Od: Mark Rotteveel
Wysłano: sobota, 22 maja 2021 09:39
Temat: Re: [Firebird-devel] Increasing CHAR/VARCHAR max. length to 64KB
On 22-05
ers itself
And this will require more time from you.
regards,
Karol Bieniaszewski
Od: Mark Rotteveel
Wysłano: wtorek, 27 kwietnia 2021 13:27
Do: firebird-devel@lists.sourceforge.net
Temat: Re: [Firebird-devel] The issue tracker for the Firebird core moveis done
?
On 27-04-2021 13:15, marius adrian
As Udf’s are depricated, are somwhere all current udfs rewriten in udr form?
I mean about fbudf.dll and ib_udf.dll and with source code to look at it as a
sample for self written „udr_udf” ?
regards,
Karol Bieniaszewski
Od: Dimitry Sibiryakov
Wysłano: niedziela, 31 stycznia 2021 17:57
Do
replication on
replica side? And anothere on another replica side... It is more natural.
But maybe i am wrong here, please explain more this option.
regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Now it have more sense, thx
regards,
Karol Bieniaszewski
Od: Dmitry Yemanov
Wysłano: środa, 27 października 2021 09:18
Do: For discussion among Firebird Developers
Temat: Re: [Firebird-devel] Cascade replication
27.10.2021 09:06, Karol Bieniaszewski wrote:
>
> Can you point me
>
it is „Ch” one
letter .
regards,
Karol Bieniaszewski
Od: Omacht András
Wysłano: sobota, 6 listopada 2021 13:19
Temat: Re: [Firebird-devel] ODP: RFC: Fix for issue 6915
It is a rule, but hungarian languages have some of this "rules" / "cases".
"SÁG"/"SÉG&q
understand description of performance
degradation?
regards,
Karol Bieniaszewski
Od: Pavel Cisar
Wysłano: czwartek, 4 listopada 2021 15:14
Do: firebird-devel@lists.sourceforge.net
Temat: Re: [Firebird-devel] RFC: Fix for issue 6915
Mama mia, here we go again.
I have no intention to get sucked e
Hi
Snapshots are not avilable
http://web.firebirdsql.org/download/snapshot_builds/win/3.0
and whole page http://web.firebirdsql.org/
Regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
RF.RDB$RELATION_NAME=R.RDB$RELATION_NAME)
And same when GROUP BY
Regards,
Karol Bieniaszewski
Od: Adriano dos Santos Fernandes
Wysłano: czwartek, 6 stycznia 2022 02:28
Do: For discussion among Firebird Developers
Temat: [Firebird-devel] ExprNode::FLAG_VALUE
Hi!
There is ExprNode::FLAG_VALUE
-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
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) VALUES(5, coalesce
: 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
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
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
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 Bieniaszewski
when i work
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
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
://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
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
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
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
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
SuperIndex for string serching
Key: CORE-4687
URL: http://tracker.firebirdsql.org/browse/CORE-4687
Project: Firebird Core
Issue Type: New Feature
Components: Engine
Reporter: Karol
: 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 as /* #1 */ - you got
invalid
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
-
nothing more
: 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
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
-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
: 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
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), R NATURAL
: 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
: 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
/ 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
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
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.
://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: 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
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
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
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 FOR '2017-09-22
://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
: 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
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 with FIELD
1 - 100 of 140 matches
Mail list logo