src/odbc/unittests/testodbc

Main

Hostnamefreddy
uname -aLinux freddy 4.10.0-37-generic #41-Ubuntu SMP Fri Oct 6 20:20:37 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux
date2017-10-14

==6714== Memcheck, a memory error detector
==6714== Copyright (C) 2002-2015, and GNU GPL'd, by Julian Seward et al.
==6714== Using Valgrind-3.12.0 and LibVEX; rerun with -h for copyright info
==6714== Command: ./testodbc
==6714== 
--6714-- Valgrind options:
--6714--    --tool=memcheck
--6714--    --vgdb=no
--6714--    --num-callers=20
--6714--    --leak-check=yes
--6714--    -v
--6714--    --show-reachable=yes
--6714--    --log-fd=3
--6714--    --suppressions=/home/freddy/suppressions.supp
--6714--    --track-origins=yes
--6714-- Contents of /proc/version:
--6714--   Linux version 4.10.0-37-generic (buildd@lgw01-amd64-021) (gcc version 6.3.0 20170406 (Ubuntu 6.3.0-12ubuntu2) ) #41-Ubuntu SMP Fri Oct 6 20:20:37 UTC 2017
--6714-- 
--6714-- Arch and hwcaps: AMD64, LittleEndian, amd64-cx16-lzcnt-rdtscp-sse3-avx-avx2-bmi
--6714-- Page sizes: currently 4096, max supported 4096
--6714-- Valgrind library directory: /home/freddy/install/lib/valgrind
--6714-- Reading syms from /home/freddy/ftdstmp/ftds_comp99/test5/src/odbc/unittests/testodbc
--6714-- Reading syms from /lib/x86_64-linux-gnu/ld-2.24.so
--6714--   Considering /lib/x86_64-linux-gnu/ld-2.24.so ..
--6714--   .. CRC mismatch (computed c075befa wanted 5b162bac)
--6714--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/ld-2.24.so ..
--6714--   .. CRC is valid
--6714-- Reading syms from /home/freddy/install/lib/valgrind/memcheck-amd64-linux
--6714--    object doesn't have a dynamic symbol table
--6714-- Scheduler: using generic scheduler lock implementation.
--6714-- Reading suppressions file: /home/freddy/suppressions.supp
--6714-- Reading suppressions file: /home/freddy/install/lib/valgrind/default.supp
--6714-- REDIR: 0x401d4d0 (ld-linux-x86-64.so.2:strlen) redirected to 0x380a60c1 (vgPlain_amd64_linux_REDIR_FOR_strlen)
--6714-- REDIR: 0x401bd80 (ld-linux-x86-64.so.2:index) redirected to 0x380a60db (vgPlain_amd64_linux_REDIR_FOR_index)
--6714-- Reading syms from /home/freddy/install/lib/valgrind/vgpreload_core-amd64-linux.so
--6714-- Reading syms from /home/freddy/install/lib/valgrind/vgpreload_memcheck-amd64-linux.so
==6714== WARNING: new redirection conflicts with existing -- ignoring it
--6714--     old: 0x0401d4d0 (strlen              ) R-> (0000.0) 0x380a60c1 vgPlain_amd64_linux_REDIR_FOR_strlen
--6714--     new: 0x0401d4d0 (strlen              ) R-> (2007.0) 0x04c30c60 strlen
--6714-- REDIR: 0x401bfa0 (ld-linux-x86-64.so.2:strcmp) redirected to 0x4c31d60 (strcmp)
--6714-- REDIR: 0x401dfe0 (ld-linux-x86-64.so.2:mempcpy) redirected to 0x4c35130 (mempcpy)
--6714-- Reading syms from /home/freddy/ftdstmp/ftds_comp99/src/odbc/.libs/libtdsodbc.so.0.0.0
--6714-- Reading syms from /lib/x86_64-linux-gnu/libpthread-2.24.so
--6714--   Considering /usr/lib/debug/.build-id/d2/d91e222a7bae3822622410509fa0e967e8360f.debug ..
--6714--   .. build-id is valid
--6714-- Reading syms from /lib/x86_64-linux-gnu/libc-2.24.so
--6714--   Considering /lib/x86_64-linux-gnu/libc-2.24.so ..
--6714--   .. CRC mismatch (computed 3bb6a0e6 wanted 41b71c4c)
--6714--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libc-2.24.so ..
--6714--   .. CRC is valid
--6714-- Reading syms from /usr/lib/x86_64-linux-gnu/libgssapi_krb5.so.2.2
--6714--    object doesn't have a symbol table
--6714-- Reading syms from /lib/x86_64-linux-gnu/libssl.so.1.0.0
--6714--    object doesn't have a symbol table
--6714-- Reading syms from /lib/x86_64-linux-gnu/libcrypto.so.1.0.0
--6714--    object doesn't have a symbol table
--6714-- Reading syms from /usr/lib/x86_64-linux-gnu/libkrb5.so.3.3
--6714--    object doesn't have a symbol table
--6714-- Reading syms from /usr/lib/x86_64-linux-gnu/libk5crypto.so.3.1
--6714--    object doesn't have a symbol table
--6714-- Reading syms from /lib/x86_64-linux-gnu/libcom_err.so.2.1
--6714--    object doesn't have a symbol table
--6714-- Reading syms from /usr/lib/x86_64-linux-gnu/libkrb5support.so.0.1
--6714--    object doesn't have a symbol table
--6714-- Reading syms from /lib/x86_64-linux-gnu/libdl-2.24.so
--6714--   Considering /lib/x86_64-linux-gnu/libdl-2.24.so ..
--6714--   .. CRC mismatch (computed 3af4e647 wanted db71b677)
--6714--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libdl-2.24.so ..
--6714--   .. CRC is valid
--6714-- Reading syms from /lib/x86_64-linux-gnu/libkeyutils.so.1.5
--6714--    object doesn't have a symbol table
--6714-- Reading syms from /lib/x86_64-linux-gnu/libresolv-2.24.so
--6714--   Considering /lib/x86_64-linux-gnu/libresolv-2.24.so ..
--6714--   .. CRC mismatch (computed bb7360ae wanted c1b4ec17)
--6714--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libresolv-2.24.so ..
--6714--   .. CRC is valid
--6714-- REDIR: 0x53c6c20 (libc.so.6:strcasecmp) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--6714-- REDIR: 0x53c2590 (libc.so.6:strcspn) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--6714-- REDIR: 0x53c8f10 (libc.so.6:strncasecmp) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--6714-- REDIR: 0x53c4a00 (libc.so.6:strpbrk) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--6714-- REDIR: 0x53c4d90 (libc.so.6:strspn) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--6714-- REDIR: 0x53c62a0 (libc.so.6:memmove) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--6714-- REDIR: 0x53c0d90 (libc.so.6:index) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--6714-- REDIR: 0x53c5e60 (libc.so.6:bcmp) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--6714-- REDIR: 0x53c0fe0 (libc.so.6:strcmp) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--6714-- REDIR: 0x53cb610 (libc.so.6:memcpy@@GLIBC_2.14) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--6714-- REDIR: 0x53c46d0 (libc.so.6:strncpy) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--6714-- REDIR: 0x53c58e0 (libc.so.6:strstr) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--6714-- REDIR: 0x53c2470 (libc.so.6:strcpy) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--6714-- REDIR: 0x53c4710 (libc.so.6:rindex) redirected to 0x4c305f0 (rindex)
--6714-- REDIR: 0x53c2a30 (libc.so.6:strlen) redirected to 0x4c30ba0 (strlen)
--6714-- REDIR: 0x53ccfc0 (libc.so.6:strchrnul) redirected to 0x4c34c60 (strchrnul)
--6714-- REDIR: 0x53bb930 (libc.so.6:malloc) redirected to 0x4c2db1f (malloc)
--6714-- REDIR: 0x53c6390 (libc.so.6:__GI_mempcpy) redirected to 0x4c34e60 (__GI_mempcpy)
Running test  1: Raw ODBC direct query... TestRawODBCDirectQuery (in)
--6714-- REDIR: 0x53bbce0 (libc.so.6:free) redirected to 0x4c2eccc (free)
--6714-- REDIR: 0x53c2e80 (libc.so.6:__GI_strncmp) redirected to 0x4c31350 (__GI_strncmp)
--6714-- REDIR: 0x53c5340 (libc.so.6:__GI_strstr) redirected to 0x4c35390 (__strstr_sse2)
--6714-- REDIR: 0x53c5b10 (libc.so.6:memchr) redirected to 0x4c31e00 (memchr)
--6714-- REDIR: 0x53c63b0 (libc.so.6:memcpy@GLIBC_2.2.5) redirected to 0x4c31ec0 (memcpy@GLIBC_2.2.5)
--6714-- REDIR: 0x53dad10 (libc.so.6:__strcpy_sse2_unaligned) redirected to 0x4c30c80 (strcpy)
--6714-- REDIR: 0x54826c0 (libc.so.6:__strcasecmp_avx) redirected to 0x4c314a0 (strcasecmp)
--6714-- REDIR: 0x536ef10 (libc.so.6:setenv) redirected to 0x4c35960 (setenv)
--6714-- REDIR: 0x53c0dc0 (libc.so.6:__GI_strchr) redirected to 0x4c30750 (__GI_strchr)
--6714-- REDIR: 0x53bbf00 (libc.so.6:realloc) redirected to 0x4c2fbb3 (realloc)
--6714-- REDIR: 0x53c1020 (libc.so.6:__GI_strcmp) redirected to 0x4c31c70 (__GI_strcmp)
--6714-- REDIR: 0x53bc550 (libc.so.6:calloc) redirected to 0x4c2f9ba (calloc)
--6714-- REDIR: 0x5485770 (libc.so.6:__memcpy_avx_unaligned_erms) redirected to 0x4c343c0 (memmove)
odbctest
--------

