MDEV-20922: Adding an order by changes the query results

For Item_direct_view_ref , get value from val_* methods
instead of result* family
The val_* methods gets value from the item on which it is referred.

1 files changed, 8 insertions, 0 deletions

diff --git a/sql/item.h b/sql/item.h
index bea09620ef8..8a90d99db9d 100644
--- a/sql/item.h
+++ b/sql/item.h
@@ -4477,6 +4477,14 @@ public:
     item_equal= NULL;
     Item_direct_ref::cleanup();
   }
+  /*
+    TODO move these val_*_result function to Item_dierct_ref (maybe)
+  */
+  double val_result();
+  longlong val_int_result();
+  String *str_result(String* tmp);
+  my_decimal *val_decimal_result(my_decimal *val);
+  bool val_bool_result();
 };