[pkg-firebird-general] Bug#494286: firebird2.0-super: isql-fb doesn't accept sql commands exceeding 64 bytes in length on stdin

[Marcin Machnio]

Package: firebird2.0-super
Version: 2.0.4.13130-1.ds1-4
Severity: normal



-- System Information:
Debian Release: lenny/sid
  APT prefers unstable
  APT policy: (500, 'unstable'), (500, 'testing')
Architecture: i386 (i686)

Kernel: Linux 2.6.17mm071102 (SMP w/1 CPU core)
Locale: LANG=pl_PL, LC_CTYPE=pl_PL (charmap=ISO-8859-2)
Shell: /bin/sh linked to /bin/bash

Versions of packages firebird2.0-super depends on:
ii  debconf [debconf-2.0 1.5.22              Debian configuration management sy
ii  firebird2.0-common   2.0.4.13130-1.ds1-4 common files for firebird 2.0 serv
ii  firebird2.0-server-c 2.0.4.13130-1.ds1-4 common files for firebird 2.0 serv
ii  libc6                2.7-10              GNU C Library: Shared libraries
ii  libeditline0         1.12-5              line editing library similar to re
ii  libfbclient2         2.0.4.13130-1.ds1-4 Firebird client library
ii  libgcc1              1:4.3.1-2           GCC support library
ii  libicu38             3.8.1-3             International Components for Unico
ii  libstdc++6           4.3.1-2             The GNU Standard C++ Library v3
ii  lsb-base             3.2-12              Linux Standard Base 3.2 init scrip

firebird2.0-super recommends no packages.

Versions of packages firebird2.0-super suggests:
pn  firebird2.0-doc               <none>     (no description available)

-- debconf information:
  shared/firebird/title:
* shared/firebird/enabled: true
  shared/firebird/purge_security: false
  shared/firebird/server_in_use:
  shared/firebird/purge_databases: false

-- Comment

Hello,

I also tried older versions of firebird on Debian (firebird1.5-super
and firebird2-super-server). It seems that this issue is a problem in
every version I used. I downloaded RPM package
FirebirdSS-2.0.4.13130-1.i686.rpm from www.firebirdsql.org and isql
from that archive doesn't cause that kind of problems.

Examples of reproducing an error: 
---------------------------------------------------------------------
Native Debian isql-fb and command shorter than 65 bytes:

echo 'select current_timestamp,current_timestamp from
 rdb$procedures;'|isql-fb -u sysdba -p kleszczunio /tmp/a.gdb

        CURRENT_TIMESTAMP         CURRENT_TIMESTAMP 
	========================= ========================= 
	2008-08-08 10:46:21.2660  2008-08-08 10:46:21.2660

---------------------------------------------------------------------
The same example with longer command causes error:

echo 'select current_timestamp,current_timestamp,current_timestamp from
 rdb$procedures;'|isql-fb -u sysdba -p kleszczunio /tmp/a.gdb 
Statement failed, SQLCODE = -104
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, column 1
-m

mmachnio at pillow:~$ echo 'select
current_timestamp,current_timestamp,current_timestamp from
rdb$procedures;'|colrm 1 64
m rdb$procedures;

It looks as if it removed first 64 characters from a command.

---------------------------------------------------------------------
The same example as previous but using isql from
FirebirdSS-2.0.4.13130-1.i686.rpm is successful

echo 'select current_timestamp,current_timestamp,current_timestamp from
rdb$procedures;'|/tmp/opt/firebird/bin/isql -u sysdba -p kleszczunio
/tmp/a.gdb 

        CURRENT_TIMESTAMP         CURRENT_TIMESTAMP
	CURRENT_TIMESTAMP 
	========================= =========================
	========================= 
	2008-08-08 10:50:43.6580  2008-08-08 10:50:43.6580  2008-08-08
	10:50:43.6580

Regards,
Marcin