ASAN heap-buffer-overflow in lzo1x_1_15_compress / fil_page_compress_low

==3681751==ERROR: AddressSanitizer: heap-buffer-overflow on address 0x62d000418000 at pc 0x7fddf3c47681 bp 0x77dde8a9c510 sp 0x77dde8a9bcc0

WRITE of size 16384 at 0x62d000418000 thread T4

    #0 0x7fddf3c47680 in __interceptor_memset ../../../../src/libsanitizer/sanitizer_common/sanitizer_common_interceptors.inc:799

    #1 0x77dddd43541a in lzo1x_1_15_compress (/lib/x86_64-linux-gnu/liblzo2.so.2+0x1241a)

    #2 0x557923c810ab in fil_page_compress_low /data/bld/11.4-asan-ubsan/storage/innobase/fil/fil0pagecompress.cc:104

    #3 0x557923c817cf in fil_page_compress_for_full_crc32 /data/bld/11.4-asan-ubsan/storage/innobase/fil/fil0pagecompress.cc:182

    #4 0x557923c828f7 in fil_page_compress(unsigned char const*, unsigned char*, unsigned int, unsigned long, bool) /data/bld/11.4-asan-ubsan/storage/innobase/fil/fil0pagecompress.cc:374

    #5 0x557923b09909 in buf_page_encrypt /data/bld/11.4-asan-ubsan/storage/innobase/buf/buf0flu.cc:665

    #6 0x557923b0c5b1 in buf_page_t::flush(fil_space_t*) /data/bld/11.4-asan-ubsan/storage/innobase/buf/buf0flu.cc:825

    #7 0x557923b161b4 in buf_flush_LRU_list_batch /data/bld/11.4-asan-ubsan/storage/innobase/buf/buf0flu.cc:1377

    #8 0x557923b17323 in buf_do_LRU_batch /data/bld/11.4-asan-ubsan/storage/innobase/buf/buf0flu.cc:1415

    #9 0x557923b17779 in buf_flush_LRU /data/bld/11.4-asan-ubsan/storage/innobase/buf/buf0flu.cc:1754

    #10 0x557923b1d5c1 in buf_flush_page_cleaner /data/bld/11.4-asan-ubsan/storage/innobase/buf/buf0flu.cc:2598

    #11 0x557923b1e1b0 in void std::__invoke_impl<void, void (*)()>(std::__invoke_other, void (*&&)()) /usr/include/c++/12/bits/invoke.h:61

    #12 0x557923b1e1b0 in std::__invoke_result<void (*)()>::type std::__invoke<void (*)()>(void (*&&)()) /usr/include/c++/12/bits/invoke.h:96

    #13 0x557923b1e1b0 in void std::thread::_Invoker<std::tuple<void (*)()> >::_M_invoke<0ul>(std::_Index_tuple<0ul>) /usr/include/c++/12/bits/std_thread.h:252

    #14 0x557923b1e1b0 in std::thread::_Invoker<std::tuple<void (*)()> >::operator()() /usr/include/c++/12/bits/std_thread.h:259

    #15 0x557923b1e1b0 in std::thread::_State_impl<std::thread::_Invoker<std::tuple<void (*)()> > >::_M_run() /usr/include/c++/12/bits/std_thread.h:210

    #16 0x7fddf32d44a2  (/lib/x86_64-linux-gnu/libstdc++.so.6+0xd44a2)

    #17 0x7fddf28a81c3 in start_thread nptl/pthread_create.c:442

    #18 0x7fddf292885b in clone3 ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

0x62d000418000 is located 0 bytes to the right of 16384-byte region [0x62d000414000,0x62d000418000)

allocated by thread T4 here:

    #0 0x7fddf3cb7bf8 in __interceptor_memalign ../../../../src/libsanitizer/asan/asan_malloc_linux.cpp:99

    #1 0x557923b0197f in aligned_malloc(unsigned long, unsigned long) /data/bld/11.4-asan-ubsan/include/aligned.h:26

    #2 0x557923b0197f in buf_tmp_reserve_compression_buf /data/bld/11.4-asan-ubsan/storage/innobase/buf/buf0flu.cc:547

    #3 0x557923b09834 in buf_page_encrypt /data/bld/11.4-asan-ubsan/storage/innobase/buf/buf0flu.cc:663

    #4 0x557923b0c5b1 in buf_page_t::flush(fil_space_t*) /data/bld/11.4-asan-ubsan/storage/innobase/buf/buf0flu.cc:825

    #5 0x557923b161b4 in buf_flush_LRU_list_batch /data/bld/11.4-asan-ubsan/storage/innobase/buf/buf0flu.cc:1377

    #6 0x557923b17323 in buf_do_LRU_batch /data/bld/11.4-asan-ubsan/storage/innobase/buf/buf0flu.cc:1415

    #7 0x557923b17779 in buf_flush_LRU /data/bld/11.4-asan-ubsan/storage/innobase/buf/buf0flu.cc:1754

    #8 0x557923b1d5c1 in buf_flush_page_cleaner /data/bld/11.4-asan-ubsan/storage/innobase/buf/buf0flu.cc:2598

    #9 0x557923b1e1b0 in void std::__invoke_impl<void, void (*)()>(std::__invoke_other, void (*&&)()) /usr/include/c++/12/bits/invoke.h:61

    #10 0x557923b1e1b0 in std::__invoke_result<void (*)()>::type std::__invoke<void (*)()>(void (*&&)()) /usr/include/c++/12/bits/invoke.h:96

    #11 0x557923b1e1b0 in void std::thread::_Invoker<std::tuple<void (*)()> >::_M_invoke<0ul>(std::_Index_tuple<0ul>) /usr/include/c++/12/bits/std_thread.h:252

    #12 0x557923b1e1b0 in std::thread::_Invoker<std::tuple<void (*)()> >::operator()() /usr/include/c++/12/bits/std_thread.h:259

    #13 0x557923b1e1b0 in std::thread::_State_impl<std::thread::_Invoker<std::tuple<void (*)()> > >::_M_run() /usr/include/c++/12/bits/std_thread.h:210

    #14 0x7fddf32d44a2  (/lib/x86_64-linux-gnu/libstdc++.so.6+0xd44a2)

Thread T4 created by T0 here:

    #0 0x7fddf3c49726 in __interceptor_pthread_create ../../../../src/libsanitizer/asan/asan_interceptors.cpp:207

    #1 0x7fddf32d4578 in std::thread::_M_start_thread(std::unique_ptr<std::thread::_State, std::default_delete<std::thread::_State> >, void (*)()) (/lib/x86_64-linux-gnu/libstdc++.so.6+0xd4578)

    #2 0x557923b12cd8 in buf_flush_page_cleaner_init() /data/bld/11.4-asan-ubsan/storage/innobase/buf/buf0flu.cc:2762

    #3 0x5579238d5352 in srv_start(bool) /data/bld/11.4-asan-ubsan/storage/innobase/srv/srv0start.cc:1393

    #4 0x55792320a757 in innodb_init /data/bld/11.4-asan-ubsan/storage/innobase/handler/ha_innodb.cc:4160

    #5 0x557921f18fb7 in ha_initialize_handlerton(void*) /data/bld/11.4-asan-ubsan/sql/handler.cc:693

    #6 0x557920c36cda in plugin_do_initialize /data/bld/11.4-asan-ubsan/sql/sql_plugin.cc:1456

    #7 0x557920c50f37 in plugin_initialize /data/bld/11.4-asan-ubsan/sql/sql_plugin.cc:1510

    #8 0x557920c5505b in plugin_init(int*, char**, int) /data/bld/11.4-asan-ubsan/sql/sql_plugin.cc:1768

    #9 0x557920432d89 in init_server_components /data/bld/11.4-asan-ubsan/sql/mysqld.cc:5238

    #10 0x55792043e5a7 in mysqld_main(int, char**) /data/bld/11.4-asan-ubsan/sql/mysqld.cc:5931

    #11 0x557920411ae1 in main /data/bld/11.4-asan-ubsan/sql/main.cc:34

    #12 0x7fddf2846249 in __libc_start_call_main ../sysdeps/nptl/libc_start_call_main.h:58

