Re: [Firebird-devel] isc_dsql_prepare, NULL tr_handle, SET TRANSACTION

Fixed. Thanks. Please, append in source code the comment for this fix. Because in each new version (begin from 2.0) this feature is broken :) Regards, Dmitry Kovalenko. -- Create and publish websites with WebMatrix

[Firebird-devel] RDB$SET_CONTEXT, mistake in system table for return value

the ticket in bug-tracker? Kovalenko Dmitry. PS. Ofcourse, this is wrong behavior of IBExpert also :)-- Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network

[Firebird-devel] ODS12. RDB$FUNCTION_ARGUMENTS. Description field.

Hi The system table RDB$FUNCTION_ARGUMENTS (in ODS12) still exists without RDB$DESCRIPTION field. RDB$PROCEDURE_PARAMETERS contains this (and RDB$SYSTEM_FLAG also) field. Kovalenko Dmitry-- Benefiting from Server

Re: [Firebird-devel] Y-valve and DPBs

Look to OLE DB properties. Each property has the unique ID: GUID.Number. Regards, Dmitry Kovalenko -Original Message- From: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com] Sent: Saturday, March 21, 2015 4:19 AM To: firebird-devel Subject: [Firebird-devel] Y-valve and DPBs

Re: [Firebird-devel] Y-valve and DPBs

Connection parameters should be in text form. Values (in common case) should contain the information about type (UI2, UI4 , String) OLEDB, for example, uses VARIANT structure. Regards, Dmitry Kovalenko. -- Dive

Re: [Firebird-devel] Longer metadata names and related things

>> I'd prefer to introduce XSQLDA version 2. >Then it should also include schema name (reserved now), to avoid yet another version switch in the future. And package name ... Dmitry Kovalenko www.ibprovider.com --

Re: [Firebird-devel] Firebird support for "newer" compilers & SDKs / especially on Windows & MacOS X

>One of our developers discovered that Firebird 2.5 fails to compile MSVC2013, made some steps in the direction of fixing it (like we did internally for GCC 6), and was told that for Firebird 2.5, it was more work than he envisioned: http://tracker.firebirdsql.org/browse/CORE-5120 You can look to

Re: [Firebird-devel] RFC: Timeouts

>But, client side already can set it own timer and cancel the statement. At current time, you may forget about cancel of operation. Because it works incorrectly. Dmitry Kovalenko. -- Check out the vibrant tech

[Firebird-devel] [FB3] Can't prepare "select (x.*) from MYTABLE x"

Hi Firebird 2.5.x can prepare SQL like "select (x.*) from MYTABLE x" Firebird 3.0.2.32619 returns the error: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, column 11 * It is regression or FB2.5 works incorrectly? Regards, Dmitry Kovalenko

Re: [Firebird-devel] [FirebirdSQL/firebird] 5aede1: Decimal floating point numbers - first draft

No -Original Message- From: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com] Sent: Friday, November 18, 2016 7:59 PM To: For discussion among Firebird Developers Subject: Re: [Firebird-devel] [FirebirdSQL/firebird] 5aede1: Decimal floating

Re: [Firebird-devel] Wire protocol changes in Firebird 4?

>4) Knowledge of total length of packet is required only for current parser which need full packet to be in single buffer. If rewrite parser to use stateful automate, total length is needless. No. It need for resolve a problem with cancelation of operations.

[Firebird-devel] [B3_0_Release] Can't compile in VS2015.

1>-- Build started: Project: engine12, Configuration: Debug Win32 -- 1>DdlNodes.obj : warning LNK4075: ignoring '/EDITANDCONTINUE' due to '/SAFESEH' specification 1> Creating library ..\..\..\temp\Win32\Debug\engine12\engine12.lib and object

Re: [Firebird-devel] Wire protocol changes in Firebird 4?

>From my point of view, protocol must be rewrited At minimum: 1. The each packet should contain the field with own size. 2. It is necessary to solve the problems with LazySend mode. Dmity Kovalenko www.ibprovider.com -Original Message- From: Mark Rotteveel [mailto:m...@lawinegevaar.nl]

[Firebird-devel] FB3 ICU (v52)

