src/dblib/unittests/t0005

Main

==1321== Memcheck, a memory error detector.
==1321== Copyright (C) 2002-2007, and GNU GPL'd, by Julian Seward et al.
==1321== Using LibVEX rev 1732, a library for dynamic binary translation.
==1321== Copyright (C) 2004-2007, and GNU GPL'd, by OpenWorks LLP.
==1321== Using valgrind-3.2.3, a dynamic binary instrumentation framework.
==1321== Copyright (C) 2000-2007, and GNU GPL'd, by Julian Seward et al.
==1321== 
--1321-- Command line
--1321--    ./t0005
--1321-- Startup, with flags:
--1321--    --tool=memcheck
--1321--    --num-callers=20
--1321--    --leak-check=yes
--1321--    -v
--1321--    --show-reachable=yes
--1321--    --log-fd=3
--1321--    --suppressions=/home/winnt/fziglio/suppressions.supp
--1321-- Contents of /proc/version:
--1321--   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
--1321-- Arch and hwcaps: X86, x86-sse1-sse2
--1321-- Page sizes: currently 4096, max supported 4096
--1321-- Valgrind library directory: /usr/lib/valgrind
--1321-- Reading syms from /lib/ld-2.7.so (0x91E000)
--1321-- Reading debug info from /usr/lib/debug/lib/ld-2.7.so.debug...
--1321-- Reading syms from /home/winnt/fziglio/cpp/freetds/ftds_comp/src/dblib/unittests/t0005 (0x8048000)
--1321-- Reading syms from /usr/lib/valgrind/x86-linux/memcheck (0x38000000)
--1321--    object doesn't have a dynamic symbol table
--1321-- Reading suppressions file: /home/winnt/fziglio/suppressions.supp
--1321-- Reading suppressions file: /usr/lib/valgrind/default.supp
--1321-- REDIR: 0x933BB0 (index) redirected to 0x38027F5F (vgPlain_x86_linux_REDIR_FOR_index)
--1321-- Reading syms from /usr/lib/valgrind/x86-linux/vgpreload_core.so (0x4001000)
--1321-- Reading syms from /usr/lib/valgrind/x86-linux/vgpreload_memcheck.so (0x4003000)
==1321== WARNING: new redirection conflicts with existing -- ignoring it
--1321--     new: 0x00933BB0 (index     ) R-> 0x04006230 index
--1321-- REDIR: 0x933D50 (strlen) redirected to 0x40062E0 (strlen)
--1321-- Reading syms from /home/winnt/fziglio/cpp/freetds/ftds_comp/src/dblib/.libs/libsybdb.so.5.0.0 (0x4009000)
--1321-- Reading syms from /lib/librt-2.7.so (0xC7D000)
--1321-- Reading debug info from /usr/lib/debug/lib/librt-2.7.so.debug...
--1321-- Reading syms from /usr/lib/libgnutls.so.13.3.0 (0x3E7C000)
--1321-- Reading debug info from /usr/lib/debug/usr/lib/libgnutls.so.13.3.0.debug...
--1321-- Reading syms from /lib/libpthread-2.7.so (0xACA000)
--1321-- Reading debug info from /usr/lib/debug/lib/libpthread-2.7.so.debug...
--1321-- Reading syms from /lib/libc-2.7.so (0x93D000)
--1321-- Reading debug info from /usr/lib/debug/lib/libc-2.7.so.debug...
--1321-- Reading syms from /lib/libz.so.1.2.3 (0xAE5000)
--1321-- Reading debug info from /usr/lib/debug/lib/libz.so.1.2.3.debug...
--1321-- Reading syms from /lib/libgcrypt.so.11.2.3 (0x3E25000)
--1321-- Reading debug info from /usr/lib/debug/lib/libgcrypt.so.11.2.3.debug...
--1321-- Reading syms from /lib/libgpg-error.so.0.3.1 (0xDB4000)
--1321-- Reading debug info from /usr/lib/debug/lib/libgpg-error.so.0.3.1.debug...
--1321-- Reading syms from /lib/libnsl-2.7.so (0x259000)
--1321-- Reading debug info from /usr/lib/debug/lib/libnsl-2.7.so.debug...
--1321-- REDIR: 0x9AE3A0 (memset) redirected to 0x4006640 (memset)
--1321-- REDIR: 0x9AE890 (memcpy) redirected to 0x4007090 (memcpy)
--1321-- REDIR: 0x9AD4C0 (rindex) redirected to 0x4006110 (rindex)
--1321-- REDIR: 0x9AD120 (strlen) redirected to 0x40062C0 (strlen)
--1321-- REDIR: 0x9A8B00 (malloc) redirected to 0x40054A0 (malloc)
--1321-- REDIR: 0x9ACBC0 (strcmp) redirected to 0x4006390 (strcmp)
--1321-- REDIR: 0x9ACC30 (strcpy) redirected to 0x40072F0 (strcpy)
--1321-- REDIR: 0x9ADEA0 (memchr) redirected to 0x40064B0 (memchr)
--1321-- REDIR: 0x9AA060 (free) redirected to 0x40050BA (free)
--
+1:found TESTSRV.test for test in "../../../PWD"
Start
1321-- REDIR: 0x9AF220 (strchrnul) redirected to 0x40066F0 (strchrnul)
--1321-- REDIR: 0x9A8810 (calloc) redirected to 0x40047CD (calloc)
--1321-- REDIR: 0x9ACA50 (index) redirected to 0x4006200 (index)
--1321-- REDIR: 0x9AD310 (strncmp) redirected to 0x4006320 (strncmp)
About to logon
About to open
--1321-- REDIR: 0x9AE400 (mempcpy) redirected to 0x4006B70 (mempcpy)
--1321-- REDIR: 0x9AE590 (stpcpy) redirected to 0x4006850 (stpcpy)
--1321-- Reading syms from /lib/libnss_files-2.7.so (0x40E4000)
--1321-- Reading debug info from /usr/lib/debug/lib/libnss_files-2.7.so.debug...
--1321-- Reading syms from /lib/libnss_winbind.so.2 (0x4210000)
--1321--    object doesn't have a symbol table
--1321-- REDIR: 0x9AD410 (strncpy) redirected to 0x4006930 (strncpy)
--1321-- REDIR: 0x9AF150 (rawmemchr) redirected to 0x4006720 (rawmemchr)
--1321-- Reading syms from /lib/libnss_dns-2.7.so (0x40F1000)
--1321-- Reading debug info from /usr/lib/debug/lib/libnss_dns-2.7.so.debug...
--1321-- Reading syms from /lib/libresolv-2.7.so (0xDBD000)
--1321-- Reading debug info from /usr/lib/debug/lib/libresolv-2.7.so.debug...
--1321-- Reading syms from /usr/lib/gconv/ISO8859-1.so (0x4202000)
--1321-- Reading debug info from /usr/lib/debug/usr/lib/gconv/ISO8859-1.so.debug...
--1321-- REDIR: 0x934110 (stpcpy) redirected to 0x40074D0 (stpcpy)
--1321-- REDIR: 0x9AC8A0 (strcat) redirected to 0x40073E0 (strcat)
--1321-- REDIR: 0xA245D0 (__strcpy_chk) redirected to 0x40067F0 (__strcpy_chk)
--1321-- REDIR: 0x9AA250 (realloc) redirected to 0x400554F (realloc)
--1321-- REDIR: 0x9AE330 (memmove) redirected to 0x4006670 (memmove)
--1321-- Reading syms from /usr/lib/gconv/CP1252.so (0x4205000)
--1321-- Reading debug info from /usr/lib/debug/usr/lib/gconv/CP1252.so.debug...
creating table
insert
select * from #dblib0005 where i < 5 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  
This query should succeeded as we have fetched exactly the
number of rows in the result set
select * from #dblib0005 where i < 6 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  
This query should fail as we have not fetched all the
rows in the result set
select * from #dblib0005 where i > 950 order by i
OK: anticipated error 20019 (Attempt to initiate a new Adaptive Server operation with results pending) arrived
calling dbcancel to flush results
Dropping proc
creating proc
create proc t0005_proc (@b int out) as
begin
select * from #dblib0005 where i < 6 order by i
select @b = 42
end

