src/dblib/unittests/t0004

Main

==1570== Memcheck, a memory error detector.
==1570== Copyright (C) 2002-2007, and GNU GPL'd, by Julian Seward et al.
==1570== Using LibVEX rev 1732, a library for dynamic binary translation.
==1570== Copyright (C) 2004-2007, and GNU GPL'd, by OpenWorks LLP.
==1570== Using valgrind-3.2.3, a dynamic binary instrumentation framework.
==1570== Copyright (C) 2000-2007, and GNU GPL'd, by Julian Seward et al.
==1570== 
--1570-- Command line
--1570--    ./t0004
--1570-- Startup, with flags:
--1570--    --tool=memcheck
--1570--    --num-callers=20
--1570--    --leak-check=yes
--1570--    -v
--1570--    --show-reachable=yes
--1570--    --log-fd=3
--1570--    --suppressions=/home/winnt/fziglio/suppressions.supp
--1570-- Contents of /proc/version:
--1570--   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
--1570-- Arch and hwcaps: X86, x86-sse1-sse2
--1570-- Page sizes: currently 4096, max supported 4096
--1570-- Valgrind library directory: /usr/lib/valgrind
--1570-- Reading syms from /lib/ld-2.7.so (0x91E000)
--1570-- Reading debug info from /usr/lib/debug/lib/ld-2.7.so.debug...
--1570-- Reading syms from /home/winnt/fziglio/cpp/freetds/ftds_comp/src/dblib/unittests/t0004 (0x8048000)
--1570-- Reading syms from /usr/lib/valgrind/x86-linux/memcheck (0x38000000)
--1570--    object doesn't have a dynamic symbol table
--1570-- Reading suppressions file: /home/winnt/fziglio/suppressions.supp
--1570-- Reading suppressions file: /usr/lib/valgrind/default.supp
--1570-- REDIR: 0x933BB0 (index) redirected to 0x38027F5F (vgPlain_x86_linux_REDIR_FOR_index)
--1570-- Reading syms from /usr/lib/valgrind/x86-linux/vgpreload_core.so (0x4001000)
--1570-- Reading syms from /usr/lib/valgrind/x86-linux/vgpreload_memcheck.so (0x4003000)
==1570== WARNING: new redirection conflicts with existing -- ignoring it
--1570--     new: 0x00933BB0 (index     ) R-> 0x04006230 index
--1570-- REDIR: 0x933D50 (strlen) redirected to 0x40062E0 (strlen)
--1570-- Reading syms from /home/winnt/fziglio/cpp/freetds/ftds_comp/src/dblib/.libs/libsybdb.so.5.0.0 (0x4009000)
--1570-- Reading syms from /lib/librt-2.7.so (0xC7D000)
--1570-- Reading debug info from /usr/lib/debug/lib/librt-2.7.so.debug...
--1570-- Reading syms from /usr/lib/libgnutls.so.13.3.0 (0x3E7C000)
--1570-- Reading debug info from /usr/lib/debug/usr/lib/libgnutls.so.13.3.0.debug...
--1570-- Reading syms from /lib/libpthread-2.7.so (0xACA000)
--1570-- Reading debug info from /usr/lib/debug/lib/libpthread-2.7.so.debug...
--1570-- Reading syms from /lib/libc-2.7.so (0x93D000)
--1570-- Reading debug info from /usr/lib/debug/lib/libc-2.7.so.debug...
--1570-- Reading syms from /lib/libz.so.1.2.3 (0xAE5000)
--1570-- Reading debug info from /usr/lib/debug/lib/libz.so.1.2.3.debug...
--1570-- Reading syms from /lib/libgcrypt.so.11.2.3 (0x3E25000)
--1570-- Reading debug info from /usr/lib/debug/lib/libgcrypt.so.11.2.3.debug...
--1570-- Reading syms from /lib/libgpg-error.so.0.3.1 (0xDB4000)
--1570-- Reading debug info from /usr/lib/debug/lib/libgpg-error.so.0.3.1.debug...
--1570-- Reading syms from /lib/libnsl-2.7.so (0x259000)
--1570-- Reading debug info from /usr/lib/debug/lib/libnsl-2.7.so.debug...
--1570-- REDIR: 0x9AE3A0 (memset) redirected to 0x4006640 (memset)
--1570-- REDIR: 0x9AE890 (memcpy) redirected to 0x4007090 (memcpy)
--1570-- REDIR: 0x9AD4C0 (rindex) redirected to 0x4006110 (rindex)
--1570-- REDIR: 0x9AD120 (strlen) redirected to 0x40062C0 (strlen)
--1570-- REDIR: 0x9A8B00 (malloc) redirected to 0x40054A0 (malloc)
--1570-- REDIR: 0x9ACBC0 (strcmp) redirected to 0x4006390 (strcmp)
--1570-- REDIR: 0x9ACC30 (strcpy) redirected to 0x40072F0 (strcpy)
--1570-- REDIR: 0x9ADEA0 (memchr) redirected to 0x40064B0 (memchr)
--1570-- REDIR: 0x9AA060 (free) redirected to 0x40050BA (free)
--1570-- REDIR: 0x9AF220 (strchrnul) redirected to 0x40066F0 (strchrnul)
found sybase15.tempdb for sa in "../../../PWD"
Start
--1570-- REDIR: 0x9A8810 (calloc) redirected to 0x40047CD (calloc)
--1570-- REDIR: 0x9ACA50 (index) redirected to 0x4006200 (index)
--1570-- REDIR: 0x9AD310 (strncmp) redirected to 0x4006320 (strncmp)
About to logon
About to open
--1570-- REDIR: 0x9AE400 (mempcpy) redirected to 0x4006B70 (mempcpy)
--1570-- REDIR: 0x9AE590 (stpcpy) redirected to 0x4006850 (stpcpy)
--1570-- Reading syms from /lib/libnss_files-2.7.so (0x40E4000)
--1570-- Reading debug info from /usr/lib/debug/lib/libnss_files-2.7.so.debug...
--1570-- Reading syms from /lib/libnss_winbind.so.2 (0x4210000)
--1570--    object doesn't have a symbol table
--1570-- REDIR: 0x9AD410 (strncpy) redirected to 0x4006930 (strncpy)
--1570-- REDIR: 0x9AF150 (rawmemchr) redirected to 0x4006720 (rawmemchr)
--1570-- Reading syms from /usr/lib/gconv/ISO8859-1.so (0x41FB000)
--1570-- Reading debug info from /usr/lib/debug/usr/lib/gconv/ISO8859-1.so.debug...
--1570-- REDIR: 0x934110 (stpcpy) redirected to 0x40074D0 (stpcpy)
--1570-- REDIR: 0x9AA250 (realloc) redirected to 0x400554F (realloc)
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
OK: anticipated error 20019 (Attempt to initiate a new Adaptive Server operation with results pending) arrived
dblib okay on t0004.c
--1570-- Discarding syms at 0x41FB000-0x41FE000 in /usr/lib/gconv/ISO8859-1.so due to munmap()
--1570-- Discarding syms at 0x40E4000-0x40F0000 in /lib/libnss_files-2.7.so due to munmap()
--1570-- Discarding syms at 0x4210000-0x421B000 in /lib/libnss_winbind.so.2 due to munmap()
==1570== 
==1570== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 28 from 1)
--1570-- 
--1570-- supp:   28 dl-hack3
==1570== malloc/free: in use at exit: 4 bytes in 1 blocks.
==1570== malloc/free: 380 allocs, 379 frees, 210,649 bytes allocated.
==1570== 
==1570== searching for pointers to 1 not-freed blocks.
==1570== checked 252,444 bytes.
==1570== 
==1570== LEAK SUMMARY:
==1570==    definitely lost: 0 bytes in 0 blocks.
==1570==      possibly lost: 0 bytes in 0 blocks.
==1570==    still reachable: 0 bytes in 0 blocks.
==1570==         suppressed: 4 bytes in 1 blocks.
--1570--  memcheck: sanity checks: 8 cheap, 1 expensive
--1570--  memcheck: auxmaps: 0 auxmap entries (0k, 0M) in use
--1570--  memcheck: auxmaps: 0 searches, 0 comparisons
--1570--  memcheck: SMs: n_issued      = 29 (464k, 0M)
--1570--  memcheck: SMs: n_deissued    = 0 (0k, 0M)
--1570--  memcheck: SMs: max_noaccess  = 65535 (1048560k, 1023M)
--1570--  memcheck: SMs: max_undefined = 0 (0k, 0M)
--1570--  memcheck: SMs: max_defined   = 49 (784k, 0M)
--1570--  memcheck: SMs: max_non_DSM   = 29 (464k, 0M)
--1570--  memcheck: max sec V bit nodes:    4 (0k, 0M)
--1570--  memcheck: set_sec_vbits8 calls: 4 (new: 4, updates: 0)
--1570--  memcheck: max shadow mem size:   768k, 0M
--1570-- translate:            fast SP updates identified: 9,232 ( 89.0%)
--1570-- translate:   generic_known SP updates identified: 863 (  8.3%)
--1570-- translate: generic_unknown SP updates identified: 274 (  2.6%)
--1570--     tt/tc: 16,867 tt lookups requiring 18,086 probes
--1570--     tt/tc: 16,867 fast-cache updates, 6 flushes
--1570--  transtab: new        7,628 (208,772 -> 3,318,466; ratio 158:10) [0 scs]
--1570--  transtab: dumped     0 (0 -> ??)
--1570--  transtab: discarded  362 (7,290 -> ??)
--1570-- scheduler: 882,286 jumps (bb entries).
--1570-- scheduler: 8/11,288 major/minor sched events.
--1570--    sanity: 9 cheap, 1 expensive checks.
--1570--    exectx: 30,011 lists, 282 contexts (avg 0 per list)
--1570--    exectx: 772 searches, 492 full compares (637 per 1000)
--1570--    exectx: 0 cmp2, 85 cmp4, 0 cmpAll

Main