Adriano, could you upload to https://github.com/FirebirdSQL the source code of ICU from FB3? Thanks, Dmitry Kovalenko www.ibprovider.com -- Check out the vibrant tech community on one of the world's most engaging

Re: [Firebird-devel] Unload of fbclient.dll (v3)

>> Could anybody confirm this behavior of FB3 client library? >Please add big delay (120 sec should be enough) after last attachment closed before unloading client library. Does it unload in such case? { ::Sleep(120*1000); _VERIFY(::FreeLibrary(m_hDLL)); } Not help. Fbclient

[Firebird-devel] Unload of fbclient.dll (v3)

Hello, fbclient.dll (from FB3) not unload when I call ::FreeLibrary. fbclient.dll (from FB2.5) unloads without problems. Could anybody confirm this behavior of FB3 client library? Thanks, Dmitry Kovalenko www.ibprovider.com

[Firebird-devel] NULL and/or true/false

Hello, Firebird 3.0.4 Could anybody (Adriano?) confirm, that next result is corrected: select null or trueas c4__null_or_true, /* TRUE */ null or false as c5__null_or_false, /* NULL */ null and true as c6__null_and_true, /* NULL */ null and false as

Re: [Firebird-devel] NULL and/or true/false

Hello Mark and Denis, >> Just – yes or no :) >Yes, and verified against SQL:2016. > Thank :) Dmitry Kovalenko Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] CURRENT_DATE in 1 dialect

Hello FB3, database with 1 dialect. I try to execute: select CAST(CURRENT_DATE AS TIMESTAMP) from RDB$DATABASE and see an error: Dynamic SQL Error. SQL error code = -104. Client SQL dialect 1 does not support reference to DATE datatype. For my point of view - server

Re: [Firebird-devel] isc_database_info and current database user

> Can you explain - what a problem with use of SQL to get that data? Need start (and commit) implicit transaction. For me - it is not good behavior of provider. Dmitry Kovalenko. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] isc_database_info and current database user

Hello, Could anybody tell me - how I can get name of current user through isc_database_info API function? I see isc_info_user_names. But I want to get the only one name. Thanks, Dmitry Kovalenko. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] isc_database_info and current database user

> select current_user from rdb$database Usage of similar queries is not good idea for connection provider. It is problem to added new info-tags (current_user and, may be, current_role) for isc_database_info in FB3.0.5? >From my side I will added the special support for these new tags into my

Re: [Firebird-devel] Introducing Firebird Butler

>We are pleased to announce a significant extension of the Firebird project to a whole new area Copy -> Paste into Google Translate -> Hmm -> Return to Work. Regards, Dmitry Kovalenko www.ibprovider.com https://www.nuget.org/packages/lcpi.data.oledb/ Firebird-Devel mailing list, web

[Firebird-devel] FB3 and op_accept answer

Hello. Which conditions required for obtain the op_accept packet during connection? I tried different settings, but see only op_accept_data or op_cond_accept packets. Thanks, Dmitry Kovalenko www.ibprovider.com Firebird-Devel mailing list, web

Re: [Firebird-devel] FB3 and op_accept answer

d-devel@lists.sourceforge.net Subject: Re: [Firebird-devel] FB3 and op_accept answer On 11-5-2019 18:39, Kovalenko Dmitry wrote: > Hello. > > Which conditions required for obtain the op_accept packet during connection? > > I tried different settings, but see only op_accept_data or &g

Re: [Firebird-devel] FB3 and op_accept answer

ists.sourceforge.net Subject: Re: [Firebird-devel] FB3 and op_accept answer On 11-5-2019 18:39, Kovalenko Dmitry wrote: > Hello. > > Which conditions required for obtain the op_accept packet during connection? > > I tried different settings, but see only op_accept_data or > op_con

[Firebird-devel] [FB3] result type of negate operation

Hello, FB3.0.8.22506 (Dialect 3) Firebird defines a follow result types for Negate operation: -SMALLINT_COLUMN has result type SMALLINT -INTEGER_COLUMN has result type INTEGER As result, I see a work like this: SQL> create table TTT2 (COL_SMALLINT SMALLINT); SQL> insert into

