Re: [firebird-support] embedded database with Chinese path

03.10.2017 2:25, Hamish Moffatt ham...@risingsoftware.com [firebird-support] wrote: > Any ideas? Give up. Firebird does not support unicode characters in database name and path. Only ANSI. -- WBR, SD.

Re: [firebird-support] embedded database with Chinese path

03.10.2017 11:05, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > Forgive me for butting in, but... Perhaps it's high time to change FB > then? Unicode is "everywhere" these days, and FB should keep up. It is a lot of work, so the path (https://github.com/aafemt/fir

[firebird-support] Service restore from stdin

Hello. When I use isc_info_svc_line for sending a piece of backup to server, everything works well. But when I use just replace isc_info_svc_line with isc_info_svc_to_eof, no errors is produced, but database is not restored. Do I something wrong or it is a bug (incomplete implementati

Re: [Graymail] [firebird-support] Service restore from stdin

03.10.2017 16:43, 'Sabbagh, Nariman' nariman.sabb...@delta.com [firebird-support] wrote: > Does anybody know what the server name is I used 'localhost' but AFAIU it should be irrelevant. -- WBR, SD. +++

Re: [firebird-support] Service restore from stdin

04.10.2017 11:42, Pavel Cisar pci...@ibphoenix.cz [firebird-support] wrote: > You can't use isc_info_svc_line for sending backup file to the service. But that's what fbsvcmgr does. > The right token is isc_info_svc_stdin. No, it is only for getting buffer size from server. I have no idea w

Re: [firebird-support] Service restore from stdin

04.10.2017 11:42, Pavel Cisar pci...@ibphoenix.cz [firebird-support] wrote: > Until stdin is fully transmited service may need another > chunk, but reply to application is blocked until stdout buffer (eof > request) is full, so everything gets stuck (service will not ask for > further input beca

Re: [firebird-support] Service restore from stdin

04.10.2017 16:24, Dimitry Sibiryakov wrote: >   I.e. server just wasting network throughput requesting no data from client > as if > request timeout is by default set to zero instead of infinity. Oops, I was wrong: even explicitly set timeout don't make service to wait before sending input

Re: [firebird-support] Service restore from stdin

04.10.2017 18:28, Pavel Cisar pci...@ibphoenix.cz [firebird-support] wrote: > Nope, without requesting isc_info_svc_line output you can't know when > service actually finished, so you may close the service at will. If you > close it *after* its finished then everything is ok, but if not, you > will

Re: [firebird-support] Connected databases to the Server

07.10.2017 22:57, 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support] wrote: > Which databases are connected, right now? Use MON$ATTACHMENTS with SYSDBA rights. -- WBR, SD. +

Re: [firebird-support] Backup Firebird 3.0.2 database using Service Manager

09.10.2017 16:08, pierr...@gmail.com [firebird-support] wrote: > If I try to use a remote connection to service_mgr RTFM -expected_db. -- WBR, SD.

Re: [firebird-support] "Invalid Cursor State"

17.10.2017 20:12, Jorge Andres Brugger jorge.brug...@gmail.com [firebird-support] wrote: > What am I doing wrong? You cannot fetch from non-select query. -- WBR, SD.

Re: [firebird-support] "Invalid Cursor State"

19.10.2017 18:11, Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support] wrote: > The real nightmare of a programmer is not when the program doesn't work > and she/he doesn't know why; it's when the program does work and she/he > doesn't know why :) https://docs.microsoft.com/en-us/sql/o

Re: [firebird-support] Index process in Firebird 2.1.4

20.10.2017 5:45, gn7s...@gmail.com [firebird-support] wrote: > I want to know whether the following index is picked by the optimizer. You can know that if you run (or just prepare) the query in isql with "SET PLAN ON". -- WBR, SD. -

Re: [firebird-support] Re: MON$REMOTE_ADDRESS

31.10.2017 20:44, m_brahi...@yahoo.fr [firebird-support] wrote: > Is there a document which explains that ? https://en.wikipedia.org/wiki/Ephemeral_port -- WBR, SD. +

Re: [firebird-support] Primary key composed by multiple integer fields

11.11.2017 11:13, m_brahi...@yahoo.fr [firebird-support] wrote: > I need to know please if it is allowed that a primary key has multiple > integer fields ? Yes, but usually it is a sign of a bad database design. > a PK that has seven integer fields will it decrease the performance table ?

