Skip to Content.
Sympa Menu

freetds - Re: [freetds] DBD::Sybase 1.01 & FTDS 0.62-dev & temp tables

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] DBD::Sybase 1.01 & FTDS 0.62-dev & temp tables
  • Date: Mon, 01 Dec 2003 20:06:23 -0000

Il lun, 2003-12-01 alle 20:42, Jerry Grooms ha scritto:
> Hello,
>
> I recently upgraded a platform from:
>
> HPUX 11.11
> perl 5.8
> DBD-Sybase-0.95
> freetds-0.53
>
> to:
>
> HPUX 11.11
> perl 5.8
> DBD-Sybase-1.01
> freetds-0.62-dev
>
>
> I had to upgrade from FTDS 0.61 to 0.62-dev due to the "queries that
> return 0 rows" bug; (kudos to the DBD::Sybase release notes)
>
> The above was corrected and things are mostly working except for
> previously working (unchanged) queries that utilize temporary
> tables. eg select blah,blah INTO #some_totals ...
>
> An example of what I'm seeing is:
>
> DBD::Sybase::st execute failed: Server message number=208
> severity=16 state=0 line=3 server=blah-blah text=Invalid object name
> '#proj_totals'. at ./topten_lastmonth.pl line 131.
>
> I've sifted through the release notes and archives and haven't found
> anything, yet.
>
> Are there any known issues with temp tables or should they work
> as before? I'll continue to debug.
>
> Thanks,
>
> Jerry

Try enabling TDSDUMP... note that iconv stuff is not yet finished.
Current source is quite stable but require GNU iconv or no iconv...
I don't know state of HP/UX 11 iconv but this can be the problem...
We use a lot of temporary table in our tests and I don't have all these
issues. Note however that server (I don't know type and version...)
retry "Invalid object name '#proj_totals'" so it seem query arrived
correctly but table do not exists. Looking at previous email ("dropped
connection, I think") seem that DBD::Sybase try to open a concurrent
connection automatically... this can be another problem... You can't see
temporary table from another connection!!

freddy77






Archive powered by MHonArc 2.6.24.

Top of Page