On 10-8-2013 15:15, Dmitry Yemanov wrote:
>>> 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);
I believe it did work when I tried with it with a literal (using
X'....'), but I am not sure. I will try again later today or tomorrow.
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
