DBD::Sybase wrong tabular output format ?

From: M Miliarakis (cretense_at_pathfinder.gr)
Date: 07/19/04


Date: 19 Jul 2004 06:17:41 -0700

Using DBD::Sybase I execute this query:
select convert(char(3),spid), convert(char(20),id), class
from master..syslocks
where object_name(id,dbid) not like '#%'
order by spid

The output is ok
39 1356531866 Non Cursor Lock
39 1356531866 Non Cursor Lock
39 1500532379 Non Cursor Lock
39 1600008731 Non Cursor Lock
39 848006052 Non Cursor Lock
122 384004399 Non Cursor Lock
122 384004399 Non Cursor Lock
122 384004399 Non Cursor Lock
137 384004399 Non Cursor Lock
137 384004399 Non Cursor Lock
137 384004399 Non Cursor Lock

When I change 2nd output field to its object name (leaving everything
else the same):
select convert(char(3),spid), convert(char(20),object_name(id,dbid)),
class
.....

I get this output (without the fixed format output that I am asking
for and I was getting before):
39 contract Non Cursor Lock
39 customer Non Cursor Lock
39 portal_statistics Non Cursor Lock
39 invoice_record_list Non Cursor Lock
39 invoice_record_list Non Cursor Lock
50 balance Non Cursor Lock
50 balance Non Cursor Lock
50 balance Non Cursor Lock
50 balance Non Cursor Lock
50 balance Non Cursor Lock
50 invoice Non Cursor Lock
50 invoice Non Cursor Lock
50 invoice Non Cursor Lock
50 invoice Non Cursor Lock
50 invoice Non Cursor Lock

Is this a bug or a feature??



Relevant Pages