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 the latest release of the Firebird database server.

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

174 questions
2
votes
1 answer

Overlapping date ranges for all workers

I'm trying to figure out how to calculate date ranges (islands) where all workers worked all together. In other words, if one of the workers is not at some date, then this date should be excluded from the result. Below sample data: insert into…
Livius
  • 866
  • 1
  • 5
  • 18
2
votes
1 answer

Returning a table in firebird 3.0 with stored function or stored procedure

I'm trying to write a stored procedure/function that returns me a table with one or multiple rows of data. The returned data depends on a variable shown in the following sql statement: SELECT * FROM table_name AS SD WHERE EXISTS (SELECT DISTINCT…
Zazimba
  • 23
  • 3
2
votes
1 answer

Firebird Missing user management plugin

When I try to open User Manager or just simple do a select * from sec$users, I get an error Missing user management plugin. I have already seen in some posts how to set usermanager from firebird.conf adding Srp, Srp256, Legacy_UserManager and…
Fernando Donizeti Ito
  • 33
  • 7
2
votes
1 answer

Firebird user has all access rights on a single database except cannot create new db and no access to other database

I have a server that will manage multiple Firebird databases. My users are allowed to have full access on all the objects for a single database but they are not allowed to create new database and no access to other databases in the same server. How…
Sherlyn Chew
  • 139
  • 1
  • 2
  • 8
2
votes
1 answer

Create user fails in Firebird 3 with isql-fb

I am trying to create a user in a firebird 3 database (on Fedora 27). When I connect to my database with isql-fb with the role RDB$ADMIN, I cannot create new users. [user@host]$ isql-fb -z ISQL Version: LI-V3.0.3.32900 Firebird 3.0 Use CONNECT or…
mor22
  • 1,302
  • 1
  • 14
  • 28
2
votes
1 answer

Firebird 3 SQL windows function over()

I need help.. I have table orders like this id,order_date,price,customer_id 1 01.01.2001 100 1 2 01.02.2001 0 1 3 20.02.2001 0 1 4 04.04.2001 200 1 I need select result like this id,order_date,price,customer_id,somefield 1 01.01.2001 100 1 …
Tester2019
  • 21
  • 1
2
votes
4 answers

Recursive Relationship on Dictionary Table

I'm working on a poor, but ok for us, full-text search using only PSQL in Firebird. I'll try to simplify as much as possible by focusing on my problem: Summing up, this a dictionary table: SELECT * FROM FTS_KEYWORDS ID | KEYWORD ----+----------- …
dipold
  • 787
  • 7
  • 18
2
votes
1 answer

Parameter in SELECT statement's fields list - error: Data type unknown

I have a problem with Firebird (embedded) database. I would like to set a parameter values in the select statement. For example: SELECT name, surname, :string AS myText FROM myTable where :string is a parameter. The above code works in SQLite and…
Mirosław Rychter
  • 33
  • 2
2
votes
1 answer

Jaybird JDBC 3.0 - Connection Timing Out

I'm connecting to a Firebird 3.0 database using the Jaybird JDBC 3.0.3 driver. I'm connecting from within the ColdFusion Administrator -> Data Sources area. In the past, using JDBC 2.0 driver I created my data source as follows. JDBC URL:…
Phil
  • 3,779
  • 3
  • 51
  • 94
2
votes
1 answer

Display all Dates in a given month and year in firebird select procedure

I am making a program for Time and Attendance. I have a table with this fields ATTEND_PK INTEGER NOT NULL, EMP VARCHAR, ATTEND_DATETIME TIMESTAMP, USER_PK SMALLINT, ATTEND_UPDATETIME TIMESTAMP); here is the sample data | ATTEND_PK | …
Don Juan
  • 145
  • 1
  • 10
2
votes
1 answer

Using UUID PK or FK in Firebird with Jooq

I have a table in Firebird with a PK column CREATE TABLE TEST ( ID CHAR(16) CHARACTER SET OCTETS NOT NULL, CONSTRAINT PK_TEST PRIMARY KEY (ID) ); OCTETS encoding are treated as bytes. I create a converter public class UUIDConverter implements…
Gerardo Suárez Trejo
  • 21
  • 2
2
votes
1 answer

Alter a Column from INTEGER To BIGINT

In my database I have several fields with INTEGER Type. I need to change some of them to BIGINT. So my question is, can I just use the following command? ALTER TABLE MyTable ALTER COLUMN MyIntegerColumn TYPE BIGINT; Are the contained data be…
Andreas
  • 306
  • 3
  • 14
2
votes
2 answers

SELECT WHERE column1 = 1 AND column2 = MAX(column2)

I have table like this |Column 1 |Column 2|Column 3| | 1| 1| 1| | 2| 1| 2| | 3| 1| 3| | 4| 2| 1| | 5| 1| 4| | 6| 2| 2| | 7| …
Parpil
  • 119
  • 2
  • 9
1
vote
1 answer

Insert values into tables with a foreign key

I want to insert some values in two tables in a loop, but it seems like I can't do it because of the foreign key. However, the same code does work in SQL Server. This works perfectly in SQL Server: declare @i int = 1 while @i<1200 BEGIN INSERT…
Andrzej Szafarczyk
  • 31
  • 4
1
vote
1 answer

ADO.NET FirebirdSql.Data.FirebirdClient.FbException: "Unable to complete network request to host "

I have a pretty strange problem when trying to connect my C# program to an existing Firebird server. First of all, this is reproducable with the default connection example from the Firebird documentation at…
autlunatic
  • 350
  • 3
  • 12
1 2
3
…
11 12