Comment 5 for bug 882833

Revision history for this message
fimbulvetr (fimbulvetr) wrote :

Hello,

The problem exists with or without index condition pushdown. I actually have another wrong result bug related to index_condition_pushdown=on on the same table but am in the same situation - unable to synthesize failing data.

As far as the varchar - I cannot remove this column as it is the order by. The problem disappears when I remove the order by or order by an alternate column. (This may be very valuable information - to repeat, the problem only appears if I sort by this varchar). The problem remains whichever direction I sort by. I do not believe I will have time today or tomorrow to continue working on this but middle of this week I will attempt again to synthesize data. I hope you can help me come up with ideas on how to do this.