firebird
firebird copied to clipboard
FirebirdSQL
Firebird server, client and tools
Consider following script: ``` set list on; set count on; set blob all; set bail OFF; shell if exist r:\temp\tmp4test.fdb del r:\temp\tmp4test.fdb; create database 'localhost:r:\temp\tmp4test.fdb' user 'sysdba' password 'masterkey'; create...
Hello, Used to know powers of twos up to guite big numbers by heart. Don't remember anymore, so would help if there would be same shorthand as in the conf-files....
According to [IEEE_754](https://en.wikipedia.org/wiki/IEEE_754) and its [explanation](https://en.wikipedia.org/wiki/Double-precision_floating-point_format), double precision must support storage of ~2.225073858507**2009**e-308 ("largest subnormal number") which is repsesented as: ```[bin] 0 00000000000 1111111111111111111111111111111111111111111111111111 ``` But this is not so...
Consider script: ``` set bail on; set list on; shell del r:\temp\tmp4test.fdb 2>nul; create database 'localhost:r:\temp\tmp4test.fdb' user 'sysdba' password 'masterkey'; create table t1(x char(2)); create table t2(x char(2)); insert into...
Changed values of per-connection parameters (which are set in DPB) are not reflected in result of query to RDB$CONFIG - at least if INET/XNET protocols are used. This can be...
We have huge databases (hundreds of gigabytes) and very complex client-server medical applications with hundreds of database connections. Applications allow users to work using multiple tabs in many active transactions...
The query below causes the server to crash WI-V3.0.13.33818 Firebird 3.0 And to the error appearance Unsuccessful execution caused by system error that does not preclude successful execution of subsequent...
When using gfix -shut -force 300 mydb.fdb -user SYSDBA -pass masterkey, I would like the server to send a message about the upcoming database shutdown, so that the application can...
Consoder following script: ``` set bail ON; shell if exist r:\temp\tmp4test.fdb del r:\temp\tmp4test.fdb; create database 'localhost:r:\temp\tmp4test.fdb' user 'sysdba' password 'masterkey'; create exception exc_test '... foo ...'; set term ^; create...