src/odbc/unittests/genparams
Main
| Hostname | obol602 |
|---|
| uname -a | Linux obol602 2.6.31-15-generic #50-Ubuntu SMP Tue Nov 10 14:53:52 UTC 2009 x86_64 GNU/Linux |
|---|
| date | 2009-11-27 |
|---|
==15267== Memcheck, a memory error detector
==15267== Copyright (C) 2002-2009, and GNU GPL'd, by Julian Seward et al.
==15267== Using Valgrind-3.5.0-Debian and LibVEX; rerun with -h for copyright info
==15267== Command: ./genparams
==15267==
--15267-- Valgrind options:
--15267-- --suppressions=/usr/lib/valgrind/debian-libc6-dbg.supp
--15267-- --tool=memcheck
--15267-- --num-callers=20
--15267-- --leak-check=yes
--15267-- -v
--15267-- --show-reachable=yes
--15267-- --log-fd=3
--15267-- --suppressions=/home/freddy/suppressions.supp
--15267-- Contents of /proc/version:
--15267-- Linux version 2.6.31-15-generic (buildd@yellow) (gcc version 4.4.1 (Ubuntu 4.4.1-4ubuntu8) ) #50-Ubuntu SMP Tue Nov 10 14:53:52 UTC 2009
--15267-- Arch and hwcaps: AMD64, amd64-sse3-cx16
--15267-- Page sizes: currently 4096, max supported 4096
--15267-- Valgrind library directory: /usr/lib/valgrind
--15267-- Reading syms from /home/freddy/cpp/freetds/ftds_comp82/src/odbc/unittests/genparams (0x400000)
--15267-- Reading syms from /lib/ld-2.10.1.so (0x4000000)
--15267-- Reading debug info from /lib/ld-2.10.1.so ..
--15267-- .. CRC mismatch (computed 27e0048f wanted 447ba3bc)
--15267-- Reading debug info from /usr/lib/debug/lib/ld-2.10.1.so ..
--15267-- Reading syms from /usr/lib/valgrind/memcheck-amd64-linux (0x38000000)
--15267-- object doesn't have a dynamic symbol table
--15267-- Reading suppressions file: /usr/lib/valgrind/debian-libc6-dbg.supp
--15267-- Reading suppressions file: /home/freddy/suppressions.supp
--15267-- Reading suppressions file: /usr/lib/valgrind/default.supp
--15267-- REDIR: 0x4017050 (strlen) redirected to 0x3803fa17 (vgPlain_amd64_linux_REDIR_FOR_strlen)
--15267-- Reading syms from /usr/lib/valgrind/vgpreload_core-amd64-linux.so (0x4a20000)
--15267-- Reading syms from /usr/lib/valgrind/vgpreload_memcheck-amd64-linux.so (0x4c22000)
==15267== WARNING: new redirection conflicts with existing -- ignoring it
--15267-- new: 0x04017050 (strlen ) R-> 0x04c26210 strlen
--15267-- REDIR: 0x4016ec0 (index) redirected to 0x4c25f60 (index)
--15267-- REDIR: 0x4016f40 (strcmp) redirected to 0x4c26510 (strcmp)
--15267-- Reading syms from /home/freddy/cpp/freetds/ftds_comp82/src/odbc/.libs/libtdsodbc.so.0.0.0 (0x4e2a000)
--15267-- Reading syms from /usr/lib/libgnutls.so.26.14.10 (0x50e2000)
--15267-- Reading debug info from /usr/lib/libgnutls.so.26.14.10 ..
--15267-- .. CRC mismatch (computed e962bb1e wanted 1627984e)
--15267-- Reading debug info from /usr/lib/debug/usr/lib/libgnutls.so.26.14.10 ..
--15267-- Reading syms from /lib/libpthread-2.10.1.so (0x5384000)
--15267-- Reading debug info from /lib/libpthread-2.10.1.so ..
--15267-- .. CRC mismatch (computed 217e8639 wanted 7a12e000)
--15267-- Reading debug info from /usr/lib/debug/lib/libpthread-2.10.1.so ..
--15267-- Reading syms from /lib/libc-2.10.1.so (0x55a0000)
--15267-- Reading debug info from /lib/libc-2.10.1.so ..
--15267-- .. CRC mismatch (computed 9003397f wanted a4efd6e8)
--15267-- Reading debug info from /usr/lib/debug/lib/libc-2.10.1.so ..
--15267-- Reading syms from /lib/librt-2.10.1.so (0x590f000)
--15267-- Reading debug info from /lib/librt-2.10.1.so ..
--15267-- .. CRC mismatch (computed e0bf5db1 wanted 745ed498)
--15267-- Reading debug info from /usr/lib/debug/lib/librt-2.10.1.so ..
--15267-- Reading syms from /usr/lib/libtasn1.so.3.1.5 (0x5b17000)
--15267-- Reading debug info from /usr/lib/libtasn1.so.3.1.5 ..
--15267-- .. CRC mismatch (computed 9c17bda6 wanted d502479b)
--15267-- object doesn't have a symbol table
--15267-- Reading syms from /lib/libz.so.1.2.3.3 (0x5d28000)
--15267-- Reading debug info from /lib/libz.so.1.2.3.3 ..
--15267-- .. CRC mismatch (computed 3957eb9d wanted 90f25be3)
--15267-- object doesn't have a symbol table
--15267-- Reading syms from /lib/libgcrypt.so.11.5.2 (0x5f3f000)
--15267-- Reading debug info from /lib/libgcrypt.so.11.5.2 ..
--15267-- .. CRC mismatch (computed 77ef73e7 wanted f3b95632)
--15267-- Reading debug info from /usr/lib/debug/lib/libgcrypt.so.11.5.2 ..
--15267-- Reading syms from /lib/libgpg-error.so.0.4.0 (0x61b7000)
--15267-- Reading debug info from /lib/libgpg-error.so.0.4.0 ..
--15267-- .. CRC mismatch (computed 5580a1c2 wanted 3127cddf)
--15267-- object doesn't have a symbol table
--15267-- REDIR: 0x561f7e0 (rindex) redirected to 0x4c25dc0 (rindex)
--15267-- REDIR: 0x561f3b0 (strlen) redirected to 0x4c261d0 (strlen)
--15267-- REDIR: 0x561a780 (malloc) redirected to 0x4c250d1 (malloc)
--15267-- REDIR: 0x56224c0 (memcpy) redirected to 0x4c265e0 (memcpy)
--15267-- REDIR: 0x561ee20 (strcmp) redirected to 0x4c264c0 (strcmp)
--15267-- REDIR: 0x56208d0 (memchr) redirected to 0x4c265b0 (memchr)
--15267-- REDIR: 0x561ee60 (strcpy) redirected to 0x4c26230 (strcpy)
--15267-- REDIR: 0x561a6a0 (free) redirected to 0x4c24ce1 (free)
--15267-- REDIR: 0x561ebe0 (strcat) redirected to 0x4c25fa0 (strcat)
--15267-- REDIR: 0x5624e90 (strchrnul) redirected to 0x4c27160 (strchrnul)
--15267-- REDIR: 0x5621b50 (mempcpy) redirected to 0x4c271b0 (mempcpy)
--15267-- REDIR: 0x55d8840 (setenv) redirected to 0x4c274b0 (setenv)
--15267-- REDIR: 0x561eda0 (index) redirected to 0x4c25e60 (index)
--15267-- REDIR: 0x561f580 (strncmp) redirected to 0x4c26450 (strncmp)
--15267-- REDIR: 0x561b4c0 (realloc) redirected to 0x4c25182 (realloc)
--15267-- REDIR: 0x5619d70 (calloc) redirected to 0x4c243c9 (calloc)
odbctest
--------
connection parameters:
server: 'sybase'
user: 'testuser'
password: '????'
database: 'FreeTDS'
--15267-- REDIR: 0x5621020 (memset) redirected to 0x4c27080 (memset)
--15267-- REDIR: 0x5620950 (bcmp) redirected to 0x4c26d70 (bcmp)
--15267-- REDIR: 0x5622170 (stpcpy) redirected to 0x4c26e10 (stpcpy)
--15267-- Reading syms from /lib/libnss_compat-2.10.1.so (0x67bb000)
--15267-- Reading debug info from /lib/libnss_compat-2.10.1.so ..
--15267-- .. CRC mismatch (computed 87a816bf wanted 753a1f07)
--15267-- Reading debug info from /usr/lib/debug/lib/libnss_compat-2.10.1.so ..
--15267-- Reading syms from /lib/libnsl-2.10.1.so (0x69c4000)
--15267-- Reading debug info from /lib/libnsl-2.10.1.so ..
--15267-- .. CRC mismatch (computed 3749f1e8 wanted 750c9fd1)
--15267-- Reading debug info from /usr/lib/debug/lib/libnsl-2.10.1.so ..
--15267-- Reading syms from /lib/libnss_nis-2.10.1.so (0x6bde000)
--15267-- Reading debug info from /lib/libnss_nis-2.10.1.so ..
--15267-- .. CRC mismatch (computed 2839fa35 wanted 4fda88b3)
--15267-- Reading debug info from /usr/lib/debug/lib/libnss_nis-2.10.1.so ..
--15267-- Reading syms from /lib/libnss_files-2.10.1.so (0x6de9000)
--15267-- Reading debug info from /lib/libnss_files-2.10.1.so ..
--15267-- .. CRC mismatch (computed 1e8ecf79 wanted 95e01138)
--15267-- Reading debug info from /usr/lib/debug/lib/libnss_files-2.10.1.so ..
--15267-- REDIR: 0x561f660 (strncpy) redirected to 0x4c26300 (strncpy)
--15267-- REDIR: 0x5624e30 (rawmemchr) redirected to 0x4c27190 (rawmemchr)
--15267-- Reading syms from /usr/lib/gconv/ISO8859-1.so (0x6ff6000)
--15267-- Reading debug info from /usr/lib/gconv/ISO8859-1.so ..
--15267-- .. CRC mismatch (computed cb3aff31 wanted 2fb673ac)
--15267-- Reading debug info from /usr/lib/debug/usr/lib/gconv/ISO8859-1.so ..
--15267-- REDIR: 0x4017ae0 (stpcpy) redirected to 0x4c26fb0 (stpcpy)
use FreeTDS
--15267-- REDIR: 0x5620e60 (memmove) redirected to 0x4c270f0 (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
--15267-- REDIR: 0x561f400 (strnlen) redirected to 0x4c26190 (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
--15267-- REDIR: 0xffffffffff600400 (???) redirected to 0x3803fa0d (vgPlain_amd64_linux_REDIR_FOR_vtime)
SELECT GETDATE()
SELECT CONVERT(DATETIME, '2003-07-22 13:02:03')
CREATE TABLE #tmp_insert (col DATETIME)
--15267-- REDIR: 0xffffffffff600000 (???) redirected to 0x3803fa03 (vgPlain_amd64_linux_REDIR_FOR_vgettimeofday)
SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2009-11-27 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
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, '2009-11-27 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
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, '2009-11-27 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
Your connection seems to not support cursors, probably you are using wrong protocol version or Sybase
--15267-- Discarding syms at 0x6ff64d0-0x6ff7058 in /usr/lib/gconv/ISO8859-1.so due to munmap()
--15267-- Discarding syms at 0x67bc310-0x67c12c8 in /lib/libnss_compat-2.10.1.so due to munmap()
--15267-- Discarding syms at 0x6be0020-0x6be64a8 in /lib/libnss_nis-2.10.1.so due to munmap()
--15267-- Discarding syms at 0x69c80c0-0x69d5978 in /lib/libnsl-2.10.1.so due to munmap()
--15267-- Discarding syms at 0x6deb170-0x6df2b68 in /lib/libnss_files-2.10.1.so due to munmap()
==15267==
==15267== HEAP SUMMARY:
==15267== in use at exit: 300 bytes in 11 blocks
==15267== total heap usage: 4,617 allocs, 4,606 frees, 925,919 bytes allocated
==15267==
==15267== Searching for pointers to 11 not-freed blocks
==15267== Checked 237,464 bytes
==15267==
==15267== LEAK SUMMARY:
==15267== definitely lost: 0 bytes in 0 blocks
==15267== indirectly lost: 0 bytes in 0 blocks
==15267== possibly lost: 0 bytes in 0 blocks
==15267== still reachable: 0 bytes in 0 blocks
==15267== suppressed: 300 bytes in 11 blocks
==15267==
==15267== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 5 from 5)
--15267--
--15267-- used_suppression: 1 getpwuid_r leak 3
--15267-- used_suppression: 5 getpwuid_r leak 2
--15267-- used_suppression: 5 getpwuid_r leak 1
--15267-- used_suppression: 2 Debian libc6 (2.10.x) stripped dynamic linker
--15267-- used_suppression: 2 Debian libc6 (2.10.x) stripped dynamic linker
==15267==
==15267== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 5 from 5)
Main