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

==2981== Memcheck, a memory error detector
==2981== Copyright (C) 2002-2017, and GNU GPL'd, by Julian Seward et al.
==2981== Using Valgrind-3.13.0 and LibVEX; rerun with -h for copyright info
==2981== Command: ./t0023
==2981== 
--2981-- Valgrind options:
--2981--    --tool=memcheck
--2981--    --vgdb=no
--2981--    --num-callers=20
--2981--    --leak-check=yes
--2981--    -v
--2981--    --show-reachable=yes
--2981--    --log-fd=3
--2981--    --suppressions=/home/test/suppressions.supp
--2981--    --track-origins=yes
--2981-- Contents of /proc/version:
--2981--   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
--2981-- 
--2981-- Arch and hwcaps: AMD64, LittleEndian, amd64-cx16-lzcnt-rdtscp-sse3-avx-avx2-bmi
--2981-- Page sizes: currently 4096, max supported 4096
--2981-- Valgrind library directory: /usr/lib/valgrind
--2981-- Reading syms from /home/test/ftdstmp/ftds_comp99m/test5/src/dblib/unittests/t0023
--2981-- Reading syms from /lib/x86_64-linux-gnu/ld-2.27.so
--2981--   Considering /lib/x86_64-linux-gnu/ld-2.27.so ..
--2981--   .. CRC mismatch (computed ac9397f6 wanted d0d82632)
--2981--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/ld-2.27.so ..
--2981--   .. CRC is valid
--2981-- Reading syms from /usr/lib/valgrind/memcheck-amd64-linux
--2981--   Considering /usr/lib/valgrind/memcheck-amd64-linux ..
--2981--   .. CRC mismatch (computed 41ddb025 wanted 9972f546)
--2981--    object doesn't have a symbol table
--2981--    object doesn't have a dynamic symbol table
--2981-- Scheduler: using generic scheduler lock implementation.
--2981-- Reading suppressions file: /home/test/suppressions.supp
--2981-- Reading suppressions file: /usr/lib/valgrind/default.supp
--2981-- REDIR: 0x401f320 (ld-linux-x86-64.so.2:strlen) redirected to 0x580608c1 (???)
--2981-- REDIR: 0x401f100 (ld-linux-x86-64.so.2:index) redirected to 0x580608db (???)
--2981-- Reading syms from /usr/lib/valgrind/vgpreload_core-amd64-linux.so
--2981--   Considering /usr/lib/valgrind/vgpreload_core-amd64-linux.so ..
--2981--   .. CRC mismatch (computed 50df1b30 wanted 4800a4cf)
--2981--    object doesn't have a symbol table
--2981-- Reading syms from /usr/lib/valgrind/vgpreload_memcheck-amd64-linux.so
--2981--   Considering /usr/lib/valgrind/vgpreload_memcheck-amd64-linux.so ..
--2981--   .. CRC mismatch (computed f893b962 wanted 95ee359e)
--2981--    object doesn't have a symbol table
==2981== WARNING: new redirection conflicts with existing -- ignoring it
--2981--     old: 0x0401f320 (strlen              ) R-> (0000.0) 0x580608c1 ???
--2981--     new: 0x0401f320 (strlen              ) R-> (2007.0) 0x04c32db0 strlen
--2981-- REDIR: 0x401d390 (ld-linux-x86-64.so.2:strcmp) redirected to 0x4c33ee0 (strcmp)
--2981-- REDIR: 0x401f860 (ld-linux-x86-64.so.2:mempcpy) redirected to 0x4c374f0 (mempcpy)
--2981-- Reading syms from /home/test/ftdstmp/ftds_comp99m/src/dblib/.libs/libsybdb.so.5.1.0
--2981-- Reading syms from /lib/x86_64-linux-gnu/libpthread-2.27.so
--2981--   Considering /usr/lib/debug/.build-id/bc/3c06107774266c5f7db3f1f380a3da68af90fa.debug ..
--2981--   .. build-id is valid
--2981-- Reading syms from /lib/x86_64-linux-gnu/libc-2.27.so
--2981--   Considering /lib/x86_64-linux-gnu/libc-2.27.so ..
--2981--   .. CRC mismatch (computed c2c067b2 wanted d73adc7f)
--2981--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libc-2.27.so ..
--2981--   .. CRC is valid
--2981-- Reading syms from /usr/lib/x86_64-linux-gnu/libhogweed.so.4.4
--2981--    object doesn't have a symbol table
--2981-- Reading syms from /usr/lib/x86_64-linux-gnu/libgssapi_krb5.so.2.2
--2981--    object doesn't have a symbol table
--2981-- Reading syms from /usr/lib/x86_64-linux-gnu/libgnutls.so.30.14.10
--2981--    object doesn't have a symbol table
--2981-- Reading syms from /usr/lib/x86_64-linux-gnu/libnettle.so.6.4
--2981--    object doesn't have a symbol table
--2981-- Reading syms from /usr/lib/x86_64-linux-gnu/libgmp.so.10.3.2
--2981--    object doesn't have a symbol table
--2981-- Reading syms from /usr/lib/x86_64-linux-gnu/libkrb5.so.3.3
--2981--    object doesn't have a symbol table
--2981-- Reading syms from /usr/lib/x86_64-linux-gnu/libk5crypto.so.3.1
--2981--    object doesn't have a symbol table
--2981-- Reading syms from /lib/x86_64-linux-gnu/libcom_err.so.2.1
--2981--    object doesn't have a symbol table
--2981-- Reading syms from /usr/lib/x86_64-linux-gnu/libkrb5support.so.0.1
--2981--    object doesn't have a symbol table
--2981-- Reading syms from /lib/x86_64-linux-gnu/libz.so.1.2.11
--2981--    object doesn't have a symbol table
--2981-- Reading syms from /usr/lib/x86_64-linux-gnu/libp11-kit.so.0.3.0
--2981--    object doesn't have a symbol table
--2981-- Reading syms from /usr/lib/x86_64-linux-gnu/libidn2.so.0.3.3
--2981--    object doesn't have a symbol table
--2981-- Reading syms from /usr/lib/x86_64-linux-gnu/libunistring.so.2.1.0
--2981--    object doesn't have a symbol table
--2981-- Reading syms from /usr/lib/x86_64-linux-gnu/libtasn1.so.6.5.5
--2981--    object doesn't have a symbol table
--2981-- Reading syms from /lib/x86_64-linux-gnu/libkeyutils.so.1.5
--2981--    object doesn't have a symbol table
--2981-- Reading syms from /lib/x86_64-linux-gnu/libresolv-2.27.so
--2981--   Considering /lib/x86_64-linux-gnu/libresolv-2.27.so ..
--2981--   .. CRC mismatch (computed 5df7bac0 wanted a9fc7e1b)
--2981--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libresolv-2.27.so ..
--2981--   .. CRC is valid
--2981-- Reading syms from /lib/x86_64-linux-gnu/libdl-2.27.so
--2981--   Considering /lib/x86_64-linux-gnu/libdl-2.27.so ..
--2981--   .. CRC mismatch (computed 415bd007 wanted 4d6f4a12)
--2981--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libdl-2.27.so ..
--2981--   .. CRC is valid
--2981-- Reading syms from /usr/lib/x86_64-linux-gnu/libffi.so.6.0.4
--2981--    object doesn't have a symbol table
--2981-- REDIR: 0x53cdce0 (libc.so.6:memmove) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53ccdb0 (libc.so.6:strncpy) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53cdfc0 (libc.so.6:strcasecmp) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53cc800 (libc.so.6:strcat) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53ccde0 (libc.so.6:rindex) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53cf830 (libc.so.6:rawmemchr) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53cde50 (libc.so.6:mempcpy) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53cdc80 (libc.so.6:bcmp) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53ccd70 (libc.so.6:strncmp) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53cc870 (libc.so.6:strcmp) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53cddb0 (libc.so.6:memset) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53eb160 (libc.so.6:wcschr) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53ccd10 (libc.so.6:strnlen) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53cc8e0 (libc.so.6:strcspn) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53ce010 (libc.so.6:strncasecmp) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53cc8b0 (libc.so.6:strcpy) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53ce150 (libc.so.6:memcpy@@GLIBC_2.14) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53cce10 (libc.so.6:strpbrk) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53cc830 (libc.so.6:index) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53ccce0 (libc.so.6:strlen) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53d7730 (libc.so.6:memrchr) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53ce060 (libc.so.6:strcasecmp_l) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53cdc50 (libc.so.6:memchr) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53ebf20 (libc.so.6:wcslen) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53cd0c0 (libc.so.6:strspn) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53cdf90 (libc.so.6:stpncpy) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53cdf60 (libc.so.6:stpcpy) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53cf860 (libc.so.6:strchrnul) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53ce0b0 (libc.so.6:strncasecmp_l) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x53ccd40 (libc.so.6:strncat) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x5460a50 (libc.so.6:__memcpy_chk) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x5460b20 (libc.so.6:__memmove_chk) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
==2981== WARNING: new redirection conflicts with existing -- ignoring it
--2981--     old: 0x054bdd30 (__memcpy_chk_avx_una) R-> (2030.0) 0x04c375e0 __memcpy_chk
--2981--     new: 0x054bdd30 (__memcpy_chk_avx_una) R-> (2024.0) 0x04c36fa0 __memmove_chk
--2981-- REDIR: 0x53cdb90 (libc.so.6:strstr) redirected to 0x4a2a6e0 (_vgnU_ifunc_wrapper)
--2981-- REDIR: 0x54bd630 (libc.so.6:__strrchr_avx2) redirected to 0x4c32730 (rindex)
--2981-- REDIR: 0x54bd800 (libc.so.6:__strlen_avx2) redirected to 0x4c32cf0 (strlen)
--2981-- REDIR: 0x53c60e0 (libc.so.6:malloc) redirected to 0x4c2faa0 (malloc)
--2981-- REDIR: 0x54bdd40 (libc.so.6:__memcpy_avx_unaligned_erms) redirected to 0x4c366e0 (memmove)
--2981-- REDIR: 0x5498fd0 (libc.so.6:__strcmp_ssse3) redirected to 0x4c33da0 (strcmp)
--2981-- REDIR: 0x53c90a0 (libc.so.6:calloc) redirected to 0x4c31a70 (calloc)
--2981-- REDIR: 0x54bd210 (libc.so.6:__strchr_avx2) redirected to 0x4c32950 (index)
--2981-- REDIR: 0x54bdd30 (libc.so.6:__memcpy_chk_avx_unaligned_erms) redirected to 0x4c375e0 (__memcpy_chk)
--2981-- REDIR: 0x53c69c0 (libc.so.6:free) redirected to 0x4c30cd0 (free)
--2981-- REDIR: 0x54aabc0 (libc.so.6:__strcpy_ssse3) redirected to 0x4c32dd0 (strcpy)
--2981-- REDIR: 0x54b4780 (libc.so.6:__strncmp_sse42) redirected to 0x4c33570 (__strncmp_sse42)
--2981-- REDIR: 0x53cd600 (libc.so.6:__GI_strstr) redirected to 0x4c37760 (__strstr_sse2)
--2981-- REDIR: 0x54b9690 (libc.so.6:__memchr_avx2) redirected to 0x4c33f80 (memchr)
--2981-- REDIR: 0x54b9570 (libc.so.6:__strspn_sse42) redirected to 0x4c37990 (strspn)
--2981-- REDIR: 0x54b92e0 (libc.so.6:__strcspn_sse42) redirected to 0x4c378d0 (strcspn)
--2981-- REDIR: 0x54bd440 (libc.so.6:__strchrnul_avx2) redirected to 0x4c37020 (strchrnul)
found msde_pool.tempdb for sa in "../../../PWD"
--2981-- REDIR: 0x54bdd20 (libc.so.6:__mempcpy_avx_unaligned_erms) redirected to 0x4c37130 (mempcpy)
SQL text will be read from ../../../src/dblib/unittests/t0023.sql
Starting ./t0023
--2981-- REDIR: 0x54ba1f0 (libc.so.6:__strcasecmp_avx) redirected to 0x4c335f0 (strcasecmp)
About to logon
--2981-- REDIR: 0x54be1c0 (libc.so.6:__memset_avx2_unaligned_erms) redirected to 0x4c365d0 (memset)
About to open
--2981-- REDIR: 0x54aeef0 (libc.so.6:__stpcpy_ssse3) redirected to 0x4c35f60 (stpcpy)
--2981-- Reading syms from /lib/x86_64-linux-gnu/libnss_compat-2.27.so
--2981--   Considering /lib/x86_64-linux-gnu/libnss_compat-2.27.so ..
--2981--   .. CRC mismatch (computed 241d2060 wanted 0ba25da4)
--2981--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnss_compat-2.27.so ..
--2981--   .. CRC is valid
--2981-- Reading syms from /lib/x86_64-linux-gnu/libnss_nis-2.27.so
--2981--   Considering /lib/x86_64-linux-gnu/libnss_nis-2.27.so ..
--2981--   .. CRC mismatch (computed 875fb728 wanted 2943766f)
--2981--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnss_nis-2.27.so ..
--2981--   .. CRC is valid
--2981-- Reading syms from /lib/x86_64-linux-gnu/libnsl-2.27.so
--2981--   Considering /lib/x86_64-linux-gnu/libnsl-2.27.so ..
--2981--   .. CRC mismatch (computed 93b0c290 wanted 14481eb5)
--2981--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnsl-2.27.so ..
--2981--   .. CRC is valid
--2981-- Reading syms from /lib/x86_64-linux-gnu/libnss_files-2.27.so
--2981--   Considering /lib/x86_64-linux-gnu/libnss_files-2.27.so ..
--2981--   .. CRC mismatch (computed 72e2d53a wanted a4e6b9c7)
--2981--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnss_files-2.27.so ..
--2981--   .. CRC is valid
--2981-- REDIR: 0x53c7ca0 (libc.so.6:realloc) redirected to 0x4c31cb0 (realloc)
--2981-- Reading syms from /usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so
--2981--   Considering /usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so ..
--2981--   .. CRC mismatch (computed edeae576 wanted 1f1a58be)
--2981--   Considering /usr/lib/debug/usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so ..
--2981--   .. CRC is valid
--2981-- REDIR: 0x54b9e10 (libc.so.6:__memcmp_avx2_movbe) redirected to 0x4c35e00 (bcmp)
--2981-- Reading syms from /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so
--2981--   Considering /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so ..
--2981--   .. CRC mismatch (computed 1eb5c892 wanted 19fb5cdc)
--2981--   Considering /usr/lib/debug/usr/lib/x86_64-linux-gnu/gconv/UTF-16.so ..
--2981--   .. CRC is valid
--2981-- Reading syms from /usr/lib/x86_64-linux-gnu/gconv/CP1252.so
--2981--   Considering /usr/lib/x86_64-linux-gnu/gconv/CP1252.so ..
--2981--   .. CRC mismatch (computed 2e94fa02 wanted 9746c51f)
--2981--   Considering /usr/lib/debug/usr/lib/x86_64-linux-gnu/gconv/CP1252.so ..
--2981--   .. 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
--2981-- Discarding syms at 0x903d710-0x903f25b in /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so due to munmap()
t0023.c OK
--2981-- Discarding syms at 0x9241600-0x9242508 in /usr/lib/x86_64-linux-gnu/gconv/CP1252.so due to munmap()
--2981-- Discarding syms at 0x8e3a600-0x8e3b292 in /usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so due to munmap()
--2981-- Discarding syms at 0x85f92a0-0x85ff1ac in /lib/x86_64-linux-gnu/libnss_compat-2.27.so due to munmap()
--2981-- Discarding syms at 0x8804070-0x880b0d9 in /lib/x86_64-linux-gnu/libnss_nis-2.27.so due to munmap()
--2981-- Discarding syms at 0x8a12090-0x8a1f8a7 in /lib/x86_64-linux-gnu/libnsl-2.27.so due to munmap()
--2981-- Discarding syms at 0x8c2a350-0x8c30d8f in /lib/x86_64-linux-gnu/libnss_files-2.27.so due to munmap()
==2981== 
==2981== HEAP SUMMARY:
==2981==     in use at exit: 0 bytes in 0 blocks
==2981==   total heap usage: 1,756 allocs, 1,756 frees, 1,241,657 bytes allocated
==2981== 
==2981== All heap blocks were freed -- no leaks are possible
==2981== 
==2981== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 0 from 0)
==2981== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 0 from 0)

Main