summaryrefslogtreecommitdiff
path: root/mysql-test/include/rowid_order.inc
diff options
context:
space:
mode:
authorunknown <mleich@three.local.lan>2006-08-16 19:29:49 +0200
committerunknown <mleich@three.local.lan>2006-08-16 19:29:49 +0200
commit27990803f63e962d0c9841bb5ffe0111d6cfaa93 (patch)
tree1f8310d811b09798025613871c02de4eccca2899 /mysql-test/include/rowid_order.inc
parent808237b083fe36ea393b7e05e1f6c78d8213c106 (diff)
downloadmariadb-git-27990803f63e962d0c9841bb5ffe0111d6cfaa93.tar.gz
This changeset belongs to
WL#3397 Refactoring storage engine test cases (for falcon) It contains fixes according to second code review. - Remove any occurence of hardcoded assignments of storage engines - Use variable names exact telling what it is used for - Updated comments - remove trailing spaces mysql-test/include/handler.inc: - Replace hardcoded MyISAM with assignments via variable mysql-test/include/mix1.inc: - Replace hardcoded MyISAM with assignments via variable - Remove hardcoded InnoDB assignments (They were introduced by late push) - Remove trailing spaces mysql-test/include/mix2.inc: - Replace hardcode MyISAM assignments - Remove trailing spaces - Engine assignments via variable refers to the use of the storage engine $other_non_trans_engine_type, $other_live_chcks_engine_type ... mysql-test/include/read_many_rows.inc: Replace hardcoded MyISAM assignment mysql-test/include/rowid_order.inc: remove trailing spaces mysql-test/r/handler_innodb.result: Updated result mysql-test/r/handler_myisam.result: Updated result mysql-test/r/innodb_mysql.result: Updated result mysql-test/r/mix2_myisam.result: Updated result mysql-test/r/read_many_rows_innodb.result: Updated result mysql-test/r/rowid_order_innodb.result: Updated result mysql-test/t/handler_innodb.test: Introduce $variables mysql-test/t/handler_myisam.test: Introduce $variables mysql-test/t/mix2_myisam.test: Introduce $variables mysql-test/t/read_many_rows_innodb.test: Introduce $variables
Diffstat (limited to 'mysql-test/include/rowid_order.inc')
-rw-r--r--mysql-test/include/rowid_order.inc14
1 files changed, 7 insertions, 7 deletions
diff --git a/mysql-test/include/rowid_order.inc b/mysql-test/include/rowid_order.inc
index 688e6a584b1..b05bad45cde 100644
--- a/mysql-test/include/rowid_order.inc
+++ b/mysql-test/include/rowid_order.inc
@@ -1,7 +1,7 @@
# include/rowid_order.inc
#
# Test for rowid ordering (and comparison) functions.
-# do index_merge select for tables with PK of various types.
+# do index_merge select for tables with PK of various types.
#
# The variable
# $engine_type -- storage engine to be tested
@@ -22,8 +22,8 @@ eval SET SESSION STORAGE_ENGINE = $engine_type;
drop table if exists t1, t2, t3,t4;
--enable_warnings
-# Signed number as rowid
-create table t1 (
+# Signed number as rowid
+create table t1 (
pk1 int not NULL,
key1 int(11),
key2 int(11),
@@ -40,8 +40,8 @@ explain select * from t1 force index(key1, key2) where key1 < 3 or key2 < 3;
select * from t1 force index(key1, key2) where key1 < 3 or key2 < 3;
drop table t1;
-# Unsigned numbers as rowids
-create table t1 (
+# Unsigned numbers as rowids
+create table t1 (
pk1 int unsigned not NULL,
key1 int(11),
key2 int(11),
@@ -58,7 +58,7 @@ select * from t1 force index(key1, key2) where key1 < 3 or key2 < 3;
drop table t1;
# Case-insensitive char(N)
-create table t1 (
+create table t1 (
pk1 char(4) not NULL,
key1 int(11),
key2 int(11),
@@ -84,7 +84,7 @@ create table t1 (
KEY key1 (key1),
KEY key2 (key2)
);
-insert into t1 values
+insert into t1 values
(1, 'u', 'u', 1, 1),
(1, 'u', char(0xEC), 1, 1),
(1, 'u', 'x', 1, 1);