dbTalk Databases Forums  

sa_split_list: Bug or Feature?

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss sa_split_list: Bug or Feature? in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Clive Collie
 
Posts: n/a

Default sa_split_list: Bug or Feature? - 01-25-2010 , 08:55 AM






If I run this:
call sa_split_list('AA','\x0d\x0a')

I get this result set (which is what I expect)
line_num,row_value
1,'AA'

If I call this:
call sa_split_list('A','\x0d\x0a')
I get nothing at all. The letter isn't relevant, it's the fact that there is
only one letter in the string.

This is not what I expect.

What should I expect?

Regards,
Clive

Reply With Quote
  #2  
Old   
Bruce Hay
 
Posts: n/a

Default Re: sa_split_list: Bug or Feature? - 01-26-2010 , 09:58 AM






It was a bug. It will be fixed in 11.0.1.2381 and in version 12. Thanks for
reporting it.

SQL Anywhere Developer Community:
http://www.sybase.com/developer/libr...ere-techcorner


SQL Anywhere Blog Center: http://www.sybase.com/sqlanyblogs




Clive Collie wrote:
Quote:
If I run this:
call sa_split_list('AA','\x0d\x0a')

I get this result set (which is what I expect)
line_num,row_value
1,'AA'

If I call this:
call sa_split_list('A','\x0d\x0a')
I get nothing at all. The letter isn't relevant, it's the fact that
there is only one letter in the string.

This is not what I expect.

What should I expect?

Regards,
Clive

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.