On 03-10-12 22:30, Rick Debay wrote:
The field f.ID is alphanumeric, it can contain many types of data and
the data type is described by f.ID_QUALIFIER .
The problem is that Firebird is always evaluating f.ID = which throws
an exception when f.ID contains non-numeric characters and b.ID_TYPE_*
, October 04, 2012 3:58 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Order of operations - AND boolean
operator
On 03-10-12 22:30, Rick Debay wrote:
The field f.ID is alphanumeric, it can contain many types of data and
the data type is described by f.ID_QUALIFIER
The field f.ID is alphanumeric, it can contain many types of data and
the data type is described by f.ID_QUALIFIER .
The problem is that Firebird is always evaluating f.ID = which throws
an exception when f.ID contains non-numeric characters and b.ID_TYPE_*
is numeric.
FROM FOO f
JOIN BAR b ON