bzr commit into mysql-6.0-falcon-team branch (lars-erik.bjork:2899) Bug#40130

[lars-erik.bjork]

#At file:///home/lb200670/devel/mysql/nanna21/

 2899 lars-erik.bjork@stripped	2008-11-04
      This is a commit for bug#40130 (Falcon date / time indexes broken)
      
      The bug was actually fixed by the patch to bug 40112 (Thanks
      Kevin:) ). This commit only includes a regression test for the bug.
      
      Two files are added, these are:
      
      mysql-test/suite/falcon/t/falcon_bug_40130.test
      mysql-test/suite/falcon/r/falcon_bug_40130.result
added:
  mysql-test/suite/falcon/r/falcon_bug_40130.result
  mysql-test/suite/falcon/t/falcon_bug_40130.test

=== added file 'mysql-test/suite/falcon/r/falcon_bug_40130.result'
--- a/mysql-test/suite/falcon/r/falcon_bug_40130.result	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/falcon/r/falcon_bug_40130.result	2008-11-04 13:24:47 +0000
@@ -0,0 +1,398 @@
+*** Bug #40130 ***
+SET @@storage_engine = 'Falcon';
+DROP TABLE IF EXISTS `table10`;
+CREATE TABLE `table10` (`time_key` time, key (`time_key` ));
+INSERT IGNORE INTO table10 VALUES ('23:43:55');
+INSERT IGNORE INTO table10 VALUES ('03:18:59');
+INSERT IGNORE INTO table10 VALUES ('05:05:23');
+INSERT IGNORE INTO table10 VALUES ('09:20:40');
+INSERT IGNORE INTO table10 VALUES ('22:32:50');
+INSERT IGNORE INTO table10 VALUES ('07:41:31');
+INSERT IGNORE INTO table10 VALUES ('10:52:13');
+INSERT IGNORE INTO table10 VALUES ('12:40:54');
+INSERT IGNORE INTO table10 VALUES ('10:33:25');
+INSERT IGNORE INTO table10 VALUES ('22:11:46');
+SET AUTOCOMMIT=OFF;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '09:11:23' WHERE `time_key` < '16:23:56' ;
+INSERT INTO `table10` VALUES ( '20:25:18' ) ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '10:33:25' WHERE `time_key` > '22:11:46' ;
+INSERT INTO `table10` VALUES ( '17:58:48' ) ;
+COMMIT;
+START TRANSACTION ;
+INSERT INTO `table10` VALUES ( '00:16:10' ) ;
+UPDATE `table10` SET `time_key` = '16:05:35' WHERE `time_key` > '16:57:24' ;
+COMMIT;
+START TRANSACTION ;
+INSERT INTO `table10` VALUES ( '20:24:01' ) ;
+INSERT INTO `table10` VALUES ( '18:37:59' ) ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '21:05:17' WHERE `time_key` < '06:07:07' ;
+INSERT INTO `table10` VALUES ( '00:05:40' ) ;
+COMMIT;
+START TRANSACTION ;
+INSERT INTO `table10` VALUES ( '13:34:36' ) ;
+INSERT INTO `table10` VALUES ( '22:35:15' ) ;
+COMMIT;
+START TRANSACTION ;
+INSERT INTO `table10` VALUES ( '09:32:02' ) ;
+INSERT INTO `table10` VALUES ( '12:02:39' ) ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '19:22:23' WHERE `time_key` < '03:39:55' ;
+UPDATE `table10` SET `time_key` = '13:45:38' WHERE `time_key` < '03:52:41' ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '21:57:00' WHERE `time_key` < '11:37:04' ;
+INSERT INTO `table10` VALUES ( '18:56:03' ) ;
+COMMIT;
+START TRANSACTION ;
+INSERT INTO `table10` VALUES ( '21:46:34' ) ;
+INSERT INTO `table10` VALUES ( '00:46:37' ) ;
+COMMIT;
+START TRANSACTION ;
+INSERT INTO `table10` VALUES ( '11:54:45' ) ;
+INSERT INTO `table10` VALUES ( '11:00:16' ) ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '04:41:27' WHERE `time_key` > '05:45:30' ;
+INSERT INTO `table10` VALUES ( '05:55:02' ) ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '02:51:17' WHERE `time_key` < '05:33:58' ;
+INSERT INTO `table10` VALUES ( '06:07:14' ) ;
+COMMIT;
+START TRANSACTION ;
+INSERT INTO `table10` VALUES ( '19:17:13' ) ;
+UPDATE `table10` SET `time_key` = '14:23:25' WHERE `time_key` < '18:44:25' ;
+COMMIT;
+START TRANSACTION ;
+INSERT INTO `table10` VALUES ( '01:54:06' ) ;
+INSERT INTO `table10` VALUES ( '05:36:42' ) ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '04:04:15' WHERE `time_key` < '17:09:11' ;
+INSERT INTO `table10` VALUES ( '13:22:58' ) ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '03:45:01' WHERE `time_key` < '01:02:29' ;
+INSERT INTO `table10` VALUES ( '14:45:34' ) ;
+COMMIT;
+START TRANSACTION ;
+INSERT INTO `table10` VALUES ( '12:33:12' ) ;
+INSERT INTO `table10` VALUES ( '21:40:27' ) ;
+COMMIT;
+START TRANSACTION ;
+INSERT INTO `table10` VALUES ( '05:05:45' ) ;
+INSERT INTO `table10` VALUES ( '01:21:15' ) ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '01:43:44' WHERE `time_key` > '18:44:54' ;
+UPDATE `table10` SET `time_key` = '16:00:25' WHERE `time_key` > '17:37:45' ;
+COMMIT;
+START TRANSACTION ;
+INSERT INTO `table10` VALUES ( '09:17:29' ) ;
+UPDATE `table10` SET `time_key` = '00:32:27' WHERE `time_key` < '19:55:22' ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '00:01:27' WHERE `time_key` < '23:49:20' ;
+INSERT INTO `table10` VALUES ( '11:10:06' ) ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '21:52:14' WHERE `time_key` > '00:54:57' ;
+INSERT INTO `table10` VALUES ( '10:32:20' ) ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '05:48:51' WHERE `time_key` < '05:53:48' ;
+UPDATE `table10` SET `time_key` = '04:11:47' WHERE `time_key` > '14:02:03' ;
+COMMIT;
+START TRANSACTION ;
+INSERT INTO `table10` VALUES ( '20:58:47' ) ;
+INSERT INTO `table10` VALUES ( '06:58:04' ) ;
+COMMIT;
+START TRANSACTION ;
+INSERT INTO `table10` VALUES ( '14:41:45' ) ;
+UPDATE `table10` SET `time_key` = '00:45:47' WHERE `time_key` < '21:51:00' ;
+COMMIT;
+START TRANSACTION ;
+INSERT INTO `table10` VALUES ( '09:01:24' ) ;
+INSERT INTO `table10` VALUES ( '07:07:37' ) ;
+COMMIT;
+START TRANSACTION ;
+INSERT INTO `table10` VALUES ( '06:25:00' ) ;
+INSERT INTO `table10` VALUES ( '05:47:01' ) ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '12:31:51' WHERE `time_key` > '04:34:05' ;
+INSERT INTO `table10` VALUES ( '01:31:26' ) ;
+COMMIT;
+START TRANSACTION ;
+INSERT INTO `table10` VALUES ( '01:46:22' ) ;
+INSERT INTO `table10` VALUES ( '01:14:58' ) ;
+COMMIT;
+START TRANSACTION ;
+INSERT INTO `table10` VALUES ( '04:09:31' ) ;
+UPDATE `table10` SET `time_key` = '08:28:13' WHERE `time_key` > '14:50:18' ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '11:19:43' WHERE `time_key` < '04:30:14' ;
+INSERT INTO `table10` VALUES ( '20:03:24' ) ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '14:40:32' WHERE `time_key` < '15:30:08' ;
+UPDATE `table10` SET `time_key` = '03:13:02' WHERE `time_key` < '21:47:42' ;
+COMMIT;
+START TRANSACTION ;
+INSERT INTO `table10` VALUES ( '20:37:56' ) ;
+UPDATE `table10` SET `time_key` = '15:51:19' WHERE `time_key` < '01:39:43' ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '07:15:18' WHERE `time_key` > '05:37:40' ;
+INSERT INTO `table10` VALUES ( '18:47:30' ) ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '13:32:24' WHERE `time_key` > '23:38:12' ;
+INSERT INTO `table10` VALUES ( '23:32:39' ) ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '22:01:18' WHERE `time_key` < '17:51:48' ;
+INSERT INTO `table10` VALUES ( '11:41:29' ) ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '15:45:55' WHERE `time_key` > '04:03:52' ;
+UPDATE `table10` SET `time_key` = '05:43:47' WHERE `time_key` < '07:29:01' ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '23:44:48' WHERE `time_key` < '00:33:42' ;
+UPDATE `table10` SET `time_key` = '08:56:04' WHERE `time_key` > '12:16:41' ;
+COMMIT;
+START TRANSACTION ;
+INSERT INTO `table10` VALUES ( '19:23:41' ) ;
+INSERT INTO `table10` VALUES ( '18:44:20' ) ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '00:40:04' WHERE `time_key` > '11:34:06' ;
+UPDATE `table10` SET `time_key` = '23:45:59' WHERE `time_key` < '09:44:50' ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '18:54:59' WHERE `time_key` < '15:46:02' ;
+INSERT INTO `table10` VALUES ( '17:37:41' ) ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '17:08:04' WHERE `time_key` < '14:11:50' ;
+UPDATE `table10` SET `time_key` = '21:33:59' WHERE `time_key` > '17:44:43' ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '03:50:15' WHERE `time_key` > '19:35:18' ;
+UPDATE `table10` SET `time_key` = '23:15:47' WHERE `time_key` < '12:18:46' ;
+COMMIT;
+START TRANSACTION ;
+INSERT INTO `table10` VALUES ( '22:50:01' ) ;
+INSERT INTO `table10` VALUES ( '17:29:53' ) ;
+COMMIT;
+START TRANSACTION ;
+INSERT INTO `table10` VALUES ( '21:33:30' ) ;
+INSERT INTO `table10` VALUES ( '06:27:52' ) ;
+COMMIT;
+START TRANSACTION ;
+INSERT INTO `table10` VALUES ( '07:49:31' ) ;
+INSERT INTO `table10` VALUES ( '21:31:25' ) ;
+COMMIT;
+START TRANSACTION ;
+INSERT INTO `table10` VALUES ( '13:50:22' ) ;
+INSERT INTO `table10` VALUES ( '15:13:07' ) ;
+COMMIT;
+START TRANSACTION ;
+INSERT INTO `table10` VALUES ( '14:06:24' ) ;
+INSERT INTO `table10` VALUES ( '19:10:11' ) ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '05:03:39' WHERE `time_key` > '11:46:31' ;
+INSERT INTO `table10` VALUES ( '04:35:34' ) ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '14:37:01' WHERE `time_key` < '02:11:03' ;
+INSERT INTO `table10` VALUES ( '10:52:22' ) ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '15:37:40' WHERE `time_key` > '11:19:00' ;
+INSERT INTO `table10` VALUES ( '08:46:29' ) ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '07:59:59' WHERE `time_key` < '05:27:20' ;
+UPDATE `table10` SET `time_key` = '00:45:15' WHERE `time_key` < '20:07:08' ;
+COMMIT;
+START TRANSACTION ;
+INSERT INTO `table10` VALUES ( '00:51:31' ) ;
+UPDATE `table10` SET `time_key` = '10:00:58' WHERE `time_key` < '16:41:45' ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '13:49:37' WHERE `time_key` > '10:40:48' ;
+INSERT INTO `table10` VALUES ( '05:16:25' ) ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '14:46:15' WHERE `time_key` < '12:48:22' ;
+UPDATE `table10` SET `time_key` = '05:50:46' WHERE `time_key` < '07:58:43' ;
+COMMIT;
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '00:11:06' WHERE `time_key` < '16:39:47' ;
+UPDATE `table10` SET `time_key` = '04:13:41' WHERE `time_key` < '14:55:39' ;
+COMMIT;
+SELECT * FROM `table10`;
+time_key
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+04:13:41
+START TRANSACTION ;
+UPDATE `table10` SET `time_key` = '00:28:04' WHERE `time_key` < '09:58:46' ;
+UPDATE `table10` SET `time_key` = '04:56:25' WHERE `time_key` > '09:26:08' ;
+COMMIT;
+SELECT * FROM `table10`;
+time_key
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+00:28:04
+DROP TABLE `table10`;

