diff options
Diffstat (limited to 'mysql-test/suite/parts/r/partition_datetime_myisam.result')
-rw-r--r-- | mysql-test/suite/parts/r/partition_datetime_myisam.result | 122 |
1 files changed, 61 insertions, 61 deletions
diff --git a/mysql-test/suite/parts/r/partition_datetime_myisam.result b/mysql-test/suite/parts/r/partition_datetime_myisam.result index 0d1dcf3e..9d8acb09 100644 --- a/mysql-test/suite/parts/r/partition_datetime_myisam.result +++ b/mysql-test/suite/parts/r/partition_datetime_myisam.result @@ -509,67 +509,67 @@ SUBPARTITIONS 3 select count(*) from t3; count(*) 59 -select * from t3; -a -10:00:01 -10:00:02 -10:00:03 -10:00:04 -10:00:05 -10:00:06 -10:00:07 -10:00:08 -10:00:09 -10:00:10 -10:00:11 -10:00:12 -10:00:13 -10:00:14 -10:00:15 -10:00:16 -10:00:17 -10:00:18 -10:00:19 -10:00:20 -10:00:21 -10:00:22 -10:00:23 -10:00:24 -10:00:25 -10:00:26 -10:00:27 -10:00:28 -10:00:29 -10:00:30 -10:00:31 -10:00:32 -10:00:33 -10:00:34 -10:00:35 -10:00:36 -10:00:37 -10:00:38 -10:00:39 -10:00:40 -10:00:41 -10:00:42 -10:00:43 -10:00:44 -10:00:45 -10:00:46 -10:00:47 -10:00:48 -10:00:49 -10:00:50 -10:00:51 -10:00:52 -10:00:53 -10:00:54 -10:00:55 -10:00:56 -10:00:57 -10:00:58 -10:00:59 +select a, second(a), if(second(a)<16,1,if(second(a)<31,2,if(second(a)<45,3,4))) from t3; +a second(a) if(second(a)<16,1,if(second(a)<31,2,if(second(a)<45,3,4))) +10:00:01 1 1 +10:00:02 2 1 +10:00:03 3 1 +10:00:04 4 1 +10:00:05 5 1 +10:00:06 6 1 +10:00:07 7 1 +10:00:08 8 1 +10:00:09 9 1 +10:00:10 10 1 +10:00:11 11 1 +10:00:12 12 1 +10:00:13 13 1 +10:00:14 14 1 +10:00:15 15 1 +10:00:16 16 2 +10:00:17 17 2 +10:00:18 18 2 +10:00:19 19 2 +10:00:20 20 2 +10:00:21 21 2 +10:00:22 22 2 +10:00:23 23 2 +10:00:24 24 2 +10:00:25 25 2 +10:00:26 26 2 +10:00:27 27 2 +10:00:28 28 2 +10:00:29 29 2 +10:00:30 30 2 +10:00:31 31 3 +10:00:32 32 3 +10:00:33 33 3 +10:00:34 34 3 +10:00:35 35 3 +10:00:36 36 3 +10:00:37 37 3 +10:00:38 38 3 +10:00:39 39 3 +10:00:40 40 3 +10:00:41 41 3 +10:00:42 42 3 +10:00:43 43 3 +10:00:44 44 3 +10:00:45 45 4 +10:00:46 46 4 +10:00:47 47 4 +10:00:48 48 4 +10:00:49 49 4 +10:00:50 50 4 +10:00:51 51 4 +10:00:52 52 4 +10:00:53 53 4 +10:00:54 54 4 +10:00:55 55 4 +10:00:56 56 4 +10:00:57 57 4 +10:00:58 58 4 +10:00:59 59 4 drop table t3; create table t4 (a time not null, primary key(a)) engine='MyISAM' partition by list (second(a)) subpartition by key (a) |