Re: [Firebird-devel] [FB3] result type of negate operation

>>>   The question is whether result of negation should keep the type of >>> source or can it be expanded if needed. >>Then it would need to expand for all types. >And what would be an -INT128? Result type must be same as result of expression "0-source"? Note that in Dialect 1: 0-smallint ->

Re: [Firebird-devel] MacOS problem with dlclose

Hello Adriano, If I understood correctly in this topic described same problem: https://groups.google.com/g/firebird-support/c/oO9c_ppmfRg/m/-ukO9L37DQAJ ? --- The problem with correct shutdown of module with shutdown function (or component with "Dispose" method) is solved through counter of

[Firebird-devel] [FB-Tracker] Created: (CORE-3984) [Attempt to reopen an open cursor] in Execute-Fetch-Cancel-Close-Execute-Fetch-Error

Project: Firebird Core Issue Type: Bug Components: API / Client Library, Engine Affects Versions: 2.5.2 Environment: Win7, x64. Reporter: Kovalenko Dmitry Server Version :2.5.3.26543 [Windows, SuperClassic, 64bit] Client Version :2.5.3.26543 [Windows

[Firebird-devel] [FB-Tracker] Created: (CORE-4059) [FB3][AV] Crash when create an UDF with RETURNS PARAMETER pos_number

Type: Bug Components: Engine, UDF Affects Versions: 3.0 Initial Reporter: Kovalenko Dmitry FB 3.0.0.30247 SQL: DECLARE EXTERNAL FUNCTION UDF_DUMMY2_RPN_1 smallint, integer, float, double precision RETURNS PARAMETER 1 ENTRY_POINT 'IB_UDF_abs' MODULE_NAME 'ib_udf'; Stack

[Firebird-devel] [FB-Tracker] Created: (CORE-4067) Problem with CREATE DATABASE ... COLLATION ... and 1 dialect

Components: Engine, ISQL Affects Versions: 3.0 Initial Reporter: Kovalenko Dmitry Firebird 3.0.0.30278 c:\Program Files (x86)\Firebird_3_0isql.exe Use CONNECT or CREATE DATABASE to specify a database SQL SET SQL DIALECT 1; SQL CREATE DATABASE 'vxp-fb30:e:\database\test2.gdb' USER

[Firebird-devel] [FB-Tracker] Created: (CORE-4239) AV. Problem in MET_procedure

Environment: Vista x64. Q6600, 8GB. IBProvider Test System. Reporter: Kovalenko Dmitry I executed my old tests (in four threads) and get the (think, reproducible) AV in Firebird's engine: Необработанное исключение в 0x000140256da2 в fb_inet_server.exe: 0xC005: Нарушение прав доступа

[Firebird-devel] [FB-Tracker] Created: (CORE-4699) Incorrect processing of DSQL_drop?

: 2.5.4 Reporter: Kovalenko Dmitry Priority: Minor As I understand, DSQL_drop constant presents the FLAG of operation, not ID of operation. However, in some cases, instead of checking the flag DSQL_drop, used a direct comparison with DSQL_drop [GDS_DSQL_FREE] [why.cpp

[Firebird-devel] [FB-Tracker] Created: (CORE-4700) Mistake in GDS_DROP_DATABASE?

Reporter: Kovalenko Dmitry jrd.cpp, GDS_DROP_DATABASE for (; shadow; shadow = shadow-sdw_next) { err = err || drop_files(shadow-sdw_file); // mistake? } I think, this code should be written like this: for (; shadow; shadow = shadow-sdw_next) { if ( drop_files(shadow-sdw_file) ) err=true

[Firebird-devel] [FB-Tracker] Created: (CORE-4785) Bad packet of op_execute kills the server

: 2.5.4 Reporter: Kovalenko Dmitry 0. Connection through TCP/IP (INET) 1. Query: insert into NUM (N_1_0) values (?) 2. input XSQLDA contains one LONG-variable (isc_sql_long). Build code: XSQLDA_V1_Wrapper xsqlda(1); xsqlda-sqld=1; unsigned __int32 xparam0_value=5; short

[Firebird-devel] [FB-Tracker] Created: (CORE-4983) [AV] Server crashes during execution of unprepared statement

Components: Engine Affects Versions: 2.5.4 Reporter: Kovalenko Dmitry [Stack] > fb_inet_server.exe!EXE_unwind(Jrd::thread_db * tdbb, Jrd::jrd_req * > request) Line 1080 C++ fb_inet_server.exe!JRD_start(Jrd::thread_db * tdbb, Jrd::jrd_req * request, Jrd::j

[Firebird-devel] [FB-Tracker] Created: (CORE-4988) [lazy_send mode] problem with alloc_stmt+prepare_stmt operation

Components: API / Client Library Affects Versions: 2.5.4, 2.5.5 Reporter: Kovalenko Dmitry In lazy_send mode, when the statement prepares the first own SQL, fbclient.dll sends two packet: op_allocate_statement and op_prepare_statement If first operation

[Firebird-devel] [FB-Tracker] Created: (CORE-5074) Lost the charset ID in selection of array element

/ Client Library, Engine Affects Versions: 2.5.5 Reporter: Kovalenko Dmitry 1. CREATE TABLE TEST_TBL ( ARRAY_COLUMN CHAR(10)[0:100] CHARACTER SET OCTETS ) 2. Prepare SQL: "select ARRAY_COLUMN[0] from TEST_TBL" 3. PROBLEM: XSQLVAR::sqlsubtype contains 0 (ZERO). Expected va

[Firebird-devel] [FB-Tracker] Created: (CORE-5139) mistake in comment "can't ise MutexLockGuard here"

s: 3.0 RC2, 2.5.5 Reporter: Kovalenko Dmitry Priority: Trivial server.cpp, line 5816 "can't use MutexLockGuard here" -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tra

[Firebird-devel] [FB-Tracker] Created: (CORE-5195) Improve a Firebird compilation scripts (bat files)

: Build Issues / Porting Affects Versions: 3.0.0 Reporter: Kovalenko Dmitry I offer to correct the "build" process for simplified a cleanup and creation different sets of binaries. At first time - for Windows environment. 1. Names of intermediate (temp, generat

[Firebird-devel] [FB-Tracker] Created: (CORE-5350) Assert in CachedMasterInterface::set

: Windows 7 x64 Reporter: Kovalenko Dmitry 1. Start server [debug build, x64] 2. Connect to database 3. Disconnect from database 4. Wait some time (1-2 minutes) 5. Connect to database again void CachedMasterInterface::set(IMaster* master) { fb_assert(master

[Firebird-devel] [FB-Tracker] Created: (CORE-5396) Assert at MET_current

Pro x64, IBProvider Test System, Outside snow. Reporter: Kovalenko Dmitry Firebird 3.0.2.32629. Original source code, custom DEBUG build VS2015 SP3, SuperServer, x64. IBProvider tests. 4 test threads. Problem in test thread #3 [table name: TEST_TABLE_6327] Crash stack

[Firebird-devel] [FB-Tracker] Created: (CORE-5382) Incorrect processing (truncation) of SQL statement with length 10MB+1

Type: Bug Components: Engine Affects Versions: 3.0.2 Environment: Firebird 3.0.2.32619, IBProvider, direct INET-connection to FB3 (without fbclient.dll). Reporter: Kovalenko Dmitry SQL Statement (total length = 10*1024*1024+1): "s

[Firebird-devel] [FB-Tracker] Created: (CORE-5415) [security3.fdb] wrong page type page 22 is of wrong type (expected pointer, found index root)

Project: Firebird Core Issue Type: Bug Affects Versions: 3.0.2 Environment: FB SS x64 3.0.2.32641, Win10, IBProvider Test System Reporter: Kovalenko Dmitry FB SuperServer x64 3.0.2.32641 Under load tests I get the some unexpected problem with connection

[Firebird-devel] [FB-Tracker] Created: (CORE-5416) [FB3] Memory Leaks. FB does not release memory after load tests.

Affects Versions: 3.0.2 Environment: FB 3.0.2.32641 SuperServer x64, Win10 x64 Pro, IBProvider Test System Reporter: Kovalenko Dmitry Attachments: fb_image.png, fb_performance.png Firebird does not release memory after completion of load tests. Size of each memory

[Firebird-devel] [FB-Tracker] Created: (CORE-5436) [FB3 SC] Server hangs (under load test)

: 3.0.2 Environment: Firebird 3.0.2.32651 SuperClassic x64, Win10, IBProvider Test System. Reporter: Kovalenko Dmitry SuperClassic hangs under load test. --- Two test processes (with 4 test theads) with own (two) databases. All test threads are waiting

[Firebird-devel] [FB-Tracker] Created: (CORE-5425) [FB3] Server hang

x64, Win10 Pro Rus, 6950X/128GB, IBProvider Test System. Reporter: Kovalenko Dmitry Attachments: FB_states.7z Firebird server hangs under load tests I launched 3 test processes with 4 test threads and own (3) databases. Connection through fbclient.dll and INET Firebird SRC

[Firebird-devel] [FB-Tracker] Created: (CORE-5632) SuperServer FB3 has entered in infinite loop (hang up)

: Engine Affects Versions: 3.0.3 Environment: Windows 10 Pro x64, 6950x/128GB, FB3 SuperServer x64, IBProvider Test System. Reporter: Kovalenko Dmitry - Firebird 3.0.3.32802 x64 (SuperServer) - Connection through TCP/IP (localhost) Server has entered in infinite loop

[Firebird-devel] [FB-Tracker] Created: (CORE-5693) EXTRACT(QUARTER FROM )

: Kovalenko Dmitry I'm surprised that Firebird (v3) still not support QUARTER in EXTRACT statement. It has a serious reason? -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure

[Firebird-devel] [FB-Tracker] Created: (CORE-5932) Usage of "BLOB SUB_TYPE TEXT" for "free" parameters

Components: Engine Affects Versions: 3.0.4 Reporter: Kovalenko Dmitry Test code: cmd.CommandText ="SELECT \"r\".\"TEST_ID\", \"r\".\"COL_VARCHAR_10\"\n" +"FROM \"TEST_MOD

[Firebird-devel] [FB-Tracker] Created: (CORE-5920) SUBSTRING does not support parameters for startPos and length

Affects Versions: 3.0.4 Reporter: Kovalenko Dmitry Server can't prepare SQL: SELECT * FROM "TEST_MODIFY_ROW" AS "r" WHERE SUBSTRING("r"."COL_VARCHAR_10" FROM :__vv1_0 FOR :__vv2_1) = _utf8 'G' Error message: "expression evaluation not s

[Firebird-devel] [FB-Tracker] Created: (CORE-5919) REPLACE and charset of third parameter

: Kovalenko Dmitry Connection charset: win1251 CREATE TABLE TEST_MODIFY_ROW ( TEST_IDT_TEST_ID NOT NULL /* T_TEST_ID = BIGINT */, COL_VARCHAR_10 T_VARCHAR_10 /* T_VARCHAR_10 = VARCHAR(10), CHARSET: WIN1251 */, ); For query1 SELECT "r"."TEST_ID", "

[Firebird-devel] [FB-Tracker] Created: (CORE-6063) FB3 (protocol 13) returns op_accept instead op_accept_data

Components: Engine Affects Versions: 4.0 Beta 1, 3.0.4, 3.0.3, 3.0.2, 3.0.1, 3.0.0, 4.0 Initial, 3.0.5, 4.0 Beta 2 Reporter: Kovalenko Dmitry This problem was detected by IBProvider builtin client to Firebird (not by fbclient.dll). Reproductions: 1. Server config: AuthServer

[Firebird-devel] [FB-Tracker] Created: (CORE-6246) [fbclient] Problem with too many number of columns in resultset.

Components: API / Client Library Affects Versions: 3.0.5 Reporter: Kovalenko Dmitry First query: select x1.RDB$FIELD_NAME from RDB$FIELDS as x1 fbclient.dll returns subtype=3 for first column Second query: select x1.RDB$FIELD_NAME, x1.RDB$FIELD_NAME, /*100500 raz

[Firebird-devel] [FB-Tracker] Created: (CORE-6224) [AV] Re-destruction of the rem_port object

Versions: 3.0.5 Environment: Test of IBProvider builtin client for Firebird. Reporter: Kovalenko Dmitry FB3.0.5.33225 x64 SuperServer. Connection through TCP/IP. --- Under mt-tesing of IBProvider builtin client for Firebird, Firebird crash on the destroy of rem_port object

[Firebird-devel] [FB-Tracker] Created: (CORE-6221) Incorrect (throw-based) alloFunc for zlib1. Possible memory leak.

Affects Versions: 3.0.5 Reporter: Kovalenko Dmitry https://www.zlib.net/manual.html Usage of z_stream_s structure: zalloc must return Z_NULL if there is not enough memory for the object. Firebird code, if I understood correctly, assign to zalloc throw-based allocation func

[Firebird-devel] [FB-Tracker] Created: (CORE-6217) [inet.cpp] Wrong work with pointer: delete ptr; ptr=new ;

Components: Engine Affects Versions: 3.0.5 Reporter: Kovalenko Dmitry inet.cpp, line 835-839 if (host.hasData()) { delete port->port_connection; port->port_connection = REMOTE_make_string(host.c_str()); } REMOTE_make_stri

[Firebird-devel] [FB-Tracker] Created: (CORE-6293) ISQL does not process (not extract) hex string of external SP body

Components: ISQL Affects Versions: 3.0.6 Reporter: Kovalenko Dmitry Priority: Minor Source code: CREATE PROCEDURE UDR__GEN_ROWS_05 (START_N INTEGER NOT NULL, END_N INTEGER

[Firebird-devel] [FB-Tracker] Created: (CORE-6406) Unexpected socket close [FB3 SS, TCP/IP]

: Windows, IBProvider test system, FB SS x64. Reporter: Kovalenko Dmitry Under multithreaded load test Firebird, time from time, closes INET-connection without any error/warning in own firebird.log Server continues to work after these problems. Work through own (builtin) IBProvider

[Firebird-devel] [FB-Tracker] Created: (CORE-6428) CAST( AS NOT NULL)

CAST( AS NOT NULL) -- Key: CORE-6428 URL: http://tracker.firebirdsql.org/browse/CORE-6428 Project: Firebird Core Issue Type: New Feature Reporter: Kovalenko Dmitry Hello, At current

[Firebird-devel] [FB-Tracker] Created: (CORE-6439) TIMESTAMP+-TIME

TIMESTAMP+-TIME --- Key: CORE-6439 URL: http://tracker.firebirdsql.org/browse/CORE-6439 Project: Firebird Core Issue Type: New Feature Components: Engine Affects Versions: 3.0.7 Reporter: Kovalenko

[Firebird-devel] [FB-Tracker] Created: (CORE-6481) Dialect 1. Not consistent result of two expressions with divide of NUMERIC with scale

: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0.8 Environment: Database with first dialect Reporter: Kovalenko Dmitry Priority: Minor Not consistent result of two expressions with divide: 1. cast(2 as NUMERIC(2, 1

[Firebird-devel] [FB-Tracker] Created: (CORE-6495) string_to_datetime and y2k problem

Reporter: Kovalenko Dmitry Priority: Minor string_to_datetime has following code for correction of y2k problem (two-digit year): tm times2; Firebird::TimeStamp::getCurrentTimeStamp().decode(); // Handle defaulting of year

[Firebird-devel] [FB-Tracker] Created: (CORE-6494) Inconsistent translation "string->timestamp->string->timestamp" and first dialect

Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0.8 Reporter: Kovalenko Dmitry Priority: Minor Connection with first dialect. SQL: select cast(cast(cast(cast('2-DEC-0083' as TIMESTAMP) as varchar(64))as TIME

[Firebird-devel] [FB-Tracker] Created: (CORE-6496) string_to_datetime and '\0' symbol

Reporter: Kovalenko Dmitry string_to_datetime returns error when translates string like: "2021-2-20\0" "2021-2-20 1:2\0" "2021-2-20 1:2:3\0" but not have problems with translation of strings like: "5.3.2021 01:02:03.1234\0" - Note that, Firebi