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
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
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
>
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
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
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
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
Reporter: Karol Bieniaszewski
Add cumulative time during query execution. Query can be be stalled and active
back in long intervals but it can be relative short as a whole.
Look at discussion with Vlad Khorsun in CORE-6456 maybe you find more
fields/statistics to add.
--
This message
Reporter: Karol Bieniaszewski
Provide the way to see info about packet read in trace.
I mean e.g.:
Table have 1 records.
I do SELECT * FROM MY_TABLE
But i do not read all records at start (do not fetch all) but i read data in
packets e.g. 300 records at one time.
Such statement
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
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
Components: Engine
Reporter: Karol Bieniaszewski
Priority: Minor
Now when we try to create index on big e.g. VARCHAR(1000) field
we got an error
"key size too big for index XXX".
But this is not definitly true as it depend on page size.
Will be good if the mess
.
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
>> 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
>> 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
-6324
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.5
Reporter: Karol Bieniaszewski
After comment in CORE-1202 Mark Rotteveel ask me for creating new bug ticket.
CREATE DOMAIN XXX Varchar(1000) CHARACTER SET
: Karol Bieniaszewski
Please provide easy access to the info:
- next attachment id
- next statement id
Currently we can read in easy way only next transaction id as
MON$NEXT_TRANSACTION in MON$DATABASE.
Next statement id we can read from joining current attachment with
mon$statements.
But next
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
: Engine
Affects Versions: 3.0.5, 3.0.6
Reporter: Karol Bieniaszewski
Look at this not trivial query but migrated to use only system tables to show
the problem.
Alias "U" is not available in the CTE "ZAWIESZENIA".
If you remove whole WHERE from the main query the
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
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
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,
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.5
Reporter: Karol Bieniaszewski
Priority: Trivial
SELECT CURRENT_USER, CURRENT_TRANSACTION, CURRENT_TIME, CURRENT_DATE,
CURRENT_TIMESTAMP, LOCALTIME, LOCALTIMESTAMP FROM RDB$DATABASE
result:
USERCURRENT_TRANSACT
URL: http://tracker.firebirdsql.org/browse/CORE-6167
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.4, 3.0.5
Reporter: Karol Bieniaszewski
Priority: Minor
do nota analyse logic here, this is onl
Provide snapshot builds for Android port
Key: CORE-6153
URL: http://tracker.firebirdsql.org/browse/CORE-6153
Project: Firebird Core
Issue Type: Task
Reporter: Karol Bieniaszewski
Please
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
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
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
s to reproduce
this.
Regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
/CORE-6124
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.5
Reporter: Karol Bieniaszewski
SET TERM ^ ;
CREATE PROCEDURE PSTRID
( IN_ID1 VARCHAR(100), IN_ID2 VARCHAR(100))
RETURNS
( ID1 VARCHAR(100), ID2 V
Issue Type: New Feature
Components: GBAK
Reporter: Karol Bieniaszewski
Please add switch to gbak to restore database with specified transaction number.
E.g. Interbase have this as "-START(ING_TRANS)" the name can be different.
I suppose it is very simple to implement
Reporter: Karol Bieniaszewski
Attachments: COREXXX.FDB
WITH KWARTALY AS
(SELECT
*
FROM
KWARTAL KW
WHERE
KW.CKWARTAL BETWEEN '2019.I
Reporter: Karol Bieniaszewski
Firebird incorrectly check for nested CTE.
Below query have not nested CTE
WITH X AS
(
SELECT 6 AS NUMBER FROM RDB$DATABASE
)
SELECT * FROM RDB$RELATIONS R
WHERE
NOT EXISTS(
WITH Y AS
(
SELECT 6 AS NUMBER FROM RDB$DATABASE
)
SELECT
isql -i should stop after first error
-
Key: CORE-6092
URL: http://tracker.firebirdsql.org/browse/CORE-6092
Project: Firebird Core
Issue Type: Bug
Components: ISQL
Reporter: Karol
: http://tracker.firebirdsql.org/browse/CORE-6082
Project: Firebird Core
Issue Type: Bug
Components: Engine, GBAK, SVCMGR
Affects Versions: 3.0.5
Environment: Windows 2008R2
WI-V3.0.5.33100 Firebird 3.0
Reporter: Karol Bieniaszewski
Attac
>> 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
: Firebird Core
Issue Type: Improvement
Components: Engine
Reporter: Karol Bieniaszewski
CREATE TABLE NAMES
(
NAME VARCHAR(100)
);
commit;
INSERT INTO names
SELECT RF.RDB$FIELD_NAME FROM RDB$RELATION_FIELDS RF;
commit;
CREATE ASCENDING INDEX IXAE_NAMES__NAME ON NAMES
Affects Versions: 4.0 Beta 1, 3.0.4
Reporter: Karol Bieniaszewski
Now when you have fresh Firebird installation - you got an error
Engine Code: 335545029
Engine Message :
Install incomplete, please read the Compatibility chapter in the release notes
for this version
Can
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
Provide running counters in the explained plan
--
Key: CORE-6030
URL: http://tracker.firebirdsql.org/browse/CORE-6030
Project: Firebird Core
Issue Type: New Feature
Reporter: Karol
/CORE-6024
Project: Firebird Core
Issue Type: Bug
Environment: Windows 2008R2
FB3.0.5.33100
Reporter: Karol Bieniaszewski
Something was broken between versions FB3.0.4.33063 vs FB3.0.5.33100
Under FB3.0.4.33063 there was possibility to specify or
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
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
>> 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
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
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
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
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
/browse/CORE-5997
Project: Firebird Core
Issue Type: New Feature
Components: Engine
Reporter: Karol Bieniaszewski
Please implement simple operations on strings in stored procedures, triggers,
functions..
i mean:
s[5] = 'A';
s[5] = s[6];
xxx = s[5] + s[3
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
>> 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
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
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
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
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.
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
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
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
)
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
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
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
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
dsql.org/browse/CORE-5941
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.4, 3.0.5
Reporter: Karol Bieniaszewski
try altering not existing trigger
SET TERM ^ ;
ALTER TRIGGER XYZXX
ACTIVE AFTER DELETE POSITION 1000
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
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
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
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
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
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
Issue Type: Bug
Affects Versions: 3.0.3, 4.0 Beta 1, 3.0.4
Reporter: Karol Bieniaszewski
SELECT RDB$GET_CONTEXT('SYSTEM', 'CURRENT_USER'), RDB$GET_CONTEXT('SYSTEM',
'CLIENT_ADDRESS'), R.RDB$CHARACTER_SET_NAME FROM RDB$DATABASE R
UNION
SELECT RDB$GET_CONTEXT('SYSTEM
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
Allow NULLS LAST in CREATE INDEX
Key: CORE-5914
URL: http://tracker.firebirdsql.org/browse/CORE-5914
Project: Firebird Core
Issue Type: Improvement
Components: Engine
Reporter: Karol
Index only operations
-
Key: CORE-5909
URL: http://tracker.firebirdsql.org/browse/CORE-5909
Project: Firebird Core
Issue Type: New Feature
Components: Engine
Reporter: Karol Bieniaszewski
Type: Bug
Components: Engine
Affects Versions: 3.0.4
Environment: WI-V3.0.4.32954 Firebird 3.0
Reporter: Karol Bieniaszewski
CREATE TABLE TEST
(
F_NUMERIC_2_1 NUMERIC(2,1)
, F_NUMERIC_10_2 NUMERIC(10, 2)
);
commit;
INSERT INTO TEST2 (F_NUMERIC_2_1
: Engine
Affects Versions: 3.0.3
Environment: Android 8.0
Firebird version: LI-V3.0.3.32900
Reporter: Karol Bieniaszewski
Any select from Firebird containing numeric data type cause
"Fixed length column [F_NUMERIC] data length mismatch. Value length - [2],
column
/CORE-5876
Project: Firebird Core
Issue Type: New Feature
Components: Engine
Affects Versions: 3.0.4
Reporter: Karol Bieniaszewski
This is important to know the reason of the error - especially if it is caused
by udf function
DECLARE EXTERNAL FUNCT
Components: Engine
Affects Versions: 3.0.4
Environment: WI-V3.0.4.32954 Firebird 3.0
Reporter: Karol Bieniaszewski
Priority: Critical
SET TERM ^ ;
CREATE FUNCTION FUN2(A CHAR(8), B CHAR(4), C CHAR(12)) RETURNS CHAR(2)
AS
DECLARE VARIABLE VAR_RESULT
: Engine
Affects Versions: 3.0.3, 3.0.4
Reporter: Karol Bieniaszewski
CREATE TABLE TEST
(
ID1 INTEGER,
ID2 INTEGER,
ID3 INTEGER,
X NUMERIC(18,2),
CONSTRAINT PK_TEST PRIMARY KEY(ID1, ID2, ID3)
);
CREATE INDEX IXA_TEST__X ON TEST(X);
CREATE INDEX IXA_TEST__ID1_X ON TEST(ID1, X
Components: Engine
Affects Versions: 3.0.4
Environment: WI-V3.0.4.32985 Firebird 3.0
Reporter: Karol Bieniaszewski
Something was broken recently.
Below sql is working under
WI-V3.0.4.32954 Firebird 3.0
but cause an error under
WI-V3.0.4.32972 Firebird 3.0
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
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
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
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
1 - 100 of 140 matches
Mail list logo