Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in August and this forum will be retired.

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
72181620
accept rate: 15%

edited 21 Mar '14, 11:12

Mark%20Culp's gravatar image

Mark Culp
25.0k10142298


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.4k365554826
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,271 times

last updated: 21 Mar '14, 11:12