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

[Damyan Ivanov]

tags 494286 confirmed
thanks

-=| Marcin Machnio, Fri, Aug 08, 2008 at 10:57:08AM +0200 |=-
> 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: 
> ---------------------------------------------------------------------
> 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

I can reproduce this.

My suspicion is that it is caused by linkage with the wrong editline 
library. Pristine upstream source includes a copy of one such library 
in extern/editline. This is removed from the debian source package and 
libeditline-dev is used at build time.

However, it seems that the "editline" bundled upstream is actually a 
derivate of the NetBSD's libedit2, which is also packaged in Debian.

I'll build packages using libedit-dev and see if it makes any 
difference.

Meanwhile, you can pass "-i /dev/stdin" option to isql-fb as a 
workaround.

-- 
dam            JabberID: dam at jabber.minus273.org
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: Digital signature
Url : http://lists.alioth.debian.org/pipermail/pkg-firebird-general/attachments/20080808/15650a6c/attachment.pgp