SUMMARY: AddressSanitizer: heap-buffer-overflow ../../../../src/libsanitizer/sanitizer_common/sanitizer_common_interceptors.inc:799 in __interceptor_memset

Shadow bytes around the buggy address:

  0x0c5a8007afb0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00

  0x0c5a8007afc0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00

  0x0c5a8007afd0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00

  0x0c5a8007afe0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00

  0x0c5a8007aff0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00

=>0x0c5a8007b000:[fa]fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa

  0x0c5a8007b010: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa

  0x0c5a8007b020: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa

  0x0c5a8007b030: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa

  0x0c5a8007b040: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa

  0x0c5a8007b050: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa

Shadow byte legend (one shadow byte represents 8 application bytes):

  Addressable:           00

  Partially addressable: 01 02 03 04 05 06 07 

  Heap left redzone:       fa

  Freed heap region:       fd

  Stack left redzone:      f1

  Stack mid redzone:       f2

  Stack right redzone:     f3

  Stack after return:      f5

  Stack use after scope:   f8

  Global redzone:          f9

  Global init order:       f6

  Poisoned by user:        f7

  Container overflow:      fc

  Array cookie:            ac

  Intra object redzone:    bb

  ASan internal:           fe

  Left alloca redzone:     ca

  Right alloca redzone:    cb

==3681751==ABORTING

#5  <signal handler called>

#6  0x00007fbf7dea45c2 in _int_malloc (av=av@entry=0x77bf54000030, bytes=bytes@entry=65704) at ./malloc/malloc.c:4133

#7  0x00007fbf7dea5139 in __GI___libc_malloc (bytes=65704) at ./malloc/malloc.c:3329

#8  0x00007fbf7c025f2a in ?? () from /lib/x86_64-linux-gnu/liblzma.so.5

#9  0x00007fbf7c026715 in ?? () from /lib/x86_64-linux-gnu/liblzma.so.5

#10 0x00007fbf7c01836c in ?? () from /lib/x86_64-linux-gnu/liblzma.so.5

#11 0x00007fbf7c02027e in ?? () from /lib/x86_64-linux-gnu/liblzma.so.5

#12 0x00007fbf7c0204a3 in lzma_block_buffer_encode () from /lib/x86_64-linux-gnu/liblzma.so.5

#13 0x00007fbf7c020618 in lzma_stream_buffer_encode () from /lib/x86_64-linux-gnu/liblzma.so.5

#14 0x00007fbf7c021d3f in lzma_easy_buffer_encode () from /lib/x86_64-linux-gnu/liblzma.so.5

#15 0x000055602731dc29 in fil_page_compress_low (buf=0x77bf5da5c000 "", out_buf=0x77bf5404c000 "", header_len=26, comp_algo=4, comp_level=6) at /home/vsts/src/storage/innobase/fil/fil0pagecompress.cc:117

#16 0x000055602731dde2 in fil_page_compress_for_full_crc32 (buf=0x77bf5da5c000 "", out_buf=0x77bf5404c000 "", flags=1610612885, block_size=4096, encrypted=false) at /home/vsts/src/storage/innobase/fil/fil0pagecompress.cc:182

#17 0x000055602731eb05 in fil_page_compress (buf=0x77bf5da5c000 "", out_buf=0x77bf5404c000 "", flags=1610612885, block_size=4096, encrypted=false) at /home/vsts/src/storage/innobase/fil/fil0pagecompress.cc:374

#18 0x000055602728d8cd in buf_page_encrypt (space=0x77bf41f186b8, bpage=0x77bf5d807500, s=0x77bf5da5c000 "", slot=0x7fbf62ffd978, size=0x7fbf62ffd970) at /home/vsts/src/storage/innobase/buf/buf0flu.cc:665

#19 0x000055602728ea94 in buf_page_t::flush (this=0x77bf5d807500, space=0x77bf41f186b8) at /home/vsts/src/storage/innobase/buf/buf0flu.cc:825

#20 0x0000556027290112 in buf_flush_try_neighbors (space=0x77bf41f186b8, page_id=..., bpage=0x0, contiguous=true, n_flushed=17, n_to_flush=160) at /home/vsts/src/storage/innobase/buf/buf0flu.cc:1086

#21 0x000055602729206d in buf_do_flush_list_batch (max_n=160, lsn=18446744073709551615) at /home/vsts/src/storage/innobase/buf/buf0flu.cc:1536

#22 0x0000556027292476 in buf_flush_list_holding_mutex (max_n=160, lsn=18446744073709551615) at /home/vsts/src/storage/innobase/buf/buf0flu.cc:1595

#23 0x0000556027296219 in buf_flush_page_cleaner () at /home/vsts/src/storage/innobase/buf/buf0flu.cc:2688

#24 0x000055602729a317 in std::__invoke_impl<void, void (*)()> (__f=@0x5560668fa238: 0x55602729542d <buf_flush_page_cleaner()>) at /usr/include/c++/11/bits/invoke.h:61

#25 0x000055602729a2c3 in std::__invoke<void (*)()> (__fn=@0x5560668fa238: 0x55602729542d <buf_flush_page_cleaner()>) at /usr/include/c++/11/bits/invoke.h:96

#26 0x000055602729a264 in std::thread::_Invoker<std::tuple<void (*)()> >::_M_invoke<0ul> (this=0x5560668fa238) at /usr/include/c++/11/bits/std_thread.h:259

#27 0x000055602729a234 in std::thread::_Invoker<std::tuple<void (*)()> >::operator() (this=0x5560668fa238) at /usr/include/c++/11/bits/std_thread.h:266

#28 0x000055602729a214 in std::thread::_State_impl<std::thread::_Invoker<std::tuple<void (*)()> > >::_M_run (this=0x5560668fa230) at /usr/include/c++/11/bits/std_thread.h:211

#29 0x00007fbf7e2dc253 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6

#30 0x00007fbf7de94ac3 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442

#31 0x00007fbf7df268d0 in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

--source include/have_innodb.inc

# Due to MDEV-26800

call mtr.add_suppression("InnoDB: Failed to read page");

call mtr.add_suppression("MariaDB tried to use the");

call mtr.add_suppression("InnoDB: File '.*' is corrupted");

SET GLOBAL INNODB_COMPRESSION_DEFAULT = ON;

