[Opensource] 5.0 DBObject quoting a 'between' clause incorrectly

[Michael Rimov]

At 09:38 PM 11/4/2002 -0600, you wrote:
>I found the problem. Here's the scenario:
>SELECT ... FROM ...
>WHERE COLUMNNAME BETWEEN '3 and 6'
>when COLUMNNAME is a text type (ie varchar)
>
>This is caused by DBMaint.quoteIfNeeded() - it doesn't check for the 
>between clause.
>
>My work around was to alter the type of the column to be numeric, as it 
>should have been anyway.
>
>I won't be able to patch this - way too much to do. Can you add this to 
>the bottom of some list somewhere, Mike?

Sure, I'll add it to the list of known bugs.
                                         -Mike