connection parameters:
server:   'msde_pool'
user:     'sa'
password: '????'
database: 'tempdb'
--6714-- REDIR: 0x53d60c0 (libc.so.6:__strcmp_sse2_unaligned) redirected to 0x4c31c20 (strcmp)
--6714-- REDIR: 0x5483d30 (libc.so.6:__strncasecmp_avx) redirected to 0x4c31580 (strncasecmp)
--6714-- REDIR: 0x53c6ab0 (libc.so.6:__GI_stpcpy) redirected to 0x4c33d80 (__GI_stpcpy)
--6714-- Reading syms from /lib/x86_64-linux-gnu/libnss_compat-2.24.so
--6714--   Considering /lib/x86_64-linux-gnu/libnss_compat-2.24.so ..
--6714--   .. CRC mismatch (computed 433ac6c1 wanted 36dcf7bd)
--6714--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnss_compat-2.24.so ..
--6714--   .. CRC is valid
--6714-- Reading syms from /lib/x86_64-linux-gnu/libnsl-2.24.so
--6714--   Considering /lib/x86_64-linux-gnu/libnsl-2.24.so ..
--6714--   .. CRC mismatch (computed 7e7ddce9 wanted 35a92cfd)
--6714--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnsl-2.24.so ..
--6714--   .. CRC is valid
--6714-- REDIR: 0x53c24b0 (libc.so.6:__GI_strcpy) redirected to 0x4c30d50 (__GI_strcpy)
--6714-- Reading syms from /lib/x86_64-linux-gnu/libnss_nis-2.24.so
--6714--   Considering /lib/x86_64-linux-gnu/libnss_nis-2.24.so ..
--6714--   .. CRC mismatch (computed 5232975c wanted d7b24933)
--6714--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnss_nis-2.24.so ..
--6714--   .. CRC is valid
--6714-- Reading syms from /lib/x86_64-linux-gnu/libnss_files-2.24.so
--6714--   Considering /lib/x86_64-linux-gnu/libnss_files-2.24.so ..
--6714--   .. CRC mismatch (computed 0c0e8d0a wanted 81d05c96)
--6714--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnss_files-2.24.so ..
--6714--   .. CRC is valid
--6714-- Reading syms from /usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so
--6714--   Considering /usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so ..
--6714--   .. CRC mismatch (computed 642bf444 wanted d8a40f40)
--6714--   Considering /usr/lib/debug/usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so ..
--6714--   .. CRC is valid
--6714-- REDIR: 0x401e2b0 (ld-linux-x86-64.so.2:stpcpy) redirected to 0x4c340c0 (stpcpy)
--6714-- Reading syms from /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so
--6714--   Considering /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so ..
--6714--   .. CRC mismatch (computed 70ceee94 wanted c2c2f8e8)
--6714--   Considering /usr/lib/debug/usr/lib/x86_64-linux-gnu/gconv/UTF-16.so ..
--6714--   .. CRC is valid
--6714-- Reading syms from /usr/lib/x86_64-linux-gnu/gconv/CP1252.so
--6714--   Considering /usr/lib/x86_64-linux-gnu/gconv/CP1252.so ..
--6714--   .. CRC mismatch (computed 73a4dc66 wanted ab9c2413)
--6714--   Considering /usr/lib/debug/usr/lib/x86_64-linux-gnu/gconv/CP1252.so ..
--6714--   .. CRC is valid
--6714-- REDIR: 0x53c6750 (libc.so.6:memset) redirected to 0x4a28742 (_vgnU_ifunc_wrapper)
--6714-- REDIR: 0x5485bb0 (libc.so.6:__memset_avx2_unaligned_erms) redirected to 0x4c342c0 (memset)
use tempdb
CREATE TABLE #Products (ProductID int NOT NULL ,ProductName varchar (40) ,SupplierID int NULL ,CategoryID int NULL ,QuantityPerUnit varchar (20)  ,UnitPrice money NULL ,UnitsInStock smallint NULL ,UnitsOnOrder smallint NULL ,ReorderLevel smallint NULL ,Discontinued bit NOT NULL ) INSERT INTO #Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(1,'Chai',1,1,'10 boxes x 20 bags',18.00,39,0,10,0) INSERT INTO #Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(2,'Chang',1,1,'24 - 12 oz bottles',19.00,17,40,25,0) INSERT INTO #Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(3,'Aniseed Syrup',1,2,'12 - 550 ml bottles',10.00,13,70,25,0) INSERT INTO #Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(4,'Chef Anton''s Cajun Seasoning',2,2,'48 - 6 oz jars',22.00,53,0,0,0) INSERT INTO #Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(5,'Chef Anton''s Gumbo Mix',2,2,'36 boxes',21.35,0,0,0,1) 
Got 3 rows
--6714-- Discarding syms at 0x7d6f6e0-0x7d70efc in /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so due to munmap()
TestRawODBCDirectQuery (out): ok
pass
Running test  2: Raw ODBC prepared query... TestRawODBCPreparedQuery (in)
odbctest
--------

