10.08.2013 12:20, Mark Rotteveel wrote:
>
>> Has anything changed in Firebird 3.0 with the stability of RDB$DB_KEY or
>> how RDB$DB_KEY works?
Nothing, AFAIR (for the regular tables).
>> It executes:
>> "SELECT RDB$DB_KEY,"ID","LONG_STR","STR","CamelStr"
>> FROM TEST_TABLE2 WHERE
>> RDB$DB_KEY = ?"
>>
>> Where the parameter is set to:
>> sqltype = 453
>> sqlscale = 0
>> sqlsubtype = 1
>> sqllen = 8
>> sqldata = { 0x81, 0, 0, 0, 0x1, 0, 0, 0 } (the same value as the dbkey
>> in the original query)
>>
>> The executed query returns no rows, while it works under Firebird 2.5
>> (and earlier).
Is a row returned using a constant (non-parameter) DBKEY value? For
example, the following works for me:
select * from rdb$database where rdb$db_key =
ascii_char(1)||ascii_char(0)||ascii_char(0)||ascii_char(0)||ascii_char(1)||ascii_char(0)||ascii_char(0)||ascii_char(0);
Dmitry
------------------------------------------------------------------------------
Get 100% visibility into Java/.NET code with AppDynamics Lite!
It's a free troubleshooting tool designed for production.
Get down to code-level detail for bottlenecks, with <2% overhead.
Download for free and get started troubleshooting in minutes.
http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