=== added file 'mysql-test/suite/falcon/t/falcon_bug_40130.test'
--- a/mysql-test/suite/falcon/t/falcon_bug_40130.test	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/falcon/t/falcon_bug_40130.test	2008-11-04 13:24:47 +0000
@@ -0,0 +1,101 @@
+--source include/have_falcon.inc
+
+#
+# Bug #40130: Falcon date / time indexes broken
+#
+--echo *** Bug #40130 ***
+
+# ----------------------------------------------------- #
+# --- Initialisation                                --- #
+# ----------------------------------------------------- #
+let $engine = 'Falcon';
+eval SET @@storage_engine = $engine;
+
+--disable_warnings
+DROP TABLE IF EXISTS `table10`;
+--enable_warnings
+
+# ----------------------------------------------------- #
+# --- Test                                          --- #
+# ----------------------------------------------------- #
+
+CREATE TABLE `table10` (`time_key` time, key (`time_key` ));
+INSERT IGNORE INTO table10 VALUES ('23:43:55');
+INSERT IGNORE INTO table10 VALUES ('03:18:59');
+INSERT IGNORE INTO table10 VALUES ('05:05:23');
+INSERT IGNORE INTO table10 VALUES ('09:20:40');
+INSERT IGNORE INTO table10 VALUES ('22:32:50');
+INSERT IGNORE INTO table10 VALUES ('07:41:31');
+INSERT IGNORE INTO table10 VALUES ('10:52:13');
+INSERT IGNORE INTO table10 VALUES ('12:40:54');
+INSERT IGNORE INTO table10 VALUES ('10:33:25');
+INSERT IGNORE INTO table10 VALUES ('22:11:46');
+
+SET AUTOCOMMIT=OFF;
+
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '09:11:23' WHERE `time_key` <
'16:23:56' ; INSERT INTO `table10` VALUES ( '20:25:18' ) ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '10:33:25' WHERE `time_key` >
'22:11:46' ; INSERT INTO `table10` VALUES ( '17:58:48' ) ; COMMIT;
+START TRANSACTION ; INSERT INTO `table10` VALUES ( '00:16:10' ) ; UPDATE `table10` SET
`time_key` = '16:05:35' WHERE `time_key` > '16:57:24' ; COMMIT;
+START TRANSACTION ; INSERT INTO `table10` VALUES ( '20:24:01' ) ; INSERT INTO `table10`
VALUES ( '18:37:59' ) ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '21:05:17' WHERE `time_key` <
'06:07:07' ; INSERT INTO `table10` VALUES ( '00:05:40' ) ; COMMIT;
+START TRANSACTION ; INSERT INTO `table10` VALUES ( '13:34:36' ) ; INSERT INTO `table10`
VALUES ( '22:35:15' ) ; COMMIT;
+START TRANSACTION ; INSERT INTO `table10` VALUES ( '09:32:02' ) ; INSERT INTO `table10`
VALUES ( '12:02:39' ) ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '19:22:23' WHERE `time_key` <
'03:39:55' ; UPDATE `table10` SET `time_key` = '13:45:38' WHERE `time_key` <
'03:52:41' ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '21:57:00' WHERE `time_key` <
'11:37:04' ; INSERT INTO `table10` VALUES ( '18:56:03' ) ; COMMIT;
+START TRANSACTION ; INSERT INTO `table10` VALUES ( '21:46:34' ) ; INSERT INTO `table10`
VALUES ( '00:46:37' ) ; COMMIT;
+START TRANSACTION ; INSERT INTO `table10` VALUES ( '11:54:45' ) ; INSERT INTO `table10`
VALUES ( '11:00:16' ) ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '04:41:27' WHERE `time_key` >
'05:45:30' ; INSERT INTO `table10` VALUES ( '05:55:02' ) ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '02:51:17' WHERE `time_key` <
'05:33:58' ; INSERT INTO `table10` VALUES ( '06:07:14' ) ; COMMIT;
+START TRANSACTION ; INSERT INTO `table10` VALUES ( '19:17:13' ) ; UPDATE `table10` SET
`time_key` = '14:23:25' WHERE `time_key` < '18:44:25' ; COMMIT;
+START TRANSACTION ; INSERT INTO `table10` VALUES ( '01:54:06' ) ; INSERT INTO `table10`
VALUES ( '05:36:42' ) ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '04:04:15' WHERE `time_key` <
'17:09:11' ; INSERT INTO `table10` VALUES ( '13:22:58' ) ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '03:45:01' WHERE `time_key` <
'01:02:29' ; INSERT INTO `table10` VALUES ( '14:45:34' ) ; COMMIT;
+START TRANSACTION ; INSERT INTO `table10` VALUES ( '12:33:12' ) ; INSERT INTO `table10`
VALUES ( '21:40:27' ) ; COMMIT;
+START TRANSACTION ; INSERT INTO `table10` VALUES ( '05:05:45' ) ; INSERT INTO `table10`
VALUES ( '01:21:15' ) ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '01:43:44' WHERE `time_key` >
'18:44:54' ; UPDATE `table10` SET `time_key` = '16:00:25' WHERE `time_key` >
'17:37:45' ; COMMIT;
+START TRANSACTION ; INSERT INTO `table10` VALUES ( '09:17:29' ) ; UPDATE `table10` SET
`time_key` = '00:32:27' WHERE `time_key` < '19:55:22' ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '00:01:27' WHERE `time_key` <
'23:49:20' ; INSERT INTO `table10` VALUES ( '11:10:06' ) ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '21:52:14' WHERE `time_key` >
'00:54:57' ; INSERT INTO `table10` VALUES ( '10:32:20' ) ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '05:48:51' WHERE `time_key` <
'05:53:48' ; UPDATE `table10` SET `time_key` = '04:11:47' WHERE `time_key` >
'14:02:03' ; COMMIT;
+START TRANSACTION ; INSERT INTO `table10` VALUES ( '20:58:47' ) ; INSERT INTO `table10`
VALUES ( '06:58:04' ) ; COMMIT;
+START TRANSACTION ; INSERT INTO `table10` VALUES ( '14:41:45' ) ; UPDATE `table10` SET
`time_key` = '00:45:47' WHERE `time_key` < '21:51:00' ; COMMIT;
+START TRANSACTION ; INSERT INTO `table10` VALUES ( '09:01:24' ) ; INSERT INTO `table10`
VALUES ( '07:07:37' ) ; COMMIT;
+START TRANSACTION ; INSERT INTO `table10` VALUES ( '06:25:00' ) ; INSERT INTO `table10`
VALUES ( '05:47:01' ) ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '12:31:51' WHERE `time_key` >
'04:34:05' ; INSERT INTO `table10` VALUES ( '01:31:26' ) ; COMMIT;
+START TRANSACTION ; INSERT INTO `table10` VALUES ( '01:46:22' ) ; INSERT INTO `table10`
VALUES ( '01:14:58' ) ; COMMIT;
+START TRANSACTION ; INSERT INTO `table10` VALUES ( '04:09:31' ) ; UPDATE `table10` SET
`time_key` = '08:28:13' WHERE `time_key` > '14:50:18' ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '11:19:43' WHERE `time_key` <
'04:30:14' ; INSERT INTO `table10` VALUES ( '20:03:24' ) ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '14:40:32' WHERE `time_key` <
'15:30:08' ; UPDATE `table10` SET `time_key` = '03:13:02' WHERE `time_key` <
'21:47:42' ; COMMIT;
+START TRANSACTION ; INSERT INTO `table10` VALUES ( '20:37:56' ) ; UPDATE `table10` SET
`time_key` = '15:51:19' WHERE `time_key` < '01:39:43' ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '07:15:18' WHERE `time_key` >
'05:37:40' ; INSERT INTO `table10` VALUES ( '18:47:30' ) ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '13:32:24' WHERE `time_key` >
'23:38:12' ; INSERT INTO `table10` VALUES ( '23:32:39' ) ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '22:01:18' WHERE `time_key` <
'17:51:48' ; INSERT INTO `table10` VALUES ( '11:41:29' ) ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '15:45:55' WHERE `time_key` >
'04:03:52' ; UPDATE `table10` SET `time_key` = '05:43:47' WHERE `time_key` <
'07:29:01' ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '23:44:48' WHERE `time_key` <
'00:33:42' ; UPDATE `table10` SET `time_key` = '08:56:04' WHERE `time_key` >
'12:16:41' ; COMMIT;
+START TRANSACTION ; INSERT INTO `table10` VALUES ( '19:23:41' ) ; INSERT INTO `table10`
VALUES ( '18:44:20' ) ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '00:40:04' WHERE `time_key` >
'11:34:06' ; UPDATE `table10` SET `time_key` = '23:45:59' WHERE `time_key` <
'09:44:50' ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '18:54:59' WHERE `time_key` <
'15:46:02' ; INSERT INTO `table10` VALUES ( '17:37:41' ) ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '17:08:04' WHERE `time_key` <
'14:11:50' ; UPDATE `table10` SET `time_key` = '21:33:59' WHERE `time_key` >
'17:44:43' ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '03:50:15' WHERE `time_key` >
'19:35:18' ; UPDATE `table10` SET `time_key` = '23:15:47' WHERE `time_key` <
'12:18:46' ; COMMIT;
+START TRANSACTION ; INSERT INTO `table10` VALUES ( '22:50:01' ) ; INSERT INTO `table10`
VALUES ( '17:29:53' ) ; COMMIT;
+START TRANSACTION ; INSERT INTO `table10` VALUES ( '21:33:30' ) ; INSERT INTO `table10`
VALUES ( '06:27:52' ) ; COMMIT;
+START TRANSACTION ; INSERT INTO `table10` VALUES ( '07:49:31' ) ; INSERT INTO `table10`
VALUES ( '21:31:25' ) ; COMMIT;
+START TRANSACTION ; INSERT INTO `table10` VALUES ( '13:50:22' ) ; INSERT INTO `table10`
VALUES ( '15:13:07' ) ; COMMIT;
+START TRANSACTION ; INSERT INTO `table10` VALUES ( '14:06:24' ) ; INSERT INTO `table10`
VALUES ( '19:10:11' ) ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '05:03:39' WHERE `time_key` >
'11:46:31' ; INSERT INTO `table10` VALUES ( '04:35:34' ) ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '14:37:01' WHERE `time_key` <
'02:11:03' ; INSERT INTO `table10` VALUES ( '10:52:22' ) ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '15:37:40' WHERE `time_key` >
'11:19:00' ; INSERT INTO `table10` VALUES ( '08:46:29' ) ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '07:59:59' WHERE `time_key` <
'05:27:20' ; UPDATE `table10` SET `time_key` = '00:45:15' WHERE `time_key` <
'20:07:08' ; COMMIT;
+START TRANSACTION ; INSERT INTO `table10` VALUES ( '00:51:31' ) ; UPDATE `table10` SET
`time_key` = '10:00:58' WHERE `time_key` < '16:41:45' ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '13:49:37' WHERE `time_key` >
'10:40:48' ; INSERT INTO `table10` VALUES ( '05:16:25' ) ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '14:46:15' WHERE `time_key` <
'12:48:22' ; UPDATE `table10` SET `time_key` = '05:50:46' WHERE `time_key` <
'07:58:43' ; COMMIT;
+START TRANSACTION ; UPDATE `table10` SET `time_key` = '00:11:06' WHERE `time_key` <
'16:39:47' ; UPDATE `table10` SET `time_key` = '04:13:41' WHERE `time_key` <
'14:55:39' ; COMMIT;
+
+SELECT * FROM `table10`;
+START TRANSACTION ;UPDATE `table10` SET `time_key` = '00:28:04' WHERE `time_key` <
'09:58:46' ; UPDATE `table10` SET `time_key` = '04:56:25' WHERE `time_key` >
'09:26:08' ; COMMIT;
+SELECT * FROM `table10`;
+
+# ----------------------------------------------------- #
+# --- Final cleanup                                 --- #
+# ----------------------------------------------------- #
+DROP TABLE `table10`;