src/dblib/unittests/rpc
Main
| Hostname | krb5.freetds.io |
|---|
| uname -a | Linux krb5.freetds.io 4.15.0-213-generic #224-Ubuntu SMP Mon Jun 19 13:30:12 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux |
|---|
| date | 2024-11-21 |
|---|
==7086== Memcheck, a memory error detector
==7086== Copyright (C) 2002-2017, and GNU GPL'd, by Julian Seward et al.
==7086== Using Valgrind-3.13.0 and LibVEX; rerun with -h for copyright info
==7086== Command: ./rpc
==7086==
--7086-- Valgrind options:
--7086-- --tool=memcheck
--7086-- --vgdb=no
--7086-- --num-callers=20
--7086-- --leak-check=yes
--7086-- -v
--7086-- --show-reachable=yes
--7086-- --log-fd=3
--7086-- --suppressions=/home/test/suppressions.supp
--7086-- --track-origins=yes
--7086-- Contents of /proc/version:
--7086-- Linux version 4.15.0-213-generic (buildd@lcy02-amd64-079) (gcc version 7.5.0 (Ubuntu 7.5.0-3ubuntu1~18.04)) #224-Ubuntu SMP Mon Jun 19 13:30:12 UTC 2023
--7086--
--7086-- Arch and hwcaps: AMD64, LittleEndian, amd64-cx16-lzcnt-rdtscp-sse3-avx-avx2-bmi
--7086-- Page sizes: currently 4096, max supported 4096
--7086-- Valgrind library directory: /usr/lib/valgrind
--7086-- Reading syms from /home/test/ftdstmp/ftds_comp99m/test3/src/dblib/unittests/rpc
--7086-- Reading syms from /lib/x86_64-linux-gnu/ld-2.27.so
--7086-- Considering /lib/x86_64-linux-gnu/ld-2.27.so ..
--7086-- .. CRC mismatch (computed 2977d8b2 wanted c64f09ed)
--7086-- Considering /usr/lib/debug/lib/x86_64-linux-gnu/ld-2.27.so ..
--7086-- .. CRC is valid
--7086-- Reading syms from /usr/lib/valgrind/memcheck-amd64-linux
--7086-- Considering /usr/lib/valgrind/memcheck-amd64-linux ..
--7086-- .. CRC mismatch (computed 41ddb025 wanted 9972f546)
--7086-- object doesn't have a symbol table
--7086-- object doesn't have a dynamic symbol table
--7086-- Scheduler: using generic scheduler lock implementation.
--7086-- Reading suppressions file: /home/test/suppressions.supp
--7086-- Reading suppressions file: /usr/lib/valgrind/default.supp
--7086-- REDIR: 0x4020d20 (ld-linux-x86-64.so.2:strlen) redirected to 0x580608c1 (???)
--7086-- REDIR: 0x4020b00 (ld-linux-x86-64.so.2:index) redirected to 0x580608db (???)
--7086-- Reading syms from /usr/lib/valgrind/vgpreload_core-amd64-linux.so
--7086-- Considering /usr/lib/valgrind/vgpreload_core-amd64-linux.so ..
--7086-- .. CRC mismatch (computed 50df1b30 wanted 4800a4cf)
--7086-- object doesn't have a symbol table
--7086-- Reading syms from /usr/lib/valgrind/vgpreload_memcheck-amd64-linux.so
--7086-- Considering /usr/lib/valgrind/vgpreload_memcheck-amd64-linux.so ..
--7086-- .. CRC mismatch (computed f893b962 wanted 95ee359e)
--7086-- object doesn't have a symbol table
==7086== WARNING: new redirection conflicts with existing -- ignoring it
--7086-- old: 0x04020d20 (strlen ) R-> (0000.0) 0x580608c1 ???
--7086-- new: 0x04020d20 (strlen ) R-> (2007.0) 0x04c34db0 strlen
--7086-- REDIR: 0x401d540 (ld-linux-x86-64.so.2:strcmp) redirected to 0x4c35ee0 (strcmp)
--7086-- REDIR: 0x4021260 (ld-linux-x86-64.so.2:mempcpy) redirected to 0x4c394f0 (mempcpy)
--7086-- Reading syms from /home/test/ftdstmp/ftds_comp99m/src/dblib/.libs/libsybdb.so.5.1.0
--7086-- Reading syms from /lib/x86_64-linux-gnu/libpthread-2.27.so
--7086-- Considering /usr/lib/debug/.build-id/1f/06001733b9be9478b105faf0dac6bdf36c85de.debug ..
--7086-- .. build-id is valid
--7086-- Reading syms from /lib/x86_64-linux-gnu/libc-2.27.so
--7086-- Considering /lib/x86_64-linux-gnu/libc-2.27.so ..
--7086-- .. CRC mismatch (computed f250d419 wanted 4aacab51)
--7086-- Considering /usr/lib/debug/lib/x86_64-linux-gnu/libc-2.27.so ..
--7086-- .. CRC is valid
--7086-- Reading syms from /usr/lib/x86_64-linux-gnu/libhogweed.so.4.5
--7086-- object doesn't have a symbol table
--7086-- Reading syms from /usr/lib/x86_64-linux-gnu/libgssapi_krb5.so.2.2
--7086-- object doesn't have a symbol table
--7086-- Reading syms from /usr/lib/x86_64-linux-gnu/libgnutls.so.30.14.10
--7086-- object doesn't have a symbol table
--7086-- Reading syms from /usr/lib/x86_64-linux-gnu/libnettle.so.6.5
--7086-- object doesn't have a symbol table
--7086-- Reading syms from /usr/lib/x86_64-linux-gnu/libgmp.so.10.3.2
--7086-- object doesn't have a symbol table
--7086-- Reading syms from /usr/lib/x86_64-linux-gnu/libkrb5.so.3.3
--7086-- object doesn't have a symbol table
--7086-- Reading syms from /usr/lib/x86_64-linux-gnu/libk5crypto.so.3.1
--7086-- object doesn't have a symbol table
--7086-- Reading syms from /lib/x86_64-linux-gnu/libcom_err.so.2.1
--7086-- object doesn't have a symbol table
--7086-- Reading syms from /usr/lib/x86_64-linux-gnu/libkrb5support.so.0.1
--7086-- object doesn't have a symbol table
--7086-- Reading syms from /lib/x86_64-linux-gnu/libz.so.1.2.11
--7086-- object doesn't have a symbol table
--7086-- Reading syms from /usr/lib/x86_64-linux-gnu/libp11-kit.so.0.3.0
--7086-- object doesn't have a symbol table
--7086-- Reading syms from /usr/lib/x86_64-linux-gnu/libidn2.so.0.3.3
--7086-- object doesn't have a symbol table
--7086-- Reading syms from /usr/lib/x86_64-linux-gnu/libunistring.so.2.1.0
--7086-- object doesn't have a symbol table
--7086-- Reading syms from /usr/lib/x86_64-linux-gnu/libtasn1.so.6.5.5
--7086-- object doesn't have a symbol table
--7086-- Reading syms from /lib/x86_64-linux-gnu/libkeyutils.so.1.5
--7086-- object doesn't have a symbol table
--7086-- Reading syms from /lib/x86_64-linux-gnu/libresolv-2.27.so
--7086-- Considering /lib/x86_64-linux-gnu/libresolv-2.27.so ..
--7086-- .. CRC mismatch (computed 0da9c5d1 wanted b111a73d)
--7086-- Considering /usr/lib/debug/lib/x86_64-linux-gnu/libresolv-2.27.so ..
--7086-- .. CRC is valid
--7086-- Reading syms from /lib/x86_64-linux-gnu/libdl-2.27.so
--7086-- Considering /lib/x86_64-linux-gnu/libdl-2.27.so ..
--7086-- .. CRC mismatch (computed 56b0b30d wanted 7867693f)
--7086-- Considering /usr/lib/debug/lib/x86_64-linux-gnu/libdl-2.27.so ..
--7086-- .. CRC is valid
--7086-- Reading syms from /usr/lib/x86_64-linux-gnu/libffi.so.6.0.4
--7086-- object doesn't have a symbol table
--7086-- REDIR: 0x53d5a50 (libc.so.6:memmove) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53d4d60 (libc.so.6:strncpy) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53d5d30 (libc.so.6:strcasecmp) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53d47b0 (libc.so.6:strcat) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53d4d90 (libc.so.6:rindex) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53d7480 (libc.so.6:rawmemchr) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53d5bc0 (libc.so.6:mempcpy) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53d59f0 (libc.so.6:bcmp) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53d4d20 (libc.so.6:strncmp) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53d4820 (libc.so.6:strcmp) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53d5b20 (libc.so.6:memset) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53f2db0 (libc.so.6:wcschr) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53d4cc0 (libc.so.6:strnlen) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53d4890 (libc.so.6:strcspn) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53d5d80 (libc.so.6:strncasecmp) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53d4860 (libc.so.6:strcpy) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53d5ec0 (libc.so.6:memcpy@@GLIBC_2.14) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53d4dc0 (libc.so.6:strpbrk) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53d47e0 (libc.so.6:index) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53d4c90 (libc.so.6:strlen) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53df380 (libc.so.6:memrchr) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53d5dd0 (libc.so.6:strcasecmp_l) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53d59c0 (libc.so.6:memchr) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53f3b70 (libc.so.6:wcslen) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53d5070 (libc.so.6:strspn) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53d5d00 (libc.so.6:stpncpy) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53d5cd0 (libc.so.6:stpcpy) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53d74b0 (libc.so.6:strchrnul) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53d5e20 (libc.so.6:strncasecmp_l) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x53d4cf0 (libc.so.6:strncat) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x5468700 (libc.so.6:__memcpy_chk) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x54687d0 (libc.so.6:__memmove_chk) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
==7086== WARNING: new redirection conflicts with existing -- ignoring it
--7086-- old: 0x054c5980 (__memcpy_chk_avx_una) R-> (2030.0) 0x04c395e0 __memcpy_chk
--7086-- new: 0x054c5980 (__memcpy_chk_avx_una) R-> (2024.0) 0x04c38fa0 __memmove_chk
--7086-- REDIR: 0x53d5900 (libc.so.6:strstr) redirected to 0x4a2c6e0 (_vgnU_ifunc_wrapper)
--7086-- REDIR: 0x54c5280 (libc.so.6:__strrchr_avx2) redirected to 0x4c34730 (rindex)
--7086-- REDIR: 0x54c5450 (libc.so.6:__strlen_avx2) redirected to 0x4c34cf0 (strlen)
--7086-- REDIR: 0x53ce020 (libc.so.6:malloc) redirected to 0x4c31aa0 (malloc)
--7086-- REDIR: 0x54c5990 (libc.so.6:__memcpy_avx_unaligned_erms) redirected to 0x4c386e0 (memmove)
--7086-- REDIR: 0x53e0b30 (libc.so.6:__strcmp_sse2_unaligned) redirected to 0x4c35da0 (strcmp)
--7086-- REDIR: 0x53d1050 (libc.so.6:calloc) redirected to 0x4c33a70 (calloc)
--7086-- REDIR: 0x54c4e60 (libc.so.6:__strchr_avx2) redirected to 0x4c34950 (index)
--7086-- REDIR: 0x54c5980 (libc.so.6:__memcpy_chk_avx_unaligned_erms) redirected to 0x4c395e0 (__memcpy_chk)
--7086-- REDIR: 0x53ce910 (libc.so.6:free) redirected to 0x4c32cd0 (free)
--7086-- REDIR: 0x54bc3d0 (libc.so.6:__strncmp_sse42) redirected to 0x4c35570 (__strncmp_sse42)
--7086-- REDIR: 0x53d55a0 (libc.so.6:__GI_strstr) redirected to 0x4c39760 (__strstr_sse2)
--7086-- REDIR: 0x54c12e0 (libc.so.6:__memchr_avx2) redirected to 0x4c35f80 (memchr)
--7086-- REDIR: 0x54c11c0 (libc.so.6:__strspn_sse42) redirected to 0x4c39990 (strspn)
--7086-- REDIR: 0x54c0f30 (libc.so.6:__strcspn_sse42) redirected to 0x4c398d0 (strcspn)
--7086-- REDIR: 0x54c5090 (libc.so.6:__strchrnul_avx2) redirected to 0x4c39020 (strchrnul)
found SYBASE15.tempdb for sa in "../../../PWD"
--7086-- REDIR: 0x54c5970 (libc.so.6:__mempcpy_avx_unaligned_erms) redirected to 0x4c39130 (mempcpy)
SQL text will be read from ../../../src/dblib/unittests/rpc.sql
Starting ./rpc
--7086-- REDIR: 0x54c1e40 (libc.so.6:__strcasecmp_avx) redirected to 0x4c355f0 (strcasecmp)
About to logon
--7086-- REDIR: 0x54c5e10 (libc.so.6:__memset_avx2_unaligned_erms) redirected to 0x4c385d0 (memset)
--7086-- REDIR: 0x53ee810 (libc.so.6:__stpcpy_sse2_unaligned) redirected to 0x4c38200 (__stpcpy_sse2_unaligned)
expected error 20201: "Packet size of -1 not supported -- size of 0 used instead!"
About to open SYBASE15.tempdb
--7086-- Reading syms from /lib/x86_64-linux-gnu/libnss_compat-2.27.so
--7086-- Considering /lib/x86_64-linux-gnu/libnss_compat-2.27.so ..
--7086-- .. CRC mismatch (computed dc0305b8 wanted 460e4052)
--7086-- Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnss_compat-2.27.so ..
--7086-- .. CRC is valid
--7086-- REDIR: 0x53ed200 (libc.so.6:__strcpy_sse2_unaligned) redirected to 0x4c34dd0 (strcpy)
--7086-- Reading syms from /lib/x86_64-linux-gnu/libnss_nis-2.27.so
--7086-- Considering /lib/x86_64-linux-gnu/libnss_nis-2.27.so ..
--7086-- .. CRC mismatch (computed 38cb38d0 wanted 96404ac2)
--7086-- Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnss_nis-2.27.so ..
--7086-- .. CRC is valid
--7086-- Reading syms from /lib/x86_64-linux-gnu/libnsl-2.27.so
--7086-- Considering /lib/x86_64-linux-gnu/libnsl-2.27.so ..
--7086-- .. CRC mismatch (computed 12772991 wanted 58367bd1)
--7086-- Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnsl-2.27.so ..
--7086-- .. CRC is valid
--7086-- Reading syms from /lib/x86_64-linux-gnu/libnss_files-2.27.so
--7086-- Considering /lib/x86_64-linux-gnu/libnss_files-2.27.so ..
--7086-- .. CRC mismatch (computed 2270a715 wanted a5763524)
--7086-- Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnss_files-2.27.so ..
--7086-- .. CRC is valid
--7086-- REDIR: 0x53f01f0 (libc.so.6:__strcat_sse2_unaligned) redirected to 0x4c34990 (strcat)
--7086-- REDIR: 0x53cfc50 (libc.so.6:realloc) redirected to 0x4c33cb0 (realloc)
--7086-- Reading syms from /usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so
--7086-- Considering /usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so ..
--7086-- .. CRC mismatch (computed 83103428 wanted d26a1d18)
--7086-- Considering /usr/lib/debug/usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so ..
--7086-- .. CRC is valid
--7086-- REDIR: 0x54c1a60 (libc.so.6:__memcmp_avx2_movbe) redirected to 0x4c37e00 (bcmp)
--7086-- Reading syms from /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so
--7086-- Considering /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so ..
--7086-- .. CRC mismatch (computed da5394b1 wanted a59039cd)
--7086-- Considering /usr/lib/debug/usr/lib/x86_64-linux-gnu/gconv/UTF-16.so ..
--7086-- .. CRC is valid
Check if server support long identifiers
1: SELECT 'x' AS this_is_a_really_really_long_identifier
trying to create a temporary stored procedure
Creating procedure #t0022
1:
2: CREATE PROCEDURE #t0022
3: @null_input varchar(30) OUTPUT
4: , @first_type varchar(30) OUTPUT
5: , @nullout int OUTPUT
6: , @varchar_tds7_out varchar(8000) OUTPUT
7: , @nvarchar_tds7_out nvarchar(4000) OUTPUT
8: , @nrows int OUTPUT
9: , @c_this_name_is_way_more_than_thirty_characters_charlie varchar(20)
10: , @nv nvarchar(20) = N'hello'
11: AS
12: BEGIN
13: if @null_input is not NULL begin
14: select 'error: should be NULL' as status, @null_input as 'null_input'
15: return -42
16: end else begin
17: print 'Good: @null_input is NULL'
18: end
19: if @c_this_name_is_way_more_than_thirty_characters_charlie is not NULL begin
20: select 'error: should be NULL' as status, @c_this_name_is_way_more_than_thirty_characters_charlie as '@c_this_name_is_way_more_than_thirty_characters_charlie'
21: return -42
22: end else begin
23: print 'Good: @c_this_name_is_way_more_than_thirty_characters_charlie is NULL'
24: end
25: select @null_input = max(convert(varchar(30), name)) from systypes
26: select @first_type = min(convert(varchar(30), name)) from systypes
27: select name from sysobjects where 0=1
28: select distinct convert(varchar(30), name) as 'type' from systypes
29: where name in ('int', 'char', 'text')
30: select @nrows = @@rowcount
31: set @varchar_tds7_out = replicate(char(123), 8000)
32: set @nvarchar_tds7_out = replicate(nchar(246), 4000)
33: select distinct @nv as '@nv', convert(varchar(30), name) as name from systypes
34: select @null_input as 'null_input'
35: , @first_type as 'first_type'
36: , @nullout as 'nullout'
37: , @nrows as 'nrows'
38: , @c_this_name_is_way_more_than_thirty_characters_charlie as 'c'
39: , @nv as 'nv'
40: into #parameters
41: select * from #parameters
42: return 42
43: END
44:
OK: anticipated message arrived: 177 CREATE PROCEDURE cannot create a temporary object (with '#' as the first character name.
OK: anticipated message arrived: 137 Must declare variable '@null_input'.
OK: anticipated message arrived: 137 Must declare variable '@null_input'.
OK: anticipated message arrived: 156 Incorrect syntax near the keyword 'else'.
OK: anticipated message arrived: 137 Must declare variable '@c_this_name_is_way_more_than_thirty_characters_charlie'.
OK: anticipated message arrived: 137 Must declare variable '@c_this_name_is_way_more_than_thirty_characters_charlie'.
OK: anticipated message arrived: 156 Incorrect syntax near the keyword 'else'.
OK: anticipated message arrived: 137 Must declare variable '@null_input'.
OK: anticipated message arrived: 137 Must declare variable '@first_type'.
OK: anticipated message arrived: 137 Must declare variable '@nrows'.
OK: anticipated message arrived: 137 Must declare variable '@varchar_tds7_out'.
OK: anticipated message arrived: 137 Must declare variable '@nvarchar_tds7_out'.
OK: anticipated message arrived: 137 Must declare variable '@nv'.
OK: anticipated message arrived: 137 Must declare variable '@null_input'.
Failed to create procedure #t0022. Wrong permission or not MSSQL.
trying to create a permanent stored procedure
Dropping procedure t0022
1: IF OBJECT_ID('t0022') IS NOT NULL DROP PROC t0022
Creating procedure t0022
1: CREATE PROCEDURE t0022
2: @null_input varchar(30) OUTPUT
3: , @first_type varchar(30) OUTPUT
4: , @nullout int OUTPUT
5: , @nrows int OUTPUT
6: , @c_this_name_is_way_more_than_thirty_characters_charlie varchar(20)
7: , @nv nvarchar(20) = N'hello'
8: AS
9: BEGIN
10: if @null_input is not NULL begin
11: select 'error: should be NULL' as status, @null_input as 'null_input'
12: return -42
13: end else begin
14: print 'Good: @null_input is NULL'
15: end
16: if @c_this_name_is_way_more_than_thirty_characters_charlie is not NULL begin
17: select 'error: should be NULL' as status, @c_this_name_is_way_more_than_thirty_characters_charlie as '@c_this_name_is_way_more_than_thirty_characters_charlie'
18: return -42
19: end else begin
20: print 'Good: @c_this_name_is_way_more_than_thirty_characters_charlie is NULL'
21: end
22: select @null_input = max(convert(varchar(30), name)) from systypes
23: select @first_type = min(convert(varchar(30), name)) from systypes
24: select name from sysobjects where 0=1
25: select distinct convert(varchar(30), name) as 'type' from systypes
26: where name in ('int', 'char', 'text')
27: select @nrows = @@rowcount
28: select distinct @nv as '@nv', convert(varchar(30), name) as name from sysobjects where type = 'S'
29: select @null_input as 'null_input'
30: , @first_type as 'first_type'
31: , @nullout as 'nullout'
32: , @nrows as 'nrows'
33: , @c_this_name_is_way_more_than_thirty_characters_charlie as 'c'
34: , @nv as 'nv'
35: into #parameters
36: select * from #parameters
37: return 42
38: END
39:
Created procedure t0022
executing dbrpcinit
executing dbrpcparam for @null_input
executing dbrpcparam for @first_type
executing dbrpcparam for @nullout
executing dbrpcparam for @varchar_tds7_out
executing dbrpcparam for @nvarchar_tds7_out
executing dbrpcparam for @nrows
executing dbrpcparam for @c_this_name_is_way_more_than_thirty_characters_charlie
executing dbrpcparam for @nv
executing dbrpcsend
executing dbsqlok
Good: @null_input is NULL
Good: @c_this_name_is_way_more_than_thirty_characters_charlie is NULL
fetching results
fetched resultset 1 successfully:
column 1 (name) is 1 wide, buffer initialized to 'one'
name
row count 0
hasretstatus 0
fetched resultset 2 successfully:
column 1 (type) is 1 wide, buffer initialized to 'one'
type
char
int
text
row count 3
hasretstatus 0
fetched resultset 3 successfully:
column 1 (@nv) is 1 wide, buffer initialized to 'one'
column 2 (name) is 1 wide, buffer initialized to 'two'
@nv name
OK sysobjects
OK sysindexes
OK syscolumns
OK systypes
OK syslogs
OK syspartitions
OK sysgams
OK sysprocedures
OK syscomments
OK syssegments
OK sysprotects
OK sysusers
OK sysalternates
OK sysdepends
OK syskeys
OK syspartitionkeys
OK sysreferences
OK sysconstraints
OK sysusermessages
OK systhresholds
OK sysroles
OK sysslices
OK systabstats
OK sysstatistics
OK sysxtypes
OK sysjars
OK sysqueryplans
OK sysencryptkeys
OK sysattributes
row count 29
hasretstatus 0
fetched resultset 4 successfully:
column 1 (null_input) is 1 wide, buffer initialized to 'one'
column 2 (first_type) is 1 wide, buffer initialized to 'two'
column 3 (nullout) is 1 wide, buffer initialized to 'three'
column 4 (nrows) is 1 wide, buffer initialized to 'four'
column 5 (c) is 1 wide, buffer initialized to 'five'
null_input first_type nullout nrows c
varchar bigint 3
row count 1
hasretstatus 1
retrieving return status...
42
retrieving output parameters...
param name type length data
---- ------------------- ---- ----- ------------------------------
1 @null_input 39 7 varchar
2 @first_type 39 6 bigint
3 @nullout 56 0
4 @nrows 56 4 3
Good: Got 6 output parameters and 1 return status of 42.
Good: Got 4 resultsets and 1 empty resultset.
Dropping procedure
1: IF OBJECT_ID('t0022') IS NOT NULL DROP PROC t0022
rpc.c OK
--7086-- Discarding syms at 0x9046710-0x904825b in /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so due to munmap()
--7086-- Discarding syms at 0x8e43600-0x8e44292 in /usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so due to munmap()
--7086-- Discarding syms at 0x86022a0-0x86081ac in /lib/x86_64-linux-gnu/libnss_compat-2.27.so due to munmap()
--7086-- Discarding syms at 0x880d070-0x88140d9 in /lib/x86_64-linux-gnu/libnss_nis-2.27.so due to munmap()
--7086-- Discarding syms at 0x8a1b090-0x8a288a7 in /lib/x86_64-linux-gnu/libnsl-2.27.so due to munmap()
--7086-- Discarding syms at 0x8c33350-0x8c39d8f in /lib/x86_64-linux-gnu/libnss_files-2.27.so due to munmap()
==7086==
==7086== HEAP SUMMARY:
==7086== in use at exit: 0 bytes in 0 blocks
==7086== total heap usage: 2,321 allocs, 2,321 frees, 1,866,875 bytes allocated
==7086==
==7086== All heap blocks were freed -- no leaks are possible
==7086==
==7086== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 0 from 0)
==7086== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 0 from 0)
Main