src/dblib/unittests/t0016

Main

Hostnamefreddy
uname -aLinux freddy 4.10.0-22-generic #24-Ubuntu SMP Mon May 22 17:43:20 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux
date2017-06-16

==11085== Memcheck, a memory error detector
==11085== Copyright (C) 2002-2015, and GNU GPL'd, by Julian Seward et al.
==11085== Using Valgrind-3.12.0 and LibVEX; rerun with -h for copyright info
==11085== Command: ./t0016
==11085== 
--11085-- Valgrind options:
--11085--    --tool=memcheck
--11085--    --vgdb=no
--11085--    --num-callers=20
--11085--    --leak-check=yes
--11085--    -v
--11085--    --show-reachable=yes
--11085--    --log-fd=3
--11085--    --suppressions=/home/freddy/suppressions.supp
--11085--    --track-origins=yes
--11085-- Contents of /proc/version:
--11085--   Linux version 4.10.0-22-generic (buildd@lcy01-08) (gcc version 6.3.0 20170406 (Ubuntu 6.3.0-12ubuntu2) ) #24-Ubuntu SMP Mon May 22 17:43:20 UTC 2017
--11085-- 
--11085-- Arch and hwcaps: AMD64, LittleEndian, amd64-cx16-lzcnt-rdtscp-sse3-avx-avx2-bmi
--11085-- Page sizes: currently 4096, max supported 4096
--11085-- Valgrind library directory: /home/freddy/install/lib/valgrind
--11085-- Reading syms from /home/freddy/ftdstmp/ftds_comp99/test3/src/dblib/unittests/t0016
--11085-- Reading syms from /lib/x86_64-linux-gnu/ld-2.24.so
--11085--   Considering /lib/x86_64-linux-gnu/ld-2.24.so ..
--11085--   .. CRC mismatch (computed 4b0c5a7e wanted 89f5325d)
--11085--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/ld-2.24.so ..
--11085--   .. CRC is valid
--11085-- Reading syms from /home/freddy/install/lib/valgrind/memcheck-amd64-linux
--11085--    object doesn't have a dynamic symbol table
--11085-- Scheduler: using generic scheduler lock implementation.
--11085-- Reading suppressions file: /home/freddy/suppressions.supp
--11085-- Reading suppressions file: /home/freddy/install/lib/valgrind/default.supp
--11085-- REDIR: 0x401d280 (ld-linux-x86-64.so.2:strlen) redirected to 0x380a60c1 (vgPlain_amd64_linux_REDIR_FOR_strlen)
--11085-- REDIR: 0x401bbd0 (ld-linux-x86-64.so.2:index) redirected to 0x380a60db (vgPlain_amd64_linux_REDIR_FOR_index)
--11085-- Reading syms from /home/freddy/install/lib/valgrind/vgpreload_core-amd64-linux.so
--11085-- Reading syms from /home/freddy/install/lib/valgrind/vgpreload_memcheck-amd64-linux.so
==11085== WARNING: new redirection conflicts with existing -- ignoring it
--11085--     old: 0x0401d280 (strlen              ) R-> (0000.0) 0x380a60c1 vgPlain_amd64_linux_REDIR_FOR_strlen
--11085--     new: 0x0401d280 (strlen              ) R-> (2007.0) 0x04c30c60 strlen
--11085-- REDIR: 0x401bdf0 (ld-linux-x86-64.so.2:strcmp) redirected to 0x4c31d60 (strcmp)
--11085-- REDIR: 0x401dd90 (ld-linux-x86-64.so.2:mempcpy) redirected to 0x4c35130 (mempcpy)
--11085-- Reading syms from /home/freddy/ftdstmp/ftds_comp99/src/dblib/.libs/libsybdb.so.5.1.0
--11085-- Reading syms from /lib/x86_64-linux-gnu/libpthread-2.24.so
--11085--   Considering /usr/lib/debug/.build-id/23/6fbbfd91b7dc1ede76916401a1435a1da42114.debug ..
--11085--   .. build-id is valid
--11085-- Reading syms from /lib/x86_64-linux-gnu/libc-2.24.so
--11085--   Considering /lib/x86_64-linux-gnu/libc-2.24.so ..
--11085--   .. CRC mismatch (computed 1f08dfe0 wanted 2cd0873a)
--11085--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libc-2.24.so ..
--11085--   .. CRC is valid
--11085-- Reading syms from /usr/lib/x86_64-linux-gnu/libgssapi_krb5.so.2.2
--11085--    object doesn't have a symbol table
--11085-- Reading syms from /lib/x86_64-linux-gnu/libssl.so.1.0.0
--11085--    object doesn't have a symbol table
--11085-- Reading syms from /lib/x86_64-linux-gnu/libcrypto.so.1.0.0
--11085--    object doesn't have a symbol table
--11085-- Reading syms from /usr/lib/x86_64-linux-gnu/libkrb5.so.3.3
--11085--    object doesn't have a symbol table
--11085-- Reading syms from /usr/lib/x86_64-linux-gnu/libk5crypto.so.3.1
--11085--    object doesn't have a symbol table
--11085-- Reading syms from /lib/x86_64-linux-gnu/libcom_err.so.2.1
--11085--    object doesn't have a symbol table
--11085-- Reading syms from /usr/lib/x86_64-linux-gnu/libkrb5support.so.0.1
--11085--    object doesn't have a symbol table
--11085-- Reading syms from /lib/x86_64-linux-gnu/libdl-2.24.so
--11085--   Considering /lib/x86_64-linux-gnu/libdl-2.24.so ..
--11085--   .. CRC mismatch (computed 3bce5754 wanted e3d30ea1)
--11085--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libdl-2.24.so ..
--11085--   .. CRC is valid
--11085-- Reading syms from /lib/x86_64-linux-gnu/libkeyutils.so.1.5
--11085--    object doesn't have a symbol table
--11085-- Reading syms from /lib/x86_64-linux-gnu/libresolv-2.24.so
--11085--   Considering /lib/x86_64-linux-gnu/libresolv-2.24.so ..
--11085--   .. CRC mismatch (computed c39a3520 wanted c971fdd5)
--11085--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libresolv-2.24.so ..
--11085--   .. CRC is valid
--11085-- REDIR: 0x53b9020 (libc.so.6:strcasecmp) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--11085-- REDIR: 0x53b4990 (libc.so.6:strcspn) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--11085-- REDIR: 0x53bb310 (libc.so.6:strncasecmp) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--11085-- REDIR: 0x53b6e00 (libc.so.6:strpbrk) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--11085-- REDIR: 0x53b7190 (libc.so.6:strspn) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--11085-- REDIR: 0x53b86a0 (libc.so.6:memmove) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--11085-- REDIR: 0x53b3190 (libc.so.6:index) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--11085-- REDIR: 0x53b8260 (libc.so.6:bcmp) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--11085-- REDIR: 0x53b33e0 (libc.so.6:strcmp) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--11085-- REDIR: 0x53bda10 (libc.so.6:memcpy@@GLIBC_2.14) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--11085-- REDIR: 0x53b6ad0 (libc.so.6:strncpy) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--11085-- REDIR: 0x53b4870 (libc.so.6:strcpy) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--11085-- REDIR: 0x53b6b10 (libc.so.6:rindex) redirected to 0x4c305f0 (rindex)
--11085-- REDIR: 0x53b4e30 (libc.so.6:strlen) redirected to 0x4c30ba0 (strlen)
--11085-- REDIR: 0x53ae0e0 (libc.so.6:free) redirected to 0x4c2eccc (free)
--11085-- REDIR: 0x53add30 (libc.so.6:malloc) redirected to 0x4c2db1f (malloc)
--11085-- REDIR: 0x53b87b0 (libc.so.6:memcpy@GLIBC_2.2.5) redirected to 0x4c31ec0 (memcpy@GLIBC_2.2.5)
--11085-- REDIR: 0x53cd110 (libc.so.6:__strcpy_sse2_unaligned) redirected to 0x4c30c80 (strcpy)
--11085-- REDIR: 0x53b5280 (libc.so.6:__GI_strncmp) redirected to 0x4c31350 (__GI_strncmp)
--11085-- REDIR: 0x53b7740 (libc.so.6:__GI_strstr) redirected to 0x4c35390 (__strstr_sse2)
--11085-- REDIR: 0x53b7f10 (libc.so.6:memchr) redirected to 0x4c31e00 (memchr)
--11085-- REDIR: 0x53bf3c0 (libc.so.6:strchrnul) redirected to 0x4c34c60 (strchrnul)
found SYBASE15.tempdb for sa in "../../../PWD"
--11085-- REDIR: 0x53b8790 (libc.so.6:__GI_mempcpy) redirected to 0x4c34e60 (__GI_mempcpy)
SQL text will be read from ../../../src/dblib/unittests/t0016.sql
Starting ./t0016
--11085-- REDIR: 0x53ae950 (libc.so.6:calloc) redirected to 0x4c2f9ba (calloc)
--11085-- REDIR: 0x53b31c0 (libc.so.6:__GI_strchr) redirected to 0x4c30750 (__GI_strchr)
--11085-- REDIR: 0x5474ac0 (libc.so.6:__strcasecmp_avx) redirected to 0x4c314a0 (strcasecmp)
--11085-- REDIR: 0x5477b70 (libc.so.6:__memcpy_avx_unaligned_erms) redirected to 0x4c343c0 (memmove)
About to logon
--11085-- REDIR: 0x53b8b50 (libc.so.6:memset) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--11085-- REDIR: 0x5477fb0 (libc.so.6:__memset_avx2_unaligned_erms) redirected to 0x4c342c0 (memset)
--11085-- REDIR: 0x53c84c0 (libc.so.6:__strcmp_sse2_unaligned) redirected to 0x4c31c20 (strcmp)
--11085-- REDIR: 0x5476130 (libc.so.6:__strncasecmp_avx) redirected to 0x4c31580 (strncasecmp)
--11085-- REDIR: 0x53b3420 (libc.so.6:__GI_strcmp) redirected to 0x4c31c70 (__GI_strcmp)
--11085-- REDIR: 0x53b8eb0 (libc.so.6:__GI_stpcpy) redirected to 0x4c33d80 (__GI_stpcpy)
--11085-- Reading syms from /lib/x86_64-linux-gnu/libnss_compat-2.24.so
--11085--   Considering /lib/x86_64-linux-gnu/libnss_compat-2.24.so ..
--11085--   .. CRC mismatch (computed 8c6ea835 wanted 20ccf3f1)
--11085--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnss_compat-2.24.so ..
--11085--   .. CRC is valid
--11085-- Reading syms from /lib/x86_64-linux-gnu/libnsl-2.24.so
--11085--   Considering /lib/x86_64-linux-gnu/libnsl-2.24.so ..
--11085--   .. CRC mismatch (computed 45f6d82d wanted 3548535a)
--11085--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnsl-2.24.so ..
--11085--   .. CRC is valid
--11085-- REDIR: 0x53b48b0 (libc.so.6:__GI_strcpy) redirected to 0x4c30d50 (__GI_strcpy)
--11085-- Reading syms from /lib/x86_64-linux-gnu/libnss_nis-2.24.so
--11085--   Considering /lib/x86_64-linux-gnu/libnss_nis-2.24.so ..
--11085--   .. CRC mismatch (computed e2d5a74c wanted c6d5135d)
--11085--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnss_nis-2.24.so ..
--11085--   .. CRC is valid
--11085-- Reading syms from /lib/x86_64-linux-gnu/libnss_files-2.24.so
--11085--   Considering /lib/x86_64-linux-gnu/libnss_files-2.24.so ..
--11085--   .. CRC mismatch (computed c47c4c51 wanted 31a2947a)
--11085--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnss_files-2.24.so ..
--11085--   .. CRC is valid
--11085-- REDIR: 0x53ae300 (libc.so.6:realloc) redirected to 0x4c2fbb3 (realloc)
--11085-- REDIR: 0x53bf1b0 (libc.so.6:rawmemchr) redirected to 0x4c34c90 (rawmemchr)
--11085-- REDIR: 0x5474870 (libc.so.6:__strpbrk_sse42) redirected to 0x4c35470 (strpbrk)
--11085-- Reading syms from /usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so
--11085--   Considering /usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so ..
--11085--   .. CRC mismatch (computed 42bfc197 wanted a6d47097)
--11085--   Considering /usr/lib/debug/usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so ..
--11085--   .. CRC is valid
--11085-- REDIR: 0x401e060 (ld-linux-x86-64.so.2:stpcpy) redirected to 0x4c340c0 (stpcpy)
--11085-- Reading syms from /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so
--11085--   Considering /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so ..
--11085--   .. CRC mismatch (computed cb2db349 wanted bc322ea2)
--11085--   Considering /usr/lib/debug/usr/lib/x86_64-linux-gnu/gconv/UTF-16.so ..
--11085--   .. CRC is valid
After logon
Creating table '#dblib0016'
	  1: create table #dblib0016 (f1 int not null, s1 int null, f2 numeric(10,2) null, f3 varchar(255) not null, f4 datetime null, [group] varchar(20)) 