Re: [firebird-support] Primary key composed by multiple integer fields

11.11.2017 13:15, m_brahi...@yahoo.fr [firebird-support] wrote: > All fields contained in the PK are updated is that mean by operations > affected ? No. Operations are: select, insert, update, delete. Update may change PK values or not, select can do index scan or full scan. All this are dif

Re: [firebird-support] NBackup Backup Takes Long Time For Level 2.

15.11.2017 7:49, Anto Edin Charley antoedinchar...@gmail.com [firebird-support] wrote: > For every Level 2 Backup it takes more than 30 Minutes to complete. Is there > anything i > need to Check/Improve 1) Try switch -d. NBackup should work at disk's speed. 2) You can migrate to Firebird 3 wher

Re: [firebird-support] Re: Rename a foreign key

16.11.2017 12:20, michael.vilhelm...@microcom.dk [firebird-support] wrote: > I do know, that its a onetime thing, but if Ihave to wait for it to finish > all I want to > change, I will not do it. Run script in evening, get results in morning. -- WBR, SD. --

Re: [firebird-support] Copy Table to Another Database

21.11.2017 10:01, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > How can I copy all records of a table to another table in different database. > The tables > having same design. Use "execute statement on external datasource". -- WBR, SD. ---

Re: [firebird-support] Copy Table to Another Database

21.11.2017 15:52, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > Please see if the under mentioned procedure is good enough: I would do the contrary: select on external source and local insert. It is better for performance. But if your SP work for you, it is good. -- WBR

Re: [firebird-support] query with no result

24.11.2017 8:53, alauren...@gmail.com [firebird-support] wrote: > I have a query with no results and I doo't understand what I do wrong: Conditions in your query will never met: you are asking for record that ARE in tempsub and at the same time ARE NOT in tempsub. -- WBR, SD.

Re: [firebird-support] Re: query with no result

24.11.2017 11:22, alauren...@gmail.com [firebird-support] wrote: > Because of that matter, I manufacture that query :) Remove TEMPSUB from FROM clause. -- WBR, SD. +++

Re: [firebird-support] Trouble establishing a connection to Firebird database files.

27.11.2017 11:35, Justis Root justis.r...@gmail.com [firebird-support] wrote: > What should I be checking first? First of all, carefully read error message. It usually contain a reason of failure. > What info am I missing from this description in order to make assisting me > easier? The

Re: [firebird-support] Deadlock error from firebird during midnight

30.11.2017 14:31, 'Joje' j...@codework-solutions.com [firebird-support] wrote: > Interesting part is this error occurs only at midnight from 12 to 2 AM. > Thereafter, > everything goes smoothly without any error. I tried replicating this on my > test machine > but no success. > > On analysing

Re: [firebird-support] Deadlock error from firebird during midnight

01.12.2017 17:32, j...@codework-solutions.com [firebird-support] wrote: > I got this errors only during midnight. Thereafter it's working fine. It may pretend to work fine, but using default transaction isolation level in .NET provider is just a disaster waiting to happen. It is the reason of

Re: [firebird-support] Slow execution of Stored Procedure after 20 min. inactivity

05.12.2017 10:07, Marcel Brink mbr...@xploration.onmicrosoft.com [firebird-support] wrote: > Does anyone have an idea why this happens only after around 20 minutes and > not every time ? You should, probably, turn performance counters output in trace as well. May be in these 20 minutes some

Re: [firebird-support] Problem with CONTAINING and COLLATE

07.12.2017 18:46, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote: > Why does the connection charset count? Because you are sending queries in connection charset. And string literals in them are in connection charset. Because of that your 'x' cannot have COLLATE PXW_HUNDC. -- WBR,

Re: [firebird-support] Problem with CONTAINING and COLLATE

08.12.2017 11:56, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > I don't agree with this. The string literal is in the connection > character set, but the value should be converted to the target character > set (of the column) for the comparison No. Imagine connection charset t

Re: [firebird-support] Problem with CONTAINING and COLLATE

08.12.2017 12:07, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > It should return no results. If it can't transliterate, it means that > the character definitely does not exist in the target column, so the > comparison is false. When character is transliterated into charset whe

Re: [firebird-support] Deadlock error from firebird during midnight

12.12.2017 7:32, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > “Error reading data from the connection” has again surfaced This is a server crash. This instruction may be useful for you to help developers fix it: http://ibphoenix.com/resources/documents/development/doc_35 -