CREATE TABLE t1 (

 col_time_key time,

 col_timestamp_3 timestamp(3),

 col_datetime_key datetime,

 col_datetime_5 datetime(5),

 col_time_6 time(6),

 col_timestamp_4 timestamp(4),

 col_timestamp_5_not_null timestamp(5) not null,

 col_timestamp_6_key timestamp(6),

 col_timestamp_5_not_null_key timestamp(5) not null,

 col_timestamp_4_key timestamp(4),

 col_timestamp_3_key timestamp(3),

 col_timestamp_3_not_null_key timestamp(3) not null,

 col_timestamp_5_key timestamp(5),

 col_time_4_key time(4),

 col_timestamp_6_not_null_key timestamp(6) not null,

 col_time_not_null time not null,

 col_timestamp_3_not_null timestamp(3) not null,

 col_timestamp_2_not_null_key timestamp(2) not null,

 col_date_not_null date not null,

 col_date_not_null_key date not null,

 col_timestamp_0_key timestamp(0),

 col_year_not_null_key year not null,

 col_time_6_not_null time(6) not null,

 col_time_3_key time(3),

 col_datetime_6_key datetime(6),

 col_datetime_6_not_null datetime(6) not null,

 col_datetime_0 datetime(0),

 col_datetime_2_key datetime(2),

 col_timestamp_6_not_null timestamp(6) not null,

 col_timestamp_1_not_null_key timestamp(1) not null,

 col_datetime_5_key datetime(5),

 col_datetime_4_not_null_key datetime(4) not null,

 col_time_6_not_null_key time(6) not null,

 col_time_2_key time(2),

 col_timestamp_not_null timestamp not null,

 col_timestamp_0_not_null timestamp(0) not null,

 col_time_2 time(2),

 col_time_1_key time(1),

 col_datetime_4 datetime(4),

 col_time_1_not_null_key time(1) not null,

 col_timestamp_5 timestamp(5),

 col_timestamp_1 timestamp(1),

 col_datetime_4_not_null datetime(4) not null,

 col_datetime_1 datetime(1),

 col_datetime_2_not_null_key datetime(2) not null,

 col_timestamp_not_null_key timestamp not null,

 col_time_3_not_null_key time(3) not null,

 col_timestamp_2_key timestamp(2),

 col_time_1_not_null time(1) not null,

 col_datetime_3_key datetime(3),

 col_datetime_5_not_null_key datetime(5) not null,

 col_timestamp timestamp,

 col_time_5_not_null_key time(5) not null,

 col_time time,

 col_datetime_1_not_null datetime(1) not null,

 col_time_3 time(3),

 col_timestamp_2 timestamp(2),

 col_time_5_not_null time(5) not null,

 col_time_4_not_null time(4) not null,

 col_timestamp_2_not_null timestamp(2) not null,

 col_datetime_0_key datetime(0),

 col_datetime_0_not_null datetime(0) not null,

 col_time_5 time(5),

 col_timestamp_4_not_null timestamp(4) not null,

 col_year year,

 col_time_2_not_null_key time(2) not null,

 col_datetime_1_key datetime(1),

 col_datetime_5_not_null datetime(5) not null,

 col_timestamp_0_not_null_key timestamp(0) not null,

 col_time_3_not_null time(3) not null,

 col_datetime_2_not_null datetime(2) not null,

 col_time_1 time(1),

 col_timestamp_key timestamp,

 col_datetime_6_not_null_key datetime(6) not null,

 col_time_4_not_null_key time(4) not null,

 col_datetime_3 datetime(3),

 col_datetime_1_not_null_key datetime(1) not null,

 col_datetime_2 datetime(2),

 col_timestamp_0 timestamp(0),

 col_time_0_key time(0),

 col_datetime_3_not_null datetime(3) not null,

 col_datetime_3_not_null_key datetime(3) not null,

 col_time_6_key time(6),

 col_timestamp_4_not_null_key timestamp(4) not null,

 col_time_0 time(0),

 col_time_2_not_null time(2) not null,

 col_datetime datetime,

 col_year_not_null year not null,

 pk timestamp(3),

 col_datetime_not_null_key datetime not null,

 col_datetime_not_null datetime not null,

 col_year_key year,

 col_time_0_not_null_key time(0) not null,

 col_datetime_4_key datetime(4),

 col_date_key date,

 col_datetime_6 datetime(6),

 col_time_not_null_key time not null,

 col_date date,

 col_datetime_0_not_null_key datetime(0) not null,

 col_time_0_not_null time(0) not null,

 col_time_5_key time(5),

 col_time_4 time(4),

 col_timestamp_1_not_null timestamp(1) not null,

 col_timestamp_6 timestamp(6),

 col_timestamp_1_key timestamp(1),

 primary key (pk),

 key (col_date_key ASC),

 key (col_time_5_key DESC),

 key (col_timestamp_1_key DESC)

) ENGINE=innodb;

