String Delimiter Nullstr TEST EXPECTED Nullstr arg is omitted All these ...

String Nullstr arg is omitted empty empty empty null null null something something delim-only has-delim has-leading-delim-only has-trailing-delim-only has-consecutive-delim has-delim-AND-leading-delim has-delim-AND-trailing-delim has-delim-AND-consecutive-delim has-leading-delim-and-trailing-delim has-delim-AND-leading-delim-AND-trailing-delim has-delim-AND-consecutive-delim-AND-leading-delim has-delim-AND-consecutive-delim-AND-trailing-delim has-delim-AND-consecutive-delim-AND-leading-delim-AND-trailing potential ambiguity of delims

All these same as above but NULL nullstr (gives same results) empty empty empty null null null something something delim-only has-delim has-leading-delim-only has-trailing-delim-only has-consecutive-delim has-delim-AND-leading-delim has-delim-AND-trailing-delim has-delim-AND-consecutive-delim has-leading-delim-and-trailing-delim has-delim-AND-leading-delim-AND-trailing-delim has-delim-AND-consecutive-delim-AND-leading-delim has-delim-AND-consecutive-delim-AND-trailing-delim has-delim-AND-consecutive-delim-AND-leading-delim-AND-trailing potential ambiguity of delims

All these same as above but empty nullstr (empty rows become NULL) empty empty empty null null null something something delim-only has-delim has-leading-delim-only has-trailing-delim-only has-consecutive-delim has-delim-AND-leading-delim has-delim-AND-trailing-delim has-delim-AND-consecutive-delim has-leading-delim-and-trailing-delim has-delim-AND-leading-delim-AND-trailing-delim has-delim-AND-consecutive-delim-AND-leading-delim has-delim-AND-consecutive-delim-AND-trailing-delim has-delim-AND-consecutive-delim-AND-leading-delim-AND-trailing potential ambiguity of delims

Delimiter Nullstr

empty

-

null

-

something -

empty

-

null

-

something -

empty

-

null

-

delim

-

delim

-

delim

-

delim

-

delim

-

delim

-

delim

-

delim

-

delim

-

delim

-

delim

-

delim

-

delim

-

delim

-

empty null something empty null something empty null delim delim delim delim delim delim delim delim delim delim delim delim delim delim

NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

empty null something empty null something empty null delim delim delim delim delim delim delim delim delim delim delim delim delim delim

empty empty empty empty empty empty empty empty empty empty empty empty empty empty empty empty empty empty empty empty empty empty

TEST

select string_to_table('', ''); select string_to_table('', NULL); select string_to_table('', '|'); select string_to_table(NULL, ''); select string_to_table(NULL, NULL); select string_to_table(NULL, '|'); select string_to_table('a|b|c', ''); select string_to_table('a|b|c', NULL); select string_to_table('|', '|'); select string_to_table('a|b|c', '|'); select string_to_table('|abc', '|'); select string_to_table('abc|', '|'); select string_to_table('ab||c', '|'); select string_to_table('|a|b|c', '|'); select string_to_table('a|b|c|', '|'); select string_to_table('a|b||c', '|'); select string_to_table('|abc|', '|'); select string_to_table('|a|b|c|', '|'); select string_to_table('|a|b||c', '|'); select string_to_table('a|b||c|', '|'); select string_to_table('|a|b||c|', '|'); select string_to_table('|||ab|||','||')

EXPECTED

{} {} {} {} {} {} {a|b|c} {a,|,b,|,c} {EMPTY,EMPTY} {a,b,c} {EMPTY,abc} {abc,EMPTY} {ab,EMPTY,c} {EMPTY,a,b,c} {a,b,c,EMPTY} {a,b,EMPTY,c} {EMPTY,abc,EMPTY} {EMPTY,a,b,c,EMPTY} {EMPTY,a,b,EMPTY,c} {a,b,EMPTY,c,EMPTY} {EMPTY,a,b,EMPTY,c,EMPTY} {EMPTY,|ab,|}

