src/dblib/unittests/null

Main

==31218== Memcheck, a memory error detector.
==31218== Copyright (C) 2002-2006, and GNU GPL'd, by Julian Seward et al.
==31218== Using LibVEX rev 1658, a library for dynamic binary translation.
==31218== Copyright (C) 2004-2006, and GNU GPL'd, by OpenWorks LLP.
==31218== Using valgrind-3.2.1, a dynamic binary instrumentation framework.
==31218== Copyright (C) 2000-2006, and GNU GPL'd, by Julian Seward et al.
==31218== 
--31218-- Command line
--31218--    ./null
--31218-- Startup, with flags:
--31218--    --tool=memcheck
--31218--    --num-callers=20
--31218--    --leak-check=yes
--31218--    -v
--31218--    --show-reachable=yes
--31218--    --log-fd=3
--31218--    --suppressions=/home/winnt/fziglio/suppressions.supp
--31218-- Contents of /proc/version:
--31218--   Linux version 2.6.23.1-1smp (fziglio@obon110) (gcc version 4.1.2 20070626 (Red Hat 4.1.2-13)) #3 SMP Mon Nov 5 20:51:48 CET 2007
--31218-- Arch and hwcaps: X86, x86-sse1-sse2
--31218-- Valgrind library directory: /usr/lib/valgrind
--31218-- Reading syms from /lib/ld-2.5.so (0xAE4000)
--31218-- Reading syms from /home/winnt/fziglio/cpp/freetds/ftds_comp_old/src/dblib/unittests/null (0x8048000)
--31218-- Reading syms from /usr/lib/valgrind/x86-linux/memcheck (0x38000000)
--31218--    object doesn't have a dynamic symbol table
--31218-- Reading suppressions file: /home/winnt/fziglio/suppressions.supp
--31218-- Reading suppressions file: /usr/lib/valgrind/default.supp
--31218-- REDIR: 0xAF9540 (index) redirected to 0x38027D0F (vgPlain_x86_linux_REDIR_FOR_index)
--31218-- Reading syms from /usr/lib/valgrind/x86-linux/vgpreload_core.so (0x4001000)
--31218-- Reading syms from /usr/lib/valgrind/x86-linux/vgpreload_memcheck.so (0x4003000)
==31218== WARNING: new redirection conflicts with existing -- ignoring it
--31218--     new: 0x00AF9540 (index     ) R-> 0x040060C0 index
--31218-- REDIR: 0xAF96E0 (strlen) redirected to 0x4006290 (strlen)
--31218-- Reading syms from /home/winnt/fziglio/cpp/freetds/ftds_comp_old/src/dblib/.libs/libsybdb.so.5.0.0 (0x4009000)
--31218-- Reading syms from /usr/lib/libgnutls.so.13.0.6 (0x6A2D000)
--31218--    object doesn't have a symbol table
--31218-- Reading syms from /lib/libc-2.5.so (0xB29000)
--31218-- Reading syms from /usr/lib/libz.so.1.2.3 (0xB14000)
--31218--    object doesn't have a symbol table
--31218-- Reading syms from /usr/lib/libgcrypt.so.11.2.2 (0x65F1000)
--31218--    object doesn't have a symbol table
--31218-- Reading syms from /usr/lib/libgpg-error.so.0.3.0 (0xADB000)
--31218--    object doesn't have a symbol table
--31218-- Reading syms from /lib/libnsl-2.5.so (0x330000)
--31218-- REDIR: 0xB96330 (rindex) redirected to 0x4005FA0 (rindex)
--31218-- REDIR: 0xB95F90 (strlen) redirected to 0x4006270 (strlen)
--31218-- REDIR: 0xB91260 (malloc) redirected to 0x400537B (malloc)
--31218-- REDIR: 0xB976C0 (memcpy) redirected to 0x4006C60 (memcpy)
--31218-- REDIR: 0xB95A30 (strcmp) redirected to 0x4006340 (strcmp)
--31218-- REDIR: 0xB95AA0 (strcpy) redirected to 0x40069F0 (strcpy)
--31218-- REDIR: 0xB96CD0 (memchr) redirected to 0x4006460 (memchr)
--31218-- REDIR: 0xB92F20 (free) redirected to 0x4004F95 (free)
found sybase.FreeTDS for testuser in "../../../PWD"
Start
--31218-- REDIR: 0xB90F60 (calloc) redirected to 0x40046A8 (calloc)
--31218-- REDIR: 0xB96180 (strncmp) redirected to 0x40062D0 (strncmp)
About to logon
--31218-- REDIR: 0xB971D0 (memset) redirected to 0x4006580 (memset)
About to open "sybase"
--31218-- REDIR: 0xB98040 (strchrnul) redirected to 0x4006610 (strchrnul)
--31218-- REDIR: 0xB973C0 (stpcpy) redirected to 0x4006910 (stpcpy)
--31218-- Reading syms from /lib/libnss_files-2.5.so (0x40C8000)
--31218-- REDIR: 0xB958C0 (index) redirected to 0x4006090 (index)
--31218-- Reading syms from /lib/libnss_winbind.so.2 (0x41ED000)
--31218--    object doesn't have a symbol table
--31218-- REDIR: 0xB96280 (strncpy) redirected to 0x4006DE0 (strncpy)
--31218-- REDIR: 0xB97F70 (rawmemchr) redirected to 0x4006640 (rawmemchr)
--31218-- Reading syms from /usr/lib/gconv/ISO8859-1.so (0x40D3000)
--31218--    object doesn't have a symbol table
--31218-- REDIR: 0xAF9AA0 (stpcpy) redirected to 0x4006830 (stpcpy)
--31218-- REDIR: 0xB93110 (realloc) redirected to 0x400542A (realloc)
query: drop table #null
Msg 3701, Level 11, State 1
Server 'OBOT602P', Line 1
Cannot drop the table '#null', because it doesn't exist in the system catalogs.

