SQL search should require escaped characters, no?

[jda]

Hi Ruslan,

In b28 I find that

select * from myTable where title='a.b.c'

finds a record with a.b.c in the title field.

I thought it should fail (and was using 'a\.b\.c' as the search 
string, which didn't work). In contrast, the same search done as 
REGEX requires the periods to be escaped.

This seems inconsistent -- I thought you always had to escape strings in SQL.

Is this a bug I should report?

Jon

P.S. Happy Thanksgiving everyone (where ever you are)!