On 4-8-2013 14:39, Mark Rotteveel wrote:
> Has anything changed in Firebird 3.0 with the stability of RDB$DB_KEY or
> how RDB$DB_KEY works?
>
> Jaybird uses RDB$DB_KEY to refresh (and update) rows in updatable
> ResultSets, one of the tests now fails because it cannot find the row it
> wants to refresh (it looks like the update fails as well, but the
> current test refreshes the row before testing that).
>
> 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).
Should I create a bug for this?
Mark
--
Mark Rotteveel
------------------------------------------------------------------------------
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
