2020. 01. 24. 14:29 keltezéssel, Matthias Winkler spmm...@gmail.com
[firebird-support] írta:
> @Mark: I see the very same issue with firebird 3.0.4. Any ideas?
I suggest try with 3.0.5 also.
Gabor
2019. 10. 21. 18:17 keltezéssel, Stefan Heymann li...@stefanheymann.de
[firebird-support] írta:
> If you want to have it for free, like in
> free beer, you can sit down, write it and publish it
This is the plan. ;-)
Gabor
-
2019. 10. 09. 5:57 keltezéssel, Alex Castillo acr_k...@yahoo.com
[firebird-support] írta:
> I'm asking myself how much time I'll still be using Firebird if the
> project evolves slow, there is no t GUI officially maintened and the
> cool features are for the commercial companies.
Yes, slooow n
2019. 05. 01. 11:47 keltezéssel, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] írta:
> 01.05.2019 11:44, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote:
>>I need a detailed recipe to increase
>> the gap.
>
> In isql: "Set transaction no auto
Hi All,
I need to know all stored procedure variable names from a (2.5)
database. I not see these in system tables like parameters or fields.
But I see these with a text editor. For example...
Create a new database and a procedure in it:
CREATE PROCEDURE MY_PROC AS DECLARE VARIABLE MY_VAR INTE
2019. 05. 01. 16:24 keltezéssel, hv...@users.sourceforge.net
[firebird-support] írta:
> > After this step firebird.log contains:
> >
> > SRV Wed May 01 14:54:40 2019
> > Sweep is started by SWEEPER
> > Database "EMPLOYEE"
> > OIT 156, OAT 20157, OST 20157, Next 20157
> >
> > SRV Wed May 01
2019. 05. 01. 11:47 keltezéssel, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] írta:
> In isql: "Set transaction no auto undo" + any DML + rollback.
Thank you very much! Now I can manage the gap! :-)
So I made a gap-setter application then try...
Windows 10 64bit, 2.5.8 Classic 3
Hi All,
I try to reproduce a real life database corruption problem with 2.5.8
Classic (Linux 64bit). Which depend on the automatic sweep feature
maybe. The formula is: Oldest snapshot (OST) - Oldest transaction (OIT)
> Sweep interval. Right? I tried many ways but cannon increase the gap
betwe
2019. 01. 21. 9:37 keltezéssel, Ertan Küçükoğlu
ertan.kucuko...@1nar.com.tr [firebird-support] írta:
> 1- Is there easier way to install firebird 2.5 on this Debian 9 Stretch
> server?
Yes. I always use the official binary tar.gz and works like a charm
(with Debian 9 and 10, CentOS 7, etc.).
Cl
2018. 11. 07. 8:51 keltezéssel, hv...@users.sourceforge.net
[firebird-support] írta:
> There should be no crash. Errors - yes, crash - no.
> Attached log is truncated and i see no message about crash there.
https://pastebin.com/0iv3FQcy
Gabor
--
2018. 11. 08. 12:40 keltezéssel, hv...@users.sourceforge.net
[firebird-support] írta:
> And I use web-interface for this group, surprise ?
Vlad,
I can send the attachment privately. Which address?
Gabor
++
2018. 11. 07. 8:51 keltezéssel, hv...@users.sourceforge.net
[firebird-support] írta:
> There should be no crash. Errors - yes, crash - no.
> Attached log is truncated and i see no message about crash there.
The firebird.log not exists when started the OLTP. My second message
contains the whol
Hi All,
While I executed some OLTP with 2.5(.9.27119 SS Win64) and no more space
for the database the server crashed. See the attachment. Is it a known
limitation (not fixed in 2.5 because it's too old) or a bug?
Gabor
[Non-text portions of this message have been removed]
2018. 09. 02. 17:03 keltezéssel, 'Christian Giesen' ch...@xt.co.za
[firebird-support] írta:
> Good day,
>
> Using Firebird 3.0.3.
>
> RAD Studio 10.2.2 (Tokyo)
>
> I have a need to generate unique sequential invoice/credit note numbers.
> I fully understand the usage of generators to produce u
2018. 06. 04. 16:17 keltezéssel, liviuslivius
liviusliv...@poczta.onet.pl [firebird-support] írta:
> I understand that data from real database are restricted.
> But what is the query plan for my CTE?
A VIEW based on a VIEW then JOIN-ed with a VIEW which contains the CTE.
So the plan is complex.
2018. 06. 01. 14:33 keltezéssel, Gabor Boros mlngl...@bgss.hu
[firebird-support] írta:
> Switched on BugcheckAbort and later found a core file in /tmp. See the
> gdb output below. Any idea?
An other bt below. Is it say something to anybody?
Reading symbols from /opt/firebird/bin/
2018. 06. 01. 17:33 keltezéssel, liviuslivius
liviusliv...@poczta.onet.pl [firebird-support] írta:
> Hi,
>
> can you show some sample?
> And what indexes have you created?
> Can you show plan for both queries and real queries itself?
> What filter "where" are you using?
>
> I am really interest
2018. 05. 31. 21:02 keltezéssel, Gabor Boros mlngl...@bgss.hu
[firebird-support] írta:
> Hi All,
>
> I found some "firebird terminated abnormally (-1)" errors in
> firebird.log on my development machine. How can I detect it's source?
> My tip is a self mad
2018. 05. 31. 21:00 keltezéssel, Gabor Boros mlngl...@bgss.hu
[firebird-support] írta:
> 2018. 05. 30. 20:03 keltezéssel, 'livius' liviusliv...@poczta.onet.pl
> [firebird-support] írta:
>> Hi,
>>
>> better is walk throught tree
>
>
> What a simplic
Hi All,
I found some "firebird terminated abnormally (-1)" errors in
firebird.log on my development machine. How can I detect it's source?
My tip is a self made UDF (no input parameter, one TIMESTAMP output and
written with Free Pascal). Can I stress test the UDF/problem somehow? (I
know the
2018. 05. 30. 20:03 keltezéssel, 'livius' liviusliv...@poczta.onet.pl
[firebird-support] írta:
> Hi,
>
> better is walk throught tree
What a simplicity! :-) Thank you very much Karol!
Gabor
++
2018. 05. 30. 16:51 keltezéssel, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] írta:
> Recursive CTEs always make my head hurt, but if I understand the intent
> correctly, you should replace it with:
>
> select ti.id, t.parent_id
> from table1 t
> inner join table1 root on t.parent_id =
2018. 05. 30. 16:04 keltezéssel, Omacht András aoma...@mve.hu
[firebird-support] írta:
> Hi Gábor!
>
> Now I can only test on 2.5.8, and it works:
András,
I tried now with 2.5.8 and got same error as with 3.0.3. Your TABLE1
contains all 12 rows?
Gabor
2018. 05. 29. 19:08 keltezéssel, Omacht András aoma...@mve.hu
[firebird-support] írta:
> Hi Gabor!
>
> You can do it with recursive cte:
First of all, thank you very much! But...
I got "multiple rows in singleton select multiple rows in singleton
select" (yes, double) error message with my re
Hi All,
I have a table (see below) with some parent/child data. I want to know
very top parent of every child. So the expected result (with below test
data) is:
ID,TOP_PARENT_ID
1,NULL
2,1
3,1
4,1
5,1
6,1
Is this result can be produced with a recursive CTE? (I tried already
without success.)
2018. 05. 07. 14:46 keltezéssel, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] írta:
> 07.05.2018 13:57, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote:
>> So I see what you say. But result of
>>
>> SELECT CAST(''='' AS CHAR(5)) SIMILAR
2018. 05. 07. 14:31 keltezéssel, liviuslivius
liviusliv...@poczta.onet.pl [firebird-support] írta:
> Hi,
>
> It is false for me
> But i put '=' in single quote with double it does not work. I use
> FB3.0.4.32954 dialect 3
Nothing double quote. ''='' is a boolean expression, empty string equal
2018. 05. 07. 12:26 keltezéssel, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] írta:
> 07.05.2018 12:19, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote:
>> A simple example: SELECT ''='' SIMILAR TO '[A-Z]{2}[0-9A-Z]{2,13}' FROM
>&
Hi All,
I accidentally (copy/paste :-) ) make a wrong SELECT which give back
strange (true) result for me.
A simple example: SELECT ''='' SIMILAR TO '[A-Z]{2}[0-9A-Z]{2,13}' FROM
RDB$DATABASE
Why is the result true? I use 3.0.3.
Gabor
--
2018. 04. 19. 16:15 keltezéssel, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] írta:
> 19.04.2018 15:34, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote:
>> I found it! :-) Works on Linux too if "... MODULE_NAME
>> '/opt/firebird/UDF/MY_UDF';&q
2018. 04. 19. 13:16 keltezéssel, Gabor Boros mlngl...@bgss.hu
[firebird-support] írta:
> DECLARE EXTERNAL FUNCTION TEST_UDF BIGINT RETURNS PARAMETER 1
> ENTRY_POINT 'TEST_UDF' MODULE_NAME 'MY_UDF';
I found it! :-) Works on Linux too if "... MODULE_NAME
2018. 04. 19. 13:23 keltezéssel, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] írta:
> 19.04.2018 13:16, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote:
>> What I am doing wrong?
>
> Your function does not match its definition: "RETURNS PARAMETER 1"
Hi All,
I use 3.0.3 SS on Linux 64bit and need to know the server's UTC
timestamp. First started with a simple example UDF which written with
FreePascal 3.0.4. See below. After many trying without success I
realized my example works like a charm with Win32. (Just compiled with
"fpc MY_UDF.pas"
2017. 12. 19. 21:13 keltezéssel, setysvar setys...@gmail.com
[firebird-support] írta:
> Why would you want collate AFTER containing? I must admit I haven't
> tried your queries in Fb 3.0 (I'm still on 2.5), but I'd say the
> sensible way to specify what you want, would be
>
> SELECT * FROM TABLE1
Hi All,
After the original "Problem with CONTAINING and COLLATE" thread I
switched to UTF8 but not happy with it. The optional COLLATE after
CONTAINING have no effect, the database default COLLATION used. See the
below examples. Tried with 3.0.3.32854 snapshot and Linux 64bit (Ubuntu
14.04.1).
Hi All,
I have a database with default UTF8 character set and UNICODE_CI collation:
CREATE DATABASE 'MYDB' PAGE_SIZE 4096 DEFAULT CHARACTER SET UTF8
COLLATION UNICODE_CI;
Execute the next script:
CREATE COLLATION UNICODE_CI_AS_HU FOR UTF8 FROM UNICODE_CI ACCENT
SENSITIVE 'LOCALE=hu_HU';
ALTE
Hi All,
I have a database with DEFAULT CHARACTER SET WIN1250 COLLATION PXW_HUN
and a table in it:
CREATE TABLE TABLE_1 (NEV VARCHAR(60) CHARACTER SET WIN1250 COLLATE
PXW_HUN);
Connect with ISQL:
isql 1.2.3.4:MYDB -charset UTF8 -user myadmin -password mypasswd
Execute this:
SELECT * FROM TABLE
Hi All,
The table have a BEFORE UPDATE trigger. Now I need a check before the
existing trigger code and raise an exception if needed. I can write the
check into the existing trigger before the existing code. But can create
a new trigger with a lower position than the existing one. Is there any
Hi All,
> record from transaction x is stuck in limbo
Source of this is an IBX transaction handling problem which already
fixed in SVN:
https://svn.mwasoftware.co.uk/viewvc/public?view=revision&revision=63
https://svn.mwasoftware.co.uk/viewvc/public/ibx/trunk/fbintf/client/3.0/FB30Transaction.
2017. 04. 26. 16:44 keltezéssel, hv...@users.sourceforge.net
[firebird-support] írta:
>Hi Gabor
>
>Do you have reproducible example ? Could you send it to me (or
> regiser at tracker), please ?
I send a test case to your address in this minutes. Hope that helps.
Gabor
---
2017. 04. 26. 16:44 keltezéssel, hv...@users.sourceforge.net
[firebird-support] írta:
>Hi Gabor
>
>Do you have reproducible example ? Could you send it to me (or
> regiser at tracker), please ?
I have a test data generator GUI(one form one button) application and a
database. I can send
Hi All,
I created a test data generator for my application.
Start transaction, execute SP1, execute SP2 in random 1-10 times,
commit. Start transaction, execute SP3, commit. SP1 and SP2 just insert
data to the database but SP3 is more complex thing. The application
works (do the above things in
Hi All,
When I create a new database with 3.0 and want the security database in
the database itself follow the next steps:
isql -user SYSDBA employee
CREATE USER MYOWNER PASSWORD 'ooo' GRANT ADMIN ROLE;
isql -user MYOWNER employee
CREATE DATABASE 'MYDB' ...
isql -user MYOWNER MYDB
CR
43 matches
Mail list logo