bcp_init with in_file as '../../../src/dblib/unittests/t0016.in'
return from bcp_init = 1
	  1: select * from #dblib0016 where 0=1
return from dbcmd = 1
return from dbsqlexec = 1
Number of columns = 6
return from bcp_columns = 1
--11085-- REDIR: 0x5492ac0 (libc.so.6:__memcmp_sse4_1) redirected to 0x4c33aa0 (__memcmp_sse4_1)
2 rows copied in
select
	  1: select * from #dblib0016 where 0=1
--11085-- REDIR: 0x53b7ce0 (libc.so.6:strstr) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--11085-- REDIR: 0x53d17b0 (libc.so.6:__strstr_sse2_unaligned) redirected to 0x4c35320 (strstr)
2 rows copied out
Dropping table '#dblib0016'
	  1: drop table #dblib0016
Input and output files are equal
Creating table '#dblib0016'
	  1: create table #dblib0016 (f1 int not null, str nvarchar(5), uuid uniqueidentifier)
Creating table '#dblib0016'
	  1: create table #dblib0016 (f1 int not null, f2 text, f3 varchar(20) )
bcp_init with in_file as '../../../src/dblib/unittests/t0016_2.in'
return from bcp_init = 1
	  1: select * from #dblib0016 where 0=1
return from dbcmd = 1
return from dbsqlexec = 1
Number of columns = 3
return from bcp_columns = 1
2 rows copied in
select
	  1: select * from #dblib0016 where 0=1
