The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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
22.3k9129262


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
29.3k287438645
accept rate: 32%

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:

×137
×18
×12

question asked: 29 Jun '10, 00:33

question was seen: 1,954 times

last updated: 21 Mar '14, 11:12