+1
András
Feladó: Jiří Činčura
Elküldve: 2022. augusztus 11. 16:46
Címzett: For discussion among Firebird Developers
Tárgy: Re: [Firebird-devel] BLOB_APPEND and NULL
I was thinking the same when reading the discussion on GH. I believe it's not
late to ma
Dear developers,
I have a test case which running fine on 2.5 and 3.0 but faild on 4.0 with "no
current record for fetch operation".
Unfortunately I could not reproduce it as a simple case, but I can send the
database in private.
The error occurs when a stored procedure delete record from a tab
Yes, Thank you Team!
András
-Original Message-
From: Mark Rotteveel [mailto:m...@lawinegevaar.nl]
Sent: Wednesday, November 17, 2021 7:58 PM
To: firebird-devel@lists.sourceforge.net
Subject: Re: [Firebird-devel] Plans for 3.0.8
On 06-11-2021 08:30, Omacht András wrote:
> Hi
bject: Re: [Firebird-devel] ODP: RFC: Fix for issue 6915
On 06/11/2021 10:08, Omacht András wrote:
> Yes, this is a huge problem. When you order you have to know CS is CS or C
> and S.
>
> E.g.:
> CICA
> CUKOR
> CSIGA
> is the good order, not
> CICA
> CSIGA
> CUKOR
(My dog pushed the ball away with a paw)
And this is the correct sorting order, because CCS have to transfered in your
mind to CSCS when you order the words This has a very logical reason, but I
will not bore you with this... :)
András
-Original Message-
From: Omacht A
ember 6, 2021 1:45 PM
To: firebird-devel@lists.sourceforge.net
Subject: Re: [Firebird-devel] ODP: RFC: Fix for issue 6915
On 06/11/2021 09:19, Omacht András wrote:
> It is a rule, but hungarian languages have some of this "rules" / "cases".
>
> "SÁG"/"SÉ
, November 6, 2021 1:09 PM
To: firebird-devel@lists.sourceforge.net
Subject: Re: [Firebird-devel] ODP: RFC: Fix for issue 6915
2021.11.06. 12:35 keltezéssel, Omacht András írta:
>
> Gábor, am I correct?
>
I think yes.
But at searching as a user I want to get ZEBRA and ZSIRÁF too if use
pers
Subject: Re: [Firebird-devel] ODP: RFC: Fix for issue 6915
On 06/11/2021 08:35, Omacht András wrote:
> For example, in the word of "IGAZSÁG", ZS is not a letter, but here two, a Z
> and an S.
Is it an exception to the rule or it it another rule?
Adriano
Firebird-Devel
Yes, if you have these data:
ANIMALS table
ANIMAL_TYPE
CICA
CSIGA
DARÁZS
ZEBRA
ZSIRÁF
Grammatically the correct solution:
select animal_type from animals where animal_type starting with 'C';
CICA
select animal_type from animals where animal_type starting with 'CS';
CSIGA
select animal_type fro
Hi All,
it's November now.
Any chance of coming out in the near future?
3.0.7 was released October 20, 2020.
András
[cid:image001.png@01D7D2E8.83347DE0]<http://www.libra.hu/>
CÉGÜNK A LIBRA CSOPORT TAGJA
OMACHT ANDRÁS
fejlesztési igazgató
LIBRA Szoftver Zrt.
1113 Budapes
Hi All,
it's November now.
Any chance of coming out in the near future?
3.0.7 was released October 20, 2020.
András
-Original Message-
Sent: Monday, September 6, 2021 12:46 PM
Subject: Re: [Firebird-devel] Plans for 3.0.8?
06.09.2021 13:31, Omacht András wrote:
>
> is 3.0
Hi,
From: Dimitry Sibiryakov [mailto:s...@ibphoenix.com]
> 2) Keep non active parts of a database on slow disks (having big
> volume)
This part is meaningless because good storages provide storage tiering at
block level.
For You maybe meaningless, but believe me a lot of users will lo
-devel@lists.sourceforge.net
Cc: Simonov Denis
Subject: Re: [Firebird-devel] Tablespaces proposal
Omacht András писал(а) в своём письме Thu, 07 Oct
2021 09:18:26 +0300:
> Hi Roman!
>
> First of all, thanks for the development and offering it to Firebird.
>
> Do you plan to par
Hi Roman!
First of all, thanks for the development and offering it to Firebird.
Do you plan to partition the data depending on field value?
Oracle range partitioning example:
CREATE TABLE sales_range
(salesman_id NUMBER(5),
salesman_name VARCHAR2(30),
sales_amount NUMBER(10),
sales_date
Dear Developers,
see following article:
https://blog.jooq.org/10-cool-sql-optimisations-that-do-not-depend-on-the-cost-model/#top8
Could Firebird support these optimization solutions?
For us, the inverse predicate would be more useful.
Should I create a ticket in the tracker?
András
Firebird-
Hi All,
is 3.0.8 expected to be released in the near future?
https://firebirdsql.org/en/roadmap/ says:
"v3.0.8 is the next point release to come, it's scheduled for Q2 2021. Follow
the "Track Details" icon for a list of bugfixes scheduled for this version."
Thanks!
András
__ Infor
completly different as others even if you divide two
numeric values.
András
-Original Message-
From: Omacht András [mailto:omacht.and...@libra.hu]
Sent: Wednesday, September 1, 2021 6:14 PM
To: For discussion among Firebird Developers
Subject: Re: [Firebird-devel] Dialect 3 inconsistent
tent round/trunc - configurable
calculation method needed
On 9/1/21 7:13 PM, Omacht András wrote:
> (Or please support D1 and don’t force developers to rewrite existing
> codebase.)
May be I've missed something - but did we have plans to remove Dialect 1? It
seems that not.
Firebi
Mark,
before Attila started this discussion we asked a development colleague who has
also been developing Firebird-based systems for a long time.
Here is his sort answer:
"The truth is that we sucked it with D3 15 years ago. Therefore, when we
started the new system, we released the numeric ty
Hi!
I don't know if this is the right list for the documentation. Sorry if not.
At this page
https://www.firebirdsql.org/pdfmanual/html/gfix-transactions.html#d0e34704
then note mentioned the limbo transaction example is based on 1.5.
If someone can update it, here is a newer one from 2.5:
[ro
From: Mark Rotteveel [mailto:m...@lawinegevaar.nl]
Sent: Sunday, June 13, 2021 9:57 AM
To: firebird-devel@lists.sourceforge.net
Subject: Re: [Firebird-devel] Stored procedure call and parameter concatenation
outside the parentheses
On 13-06-2021 07:48, Omacht András wrote:
[..]
> Why is a valid ca
Hi All!
CREATE EXCEPTION GL_EX 'Something.';
create or alter procedure EX (
msg varchar(100))
as
begin
exception gl_ex msg;
end
execute procedure ex('Exception') || 'message'
GL_EX.
Exceptionmessage.
At procedure 'EX' line: 5, col: 3.
execute procedure ex('Exception ') || 'message';
Hi All,
just for the archive, finally Dmitry and my colleague Gábor find out what was
the problem and it is solved now:
https://github.com/FirebirdSQL/firebird/issues/6848
Thank you both!
András
-Original Message-
From: Omacht András [mailto:omacht.and...@libra.hu]
Sent: Tuesday
Dear Developers!
My colleagues have done what I have proposed and undertaken.
The issues are closed or marked as closable or confirmed to still exist.
András
From: Omacht András [mailto:omacht.and...@libra.hu]
Sent: Monday, May 24, 2021 8:16 PM
To: For discussion among Firebird Developers
PM
To: firebird-devel@lists.sourceforge.net
Subject: Re: [Firebird-devel] Deprecations
On 27/05/2021 07:49, Omacht András wrote:
> Hi Virgo and all!
>
>
>
> I also did some tests on 3.0.8.33468
>
>
>
> I had a table with 2.8 million records. I tested with
Firebird-devel
[mailto:firebird-devel@lists.sourceforge.net]
Sent: Thursday, May 27, 2021 9:29 AM
To: firebird-devel@lists.sourceforge.net
Cc: Virgo Pärna
Subject: Re: [Firebird-devel] Deprecations
On Thu, 20 May 2021 11:45:22 +, Omacht András
mailto:omacht.and...@libra.hu>> wrote
Dear Developers!
My team has been developing an ERP system using Firebird RDBMS for almost 18
years.
After Interbase times, we moved to Firebird from 1.0 to 2.5 during this time.
We've been working for years on the transition to 3.0 and dialect 3, this year
maybe the time will come for us to mov
-
From: Mark Rotteveel [mailto:m...@lawinegevaar.nl]
Sent: Thursday, May 20, 2021 10:29 AM
To: firebird-devel@lists.sourceforge.net
Subject: Re: [Firebird-devel] Deprecations
On 2021-05-20 08:28, Omacht András wrote:
> Mark: Yes, that could be good, but it’s not even in 4.0, so (one day)
&
lto:m...@lawinegevaar.nl]
Sent: Wednesday, May 19, 2021 8:04 PM
To: firebird-devel@lists.sourceforge.net
Subject: Re: [Firebird-devel] Deprecations
On 2021-05-19 19:40, Omacht András wrote:
> Hi!
>
> Since Firebird 2.5, we have been able to replace almost all UDFs with
> built-in functio
Hi!
Since Firebird 2.5, we have been able to replace almost all UDFs with built-in
functions.
There is only one left (it’s the Highlander :)) : formatting dates and
timestamps to readable format for hungarian people:
-- Hungarian format
select to_char(cast('TODAY' as date), '.MM.DD') from
-
From: Dimitry Sibiryakov [mailto:s...@ibphoenix.com]
Sent: Tuesday, May 18, 2021 4:00 PM
To: For discussion among Firebird Developers
Subject: Re: [Firebird-devel] Replication - generators' value are not replicated
18.05.2021 14:45, Omacht András wrote:
> We have very complex and long
: [Firebird-devel] Replication - generators' value are not replicated
18.05.2021 14:36, Omacht András wrote:
> Ok, let's see the following example:
>
> Master:
> CREATE SEQUENCE TMP_GEN_2;
> commit;
>
> CREATE TABLE TMP_TABLE (
> VC VARCHAR(10)
> );
&
#x27;); commit;
-- At this point in master and replica's generator has the same value: 1
update tmp_table set vc = 'B';
commit;
-- At this point master's generator value is 2, but the replica's generator
value is 1.
The last update is a commited DML...
CÉGÜNK A LIBRA CSOPO
rator
value is 1.
The last update is a commited DML...
CÉGÜNK A LIBRA CSOPORT TAGJA
OMACHT ANDRÁS
fejlesztési igazgató
LIBRA Szoftver Zrt.
1113 Budapest, Karolina út 65.
+36 (1) 255-3939
i...@libra.hu | www.libra.hu
-Original Message-
From: Dimitry Sibiryakov [mailto:s...@ibphoenix.c
Hi Dimitry,
I commited, as shown in my example.
Master:
select gen_id(tmp_gen_1, 1) from rdb$database;
-- Result: 1 - OK
commit;
(In my opinion, replication should work for rollback anyway.)
CÉGÜNK A LIBRA CSOPORT TAGJA
OMACHT ANDRÁS
fejlesztési igazgató
LIBRA Szoftver Zrt.
1113 Budapest
Hi!
FB4 - 4.0.0.2489
We tried the following in both (sync, async) modes:
Master:
CREATE SEQUENCE TMP_GEN_1;
commit;
(The sequence was created fine in replicas.)
Master:
select gen_id(tmp_gen_1, 1) from rdb$database;
-- Result: 1 - OK
commit;
select gen_id(tmp_gen_1, 0) from rdb$database;
-- Re
Hi!
FB4 - 4.0.0.2489
We tried the following in both (sync, async) modes:
Master:
CREATE SEQUENCE TMP_GEN_1;
commit;
(The sequence was created fine in replicas.)
Master:
select gen_id(tmp_gen_1, 1) from rdb$database;
-- Result: 1 - OK
commit;
select gen_id(tmp_gen_1, 0) from rdb$database;
-- Re
Hi Mark,
on the conference in Berlin 2019 Q4 was told.
Andras
Eredeti üzenet
Feladó: Mark Rotteveel
Dátum: 2019. 11. 02. 12:36 (GMT+01:00)
Címzett: firebird-devel@lists.sourceforge.net
Tárgy: Re: [Firebird-devel] Plan for releasing Firebird 3.0.5?
On 2-11-2019 11:39, Gab
] Core-5658 tested
09.03.2019 12:01, Omacht András wrote:
> Hi All!
>
> I’m unable to add comment tot he tracker,
Hmm... it is strange, you should be able to comment at tracker...
> so I send it:
>
> http://tracker.firebirdsql.org/browse/CORE-5658
>
> Hi Vlad!
>
Hi All!
I'm unable to add comment tot he tracker, so I send it:
http://tracker.firebirdsql.org/browse/CORE-5658
Hi Vlad!
We tested it and works well.
Is it possible to backport it to 3.0 (and 2.5)?
András
__ Information from ESET Mail Security, version of virus signature
databa
] PostgreSQL vs. fsync error
On 2/17/19 10:35 AM, Omacht András wrote:
> Dear Developers,
>
> https://wiki.postgresql.org/wiki/Fsync_Errors
>
> Firebird can be also involved in the problem?
>
> Perodically we have corrupted databases on linux (85% wrong page
> type). And this canno
Dear Developers,
https://wiki.postgresql.org/wiki/Fsync_Errors
Firebird can be also involved in the problem?
Perodically we have corrupted databases on linux (85% wrong page type). And
this cannot be reproduced for ages. Currently we are running FB 2.5.8 on 4.1.12
kernel.
Thanks.
Andras
Fire
keltezéssel, Omacht András írta:
> The database file and the tmp directory located on ramdisk.
What was the filesystem of the ramdisk? Tmpfs?
Gabor
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
__ Information from ESET M
Hi!
I suggested this database trigger type in the ticket, but this BEFORE and AFTER
RESET one would better meet the needs, I prefer such an implementation.
András
-Original Message-
From: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com]
Sent: Wednesday, May 23, 2018 12:40 PM
T
Or starting with
--
Omacht András
Fejlesztési igazgató
Eredeti üzenet
Feladó: Dimitry Sibiryakov
Dátum: 2018. 04. 28. 14:25 (GMT+01:00)
Címzett: For discussion among Firebird Developers
Tárgy: Re: [Firebird-devel] CHAR fields in system tables
28.04.2018 13:38, fbbt wrote
[Firebird-devel] Meltdown and Spectre
András,
> -Original Message-
> From: Omacht András [mailto:aoma...@mve.hu]
> Sent: Wednesday, January 10, 2018 9:08 AM
> finally we choose the easiest way, backup the system and update it to
> Debian SID.
>
> # uname -a
> Linux
Sean,
finally we choose the easiest way, backup the system and update it to Debian
SID.
# uname -a
Linux firebirdtest 4.14.0-3-amd64 #1 SMP Debian 4.14.12-2 (2018-01-06) x86_64
GNU/Linux
Average running time: 641 secs (10 mins 41 secs)
András
-Original Message-
From: Leyne, Sean [mai
;
On Tue, Jan 9, 2018 at 11:52 AM, Omacht András
mailto:aoma...@mve.hu>> wrote:
Hi!
Just for the shake of information.
Our test system running on Debian 9.3.
processor : 7
vendor_id : GenuineIntel
cpu family : 6
model : 23
model name : Intel(R)
Hi!
Just for the shake of information.
Our test system running on Debian 9.3.
processor : 7
vendor_id : GenuineIntel
cpu family : 6
model : 23
model name : Intel(R) Xeon(R) CPU E5420 @ 2.50GHz
stepping: 6
microcode : 0x60b
cpu MHz :
Hi!
"With this I don't know whether the RETURNING returns NULL as a new value or
nothing was updated. I would have to go to PSQL and use ROW_COUNT or something
like that."
Workaround:
update foobar set foo = 2 where id = 1 returning id, bar;
if id is null then bar null values is valid, otherwi
And THANK YOU!
OMACHT ANDRÁS
-Original Message-
From: Carlos H. Cantu [mailto:lis...@warmboot.com.br]
Sent: Tuesday, April 19, 2016 3:43 PM
To: For discussion among Firebird Developers
Subject: Re: [Firebird-devel] Firebird 3.0 Is Available Now
Congratulations to everyone involved
No, sorry, I can only bid for SmartGit.
OMACHT ANDRÁS
fejlesztési igazgató
Libra Szoftver Zrt.
1113 Budapest, Karolina út 65.
Tel.: +36 1 255 3939
Fax: +36 1 209 1477
http://www.libraszoftver.hu
-Original Message-
From: Dimitry Sibiryakov [mailto:s...@ibphoenix.com]
Sent: Tuesday
No, with git log you can see every previous version of a file without closing
the IDE, switching branches, etc.
The only requirement is FB2.0, FB2.5, FB3.0 branches must be stored in the same
repository.
OMACHT ANDRÁS
fejlesztési igazgató
Libra Szoftver Zrt.
1113 Budapest, Karolina út 65
per merge base for merging
is automatically done for us and is generally very easy to do. These features
help encourage developers to create and use branches often. "
OMACHT ANDRÁS
fejlesztési igazgató
Libra Szoftver Zrt.
1113 Budapest, Karolina út 65.
Tel.: +36 1 255 3939
Fax: +36 1 2
ideas, etc.),
- more than 10k TEXT files, less than 100 binary files (an other project
shown us, GIT with many (> 10k), frequently changed binary files CAN BE very
slow !!!)
- more than 42k commits
and takes maximum 10 secounds to change from one branch to another.)
OMACHT ANDRÁS
fejleszt
55 matches
Mail list logo