connection parameters:
server:   'msde_pool'
user:     'sa'
password: '????'
database: 'tempdb'
--6714-- Reading syms from /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so
--6714--   Considering /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so ..
--6714--   .. CRC mismatch (computed 70ceee94 wanted c2c2f8e8)
--6714--   Considering /usr/lib/debug/usr/lib/x86_64-linux-gnu/gconv/UTF-16.so ..
--6714--   .. CRC is valid
use tempdb
CREATE TABLE #Products (ProductID int NOT NULL ,ProductName varchar (40) ,SupplierID int NULL ,CategoryID int NULL ,QuantityPerUnit varchar (20)  ,UnitPrice money NULL ,UnitsInStock smallint NULL ,UnitsOnOrder smallint NULL ,ReorderLevel smallint NULL ,Discontinued bit NOT NULL ) INSERT INTO #Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(9,'Mishi Kobe Niku',4,6,'18 - 500 g pkgs.',97.00,29,0,0,1) INSERT INTO #Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(10,'Ikura',4,8,'12 - 200 ml jars',31.00,31,0,0,0) INSERT INTO #Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(74,'Longlife Tofu',4,7,'5 kg pkg.',10.00,4,20,5,0) INSERT INTO #Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(11,'Queso Cabrales',5,4,'1 kg pkg.',21.00,22,30,30,0) INSERT INTO #Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(12,'Queso Manchego La Pastora',5,4,'10 - 500 g pkgs.',38.00,86,0,0,0)
Got 3 rows
--6714-- Discarding syms at 0x7d6f6e0-0x7d70efc in /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so due to munmap()
TestRawODBCPreparedQuery (out): ok
pass
Running test  3: Raw ODBC GUID... TestRawODBCGuid (in)
odbctest
--------

