1 files changed, 151 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/t/read_only_func.test b/mysql-test/suite/sys_vars/t/read_only_func.test
new file mode 100644
index 00000000000..c8fb932544b
--- /dev/null
+++ b/mysql-test/suite/sys_vars/t/read_only_func.test
@@ -0,0 +1,151 @@
+############ mysql-test\t\read_only_func.test ##################################
+#                                                                              #
+#Variable Name: read_only                                                      #
+#Scope: SESSION                                                                #
+#Access Type: Dynamic                                                          #
+#Data Type: BOOLEAN                                                            #
+#Default Value: OFF                                                            #
+#Values:      ON, OFF                                                          #
+#                                                                              #
+#                                                                              #
+#Creation Date: 2008-03-02                                                     #
+#Author:  Sharique Abdullah                                                        #
+#                                                                              #
+#Description: Test Cases of Dynamic System Variable "read_only"                #
+#             that checks behavior of this variable in the following ways      #
+#             * Functionality based on different values                        #
+#                                                                              #
+#Reference: http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#
+# option_mysqld_read_only                                                      #
+#                                                                              #
+################################################################################
+
+--echo ** Setup **
+--echo
+#
+# Setup
+#
+
+--source include/not_embedded.inc
+
+SET @default_read_only = @@read_only;
+
+--echo '#--------------------FN_DYNVARS_140_01-------------------------#'
+###################################
+#Setting Read only value ON       #
+###################################
+
+SET Global read_only=ON;
+
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+--enable_warnings
+
+##################################
+#     Creating table             #
+##################################
+
+
+# creating table
+CREATE TABLE t1
+(
+id INT NOT NULL auto_increment,
+PRIMARY KEY (id),
+name BLOB
+);
+
+##################################
+#         Inserting values       #
+##################################
+
+
+INSERT into t1(name) values("aaassssssssddddddddffffff");
+
+###################################
+#   Updating values               #
+###################################
+
+update t1 set name="jfjdf" where id=1;
+
+###############################################
+# Select to see wether value is updated or not#
+###############################################
+
+select * from t1 where id=1;
+
+--echo '#--------------------FN_DYNVARS_140_02-------------------------#'
+#########################################
+#Creating user without Super privilege  #
+#########################################
+
+
+--echo ** Creating new user with out super privilege**
+CREATE user sameea;
+--echo ** Connecting connn using username 'sameea' **
+CONNECT (connn,localhost,sameea,,);
+
+--Error ER_SPECIFIC_ACCESS_DENIED_ERROR
+SET Global read_ONLY=ON;
+--Error ER_OPTION_PREVENTS_STATEMENT
+CREATE TABLE t2
+(
+id INT NOT NULL auto_increment,
+PRIMARY KEY (id),
+name BLOB
+);
+
+# With ps-protocol the error is ER_NO_SUCH_TABLE
+--echo not updating values
+--Error ER_OPTION_PREVENTS_STATEMENT,ER_NO_SUCH_TABLE
+INSERT into t2(name) values("aaassssssssddddddddffffff");
+
+
+--Error ER_OPTION_PREVENTS_STATEMENT,ER_NO_SUCH_TABLE
+UPDATE t2 SET name="samia" where id=1;
+
+--echo '#--------------------FN_DYNVARS_140_03-------------------------#'
+
+###########################
+# Testing temporary table #
+###########################
+CREATE TEMPORARY TABLE t3(a int);
+
+--echo '#--------------------FN_DYNVARS_140_04-------------------------#'
+###########################
+# Turning read_only OFF   #
+###########################
+--echo ** Connection default **
+connection default;
+
+SET Global read_only=OFF;
+--echo ** Connection connn **
+connection connn;
+
+CREATE TABLE t2
+(
+id INT NOT NULL auto_increment,
+PRIMARY KEY (id),
+name BLOB
+);
+--echo updating values
+INSERT into t2(name) values("aaassssssssdddddddd");
+
+UPDATE t2 SET name="samia" where id=1;
+
+#
+# Cleanup
+#
+--echo ** Connection default **
+connection default;
+
+--echo ** Disconnecting connn **
+DISCONNECT connn;
+
+DROP USER sameea;
+
+DROP TABLE t1;
+DROP TABLE t2;
+SET global read_only = @default_read_only;
+
+--disable_info
+--enable_warnings