2 rows copied out
Dropping table '#dblib0016'
	  1: drop table #dblib0016
Input and output files are equal
Creating table '#dblib0016'
	  1: create table #dblib0016 (f1 int not null, f2 char(20) not null, f3 binary(4) not null)
bcp_init with in_file as '../../../src/dblib/unittests/t0016_3.in'
return from bcp_init = 1
	  1: select * from #dblib0016 where 0=1
return from dbcmd = 1
return from dbsqlexec = 1
Number of columns = 3
return from bcp_columns = 1
2 rows copied in
select
	  1: select * from #dblib0016 where 0=1
2 rows copied out
Dropping table '#dblib0016'
	  1: drop table #dblib0016
Input and output files are equal
Creating table '#dblib0016'
	  1: create table #dblib0016 (f1 int not null, f2 char(20) null, f3 binary(4) null)
bcp_init with in_file as '../../../src/dblib/unittests/t0016_4.in'
return from bcp_init = 1
	  1: select * from #dblib0016 where 0=1
return from dbcmd = 1
return from dbsqlexec = 1
Number of columns = 3
return from bcp_columns = 1
2 rows copied in
select
	  1: select * from #dblib0016 where 0=1
2 rows copied out
Dropping table '#dblib0016'
	  1: drop table #dblib0016
