Hey,
I would like to ask a question about storage and evaluation of the
record of a table in MySQL. More clearly, val_int method of item object
evaluates the result. Right? I want to evaluate the result of the
expression not only on the current record, but also on the old records.
In order to do this, I did copy 'join->all_fields' at each time when
record evaluated by assuming join->all_fields stores the row (at
sql/sql_select.cc evaluate_join_record(..) method). Later I point the
join->all_fields to one of the copied records (ex join->all_fields) and
run 'predicate.val_int()'. It doesn't work as I expected and it still
returns the result of current row, not the copied one.
Does anyone have suggestion?
Thanks,
Nihal