create table #null (n int, c VARCHAR(10) NULL)
query: insert into #null values(1, '')
query: insert into #null values(2, NULL)
query: insert into #null values(3, ' ')
query: insert into #null values(4, 'a')
Unexpected result for n == 1 len 1 data 0x410c770
query: drop table #null
query: drop table #null
Msg 3701, Level 11, State 1
Server 'OBOT602P', Line 1
Cannot drop the table '#null', because it doesn't exist in the system catalogs.

create table #null (n int, c TEXT NULL)
query: insert into #null values(1, '')
query: insert into #null values(2, NULL)
query: insert into #null values(3, ' ')
query: insert into #null values(4, 'a')
Unexpected result for n == 1 len 1 data 0x410eab8
query: drop table #null
query: drop table #null
Msg 3701, Level 11, State 1
Server 'OBOT602P', Line 1
Cannot drop the table '#null', because it doesn't exist in the system catalogs.

create table #null (n int, c NVARCHAR(10) NULL)
query: insert into #null values(1, '')
query: insert into #null values(2, NULL)
query: insert into #null values(3, ' ')
query: insert into #null values(4, 'a')
Unexpected result for n == 1 len 1 data 0x4110dd8
query: drop table #null
query: drop table #null
Msg 3701, Level 11, State 1
Server 'OBOT602P', Line 1
Cannot drop the table '#null', because it doesn't exist in the system catalogs.

create table #null (n int, c NTEXT NULL)
Msg 2715, Level 16, State 1
Server 'OBOT602P', Line 1
Can't find type 'NTEXT'.

query: drop table #null
Msg 3701, Level 11, State 1
Server 'OBOT602P', Line 1
Cannot drop the table '#null', because it doesn't exist in the system catalogs.

create table #null (n int, c VARCHAR(MAX) NULL)
Msg 156, Level 15, State 2
Server 'OBOT602P', Line 1
Incorrect syntax near the keyword 'MAX'.

query: drop table #null
Msg 3701, Level 11, State 1
Server 'OBOT602P', Line 1
Cannot drop the table '#null', because it doesn't exist in the system catalogs.

create table #null (n int, c NVARCHAR(MAX) NULL)
Msg 156, Level 15, State 2
Server 'OBOT602P', Line 1
Incorrect syntax near the keyword 'MAX'.

--31218-- Discarding syms at 0x40D3000-0x40D6000 in /usr/lib/gconv/ISO8859-1.so due to munmap()
--31218-- Discarding syms at 0x40C8000-0x40D3000 in /lib/libnss_files-2.5.so due to munmap()
--31218-- Discarding syms at 0x41ED000-0x41F8000 in /lib/libnss_winbind.so.2 due to munmap()
==31218== 
==31218== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 25 from 1)
--31218-- 
--31218-- supp:   25 Fedora-Core-6-hack3-ld25
==31218== malloc/free: in use at exit: 4 bytes in 1 blocks.
==31218== malloc/free: 439 allocs, 438 frees, 225,481 bytes allocated.
==31218== 
==31218== searching for pointers to 1 not-freed blocks.
==31218== checked 222,572 bytes.
==31218== 
==31218== LEAK SUMMARY:
==31218==    definitely lost: 0 bytes in 0 blocks.
==31218==      possibly lost: 0 bytes in 0 blocks.
==31218==    still reachable: 0 bytes in 0 blocks.
==31218==         suppressed: 4 bytes in 1 blocks.
--31218--  memcheck: sanity checks: 7 cheap, 1 expensive
--31218--  memcheck: auxmaps: 0 auxmap entries (0k, 0M) in use
--31218--  memcheck: auxmaps: 0 searches, 0 comparisons
--31218--  memcheck: SMs: n_issued      = 26 (416k, 0M)
--31218--  memcheck: SMs: n_deissued    = 0 (0k, 0M)
--31218--  memcheck: SMs: max_noaccess  = 65535 (1048560k, 1023M)
--31218--  memcheck: SMs: max_undefined = 0 (0k, 0M)
--31218--  memcheck: SMs: max_defined   = 42 (672k, 0M)
--31218--  memcheck: SMs: max_non_DSM   = 26 (416k, 0M)
--31218--  memcheck: max sec V bit nodes:    4 (0k, 0M)
--31218--  memcheck: set_sec_vbits8 calls: 4 (new: 4, updates: 0)
--31218--  memcheck: max shadow mem size:   720k, 0M
--31218-- translate:            fast SP updates identified: 9,016 ( 89.4%)
--31218-- translate:   generic_known SP updates identified: 803 (  7.9%)
--31218-- translate: generic_unknown SP updates identified: 264 (  2.6%)
--31218--     tt/tc: 15,967 tt lookups requiring 16,819 probes
--31218--     tt/tc: 15,967 fast-cache updates, 6 flushes
--31218--  transtab: new        7,251 (197,085 -> 3,209,092; ratio 162:10) [0 scs]
--31218--  transtab: dumped     0 (0 -> ??)
--31218--  transtab: discarded  353 (7,025 -> ??)
--31218-- scheduler: 742,760 jumps (bb entries).
--31218-- scheduler: 7/10,980 major/minor sched events.
--31218--    sanity: 8 cheap, 1 expensive checks.
--31218--    exectx: 30,011 lists, 686 contexts (avg 0 per list)
--31218--    exectx: 862 searches, 184 full compares (213 per 1000)
--31218--    exectx: 0 cmp2, 73 cmp4, 0 cmpAll

Main