Input and output files are equal
Creating table '#dblib0016'
	  1: create table #dblib0016 (f0 int not null, f1 varchar(60) not null, f2 varchar(60) not null, f3 varchar(60) not null, f4 varchar(60) not null, f5 varchar(60) not null, f6 varchar(60) not null, f7 varchar(60) not null, f8 varchar(60) not null, f9 varchar(60) not null, f10 varchar(60) not null, f11 varchar(60) not null, f12 varchar(60) not null, f13 varchar(60) not null, f14 varchar(60) not null, f15 varchar(60) not null, f16 varchar(60) not null, f17 varchar(60) not null, f18 varchar(60) not null, f19 varchar(60) not null, f20 varchar(60) not null)
bcp_init with in_file as '../../../src/dblib/unittests/t0016_5.in'
return from bcp_init = 1
	  1: select * from #dblib0016 where 0=1
return from dbcmd = 1
return from dbsqlexec = 1
Number of columns = 21
return from bcp_columns = 1
2 rows copied in
select
	  1: select * from #dblib0016 where 0=1
2 rows copied out
Dropping table '#dblib0016'
	  1: drop table #dblib0016
Input and output files are equal
Creating table '#dblib0016'
	  1: create table #dblib0016 (f0 datetime2(3) not null)
Creating table '#dblib0016'
	  1: create table #dblib0016 (b1 bit, b2 bit, i1 int not null, b3 bit, b4 bit)
