|
|
sybperl-l Archive
Up Prev Next
From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: Need help :-Problem using Sybase::BLK with ASE 15
Date: Mar 13 2008 7:10PM
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:Scott.Zetlan@corp.aol.com]
> Sent: Thursday, March 13, 2008 10:06 PM
> To: Prasad, Neelakanta
> Cc: mpeppler@peppler.org
> 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:Neelakanta.Prasad@deshaw.com]
> 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: 'scottzetlan@aol.com'; 'sybperl-l@peppler.org';
>> 'mpeppler@peppler.org'
>> Cc: 'jnp_swiss@yahoo.co.in'
>> 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: prasadn@deshaw.com
>>
>>
>
>
>
--
Michael Peppler - Peppler Consulting SaRL
mpeppler@peppler.org - http://www.peppler.org
Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com
Sybase on Linux FAQ - http://www.peppler.org/FAQ/linux.html
|