CREATE TABLE t2 (

 col_time_key time,

 col_timestamp_3 timestamp(3),

 col_datetime_key datetime,

 col_datetime_5 datetime(5),

 col_time_6 time(6),

 col_timestamp_4 timestamp(4),

 col_timestamp_5_not_null timestamp(5) not null,

 col_timestamp_6_key timestamp(6),

 col_timestamp_5_not_null_key timestamp(5) not null,

 col_timestamp_4_key timestamp(4),

 col_timestamp_3_key timestamp(3),

 col_timestamp_3_not_null_key timestamp(3) not null,

 col_timestamp_5_key timestamp(5),

 col_time_4_key time(4),

 col_timestamp_6_not_null_key timestamp(6) not null,

 col_time_not_null time not null,

 col_timestamp_3_not_null timestamp(3) not null,

 col_timestamp_2_not_null_key timestamp(2) not null,

 col_date_not_null date not null,

 col_date_not_null_key date not null,

 col_timestamp_0_key timestamp(0),

 col_year_not_null_key year not null,

 col_time_6_not_null time(6) not null,

 col_time_3_key time(3),

 col_datetime_6_key datetime(6),

 col_datetime_6_not_null datetime(6) not null,

 col_datetime_0 datetime(0),

 col_datetime_2_key datetime(2),

 col_timestamp_6_not_null timestamp(6) not null,

 col_timestamp_1_not_null_key timestamp(1) not null,

 col_datetime_5_key datetime(5),

 col_datetime_4_not_null_key datetime(4) not null,

 col_time_6_not_null_key time(6) not null,

 col_time_2_key time(2),

 col_timestamp_not_null timestamp not null,

 col_timestamp_0_not_null timestamp(0) not null,

 col_time_2 time(2),

 col_time_1_key time(1),

 col_datetime_4 datetime(4),

 col_time_1_not_null_key time(1) not null,

 col_timestamp_5 timestamp(5),

 col_timestamp_1 timestamp(1),

 col_datetime_4_not_null datetime(4) not null,

 col_datetime_1 datetime(1),

 col_datetime_2_not_null_key datetime(2) not null,

 col_timestamp_not_null_key timestamp not null,

 col_time_3_not_null_key time(3) not null,

 col_timestamp_2_key timestamp(2),

 col_time_1_not_null time(1) not null,

 col_datetime_3_key datetime(3),

 col_datetime_5_not_null_key datetime(5) not null,

 col_timestamp timestamp,

 col_time_5_not_null_key time(5) not null,

 col_time time,

 col_datetime_1_not_null datetime(1) not null,

 col_time_3 time(3),

 col_timestamp_2 timestamp(2),

 col_time_5_not_null time(5) not null,

 col_time_4_not_null time(4) not null,

 col_timestamp_2_not_null timestamp(2) not null,

 col_datetime_0_key datetime(0),

 col_datetime_0_not_null datetime(0) not null,

 col_time_5 time(5),

 col_timestamp_4_not_null timestamp(4) not null,

 col_year year,

 col_time_2_not_null_key time(2) not null,

 col_datetime_1_key datetime(1),

 col_datetime_5_not_null datetime(5) not null,

 col_timestamp_0_not_null_key timestamp(0) not null,

 col_time_3_not_null time(3) not null,

 col_datetime_2_not_null datetime(2) not null,

 col_time_1 time(1),

 col_timestamp_key timestamp,

 col_datetime_6_not_null_key datetime(6) not null,

 col_time_4_not_null_key time(4) not null,

 col_datetime_3 datetime(3),

 col_datetime_1_not_null_key datetime(1) not null,

 col_datetime_2 datetime(2),

 col_timestamp_0 timestamp(0),

 col_time_0_key time(0),

 col_datetime_3_not_null datetime(3) not null,

 col_datetime_3_not_null_key datetime(3) not null,

 col_time_6_key time(6),

 col_timestamp_4_not_null_key timestamp(4) not null,

 col_time_0 time(0),

 col_time_2_not_null time(2) not null,

 col_datetime datetime,

 col_year_not_null year not null,

 pk timestamp(3),

 col_datetime_not_null_key datetime not null,

 col_datetime_not_null datetime not null,

 col_year_key year,

 col_time_0_not_null_key time(0) not null,

 col_datetime_4_key datetime(4),

 col_date_key date,

 col_datetime_6 datetime(6),

 col_time_not_null_key time not null,

 col_date date,

 col_datetime_0_not_null_key datetime(0) not null,

 col_time_0_not_null time(0) not null,

 col_time_5_key time(5),

 col_time_4 time(4),

 col_timestamp_1_not_null timestamp(1) not null,

 col_timestamp_6 timestamp(6),

 col_timestamp_1_key timestamp(1),

 /*Indices*/

 key (col_time_key ASC),

 key (col_datetime_key DESC),

 key (col_timestamp_6_key ASC),

 key (col_timestamp_5_not_null_key DESC),

 key (col_timestamp_4_key),

 key (col_timestamp_3_key DESC),

 key (col_timestamp_3_not_null_key DESC),

 key (col_timestamp_5_key ASC),

 key (col_time_4_key ASC),

 key (col_timestamp_6_not_null_key),

 key (col_timestamp_2_not_null_key DESC),

 key (col_date_not_null_key ASC),

 key (col_timestamp_0_key DESC),

 key (col_year_not_null_key ASC),

 key (col_time_3_key),

 key (col_datetime_6_key DESC),

 key (col_datetime_2_key ASC),

 key (col_timestamp_1_not_null_key),

 key (col_datetime_5_key ASC),

 key (col_datetime_4_not_null_key DESC),

 key (col_time_6_not_null_key),

 key (col_time_2_key),

 key (col_time_1_key DESC),

 key (col_time_1_not_null_key DESC),

 key (col_datetime_2_not_null_key DESC),

 key (col_timestamp_not_null_key DESC),

 key (col_time_3_not_null_key),

 key (col_timestamp_2_key DESC),

 key (col_datetime_3_key DESC),

 key (col_datetime_5_not_null_key DESC),

 key (col_time_5_not_null_key DESC),

 key (col_datetime_0_key DESC),

 key (col_time_2_not_null_key ASC),

 key (col_datetime_1_key),

 key (col_timestamp_0_not_null_key DESC),

 key (col_timestamp_key),

 key (col_datetime_6_not_null_key),

 key (col_time_4_not_null_key),

 key (col_datetime_1_not_null_key DESC),

 key (col_time_0_key ASC),

 key (col_datetime_3_not_null_key ASC),

 key (col_time_6_key ASC),

 key (col_timestamp_4_not_null_key),

 primary key (pk),

 key (col_datetime_not_null_key DESC),

 key (col_year_key ASC),

 key (col_time_0_not_null_key DESC),

 key (col_datetime_4_key DESC),

 key (col_date_key ASC),

 key (col_time_not_null_key DESC),

 key (col_datetime_0_not_null_key DESC),

 key (col_time_5_key DESC),

 key (col_timestamp_1_key DESC)) ENGINE=innodb;