connection parameters:
server:   'msde_pool'
user:     'sa'
password: '????'
database: 'tempdb'
--6714-- Reading syms from /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so
--6714--   Considering /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so ..
--6714--   .. CRC mismatch (computed 70ceee94 wanted c2c2f8e8)
--6714--   Considering /usr/lib/debug/usr/lib/x86_64-linux-gnu/gconv/UTF-16.so ..
--6714--   .. CRC is valid
use tempdb
--6714-- REDIR: 0x53df3b0 (libc.so.6:__strstr_sse2_unaligned) redirected to 0x4c35320 (strstr)
Creating #pet table
DROP PROC GetGUIDRows
--6714-- REDIR: 0x54a06c0 (libc.so.6:__memcmp_sse4_1) redirected to 0x4c33aa0 (__memcmp_sse4_1)
Creating stored proc GetGUIDRows
Insert row 1
Insert row 2
Insert row 3
Insert row 4
Insert row 5
retrieving name and guid
name: Fang       guid: E7C023BB-AA0B-4F02-AF10-B004D5B84734
name: Splash     guid: 12345678-1234-1234-1234-123456789012
name: Woof       guid: 87654321-4321-4321-4321-123456789ABC
name: Spike      guid: 1234ABCD-ABCD-ABCD-ABCD-123456789ABC
name: Fluffy     guid: AABBCCDD-EEFF-1122-1122-334455667788
retrieving name and guid again
Fang       E7C023BB-AA0B-4F02-AF10-B004D5B84734
Splash     12345678-1234-1234-1234-123456789012
Woof       87654321-4321-4321-4321-123456789ABC
Spike      1234ABCD-ABCD-ABCD-ABCD-123456789ABC
Fluffy     AABBCCDD-EEFF-1122-1122-334455667788
retrieving name and guid
--6714-- REDIR: 0x53ccdb0 (libc.so.6:rawmemchr) redirected to 0x4c34c90 (rawmemchr)
Woof       87654321-4321-4321-4321-123456789ABC
DROP PROC GetGUIDRows
--6714-- Discarding syms at 0x7d6f6e0-0x7d70efc in /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so due to munmap()
TestRawODBCGuid (out): ok
pass

