[Firebird-devel] Firebird 2.0b1 not playing well with ODBC 1.2 or 2.0

[Richard W. <haw...@ta...>]

I have been trying to cope with a set of problems that showed up when  
I switched over to the 2.0b1.  One of them is reproducible from the  
isql.exe command line tool, and I hope this will be enough data to  
reproduce the problem.

UDFs:

fbudf.dll and ib_udf.dll from the distribution and FreeAdhocUDF.dll.   
Incidentally, the 2.0b1 ib_udf.sql has two errors when you load it.   
The problem also shows up with the old FreeAdhocUDF.dll, and both  
versions work with 1.5.2.

Schema:

create table "Calcs" (
  "key" varchar(255),
  "str2" varchar(255)
  "int0" integer);

Data:

+-------+----------+------+
| key   | str2     | int0 |
+-------+----------+------+
| key00 | one      |    1 |
| key01 | two      | NULL |
| key02 | three    | NULL |
| key03 | NULL     | NULL |
| key04 | five     |    7 |
| key05 | six      |    3 |
| key06 | NULL     |    8 |
| key07 | eight    | NULL |
| key08 | nine     | NULL |
| key09 | ten      |    8 |
| key10 | eleven   |    4 |
| key11 | twelve   |   10 |
| key12 | NULL     | NULL |
| key13 | fourteen |    4 |
| key14 | fifteen  |   11 |
| key15 | sixteen  |    4 |
| key16 | NULL     |    8 |
+-------+----------+------+

Query:

SELECT (("Calcs"."int0")) AS "int0 (dim)",
   "Calcs"."key" AS "key",
   "Calcs"."str2" AS "str2",
   ((CASE WHEN ("Calcs"."int0") >= 0 THEN SRIGHT 
("Calcs"."str2",F_TRUNCATE(("Calcs"."int0"))) ELSE NULL END)) AS  
"z_right_str_num3"
FROM "Calcs"

generates an error:

Statement failed, SQLCODE = -902
Error reading data from  the connection.

The same query works correctly with the 1.5.2 server.  Subsequent  
queries in isql report that the connection to the server has been  
dropped.  Reestablishing it by repeating the connect request results in:

Commit current transaction (y/n)?

Responding n (rolling back) results in the connection dropped message  
being repeated and a new connection being established.

Any ideas?

TIA,