Re: [firebird-support] Deadlock error from firebird during midnight

12.12.2017 13:28, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > 1. I have generated DMP files for : > (a) The Firebird server - size 62,028 KB and > (b) My .NET Application - size 2,65,968 KB > > 2. Please let me know how do I share these DMP files. If your database does not c

Re: [firebird-support] Re: Deadlock error from firebird during midnight

14.12.2017 9:00, hv...@users.sourceforge.net [firebird-support] wrote: >> 1. The PID remains same: 4212, before and after the exception is caught. > >   I.e. there was no crash of Firebird, very good. But still Firebird that just dropping connection instead of returning a proper error is no

Re: [firebird-support] Re: Deadlock error from firebird during midnight

14.12.2017 11:25, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > I need to keep my deployed application running, and would happily trade off > connection > pooling/SMP etc for robust connection. Any suggestions please ? First of all, look into firebird.log. Perhaps, disconnect

Re: [firebird-support] Re: Deadlock error from firebird during midnight

14.12.2017 11:34, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: >  INET/inet_error: read errno = 10054, client host = RajivPC, address = > 192.168.42.134/52754 , user = rdsc1 If these data match your .NET application, then you have problem with net

Re: [firebird-support] Re: Deadlock error from firebird during midnight

14.12.2017 12:03, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > 1. Here server and client both are on the same machine, RajivPC. It does not matter. Still there is software (and may be even hardware) between server and your application. > 2. Execution of only one stored proc

Re: [firebird-support] Re: Deadlock error from firebird during midnight

14.12.2017 12:27, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > 1. No, I did not. How do I do this? Google is your friend. For example: https://stackoverflow.com/questions/41980813/firebird-net-provider-and-embedded-server-3/41981523#41981523 -- WBR, SD. --

Re: [firebird-support] Lock Conflict

15.12.2017 12:04, OB1 oldbasf...@googlemail.com [firebird-support] wrote: > Yes. A pre-insert on both that checks the data and assigns a PK from a > generator if one's > not assigned. Also checks valid data has been assigned and sets NEW.blah.  No > interaction > with other tables in anyway.

Re: [firebird-support] Lock Conflict

15.12.2017 12:21, OB1 oldbasf...@googlemail.com [firebird-support] wrote: > RecVersion = false That's bad. Change to true. -- WBR, SD. ++ Visit ht

Re: [firebird-support] Info

19.12.2017 16:34, Nico Speleers nico.spele...@carfac.com [firebird-support] wrote: > I want to know the next Id number in my table Addresses without an insert. In > my example > it will be 3. I want to reserve (without an insert) Id number 3 because > someone else can > also ask the next Id nu

Re: [firebird-support] Firebird 3.0.3 no longer compatible with InterBase 7.5.1 clients

19.12.2017 4:32, FSPAPA INCA Team i...@foodstuffs-si.co.nz [firebird-support] wrote: > Wireshark traces show that the server is sending all the data from the query, > but the > client is not recognising it and waits forever So, you, actually, should ask Embarcadero why their client cannot wo

Re: [firebird-support] Firebird 3 client API to connect FB 2.5 database server

03.01.2018 11:51, Mauricio Junqueira mau...@gmail.com [firebird-support] wrote: > Is there a way to change WireCrypt and AuthServer in the Database Params > Buffer? Use isc_dpb_config hack. -- WBR, SD.

Re: [firebird-support] Firebird 3 client API to connect FB 2.5 database server

