do 1 not in (year(from_unixtime(1)),1); [sbester@levovo mysql-5.6.2-m5-linux-x86_64]$ valgrind -v --show-reachable=no --db-attach=yes --track-origins=yes --leak-check=full --tool=memcheck --num-callers=50 ./bin/mysqld --no-defaults --basedir=. --datadir=./data --skip-gr --myisam-recover=force --open-files-limit=2000 --port=3306 --socket=/tmp/mysql.sock --tmpdir=. --gdb --skip-na ==10767== Memcheck, a memory error detector ==10767== Copyright (C) 2002-2009, and GNU GPL'd, by Julian Seward et al. ==10767== Using Valgrind-3.5.0 and LibVEX; rerun with -h for copyright info ==10767== Command: ./bin/mysqld --no-defaults --basedir=. --datadir=./data --skip-gr --myisam-recover=force --open-files-limit=2000 --port=3306 --socket=/tmp/mysql.sock --tmpdir=. --gdb --skip-na ==10767== --10767-- Valgrind options: --10767-- -v --10767-- --show-reachable=no --10767-- --db-attach=yes --10767-- --track-origins=yes --10767-- --leak-check=full --10767-- --tool=memcheck --10767-- --num-callers=50 --10767-- Contents of /proc/version: --10767-- Linux version 2.6.33.3-85.fc13.x86_64 (mockbuild@x86-02.phx2.fedoraproject.org) (gcc version 4.4.4 20100503 (Red Hat 4.4.4-2) (GCC) ) #1 SMP Thu May 6 18:09:49 UTC 2010 --10767-- Arch and hwcaps: AMD64, amd64-sse3-cx16 --10767-- Page sizes: currently 4096, max supported 4096 --10767-- Valgrind library directory: /usr/lib64/valgrind --10767-- Reading syms from /home/sbester/mysql/5.6/mysql-5.6.2-m5-linux-x86_64/bin/mysqld (0x400000) --10767-- Reading syms from /usr/lib64/valgrind/memcheck-amd64-linux (0x38000000) --10767-- object doesn't have a dynamic symbol table --10767-- Reading syms from /lib64/ld-2.12.so (0x30e1000000) --10767-- Reading debug info from /usr/lib/debug/lib64/ld-2.12.so.debug .. --10767-- Reading suppressions file: /usr/lib64/valgrind/default.supp --10767-- REDIR: 0x30e1017590 (strlen) redirected to 0x3803f6f7 (vgPlain_amd64_linux_REDIR_FOR_strlen) --10767-- Reading syms from /usr/lib64/valgrind/vgpreload_core-amd64-linux.so (0x4801000) --10767-- Reading syms from /usr/lib64/valgrind/vgpreload_memcheck-amd64-linux.so (0x4a02000) ==10767== WARNING: new redirection conflicts with existing -- ignoring it --10767-- new: 0x30e1017590 (strlen ) R-> 0x04a06340 strlen --10767-- REDIR: 0x30e1017400 (index) redirected to 0x4a05f80 (index) --10767-- REDIR: 0x30e1017480 (strcmp) redirected to 0x4a06900 (strcmp) --10767-- Reading syms from /lib64/libpthread-2.12.so (0x30e1800000) --10767-- Reading debug info from /usr/lib/debug/lib64/libpthread-2.12.so.debug .. --10767-- Reading syms from /lib64/libz.so.1.2.3 (0x30e2400000) --10767-- Reading debug info from /usr/lib/debug/lib64/libz.so.1.2.3.debug .. --10767-- Reading syms from /lib64/libm-2.12.so (0x30e1c00000) --10767-- Reading debug info from /usr/lib/debug/lib64/libm-2.12.so.debug .. --10767-- Reading syms from /lib64/librt-2.12.so (0x30e2800000) --10767-- Reading debug info from /usr/lib/debug/lib64/librt-2.12.so.debug .. --10767-- Reading syms from /lib64/libcrypt-2.12.so (0x33b8200000) --10767-- Reading debug info from /usr/lib/debug/lib64/libcrypt-2.12.so.debug .. --10767-- Reading syms from /lib64/libdl-2.12.so (0x30e2000000) --10767-- Reading debug info from /usr/lib/debug/lib64/libdl-2.12.so.debug .. --10767-- Reading syms from /lib64/libc-2.12.so (0x30e1400000) --10767-- Reading debug info from /usr/lib/debug/lib64/libc-2.12.so.debug .. --10767-- Reading syms from /lib64/libfreebl3.so (0x33b8600000) --10767-- Reading debug info from /usr/lib/debug/lib64/libfreebl3.so.debug .. --10767-- REDIR: 0x30e1481ad0 (__GI_strrchr) redirected to 0x4a05e00 (__GI_strrchr) --10767-- REDIR: 0x30e1482850 (memset) redirected to 0x4a07540 (memset) --10767-- REDIR: 0x30e147ffe0 (strlen) redirected to 0x480155c (_vgnU_ifunc_wrapper) ==10767== WARNING: new redirection conflicts with existing -- ignoring it --10767-- new: 0x30e1480010 (__GI_strlen ) R-> 0x04a062e0 strlen --10767-- REDIR: 0x30e1480010 (__GI_strlen) redirected to 0x4a06300 (__GI_strlen) --10767-- REDIR: 0x30e1479610 (calloc) redirected to 0x4a043d3 (calloc) --10767-- REDIR: 0x30e147e5a0 (strcmp) redirected to 0x480155c (_vgnU_ifunc_wrapper) --10767-- REDIR: 0x30e1527820 (__strcmp_ssse3) redirected to 0x4a06860 (strcmp) --10767-- REDIR: 0x30e1480060 (strnlen) redirected to 0x4a06280 (strnlen) --10767-- REDIR: 0x30e1482690 (memmove) redirected to 0x4a075b0 (memmove) --10767-- REDIR: 0x30e1485260 (strchrnul) redirected to 0x4a07620 (strchrnul) --10767-- REDIR: 0x30e1483c60 (memcpy) redirected to 0x4a069d0 (memcpy) --10767-- REDIR: 0x30e14799d0 (malloc) redirected to 0x4a050db (malloc) --10767-- Reading syms from /lib64/libgcc_s-4.4.4-20100630.so.1 (0x30ec000000) --10767-- Reading debug info from /usr/lib/debug/lib64/libgcc_s-4.4.4-20100630.so.1.debug .. ==10767== WARNING: new redirection conflicts with existing -- ignoring it --10767-- new: 0x30e1480010 (__GI_strlen ) R-> 0x04a062e0 strlen --10767-- REDIR: 0x30e147a750 (free) redirected to 0x4a04ceb (free) --10767-- REDIR: 0x30e1480220 (__GI_strncmp) redirected to 0x4a06800 (__GI_strncmp) --10767-- REDIR: 0x30e147fa30 (strcpy) redirected to 0x480155c (_vgnU_ifunc_wrapper) --10767-- REDIR: 0x30e1524280 (???) redirected to 0x4a06360 (strcpy) --10767-- REDIR: 0x30e1482260 (bcmp) redirected to 0x480155c (_vgnU_ifunc_wrapper) --10767-- REDIR: 0x30e1482290 (__GI_memcmp) redirected to 0x4a07160 (bcmp) --10767-- REDIR: 0x30e147abd0 (realloc) redirected to 0x4a0518c (realloc) --10767-- REDIR: 0x30e147fa60 (__GI_strcpy) redirected to 0x4a06430 (__GI_strcpy) --10767-- REDIR: 0x30e147e5e0 (__GI_strcmp) redirected to 0x4a068b0 (__GI_strcmp) --10767-- REDIR: 0xffffffffff600400 (???) redirected to 0x3803f6ed (vgPlain_amd64_linux_REDIR_FOR_vtime) --10767-- REDIR: 0x30e1485210 (__GI___rawmemchr) redirected to 0x4a07670 (__GI___rawmemchr) --10767-- REDIR: 0x30e1481aa0 (rindex) redirected to 0x480155c (_vgnU_ifunc_wrapper) ==10767== WARNING: new redirection conflicts with existing -- ignoring it --10767-- new: 0x30e1481ad0 (__GI_strrchr ) R-> 0x04a05dd0 rindex --10767-- REDIR: 0x30e147e4f0 (index) redirected to 0x480155c (_vgnU_ifunc_wrapper) ==10767== WARNING: new redirection conflicts with existing -- ignoring it --10767-- new: 0x30e147e520 (__GI_strchr ) R-> 0x04a05e90 index --10767-- REDIR: 0x30e147e520 (__GI_strchr) redirected to 0x4a05ec0 (__GI_strchr) --10767-- REDIR: 0x30e1480140 (strncat) redirected to 0x4a06170 (strncat) --10767-- REDIR: 0x30e1483380 (mempcpy) redirected to 0x4a07690 (mempcpy) --10767-- REDIR: 0x30e14821e0 (memchr) redirected to 0x4a069a0 (memchr) --10767-- REDIR: 0x30e1483990 (stpcpy) redirected to 0x480155c (_vgnU_ifunc_wrapper) --10767-- REDIR: 0x30e1525c20 (???) redirected to 0x4a07200 (stpcpy) --10767-- REDIR: 0x30e14801e0 (strncmp) redirected to 0x480155c (_vgnU_ifunc_wrapper) --10767-- REDIR: 0x30e1528a80 (__strncmp_ssse3) redirected to 0x4a067a0 (strncmp) 110104 9:37:34 [Note] Plugin 'FEDERATED' is disabled. 110104 9:37:34 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 110104 9:37:34 InnoDB: The InnoDB memory heap is disabled 110104 9:37:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins 110104 9:37:34 InnoDB: Compressed tables use zlib 1.2.3 --10767-- REDIR: 0xffffffffff600000 (???) redirected to 0x3803f6e3 (vgPlain_amd64_linux_REDIR_FOR_vgettimeofday) 110104 9:37:35 InnoDB: Initializing buffer pool, size = 128.0M 110104 9:37:40 InnoDB: Completed initialization of buffer pool 110104 9:37:42 InnoDB: highest supported file format is Barracuda. 110104 9:37:53 InnoDB: 1.2.1 started; log sequence number 1595675 110104 9:37:55 [Note] ./bin/mysqld: ready for connections. Version: '5.6.2-m5-valgrind-max-debug' socket: '/tmp/mysql.sock' port: 3306 Source distribution ==10767== Thread 18: ==10767== Conditional jump or move depends on uninitialised value(s) ==10767== at 0x78EB7D: cmp_longs(long long, long long) (item_cmpfunc.cc:3359) ==10767== by 0x78EC97: cmp_longlong(void*, in_longlong::packed_longlong*, in_longlong::packed_longlong*) (item_cmpfunc.cc:3432) ==10767== by 0x8FFD19: my_qsort2 (mf_qsort.c:130) ==10767== by 0x79793C: in_vector::sort() (item_cmpfunc.h:822) ==10767== by 0x7911E6: Item_func_in::fix_length_and_dec() (item_cmpfunc.cc:4126) ==10767== by 0x7ADE6F: Item_func::fix_fields(THD*, Item**) (item_func.cc:227) ==10767== by 0x7905F1: Item_func_in::fix_fields(THD*, Item**) (item_cmpfunc.cc:3902) ==10767== by 0x5AFDDA: setup_fields(THD*, Item**, List&, enum_mark_columns, List*, bool) (sql_base.cc:7784) ==10767== by 0x858277: mysql_do(THD*, List&) (sql_do.cc:31) ==10767== by 0x5F49D2: mysql_execute_command(THD*) (sql_parse.cc:2119) ==10767== by 0x5FDDF6: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5550) ==10767== by 0x5F21BD: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1078) ==10767== by 0x5F14C5: do_command(THD*) (sql_parse.cc:815) ==10767== by 0x6D131C: do_handle_one_connection(THD*) (sql_connect.cc:748) ==10767== by 0x6D0EAD: handle_one_connection (sql_connect.cc:684) ==10767== by 0x30E1807760: start_thread (pthread_create.c:301) ==10767== by 0x1B07070F: ??? ==10767== Uninitialised value was created by a stack allocation ==10767== at 0x7FAA82: Item_func_year::val_int() (item_timefunc.cc:1303) ==10767== ==10767== ==10767== ---- Attach to debugger ? --- [Return/N/n/Y/y/C/c] ---- c ==10767== Conditional jump or move depends on uninitialised value(s) ==10767== at 0x8FFD1C: my_qsort2 (mf_qsort.c:130) ==10767== by 0x79793C: in_vector::sort() (item_cmpfunc.h:822) ==10767== by 0x7911E6: Item_func_in::fix_length_and_dec() (item_cmpfunc.cc:4126) ==10767== by 0x7ADE6F: Item_func::fix_fields(THD*, Item**) (item_func.cc:227) ==10767== by 0x7905F1: Item_func_in::fix_fields(THD*, Item**) (item_cmpfunc.cc:3902) ==10767== by 0x5AFDDA: setup_fields(THD*, Item**, List&, enum_mark_columns, List*, bool) (sql_base.cc:7784) ==10767== by 0x858277: mysql_do(THD*, List&) (sql_do.cc:31) ==10767== by 0x5F49D2: mysql_execute_command(THD*) (sql_parse.cc:2119) ==10767== by 0x5FDDF6: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5550) ==10767== by 0x5F21BD: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1078) ==10767== by 0x5F14C5: do_command(THD*) (sql_parse.cc:815) ==10767== by 0x6D131C: do_handle_one_connection(THD*) (sql_connect.cc:748) ==10767== by 0x6D0EAD: handle_one_connection (sql_connect.cc:684) ==10767== by 0x30E1807760: start_thread (pthread_create.c:301) ==10767== by 0x1B07070F: ??? ==10767== Uninitialised value was created by a stack allocation ==10767== at 0x7FAA82: Item_func_year::val_int() (item_timefunc.cc:1303) ==10767== ==10767== Conditional jump or move depends on uninitialised value(s) ==10767== at 0x78EB7D: cmp_longs(long long, long long) (item_cmpfunc.cc:3359) ==10767== by 0x78EC97: cmp_longlong(void*, in_longlong::packed_longlong*, in_longlong::packed_longlong*) (item_cmpfunc.cc:3432) ==10767== by 0x78EE0E: in_vector::find(Item*) (item_cmpfunc.cc:3470) ==10767== by 0x7914BE: Item_func_in::val_int() (item_cmpfunc.cc:4198) ==10767== by 0x8582AF: mysql_do(THD*, List&) (sql_do.cc:34) ==10767== by 0x5F49D2: mysql_execute_command(THD*) (sql_parse.cc:2119) ==10767== by 0x5FDDF6: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5550) ==10767== by 0x5F21BD: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1078) ==10767== by 0x5F14C5: do_command(THD*) (sql_parse.cc:815) ==10767== by 0x6D131C: do_handle_one_connection(THD*) (sql_connect.cc:748) ==10767== by 0x6D0EAD: handle_one_connection (sql_connect.cc:684) ==10767== by 0x30E1807760: start_thread (pthread_create.c:301) ==10767== by 0x1B07070F: ??? ==10767== Uninitialised value was created by a stack allocation ==10767== at 0x7FAA82: Item_func_year::val_int() (item_timefunc.cc:1303) ==10767== ==10767== Conditional jump or move depends on uninitialised value(s) ==10767== at 0x78EE1B: in_vector::find(Item*) (item_cmpfunc.cc:3470) ==10767== by 0x7914BE: Item_func_in::val_int() (item_cmpfunc.cc:4198) ==10767== by 0x8582AF: mysql_do(THD*, List&) (sql_do.cc:34) ==10767== by 0x5F49D2: mysql_execute_command(THD*) (sql_parse.cc:2119) ==10767== by 0x5FDDF6: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5550) ==10767== by 0x5F21BD: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1078) ==10767== by 0x5F14C5: do_command(THD*) (sql_parse.cc:815) ==10767== by 0x6D131C: do_handle_one_connection(THD*) (sql_connect.cc:748) ==10767== by 0x6D0EAD: handle_one_connection (sql_connect.cc:684) ==10767== by 0x30E1807760: start_thread (pthread_create.c:301) ==10767== by 0x1B07070F: ??? ==10767== Uninitialised value was created by a stack allocation ==10767== at 0x7FAA82: Item_func_year::val_int() (item_timefunc.cc:1303) ==10767== ==10767== Conditional jump or move depends on uninitialised value(s) ==10767== at 0x78EE28: in_vector::find(Item*) (item_cmpfunc.cc:3472) ==10767== by 0x7914BE: Item_func_in::val_int() (item_cmpfunc.cc:4198) ==10767== by 0x8582AF: mysql_do(THD*, List&) (sql_do.cc:34) ==10767== by 0x5F49D2: mysql_execute_command(THD*) (sql_parse.cc:2119) ==10767== by 0x5FDDF6: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5550) ==10767== by 0x5F21BD: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1078) ==10767== by 0x5F14C5: do_command(THD*) (sql_parse.cc:815) ==10767== by 0x6D131C: do_handle_one_connection(THD*) (sql_connect.cc:748) ==10767== by 0x6D0EAD: handle_one_connection (sql_connect.cc:684) ==10767== by 0x30E1807760: start_thread (pthread_create.c:301) ==10767== by 0x1B07070F: ??? ==10767== Uninitialised value was created by a stack allocation ==10767== at 0x7FAA82: Item_func_year::val_int() (item_timefunc.cc:1303) ==10767==