Skip to Content
0
Nov 14, 2013 at 06:15 PM

LIKE bug in ASE 15.0.3?

19 Views

Does anyone know anything about this apparent bug?

if "Jones" like "%[QRS]%" print "yes" else print "no"

Results in no as expected.

if "Jones" like "%[Q-S]%" print "yes" else print "no"

Results in no as expected.

if "Jones" like "%[QRST]%" print "yes" else print "no"

Results in no as expected.

if "Jones" like "%[Q-T]%" print "yes" else print "no"

Surprise! Results in yes.

Seems to have something to do with with case sensitivity, but only when a LIKE range is being used, and only when the matching character is not the last character in the range.

I have reproduced this in ASE versions 15.0.3 ESD 2 through 4.

- John.