Subject [firebird-support] isql issue with FB 2.1 on Mac OS X 10.4.11 PPC
Author Paul Beach
Any ideas?

Yes, it looks like the ppc build for MacOSX has been broken somehow.
I need to check and find out why.

Paul


I am having some issues after having installed the SuperServer-Package
of Firebird 2.1 for Mac OS PPC.
I get no results when issuing any query in isql. Issuing the query
again results in the error message
-SQL error code = -519
-The prepare statement identifies a prepare statement with an open cursor

Here's what to do to reproduce the error, at least on my system:

Marvin:~ thomas$ isql -u sysdba -p masterkey
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'test.fdb';
SQL> connect 'test.fdb';
Commit current transaction (y/n)?y
Committing.
Database: 'test.fdb', User: sysdba
SQL> select * from rdb$database;
SQL> select * from rdb$database;
Statement failed, SQLCODE = -519
Dynamic SQL Error
-SQL error code = -519
-The prepare statement identifies a prepare statement with an open cursor
SQL>

Connecting from PHP 5.2.6RC6 (freshly compiled against FB2.1) works flawlessly.
I then tried CS just to be sure. The above error does not occur, but
isql keeps segfaulting on exit.




Paul Beach
Tel (France): +33 (0) 2 47 58 30 43
Mob (France): +33 (0) 6 79 24 32 32