trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eric Owhadi <eric.owh...@esgyn.com>
Subject question on normalization
Date Mon, 14 Dec 2015 21:25:55 GMT 
I am implementing predicate push down enhancement. doing so, I found
something weird.

If I do select an from t132 where an != 1

The normalized predicate is ((an < 1) or <an >1))

I would have expected a simple an <> 1

There is probably a reason being this? But what is it?

Thanks in advance for the help,
Eric
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message