FreeTDS Development Group

[Frediano Ziglio <freddyz77 AT tin.it>]

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