Re: Need help :-Problem using Sybase::BLK with ASE 15

I noticed this some time ago - I think I posted a patch, but maybe not. 
It has to do with the row-level locking of system tables in ASE 15.0.2, 
which changes the default order of returned rows.

Michael

Prasad, Neelakanta wrote:
> Thanks for the help Scott. I will try this.
> 
> Thanks,
>   Neelakanta Prasad. 
> 
> -----Original Message-----
> From: Zetlan, Scott [mailto:[email protected]] 
> Sent: Thursday, March 13, 2008 10:06 PM
> To: Prasad, Neelakanta
> Cc: [email protected]
> Subject: RE: Need help :-Problem using Sybase::BLK with ASE 15
> 
> It's been a while since I've looked at this code, but my recollection is
> that the query for _gettabinfo() isn't used anywhere else, and neither
> is _gettabinfo() called under any other circumstance.  So, I'd recommend
> going ahead with that change.
> 
> You should be able to test this out by making a modification to your
> local copy of BLK.pm and re-running whatever test bed you have available
> (make test will help).
> 
> Good catch!
> 
> Scott 
> 
> -----Original Message-----
> From: Prasad, Neelakanta [mailto:[email protected]] 
> Sent: Thursday, March 13, 2008 12:06 PM
> To: Zetlan, Scott
> Subject: FW: Need help :-Problem using Sybase::BLK with ASE 15
> 
> 
> 
>> ______________________________________________ 
>> From: 	Prasad, Neelakanta  
>> Sent:	Thursday, March 13, 2008 9:34 PM
>> To:	'[email protected]'; '[email protected]';
>> '[email protected]'
>> Cc:	'[email protected]'
>> Subject:	Need help :-Problem using Sybase::BLK with ASE 15
>>
>> Hi,
>>   We have some issue using Sybase::BLK module with ASE 15. In the 
>> method Sybase::BLK::_gettabinfo, the query used to get the column 
>> names returns the columns in the default order in ASE 12.5. But this 
>> is not happening in ASE 15. In ASE 12.5 the results are ordered by 
>> colid which is not happening in ASE 15. Including "order by colid" in 
>> the query could solve this issue. But I would just like to confirm 
>> whether this will break any other module if we do like this. Any kind 
>> of suggestion would be greatly appreciated.
>>
>> Thanks,
>> Neelakanta Prasad.J
>> Member-Information Technology
>> D.E.Shaw India Software Pvt Ltd.
>> Phone: +91-40-66390677
>> Email: [email protected]
>>
>>
> 
> 
> 


-- 
Michael Peppler           -                 Peppler Consulting SaRL
[email protected]      -                  http://www.peppler.org
Sybase DBA/Developer      -   TeamSybase: http://www.teamsybase.com
Sybase on Linux FAQ       -   http://www.peppler.org/FAQ/linux.html