calling proc
declare @myout int exec t0005_proc @b = @myout output
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  
This next command should succeed as we have fetched exactly the.
number of rows in the result set
select getdate()
dblib okay on t0005.c
--1321-- Discarding syms at 0x4205000-0x4209000 in /usr/lib/gconv/CP1252.so due to munmap()
--1321-- Discarding syms at 0x4202000-0x4205000 in /usr/lib/gconv/ISO8859-1.so due to munmap()
--1321-- Discarding syms at 0x40E4000-0x40F0000 in /lib/libnss_files-2.7.so due to munmap()
--1321-- Discarding syms at 0x4210000-0x421B000 in /lib/libnss_winbind.so.2 due to munmap()
--1321-- Discarding syms at 0x40F1000-0x40F7000 in /lib/libnss_dns-2.7.so due to munmap()
--1321-- Discarding syms at 0xDBD000-0xDD1000 in /lib/libresolv-2.7.so due to munmap()
==1321== 
==1321== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 33 from 1)
--1321-- 
--1321-- supp:   33 dl-hack3
==1321== malloc/free: in use at exit: 2,028 bytes in 32 blocks.
==1321== malloc/free: 6,901 allocs, 6,869 frees, 636,212 bytes allocated.
==1321== 
==1321== searching for pointers to 32 not-freed blocks.
==1321== checked 254,468 bytes.
==1321== 
==1321== LEAK SUMMARY:
==1321==    definitely lost: 0 bytes in 0 blocks.
==1321==      possibly lost: 0 bytes in 0 blocks.
==1321==    still reachable: 0 bytes in 0 blocks.
==1321==         suppressed: 2,028 bytes in 32 blocks.
--1321--  memcheck: sanity checks: 24 cheap, 1 expensive
--1321--  memcheck: auxmaps: 0 auxmap entries (0k, 0M) in use
--1321--  memcheck: auxmaps: 0 searches, 0 comparisons
--1321--  memcheck: SMs: n_issued      = 44 (704k, 0M)
--1321--  memcheck: SMs: n_deissued    = 1 (16k, 0M)
--1321--  memcheck: SMs: max_noaccess  = 65535 (1048560k, 1023M)
--1321--  memcheck: SMs: max_undefined = 0 (0k, 0M)
--1321--  memcheck: SMs: max_defined   = 50 (800k, 0M)
--1321--  memcheck: SMs: max_non_DSM   = 44 (704k, 0M)
--1321--  memcheck: max sec V bit nodes:    7 (0k, 0M)
--1321--  memcheck: set_sec_vbits8 calls: 9 (new: 7, updates: 2)
--1321--  memcheck: max shadow mem size:   1008k, 0M
--1321-- translate:            fast SP updates identified: 16,491 ( 88.8%)
--1321-- translate:   generic_known SP updates identified: 1,598 (  8.6%)
--1321-- translate: generic_unknown SP updates identified: 468 (  2.5%)
--1321--     tt/tc: 33,046 tt lookups requiring 38,096 probes
--1321--     tt/tc: 33,046 fast-cache updates, 9 flushes
--1321--  transtab: new        13,801 (411,627 -> 6,494,415; ratio 157:10) [0 scs]
--1321--  transtab: dumped     0 (0 -> ??)
--1321--  transtab: discarded  890 (18,521 -> ??)
--1321-- scheduler: 2,437,620 jumps (bb entries).
--1321-- scheduler: 24/34,734 major/minor sched events.
--1321--    sanity: 25 cheap, 1 expensive checks.
--1321--    exectx: 30,011 lists, 1,094 contexts (avg 0 per list)
--1321--    exectx: 13,782 searches, 12,709 full compares (922 per 1000)
--1321--    exectx: 30 cmp2, 94 cmp4, 0 cmpAll

Main