03.01.2018 21:38, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > Use isc_dpb_config hack. > > Which is? Please do not just drop vague hints, but actually provide an > answer if you know it. Documentation and examples of the new API barely > exist (or at least, I'm not aware of

Re: [firebird-support] Query and problem with nulls

04.01.2018 12:36, Luigi Siciliano luigi...@tiscalinet.it [firebird-support] wrote: > The following query works fine but returns*all nulls* if no rows > between :DaData and :AData Are you sure that your query really returns all nulls and this is not a visual bug in the tool you run this quer

Re: [firebird-support] Query and problem with nulls

04.01.2018 16:55, Luigi Siciliano luigi...@tiscalinet.it [firebird-support] wrote: > As you see: > - if I select between 01/01/2018 and 31/12/2018 the are not rows in DT > - if I select between 01/01/2017 and 31/12/2017 works fine because the > are at least 1 row in DT So, where is the problem

Re: [firebird-support] Query and problem with nulls

04.01.2018 17:13, Luigi Siciliano luigi...@tiscalinet.it [firebird-support] wrote: > if I select between 01/01/2018 and 31/12/2018 I not have results! this > because there are no rows in DT between 01/01/2018 and 31/12/2018. That's right. No rows - no result. If you want this result, add into

Re: [firebird-support] garbage problem

05.01.2018 18:09, HuI HaO huihaoc...@hotmail.com [firebird-support] wrote: > currently i have an application at client side runing a timer 5s keep do the > select sql > read the Table as status on server DB. after few day run the fb service hang > up and slow > respond the DB file size also inc

Re: [firebird-support] Using a selectable stored procedure

06.01.2018 15:19, m_brahi...@yahoo.fr [firebird-support] wrote: > Heres is a sample code of the SP There is no point in such SP. You'll get only bad performance and no advantages. -- WBR, SD. ++

Re: [firebird-support] Activate all indexes

08.01.2018 23:09, fredf...@hotmail.com [firebird-support] wrote: > No exception raised but indexes ar e not ac tivated! What is wrong? How can I > activate all > indexes correctly? 1. Indexes are activated on commit. 2. You don't need to use script component in Delphi, "execute block" is a sing

Re: [firebird-support] Firebird 3.0.1 freezes on one table for some 10-20 minutes during backup after gfix/mend

11.01.2018 9:14, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > Are there any ideas what happens and how to prevent it? Do you run gbak with -g switch? -- WBR, SD. +++

Re: [firebird-support] Firebird 3.0.1 freezes on one table for some 10-20 minutes during backup after gfix/mend

11.01.2018 11:29, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > No, we don't use -g. You should. > We are doing immedate restore anyway after each backup. It is very doubtful practice. Immediate restore into different place is good for many reasons, but need in replacing origina

Re: [firebird-support] Firebird 3.0.1 freezes on one table for some 10-20 minutes during backup after gfix/mend

11.01.2018 13:21, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > My understanding is that mend can not and it should not cause any troubles. Your understanding is wrong. This switch is intended to save at least some data from a dead database with gbak. After you used it, database is b

Re: [firebird-support] "Over the wire" Connection Encryption: AES

26.01.2018 13:37, daniel.acherm...@logismos.com [firebird-support] wrote: > One of our customer is interested in the Firebird 3 feature of a "over the > wire" > connection encryption. This customer however prefers the AES-protocol instead > of the > default plug in with arc4. AES can hardly

Re: [firebird-support] Miscalculation of floating points in Firebird

26.01.2018 16:17, Salim Naufal s.nau...@softnet.me [firebird-support] wrote: > I am not familiar with the details of the SQL standard, is this the proper > was to round > and calculate numeric values in SQL? Yes. In your first examples you don't use floating point numbers, but exact decimals

Re: [firebird-support] Does gstat "max version">1000 indicates about problems?

09.02.2018 13:54, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > Are such values for max version dangerous? What can I do and what should I do > not to avoid > such large max version values? They are not dangerous, but very unpleasant because make your database slow. You must carefu

Re: [firebird-support] Adding a field with NOT NULL constraint

10.02.2018 16:32, Aldo Caruso aldo.car...@argencasas.com [firebird-support] wrote: > I discovered that when a field is added to a table with a NOT NULL > constraint and a default value, it is automatically filled with that > default value. No, it isn't. It would be too slow. Default value i

Re: [firebird-support] Firebird:Search All Fields In All Tables For A Specific Value

11.02.2018 22:03, iorip...@sina.com [firebird-support] wrote: > How to find out witch tables and fields include this Value? Dump whole database into text file(s) with IBexpert then grep. -- WBR, SD.

Re: [firebird-support] FB 2.5 backed-up DB cannot be restored, msg about Malformed String and "Use -FIX_FSS_DATA option."

20.02.2018 16:36, dco...@sympatico.ca [firebird-support] wrote: > I've Googled a lot about this and that -FIX_FSS_DATA option seems to only > really be > relevant when restoring DBs from much earlier versions of FB - but this is > from the same > version! Version of engine doesn't matter in

Re: [firebird-support] Cannot open database file in local hard disk

20.02.2018 0:31, Eduardo guse...@gmail.com [firebird-support] wrote: > If I use C:\Test\MYDATABASE.FDB I get "unavailable database". > If I use SERVERNAME:C:\Test\MYDATABASE.FDB I get "unavailable database". > If I use \\SERVERNAME\C:\Test\MYDATABASE.FDB I get "unavailable database". > > If I modi

Re: [firebird-support] SecurityDatabase in FB3

21.02.2018 13:46, Alexander Tabakov a.taba...@eklektica.com [firebird-support] wrote: > > What happens in case 3 (stored in the same database) when we move the > database on a > different server. Shall credentials stored in place take precedence over the > other > server's configuration?

Re: [firebird-support] Re: SecurityDatabase in FB3

22.02.2018 6:22, Alexander Tabakov a.taba...@eklektica.com [firebird-support] wrote: > So, generally speaking are there any benefits of embedding the credentials > into the > database - performance, security, other ? You don't need to backup/replicate two databases, one is enough. -- W

Re: [firebird-support] No permission to remote access to database

22.02.2018 11:15, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > How to add permission to login into security3.fdb? Locally you don't need any special permission. Remotely you must edit databases.conf to enable that. -- WBR, SD. -

Re: [firebird-support] Read only user for Firebird 3.

22.02.2018 20:07, Alexandre Vinhaes - Tecnico - Tecnologia alexandre.vinh...@cipa.com.br [firebird-support] wrote: > I need to have a read only login (read all views and tables) for specifc > application > connection. Some those views executes procedures internally. So, in this > case, select

Re: [firebird-support] Execute Block: too many inserts

01.03.2018 19:43, ho...@agencybusys.com [firebird-support] wrote: > What is the best way to accomplish very large batches? If data is plain (without BLOBs) then using of external tables is the fastest way. -- WBR, SD. --

Re: [firebird-support] Execute Block: too many inserts

01.03.2018 20:37, ho...@agencybusys.com [firebird-support] wrote: > I suspect it would be true if the source data was already in a table on the > server, but > mine is newly entered data by a user on a network client. In this case I'd suggest to use prepared statement in single transaction.

Re: [firebird-support] C++/C compiler for Firebird 3 UDF on Windows - free version?

08.03.2018 12:44, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > Just wanted to know if there is available free (of charge) C++/C compiler for > Firebird 3 > UDFs on Windows - 32 bit and 64 bit? GCC (MinGW). -- WBR, SD. ---

Re: [firebird-support] Re: Can many Execute Blocks be within a Transaction.

13.03.2018 9:30, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > and in Firebird 3 when using the old API (most applications use > the old API). Actually 64k limit is applied to statement in ISC API only if length of statement is indicated explicitly and function declarations

Re: [firebird-support] BLOB Not Found error

16.03.2018 14:47, shg_siste...@yahoo.com.ar [firebird-support] wrote: > Since some days ago I'm getting (it seems very occasionally and randomly) a > "blob not > found" error. > As far as I remember the problem happens during read operations: with > "locate" commands or > inside a "while not eo

Re: [firebird-support] BLOB Not Found error

16.03.2018 15:26, shg_siste...@yahoo.com.ar [firebird-support] wrote: > The same applies if the record wasn't deleted but changed by another > transaction? Yes. From technical POV there is no difference between update and delete in Firebird. -- WBR, SD. ---

Re: [firebird-support] Impossible to create a new database from a script

17.03.2018 14:50, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > >   DEFAULT CHARACTER SET ISO8859_1 > >   COLLATION ES_ES; > > > > What character set is the script file using? Is it using UTF-8 or > WIN1252? You are currently probably connecting using NONE. > > If the script

Re: [firebird-support] Impossible to create a new database from a script

17.03.2018 18:07, 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support] wrote: > Sorry, but I don't understand. The script file is a plain text file. Exactly because if that it has a definite encoding. And you, as its author, must know what encoding you used when pr

