src/odbc/unittests/mars1

Main

Hostnamefreddy
uname -aLinux freddy 4.13.0-25-generic #29-Ubuntu SMP Mon Jan 8 21:14:41 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
date2018-02-18

==19872== Memcheck, a memory error detector
==19872== Copyright (C) 2002-2015, and GNU GPL'd, by Julian Seward et al.
==19872== Using Valgrind-3.12.0 and LibVEX; rerun with -h for copyright info
==19872== Command: ./mars1
==19872== 
--19872-- Valgrind options:
--19872--    --tool=memcheck
--19872--    --vgdb=no
--19872--    --num-callers=20
--19872--    --leak-check=yes
--19872--    -v
--19872--    --show-reachable=yes
--19872--    --log-fd=3
--19872--    --suppressions=/home/freddy/suppressions.supp
--19872--    --track-origins=yes
--19872-- Contents of /proc/version:
--19872--   Linux version 4.13.0-25-generic (buildd@lgw01-amd64-039) (gcc version 7.2.0 (Ubuntu 7.2.0-8ubuntu3)) #29-Ubuntu SMP Mon Jan 8 21:14:41 UTC 2018
--19872-- 
--19872-- Arch and hwcaps: AMD64, LittleEndian, amd64-cx16-lzcnt-rdtscp-sse3-avx-avx2-bmi
--19872-- Page sizes: currently 4096, max supported 4096
--19872-- Valgrind library directory: /home/freddy/install/lib/valgrind
--19872-- Reading syms from /home/freddy/ftdstmp/ftds_comp99m/test4/src/odbc/unittests/mars1
--19872-- Reading syms from /lib/x86_64-linux-gnu/ld-2.26.so
--19872--   Considering /lib/x86_64-linux-gnu/ld-2.26.so ..
--19872--   .. CRC mismatch (computed 89c8df08 wanted 47b839f9)
--19872--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/ld-2.26.so ..
--19872--   .. CRC is valid
--19872-- Reading syms from /home/freddy/install/lib/valgrind/memcheck-amd64-linux
--19872--    object doesn't have a dynamic symbol table
--19872-- Scheduler: using generic scheduler lock implementation.
--19872-- Reading suppressions file: /home/freddy/suppressions.supp
--19872-- Reading suppressions file: /home/freddy/install/lib/valgrind/default.supp
--19872-- REDIR: 0x401f860 (ld-linux-x86-64.so.2:strlen) redirected to 0x380a60c1 (vgPlain_amd64_linux_REDIR_FOR_strlen)
--19872-- REDIR: 0x401f640 (ld-linux-x86-64.so.2:index) redirected to 0x380a60db (vgPlain_amd64_linux_REDIR_FOR_index)
--19872-- Reading syms from /home/freddy/install/lib/valgrind/vgpreload_core-amd64-linux.so
--19872-- Reading syms from /home/freddy/install/lib/valgrind/vgpreload_memcheck-amd64-linux.so
==19872== WARNING: new redirection conflicts with existing -- ignoring it
--19872--     old: 0x0401f860 (strlen              ) R-> (0000.0) 0x380a60c1 vgPlain_amd64_linux_REDIR_FOR_strlen
--19872--     new: 0x0401f860 (strlen              ) R-> (2007.0) 0x04c32c60 strlen
--19872-- REDIR: 0x401d8d0 (ld-linux-x86-64.so.2:strcmp) redirected to 0x4c33d60 (strcmp)
--19872-- REDIR: 0x401fda0 (ld-linux-x86-64.so.2:mempcpy) redirected to 0x4c37130 (mempcpy)
--19872-- Reading syms from /home/freddy/ftdstmp/ftds_comp99m/src/odbc/.libs/libtdsodbc.so.0.0.0
--19872-- Reading syms from /lib/x86_64-linux-gnu/libpthread-2.26.so
--19872--   Considering /usr/lib/debug/.build-id/b9/5ecb6ece407081730183e686ff6cf2e0bce4f6.debug ..
--19872--   .. build-id is valid
--19872-- Reading syms from /lib/x86_64-linux-gnu/libc-2.26.so
--19872--   Considering /lib/x86_64-linux-gnu/libc-2.26.so ..
--19872--   .. CRC mismatch (computed b6c34c34 wanted f79829d1)
--19872--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libc-2.26.so ..
--19872--   .. CRC is valid
--19872-- Reading syms from /usr/lib/x86_64-linux-gnu/libhogweed.so.4.3
--19872--    object doesn't have a symbol table
--19872-- Reading syms from /usr/lib/x86_64-linux-gnu/libgssapi_krb5.so.2.2
--19872--    object doesn't have a symbol table
--19872-- Reading syms from /usr/lib/x86_64-linux-gnu/libgnutls.so.30.13.1
--19872--    object doesn't have a symbol table
--19872-- Reading syms from /usr/lib/x86_64-linux-gnu/libnettle.so.6.3
--19872--    object doesn't have a symbol table
--19872-- Reading syms from /usr/lib/x86_64-linux-gnu/libgmp.so.10.3.2
--19872--    object doesn't have a symbol table
--19872-- Reading syms from /usr/lib/x86_64-linux-gnu/libkrb5.so.3.3
--19872--    object doesn't have a symbol table
--19872-- Reading syms from /usr/lib/x86_64-linux-gnu/libk5crypto.so.3.1
--19872--    object doesn't have a symbol table
--19872-- Reading syms from /lib/x86_64-linux-gnu/libcom_err.so.2.1
--19872--    object doesn't have a symbol table
--19872-- Reading syms from /usr/lib/x86_64-linux-gnu/libkrb5support.so.0.1
--19872--    object doesn't have a symbol table
--19872-- Reading syms from /lib/x86_64-linux-gnu/libz.so.1.2.11
--19872--    object doesn't have a symbol table
--19872-- Reading syms from /usr/lib/x86_64-linux-gnu/libp11-kit.so.0.3.0
--19872--    object doesn't have a symbol table
--19872-- Reading syms from /lib/x86_64-linux-gnu/libidn.so.11.6.16
--19872--    object doesn't have a symbol table
--19872-- Reading syms from /usr/lib/x86_64-linux-gnu/libtasn1.so.6.5.4
--19872--    object doesn't have a symbol table
--19872-- Reading syms from /lib/x86_64-linux-gnu/libkeyutils.so.1.5
--19872--    object doesn't have a symbol table
--19872-- Reading syms from /lib/x86_64-linux-gnu/libresolv-2.26.so
--19872--   Considering /lib/x86_64-linux-gnu/libresolv-2.26.so ..
--19872--   .. CRC mismatch (computed 282a75e7 wanted 8a45d56f)
--19872--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libresolv-2.26.so ..
--19872--   .. CRC is valid
--19872-- Reading syms from /lib/x86_64-linux-gnu/libdl-2.26.so
--19872--   Considering /lib/x86_64-linux-gnu/libdl-2.26.so ..
--19872--   .. CRC mismatch (computed 4752ccc3 wanted 4a46c849)
--19872--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libdl-2.26.so ..
--19872--   .. CRC is valid
--19872-- Reading syms from /usr/lib/x86_64-linux-gnu/libffi.so.6.0.4
--19872--    object doesn't have a symbol table
--19872-- REDIR: 0x53cbf50 (libc.so.6:memmove) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53cb010 (libc.so.6:strncpy) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53cc230 (libc.so.6:strcasecmp) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53caa60 (libc.so.6:strcat) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53cb040 (libc.so.6:rindex) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53cdbb0 (libc.so.6:rawmemchr) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53cc0c0 (libc.so.6:mempcpy) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53cbee0 (libc.so.6:bcmp) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53cafd0 (libc.so.6:strncmp) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53caad0 (libc.so.6:strcmp) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53cc020 (libc.so.6:memset) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53e9f10 (libc.so.6:wcschr) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53caf70 (libc.so.6:strnlen) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53cab40 (libc.so.6:strcspn) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53cc280 (libc.so.6:strncasecmp) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53cab10 (libc.so.6:strcpy) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53cc3c0 (libc.so.6:memcpy@@GLIBC_2.14) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53cb070 (libc.so.6:strpbrk) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53caa90 (libc.so.6:index) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53caf40 (libc.so.6:strlen) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53d6510 (libc.so.6:memrchr) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53cc2d0 (libc.so.6:strcasecmp_l) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53cbeb0 (libc.so.6:memchr) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53eacc0 (libc.so.6:wcslen) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53cb350 (libc.so.6:strspn) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53cc200 (libc.so.6:stpncpy) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53cc1d0 (libc.so.6:stpcpy) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53cdbe0 (libc.so.6:strchrnul) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53cc320 (libc.so.6:strncasecmp_l) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53cafa0 (libc.so.6:strncat) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x545b3c0 (libc.so.6:__memcpy_chk) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x53cbdf0 (libc.so.6:strstr) redirected to 0x4a2a742 (_vgnU_ifunc_wrapper)
--19872-- REDIR: 0x54b56f0 (libc.so.6:__strrchr_avx2) redirected to 0x4c325f0 (rindex)
--19872-- REDIR: 0x54b58c0 (libc.so.6:__strlen_avx2) redirected to 0x4c32ba0 (strlen)
--19872-- REDIR: 0x54ac860 (libc.so.6:__strncmp_sse42) redirected to 0x4c33430 (__strncmp_sse42)
--19872-- REDIR: 0x53c5eb0 (libc.so.6:malloc) redirected to 0x4c2fb1f (malloc)
--19872-- REDIR: 0x54b5e00 (libc.so.6:__memcpy_avx_unaligned_erms) redirected to 0x4c363c0 (memmove)
--19872-- REDIR: 0x54910b0 (libc.so.6:__strcmp_ssse3) redirected to 0x4c33c20 (strcmp)
--19872-- REDIR: 0x53c7540 (libc.so.6:calloc) redirected to 0x4c319ba (calloc)
--19872-- REDIR: 0x54b52d0 (libc.so.6:__strchr_avx2) redirected to 0x4c32810 (index)
--19872-- REDIR: 0x54b5df0 (libc.so.6:__memcpy_chk_avx_unaligned_erms) redirected to 0x4c37220 (__memcpy_chk)
--19872-- REDIR: 0x53c63e0 (libc.so.6:free) redirected to 0x4c30ccc (free)
--19872-- REDIR: 0x53cb850 (libc.so.6:__GI_strstr) redirected to 0x4c37390 (__strstr_sse2)
--19872-- REDIR: 0x54b1750 (libc.so.6:__memchr_avx2) redirected to 0x4c33e00 (memchr)
--19872-- REDIR: 0x54b1630 (libc.so.6:__strspn_sse42) redirected to 0x4c37530 (strspn)
--19872-- REDIR: 0x54b13c0 (libc.so.6:__strcspn_sse42) redirected to 0x4c374d0 (strcspn)
--19872-- REDIR: 0x54a2ca0 (libc.so.6:__strcpy_ssse3) redirected to 0x4c32c80 (strcpy)
--19872-- REDIR: 0x54b22b0 (libc.so.6:__strcasecmp_avx) redirected to 0x4c334a0 (strcasecmp)
--19872-- REDIR: 0x54b5500 (libc.so.6:__strchrnul_avx2) redirected to 0x4c36c60 (strchrnul)
--19872-- REDIR: 0x54b5de0 (libc.so.6:__mempcpy_avx_unaligned_erms) redirected to 0x4c36d70 (mempcpy)
--19872-- REDIR: 0x5372b60 (libc.so.6:setenv) redirected to 0x4c37960 (setenv)
--19872-- REDIR: 0x53c6a00 (libc.so.6:realloc) redirected to 0x4c31bb3 (realloc)
odbctest
--------

