From 9b2e4c7c60b3cbb9e1f9e19c011656f5708e7015 Mon Sep 17 00:00:00 2001 From: unknown Date: Thu, 24 Mar 2005 18:10:46 +0400 Subject: Fixed that LEFT OUTER JOIN was replaced with a regulat join in some cases, because "charset(x) = 'string'" was considered as "x is not null" due to incorrect not_null_tables(). --- sql/item_strfunc.h | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'sql/item_strfunc.h') diff --git a/sql/item_strfunc.h b/sql/item_strfunc.h index 0c3ed32fb68..323b52b826c 100644 --- a/sql/item_strfunc.h +++ b/sql/item_strfunc.h @@ -641,7 +641,9 @@ public: { collation.set(system_charset_info); max_length= 64 * collation.collation->mbmaxlen; // should be enough + maybe_null= 0; }; + table_map not_null_tables() const { return 0; } }; class Item_func_collation :public Item_str_func @@ -654,7 +656,9 @@ public: { collation.set(system_charset_info); max_length= 64 * collation.collation->mbmaxlen; // should be enough + maybe_null= 0; }; + table_map not_null_tables() const { return 0; } }; class Item_func_crc32 :public Item_int_func -- cgit v1.2.1