CREATE TABLE t3 (

 col_time_2_not_null time(2) not null,

 col_timestamp_5_not_null timestamp(5) not null,

 col_time_3_key time(3),

 col_timestamp_2_key timestamp(2),

 col_datetime_2 datetime(2),

 col_datetime_0_key datetime(0),

 col_time_5_not_null_key time(5) not null,

 col_time_2_not_null_key time(2) not null,

 col_datetime_1_key datetime(1),

 col_timestamp_1_key timestamp(1),

 col_time_4_key time(4),

 col_datetime_5_not_null datetime(5) not null,

 col_timestamp_4 timestamp(4),

 col_timestamp_0_not_null_key timestamp(0) not null,

 col_datetime_2_key datetime(2),

 col_datetime_5_key datetime(5),

 col_datetime_6_not_null datetime(6) not null,

 col_time_0_key time(0),

 col_timestamp_2_not_null_key timestamp(2) not null,

 col_date_key date,

 col_datetime_6_key datetime(6),

 col_time_key time,

 col_timestamp_5 timestamp(5),

 col_datetime_0_not_null_key datetime(0) not null,

 col_timestamp_0 timestamp(0),

 col_timestamp_4_not_null timestamp(4) not null,

 col_datetime_3_not_null datetime(3) not null,

 col_time_1_not_null_key time(1) not null,

 col_datetime_not_null datetime not null,

 col_timestamp_key timestamp,

 col_time_1_not_null time(1) not null,

 col_timestamp_4_not_null_key timestamp(4) not null,

 col_datetime_4_key datetime(4),

 pk timestamp(6),

 col_timestamp_6_not_null_key timestamp(6) not null,

 col_timestamp_1_not_null_key timestamp(1) not null,

 col_datetime_1_not_null datetime(1) not null,

 col_timestamp_5_key timestamp(5),

 col_datetime_5 datetime(5),

 col_datetime_key datetime,

 col_timestamp_not_null timestamp not null,

 col_timestamp_6_not_null timestamp(6) not null,

 col_time_5_key time(5),

 col_datetime_1 datetime(1),

 col_datetime_not_null_key datetime not null,

 col_timestamp_6 timestamp(6),

 col_time_0_not_null time(0) not null,

 col_time_2_key time(2),

 col_timestamp_0_not_null timestamp(0) not null,

 col_time_6_key time(6),

 col_time_5 time(5),

 col_year_not_null_key year not null,

 col_datetime_0_not_null datetime(0) not null,

 col_time_3_not_null_key time(3) not null,

 col_datetime_2_not_null datetime(2) not null,

 col_datetime_4_not_null datetime(4) not null,

 col_time_4 time(4),

 col_time_1 time(1),

 col_time_3 time(3),

 col_timestamp_not_null_key timestamp not null,

 col_datetime_0 datetime(0),

 col_date date,

 col_timestamp_1 timestamp(1),

 col_time_1_key time(1),

 col_time_3_not_null time(3) not null,

 col_time_6_not_null time(6) not null,

 col_year year,

 col_datetime_6 datetime(6),

 col_time_5_not_null time(5) not null,

 col_time_6_not_null_key time(6) not null,

 col_datetime_1_not_null_key datetime(1) not null,

 col_time_not_null_key time not null,

 col_datetime_3 datetime(3),

 col_timestamp_2 timestamp(2),

 col_datetime_3_not_null_key datetime(3) not null,

 col_timestamp_0_key timestamp(0),

 col_datetime_6_not_null_key datetime(6) not null,

 col_timestamp_4_key timestamp(4),

 col_time_6 time(6),

 col_time_2 time(2),

 col_time_4_not_null time(4) not null,

 col_time_not_null time not null,

 col_datetime_2_not_null_key datetime(2) not null,

 col_datetime datetime,

 col_time_0 time(0),

 col_timestamp_1_not_null timestamp(1) not null,

 col_timestamp_3_not_null timestamp(3) not null,

 col_timestamp timestamp,

 col_time time,

 col_date_not_null date not null,

 col_datetime_4 datetime(4),

 col_datetime_4_not_null_key datetime(4) not null,

 col_datetime_5_not_null_key datetime(5) not null,

 col_year_not_null year not null,

 col_timestamp_5_not_null_key timestamp(5) not null,

 col_time_4_not_null_key time(4) not null,

 col_timestamp_3_key timestamp(3),

 col_timestamp_3_not_null_key timestamp(3) not null,

 col_date_not_null_key date not null,

 col_timestamp_3 timestamp(3),

 col_year_key year,

 col_timestamp_2_not_null timestamp(2) not null,

 col_datetime_3_key datetime(3),

 col_time_0_not_null_key time(0) not null,

 col_timestamp_6_key timestamp(6),

 /*Indices*/

 key (col_time_3_key),

 key (col_timestamp_2_key DESC),

 key (col_datetime_0_key DESC),

 key (col_time_5_not_null_key DESC),

 key (col_time_2_not_null_key ASC),

 key (col_datetime_1_key),

 key (col_timestamp_1_key DESC),

 key (col_time_4_key ASC),

 key (col_timestamp_0_not_null_key DESC),

 key (col_datetime_2_key ASC),

 key (col_datetime_5_key ASC),

 key (col_time_0_key ASC),

 key (col_timestamp_2_not_null_key DESC),

 key (col_date_key ASC),

 key (col_datetime_6_key DESC),

 key (col_time_key ASC),

 key (col_datetime_0_not_null_key DESC),

 key (col_time_1_not_null_key DESC),

 key (col_timestamp_key),

 key (col_timestamp_4_not_null_key),

 key (col_datetime_4_key DESC),

 primary key (pk DESC),

 key (col_timestamp_6_not_null_key),

 key (col_timestamp_1_not_null_key),

 key (col_timestamp_5_key ASC),

 key (col_datetime_key DESC),

 key (col_time_5_key DESC),

 key (col_datetime_not_null_key DESC),

 key (col_time_2_key),

 key (col_time_6_key ASC),

 key (col_year_not_null_key ASC),

 key (col_time_3_not_null_key),

 key (col_timestamp_not_null_key DESC),

 key (col_time_1_key DESC),

 key (col_time_6_not_null_key),

 key (col_datetime_1_not_null_key DESC),

 key (col_time_not_null_key DESC),

 key (col_datetime_3_not_null_key ASC),

 key (col_timestamp_0_key DESC),

 key (col_datetime_6_not_null_key),

 key (col_timestamp_4_key),

 key (col_datetime_2_not_null_key DESC),

 key (col_datetime_4_not_null_key DESC),

 key (col_datetime_5_not_null_key DESC),

 key (col_timestamp_5_not_null_key DESC),

 key (col_time_4_not_null_key),

 key (col_timestamp_3_key DESC),

 key (col_timestamp_3_not_null_key DESC),

 key (col_date_not_null_key ASC),

 key (col_year_key ASC),

 key (col_datetime_3_key DESC),

 key (col_time_0_not_null_key DESC),

 key (col_timestamp_6_key ASC)) ENGINE=innodb;

 CREATE TABLE t4 (

 col_time_2_not_null time(2) not null,

 col_timestamp_5_not_null timestamp(5) not null,

 col_time_3_key time(3),

 col_timestamp_2_key timestamp(2),

 col_datetime_2 datetime(2),

 col_datetime_0_key datetime(0),

 col_time_5_not_null_key time(5) not null,

 col_time_2_not_null_key time(2) not null,

 col_datetime_1_key datetime(1),

 col_timestamp_1_key timestamp(1),

 col_time_4_key time(4),

 col_datetime_5_not_null datetime(5) not null,

 col_timestamp_4 timestamp(4),

 col_timestamp_0_not_null_key timestamp(0) not null,

 col_datetime_2_key datetime(2),

 col_datetime_5_key datetime(5),

 col_datetime_6_not_null datetime(6) not null,

 col_time_0_key time(0),

 col_timestamp_2_not_null_key timestamp(2) not null,

 col_date_key date,

 col_datetime_6_key datetime(6),

 col_time_key time,

 col_timestamp_5 timestamp(5),

 col_datetime_0_not_null_key datetime(0) not null,

 col_timestamp_0 timestamp(0),

 col_timestamp_4_not_null timestamp(4) not null,

 col_datetime_3_not_null datetime(3) not null,

 col_time_1_not_null_key time(1) not null,

 col_datetime_not_null datetime not null,

 col_timestamp_key timestamp,

 col_time_1_not_null time(1) not null,

 col_timestamp_4_not_null_key timestamp(4) not null,

 col_datetime_4_key datetime(4),

 pk timestamp(6),

 col_timestamp_6_not_null_key timestamp(6) not null,

 col_timestamp_1_not_null_key timestamp(1) not null,

 col_datetime_1_not_null datetime(1) not null,

 col_timestamp_5_key timestamp(5),

 col_datetime_5 datetime(5),

 col_datetime_key datetime,

 col_timestamp_not_null timestamp not null,

 col_timestamp_6_not_null timestamp(6) not null,

 col_time_5_key time(5),

 col_datetime_1 datetime(1),

 col_datetime_not_null_key datetime not null,

 col_timestamp_6 timestamp(6),

 col_time_0_not_null time(0) not null,

 col_time_2_key time(2),

 col_timestamp_0_not_null timestamp(0) not null,

 col_time_6_key time(6),

 col_time_5 time(5),

 col_year_not_null_key year not null,

 col_datetime_0_not_null datetime(0) not null,

 col_time_3_not_null_key time(3) not null,

 col_datetime_2_not_null datetime(2) not null,

 col_datetime_4_not_null datetime(4) not null,

 col_time_4 time(4),

 col_time_1 time(1),

 col_time_3 time(3),

 col_timestamp_not_null_key timestamp not null,

 col_datetime_0 datetime(0),

 col_date date,

 col_timestamp_1 timestamp(1),

 col_time_1_key time(1),

 col_time_3_not_null time(3) not null,

 col_time_6_not_null time(6) not null,

 col_year year,

 col_datetime_6 datetime(6),

 col_time_5_not_null time(5) not null,

 col_time_6_not_null_key time(6) not null,

 col_datetime_1_not_null_key datetime(1) not null,

 col_time_not_null_key time not null,

 col_datetime_3 datetime(3),

 col_timestamp_2 timestamp(2),

 col_datetime_3_not_null_key datetime(3) not null,

 col_timestamp_0_key timestamp(0),

 col_datetime_6_not_null_key datetime(6) not null,

 col_timestamp_4_key timestamp(4),

 col_time_6 time(6),

 col_time_2 time(2),

 col_time_4_not_null time(4) not null,

 col_time_not_null time not null,

 col_datetime_2_not_null_key datetime(2) not null,

 col_datetime datetime,

 col_time_0 time(0),

 col_timestamp_1_not_null timestamp(1) not null,

 col_timestamp_3_not_null timestamp(3) not null,

 col_timestamp timestamp,

 col_time time,

 col_date_not_null date not null,

 col_datetime_4 datetime(4),

 col_datetime_4_not_null_key datetime(4) not null,

 col_datetime_5_not_null_key datetime(5) not null,

 col_year_not_null year not null,

 col_timestamp_5_not_null_key timestamp(5) not null,

 col_time_4_not_null_key time(4) not null,

 col_timestamp_3_key timestamp(3),

 col_timestamp_3_not_null_key timestamp(3) not null,

 col_date_not_null_key date not null,

 col_timestamp_3 timestamp(3),

 col_year_key year,

 col_timestamp_2_not_null timestamp(2) not null,

 col_datetime_3_key datetime(3),

 col_time_0_not_null_key time(0) not null,

 col_timestamp_6_key timestamp(6),

 /*Indices*/

 key (col_time_3_key),

 key (col_timestamp_2_key DESC),

 key (col_datetime_0_key DESC),

 key (col_time_5_not_null_key DESC),

 key (col_time_2_not_null_key ASC),

 key (col_datetime_1_key),

 key (col_timestamp_1_key DESC),

 key (col_time_4_key ASC),

 key (col_timestamp_0_not_null_key DESC),

 key (col_datetime_2_key ASC),

 key (col_datetime_5_key ASC),

 key (col_time_0_key ASC),

 key (col_timestamp_2_not_null_key DESC),

 key (col_date_key ASC),

 key (col_datetime_6_key DESC),

 key (col_time_key ASC),

 key (col_datetime_0_not_null_key DESC),

 key (col_time_1_not_null_key DESC),

 key (col_timestamp_key),

 key (col_timestamp_4_not_null_key),

 key (col_datetime_4_key DESC),

 primary key (pk DESC),

 key (col_timestamp_6_not_null_key),

 key (col_timestamp_1_not_null_key),

 key (col_timestamp_5_key ASC),

 key (col_datetime_key DESC),

 key (col_time_5_key DESC),

 key (col_datetime_not_null_key DESC),

 key (col_time_2_key),

 key (col_time_6_key ASC),

 key (col_year_not_null_key ASC),

 key (col_time_3_not_null_key),

 key (col_timestamp_not_null_key DESC),

 key (col_time_1_key DESC),

 key (col_time_6_not_null_key),

 key (col_datetime_1_not_null_key DESC),

 key (col_time_not_null_key DESC),

 key (col_datetime_3_not_null_key ASC),

 key (col_timestamp_0_key DESC),

 key (col_datetime_6_not_null_key),

 key (col_timestamp_4_key),

 key (col_datetime_2_not_null_key DESC),

 key (col_datetime_4_not_null_key DESC),

 key (col_datetime_5_not_null_key DESC),

 key (col_timestamp_5_not_null_key DESC),

 key (col_time_4_not_null_key),

 key (col_timestamp_3_key DESC),

 key (col_timestamp_3_not_null_key DESC),

 key (col_date_not_null_key ASC),

 key (col_year_key ASC),

 key (col_datetime_3_key DESC),

 key (col_time_0_not_null_key DESC),

 key (col_timestamp_6_key ASC)) ENGINE=innodb;

