Below is the list of changes that have just been committed into a local
5.1 repository of hhunger. When hhunger does a push these changes
will be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html
ChangeSet@stripped, 2008-04-30 14:05:15+02:00, hhunger@stripped +2 -0
Without "SET" (bug 35988).
mysql-test/r/myisam_use_mmap_basic.result@stripped, 2008-04-30 14:05:13+02:00, hhunger@stripped +52 -0
Without "SET" (bug 35988).
mysql-test/r/myisam_use_mmap_basic.result@stripped, 2008-04-30 14:05:13+02:00, hhunger@stripped +0 -0
mysql-test/t/myisam_use_mmap_basic.test@stripped, 2008-04-30 14:05:13+02:00, hhunger@stripped +104 -0
Without "SET" (bug 35988).
mysql-test/t/myisam_use_mmap_basic.test@stripped, 2008-04-30 14:05:13+02:00, hhunger@stripped +0 -0
diff -Nrup a/mysql-test/r/myisam_use_mmap_basic.result b/mysql-test/r/myisam_use_mmap_basic.result
--- /dev/null Wed Dec 31 16:00:00 196900
+++ b/mysql-test/r/myisam_use_mmap_basic.result 2008-04-30 14:05:13 +02:00
@@ -0,0 +1,52 @@
+'#---------------------BS_STVARS_042_01----------------------#'
+SELECT COUNT(@@GLOBAL.myisam_use_mmap);
+COUNT(@@GLOBAL.myisam_use_mmap)
+1
+1 Expected
+'#---------------------BS_STVARS_042_02----------------------#'
+"BUG:It should give error on setting this variable as it is readonly variable"
+Expected error 'Read only variable'
+SELECT COUNT(@@GLOBAL.myisam_use_mmap);
+COUNT(@@GLOBAL.myisam_use_mmap)
+1
+1 Expected
+'#---------------------BS_STVARS_042_03----------------------#'
+SELECT @@GLOBAL.myisam_use_mmap = VARIABLE_VALUE
+FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
+WHERE VARIABLE_NAME='myisam_use_mmap';
+@@GLOBAL.myisam_use_mmap = VARIABLE_VALUE
+1
+1 Expected
+SELECT COUNT(@@GLOBAL.myisam_use_mmap);
+COUNT(@@GLOBAL.myisam_use_mmap)
+1
+1 Expected
+SELECT COUNT(VARIABLE_VALUE)
+FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
+WHERE VARIABLE_NAME='myisam_use_mmap';
+COUNT(VARIABLE_VALUE)
+1
+1 Expected
+'#---------------------BS_STVARS_042_04----------------------#'
+SELECT @@myisam_use_mmap = @@GLOBAL.myisam_use_mmap;
+@@myisam_use_mmap = @@GLOBAL.myisam_use_mmap
+1
+1 Expected
+'#---------------------BS_STVARS_042_05----------------------#'
+SELECT COUNT(@@myisam_use_mmap);
+COUNT(@@myisam_use_mmap)
+1
+1 Expected
+SELECT COUNT(@@local.myisam_use_mmap);
+ERROR HY000: Variable 'myisam_use_mmap' is a GLOBAL variable
+Expected error 'Variable is a GLOBAL variable'
+SELECT COUNT(@@SESSION.myisam_use_mmap);
+ERROR HY000: Variable 'myisam_use_mmap' is a GLOBAL variable
+Expected error 'Variable is a GLOBAL variable'
+SELECT COUNT(@@GLOBAL.myisam_use_mmap);
+COUNT(@@GLOBAL.myisam_use_mmap)
+1
+1 Expected
+SELECT myisam_use_mmap = @@SESSION.myisam_use_mmap;
+ERROR 42S22: Unknown column 'myisam_use_mmap' in 'field list'
+Expected error 'Readonly variable'
diff -Nrup a/mysql-test/t/myisam_use_mmap_basic.test b/mysql-test/t/myisam_use_mmap_basic.test
--- /dev/null Wed Dec 31 16:00:00 196900
+++ b/mysql-test/t/myisam_use_mmap_basic.test 2008-04-30 14:05:13 +02:00
@@ -0,0 +1,104 @@
+
+
+################## mysql-test\t\myisam_use_mmap_basic.test ####################
+# #
+# Variable Name: myisam_use_mmap #
+# Scope: Global #
+# Access Type: Static #
+# Data Type: #
+# #
+# #
+# Creation Date: 2008-02-07 #
+# Author : Sharique Abdullah #
+# #
+# #
+# Description:Test Cases of Dynamic System Variable myisam_use_mmap #
+# that checks the behavior of this variable in the following ways #
+# * Value Check #
+# * Scope Check #
+# #
+# Reference: http://dev.mysql.com/doc/refman/5.1/en/ #
+# server-system-variables.html #
+# #
+###############################################################################
+
+--echo '#---------------------BS_STVARS_042_01----------------------#'
+####################################################################
+# Displaying default value #
+####################################################################
+SELECT COUNT(@@GLOBAL.myisam_use_mmap);
+--echo 1 Expected
+
+
+--echo '#---------------------BS_STVARS_042_02----------------------#'
+#
+# Test case for Bug #35433
+#
+####################################################################
+# Check if Value can set #
+####################################################################
+
+#--error ER_INCORRECT_GLOBAL_LOCAL_VAR
+#SET @@GLOBAL.myisam_use_mmap=1;
+--ECHO "BUG:It should give error on setting this variable as it is readonly variable"
+--echo Expected error 'Read only variable'
+
+SELECT COUNT(@@GLOBAL.myisam_use_mmap);
+--echo 1 Expected
+
+
+
+
+--echo '#---------------------BS_STVARS_042_03----------------------#'
+#################################################################
+# Check if the value in GLOBAL Table matches value in variable #
+#################################################################
+
+SELECT @@GLOBAL.myisam_use_mmap = VARIABLE_VALUE
+FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
+WHERE VARIABLE_NAME='myisam_use_mmap';
+--echo 1 Expected
+
+SELECT COUNT(@@GLOBAL.myisam_use_mmap);
+--echo 1 Expected
+
+SELECT COUNT(VARIABLE_VALUE)
+FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
+WHERE VARIABLE_NAME='myisam_use_mmap';
+--echo 1 Expected
+
+
+
+--echo '#---------------------BS_STVARS_042_04----------------------#'
+################################################################################
+# Check if accessing variable with and without GLOBAL point to same variable #
+################################################################################
+SELECT @@myisam_use_mmap = @@GLOBAL.myisam_use_mmap;
+--echo 1 Expected
+
+
+
+--echo '#---------------------BS_STVARS_042_05----------------------#'
+################################################################################
+# Check if myisam_use_mmap can be accessed with and without @@ sign #
+################################################################################
+
+SELECT COUNT(@@myisam_use_mmap);
+--echo 1 Expected
+
+--Error ER_INCORRECT_GLOBAL_LOCAL_VAR
+SELECT COUNT(@@local.myisam_use_mmap);
+--echo Expected error 'Variable is a GLOBAL variable'
+
+--Error ER_INCORRECT_GLOBAL_LOCAL_VAR
+SELECT COUNT(@@SESSION.myisam_use_mmap);
+--echo Expected error 'Variable is a GLOBAL variable'
+
+SELECT COUNT(@@GLOBAL.myisam_use_mmap);
+--echo 1 Expected
+
+--Error ER_BAD_FIELD_ERROR
+SELECT myisam_use_mmap = @@SESSION.myisam_use_mmap;
+--echo Expected error 'Readonly variable'
+
+
| Thread |
|---|
| • bk commit into 5.1 tree (hhunger:1.2567) | horst | 30 Apr |