select string_to_table('', '',NULL); select string_to_table('', NULL,NULL); select string_to_table('', '|',NULL); select string_to_table(NULL, '',NULL); select string_to_table(NULL, NULL,NULL); select string_to_table(NULL, '|',NULL); select string_to_table('a|b|c', '',NULL); select string_to_table('a|b|c', NULL,NULL); select string_to_table('|', '|',NULL); select string_to_table('a|b|c', '|',NULL); select string_to_table('|abc', '|',NULL); select string_to_table('abc|', '|',NULL); select string_to_table('ab||c', '|',NULL); select string_to_table('|a|b|c', '|',NULL); select string_to_table('a|b|c|', '|',NULL); select string_to_table('a|b||c', '|',NULL); select string_to_table('|abc|', '|',NULL); select string_to_table('|a|b|c|', '|',NULL); select string_to_table('|a|b||c', '|',NULL); select string_to_table('a|b||c|', '|',NULL); select string_to_table('|a|b||c|', '|',NULL); select string_to_table('|||ab|||','||',NULL)

{} {} {} {} {} {} {a|b|c} {a,|,b,|,c} {EMPTY,EMPTY} {a,b,c} {EMPTY,abc} {abc,EMPTY} {ab,EMPTY,c} {EMPTY,a,b,c} {a,b,c,EMPTY} {a,b,EMPTY,c} {EMPTY,abc,EMPTY} {EMPTY,a,b,c,EMPTY} {EMPTY,a,b,EMPTY,c} {a,b,EMPTY,c,EMPTY} {EMPTY,a,b,EMPTY,c,EMPTY} {EMPTY,|ab,|}

select string_to_table('', '',''); select string_to_table('', NULL,''); select string_to_table('', '|',''); select string_to_table(NULL, '',''); select string_to_table(NULL, NULL,''); select string_to_table(NULL, '|',''); select string_to_table('a|b|c', '',''); select string_to_table('a|b|c', NULL,''); select string_to_table('|', '|',''); select string_to_table('a|b|c', '|',''); select string_to_table('|abc', '|',''); select string_to_table('abc|', '|',''); select string_to_table('ab||c', '|',''); select string_to_table('|a|b|c', '|',''); select string_to_table('a|b|c|', '|',''); select string_to_table('a|b||c', '|',''); select string_to_table('|abc|', '|',''); select string_to_table('|a|b|c|', '|',''); select string_to_table('|a|b||c', '|',''); select string_to_table('a|b||c|', '|',''); select string_to_table('|a|b||c|', '|',''); select string_to_table('|||ab|||','||','')

{} {} {} {} {} {} {a|b|c} {a,|,b,|,c} {NULL,NULL} {a,b,c} {NULL,abc} {abc,NULL} {ab,NULL,c} {NULL,a,b,c} {a,b,c,NULL} {a,b,NULL,c} {NULL,abc,NULL} {NULL,a,b,c,NULL} {NULL,a,b,NULL,c} {a,b,NULL,c,NULL} {NULL,a,b,NULL,c,NULL} {NULL,|ab,|}

0 rows 0 rows 0 rows 0 rows 0 rows 0 rows 1 row 5 rows 2 rows 3 rows 2 rows 2 rows 3 rows 4 rows 4 rows 4 rows 3 rows 5 rows 5 rows 5 rows 6 rows 3 rows

0 rows 0 rows 0 rows 0 rows 0 rows 0 rows 1 row 5 rows 2 rows 3 rows 2 rows 2 rows 3 rows 4 rows 4 rows 4 rows 3 rows 5 rows 5 rows 5 rows 6 rows 3 rows

0 rows 0 rows 0 rows 0 rows 0 rows 0 rows 1 row 5 rows 2 rows 3 rows 2 rows 2 rows 3 rows 4 rows 4 rows 4 rows 3 rows 5 rows 5 rows 5 rows 6 rows 3 rows

String Nullstr arg is present but does NOT appear in the string empty empty empty null null null something something delim-only has-delim has-leading-delim-only has-trailing-delim-only has-consecutive-delim has-delim-AND-leading-delim has-delim-AND-trailing-delim has-delim-AND-consecutive-delim has-leading-delim-and-trailing-delim has-delim-AND-leading-delim-AND-trailing-delim has-delim-AND-consecutive-delim-AND-leading-delim has-delim-AND-consecutive-delim-AND-trailing-delim has-delim-AND-consecutive-delim-AND-leading-delim-AND-trailing potential ambiguity of delims

Nullstr arg is present and DOES appear in the string empty empty empty null null null something something delim-only has-delim has-leading-delim-only has-trailing-delim-only has-consecutive-delim has-delim-AND-leading-delim has-delim-AND-trailing-delim has-delim-AND-consecutive-delim has-leading-delim-and-trailing-delim has-delim-AND-leading-delim-AND-trailing-delim has-delim-AND-consecutive-delim-AND-leading-delim has-delim-AND-consecutive-delim-AND-trailing-delim has-delim-AND-consecutive-delim-AND-leading-delim-AND-trailing potential ambiguity of delims

