src/odbc/unittests/genparams
Main
| Hostname | obon110 |
|---|
| gcc version | gcc (GCC) 4.1.2 20070925 (Red Hat 4.1.2-33) |
|---|
| uname -a | Linux obon110 2.6.26.2-1smp #1 SMP Tue Aug 19 10:16:15 CEST 2008 i686 i686 i386 GNU/Linux |
|---|
| date | 2008-09-03 |
|---|
==2094== Memcheck, a memory error detector.
==2094== Copyright (C) 2002-2007, and GNU GPL'd, by Julian Seward et al.
==2094== Using LibVEX rev 1732, a library for dynamic binary translation.
==2094== Copyright (C) 2004-2007, and GNU GPL'd, by OpenWorks LLP.
==2094== Using valgrind-3.2.3, a dynamic binary instrumentation framework.
==2094== Copyright (C) 2000-2007, and GNU GPL'd, by Julian Seward et al.
==2094==
--2094-- Command line
--2094-- ./genparams
--2094-- Startup, with flags:
--2094-- --tool=memcheck
--2094-- --num-callers=20
--2094-- --leak-check=yes
--2094-- -v
--2094-- --show-reachable=yes
--2094-- --log-fd=3
--2094-- --suppressions=/home/winnt/fziglio/suppressions.supp
--2094-- Contents of /proc/version:
--2094-- Linux version 2.6.26.2-1smp (fziglio@obon110) (gcc version 4.1.2 20070626 (Red Hat 4.1.2-13)) #1 SMP Tue Aug 19 10:16:15 CEST 2008
--2094-- Arch and hwcaps: X86, x86-sse1-sse2
--2094-- Page sizes: currently 4096, max supported 4096
--2094-- Valgrind library directory: /usr/lib/valgrind
--2094-- Reading syms from /lib/ld-2.7.so (0x91E000)
--2094-- Reading debug info from /usr/lib/debug/lib/ld-2.7.so.debug...
--2094-- Reading syms from /home/winnt/fziglio/cpp/freetds/ftds_comp/src/odbc/unittests/genparams (0x8048000)
--2094-- Reading syms from /usr/lib/valgrind/x86-linux/memcheck (0x38000000)
--2094-- object doesn't have a dynamic symbol table
--2094-- Reading suppressions file: /home/winnt/fziglio/suppressions.supp
--2094-- Reading suppressions file: /usr/lib/valgrind/default.supp
--2094-- REDIR: 0x933BB0 (index) redirected to 0x38027F5F (vgPlain_x86_linux_REDIR_FOR_index)
--2094-- Reading syms from /usr/lib/valgrind/x86-linux/vgpreload_core.so (0x4001000)
--2094-- Reading syms from /usr/lib/valgrind/x86-linux/vgpreload_memcheck.so (0x4003000)
==2094== WARNING: new redirection conflicts with existing -- ignoring it
--2094-- new: 0x00933BB0 (index ) R-> 0x04006230 index
--2094-- REDIR: 0x933D50 (strlen) redirected to 0x40062E0 (strlen)
--2094-- Reading syms from /home/winnt/fziglio/cpp/freetds/ftds_comp/src/odbc/.libs/libtdsodbc.so.0.0.0 (0x4009000)
--2094-- Reading syms from /lib/librt-2.7.so (0xC7D000)
--2094-- Reading debug info from /usr/lib/debug/lib/librt-2.7.so.debug...
--2094-- Reading syms from /usr/lib/libgnutls.so.13.3.0 (0x3E7C000)
--2094-- Reading debug info from /usr/lib/debug/usr/lib/libgnutls.so.13.3.0.debug...
--2094-- Reading syms from /lib/libpthread-2.7.so (0xACA000)
--2094-- Reading debug info from /usr/lib/debug/lib/libpthread-2.7.so.debug...
--2094-- Reading syms from /lib/libc-2.7.so (0x93D000)
--2094-- Reading debug info from /usr/lib/debug/lib/libc-2.7.so.debug...
--2094-- Reading syms from /lib/libz.so.1.2.3 (0xAE5000)
--2094-- Reading debug info from /usr/lib/debug/lib/libz.so.1.2.3.debug...
--2094-- Reading syms from /lib/libgcrypt.so.11.2.3 (0x3E25000)
--2094-- Reading debug info from /usr/lib/debug/lib/libgcrypt.so.11.2.3.debug...
--2094-- Reading syms from /lib/libgpg-error.so.0.3.1 (0xDB4000)
--2094-- Reading debug info from /usr/lib/debug/lib/libgpg-error.so.0.3.1.debug...
--2094-- Reading syms from /lib/libnsl-2.7.so (0x259000)
--2094-- Reading debug info from /usr/lib/debug/lib/libnsl-2.7.so.debug...
--2094-- REDIR: 0x9AE3A0 (memset) redirected to 0x4006640 (memset)
--2094-- REDIR: 0x9AE890 (memcpy) redirected to 0x4007090 (memcpy)
--2094-- REDIR: 0x9AD4C0 (rindex) redirected to 0x4006110 (rindex)
--2094-- REDIR: 0x9AD120 (strlen) redirected to 0x40062C0 (strlen)
--2094-- REDIR: 0x9A8B00 (malloc) redirected to 0x40054A0 (malloc)
--2094-- REDIR: 0x9ACBC0 (strcmp) redirected to 0x4006390 (strcmp)
--2094-- REDIR: 0x9ADEA0 (memchr) redirected to 0x40064B0 (memchr)
--2094-- REDIR: 0x9ACC30 (strcpy) redirected to 0x40072F0 (strcpy)
--2094-- REDIR: 0x9AA060 (free) redirected to 0x40050BA (free)
--2094-- REDIR: 0x9AC8A0 (strcat) redirected to 0x40073E0 (strcat)
--2094-- REDIR: 0x9AF220 (strchrnul) redirected to 0x40066F0 (strchrnul)
--2094-- REDIR: 0x9AE400 (mempcpy) redirected to 0x4006B70 (mempcpy)
--2094-- REDIR: 0x9ACA50 (index) redirected to 0x4006200 (index)
--2094-- REDIR: 0x9AD310 (strncmp) redirected to 0x4006320 (strncmp)
--2094-- REDIR: 0x9AA250 (realloc) redirected to 0x400554F (realloc)
--2094-- REDIR: 0x9A8810 (calloc) redirected to 0x40047CD (calloc)
odbctest
--------
connection parameters:
server: 'sybase15'
user: 'sa'
password: '????'
database: 'tempdb'
--2094-- REDIR: 0x9AE590 (stpcpy) redirected to 0x4006850 (stpcpy)
--2094-- Reading syms from /lib/libnss_files-2.7.so (0x40E0000)
--2094-- Reading debug info from /usr/lib/debug/lib/libnss_files-2.7.so.debug...
--2094-- Reading syms from /lib/libnss_winbind.so.2 (0x420C000)
--2094-- object doesn't have a symbol table
--2094-- REDIR: 0x9AD410 (strncpy) redirected to 0x4006930 (strncpy)
--2094-- REDIR: 0x9AF150 (rawmemchr) redirected to 0x4006720 (rawmemchr)
--2094-- Reading syms from /usr/lib/gconv/ISO8859-1.so (0x41F7000)
--2094-- Reading debug info from /usr/lib/debug/usr/lib/gconv/ISO8859-1.so.debug...
--2094-- REDIR: 0x934110 (stpcpy) redirected to 0x40074D0 (stpcpy)
use tempdb
--2094-- REDIR: 0x9AE330 (memmove) redirected to 0x4006670 (memmove)
use_cursors 0 exec_direct 1 prepare_before 0
IF OBJECT_ID('spTestProc') IS NOT NULL DROP PROC spTestProc
CREATE PROC spTestProc @i NUMERIC(18,2) OUTPUT AS SELECT @i = CONVERT(NUMERIC(18,2), '123')
drop proc spTestProc
IF OBJECT_ID('spTestProc') IS NOT NULL DROP PROC spTestProc
CREATE PROC spTestProc @i DECIMAL(18,2) OUTPUT AS SELECT @i = CONVERT(DECIMAL(18,2), '123')
drop proc spTestProc
IF OBJECT_ID('spTestProc') IS NOT NULL DROP PROC spTestProc
CREATE PROC spTestProc @i NUMERIC(18,2) OUTPUT AS SELECT @i = CONVERT(NUMERIC(18,2), '123')
drop proc spTestProc
--2094-- REDIR: 0x9AD1D0 (strnlen) redirected to 0x4006290 (strnlen)
SELECT CONVERT(INTEGER, '12345')
CREATE TABLE #tmp_insert (col VARCHAR(20))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARCHAR(20), '12345')
DROP TABLE #tmp_insert
IF OBJECT_ID('spTestProc') IS NOT NULL DROP PROC spTestProc
CREATE PROC spTestProc @i VARCHAR(20) OUTPUT AS SELECT @i = CONVERT(VARCHAR(20), '313233')
drop proc spTestProc
IF OBJECT_ID('spTestProc') IS NOT NULL DROP PROC spTestProc
CREATE PROC spTestProc @i DATETIME OUTPUT AS SELECT @i = CONVERT(DATETIME, '2004-02-24 15:16:17')
drop proc spTestProc
IF OBJECT_ID('spTestProc') IS NOT NULL DROP PROC spTestProc
CREATE PROC spTestProc @i SMALLDATETIME OUTPUT AS SELECT @i = CONVERT(SMALLDATETIME, '2004-02-24 15:16:17')
drop proc spTestProc
SELECT CONVERT(DATETIME, '2005-07-22 09:51:34')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2005-07-22 09:51:34')
DROP TABLE #tmp_insert
SELECT CONVERT(DATETIME, '2005-07-22 09:51:34.001')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2005-07-22 09:51:34.000')
DROP TABLE #tmp_insert
SELECT CONVERT(DATETIME, '2005-07-22 09:51:34.002')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2005-07-22 09:51:34.003')
DROP TABLE #tmp_insert
SELECT CONVERT(DATETIME, '2005-07-22 09:51:34.003')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2005-07-22 09:51:34.003')
DROP TABLE #tmp_insert
SELECT CONVERT(DATETIME, '2005-07-22 09:51:34.004')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2005-07-22 09:51:34.003')
DROP TABLE #tmp_insert
SELECT CONVERT(DATETIME, '2005-07-22 09:51:34.005')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2005-07-22 09:51:34.007')
DROP TABLE #tmp_insert
SELECT CONVERT(DATETIME, '2005-07-22 09:51:34.006')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2005-07-22 09:51:34.007')
DROP TABLE #tmp_insert
SELECT CONVERT(DATETIME, '2005-07-22 13:02:03')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2005-07-22 00:00:00')
DROP TABLE #tmp_insert
SELECT GETDATE()
SELECT CONVERT(DATETIME, '2003-07-22 13:02:03')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2008-09-03 13:02:03')
DROP TABLE #tmp_insert
SELECT CONVERT(FLOAT, '1234.25')
CREATE TABLE #tmp_insert (col FLOAT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(FLOAT, '1234.25')
DROP TABLE #tmp_insert
SELECT CONVERT(REAL, '-1234.25')
CREATE TABLE #tmp_insert (col FLOAT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(FLOAT, '-1234.25')
DROP TABLE #tmp_insert
SELECT CONVERT(REAL, '1234.25')
CREATE TABLE #tmp_insert (col FLOAT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(FLOAT, '1234.25')
DROP TABLE #tmp_insert
SELECT CONVERT(FLOAT, '-1234.25')
CREATE TABLE #tmp_insert (col FLOAT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(FLOAT, '-1234.25')
DROP TABLE #tmp_insert
SELECT CONVERT(FLOAT, '1234.25')
CREATE TABLE #tmp_insert (col FLOAT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(FLOAT, '1234.25')
DROP TABLE #tmp_insert
SELECT CONVERT(REAL, '-1234.25')
CREATE TABLE #tmp_insert (col FLOAT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(FLOAT, '-1234.25')
DROP TABLE #tmp_insert
SELECT CONVERT(FLOAT, '1234.25')
CREATE TABLE #tmp_insert (col FLOAT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(FLOAT, '1234.25')
DROP TABLE #tmp_insert
SELECT CONVERT(REAL, '-1234.25')
CREATE TABLE #tmp_insert (col FLOAT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(FLOAT, '-1234.25')
DROP TABLE #tmp_insert
SELECT CONVERT(TINYINT, '231')
CREATE TABLE #tmp_insert (col TINYINT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(TINYINT, '231')
DROP TABLE #tmp_insert
SELECT CONVERT(NUMERIC(20,3), '765432.2')
CREATE TABLE #tmp_insert (col NUMERIC(20,3))
SELECT * FROM #tmp_insert WHERE col = CONVERT(NUMERIC(20,3), '765432')
DROP TABLE #tmp_insert
SELECT CONVERT(BIT, '0')
CREATE TABLE #tmp_insert (col BIT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(BIT, '0')
DROP TABLE #tmp_insert
SELECT CONVERT(BIT, '1')
CREATE TABLE #tmp_insert (col BIT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(BIT, '1')
DROP TABLE #tmp_insert
SELECT CONVERT(MONEY, '123.34')
CREATE TABLE #tmp_insert (col MONEY)
SELECT * FROM #tmp_insert WHERE col = CONVERT(MONEY, '123.34')
DROP TABLE #tmp_insert
SELECT CONVERT(VARCHAR(20), '1EasyTest')
CREATE TABLE #tmp_insert (col VARCHAR(20))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARCHAR(20), '1EasyTest')
DROP TABLE #tmp_insert
SELECT CONVERT(VARCHAR(20), 'meô')
CREATE TABLE #tmp_insert (col VARCHAR(20))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARCHAR(20), 'meô')
DROP TABLE #tmp_insert
IF OBJECT_ID('spTestProc') IS NOT NULL DROP PROC spTestProc
CREATE PROC spTestProc @i VARCHAR(20) OUTPUT AS SELECT @i = CONVERT(VARCHAR(20), 'foo test')
drop proc spTestProc
IF OBJECT_ID('spTestProc') IS NOT NULL DROP PROC spTestProc
CREATE PROC spTestProc @i VARCHAR(20) OUTPUT AS SELECT @i = CONVERT(VARCHAR(20), 0xf8f9)
drop proc spTestProc
use_cursors 0 exec_direct 0 prepare_before 1
IF OBJECT_ID('spTestProc') IS NOT NULL DROP PROC spTestProc
CREATE PROC spTestProc @i NUMERIC(18,2) OUTPUT AS SELECT @i = CONVERT(NUMERIC(18,2), '123')
drop proc spTestProc
IF OBJECT_ID('spTestProc') IS NOT NULL DROP PROC spTestProc
CREATE PROC spTestProc @i DECIMAL(18,2) OUTPUT AS SELECT @i = CONVERT(DECIMAL(18,2), '123')
drop proc spTestProc
IF OBJECT_ID('spTestProc') IS NOT NULL DROP PROC spTestProc
CREATE PROC spTestProc @i NUMERIC(18,2) OUTPUT AS SELECT @i = CONVERT(NUMERIC(18,2), '123')
drop proc spTestProc
SELECT CONVERT(INTEGER, '12345')
CREATE TABLE #tmp_insert (col VARCHAR(20))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARCHAR(20), '12345')
DROP TABLE #tmp_insert
IF OBJECT_ID('spTestProc') IS NOT NULL DROP PROC spTestProc
CREATE PROC spTestProc @i VARCHAR(20) OUTPUT AS SELECT @i = CONVERT(VARCHAR(20), '313233')
drop proc spTestProc
IF OBJECT_ID('spTestProc') IS NOT NULL DROP PROC spTestProc
CREATE PROC spTestProc @i DATETIME OUTPUT AS SELECT @i = CONVERT(DATETIME, '2004-02-24 15:16:17')
drop proc spTestProc
IF OBJECT_ID('spTestProc') IS NOT NULL DROP PROC spTestProc
CREATE PROC spTestProc @i SMALLDATETIME OUTPUT AS SELECT @i = CONVERT(SMALLDATETIME, '2004-02-24 15:16:17')
drop proc spTestProc
SELECT CONVERT(DATETIME, '2005-07-22 09:51:34')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2005-07-22 09:51:34')
DROP TABLE #tmp_insert
SELECT CONVERT(DATETIME, '2005-07-22 09:51:34.001')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2005-07-22 09:51:34.000')
DROP TABLE #tmp_insert
SELECT CONVERT(DATETIME, '2005-07-22 09:51:34.002')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2005-07-22 09:51:34.003')
DROP TABLE #tmp_insert
SELECT CONVERT(DATETIME, '2005-07-22 09:51:34.003')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2005-07-22 09:51:34.003')
DROP TABLE #tmp_insert
SELECT CONVERT(DATETIME, '2005-07-22 09:51:34.004')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2005-07-22 09:51:34.003')
DROP TABLE #tmp_insert
SELECT CONVERT(DATETIME, '2005-07-22 09:51:34.005')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2005-07-22 09:51:34.007')
DROP TABLE #tmp_insert
SELECT CONVERT(DATETIME, '2005-07-22 09:51:34.006')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2005-07-22 09:51:34.007')
DROP TABLE #tmp_insert
SELECT CONVERT(DATETIME, '2005-07-22 13:02:03')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2005-07-22 00:00:00')
DROP TABLE #tmp_insert
SELECT GETDATE()
SELECT CONVERT(DATETIME, '2003-07-22 13:02:03')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2008-09-03 13:02:03')
DROP TABLE #tmp_insert
SELECT CONVERT(FLOAT, '1234.25')
CREATE TABLE #tmp_insert (col FLOAT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(FLOAT, '1234.25')
DROP TABLE #tmp_insert
SELECT CONVERT(REAL, '-1234.25')
CREATE TABLE #tmp_insert (col FLOAT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(FLOAT, '-1234.25')
DROP TABLE #tmp_insert
SELECT CONVERT(REAL, '1234.25')
CREATE TABLE #tmp_insert (col FLOAT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(FLOAT, '1234.25')
DROP TABLE #tmp_insert
SELECT CONVERT(FLOAT, '-1234.25')
CREATE TABLE #tmp_insert (col FLOAT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(FLOAT, '-1234.25')
DROP TABLE #tmp_insert
SELECT CONVERT(FLOAT, '1234.25')
CREATE TABLE #tmp_insert (col FLOAT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(FLOAT, '1234.25')
DROP TABLE #tmp_insert
SELECT CONVERT(REAL, '-1234.25')
CREATE TABLE #tmp_insert (col FLOAT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(FLOAT, '-1234.25')
DROP TABLE #tmp_insert
SELECT CONVERT(FLOAT, '1234.25')
CREATE TABLE #tmp_insert (col FLOAT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(FLOAT, '1234.25')
DROP TABLE #tmp_insert
SELECT CONVERT(REAL, '-1234.25')
CREATE TABLE #tmp_insert (col FLOAT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(FLOAT, '-1234.25')
DROP TABLE #tmp_insert
SELECT CONVERT(TINYINT, '231')
CREATE TABLE #tmp_insert (col TINYINT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(TINYINT, '231')
DROP TABLE #tmp_insert
SELECT CONVERT(NUMERIC(20,3), '765432.2')
CREATE TABLE #tmp_insert (col NUMERIC(20,3))
SELECT * FROM #tmp_insert WHERE col = CONVERT(NUMERIC(20,3), '765432')
DROP TABLE #tmp_insert
SELECT CONVERT(BIT, '0')
CREATE TABLE #tmp_insert (col BIT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(BIT, '0')
DROP TABLE #tmp_insert
SELECT CONVERT(BIT, '1')
CREATE TABLE #tmp_insert (col BIT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(BIT, '1')
DROP TABLE #tmp_insert
SELECT CONVERT(MONEY, '123.34')
CREATE TABLE #tmp_insert (col MONEY)
SELECT * FROM #tmp_insert WHERE col = CONVERT(MONEY, '123.34')
DROP TABLE #tmp_insert
SELECT CONVERT(VARCHAR(20), '1EasyTest')
CREATE TABLE #tmp_insert (col VARCHAR(20))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARCHAR(20), '1EasyTest')
DROP TABLE #tmp_insert
SELECT CONVERT(VARCHAR(20), 'meô')
CREATE TABLE #tmp_insert (col VARCHAR(20))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARCHAR(20), 'meô')
DROP TABLE #tmp_insert
IF OBJECT_ID('spTestProc') IS NOT NULL DROP PROC spTestProc
CREATE PROC spTestProc @i VARCHAR(20) OUTPUT AS SELECT @i = CONVERT(VARCHAR(20), 'foo test')
drop proc spTestProc
IF OBJECT_ID('spTestProc') IS NOT NULL DROP PROC spTestProc
CREATE PROC spTestProc @i VARCHAR(20) OUTPUT AS SELECT @i = CONVERT(VARCHAR(20), 0xf8f9)
drop proc spTestProc
use_cursors 0 exec_direct 0 prepare_before 0
IF OBJECT_ID('spTestProc') IS NOT NULL DROP PROC spTestProc
CREATE PROC spTestProc @i NUMERIC(18,2) OUTPUT AS SELECT @i = CONVERT(NUMERIC(18,2), '123')
drop proc spTestProc
IF OBJECT_ID('spTestProc') IS NOT NULL DROP PROC spTestProc
CREATE PROC spTestProc @i DECIMAL(18,2) OUTPUT AS SELECT @i = CONVERT(DECIMAL(18,2), '123')
drop proc spTestProc
IF OBJECT_ID('spTestProc') IS NOT NULL DROP PROC spTestProc
CREATE PROC spTestProc @i NUMERIC(18,2) OUTPUT AS SELECT @i = CONVERT(NUMERIC(18,2), '123')
drop proc spTestProc
SELECT CONVERT(INTEGER, '12345')
CREATE TABLE #tmp_insert (col VARCHAR(20))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARCHAR(20), '12345')
DROP TABLE #tmp_insert
IF OBJECT_ID('spTestProc') IS NOT NULL DROP PROC spTestProc
CREATE PROC spTestProc @i VARCHAR(20) OUTPUT AS SELECT @i = CONVERT(VARCHAR(20), '313233')
drop proc spTestProc
IF OBJECT_ID('spTestProc') IS NOT NULL DROP PROC spTestProc
CREATE PROC spTestProc @i DATETIME OUTPUT AS SELECT @i = CONVERT(DATETIME, '2004-02-24 15:16:17')
drop proc spTestProc
IF OBJECT_ID('spTestProc') IS NOT NULL DROP PROC spTestProc
CREATE PROC spTestProc @i SMALLDATETIME OUTPUT AS SELECT @i = CONVERT(SMALLDATETIME, '2004-02-24 15:16:17')
drop proc spTestProc
SELECT CONVERT(DATETIME, '2005-07-22 09:51:34')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2005-07-22 09:51:34')
DROP TABLE #tmp_insert
SELECT CONVERT(DATETIME, '2005-07-22 09:51:34.001')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2005-07-22 09:51:34.000')
DROP TABLE #tmp_insert
SELECT CONVERT(DATETIME, '2005-07-22 09:51:34.002')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2005-07-22 09:51:34.003')
DROP TABLE #tmp_insert
SELECT CONVERT(DATETIME, '2005-07-22 09:51:34.003')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2005-07-22 09:51:34.003')
DROP TABLE #tmp_insert
SELECT CONVERT(DATETIME, '2005-07-22 09:51:34.004')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2005-07-22 09:51:34.003')
DROP TABLE #tmp_insert
SELECT CONVERT(DATETIME, '2005-07-22 09:51:34.005')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2005-07-22 09:51:34.007')
DROP TABLE #tmp_insert
SELECT CONVERT(DATETIME, '2005-07-22 09:51:34.006')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2005-07-22 09:51:34.007')
DROP TABLE #tmp_insert
SELECT CONVERT(DATETIME, '2005-07-22 13:02:03')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2005-07-22 00:00:00')
DROP TABLE #tmp_insert
SELECT GETDATE()
SELECT CONVERT(DATETIME, '2003-07-22 13:02:03')
CREATE TABLE #tmp_insert (col DATETIME)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2008-09-03 13:02:03')
DROP TABLE #tmp_insert
SELECT CONVERT(FLOAT, '1234.25')
CREATE TABLE #tmp_insert (col FLOAT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(FLOAT, '1234.25')
DROP TABLE #tmp_insert
SELECT CONVERT(REAL, '-1234.25')
CREATE TABLE #tmp_insert (col FLOAT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(FLOAT, '-1234.25')
DROP TABLE #tmp_insert
SELECT CONVERT(REAL, '1234.25')
CREATE TABLE #tmp_insert (col FLOAT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(FLOAT, '1234.25')
DROP TABLE #tmp_insert
SELECT CONVERT(FLOAT, '-1234.25')
CREATE TABLE #tmp_insert (col FLOAT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(FLOAT, '-1234.25')
DROP TABLE #tmp_insert
SELECT CONVERT(FLOAT, '1234.25')
CREATE TABLE #tmp_insert (col FLOAT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(FLOAT, '1234.25')
DROP TABLE #tmp_insert
SELECT CONVERT(REAL, '-1234.25')
CREATE TABLE #tmp_insert (col FLOAT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(FLOAT, '-1234.25')
DROP TABLE #tmp_insert
SELECT CONVERT(FLOAT, '1234.25')
CREATE TABLE #tmp_insert (col FLOAT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(FLOAT, '1234.25')
DROP TABLE #tmp_insert
SELECT CONVERT(REAL, '-1234.25')
CREATE TABLE #tmp_insert (col FLOAT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(FLOAT, '-1234.25')
DROP TABLE #tmp_insert
SELECT CONVERT(TINYINT, '231')
CREATE TABLE #tmp_insert (col TINYINT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(TINYINT, '231')
DROP TABLE #tmp_insert
SELECT CONVERT(NUMERIC(20,3), '765432.2')
CREATE TABLE #tmp_insert (col NUMERIC(20,3))
SELECT * FROM #tmp_insert WHERE col = CONVERT(NUMERIC(20,3), '765432')
DROP TABLE #tmp_insert
SELECT CONVERT(BIT, '0')
CREATE TABLE #tmp_insert (col BIT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(BIT, '0')
DROP TABLE #tmp_insert
SELECT CONVERT(BIT, '1')
CREATE TABLE #tmp_insert (col BIT)
SELECT * FROM #tmp_insert WHERE col = CONVERT(BIT, '1')
DROP TABLE #tmp_insert
SELECT CONVERT(MONEY, '123.34')
CREATE TABLE #tmp_insert (col MONEY)
SELECT * FROM #tmp_insert WHERE col = CONVERT(MONEY, '123.34')
DROP TABLE #tmp_insert
SELECT CONVERT(VARCHAR(20), '1EasyTest')
CREATE TABLE #tmp_insert (col VARCHAR(20))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARCHAR(20), '1EasyTest')
DROP TABLE #tmp_insert
SELECT CONVERT(VARCHAR(20), 'meô')
CREATE TABLE #tmp_insert (col VARCHAR(20))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARCHAR(20), 'meô')
DROP TABLE #tmp_insert
IF OBJECT_ID('spTestProc') IS NOT NULL DROP PROC spTestProc
CREATE PROC spTestProc @i VARCHAR(20) OUTPUT AS SELECT @i = CONVERT(VARCHAR(20), 'foo test')
drop proc spTestProc
IF OBJECT_ID('spTestProc') IS NOT NULL DROP PROC spTestProc
CREATE PROC spTestProc @i VARCHAR(20) OUTPUT AS SELECT @i = CONVERT(VARCHAR(20), 0xf8f9)
drop proc spTestProc
Your connection seems to not support cursors, probably you are using wrong protocol version or Sybase
--2094-- Discarding syms at 0x41F7000-0x41FA000 in /usr/lib/gconv/ISO8859-1.so due to munmap()
--2094-- Discarding syms at 0x40E0000-0x40EC000 in /lib/libnss_files-2.7.so due to munmap()
--2094-- Discarding syms at 0x420C000-0x4217000 in /lib/libnss_winbind.so.2 due to munmap()
==2094==
==2094== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 28 from 1)
--2094--
--2094-- supp: 28 dl-hack3
==2094== malloc/free: in use at exit: 4 bytes in 1 blocks.
==2094== malloc/free: 5,172 allocs, 5,171 frees, 837,015 bytes allocated.
==2094==
==2094== searching for pointers to 1 not-freed blocks.
==2094== checked 248,496 bytes.
==2094==
==2094== LEAK SUMMARY:
==2094== definitely lost: 0 bytes in 0 blocks.
==2094== possibly lost: 0 bytes in 0 blocks.
==2094== still reachable: 0 bytes in 0 blocks.
==2094== suppressed: 4 bytes in 1 blocks.
--2094-- memcheck: sanity checks: 33 cheap, 2 expensive
--2094-- memcheck: auxmaps: 0 auxmap entries (0k, 0M) in use
--2094-- memcheck: auxmaps: 0 searches, 0 comparisons
--2094-- memcheck: SMs: n_issued = 43 (688k, 0M)
--2094-- memcheck: SMs: n_deissued = 0 (0k, 0M)
--2094-- memcheck: SMs: max_noaccess = 65535 (1048560k, 1023M)
--2094-- memcheck: SMs: max_undefined = 0 (0k, 0M)
--2094-- memcheck: SMs: max_defined = 48 (768k, 0M)
--2094-- memcheck: SMs: max_non_DSM = 43 (688k, 0M)
--2094-- memcheck: max sec V bit nodes: 14 (0k, 0M)
--2094-- memcheck: set_sec_vbits8 calls: 1328 (new: 14, updates: 1314)
--2094-- memcheck: max shadow mem size: 992k, 0M
--2094-- translate: fast SP updates identified: 11,635 ( 88.4%)
--2094-- translate: generic_known SP updates identified: 1,231 ( 9.3%)
--2094-- translate: generic_unknown SP updates identified: 290 ( 2.2%)
--2094-- tt/tc: 49,802 tt lookups requiring 53,455 probes
--2094-- tt/tc: 49,802 fast-cache updates, 6 flushes
--2094-- transtab: new 10,296 (308,778 -> 4,845,770; ratio 156:10) [0 scs]
--2094-- transtab: dumped 0 (0 -> ??)
--2094-- transtab: discarded 362 (7,290 -> ??)
--2094-- scheduler: 3,318,965 jumps (bb entries).
--2094-- scheduler: 33/54,637 major/minor sched events.
--2094-- sanity: 34 cheap, 2 expensive checks.
--2094-- exectx: 30,011 lists, 9,982 contexts (avg 0 per list)
--2094-- exectx: 10,195 searches, 1,901 full compares (186 per 1000)
--2094-- exectx: 0 cmp2, 85 cmp4, 0 cmpAll
Main