LOCATE function bug?
This is a discussion on LOCATE function bug? within the DB2 forums, part of the Database Server Software category; --> Hello. v8.2.1 Try this (and any 3-d argument): --- select locate('','string',5) from sysibm.sysdummy1; --- Is it a feature or ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 11:27 AM
| |||
| |||
 Re: LOCATE function bug? 4.spam@mail.ru wrote: > Hello. > > v8.2.1 > Try this (and any 3-d argument): > --- > select locate('','string',5) from sysibm.sysdummy1; > --- > Is it a feature or a bug? $ db2 "values locate('','string',5)" 1 ----------- 5 1 record(s) selected. This is exactly what I would expect: at position 5 is the first occurrence where an empty string starts. -- Knut Stolze DB2 z/OS Utilities Development IBM Germany      |
|
02-27-2008, 11:27 AM
| |||
| |||
| Re: LOCATE function bug? And how about 3-d argument > length(source_string) ? For example, posstr(substr('string', 10), '') returns error, but locate('','string',10) returns 10... > $ db2 "values locate('','string',5)" > > 1 > ----------- > 5 > > 1 record(s) selected. > > This is exactly what I would expect: at position 5 is the first occurrence > where an empty string starts. > |
|
02-27-2008, 11:28 AM
| ||||
| ||||
| Re: LOCATE function bug? 4.spam@mail.ru wrote: > And how about 3-d argument > length(source_string) ? > For example, > posstr(substr('string', 10), '') > returns error, but > locate('','string',10) > returns 10... That's inconsistent, indeed... -- Knut Stolze DB2 z/OS Utilities Development IBM Germany |
 |
« Media Error - while restoring backup from Tape
|
SQL1091C The release number of the database is not valid. SQLSTATE=08004 »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 08:37 AM.
