Stack Overflow
Stack Overflow

Questions tagged [firebird-3.0]

For questions specific to Firebird 3.0. It is advisable to also tag with firebird.

Firebird 3.0 is a previous release of the Firebird database server. The latest release is .

Notable new features

  • Unified executable
  • Improved SMP support for SuperServer
  • Encrypted wire protocol
  • Per-database configuration
  • Multiple security databases
  • Improved SQL user management
  • BOOLEAN data type
  • IDENTITY support
  • PSQL packages
  • PSQL functions
  • DDL triggers
  • SQL Window (or analytical) functions

Resources

See also

211 questions
1
vote
2 answers

Select closest maximal numeric value in Firebird

Imagine there're 2 tables, let's call them "Master" and "Detail": Master -------------------------------- | ID | field_1 | ... | field_n | -------------------------------- Detail -------------------------------------------- | ID | master_id |…
Old Skull
  • 165
  • 7
1
vote
0 answers

Firebird 3 not using index in plan

I am trying understand why Firebird 3 does not use an index in my simplified query below. If I run it without the plan clause it uses PLAN JOIN (L NATURAL, T INDEX (FK_TRANS_LEDGER), P INDEX (IDX_PRODUCTIONS1)) If I explicitly add the plan with the…
Tony
  • 48
  • 1
  • 9
1
vote
1 answer

Jaybird SocketInputStream.socketread0 thread blocking

I am using JDBC connection to firebird. org.firebirdsql.jdbc jaybird-jdk18 3.0.5 When I am reading data with: resultSet.next(); //resultSet is instance of FBResultSet sometimes thread…
Altair
  • 325
  • 3
  • 16
1
vote
0 answers

"too many open handles to database" and ibase_prepare

On my new brand AWS server I have a big problem with PHP and Firebird DB. Current configuration: Debian 10 (buster) PHP 7.3.11-1~deb10u1 (cli) (built: Oct 26 2019 14:14:18) ( NTS ) LI-V3.0.5.3310 Firebird 3.0 Super This is not real code from my…
Leonardo Cosmai
  • 11
  • 2
1
vote
1 answer

How to handle precision problems of floating point numbers?

I am using Firebird 3.0.4 (both in Windows and Linux) and I have the following procedure that clearly demonstrates my problem with floating point numbers, and that also demonstrates a possible workaround: create or alter procedure test_float returns…
TomR
  • 2,696
  • 6
  • 34
  • 87
1
vote
3 answers

JOINing a "LIST" table with a "SPAN" table

In Firebird, I have a table that is a "list". It contains records like this: LstRecID 1 2 3 4 5 6 7 8 9 10 ... I have another table that contains various "spans". It contains records like this: SpnRecID | BeginSpan | EndSpan …
user3319732
  • 19
  • 5
1
vote
2 answers

FirebirdSql Error occurred during login, please check server firebird.log for details

I am trying to connect and read data from Firebird database using the FirebirdSQL .net provider (using FirebirdSql.Data.FirebirdClient). Here is the code: FbConnection viewdataConnection=new FbConnection(); viewdataConnection.ConnectionString =…
Vikas Kottari
  • 495
  • 2
  • 10
  • 24
1
vote
1 answer

EF Core - Firebird Migration auto-increment problem

I'm testing the migration with EF Core with MSSQL-Server and Firebird 3.0. I create a new table with a few fields. The key-field has the property .ValueGeneratedOnAdd(), but the key-field in the Firebird database doesn't get an auto-increment…
Henning
  • 421
  • 2
  • 11
  • 22
1
vote
1 answer

How to manually perform a Firebird client-only install?

I'm trying to install Firebird client 3.0.4.33054 on a Windows client without using the installer. Version on the server is the following: C:\Program Files\Firebird\Firebird_3_0>gfix -z gfix version WI-V3.0.4.33054 Firebird 3.0 I found this…
Fabrizio
  • 7,603
  • 6
  • 44
  • 104
1
vote
1 answer

How to disable "heading" for all firebird subrequests

I have a request for firebird with concatenation and using nested select and list (), and then written this to the file. The first command is SET HEADING OFF; SET HEADING OFF; SELECT DISTINCT '"' || REPLACE(TRIM(COALESCE(x.column, '')), '"',…
Alex Pen
  • 13
  • 5
1
vote
2 answers

Display a calendar list select procedure using left join and display more than one data in a single date

I am working on a small hostel reservation project. I tried creating a calendar list on a grid that displays all the dates on a month and beside the dates are the transaction details of the hostel (booking details or reservation details). Here is my…
Don Juan
  • 155
  • 1
  • 10
1
vote
1 answer

How to replace only whole words using Firebird?

I need to write an SQL text for replacing only entire words. For "whole word" I mean all occurrences which are not part of another alphanumeric word. Example: Replacing 'abc' with 'xyz' | MYFIELD | | 'test abc test' | | 'abctest' | | 'testabctest'…
Fabrizio
  • 7,603
  • 6
  • 44
  • 104
1
vote
2 answers

How to add query inside a function

I'm trying to make a class that contain the whole query (CRUD) for other units/forms to call and use it. But then I'm facing some errors. I'm using Firebird as database. I have no idea how to add query to execute inside a function. I get error when…
Kai
  • 155
  • 3
  • 9
1
vote
1 answer

How to create Firebird database user and grant some privileges to that user

I am creating a firebird database dynamically using SYSDBA. I want to create a user with some privileges and then open this database using the new user. Can anyone help, please? var csb = new…
Muhammad Waqas
  • 85
  • 4
  • 15
1
vote
2 answers

UDF Firebird function STRTOINT is not defined in query even if its listed in RDB$FUNCTIONS

I'm trying to run a SQL query in my Firebird database. I've restored a backup in my local development environment. My error is the following: echo "SELECT STRTOINT('3') FROM MyTable;" | isql-fb /var/lib/firebird/3.0/data/dbname.fdb Statement failed,…
Nepomuk Pajonk
  • 2,972
  • 1
  • 19
  • 29
1 2 3
…
14 15