Miscellanous nullstr only delimiters get applied 1st nullstr gets applied 2nd case sensitive delim case sensitive nullstr

Delimiter Nullstr

empty null something empty null something empty null delim delim delim delim delim delim delim delim delim delim delim delim delim delim

nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr

empty null something empty null something empty null delim delim delim delim delim delim delim delim delim delim delim delim delim delim

nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr nullstr

delim delim null delim delim

nullstr nullstr nullstr nullstr

TEST

select string_to_table('', '','*'); select string_to_table('', NULL,'*'); select string_to_table('', '|','*'); select string_to_table(NULL, '','*'); select string_to_table(NULL, NULL,'*'); select string_to_table(NULL, '|','*'); select string_to_table('a|b|c', '','*'); select string_to_table('a|b|c', NULL,'*'); select string_to_table('|', '|','*'); select string_to_table('a|b|c', '|','*'); select string_to_table('|abc', '|','*'); select string_to_table('abc|', '|','*'); select string_to_table('ab||c', '|','*'); select string_to_table('|a|b|c', '|','*'); select string_to_table('a|b|c|', '|','*'); select string_to_table('a|b||c', '|','*'); select string_to_table('|abc|', '|','*'); select string_to_table('|a|b|c|', '|','*'); select string_to_table('|a|b||c', '|','*'); select string_to_table('a|b||c|', '|','*'); select string_to_table('|a|b||c|', '|','*'); select string_to_table('|||ab|||','||','*')

EXPECTED

{} {} {} {} {} {} {a|b|c} {a,|,b,|,c} {EMPTY,EMPTY} {a,b,c} {EMPTY,abc} {abc,EMPTY} {ab,EMPTY,c} {EMPTY,a,b,c} {a,b,c,EMPTY} {a,b,EMPTY,c} {EMPTY,abc,EMPTY} {EMPTY,a,b,c,EMPTY} {EMPTY,a,b,EMPTY,c} {a,b,EMPTY,c,EMPTY} {EMPTY,a,b,EMPTY,c,EMPTY} {EMPTY,|ab,|}

NA NA NA NA NA NA select string_to_table('a|b|*|c', '','*'); select string_to_table('a|b|*|c', NULL,'*'); NA select string_to_table('a|b|*|c', '|','*'); select string_to_table('|ab*c', '|','*'); select string_to_table('ab*c|', '|','*'); select string_to_table('ab*||c', '|','*'); select string_to_table('|a|b|*|c','|','*'); select string_to_table('a|b|*|c|', '|','*'); select string_to_table('a|b|*||c', '|','*'); select string_to_table('|ab*c|', '|','*'); select string_to_table('|a|b|*|c|', '|','*'); select string_to_table('|a|b|*||c', '|','*'); select string_to_table('a|b|*||c|', '|','*'); select string_to_table('|a|b|*||c|', '|','*'); select string_to_table('|||ab|||*|||','||','*')

{a|b|*|c} {a,|,b,|,NULL,|,c}

{a,b,NULL,c} {EMPTY,ab*c} {ab*c,EMPTY} {ab*,EMPTY,c} {EMPTY,a,b,NULL,c} {a,b,NULL,c,EMPTY} {a,b,NULL,EMPTY,c} {EMPTY,ab*c,EMPTY} {EMPTY,a,b,NULL,c,EMPTY} {EMPTY,a,b,NULL,EMPTY,c} {a,b,NULL,EMPTY,c,EMPTY} {EMPTY,a,b,NULL,EMPTY,c,EMPTY} {EMPTY,|ab,|*,|}

select string_to_table('*','','*'); select string_to_table('*','*','*'); select string_to_table('**',NULL,'*'); select string_to_table('axbXcxd','x'); select string_to_table('a|b|X|x|c','|','X');

{NULL} {EMPTY,EMPTY} {NULL,NULL} {a,bXc,d} {a,b,NULL,x,c}

0 rows 0 rows 0 rows 0 rows 0 rows 0 rows 1 row 5 rows 2 rows 3 rows 2 rows 2 rows 3 rows 4 rows 4 rows 4 rows 3 rows 5 rows 5 rows 5 rows 6 rows 3 rows

1 row 7 rows

4 rows 2 rows 2 rows 3 rows 5 rows 5 rows 5 rows 3 rows 6 rows 6 rows 6 rows 7 rows 4 rows

1 row 2 rows 2 rows 3 rows 5 rows

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download