Subject | RE: [IBO] Bugs: Strange query result that involve timestamp field with date params |
---|---|
Author | IBO Support List |
Post date | 2012-06-07T01:43:09Z |
Ok, I've looked into this more and the multiple parameters need to be of the
same underlying SQL type in order to all become bound together. You have
some of them as DATE and some of them as TIMESTAMP and IBO cannot
consolidate them all to a single buffer space.
I'm looking into a way that perhaps I can detect this and use parameter type
coercion in order to make this work. But, I'm not so sure I'll be able to
accomplish this.
You may want try and cast the columns or the parameters to force them all to
be of the same type.
Jason
same underlying SQL type in order to all become bound together. You have
some of them as DATE and some of them as TIMESTAMP and IBO cannot
consolidate them all to a single buffer space.
I'm looking into a way that perhaps I can detect this and use parameter type
coercion in order to make this work. But, I'm not so sure I'll be able to
accomplish this.
You may want try and cast the columns or the parameters to force them all to
be of the same type.
Jason