src/dblib/unittests/t0004

Main

==21637== Memcheck, a memory error detector.
==21637== Copyright (C) 2002-2007, and GNU GPL'd, by Julian Seward et al.
==21637== Using LibVEX rev 1732, a library for dynamic binary translation.
==21637== Copyright (C) 2004-2007, and GNU GPL'd, by OpenWorks LLP.
==21637== Using valgrind-3.2.3, a dynamic binary instrumentation framework.
==21637== Copyright (C) 2000-2007, and GNU GPL'd, by Julian Seward et al.
==21637== 
--21637-- Command line
--21637--    ./t0004
--21637-- Startup, with flags:
--21637--    --tool=memcheck
--21637--    --num-callers=20
--21637--    --leak-check=yes
--21637--    -v
--21637--    --show-reachable=yes
--21637--    --log-fd=3
--21637--    --suppressions=/home/winnt/fziglio/suppressions.supp
--21637-- Contents of /proc/version:
--21637--   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
--21637-- Arch and hwcaps: X86, x86-sse1-sse2
--21637-- Page sizes: currently 4096, max supported 4096
--21637-- Valgrind library directory: /usr/lib/valgrind
--21637-- Reading syms from /lib/ld-2.7.so (0x91E000)
--21637-- Reading debug info from /usr/lib/debug/lib/ld-2.7.so.debug...
--21637-- Reading syms from /home/winnt/fziglio/cpp/freetds/ftds_comp_old/src/dblib/unittests/t0004 (0x8048000)
--21637-- Reading syms from /usr/lib/valgrind/x86-linux/memcheck (0x38000000)
--21637--    object doesn't have a dynamic symbol table
--21637-- Reading suppressions file: /home/winnt/fziglio/suppressions.supp
--21637-- Reading suppressions file: /usr/lib/valgrind/default.supp
--21637-- REDIR: 0x933BB0 (index) redirected to 0x38027F5F (vgPlain_x86_linux_REDIR_FOR_index)
--21637-- Reading syms from /usr/lib/valgrind/x86-linux/vgpreload_core.so (0x4001000)
--21637-- Reading syms from /usr/lib/valgrind/x86-linux/vgpreload_memcheck.so (0x4003000)
==21637== WARNING: new redirection conflicts with existing -- ignoring it
--21637--     new: 0x00933BB0 (index     ) R-> 0x04006230 index
--21637-- REDIR: 0x933D50 (strlen) redirected to 0x40062E0 (strlen)
--21637-- Reading syms from /home/winnt/fziglio/cpp/freetds/ftds_comp_old/src/dblib/.libs/libsybdb.so.5.0.0 (0x4009000)
--21637-- Reading syms from /usr/lib/libgnutls.so.13.3.0 (0x40DB000)
--21637-- Reading debug info from /usr/lib/debug/usr/lib/libgnutls.so.13.3.0.debug...
--21637-- ... CRC mismatch (computed 812A60F5 wanted E162DD80)
--21637--    object doesn't have a symbol table
--21637-- Reading syms from /lib/libc-2.7.so (0x93D000)
--21637-- Reading debug info from /usr/lib/debug/lib/libc-2.7.so.debug...
--21637-- Reading syms from /lib/libz.so.1.2.3 (0xAE5000)
--21637-- Reading debug info from /usr/lib/debug/lib/libz.so.1.2.3.debug...
--21637-- Reading syms from /lib/libgcrypt.so.11.2.3 (0x3E25000)
--21637-- Reading debug info from /usr/lib/debug/lib/libgcrypt.so.11.2.3.debug...
--21637-- Reading syms from /lib/libgpg-error.so.0.3.1 (0xDB4000)
--21637-- Reading debug info from /usr/lib/debug/lib/libgpg-error.so.0.3.1.debug...
--21637-- Reading syms from /lib/libnsl-2.7.so (0x259000)
--21637-- Reading debug info from /usr/lib/debug/lib/libnsl-2.7.so.debug...
--21637-- REDIR: 0x9AD4C0 (rindex) redirected to 0x4006110 (rindex)
--21637-- REDIR: 0x9AD120 (strlen) redirected to 0x40062C0 (strlen)
--21637-- REDIR: 0x9A8B00 (malloc) redirected to 0x40054A0 (malloc)
--21637-- REDIR: 0x9AE890 (memcpy) redirected to 0x4007090 (memcpy)
--21637-- REDIR: 0x9ACBC0 (strcmp) redirected to 0x4006390 (strcmp)
--21637-- REDIR: 0x9ACC30 (strcpy) redirected to 0x40072F0 (strcpy)
--21637-- REDIR: 0x9ADEA0 (memchr) redirected to 0x40064B0 (memchr)
--21637-- REDIR: 0x9AA060 (free) redirected to 0x40050BA (free)
--21637-- REDIR: 0x9AF220 (strchrnul) redirected to 0x40066F0 (strchrnul)
found TESTSRV.test for test in "../../../PWD"
Start
--21637-- REDIR: 0x9A8810 (calloc) redirected to 0x40047CD (calloc)
--21637-- REDIR: 0x9AD310 (strncmp) redirected to 0x4006320 (strncmp)
About to logon
--21637-- REDIR: 0x9AE3A0 (memset) redirected to 0x4006640 (memset)
About to open
--21637-- REDIR: 0x9AE400 (mempcpy) redirected to 0x4006B70 (mempcpy)
--21637-- REDIR: 0x9AE590 (stpcpy) redirected to 0x4006850 (stpcpy)
--21637-- Reading syms from /lib/libnss_files-2.7.so (0x40C7000)
--21637-- Reading debug info from /usr/lib/debug/lib/libnss_files-2.7.so.debug...
--21637-- REDIR: 0x9ACA50 (index) redirected to 0x4006200 (index)
--21637-- Reading syms from /lib/libnss_winbind.so.2 (0x426F000)
--21637--    object doesn't have a symbol table
--21637-- REDIR: 0x9AD410 (strncpy) redirected to 0x4006930 (strncpy)
--21637-- REDIR: 0x9AF150 (rawmemchr) redirected to 0x4006720 (rawmemchr)
--21637-- Reading syms from /lib/libnss_dns-2.7.so (0x40D4000)
--21637-- Reading debug info from /usr/lib/debug/lib/libnss_dns-2.7.so.debug...
--21637-- Reading syms from /lib/libresolv-2.7.so (0xDBD000)
--21637-- Reading debug info from /usr/lib/debug/lib/libresolv-2.7.so.debug...
--21637-- Reading syms from /usr/lib/gconv/ISO8859-1.so (0x4261000)
--21637-- Reading debug info from /usr/lib/debug/usr/lib/gconv/ISO8859-1.so.debug...
--21637-- REDIR: 0x934110 (stpcpy) redirected to 0x40074D0 (stpcpy)
--21637-- REDIR: 0x9AC8A0 (strcat) redirected to 0x40073E0 (strcat)
--21637-- REDIR: 0xA245D0 (__strcpy_chk) redirected to 0x40067F0 (__strcpy_chk)
--21637-- REDIR: 0x9AA250 (realloc) redirected to 0x400554F (realloc)
--21637-- REDIR: 0x9AE330 (memmove) redirected to 0x4006670 (memmove)
--21637-- Reading syms from /usr/lib/gconv/CP1252.so (0x4264000)
--21637-- Reading debug info from /usr/lib/debug/usr/lib/gconv/CP1252.so.debug...
creating table
insert
insert into #dblib0004 values (1, 'row 0001')
insert into #dblib0004 values (2, 'row 0002')
insert into #dblib0004 values (3, 'row 0003')
insert into #dblib0004 values (4, 'row 0004')
insert into #dblib0004 values (5, 'row 0005')
insert into #dblib0004 values (6, 'row 0006')
insert into #dblib0004 values (7, 'row 0007')
insert into #dblib0004 values (8, 'row 0008')
insert into #dblib0004 values (9, 'row 0009')
insert into #dblib0004 values (10, 'row 0010')
insert into #dblib0004 values (11, 'row 0011')
insert into #dblib0004 values (12, 'row 0012')
insert into #dblib0004 values (13, 'row 0013')
insert into #dblib0004 values (14, 'row 0014')
insert into #dblib0004 values (15, 'row 0015')
insert into #dblib0004 values (16, 'row 0016')
insert into #dblib0004 values (17, 'row 0017')
insert into #dblib0004 values (18, 'row 0018')
insert into #dblib0004 values (19, 'row 0019')
insert into #dblib0004 values (20, 'row 0020')
insert into #dblib0004 values (21, 'row 0021')
insert into #dblib0004 values (22, 'row 0022')
insert into #dblib0004 values (23, 'row 0023')
insert into #dblib0004 values (24, 'row 0024')
insert into #dblib0004 values (25, 'row 0025')
insert into #dblib0004 values (26, 'row 0026')
insert into #dblib0004 values (27, 'row 0027')
insert into #dblib0004 values (28, 'row 0028')
insert into #dblib0004 values (29, 'row 0029')
insert into #dblib0004 values (30, 'row 0030')
insert into #dblib0004 values (31, 'row 0031')
insert into #dblib0004 values (32, 'row 0032')
insert into #dblib0004 values (33, 'row 0033')
insert into #dblib0004 values (34, 'row 0034')
insert into #dblib0004 values (35, 'row 0035')
insert into #dblib0004 values (36, 'row 0036')
insert into #dblib0004 values (37, 'row 0037')
insert into #dblib0004 values (38, 'row 0038')
insert into #dblib0004 values (39, 'row 0039')
insert into #dblib0004 values (40, 'row 0040')
insert into #dblib0004 values (41, 'row 0041')
insert into #dblib0004 values (42, 'row 0042')
insert into #dblib0004 values (43, 'row 0043')
insert into #dblib0004 values (44, 'row 0044')
insert into #dblib0004 values (45, 'row 0045')
insert into #dblib0004 values (46, 'row 0046')
insert into #dblib0004 values (47, 'row 0047')
insert into #dblib0004 values (48, 'row 0048')
insert into #dblib0004 values (49, 'row 0049')
select * from #dblib0004 where i<=25 order by i
col 1 is i
col 2 is s
Read a row of data -> 1 row 0001  
Read a row of data -> 2 row 0002  
Read a row of data -> 3 row 0003  
Read a row of data -> 4 row 0004  
Read a row of data -> 5 row 0005  
Read a row of data -> 6 row 0006  
Read a row of data -> 7 row 0007  
Read a row of data -> 8 row 0008  
Read a row of data -> 9 row 0009  
Read a row of data -> 10 row 0010  
Read a row of data -> 11 row 0011  
Read a row of data -> 12 row 0012  
Read a row of data -> 13 row 0013  
Read a row of data -> 14 row 0014  
Read a row of data -> 15 row 0015  
Read a row of data -> 16 row 0016  
Read a row of data -> 17 row 0017  
Read a row of data -> 18 row 0018  
Read a row of data -> 19 row 0019  
Read a row of data -> 20 row 0020  
Read a row of data -> 21 row 0021  
Read a row of data -> 22 row 0022  
Read a row of data -> 23 row 0023  
Read a row of data -> 24 row 0024  
second select
select * from #dblib0004 where i>950 order by i
About to exec for the second time.  Should fail
DB-LIBRARY error (severity 7, dberr 20019, oserr 0, dberrstr Attempt to initiate a new Adaptive Server operation with results pending, oserrstr Success):
dblib okay on t0004.c
--21637-- Discarding syms at 0x4264000-0x4268000 in /usr/lib/gconv/CP1252.so due to munmap()
--21637-- Discarding syms at 0x4261000-0x4264000 in /usr/lib/gconv/ISO8859-1.so due to munmap()
--21637-- Discarding syms at 0x40C7000-0x40D3000 in /lib/libnss_files-2.7.so due to munmap()
--21637-- Discarding syms at 0x426F000-0x427A000 in /lib/libnss_winbind.so.2 due to munmap()
--21637-- Discarding syms at 0x40D4000-0x40DA000 in /lib/libnss_dns-2.7.so due to munmap()
--21637-- Discarding syms at 0xDBD000-0xDD1000 in /lib/libresolv-2.7.so due to munmap()
==21637== 
==21637== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 32 from 1)
--21637-- 
--21637-- supp:   32 dl-hack3
==21637== malloc/free: in use at exit: 2,028 bytes in 32 blocks.
==21637== malloc/free: 6,902 allocs, 6,870 frees, 629,484 bytes allocated.
==21637== 
==21637== searching for pointers to 32 not-freed blocks.
==21637== checked 220,564 bytes.
==21637== 
==21637== LEAK SUMMARY:
==21637==    definitely lost: 0 bytes in 0 blocks.
==21637==      possibly lost: 0 bytes in 0 blocks.
==21637==    still reachable: 0 bytes in 0 blocks.
==21637==         suppressed: 2,028 bytes in 32 blocks.
--21637--  memcheck: sanity checks: 23 cheap, 1 expensive
--21637--  memcheck: auxmaps: 0 auxmap entries (0k, 0M) in use
--21637--  memcheck: auxmaps: 0 searches, 0 comparisons
--21637--  memcheck: SMs: n_issued      = 40 (640k, 0M)
--21637--  memcheck: SMs: n_deissued    = 1 (16k, 0M)
--21637--  memcheck: SMs: max_noaccess  = 65535 (1048560k, 1023M)
--21637--  memcheck: SMs: max_undefined = 0 (0k, 0M)
--21637--  memcheck: SMs: max_defined   = 46 (736k, 0M)
--21637--  memcheck: SMs: max_non_DSM   = 40 (640k, 0M)
--21637--  memcheck: max sec V bit nodes:    7 (0k, 0M)
--21637--  memcheck: set_sec_vbits8 calls: 9 (new: 7, updates: 2)
--21637--  memcheck: max shadow mem size:   944k, 0M
--21637-- translate:            fast SP updates identified: 15,878 ( 88.9%)
--21637-- translate:   generic_known SP updates identified: 1,505 (  8.4%)
--21637-- translate: generic_unknown SP updates identified: 462 (  2.5%)
--21637--     tt/tc: 30,385 tt lookups requiring 35,152 probes
--21637--     tt/tc: 30,385 fast-cache updates, 9 flushes
--21637--  transtab: new        13,280 (392,957 -> 6,240,175; ratio 158:10) [0 scs]
--21637--  transtab: dumped     0 (0 -> ??)
--21637--  transtab: discarded  886 (18,472 -> ??)
--21637-- scheduler: 2,356,065 jumps (bb entries).
--21637-- scheduler: 23/32,920 major/minor sched events.
--21637--    sanity: 24 cheap, 1 expensive checks.
--21637--    exectx: 30,011 lists, 1,009 contexts (avg 0 per list)
--21637--    exectx: 13,783 searches, 12,797 full compares (928 per 1000)
--21637--    exectx: 30 cmp2, 95 cmp4, 0 cmpAll

Main