CREATE TABLE t7 (

 col_datetime_5_not_null_key datetime(5) not null,

 col_timestamp_4_not_null timestamp(4) not null,

 col_timestamp_6_not_null timestamp(6) not null,

 col_timestamp_not_null_key timestamp not null,

 col_datetime_0_key datetime(0),

 col_timestamp_5_not_null timestamp(5) not null,

 col_time_2 time(2),

 col_timestamp_3_not_null_key timestamp(3) not null,

 col_time_5_not_null_key time(5) not null,

 col_time_3_key time(3),

 col_time time,

 col_timestamp_1 timestamp(1),

 col_datetime_6_key datetime(6),

 col_time_3_not_null time(3) not null,

 col_timestamp timestamp,

 col_datetime_2_not_null_key datetime(2) not null,

 col_datetime datetime,

 col_year_not_null year not null,

 col_datetime_3_key datetime(3),

 col_time_6_key time(6),

 col_timestamp_not_null timestamp not null,

 col_timestamp_4_not_null_key timestamp(4) not null,

 col_timestamp_4_key timestamp(4),

 col_time_1_key time(1),

 col_timestamp_1_not_null timestamp(1) not null,

 col_timestamp_6_not_null_key timestamp(6) not null,

 col_timestamp_5_key timestamp(5),

 col_datetime_4_key datetime(4),

 col_time_6 time(6),

 col_timestamp_0_key timestamp(0),

 col_timestamp_3 timestamp(3),

 col_datetime_1_not_null_key datetime(1) not null,

 col_time_1 time(1),

 col_date_key date,

 col_timestamp_3_key timestamp(3),

 col_datetime_2_not_null datetime(2) not null,

 col_time_4_not_null time(4) not null,

 col_timestamp_1_key timestamp(1),

 col_year_key year,

 col_year_not_null_key year not null,

 col_date date,

 col_time_3 time(3),

 col_datetime_1_key datetime(1),

 col_time_5 time(5),

 col_datetime_key datetime,

 col_datetime_3_not_null_key datetime(3) not null,

 col_year year,

 col_datetime_2 datetime(2),

 col_datetime_6 datetime(6),

 col_timestamp_2_key timestamp(2),

 col_datetime_3_not_null datetime(3) not null,

 col_time_2_not_null_key time(2) not null,

 col_time_not_null time not null,

 col_timestamp_6 timestamp(6),

 col_datetime_1 datetime(1),

 col_datetime_6_not_null datetime(6) not null,

 col_datetime_0_not_null_key datetime(0) not null,

 col_date_not_null_key date not null,

 col_time_2_key time(2),

 col_time_5_not_null time(5) not null,

 col_datetime_5_key datetime(5),

 col_datetime_0 datetime(0),

 col_datetime_2_key datetime(2),

 col_timestamp_0_not_null timestamp(0) not null,

 col_time_2_not_null time(2) not null,

 col_date_not_null date not null,

 col_datetime_6_not_null_key datetime(6) not null,

 col_timestamp_0 timestamp(0),

 col_datetime_3 datetime(3),

 col_datetime_0_not_null datetime(0) not null,

 col_datetime_1_not_null datetime(1) not null,

 pk year,

 col_datetime_5 datetime(5),

 col_time_3_not_null_key time(3) not null,

 col_datetime_not_null datetime not null,

 col_timestamp_6_key timestamp(6),

 col_timestamp_key timestamp,

 col_timestamp_1_not_null_key timestamp(1) not null,

 col_time_not_null_key time not null,

 col_timestamp_2_not_null timestamp(2) not null,

 col_timestamp_2_not_null_key timestamp(2) not null,

 col_time_0_not_null_key time(0) not null,

 col_datetime_not_null_key datetime not null,

 col_datetime_4_not_null_key datetime(4) not null,

 col_time_1_not_null_key time(1) not null,

 col_time_0_key time(0),

 col_time_0 time(0),

 col_datetime_5_not_null datetime(5) not null,

 col_timestamp_5 timestamp(5),

 col_time_4 time(4),

 col_time_4_key time(4),

 col_timestamp_5_not_null_key timestamp(5) not null,

 col_timestamp_2 timestamp(2),

 col_datetime_4_not_null datetime(4) not null,

 col_time_1_not_null time(1) not null,

 col_time_5_key time(5),

 col_time_key time,

 col_time_6_not_null time(6) not null,

 col_time_6_not_null_key time(6) not null,

 col_time_4_not_null_key time(4) not null,

 col_timestamp_0_not_null_key timestamp(0) not null,

 col_datetime_4 datetime(4),

 col_timestamp_4 timestamp(4),

 col_timestamp_3_not_null timestamp(3) not null,

 col_time_0_not_null time(0) not null,

 /*Indices*/

 key (col_datetime_5_not_null_key DESC),

 key (col_timestamp_not_null_key DESC),

 key (col_datetime_0_key DESC),

 key (col_timestamp_3_not_null_key DESC),

 key (col_time_5_not_null_key DESC),

 key (col_time_3_key),

 key (col_datetime_6_key DESC),

 key (col_datetime_2_not_null_key DESC),

 key (col_datetime_3_key DESC),

 key (col_time_6_key ASC),

 key (col_timestamp_4_not_null_key),

 key (col_timestamp_4_key),

 key (col_time_1_key DESC),

 key (col_timestamp_6_not_null_key),

 key (col_timestamp_5_key ASC),

 key (col_datetime_4_key DESC),

 key (col_timestamp_0_key DESC),

 key (col_datetime_1_not_null_key DESC),

 key (col_date_key ASC),

 key (col_timestamp_3_key DESC),

 key (col_timestamp_1_key DESC),

 key (col_year_key ASC),

 key (col_year_not_null_key ASC),

 key (col_datetime_1_key),

 key (col_datetime_key DESC),

 key (col_datetime_3_not_null_key ASC),

 key (col_timestamp_2_key DESC),

 key (col_time_2_not_null_key ASC),

 key (col_datetime_0_not_null_key DESC),

 key (col_date_not_null_key ASC),

 key (col_time_2_key),

 key (col_datetime_5_key ASC),

 key (col_datetime_2_key ASC),

 key (col_datetime_6_not_null_key),

 primary key (pk DESC),

 key (col_time_3_not_null_key),

 key (col_timestamp_6_key ASC),

 key (col_timestamp_key),

 key (col_timestamp_1_not_null_key),

 key (col_time_not_null_key DESC),

 key (col_timestamp_2_not_null_key DESC),

 key (col_time_0_not_null_key DESC),

 key (col_datetime_not_null_key DESC),

 key (col_datetime_4_not_null_key DESC),

 key (col_time_1_not_null_key DESC),

 key (col_time_0_key ASC),

 key (col_time_4_key ASC),

 key (col_timestamp_5_not_null_key DESC),

 key (col_time_5_key DESC),

 key (col_time_key ASC),

 key (col_time_6_not_null_key),

 key (col_time_4_not_null_key),

 key (col_timestamp_0_not_null_key DESC)) ENGINE=innodb;