bcp_init with in_file as '../../../src/dblib/unittests/t0016_7.in'
return from bcp_init = 1
	  1: select * from #dblib0016 where 0=1
return from dbcmd = 1
return from dbsqlexec = 1
Number of columns = 5
return from bcp_columns = 1
2 rows copied in
select
	  1: select * from #dblib0016 where 0=1
2 rows copied out
Dropping table '#dblib0016'
	  1: drop table #dblib0016
Input and output files are equal
Creating table '#dblib0016'
	  1: create table #dblib0016 (b1 bit, b2 bit, b3 bit, b4 bit)
bcp_init with in_file as '../../../src/dblib/unittests/t0016_8.in'
return from bcp_init = 1
	  1: select * from #dblib0016 where 0=1
return from dbcmd = 1
return from dbsqlexec = 1
Number of columns = 4
return from bcp_columns = 1
2 rows copied in
select
	  1: select * from #dblib0016 where 0=1
2 rows copied out
Dropping table '#dblib0016'
	  1: drop table #dblib0016
Input and output files are equal
Creating table '#dblib0016'
	  1: -- check if bit are all collased together, the layout will be
	  2: -- 8 bits (b1-b8), i1, 1 bit (b9) -> 6 bytes
	  3: create table #dblib0016 (b1 bit, b2 bit, b3 bit, b4 bit, b5 bit, b6 bit, b7 bit, b8 bit, i1 int not null, b9 bit)
bcp_init with in_file as '../../../src/dblib/unittests/t0016_9.in'
return from bcp_init = 1
	  1: select * from #dblib0016 where 0=1
return from dbcmd = 1
return from dbsqlexec = 1
Number of columns = 10
return from bcp_columns = 1
2 rows copied in
select
	  1: select * from #dblib0016 where 0=1
2 rows copied out
Dropping table '#dblib0016'
	  1: drop table #dblib0016
Input and output files are equal
Creating table '#dblib0016'
	  1: set textsize 65536
	  2: create table #dblib0016 (id int not null, data image)
bcp_init with in_file as '../../../src/dblib/unittests/t0016_10.in'
return from bcp_init = 1
	  1: select * from #dblib0016 where 0=1
return from dbcmd = 1
return from dbsqlexec = 1
Number of columns = 2
return from bcp_columns = 1
2 rows copied in
select
	  1: select * from #dblib0016 where 0=1
2 rows copied out
Dropping table '#dblib0016'
	  1: drop table #dblib0016
Input and output files are equal
Creating table '#dblib0016'
	  1: create table #dblib0016 (id int not null, var uniqueidentifier null, c1 char(20) not null, v1 varchar(20) not null, c2 char(20) null, v2 varchar(20) null, b1 binary(20) null, vb1 varbinary(20) null, img image null, txt text null)
Creating table '#dblib0016'
	  1: create table #dblib0016 (id int not null, var uniqueidentifier null, c1 nvarchar(200))
could not open SQL input file "../../../src/dblib/unittests/t0016_13.sql"
--11085-- Discarding syms at 0x7b5f5e0-0x7b600ba in /usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so due to munmap()
dblib okay on t0016.c
--11085-- Discarding syms at 0x7d626e0-0x7d63efc in /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so due to munmap()
--11085-- Discarding syms at 0x73202b0-0x7325b05 in /lib/x86_64-linux-gnu/libnss_compat-2.24.so due to munmap()
--11085-- Discarding syms at 0x77430e0-0x7749869 in /lib/x86_64-linux-gnu/libnss_nis-2.24.so due to munmap()
--11085-- Discarding syms at 0x752bfd0-0x7539091 in /lib/x86_64-linux-gnu/libnsl-2.24.so due to munmap()
--11085-- Discarding syms at 0x794f1d0-0x79552a1 in /lib/x86_64-linux-gnu/libnss_files-2.24.so due to munmap()
==11085== 
==11085== HEAP SUMMARY:
==11085==     in use at exit: 0 bytes in 0 blocks
==11085==   total heap usage: 4,902 allocs, 4,902 frees, 5,224,417 bytes allocated
==11085== 
==11085== All heap blocks were freed -- no leaks are possible
==11085== 
==11085== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 0 from 0)
==11085== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 0 from 0)

Main