ixed table and db name of fields incase of lower_case_table_names (BUG#5154)

sql/item.cc:
  fixed table and db name of fields incase of lower_case_table_names

3 files changed, 21 insertions, 0 deletions

diff --git a/mysql-test/r/lowercase_view.result b/mysql-test/r/lowercase_view.result
new file mode 100644
index 00000000000..233ca9590b8
--- /dev/null
+++ b/mysql-test/r/lowercase_view.result
@@ -0,0 +1,9 @@
+drop database if exists MySQLTest;
+create database MySQLTest;
+use MySQLTest;
+create table TaB (Field int);
+create view ViE as select * from TAb;
+show create table VIe;
+Table	Create Table
+vie	CREATE VIEW `mysqltest`.`vie` AS select `mysqltest`.`tab`.`Field` AS `Field` from `mysqltest`.`tab`
+drop database MySQLTest;
diff --git a/mysql-test/t/lowercase_view-master.opt b/mysql-test/t/lowercase_view-master.opt
new file mode 100644
index 00000000000..62ab6dad1e0
--- /dev/null
+++ b/mysql-test/t/lowercase_view-master.opt
@@ -0,0 +1 @@
+--lower_case_table_names=1
diff --git a/mysql-test/t/lowercase_view.test b/mysql-test/t/lowercase_view.test
new file mode 100644
index 00000000000..ed19c2184ab
--- /dev/null
+++ b/mysql-test/t/lowercase_view.test
@@ -0,0 +1,11 @@
+--disable_warnings
+drop database if exists MySQLTest;
+--enable_warnings
+
+
+create database MySQLTest;
+use MySQLTest;
+create table TaB (Field int);
+create view ViE as select * from TAb;
+show create table VIe;
+drop database MySQLTest;