src/dblib/unittests/t0007

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

==21661== Memcheck, a memory error detector.
==21661== Copyright (C) 2002-2007, and GNU GPL'd, by Julian Seward et al.
==21661== Using LibVEX rev 1732, a library for dynamic binary translation.
==21661== Copyright (C) 2004-2007, and GNU GPL'd, by OpenWorks LLP.
==21661== Using valgrind-3.2.3, a dynamic binary instrumentation framework.
==21661== Copyright (C) 2000-2007, and GNU GPL'd, by Julian Seward et al.
==21661== 
--21661-- Command line
--21661--    ./t0007
--21661-- Startup, with flags:
--21661--    --tool=memcheck
--21661--    --num-callers=20
--21661--    --leak-check=yes
--21661--    -v
--21661--    --show-reachable=yes
--21661--    --log-fd=3
--21661--    --suppressions=/home/winnt/fziglio/suppressions.supp
--21661-- Contents of /proc/version:
--21661--   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
--21661-- Arch and hwcaps: X86, x86-sse1-sse2
--21661-- Page sizes: currently 4096, max supported 4096
--21661-- Valgrind library directory: /usr/lib/valgrind
--21661-- Reading syms from /lib/ld-2.7.so (0x91E000)
--21661-- Reading debug info from /usr/lib/debug/lib/ld-2.7.so.debug...
--21661-- Reading syms from /home/winnt/fziglio/cpp/freetds/ftds_comp_old/src/dblib/unittests/t0007 (0x8048000)
--21661-- Reading syms from /usr/lib/valgrind/x86-linux/memcheck (0x38000000)
--21661--    object doesn't have a dynamic symbol table
--21661-- Reading suppressions file: /home/winnt/fziglio/suppressions.supp
--21661-- Reading suppressions file: /usr/lib/valgrind/default.supp
--21661-- REDIR: 0x933BB0 (index) redirected to 0x38027F5F (vgPlain_x86_linux_REDIR_FOR_index)
--21661-- Reading syms from /usr/lib/valgrind/x86-linux/vgpreload_core.so (0x4001000)
--21661-- Reading syms from /usr/lib/valgrind/x86-linux/vgpreload_memcheck.so (0x4003000)
==21661== WARNING: new redirection conflicts with existing -- ignoring it
--21661--     new: 0x00933BB0 (index     ) R-> 0x04006230 index
--21661-- REDIR: 0x933D50 (strlen) redirected to 0x40062E0 (strlen)
--21661-- Reading syms from /home/winnt/fziglio/cpp/freetds/ftds_comp_old/src/dblib/.libs/libsybdb.so.5.0.0 (0x4009000)
--21661-- Reading syms from /usr/lib/libgnutls.so.13.3.0 (0x40DB000)
--21661-- Reading debug info from /usr/lib/debug/usr/lib/libgnutls.so.13.3.0.debug...
--21661-- ... CRC mismatch (computed 812A60F5 wanted E162DD80)
--21661--    object doesn't have a symbol table
--21661-- Reading syms from /lib/libc-2.7.so (0x93D000)
--21661-- Reading debug info from /usr/lib/debug/lib/libc-2.7.so.debug...
--21661-- Reading syms from /lib/libz.so.1.2.3 (0xAE5000)
--21661-- Reading debug info from /usr/lib/debug/lib/libz.so.1.2.3.debug...
--21661-- Reading syms from /lib/libgcrypt.so.11.2.3 (0x3E25000)
--21661-- Reading debug info from /usr/lib/debug/lib/libgcrypt.so.11.2.3.debug...
--21661-- Reading syms from /lib/libgpg-error.so.0.3.1 (0xDB4000)
--21661-- Reading debug info from /usr/lib/debug/lib/libgpg-error.so.0.3.1.debug...
--21661-- Reading syms from /lib/libnsl-2.7.so (0x259000)
--21661-- Reading debug info from /usr/lib/debug/lib/libnsl-2.7.so.debug...
--21661-- REDIR: 0x9AD4C0 (rindex) redirected to 0x4006110 (rindex)
--21661-- REDIR: 0x9AD120 (strlen) redirected to 0x40062C0 (strlen)
--21661-- REDIR: 0x9A8B00 (malloc) redirected to 0x40054A0 (malloc)
--21661-- REDIR: 0x9AE890 (memcpy) redirected to 0x4007090 (memcpy)
--21661-- REDIR: 0x9ACBC0 (strcmp) redirected to 0x4006390 (strcmp)
--21661-- REDIR: 0x9ACC30 (strcpy) redirected to 0x40072F0 (strcpy)
--21661-- REDIR: 0x9ADEA0 (memchr) redirected to 0x40064B0 (memchr)
--21661-- REDIR: 0x9AA060 (free) redirected to 0x40050BA (free)
--21661-- REDIR: 0x9AF220 (strchrnul) redirected to 0x40066F0 (strchrnul)
found TESTSRV.test for test in "../../../PWD"
Start
--21661-- REDIR: 0x9A8810 (calloc) redirected to 0x40047CD (calloc)
--21661-- REDIR: 0x9AD310 (strncmp) redirected to 0x4006320 (strncmp)
About to logon
--21661-- REDIR: 0x9AE3A0 (memset) redirected to 0x4006640 (memset)
About to open
--21661-- REDIR: 0x9AE400 (mempcpy) redirected to 0x4006B70 (mempcpy)
--21661-- REDIR: 0x9AE590 (stpcpy) redirected to 0x4006850 (stpcpy)
--21661-- Reading syms from /lib/libnss_files-2.7.so (0x40C7000)
--21661-- Reading debug info from /usr/lib/debug/lib/libnss_files-2.7.so.debug...
--21661-- REDIR: 0x9ACA50 (index) redirected to 0x4006200 (index)
--21661-- Reading syms from /lib/libnss_winbind.so.2 (0x426F000)
--21661--    object doesn't have a symbol table
--21661-- REDIR: 0x9AD410 (strncpy) redirected to 0x4006930 (strncpy)
--21661-- REDIR: 0x9AF150 (rawmemchr) redirected to 0x4006720 (rawmemchr)
--21661-- Reading syms from /lib/libnss_dns-2.7.so (0x40D4000)
--21661-- Reading debug info from /usr/lib/debug/lib/libnss_dns-2.7.so.debug...
--21661-- Reading syms from /lib/libresolv-2.7.so (0xDBD000)
--21661-- Reading debug info from /usr/lib/debug/lib/libresolv-2.7.so.debug...
--21661-- Reading syms from /usr/lib/gconv/ISO8859-1.so (0x4261000)
--21661-- Reading debug info from /usr/lib/debug/usr/lib/gconv/ISO8859-1.so.debug...
--21661-- REDIR: 0x934110 (stpcpy) redirected to 0x40074D0 (stpcpy)
--21661-- REDIR: 0x9AC8A0 (strcat) redirected to 0x40073E0 (strcat)
--21661-- REDIR: 0xA245D0 (__strcpy_chk) redirected to 0x40067F0 (__strcpy_chk)
--21661-- REDIR: 0x9AA250 (realloc) redirected to 0x400554F (realloc)
--21661-- REDIR: 0x9AE330 (memmove) redirected to 0x4006670 (memmove)
--21661-- Reading syms from /usr/lib/gconv/CP1252.so (0x4264000)
--21661-- Reading debug info from /usr/lib/debug/usr/lib/gconv/CP1252.so.debug...
creating table
insert
insert into #dblib0007 values (1, 'row 0000001')
insert into #dblib0007 values (2, 'row 0000002')
insert into #dblib0007 values (3, 'row 0000003')
insert into #dblib0007 values (4, 'row 0000004')
insert into #dblib0007 values (5, 'row 0000005')
insert into #dblib0007 values (6, 'row 0000006')
insert into #dblib0007 values (7, 'row 0000007')
insert into #dblib0007 values (8, 'row 0000008')
insert into #dblib0007 values (9, 'row 0000009')
select * from #dblib0007 where i<=5 order by i
col 1 is i
col 2 is s
Read a row of data -> 1 row 0000001 
Read a row of data -> 2 row 0000002 
second select.  Should fail.
select * from #dblib0007 where i>=5 order by i
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 t0007.c
--21661-- Discarding syms at 0x4264000-0x4268000 in /usr/lib/gconv/CP1252.so due to munmap()
--21661-- Discarding syms at 0x4261000-0x4264000 in /usr/lib/gconv/ISO8859-1.so due to munmap()
--21661-- Discarding syms at 0x40C7000-0x40D3000 in /lib/libnss_files-2.7.so due to munmap()
--21661-- Discarding syms at 0x426F000-0x427A000 in /lib/libnss_winbind.so.2 due to munmap()
--21661-- Discarding syms at 0x40D4000-0x40DA000 in /lib/libnss_dns-2.7.so due to munmap()
--21661-- Discarding syms at 0xDBD000-0xDD1000 in /lib/libresolv-2.7.so due to munmap()
==21661== 
==21661== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 32 from 1)
--21661-- 
--21661-- supp:   32 dl-hack3
==21661== malloc/free: in use at exit: 2,028 bytes in 32 blocks.
==21661== malloc/free: 6,752 allocs, 6,720 frees, 625,957 bytes allocated.
==21661== 
==21661== searching for pointers to 32 not-freed blocks.
==21661== checked 220,564 bytes.
==21661== 
==21661== LEAK SUMMARY:
==21661==    definitely lost: 0 bytes in 0 blocks.
==21661==      possibly lost: 0 bytes in 0 blocks.
==21661==    still reachable: 0 bytes in 0 blocks.
==21661==         suppressed: 2,028 bytes in 32 blocks.
--21661--  memcheck: sanity checks: 22 cheap, 1 expensive
--21661--  memcheck: auxmaps: 0 auxmap entries (0k, 0M) in use
--21661--  memcheck: auxmaps: 0 searches, 0 comparisons
--21661--  memcheck: SMs: n_issued      = 40 (640k, 0M)
--21661--  memcheck: SMs: n_deissued    = 1 (16k, 0M)
--21661--  memcheck: SMs: max_noaccess  = 65535 (1048560k, 1023M)
--21661--  memcheck: SMs: max_undefined = 0 (0k, 0M)
--21661--  memcheck: SMs: max_defined   = 46 (736k, 0M)
--21661--  memcheck: SMs: max_non_DSM   = 40 (640k, 0M)
--21661--  memcheck: max sec V bit nodes:    7 (0k, 0M)
--21661--  memcheck: set_sec_vbits8 calls: 9 (new: 7, updates: 2)
--21661--  memcheck: max shadow mem size:   944k, 0M
--21661-- translate:            fast SP updates identified: 15,889 ( 88.9%)
--21661-- translate:   generic_known SP updates identified: 1,507 (  8.4%)
--21661-- translate: generic_unknown SP updates identified: 465 (  2.6%)
--21661--     tt/tc: 29,596 tt lookups requiring 34,204 probes
--21661--     tt/tc: 29,596 fast-cache updates, 9 flushes
--21661--  transtab: new        13,280 (392,731 -> 6,239,221; ratio 158:10) [0 scs]
--21661--  transtab: dumped     0 (0 -> ??)
--21661--  transtab: discarded  886 (18,472 -> ??)
--21661-- scheduler: 2,213,129 jumps (bb entries).
--21661-- scheduler: 22/31,251 major/minor sched events.
--21661--    sanity: 23 cheap, 1 expensive checks.
--21661--    exectx: 30,011 lists, 1,009 contexts (avg 0 per list)
--21661--    exectx: 13,483 searches, 12,490 full compares (926 per 1000)
--21661--    exectx: 30 cmp2, 95 cmp4, 0 cmpAll

Main