Re: [firebird-support] Network disconnection

19.03.2018 10:34, atuncce...@duzen.com.tr [firebird-support] wrote: > Sometimes, on some computers the application crashes with this error, which > can be seen in > the event log: > > > Faulting application name: duzen_test.exe, version: 1.5.5.9106, time stamp: > 0x2a425e19 > Faulting module n

Re: [firebird-support] Trailing spaces behaviour

20.03.2018 15:34, Alexander Tabakov a.taba...@eklektica.com [firebird-support] wrote: > > Is this by design :) Yes, it is by SQL standard. -- WBR, SD. ++

Re: [firebird-support] Firebird UDF Access configuration failing

27.03.2018 9:14, rgilland1...@gmail.com [firebird-support] wrote: > Does anyone know why? Because your old formatting violated rules, described in comments for this parameter. -- WBR, SD. ++

Re: [firebird-support] Re: Firebird UDF Access configuration failing

27.03.2018 11:46, rgilland1...@gmail.com [firebird-support] wrote: > Have read closely the comments on the parameter, and cannot see how it > violates them "If you choose Restrict, *provide _';'_ -separated trees list*, where UDF libraries". -- WBR, SD. ---

Re: [firebird-support] Re: Firebird UDF Access configuration failing

27.03.2018 12:10, rgilland1...@gmail.com [firebird-support] wrote: > So how should I format the below? > > UdfAccess = Restrict UDF C:\Program Files (x86)\Firebird\Firebird_2_1\UDF Quoting Firebird.conf: > # DatabaseAccess = Restrict C:\DataBase > # DatabaseAccess = Restrict C:\DataBase;D:\Mi

