Mike -
Yes, but that's not what I said. I was talking about a non-explicit
operation which may take place during execution of the BROWSE command and is
not accessible to the user. If we assume the TEXT values are stored padded
with blanks or are padded with blanks to the column width before comparisons
then columns of different text lengths can never be equal if the blanks are
included in the comparison. Something on the order of
BROWSE ALL FROM diaginfo WHERE (STRIM(diagname)) IN (SELECT (STRIM(disease))
FROM
pasthist)
should work since your command below works.
BROWSE ALL FROM diaginfo WHERE (SGET(DIAGNAME,36,1)) in (SELECT DISEASE
FROM pasthist)
In your command the values compared are exactly equivalent bytewise, being
the first 36 bytes of both columns. What I don't understand is why Ben's
BROWSE command
Brow * from diaginfo t1, pasthist t2 whe t1.diagname = t2.disease
does work because strings of differing lengths are being found equal when in
a strict logical sense they can't be equal unless the trailing blanks are
stripped.
At a minimum this is an inconsistency but I don't know if it
qualifies as a bug. Hmmmm. Maybe we should discuss the definition of
behavioral criteria for bug designation.
Bernie
======================================
At 01:41 PM 6/4/2001 -0400, you wrote:
>The strim did not make the problem go away!
>
>Mike Sinclair
>
>Bernie Corrigan wrote:
>>
>> Jim -
>> I disagree. "Jim Blackburn " does not equal "Jim Blackburn
>> ". We can of course arbitrarily specify that trailing blanks are not to be
>> used in string comparisons; however, they are characters. LIKE handles the
>> original problem. I'm a bit surprised that what appears to be an automatic
>> STRIM takes place before the compare in the BROWSE from both tables
>> command's implicit view.
>>
>> Bernie
>> ======================================
>> At 08:40 AM 6/4/2001 -0800, you wrote:
>> >Mike:
>> >The logic of your command is very clear. I would not be happy trying to
>> explain that failure to one of our research biologists. It is clearly a bug.
>> >
>> >My $0.02,
>> >Jim Blackburn
>> >Kodiak
>> >
>> >MJS wrote:
>> >I was looking for a concensus on wether or not to submit it to RDCC.
>> >>
>> >> Mike Sinclair
>> >>
>> >> Ben Petersen wrote:
>> >> >
>> >> > Mike,
>> >> >
>> >> > Try:
>> >> >
>> >> > Brow * from diaginfo t1, pasthist t2 whe t1.diagname = t2.disease
>> >> >
>> >> > Ben Petersen
>> >> >
>> >> > On 4 Jun 2001, at 8:20, MJS wrote:
>> >> >
>> >> > > the following does not yield any rows.....
>> >> > >
>> >> > > BROWSE ALL FROM diaginfo WHERE diagname IN (SELECT disease FROM
>> >> > > pasthist)
>> >> > >
>> >> > > But this works...
>> >> > >
>> >> > > BROWSE ALL FROM diaginfo WHERE (SGET(DIAGNAME,36,1)) in (SELECT
DISEASE
>> >> > > FROM pasthist)
>> >> > >
>> >
>> >
>
>
>
