Using SA 11.0.1.2331

begin

declare @string varchar (100) ; 
set @string= 'a' ;

select * from sa_split_list(@string)

end 

returns

line_num,row_value
1,'a'

So far so good.

So why does

begin

declare @string varchar (100) ; 
set @string= 'a' ;

select * from sa_split_list(@string, '||')

end 

not return anything?

I can't see anything in the documentation that says non-default delimiters should behave differently.

asked 29 Jun '10, 00:33

Vincent%20Buck's gravatar image

Vincent Buck
70681520
accept rate: 15%

edited 21 Mar '14, 11:12

Mark%20Culp's gravatar image

Mark Culp
24.9k10141297


AFAIK, this is a wrong behaviour fixed with 11.0.1.2381. From the readme.html for EBF 11.0.1.2427:

================(Build #2381 - Engineering Case #616395)================

The system procedure sa_split_list() did not work as expected when a multi-character delimiter was provided, and the string to be split was shorter than the delimiter. No rows were returned, whereas the expected result was a single row containing the string to be split. This has been fixed.

permanent link

answered 29 Jun '10, 07:07

Volker%20Barth's gravatar image

Volker Barth
40.1k361549819
accept rate: 34%

1

Thanks. To anyone from Sybase reading this: you have superb online help. Please think of consolidating EBFs into the online doc. Who's going to parse all EBFs unless they are a full-time DBA? This would make it SO MUCH easier to troubleshoot problems and work around version quirks

(29 Jun '10, 07:59) Vincent Buck
2

@Vincent: EBFs are cumulative which means that you would only need to review one README file (i.e. the latest one) to see if there was a fix relating to an issue that you were having. We have had discussions about making the EBF READMEs available via dcx but I can't remember what the outcome was of that discussion? I will mention it again to the doc team.

(29 Jun '10, 12:24) Mark Culp

@Vincent: In addition to Mark's comment: The fact that the newer EBF readmes (since about last year) can be filtered to list only the changes between build x and y makes looking for the relevant ones really easy - that is a great relieve IMHO. I'm at best a "quarter-time DBA" but scanning through the EBF readmes is worthwhile.

(29 Jun '10, 19:42) Volker Barth

It works OK in the version 12 beta (build 2429). Are you using the latest build of version 11?

permanent link

answered 29 Jun '10, 06:57

rbiffl's gravatar image

rbiffl
203357
accept rate: 0%

I'm using 11.0.1.2331

(29 Jun '10, 06:58) Vincent Buck
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×143
×22
×12

question asked: 29 Jun '10, 00:33

question was seen: 4,140 times

last updated: 21 Mar '14, 11:12