Re: [firebird-support] Firebird UDF Access configuration failing

27.03.2018 12:49, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > Dimitry, it would be more helpful if you explicitly pointed out the > problem instead of giving vague hints. Yes, but giving a fish to a man used to be considered less helpful than teaching him how to fish. --

Re: [firebird-support] Firebird log, error

29.03.2018 15:32, atuncce...@duzen.com.tr [firebird-support] wrote: > What might be causing this, any ideas? NULL pointer to an object most likely. See call stack for details. -- WBR, SD. +++

Re: [firebird-support] Auto-increment generating old ID's for insertion

03.04.2018 7:19, 'Joje' j...@codework-solutions.com [firebird-support] wrote: > _Trigger that calls generator is fired on insertion:_ Try to add some logging into this trigger to detect cases when record is inserted with application-provided _ID and thus generator is not used. -- WBR, S

Re: [firebird-support] segfault

06.04.2018 13:57, atuncce...@duzen.com.tr [firebird-support] wrote: > Is the IP expression in the logs show the IP of the client? If yes, how do I > decode it? :) It shows IP register of CPU at the moment of crash. You can track the crashes using core dump as described in http://ibphoenix.co

Re: [firebird-support] IB XE7 to FB 3 Migration

10.04.2018 22:16, j...@firstduews.com [firebird-support] wrote: > I am trying to migrate my IB database to FB. When I do the backup/restore > process It > errors on on a table. You cannot migrate database between Interbase and Firebird using backup-restore. They are different DBMS now. C

Re: [firebird-support] Book on T-SQL

18.04.2018 12:24, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: > I want to use TSQL in Firebird Give up. Firebird supports standard SQL to some extend. T-SQL supports standard SQL to some extend. Firebird has no support for T-SQL. -- WBR, SD. --

Re: [firebird-support] Write UDF for 3.0 - Linux 64bit vs Windows 32bit

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" is not what you think. Use nm to check that TEST_UDF is really exported (remember about case sensitivity) and library is rea

Re: [firebird-support] Write UDF for 3.0 - Linux 64bit vs Windows 32bit

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';" It means that in your firebird.conf you have "UDFAccess = Full" which is not default and a very bad idea from security POV. --

Re: [firebird-support] UDF "returning" BLOB slow after first call

23.04.2018 16:18, tvd...@ymail.com [firebird-support] wrote: > It seems to be that call to blob_put_segment that becomes slow. At first > usage of the UDF > it's almost instant, and after that it takes 15ms for every invocation. > > What causes this and can I avoid it? Data, returned from UD

Re: [firebird-support] Re: aliases.conf ignored?

25.04.2018 14:42, Harald Wolf leaw...@gmx.de [firebird-support] wrote: > What the heck is going wrong here? Process Monitor will show where Firebird look for aliases.conf, if at all. -- WBR, SD.

Re: [firebird-support] Dynamic PSQL (Execute Statement) in Stored Procedure With "SELECT / INTO"

25.04.2018 22:33, blackfalconsoftw...@outlook.com [firebird-support] wrote: > It seems that no matter how I try to implement the "INTO" clause against the > return > variable, when I run the procedure from my DB-Manager it yields an error... INTO belongs to EXECUTE STATEMENT clause, not to ex

