List:Commits« Previous MessageNext Message »
From:horst Date:April 30 2008 12:05pm
Subject:bk commit into 5.1 tree (hhunger:1.2567)
View as plain text  
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)horst30 Apr