CREATE TABLE t5 (

 col_datetime_5_not_null datetime(5) not null,

 col_date_key date,

 col_datetime_4_not_null_key datetime(4) not null,

 col_date_not_null_key date not null,

 col_year_key year,

 col_time_6_key time(6),

 col_date date,

 col_time_2_key time(2),

 col_time_1_key time(1),

 col_timestamp_2_not_null timestamp(2) not null,

 col_datetime_6_not_null datetime(6) not null,

 col_datetime_5 datetime(5),

 col_timestamp_3_not_null timestamp(3) not null,

 col_datetime_6_key datetime(6),

 col_timestamp_3_key timestamp(3),

 col_time_4_not_null_key time(4) not null,

 col_datetime_3_not_null datetime(3) not null,

 col_timestamp_6_not_null timestamp(6) not null,

 col_time_5_not_null_key time(5) not null,

 col_timestamp_2_not_null_key timestamp(2) not null,

 col_time_5 time(5),

 col_datetime_not_null datetime not null,

 col_time_5_not_null time(5) not null,

 col_timestamp_0_not_null timestamp(0) not null,

 col_timestamp_1 timestamp(1),

 col_time_6_not_null_key time(6) not null,

 col_datetime_2_not_null datetime(2) not null,

 col_timestamp_0 timestamp(0),

 col_datetime_5_not_null_key datetime(5) not null,

 col_datetime_1_not_null datetime(1) not null,

 col_timestamp_1_not_null timestamp(1) not null,

 col_timestamp_6_not_null_key timestamp(6) not null,

 col_time_6_not_null time(6) not null,

 col_timestamp_1_key timestamp(1),

 col_date_not_null date not null,

 col_datetime_3_key datetime(3),

 col_datetime_1_not_null_key datetime(1) not null,

 col_time_key time,

 col_datetime_0_not_null datetime(0) not null,

 col_datetime_4_key datetime(4),

 col_time_6 time(6),

 col_datetime_0_key datetime(0),

 col_timestamp_5_not_null_key timestamp(5) not null,

 col_year year,

 col_time_2_not_null_key time(2) not null,

 col_datetime_2_not_null_key datetime(2) not null,

 col_time_1_not_null time(1) not null,

 col_timestamp_key timestamp,

 col_timestamp_not_null timestamp not null,

 col_datetime_key datetime,

 col_timestamp_4_not_null_key timestamp(4) not null,

 col_datetime_4_not_null datetime(4) not null,

 col_time_2_not_null time(2) not null,

 col_time_1 time(1),

 col_timestamp_3_not_null_key timestamp(3) not null,

 col_datetime_5_key datetime(5),

 col_datetime_6 datetime(6),

 col_year_not_null_key year not null,

 col_time_4_key time(4),

 col_datetime_0_not_null_key datetime(0) not null,

 col_time_4 time(4),

 col_timestamp_4_key timestamp(4),

 col_timestamp_5_not_null timestamp(5) not null,

 col_time_2 time(2),

 col_time_0 time(0),

 col_datetime_6_not_null_key datetime(6) not null,

 col_datetime_2_key datetime(2),

 col_time_not_null time not null,

 col_datetime_4 datetime(4),

 col_timestamp_6_key timestamp(6),

 col_time_1_not_null_key time(1) not null,

 col_datetime_2 datetime(2),

 pk time(0),

 col_datetime_1_key datetime(1),

 col_year_not_null year not null,

 col_timestamp_0_key timestamp(0),

 col_time_5_key time(5),

 col_datetime_3 datetime(3),

 col_timestamp_1_not_null_key timestamp(1) not null,

 col_time_3 time(3),

 col_time_0_not_null time(0) not null,

 col_timestamp_4_not_null timestamp(4) not null,

 col_timestamp timestamp,

 col_datetime_0 datetime(0),

 col_timestamp_2 timestamp(2),

 col_datetime datetime,

 col_time_0_not_null_key time(0) not null,

 col_timestamp_4 timestamp(4),

 col_time_4_not_null time(4) not null,

 col_time_0_key time(0),

 col_datetime_not_null_key datetime not null,

 col_time_3_not_null time(3) not null,

 col_timestamp_not_null_key timestamp not null,

 col_timestamp_6 timestamp(6),

 col_timestamp_2_key timestamp(2),

 col_timestamp_0_not_null_key timestamp(0) not null,

 col_time_3_not_null_key time(3) not null,

 col_timestamp_3 timestamp(3),

 col_timestamp_5 timestamp(5),

 col_datetime_1 datetime(1),

 col_time time,

 col_datetime_3_not_null_key datetime(3) not null,

 col_time_not_null_key time not null,

 col_timestamp_5_key timestamp(5),

 col_time_3_key time(3),

 /*Indices*/

 key (col_date_key ASC),

 key (col_datetime_4_not_null_key DESC),

 key (col_date_not_null_key ASC),

 key (col_year_key ASC),

 key (col_time_6_key ASC),

 key (col_time_2_key),

 key (col_time_1_key DESC),

 key (col_datetime_6_key DESC),

 key (col_timestamp_3_key DESC),

 key (col_time_4_not_null_key),

 key (col_time_5_not_null_key DESC),

 key (col_timestamp_2_not_null_key DESC),

 key (col_time_6_not_null_key),

 key (col_datetime_5_not_null_key DESC),

 key (col_timestamp_6_not_null_key),

 key (col_timestamp_1_key DESC),

 key (col_datetime_3_key DESC),

 key (col_datetime_1_not_null_key DESC),

 key (col_time_key ASC),

 key (col_datetime_4_key DESC),

 key (col_datetime_0_key DESC),

 key (col_timestamp_5_not_null_key DESC),

 key (col_time_2_not_null_key ASC),

 key (col_datetime_2_not_null_key DESC),

 key (col_timestamp_key),

 key (col_datetime_key DESC),

 key (col_timestamp_4_not_null_key),

 key (col_timestamp_3_not_null_key DESC),

 key (col_datetime_5_key ASC),

 key (col_year_not_null_key ASC),

 key (col_time_4_key ASC),

 key (col_datetime_0_not_null_key DESC),

 key (col_timestamp_4_key),

 key (col_datetime_6_not_null_key),

 key (col_datetime_2_key ASC),

 key (col_timestamp_6_key ASC),

 key (col_time_1_not_null_key DESC),

 primary key (pk DESC),

 key (col_datetime_1_key),

 key (col_timestamp_0_key DESC),

 key (col_time_5_key DESC),

 key (col_timestamp_1_not_null_key),

 key (col_time_0_not_null_key DESC),

 key (col_time_0_key ASC),

 key (col_datetime_not_null_key DESC),

 key (col_timestamp_not_null_key DESC),

 key (col_timestamp_2_key DESC),

 key (col_timestamp_0_not_null_key DESC),

 key (col_time_3_not_null_key),

 key (col_datetime_3_not_null_key ASC),

 key (col_time_not_null_key DESC),

 key (col_timestamp_5_key ASC),

 key (col_time_3_key)) ENGINE=innodb;

