src/odbc/unittests/testodbc

Main

Hostnameobon110
gcc versiongcc (GCC) 4.1.2 20070925 (Red Hat 4.1.2-33)
uname -aLinux obon110 2.6.26.2-1smp #1 SMP Tue Aug 19 10:16:15 CEST 2008 i686 i686 i386 GNU/Linux
date2008-11-21

==22049== Memcheck, a memory error detector.
==22049== Copyright (C) 2002-2007, and GNU GPL'd, by Julian Seward et al.
==22049== Using LibVEX rev 1732, a library for dynamic binary translation.
==22049== Copyright (C) 2004-2007, and GNU GPL'd, by OpenWorks LLP.
==22049== Using valgrind-3.2.3, a dynamic binary instrumentation framework.
==22049== Copyright (C) 2000-2007, and GNU GPL'd, by Julian Seward et al.
==22049== 
--22049-- Command line
--22049--    ./testodbc
--22049-- Startup, with flags:
--22049--    --tool=memcheck
--22049--    --num-callers=20
--22049--    --leak-check=yes
--22049--    -v
--22049--    --show-reachable=yes
--22049--    --log-fd=3
--22049--    --suppressions=/home/winnt/fziglio/suppressions.supp
--22049-- Contents of /proc/version:
--22049--   Linux version 2.6.26.2-1smp (fziglio@obon110) (gcc version 4.1.2 20070626 (Red Hat 4.1.2-13)) #1 SMP Tue Aug 19 10:16:15 CEST 2008
--22049-- Arch and hwcaps: X86, x86-sse1-sse2
--22049-- Page sizes: currently 4096, max supported 4096
--22049-- Valgrind library directory: /usr/lib/valgrind
--22049-- Reading syms from /lib/ld-2.7.so (0x91E000)
--22049-- Reading debug info from /usr/lib/debug/lib/ld-2.7.so.debug...
--22049-- Reading syms from /home/winnt/fziglio/cpp/freetds/ftds_comp_old/src/odbc/unittests/testodbc (0x8048000)
--22049-- Reading syms from /usr/lib/valgrind/x86-linux/memcheck (0x38000000)
--22049--    object doesn't have a dynamic symbol table
--22049-- Reading suppressions file: /home/winnt/fziglio/suppressions.supp
--22049-- Reading suppressions file: /usr/lib/valgrind/default.supp
--22049-- REDIR: 0x933BB0 (index) redirected to 0x38027F5F (vgPlain_x86_linux_REDIR_FOR_index)
--22049-- Reading syms from /usr/lib/valgrind/x86-linux/vgpreload_core.so (0x4001000)
--22049-- Reading syms from /usr/lib/valgrind/x86-linux/vgpreload_memcheck.so (0x4003000)
==22049== WARNING: new redirection conflicts with existing -- ignoring it
--22049--     new: 0x00933BB0 (index     ) R-> 0x04006230 index
--22049-- REDIR: 0x933D50 (strlen) redirected to 0x40062E0 (strlen)
--22049-- Reading syms from /home/winnt/fziglio/cpp/freetds/ftds_comp_old/src/odbc/.libs/libtdsodbc.so.0.0.0 (0x4009000)
--22049-- Reading syms from /usr/lib/libgnutls.so.13.3.0 (0x40DE000)
--22049-- Reading debug info from /usr/lib/debug/usr/lib/libgnutls.so.13.3.0.debug...
--22049-- ... CRC mismatch (computed 812A60F5 wanted E162DD80)
--22049--    object doesn't have a symbol table
--22049-- Reading syms from /lib/libc-2.7.so (0x93D000)
--22049-- Reading debug info from /usr/lib/debug/lib/libc-2.7.so.debug...
--22049-- Reading syms from /lib/libz.so.1.2.3 (0xAE5000)
--22049-- Reading debug info from /usr/lib/debug/lib/libz.so.1.2.3.debug...
--22049-- Reading syms from /lib/libgcrypt.so.11.2.3 (0x3E25000)
--22049-- Reading debug info from /usr/lib/debug/lib/libgcrypt.so.11.2.3.debug...
--22049-- Reading syms from /lib/libgpg-error.so.0.3.1 (0xDB4000)
--22049-- Reading debug info from /usr/lib/debug/lib/libgpg-error.so.0.3.1.debug...
--22049-- Reading syms from /lib/libnsl-2.7.so (0x259000)
--22049-- Reading debug info from /usr/lib/debug/lib/libnsl-2.7.so.debug...
--22049-- REDIR: 0x9AD4C0 (rindex) redirected to 0x4006110 (rindex)
--22049-- REDIR: 0x9AD120 (strlen) redirected to 0x40062C0 (strlen)
--22049-- REDIR: 0x9A8B00 (malloc) redirected to 0x40054A0 (malloc)
--22049-- REDIR: 0x9AE890 (memcpy) redirected to 0x4007090 (memcpy)
--22049-- REDIR: 0x9ACBC0 (strcmp) redirected to 0x4006390 (strcmp)
--22049-- REDIR: 0x9AF220 (strchrnul) redirected to 0x40066F0 (strchrnul)
--22049-- REDIR: 0x9AE400 (mempcpy) redirected to 0x4006B70 (mempcpy)
Running test  1: Raw ODBC direct query... TestRawODBCDirectQuery (in)
--22049-- REDIR: 0x9ADEA0 (memchr) redirected to 0x40064B0 (memchr)
--22049-- REDIR: 0x9ACC30 (strcpy) redirected to 0x40072F0 (strcpy)
--22049-- REDIR: 0x9AA060 (free) redirected to 0x40050BA (free)
--22049-- REDIR: 0x9AC8A0 (strcat) redirected to 0x40073E0 (strcat)
--22049-- REDIR: 0x9ACA50 (index) redirected to 0x4006200 (index)
--22049-- REDIR: 0x9AD310 (strncmp) redirected to 0x4006320 (strncmp)
--22049-- REDIR: 0x9AA250 (realloc) redirected to 0x400554F (realloc)
--22049-- REDIR: 0x9AE3A0 (memset) redirected to 0x4006640 (memset)
odbctest
--------