Re: [firebird-support] Transaction ID overflow

01.05.2018 9:19, Brian Dunstan brian.duns...@health.telstra.com [firebird-support] wrote: > If we move to dialect 3, does the TID become 64 bits? It is 48 bits in Firebird 3. -- WBR, SD. +++

Re: [firebird-support] gbak of encrypted database

01.05.2018 7:57, 'Alexey Kovyazin (ak)' a...@ib-aid.com [firebird-support] wrote: > If you're implementing your own plugin,  you can implement whatever you need. Oh, really? How server plugin can affect what client utility does? -- WBR, SD. ---

Re: [firebird-support] Measure the effectiveness of incrementing page buffer...

03.05.2018 7:56, Javier Cintron fcintr...@yahoo.com [firebird-support] wrote: > Firebird ver 2.5.7.27050 64 bits > Windows Server 2012R2 > > ¿Is there a way to calculate the effectiveness of incrementing the page cache > buffer ? select cast(mon$page_reads as double precision)/mon$page_fetche

Re: [firebird-support] Proper way to handle an open Firebird database...

03.05.2018 16:11, Javier Cintron fcintr...@yahoo.com [firebird-support] wrote: > 1. When I need to copy my Firebird database: Do I need to shutdown the > Firebird instance > first? and If y es, what is the proper way to shutdown and startup it? You may shut it down or use nbackup or use A

Re: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure

03.05.2018 23:04, blackfalconsoftw...@outlook.com [firebird-support] wrote: > However, I though only the issuance one "SUSPEND" was enough to flush the > entire buffer of > all records... No. One SUSPEND - one record in result set. Two SUSPENDs - two records and so on. Watch this in isql

Re: [firebird-support] What regular maintenance actions does Firebird need in order to function properly?

04.05.2018 4:55, Javier Cintron fcintr...@yahoo.com [firebird-support] wrote: > what other regular maintenance actions does Firebird need in order to > function properly? It may be a good idea to recalculate index statistics from time to time. -- WBR, SD. --

Re: [firebird-support] Measure the effectiveness of incrementing page buffer...

04.05.2018 11:42, Alexey Kovyazin a...@ib-aid.com [firebird-support] wrote: > the single badly designed query with many page fetches can "improve" this > parameter a lot, > without any real improvement in the performance, of course. The question was about cache effectiveness which is always m

Re: [firebird-support] Create a table from Query

04.05.2018 14:04, antoedinchar...@gmail.com [firebird-support] wrote: > Is there any way we could create a table in Firebird using the query? No. Firebird cursors (implicit and explicit) are more powerful than MS SQL's ones and let developers avoid local temporary tables completely. --

Re: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure

04.05.2018 18:13, Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support] wrote: > If you look at my procedure below, you will note that there is only a single > "SUSPEND" > statement. If you look a little more, you'll see that it is called in a loop. -- WBR, SD. -

Re: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure

04.05.2018 20:10, blackfalconsoftw...@outlook.com [firebird-support] wrote: > Nonetheless, I have worked with Oracle, Sybase, MySQL, and a little > PostgreSQL and SQLite. I can't believe that you never looked at Oracle's FOR LOOP syntax in pipelined functions which difference from Firebird i

Re: [firebird-support] Deactivate triggers inside EXECUTE BLOCK

07.05.2018 7:43, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > I'm looking for a way to run a simple update on couple tables without calling > triggers Modify your trigger to check some context variable and skip actions. Then do something like that: EXECUTE BLOCK AS declare var

Re: [firebird-support] Strange SIMILAR TO result

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 > RDB$DATABASE > > Why is the result true? Your expression is actually calculated as "CAST(''='' as CHAR(5)) SIMILAR TO '[A-Z]{2}[0-9A-Z]{2,13}'".

Re: [firebird-support] Strange SIMILAR TO result

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 TO '[A-Z]{2}[0-9A-Z]{2,13}' FROM > RDB$DATABASE; > > is > > === > Perhaps, it must be CHAR(4) or VARCHAR. I'm not sure in type of im

Re: [firebird-support] Guid in firebird

08.05.2018 16:28, ymak1...@yahoo.com [firebird-support] wrote: > Any ideas? Do not use CHAR_TO_UUID(). Store and use GUIDs in binary form using parametrized queries. -- WBR, SD.

<    1   2   3   4   5   6   7   8   >