connection parameters:
server:   'sql2008'
user:     'FREETDS\Administrator'
password: '????'
database: 'tempdb'
--19872-- REDIR: 0x54b3920 (libc.so.6:__strncasecmp_avx) redirected to 0x4c33580 (strncasecmp)
--19872-- REDIR: 0x54a6fd0 (libc.so.6:__stpcpy_ssse3) redirected to 0x4c35cb0 (stpcpy)
--19872-- Reading syms from /lib/x86_64-linux-gnu/libnss_compat-2.26.so
--19872--   Considering /lib/x86_64-linux-gnu/libnss_compat-2.26.so ..
--19872--   .. CRC mismatch (computed b8985d51 wanted 5be90e8d)
--19872--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnss_compat-2.26.so ..
--19872--   .. CRC is valid
--19872-- Reading syms from /lib/x86_64-linux-gnu/libnsl-2.26.so
--19872--   Considering /lib/x86_64-linux-gnu/libnsl-2.26.so ..
--19872--   .. CRC mismatch (computed 39e4af96 wanted 94850e13)
--19872--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnsl-2.26.so ..
--19872--   .. CRC is valid
--19872-- Reading syms from /lib/x86_64-linux-gnu/libnss_nis-2.26.so
--19872--   Considering /lib/x86_64-linux-gnu/libnss_nis-2.26.so ..
--19872--   .. CRC mismatch (computed f95cf356 wanted 7ecb1f40)
--19872--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnss_nis-2.26.so ..
--19872--   .. CRC is valid
--19872-- Reading syms from /lib/x86_64-linux-gnu/libnss_files-2.26.so
--19872--   Considering /lib/x86_64-linux-gnu/libnss_files-2.26.so ..
--19872--   .. CRC mismatch (computed e2a93e37 wanted aed0de79)
--19872--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnss_files-2.26.so ..
--19872--   .. CRC is valid
--19872-- REDIR: 0x54b1500 (libc.so.6:__strpbrk_sse42) redirected to 0x4c37470 (strpbrk)
--19872-- REDIR: 0x54b6280 (libc.so.6:__memset_avx2_unaligned_erms) redirected to 0x4c362c0 (memset)
--19872-- Reading syms from /usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so
--19872--   Considering /usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so ..
--19872--   .. CRC mismatch (computed 167a2c0b wanted 344ecff5)
--19872--   Considering /usr/lib/debug/usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so ..
--19872--   .. CRC is valid
--19872-- REDIR: 0x401fc20 (ld-linux-x86-64.so.2:stpcpy) redirected to 0x4c360c0 (stpcpy)
--19872-- Reading syms from /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so
--19872--   Considering /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so ..
--19872--   .. CRC mismatch (computed 1fa9e6a7 wanted 247701e3)
--19872--   Considering /usr/lib/debug/usr/lib/x86_64-linux-gnu/gconv/UTF-16.so ..
--19872--   .. CRC is valid
--19872-- REDIR: 0x54b1ed0 (libc.so.6:__memcmp_avx2_movbe) redirected to 0x4c35b50 (bcmp)
--19872-- Reading syms from /usr/lib/x86_64-linux-gnu/gconv/CP1252.so
--19872--   Considering /usr/lib/x86_64-linux-gnu/gconv/CP1252.so ..
--19872--   .. CRC mismatch (computed 435269c7 wanted cac8a70f)
--19872--   Considering /usr/lib/debug/usr/lib/x86_64-linux-gnu/gconv/CP1252.so ..
--19872--   .. CRC is valid
use tempdb
Following row can contain an error due to MARS detection (is expected)
BEGIN TRANSACTION
Message: '42000' [FreeTDS][SQL Server]A transaction that was started in a MARS batch is still active at the end of the batch. The transaction is rolled back.
create table #mars1 (n int, v varchar(100))
insert into #mars1 values(0, '')
insert into #mars1 values(1, 'bbbbbbb')
insert into #mars1 values(2, 'cccccccccccccc')
insert into #mars1 values(3, 'ddddddddddddddddddddd')
insert into #mars1 values(4, 'eeeeeeeeeeeeeeeeeeeeeeeeeeee')
insert into #mars1 values(5, 'fffffffffffffffffffffffffffffffffff')
insert into #mars1 values(6, 'gggggggggggggggggggggggggggggggggggggggggg')
insert into #mars1 values(7, 'hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh')
insert into #mars1 values(8, 'iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii')
insert into #mars1 values(9, 'jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj')
insert into #mars1 values(10, 'kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk')
insert into #mars1 values(11, 'llll')
insert into #mars1 values(12, 'mmmmmmmmmmm')
insert into #mars1 values(13, 'nnnnnnnnnnnnnnnnnn')
insert into #mars1 values(14, 'ooooooooooooooooooooooooo')
insert into #mars1 values(15, 'pppppppppppppppppppppppppppppppp')
insert into #mars1 values(16, 'qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq')
insert into #mars1 values(17, 'rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr')
insert into #mars1 values(18, 'sssssssssssssssssssssssssssssssssssssssssssssssssssss')
insert into #mars1 values(19, 'tttttttttttttttttttttttttttttttttttttttttttttttttttttttttttt')
insert into #mars1 values(20, 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu')
insert into #mars1 values(21, 'v')
insert into #mars1 values(22, 'wwwwwwww')
insert into #mars1 values(23, 'xxxxxxxxxxxxxxx')
insert into #mars1 values(24, 'yyyyyyyyyyyyyyyyyyyyyy')
insert into #mars1 values(25, 'zzzzzzzzzzzzzzzzzzzzzzzzzzzzz')
insert into #mars1 values(26, 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa')
insert into #mars1 values(27, 'bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb')
insert into #mars1 values(28, 'cccccccccccccccccccccccccccccccccccccccccccccccccc')
insert into #mars1 values(29, 'ddddddddddddddddddddddddddddddddddddddddddddddddddddddddd')
insert into #mars1 values(30, 'eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee')
insert into #mars1 values(31, 'fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff')
insert into #mars1 values(32, 'ggggg')
insert into #mars1 values(33, 'hhhhhhhhhhhh')
insert into #mars1 values(34, 'iiiiiiiiiiiiiiiiiii')
insert into #mars1 values(35, 'jjjjjjjjjjjjjjjjjjjjjjjjjj')
insert into #mars1 values(36, 'kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk')
insert into #mars1 values(37, 'llllllllllllllllllllllllllllllllllllllll')
insert into #mars1 values(38, 'mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm')
insert into #mars1 values(39, 'nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn')
insert into #mars1 values(40, 'ooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo')
insert into #mars1 values(41, 'pppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppp')
insert into #mars1 values(42, 'qq')
insert into #mars1 values(43, 'rrrrrrrrr')
insert into #mars1 values(44, 'ssssssssssssssss')
insert into #mars1 values(45, 'ttttttttttttttttttttttt')
insert into #mars1 values(46, 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuu')
insert into #mars1 values(47, 'vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv')
insert into #mars1 values(48, 'wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww')
insert into #mars1 values(49, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx')
insert into #mars1 values(50, 'yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy')
insert into #mars1 values(51, 'zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz')
insert into #mars1 values(52, 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa')
insert into #mars1 values(53, 'bbbbbb')
insert into #mars1 values(54, 'ccccccccccccc')
insert into #mars1 values(55, 'dddddddddddddddddddd')
insert into #mars1 values(56, 'eeeeeeeeeeeeeeeeeeeeeeeeeee')
insert into #mars1 values(57, 'ffffffffffffffffffffffffffffffffff')
insert into #mars1 values(58, 'ggggggggggggggggggggggggggggggggggggggggg')
insert into #mars1 values(59, 'hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh')
create table #mars2 (n int, v varchar(100))
select a.n, b.n, a.v from #mars1 a, #mars1 b order by a.n, b.n
insert into #mars2 values(1, 'foo')
--19872-- Discarding syms at 0x8cf0750-0x8cf1fd3 in /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so due to munmap()
--19872-- Discarding syms at 0x8ef4640-0x8ef5367 in /usr/lib/x86_64-linux-gnu/gconv/CP1252.so due to munmap()
--19872-- Discarding syms at 0x8aed640-0x8aee16f in /usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so due to munmap()
--19872-- Discarding syms at 0x82ad320-0x82b2f9e in /lib/x86_64-linux-gnu/libnss_compat-2.26.so due to munmap()
--19872-- Discarding syms at 0x86d1100-0x86d7f14 in /lib/x86_64-linux-gnu/libnss_nis-2.26.so due to munmap()
--19872-- Discarding syms at 0x84b90d0-0x84c6ba1 in /lib/x86_64-linux-gnu/libnsl-2.26.so due to munmap()
--19872-- Discarding syms at 0x88dd1f0-0x88e3481 in /lib/x86_64-linux-gnu/libnss_files-2.26.so due to munmap()
==19872== 
==19872== HEAP SUMMARY:
==19872==     in use at exit: 0 bytes in 0 blocks
==19872==   total heap usage: 2,671 allocs, 2,671 frees, 1,574,924 bytes allocated
==19872== 
==19872== All heap blocks were freed -- no leaks are possible
==19872== 
==19872== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 0 from 0)
==19872== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 0 from 0)

Main