connection parameters:
server:   'TESTSRV'
user:     'test'
password: '????'
database: 'test'
--22049-- REDIR: 0x9AE590 (stpcpy) redirected to 0x4006850 (stpcpy)
--22049-- REDIR: 0x9A8810 (calloc) redirected to 0x40047CD (calloc)
--22049-- Reading syms from /lib/libnss_files-2.7.so (0x40CA000)
--22049-- Reading debug info from /usr/lib/debug/lib/libnss_files-2.7.so.debug...
--22049-- Reading syms from /lib/libnss_winbind.so.2 (0x4272000)
--22049--    object doesn't have a symbol table
--22049-- REDIR: 0x9AD410 (strncpy) redirected to 0x4006930 (strncpy)
--22049-- REDIR: 0x9AF150 (rawmemchr) redirected to 0x4006720 (rawmemchr)
--22049-- Reading syms from /lib/libnss_dns-2.7.so (0x40D7000)
--22049-- Reading debug info from /usr/lib/debug/lib/libnss_dns-2.7.so.debug...
--22049-- Reading syms from /lib/libresolv-2.7.so (0xDBD000)
--22049-- Reading debug info from /usr/lib/debug/lib/libresolv-2.7.so.debug...
--22049-- Reading syms from /usr/lib/gconv/ISO8859-1.so (0x4264000)
--22049-- Reading debug info from /usr/lib/debug/usr/lib/gconv/ISO8859-1.so.debug...
--22049-- REDIR: 0x934110 (stpcpy) redirected to 0x40074D0 (stpcpy)
--22049-- REDIR: 0xA245D0 (__strcpy_chk) redirected to 0x40067F0 (__strcpy_chk)
--22049-- REDIR: 0x9AE330 (memmove) redirected to 0x4006670 (memmove)
--22049-- Reading syms from /usr/lib/gconv/CP1252.so (0x4267000)
--22049-- Reading debug info from /usr/lib/debug/usr/lib/gconv/CP1252.so.debug...
use test
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
TestRawODBCDirectQuery (out): ok
pass
Running test  2: Raw ODBC prepared query... TestRawODBCPreparedQuery (in)
odbctest
--------

