src/dblib/unittests/t0023

Main

Hostnamekrb5.freetds.io
uname -aLinux krb5.freetds.io 4.15.0-112-generic #113-Ubuntu SMP Thu Jul 9 23:41:39 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux
date2020-07-22

==13030== Memcheck, a memory error detector
==13030== Copyright (C) 2002-2017, and GNU GPL'd, by Julian Seward et al.
==13030== Using Valgrind-3.13.0 and LibVEX; rerun with -h for copyright info
==13030== Command: ./t0023
==13030== 
--13030-- Valgrind options:
--13030--    --tool=memcheck
--13030--    --vgdb=no
--13030--    --num-callers=20
--13030--    --leak-check=yes
--13030--    -v
--13030--    --show-reachable=yes
--13030--    --log-fd=3
--13030--    --suppressions=/home/test/suppressions.supp
--13030--    --track-origins=yes
--13030-- Contents of /proc/version:
--13030--   Linux version 4.15.0-112-generic (buildd@lcy01-amd64-027) (gcc version 7.5.0 (Ubuntu 7.5.0-3ubuntu1~18.04)) #113-Ubuntu SMP Thu Jul 9 23:41:39 UTC 2020
--13030-- 
--13030-- Arch and hwcaps: AMD64, LittleEndian, amd64-cx16-lzcnt-rdtscp-sse3-avx-avx2-bmi
--13030-- Page sizes: currently 4096, max supported 4096
--13030-- Valgrind library directory: /usr/lib/valgrind
--13030-- Reading syms from /home/test/ftdstmp/ftds_comp99/test5/src/dblib/unittests/t0023
--13030-- Reading syms from /lib/x86_64-linux-gnu/ld-2.27.so
--13030--   Considering /lib/x86_64-linux-gnu/ld-2.27.so ..
--13030--   .. CRC mismatch (computed ac9397f6 wanted d0d82632)
--13030--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/ld-2.27.so ..
--13030--   .. CRC is valid
--13030-- Reading syms from /usr/lib/valgrind/memcheck-amd64-linux
--13030--   Considering /usr/lib/valgrind/memcheck-amd64-linux ..
--13030--   .. CRC mismatch (computed 41ddb025 wanted 9972f546)
--13030--    object doesn't have a symbol table
--13030--    object doesn't have a dynamic symbol table
--13030-- Scheduler: using generic scheduler lock implementation.
--13030-- Reading suppressions file: /home/test/suppressions.supp
--13030-- Reading suppressions file: /usr/lib/valgrind/default.supp
--13030-- REDIR: 0x401f320 (ld-linux-x86-64.so.2:strlen) redirected to 0x580608c1 (???)
--13030-- REDIR: 0x401f100 (ld-linux-x86-64.so.2:index) redirected to 0x580608db (???)
--13030-- Reading syms from /usr/lib/valgrind/vgpreload_core-amd64-linux.so
--13030--   Considering /usr/lib/valgrind/vgpreload_core-amd64-linux.so ..
--13030--   .. CRC mismatch (computed 50df1b30 wanted 4800a4cf)
--13030--    object doesn't have a symbol table
--13030-- Reading syms from /usr/lib/valgrind/vgpreload_memcheck-amd64-linux.so
--13030--   Considering /usr/lib/valgrind/vgpreload_memcheck-amd64-linux.so ..
--13030--   .. CRC mismatch (computed f893b962 wanted 95ee359e)
--13030--    object doesn't have a symbol table
==13030== WARNING: new redirection conflicts with existing -- ignoring it
--13030--     old: 0x0401f320 (strlen              ) R-> (0000.0) 0x580608c1 ???
--13030--     new: 0x0401f320 (strlen              ) R-> (2007.0) 0x04c32db0 strlen
--13030-- REDIR: 0x401d390 (ld-linux-x86-64.so.2:strcmp) redirected to 0x4c33ee0 (strcmp)
--13030-- REDIR: 0x401f860 (ld-linux-x86-64.so.2:mempcpy) redirected to 0x4c374f0 (mempcpy)
--13030-- Reading syms from /home/test/ftdstmp/ftds_comp99/src/dblib/.libs/libsybdb.so.5.1.0
--13030-- Reading syms from /lib/x86_64-linux-gnu/libpthread-2.27.so
--13030--   Considering /usr/lib/debug/.build-id/bc/3c06107774266c5f7db3f1f380a3da68af90fa.debug ..
--13030--   .. build-id is valid
--13030-- Reading syms from /lib/x86_64-linux-gnu/libc-2.27.so
--13030--   Considering /lib/x86_64-linux-gnu/libc-2.27.so ..
--13030--   .. CRC mismatch (computed c2c067b2 wanted d73adc7f)
--13030--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libc-2.27.so ..
--13030--   .. CRC is valid
--13030-- Reading syms from /usr/lib/x86_64-linux-gnu/libgssapi_krb5.so.2.2
--13030--    object doesn't have a symbol table
--13030-- Reading syms from /usr/lib/x86_64-linux-gnu/libssl.so.1.1
--13030--    object doesn't have a symbol table
--13030-- Reading syms from /usr/lib/x86_64-linux-gnu/libcrypto.so.1.1
--13030--    object doesn't have a symbol table
--13030-- Reading syms from /usr/lib/x86_64-linux-gnu/libkrb5.so.3.3
--13030--    object doesn't have a symbol table
--13030-- Reading syms from /usr/lib/x86_64-linux-gnu/libk5crypto.so.3.1
--13030--    object doesn't have a symbol table
--13030-- Reading syms from /lib/x86_64-linux-gnu/libcom_err.so.2.1
--13030--    object doesn't have a symbol table
--13030-- Reading syms from /usr/lib/x86_64-linux-gnu/libkrb5support.so.0.1
--13030--    object doesn't have a symbol table
--13030-- Reading syms from /lib/x86_64-linux-gnu/libdl-2.27.so
--13030--   Considering /lib/x86_64-linux-gnu/libdl-2.27.so ..
--13030--   .. CRC mismatch (computed 415bd007 wanted 4d6f4a12)
--13030--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libdl-2.27.so ..
--13030--   .. CRC is valid
--13030-- Reading syms from /lib/x86_64-linux-gnu/libkeyutils.so.1.5
--13030--    object doesn't have a symbol table
--13030-- Reading syms from /lib/x86_64-linux-gnu/libresolv-2.27.so
--13030--   Considering /lib/x86_64-linux-gnu/libresolv-2.27.so ..
--13030--   .. CRC mismatch (computed 5df7bac0 wanted a9fc7e1b)
--13030--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libresolv-2.27.so ..
--13030--   .. CRC is valid
--13030-- REDIR: 0x53ccce0 (libc.so.6:memmove) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53cbdb0 (libc.so.6:strncpy) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53ccfc0 (libc.so.6:strcasecmp) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53cb800 (libc.so.6:strcat) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53cbde0 (libc.so.6:rindex) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53ce830 (libc.so.6:rawmemchr) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53cce50 (libc.so.6:mempcpy) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53ccc80 (libc.so.6:bcmp) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53cbd70 (libc.so.6:strncmp) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53cb870 (libc.so.6:strcmp) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53ccdb0 (libc.so.6:memset) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53ea160 (libc.so.6:wcschr) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53cbd10 (libc.so.6:strnlen) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53cb8e0 (libc.so.6:strcspn) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53cd010 (libc.so.6:strncasecmp) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53cb8b0 (libc.so.6:strcpy) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53cd150 (libc.so.6:memcpy@@GLIBC_2.14) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53cbe10 (libc.so.6:strpbrk) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53cb830 (libc.so.6:index) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53cbce0 (libc.so.6:strlen) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53d6730 (libc.so.6:memrchr) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53cd060 (libc.so.6:strcasecmp_l) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53ccc50 (libc.so.6:memchr) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53eaf20 (libc.so.6:wcslen) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53cc0c0 (libc.so.6:strspn) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53ccf90 (libc.so.6:stpncpy) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53ccf60 (libc.so.6:stpcpy) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53ce860 (libc.so.6:strchrnul) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53cd0b0 (libc.so.6:strncasecmp_l) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x545fa50 (libc.so.6:__memcpy_chk) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x53ccb90 (libc.so.6:strstr) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--13030-- REDIR: 0x54bc630 (libc.so.6:__strrchr_avx2) redirected to 0x4c32730 (rindex)
--13030-- REDIR: 0x54bc800 (libc.so.6:__strlen_avx2) redirected to 0x4c32cf0 (strlen)
--13030-- REDIR: 0x53c59c0 (libc.so.6:free) redirected to 0x4c30cd0 (free)
--13030-- REDIR: 0x53c50e0 (libc.so.6:malloc) redirected to 0x4c2faa0 (malloc)
--13030-- REDIR: 0x54bcd40 (libc.so.6:__memcpy_avx_unaligned_erms) redirected to 0x4c366e0 (memmove)
--13030-- REDIR: 0x54a9bc0 (libc.so.6:__strcpy_ssse3) redirected to 0x4c32dd0 (strcpy)
--13030-- REDIR: 0x54b3780 (libc.so.6:__strncmp_sse42) redirected to 0x4c33570 (__strncmp_sse42)
--13030-- REDIR: 0x53cc600 (libc.so.6:__GI_strstr) redirected to 0x4c37760 (__strstr_sse2)
--13030-- REDIR: 0x54b8690 (libc.so.6:__memchr_avx2) redirected to 0x4c33f80 (memchr)
--13030-- REDIR: 0x54b8570 (libc.so.6:__strspn_sse42) redirected to 0x4c37990 (strspn)
--13030-- REDIR: 0x54b82e0 (libc.so.6:__strcspn_sse42) redirected to 0x4c378d0 (strcspn)
--13030-- REDIR: 0x54bc440 (libc.so.6:__strchrnul_avx2) redirected to 0x4c37020 (strchrnul)
found msde_pool.tempdb for sa in "../../../PWD"
--13030-- REDIR: 0x54bcd20 (libc.so.6:__mempcpy_avx_unaligned_erms) redirected to 0x4c37130 (mempcpy)
SQL text will be read from ../../../src/dblib/unittests/t0023.sql
Starting ./t0023
--13030-- REDIR: 0x53c80a0 (libc.so.6:calloc) redirected to 0x4c31a70 (calloc)
--13030-- REDIR: 0x54bc210 (libc.so.6:__strchr_avx2) redirected to 0x4c32950 (index)
--13030-- REDIR: 0x54b91f0 (libc.so.6:__strcasecmp_avx) redirected to 0x4c335f0 (strcasecmp)
About to logon
--13030-- REDIR: 0x54bd1c0 (libc.so.6:__memset_avx2_unaligned_erms) redirected to 0x4c365d0 (memset)
About to open
--13030-- REDIR: 0x5497fd0 (libc.so.6:__strcmp_ssse3) redirected to 0x4c33da0 (strcmp)
--13030-- REDIR: 0x54adef0 (libc.so.6:__stpcpy_ssse3) redirected to 0x4c35f60 (stpcpy)
--13030-- Reading syms from /lib/x86_64-linux-gnu/libnss_compat-2.27.so
--13030--   Considering /lib/x86_64-linux-gnu/libnss_compat-2.27.so ..
--13030--   .. CRC mismatch (computed 241d2060 wanted 0ba25da4)
--13030--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnss_compat-2.27.so ..
--13030--   .. CRC is valid
--13030-- Reading syms from /lib/x86_64-linux-gnu/libnss_nis-2.27.so
--13030--   Considering /lib/x86_64-linux-gnu/libnss_nis-2.27.so ..
--13030--   .. CRC mismatch (computed 875fb728 wanted 2943766f)
--13030--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnss_nis-2.27.so ..
--13030--   .. CRC is valid
--13030-- Reading syms from /lib/x86_64-linux-gnu/libnsl-2.27.so
--13030--   Considering /lib/x86_64-linux-gnu/libnsl-2.27.so ..
--13030--   .. CRC mismatch (computed 93b0c290 wanted 14481eb5)
--13030--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnsl-2.27.so ..
--13030--   .. CRC is valid
--13030-- Reading syms from /lib/x86_64-linux-gnu/libnss_files-2.27.so
--13030--   Considering /lib/x86_64-linux-gnu/libnss_files-2.27.so ..
--13030--   .. CRC mismatch (computed 72e2d53a wanted a4e6b9c7)
--13030--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnss_files-2.27.so ..
--13030--   .. CRC is valid
--13030-- REDIR: 0x53c6ca0 (libc.so.6:realloc) redirected to 0x4c31cb0 (realloc)
--13030-- Reading syms from /usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so
--13030--   Considering /usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so ..
--13030--   .. CRC mismatch (computed edeae576 wanted 1f1a58be)
--13030--   Considering /usr/lib/debug/usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so ..
--13030--   .. CRC is valid
--13030-- REDIR: 0x54b8e10 (libc.so.6:__memcmp_avx2_movbe) redirected to 0x4c35e00 (bcmp)
--13030-- Reading syms from /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so
--13030--   Considering /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so ..
--13030--   .. CRC mismatch (computed 1eb5c892 wanted 19fb5cdc)
--13030--   Considering /usr/lib/debug/usr/lib/x86_64-linux-gnu/gconv/UTF-16.so ..
--13030--   .. CRC is valid
--13030-- Reading syms from /usr/lib/x86_64-linux-gnu/gconv/CP1252.so
--13030--   Considering /usr/lib/x86_64-linux-gnu/gconv/CP1252.so ..
--13030--   .. CRC mismatch (computed 2e94fa02 wanted 9746c51f)
--13030--   Considering /usr/lib/debug/usr/lib/x86_64-linux-gnu/gconv/CP1252.so ..
--13030--   .. CRC is valid
	  1: select name from sysobjects where name = 'missing' compute max(name)