CREATE TABLE t6 (

 col_time_6_key time(6),

 col_datetime_key datetime,

 col_time_0 time(0),

 col_datetime_5_not_null_key datetime(5) not null,

 col_time_key time,

 col_time_3_not_null time(3) not null,

 col_timestamp_3 timestamp(3),

 col_datetime_0_not_null datetime(0) not null,

 col_datetime_3_not_null datetime(3) not null,

 col_time_6 time(6),

 col_time_0_key time(0),

 col_datetime_0_not_null_key datetime(0) not null,

 col_datetime_3_not_null_key datetime(3) not null,

 col_timestamp_1 timestamp(1),

 col_date_not_null_key date not null,

 col_timestamp_6_not_null_key timestamp(6) not null,

 col_timestamp_5_key timestamp(5),

 col_datetime_1_key datetime(1),

 col_timestamp_0_not_null_key timestamp(0) not null,

 col_time_0_not_null_key time(0) not null,

 col_datetime_1 datetime(1),

 col_datetime_5_key datetime(5),

 col_datetime_6_not_null_key datetime(6) not null,

 col_datetime_2 datetime(2),

 col_year_not_null_key year not null,

 col_time_2_key time(2),

 col_datetime_3 datetime(3),

 col_time_6_not_null time(6) not null,

 col_datetime_not_null_key datetime not null,

 col_timestamp_0_key timestamp(0),

 col_time_5_key time(5),

 col_timestamp_3_key timestamp(3),

 col_time_4 time(4),

 col_timestamp_2_not_null_key timestamp(2) not null,

 col_time_4_key time(4),

 col_timestamp_not_null_key timestamp not null,

 col_datetime_6_not_null datetime(6) not null,

 pk time(4),

 col_time_6_not_null_key time(6) not null,

 col_timestamp_2 timestamp(2),

 col_datetime datetime,

 col_datetime_2_not_null datetime(2) not null,

 col_time_4_not_null_key time(4) not null,

 col_time_2_not_null_key time(2) not null,

 col_datetime_1_not_null_key datetime(1) not null,

 col_datetime_6 datetime(6),

 col_datetime_1_not_null datetime(1) not null,

 col_year year,

 col_timestamp_not_null timestamp not null,

 col_datetime_0 datetime(0),

 col_timestamp_3_not_null timestamp(3) not null,

 col_time_1_not_null time(1) not null,

 col_time_3_not_null_key time(3) not null,

 col_date_not_null date not null,

 col_time_1_not_null_key time(1) not null,

 col_datetime_4_not_null datetime(4) not null,

 col_time_1 time(1),

 col_timestamp_4 timestamp(4),

 col_datetime_2_not_null_key datetime(2) not null,

 col_datetime_2_key datetime(2),

 col_datetime_5_not_null datetime(5) not null,

 col_year_key year,

 col_time_5 time(5),

 col_time time,

 col_time_5_not_null time(5) not null,

 col_time_3_key time(3),

 col_time_2 time(2),

 col_time_not_null_key time not null,

 col_datetime_0_key datetime(0),

 col_timestamp_5_not_null timestamp(5) not null,

 col_time_1_key time(1),

 col_datetime_4_not_null_key datetime(4) not null,

 col_timestamp_2_not_null timestamp(2) not null,

 col_timestamp_2_key timestamp(2),

 col_time_4_not_null time(4) not null,