connection parameters:
server:   'TESTSRV'
user:     'test'
password: '????'
database: 'test'
use test
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
TestRawODBCPreparedQuery (out): ok
pass
Running test  3: Raw ODBC GUID... TestRawODBCGuid (in)
odbctest
--------

connection parameters:
server:   'TESTSRV'
user:     'test'
password: '????'
database: 'test'
use test
Creating #pet table
DROP PROC GetGUIDRows
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: AB1E6727-E46D-4019-B4F7-298D8F8625CF
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       AB1E6727-E46D-4019-B4F7-298D8F8625CF
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
Woof       87654321-4321-4321-4321-123456789ABC
DROP PROC GetGUIDRows
TestRawODBCGuid (out): ok
pass

All 3 tests passed.

--22049-- Discarding syms at 0x4267000-0x426B000 in /usr/lib/gconv/CP1252.so due to munmap()
--22049-- Discarding syms at 0x4264000-0x4267000 in /usr/lib/gconv/ISO8859-1.so due to munmap()
--22049-- Discarding syms at 0x40CA000-0x40D6000 in /lib/libnss_files-2.7.so due to munmap()
--22049-- Discarding syms at 0x4272000-0x427D000 in /lib/libnss_winbind.so.2 due to munmap()
--22049-- Discarding syms at 0x40D7000-0x40DD000 in /lib/libnss_dns-2.7.so due to munmap()
--22049-- Discarding syms at 0xDBD000-0xDD1000 in /lib/libresolv-2.7.so due to munmap()
==22049== 
==22049== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 32 from 1)
--22049-- 
--22049-- supp:   32 dl-hack3
==22049== malloc/free: in use at exit: 2,028 bytes in 32 blocks.
==22049== malloc/free: 9,641 allocs, 9,609 frees, 1,452,740 bytes allocated.
==22049== 
==22049== searching for pointers to 32 not-freed blocks.
==22049== checked 228,756 bytes.
==22049== 
==22049== LEAK SUMMARY:
==22049==    definitely lost: 0 bytes in 0 blocks.
==22049==      possibly lost: 0 bytes in 0 blocks.
==22049==    still reachable: 0 bytes in 0 blocks.
==22049==         suppressed: 2,028 bytes in 32 blocks.
--22049--  memcheck: sanity checks: 43 cheap, 2 expensive
--22049--  memcheck: auxmaps: 0 auxmap entries (0k, 0M) in use
--22049--  memcheck: auxmaps: 0 searches, 0 comparisons
--22049--  memcheck: SMs: n_issued      = 54 (864k, 0M)
--22049--  memcheck: SMs: n_deissued    = 1 (16k, 0M)
--22049--  memcheck: SMs: max_noaccess  = 65535 (1048560k, 1023M)
--22049--  memcheck: SMs: max_undefined = 0 (0k, 0M)
--22049--  memcheck: SMs: max_defined   = 47 (752k, 0M)
--22049--  memcheck: SMs: max_non_DSM   = 54 (864k, 0M)
--22049--  memcheck: max sec V bit nodes:    10 (0k, 0M)
--22049--  memcheck: set_sec_vbits8 calls: 19 (new: 10, updates: 9)
--22049--  memcheck: max shadow mem size:   1168k, 1M
--22049-- translate:            fast SP updates identified: 17,265 ( 88.5%)
--22049-- translate:   generic_known SP updates identified: 1,764 (  9.0%)
--22049-- translate: generic_unknown SP updates identified: 465 (  2.3%)
--22049--     tt/tc: 40,273 tt lookups requiring 47,019 probes
--22049--     tt/tc: 40,273 fast-cache updates, 9 flushes
--22049--  transtab: new        14,918 (457,398 -> 7,210,359; ratio 157:10) [0 scs]
--22049--  transtab: dumped     0 (0 -> ??)
--22049--  transtab: discarded  908 (18,911 -> ??)
--22049-- scheduler: 4,401,013 jumps (bb entries).
--22049-- scheduler: 43/47,320 major/minor sched events.
--22049--    sanity: 44 cheap, 2 expensive checks.
--22049--    exectx: 30,011 lists, 2,596 contexts (avg 0 per list)
--22049--    exectx: 19,216 searches, 16,751 full compares (871 per 1000)
--22049--    exectx: 30 cmp2, 95 cmp4, 0 cmpAll

Main