Error in the regular expression crashes application.
Sometimes my procedure using the expression '^-{0,1}*\d+*\d*$' crashes applications.
I have made a mistake in that expression, I forgot to remove the "*" marked red, but this error should not cause the application to crash!
I think there is error in the regular expression engine, which show cases below:
select case when (REGEXP_LIKE('-23,4','^-{0,1}*\d+,*\d*$')) then 1 else 0 end a from dual; -- works
select case when (REGEXP_LIKE('- 23,4','^-{0,1}*\d+,*\d*$')) then 1 else 0 end a from dual; -- crashes (add: " " between "-" and "23,4")
Tomasz Górniak
0