creating table
	  1: create table #dblib0023 (col1 int not null,  col2 char(1) not null, col3 datetime not null)
insert
	  1: insert into #dblib0023 values (1, 'A', 'Jan  1 2002 10:00:00AM')
	  1: insert into #dblib0023 values (2, 'A', 'Jan  2 2002 10:00:00AM')
	  1: insert into #dblib0023 values (3, 'A', 'Jan  3 2002 10:00:00AM')
	  1: insert into #dblib0023 values (8, 'B', 'Jan  4 2002 10:00:00AM')
	  1: insert into #dblib0023 values (9, 'B', 'Jan  5 2002 10:00:00AM')
select
	  1: select col1, col2, col3 from #dblib0023 order by col2 compute sum(col1) by col2 compute max(col3)
col 1 is col1
col 2 is col2
col 3 is col3
binding row columns
testing compute clause 1
testing compute clause 2
gotten a regular row
gotten a regular row
gotten a regular row
gotten a compute row for clause 1
value of sum(col1) = 6
gotten a regular row
gotten a regular row
gotten a compute row for clause 1
value of sum(col1) = 17
gotten a compute row for clause 2
value of max(col3) = Jan  5 2002 10:00:00:000AM
--13030-- Discarding syms at 0x7e41710-0x7e4325b in /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so due to munmap()
t0023.c OK
--13030-- Discarding syms at 0x8045600-0x8046508 in /usr/lib/x86_64-linux-gnu/gconv/CP1252.so due to munmap()
--13030-- Discarding syms at 0x7c3e600-0x7c3f292 in /usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so due to munmap()
--13030-- Discarding syms at 0x73fd2a0-0x74031ac in /lib/x86_64-linux-gnu/libnss_compat-2.27.so due to munmap()
--13030-- Discarding syms at 0x7608070-0x760f0d9 in /lib/x86_64-linux-gnu/libnss_nis-2.27.so due to munmap()
--13030-- Discarding syms at 0x7816090-0x78238a7 in /lib/x86_64-linux-gnu/libnsl-2.27.so due to munmap()
--13030-- Discarding syms at 0x7a2e350-0x7a34d8f in /lib/x86_64-linux-gnu/libnss_files-2.27.so due to munmap()
==13030== 
==13030== HEAP SUMMARY:
==13030==     in use at exit: 0 bytes in 0 blocks
==13030==   total heap usage: 434 allocs, 434 frees, 1,128,245 bytes allocated
==13030== 
==13030== All heap blocks were freed -- no leaks are possible
==13030== 
==13030== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 0 from 0)
==13030== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 0 from 0)

Main