All 3 tests passed.

--6714-- Discarding syms at 0x7f735e0-0x7f742d2 in /usr/lib/x86_64-linux-gnu/gconv/CP1252.so due to munmap()
--6714-- Discarding syms at 0x7b6c5e0-0x7b6d0ba in /usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so due to munmap()
--6714-- Discarding syms at 0x732d2b0-0x7332b05 in /lib/x86_64-linux-gnu/libnss_compat-2.24.so due to munmap()
--6714-- Discarding syms at 0x77500e0-0x7756869 in /lib/x86_64-linux-gnu/libnss_nis-2.24.so due to munmap()
--6714-- Discarding syms at 0x7538fd0-0x7546091 in /lib/x86_64-linux-gnu/libnsl-2.24.so due to munmap()
--6714-- Discarding syms at 0x795c1d0-0x79622a1 in /lib/x86_64-linux-gnu/libnss_files-2.24.so due to munmap()
==6714== 
==6714== HEAP SUMMARY:
==6714==     in use at exit: 0 bytes in 0 blocks
==6714==   total heap usage: 1,082 allocs, 1,082 frees, 1,798,645 bytes allocated
==6714== 
==6714== All heap blocks were freed -- no leaks are possible
==6714== 
==6714== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 0 from 0)
==6714== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 0 from 0)

Main