src/odbc/unittests/genparams

Main

Hostnamefreddy
uname -aLinux freddy 4.4.0-22-generic #40-Ubuntu SMP Thu May 12 22:03:46 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux
date2016-05-31

==21081== Memcheck, a memory error detector
==21081== Copyright (C) 2002-2015, and GNU GPL'd, by Julian Seward et al.
==21081== Using Valgrind-3.12.0.SVN and LibVEX; rerun with -h for copyright info
==21081== Command: ./genparams
==21081== 
--21081-- Valgrind options:
--21081--    --tool=memcheck
--21081--    --vgdb=no
--21081--    --num-callers=20
--21081--    --leak-check=yes
--21081--    -v
--21081--    --show-reachable=yes
--21081--    --log-fd=3
--21081--    --suppressions=/home/freddy/suppressions.supp
--21081--    --track-origins=yes
--21081-- Contents of /proc/version:
--21081--   Linux version 4.4.0-22-generic (buildd@lgw01-41) (gcc version 5.3.1 20160413 (Ubuntu 5.3.1-14ubuntu2) ) #40-Ubuntu SMP Thu May 12 22:03:46 UTC 2016
--21081-- 
--21081-- Arch and hwcaps: AMD64, LittleEndian, amd64-cx16-lzcnt-rdtscp-sse3-avx-avx2-bmi
--21081-- Page sizes: currently 4096, max supported 4096
--21081-- Valgrind library directory: /home/freddy/install/lib/valgrind
--21081-- Reading syms from /home/freddy/ftdstmp/ftds_comp100/test2/src/odbc/unittests/genparams
--21081-- Reading syms from /lib/x86_64-linux-gnu/ld-2.23.so
--21081--   Considering /lib/x86_64-linux-gnu/ld-2.23.so ..
--21081--   .. CRC mismatch (computed d3da0723 wanted a1c29704)
--21081--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/ld-2.23.so ..
--21081--   .. CRC is valid
--21081-- Reading syms from /home/freddy/install/lib/valgrind/memcheck-amd64-linux
--21081--    object doesn't have a dynamic symbol table
--21081-- Scheduler: using generic scheduler lock implementation.
--21081-- Reading suppressions file: /home/freddy/suppressions.supp
--21081-- Reading suppressions file: /home/freddy/install/lib/valgrind/default.supp
--21081-- REDIR: 0x401cdc0 (ld-linux-x86-64.so.2:strlen) redirected to 0x3809ecf1 (vgPlain_amd64_linux_REDIR_FOR_strlen)
--21081-- REDIR: 0x401b710 (ld-linux-x86-64.so.2:index) redirected to 0x3809ed0b (vgPlain_amd64_linux_REDIR_FOR_index)
--21081-- Reading syms from /home/freddy/install/lib/valgrind/vgpreload_core-amd64-linux.so
--21081-- Reading syms from /home/freddy/install/lib/valgrind/vgpreload_memcheck-amd64-linux.so
==21081== WARNING: new redirection conflicts with existing -- ignoring it
--21081--     old: 0x0401cdc0 (strlen              ) R-> (0000.0) 0x3809ecf1 vgPlain_amd64_linux_REDIR_FOR_strlen
--21081--     new: 0x0401cdc0 (strlen              ) R-> (2007.0) 0x04c30a90 strlen
--21081-- REDIR: 0x401b930 (ld-linux-x86-64.so.2:strcmp) redirected to 0x4c31b40 (strcmp)
--21081-- REDIR: 0x401db20 (ld-linux-x86-64.so.2:mempcpy) redirected to 0x4c34d20 (mempcpy)
--21081-- Reading syms from /home/freddy/ftdstmp/ftds_comp100/src/odbc/.libs/libtdsodbc.so.0.0.0
--21081-- Reading syms from /lib/x86_64-linux-gnu/libpthread-2.23.so
--21081--   Considering /usr/lib/debug/.build-id/b7/7847cc9cacbca3b5753d0d25a32e5795afe75b.debug ..
--21081--   .. build-id is valid
--21081-- Reading syms from /lib/x86_64-linux-gnu/libc-2.23.so
--21081--   Considering /lib/x86_64-linux-gnu/libc-2.23.so ..
--21081--   .. CRC mismatch (computed 2adb2e50 wanted 9b73f606)
--21081--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libc-2.23.so ..
--21081--   .. CRC is valid
--21081-- Reading syms from /usr/lib/x86_64-linux-gnu/libgssapi_krb5.so.2.2
--21081--   Considering /usr/lib/x86_64-linux-gnu/libgssapi_krb5.so.2.2 ..
--21081--   .. CRC mismatch (computed 234d2626 wanted 1ab49fb0)
--21081--    object doesn't have a symbol table
--21081-- Reading syms from /lib/x86_64-linux-gnu/libssl.so.1.0.0
--21081--    object doesn't have a symbol table
--21081-- Reading syms from /lib/x86_64-linux-gnu/libcrypto.so.1.0.0
--21081--    object doesn't have a symbol table
--21081-- Reading syms from /usr/lib/x86_64-linux-gnu/libkrb5.so.3.3
--21081--   Considering /usr/lib/x86_64-linux-gnu/libkrb5.so.3.3 ..
--21081--   .. CRC mismatch (computed a79adaf9 wanted 3edf8bac)
--21081--    object doesn't have a symbol table
--21081-- Reading syms from /usr/lib/x86_64-linux-gnu/libk5crypto.so.3.1
--21081--   Considering /usr/lib/x86_64-linux-gnu/libk5crypto.so.3.1 ..
--21081--   .. CRC mismatch (computed 5654054d wanted 7d4672a0)
--21081--    object doesn't have a symbol table
--21081-- Reading syms from /lib/x86_64-linux-gnu/libcom_err.so.2.1
--21081--   Considering /lib/x86_64-linux-gnu/libcom_err.so.2.1 ..
--21081--   .. CRC mismatch (computed 0c5846b0 wanted 1b47dcd1)
--21081--    object doesn't have a symbol table
--21081-- Reading syms from /usr/lib/x86_64-linux-gnu/libkrb5support.so.0.1
--21081--   Considering /usr/lib/x86_64-linux-gnu/libkrb5support.so.0.1 ..
--21081--   .. CRC mismatch (computed 84efbe11 wanted 9d23b09f)
--21081--    object doesn't have a symbol table
--21081-- Reading syms from /lib/x86_64-linux-gnu/libdl-2.23.so
--21081--   Considering /lib/x86_64-linux-gnu/libdl-2.23.so ..
--21081--   .. CRC mismatch (computed b7ff3c20 wanted 623a46c3)
--21081--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libdl-2.23.so ..
--21081--   .. CRC is valid
--21081-- Reading syms from /lib/x86_64-linux-gnu/libkeyutils.so.1.5
--21081--    object doesn't have a symbol table
--21081-- Reading syms from /lib/x86_64-linux-gnu/libresolv-2.23.so
--21081--   Considering /lib/x86_64-linux-gnu/libresolv-2.23.so ..
--21081--   .. CRC mismatch (computed 87659676 wanted 8389f31d)
--21081--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libresolv-2.23.so ..
--21081--   .. CRC is valid
--21081-- REDIR: 0x53befd0 (libc.so.6:strcasecmp) redirected to 0x4a28770 (_vgnU_ifunc_wrapper)
--21081-- REDIR: 0x53ba850 (libc.so.6:strcspn) redirected to 0x4a28770 (_vgnU_ifunc_wrapper)
--21081-- REDIR: 0x53c12c0 (libc.so.6:strncasecmp) redirected to 0x4a28770 (_vgnU_ifunc_wrapper)
--21081-- REDIR: 0x53bccc0 (libc.so.6:strpbrk) redirected to 0x4a28770 (_vgnU_ifunc_wrapper)
--21081-- REDIR: 0x53bd050 (libc.so.6:strspn) redirected to 0x4a28770 (_vgnU_ifunc_wrapper)
--21081-- REDIR: 0x53be71b (libc.so.6:memcpy@GLIBC_2.2.5) redirected to 0x4a28770 (_vgnU_ifunc_wrapper)
--21081-- REDIR: 0x53b9050 (libc.so.6:index) redirected to 0x4a28770 (_vgnU_ifunc_wrapper)
--21081-- REDIR: 0x53be180 (libc.so.6:bcmp) redirected to 0x4a28770 (_vgnU_ifunc_wrapper)
--21081-- REDIR: 0x53b92a0 (libc.so.6:strcmp) redirected to 0x4a28770 (_vgnU_ifunc_wrapper)
--21081-- REDIR: 0x53c39c0 (libc.so.6:memcpy@@GLIBC_2.14) redirected to 0x4a28770 (_vgnU_ifunc_wrapper)
--21081-- REDIR: 0x53bc9d0 (libc.so.6:rindex) redirected to 0x4c30410 (rindex)
--21081-- REDIR: 0x53bacf0 (libc.so.6:strlen) redirected to 0x4c309d0 (strlen)
--21081-- REDIR: 0x53b3550 (libc.so.6:malloc) redirected to 0x4c2db2f (malloc)
--21081-- REDIR: 0x547d6d0 (libc.so.6:__memcpy_avx_unaligned) redirected to 0x4c31f10 (memcpy@@GLIBC_2.14)
--21081-- REDIR: 0x53be780 (libc.so.6:memset) redirected to 0x4a28770 (_vgnU_ifunc_wrapper)
--21081-- REDIR: 0x54a21a0 (libc.so.6:__memset_avx2) redirected to 0x4c33f30 (memset)
--21081-- REDIR: 0x549dc60 (libc.so.6:__memcmp_sse4_1) redirected to 0x4c33740 (__memcmp_sse4_1)
--21081-- REDIR: 0x53b3a70 (libc.so.6:free) redirected to 0x4c2ec29 (free)
--21081-- REDIR: 0x53b4290 (libc.so.6:calloc) redirected to 0x4c2f8b2 (calloc)
--21081-- REDIR: 0x53bc990 (libc.so.6:strncpy) redirected to 0x4a28770 (_vgnU_ifunc_wrapper)
--21081-- REDIR: 0x53d55d0 (libc.so.6:__strncpy_sse2_unaligned) redirected to 0x4c30fe0 (__strncpy_sse2_unaligned)
--21081-- REDIR: 0x53bee20 (libc.so.6:stpcpy) redirected to 0x4a28770 (_vgnU_ifunc_wrapper)
--21081-- REDIR: 0x53d65b0 (libc.so.6:__stpcpy_sse2_unaligned) redirected to 0x4c33b90 (__stpcpy_sse2_unaligned)
--21081-- REDIR: 0x53bb140 (libc.so.6:__GI_strncmp) redirected to 0x4c31180 (__GI_strncmp)
--21081-- REDIR: 0x53bd630 (libc.so.6:__GI_strstr) redirected to 0x4c34f80 (__strstr_sse2)
--21081-- REDIR: 0x53bde30 (libc.so.6:memchr) redirected to 0x4c31be0 (memchr)
--21081-- REDIR: 0x53c3a40 (libc.so.6:__GI_memcpy) redirected to 0x4c32570 (__GI_memcpy)
--21081-- REDIR: 0x5445bc0 (libc.so.6:__strcpy_chk) redirected to 0x4c348c0 (__strcpy_chk)
--21081-- REDIR: 0x547a1b0 (libc.so.6:__strcasecmp_avx) redirected to 0x4c312d0 (strcasecmp)
--21081-- REDIR: 0x53c5d30 (libc.so.6:strchrnul) redirected to 0x4c34850 (strchrnul)
--21081-- REDIR: 0x53be980 (libc.so.6:__GI_mempcpy) redirected to 0x4c34a50 (__GI_mempcpy)
--21081-- REDIR: 0x5369c90 (libc.so.6:setenv) redirected to 0x4c35550 (setenv)
--21081-- REDIR: 0x53b9080 (libc.so.6:__GI_strchr) redirected to 0x4c30570 (__GI_strchr)
--21081-- REDIR: 0x53b3c40 (libc.so.6:realloc) redirected to 0x4c2fa81 (realloc)
--21081-- REDIR: 0x53b92e0 (libc.so.6:__GI_strcmp) redirected to 0x4c31a50 (__GI_strcmp)
odbctest
--------

connection parameters:
server:   'sybase'
user:     'testuser'
password: '????'
database: 'FreeTDS'
--21081-- REDIR: 0x53ceb40 (libc.so.6:__strcmp_sse2_unaligned) redirected to 0x4c31a00 (strcmp)
--21081-- REDIR: 0x547b820 (libc.so.6:__strncasecmp_avx) redirected to 0x4c313b0 (strncasecmp)
--21081-- REDIR: 0x53bee60 (libc.so.6:__GI_stpcpy) redirected to 0x4c339f0 (__GI_stpcpy)
--21081-- Reading syms from /lib/x86_64-linux-gnu/libnss_compat-2.23.so
--21081--   Considering /lib/x86_64-linux-gnu/libnss_compat-2.23.so ..
--21081--   .. CRC mismatch (computed a9955d05 wanted fb5bcc8f)
--21081--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnss_compat-2.23.so ..
--21081--   .. CRC is valid
--21081-- Reading syms from /lib/x86_64-linux-gnu/libnsl-2.23.so
--21081--   Considering /lib/x86_64-linux-gnu/libnsl-2.23.so ..
--21081--   .. CRC mismatch (computed a5a10c48 wanted 9d2e1498)
--21081--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnsl-2.23.so ..
--21081--   .. CRC is valid
--21081-- REDIR: 0x53ba770 (libc.so.6:__GI_strcpy) redirected to 0x4c30b80 (__GI_strcpy)
--21081-- Reading syms from /lib/x86_64-linux-gnu/libnss_nis-2.23.so
--21081--   Considering /lib/x86_64-linux-gnu/libnss_nis-2.23.so ..
--21081--   .. CRC mismatch (computed 34132a3b wanted 31617a24)
--21081--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnss_nis-2.23.so ..
--21081--   .. CRC is valid
--21081-- Reading syms from /lib/x86_64-linux-gnu/libnss_files-2.23.so
--21081--   Considering /lib/x86_64-linux-gnu/libnss_files-2.23.so ..
--21081--   .. CRC mismatch (computed 787ef17f wanted 48302948)
--21081--   Considering /usr/lib/debug/lib/x86_64-linux-gnu/libnss_files-2.23.so ..
--21081--   .. CRC is valid
--21081-- REDIR: 0x53c5b20 (libc.so.6:rawmemchr) redirected to 0x4c34880 (rawmemchr)
--21081-- Reading syms from /usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so
--21081--   Considering /usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so ..
--21081--   .. CRC mismatch (computed d872b97c wanted 2237059d)
--21081--   Considering /usr/lib/debug/usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so ..
--21081--   .. CRC is valid
--21081-- REDIR: 0x401dc70 (ld-linux-x86-64.so.2:stpcpy) redirected to 0x4c33d30 (stpcpy)
--21081-- Reading syms from /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so
--21081--   Considering /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so ..
--21081--   .. CRC mismatch (computed b03c450e wanted 425e109b)
--21081--   Considering /usr/lib/debug/usr/lib/x86_64-linux-gnu/gconv/UTF-16.so ..
--21081--   .. CRC is valid
use FreeTDS
use_cursors 0 exec_direct 1 prepare_before 0
CREATE TABLE #tmp_insert (col VARCHAR(100) NULL)
--21081-- REDIR: 0x53bdc00 (libc.so.6:strstr) redirected to 0x4a28770 (_vgnU_ifunc_wrapper)
--21081-- REDIR: 0x53d9640 (libc.so.6:__strstr_sse2_unaligned) redirected to 0x4c34f10 (strstr)
SELECT * FROM #tmp_insert WHERE col IS NULL
DROP TABLE #tmp_insert
CREATE TABLE #tmp_insert (col TEXT NULL)
SELECT * FROM #tmp_insert WHERE DATALENGTH(col) = 0 OR DATALENGTH(col) IS NULL
DROP TABLE #tmp_insert
CREATE TABLE #tmp_insert (col INTEGER NULL)
SELECT * FROM #tmp_insert WHERE col IS NULL
DROP TABLE #tmp_insert
CREATE TABLE #tmp_insert (col TEXT NULL)
SELECT * FROM #tmp_insert WHERE DATALENGTH(col) = 0 OR DATALENGTH(col) IS NULL
DROP TABLE #tmp_insert
CREATE TABLE #tmp_insert (col DATETIME NULL)
SELECT * FROM #tmp_insert WHERE col IS NULL
DROP TABLE #tmp_insert
CREATE TABLE #tmp_insert (col FLOAT NULL)
SELECT * FROM #tmp_insert WHERE col IS NULL
DROP TABLE #tmp_insert
CREATE TABLE #tmp_insert (col TEXT NULL)
SELECT * FROM #tmp_insert WHERE DATALENGTH(col) = 0 OR DATALENGTH(col) IS NULL
DROP TABLE #tmp_insert
CREATE TABLE #tmp_insert (col MONEY NULL)
SELECT * FROM #tmp_insert WHERE col IS NULL
DROP TABLE #tmp_insert
IF OBJECT_ID('spTestProc') IS NOT NULL DROP PROC spTestProc
--21081-- REDIR: 0x547d1e0 (libc.so.6:__memmove_avx_unaligned) redirected to 0x4c31ca0 (memcpy@GLIBC_2.2.5)
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
--21081-- REDIR: 0x53bae90 (libc.so.6:strnlen) redirected to 0x4c30950 (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
SELECT CONVERT(INTEGER, '12345')
CREATE TABLE #tmp_insert (col TEXT)
SELECT * FROM #tmp_insert WHERE CONVERT(VARCHAR(255), col) = CONVERT(VARCHAR(255), '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 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)
--21081-- REDIR: 0x53ba730 (libc.so.6:strcpy) redirected to 0x4a28770 (_vgnU_ifunc_wrapper)
--21081-- REDIR: 0x53d4fa0 (libc.so.6:__strcpy_sse2_unaligned) redirected to 0x4c30ab0 (strcpy)
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
--21081-- REDIR: 0x53be1c0 (libc.so.6:__GI_memcmp) redirected to 0x4c33600 (__GI_memcmp)
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, '2016-05-31 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))
--21081-- REDIR: 0x5445950 (libc.so.6:__memcpy_chk) redirected to 0x4a28770 (_vgnU_ifunc_wrapper)
--21081-- REDIR: 0x547d6c0 (libc.so.6:__memcpy_chk_avx_unaligned) redirected to 0x4c34e10 (__memcpy_chk)
SELECT * FROM #tmp_insert WHERE col = CONVERT(NUMERIC(20,3), '765432')
DROP TABLE #tmp_insert
SELECT CONVERT(NUMERIC(20,3), '578246.234')
CREATE TABLE #tmp_insert (col VARCHAR(20))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARCHAR(20), '578246')
DROP TABLE #tmp_insert
SELECT CONVERT(NUMERIC(20,3), '578246.234')
CREATE TABLE #tmp_insert (col TEXT)
SELECT * FROM #tmp_insert WHERE CONVERT(VARCHAR(255), col) = CONVERT(VARCHAR(255), '578246')
DROP TABLE #tmp_insert
SELECT CONVERT(VARCHAR(100), '4145544F')
CREATE TABLE #tmp_insert (col VARBINARY(20))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARBINARY(20), 'AETO')
DROP TABLE #tmp_insert
SELECT CONVERT(TEXT, '4145544F')
CREATE TABLE #tmp_insert (col VARBINARY(20))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARBINARY(20), 'AETO')
DROP TABLE #tmp_insert
SELECT CONVERT(VARCHAR(100), '4145544F')
CREATE TABLE #tmp_insert (col IMAGE)
SELECT * FROM #tmp_insert WHERE CONVERT(VARBINARY(255), col) = CONVERT(VARBINARY(255), 'AETO')
DROP TABLE #tmp_insert
SELECT CONVERT(VARBINARY(100), 0x4145544F)
CREATE TABLE #tmp_insert (col VARCHAR(20))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARCHAR(20), 'AETO')
DROP TABLE #tmp_insert
SELECT CONVERT(IMAGE, 0x4145544F)
CREATE TABLE #tmp_insert (col VARCHAR(20))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARCHAR(20), 'AETO')
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), '1EasyTest')
CREATE TABLE #tmp_insert (col TEXT)
SELECT * FROM #tmp_insert WHERE CONVERT(VARCHAR(255), col) = CONVERT(VARCHAR(255), '1EasyTest')
DROP TABLE #tmp_insert
SELECT CONVERT(VARCHAR(10), 'Test 12345')
CREATE TABLE #tmp_insert (col VARCHAR(10))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARCHAR(10), 'Test 12345')
DROP TABLE #tmp_insert
SELECT CONVERT(VARCHAR(10), 'Test 12345')
CREATE TABLE #tmp_insert (col TEXT)
SELECT * FROM #tmp_insert WHERE CONVERT(VARCHAR(255), col) = CONVERT(VARCHAR(255), 'Test 12345')
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
SELECT CONVERT(VARCHAR(20), 'me')
CREATE TABLE #tmp_insert (col TEXT)
SELECT * FROM #tmp_insert WHERE CONVERT(VARCHAR(255), col) = CONVERT(VARCHAR(255), '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
use_cursors 0 exec_direct 0 prepare_before 1
CREATE TABLE #tmp_insert (col VARCHAR(100) NULL)
SELECT * FROM #tmp_insert WHERE col IS NULL
DROP TABLE #tmp_insert
CREATE TABLE #tmp_insert (col TEXT NULL)
SELECT * FROM #tmp_insert WHERE DATALENGTH(col) = 0 OR DATALENGTH(col) IS NULL
DROP TABLE #tmp_insert
CREATE TABLE #tmp_insert (col INTEGER NULL)
SELECT * FROM #tmp_insert WHERE col IS NULL
DROP TABLE #tmp_insert
CREATE TABLE #tmp_insert (col TEXT NULL)
SELECT * FROM #tmp_insert WHERE DATALENGTH(col) = 0 OR DATALENGTH(col) IS NULL
DROP TABLE #tmp_insert
CREATE TABLE #tmp_insert (col DATETIME NULL)
SELECT * FROM #tmp_insert WHERE col IS NULL
DROP TABLE #tmp_insert
CREATE TABLE #tmp_insert (col FLOAT NULL)
SELECT * FROM #tmp_insert WHERE col IS NULL
DROP TABLE #tmp_insert
CREATE TABLE #tmp_insert (col TEXT NULL)
SELECT * FROM #tmp_insert WHERE DATALENGTH(col) = 0 OR DATALENGTH(col) IS NULL
DROP TABLE #tmp_insert
CREATE TABLE #tmp_insert (col MONEY NULL)
SELECT * FROM #tmp_insert WHERE col IS NULL
DROP TABLE #tmp_insert
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
SELECT CONVERT(INTEGER, '12345')
CREATE TABLE #tmp_insert (col TEXT)
SELECT * FROM #tmp_insert WHERE CONVERT(VARCHAR(255), col) = CONVERT(VARCHAR(255), '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 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, '2016-05-31 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(NUMERIC(20,3), '578246.234')
CREATE TABLE #tmp_insert (col VARCHAR(20))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARCHAR(20), '578246')
DROP TABLE #tmp_insert
SELECT CONVERT(NUMERIC(20,3), '578246.234')
CREATE TABLE #tmp_insert (col TEXT)
SELECT * FROM #tmp_insert WHERE CONVERT(VARCHAR(255), col) = CONVERT(VARCHAR(255), '578246')
DROP TABLE #tmp_insert
SELECT CONVERT(VARCHAR(100), '4145544F')
CREATE TABLE #tmp_insert (col VARBINARY(20))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARBINARY(20), 'AETO')
DROP TABLE #tmp_insert
SELECT CONVERT(TEXT, '4145544F')
CREATE TABLE #tmp_insert (col VARBINARY(20))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARBINARY(20), 'AETO')
DROP TABLE #tmp_insert
SELECT CONVERT(VARCHAR(100), '4145544F')
CREATE TABLE #tmp_insert (col IMAGE)
SELECT * FROM #tmp_insert WHERE CONVERT(VARBINARY(255), col) = CONVERT(VARBINARY(255), 'AETO')
DROP TABLE #tmp_insert
SELECT CONVERT(VARBINARY(100), 0x4145544F)
CREATE TABLE #tmp_insert (col VARCHAR(20))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARCHAR(20), 'AETO')
DROP TABLE #tmp_insert
SELECT CONVERT(IMAGE, 0x4145544F)
CREATE TABLE #tmp_insert (col VARCHAR(20))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARCHAR(20), 'AETO')
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), '1EasyTest')
CREATE TABLE #tmp_insert (col TEXT)
SELECT * FROM #tmp_insert WHERE CONVERT(VARCHAR(255), col) = CONVERT(VARCHAR(255), '1EasyTest')
DROP TABLE #tmp_insert
SELECT CONVERT(VARCHAR(10), 'Test 12345')
CREATE TABLE #tmp_insert (col VARCHAR(10))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARCHAR(10), 'Test 12345')
DROP TABLE #tmp_insert
SELECT CONVERT(VARCHAR(10), 'Test 12345')
CREATE TABLE #tmp_insert (col TEXT)
SELECT * FROM #tmp_insert WHERE CONVERT(VARCHAR(255), col) = CONVERT(VARCHAR(255), 'Test 12345')
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
SELECT CONVERT(VARCHAR(20), 'me')
CREATE TABLE #tmp_insert (col TEXT)
SELECT * FROM #tmp_insert WHERE CONVERT(VARCHAR(255), col) = CONVERT(VARCHAR(255), '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
use_cursors 0 exec_direct 0 prepare_before 0
CREATE TABLE #tmp_insert (col VARCHAR(100) NULL)
SELECT * FROM #tmp_insert WHERE col IS NULL
DROP TABLE #tmp_insert
CREATE TABLE #tmp_insert (col TEXT NULL)
SELECT * FROM #tmp_insert WHERE DATALENGTH(col) = 0 OR DATALENGTH(col) IS NULL
DROP TABLE #tmp_insert
CREATE TABLE #tmp_insert (col INTEGER NULL)
SELECT * FROM #tmp_insert WHERE col IS NULL
DROP TABLE #tmp_insert
CREATE TABLE #tmp_insert (col TEXT NULL)
SELECT * FROM #tmp_insert WHERE DATALENGTH(col) = 0 OR DATALENGTH(col) IS NULL
DROP TABLE #tmp_insert
CREATE TABLE #tmp_insert (col DATETIME NULL)
SELECT * FROM #tmp_insert WHERE col IS NULL
DROP TABLE #tmp_insert
CREATE TABLE #tmp_insert (col FLOAT NULL)
SELECT * FROM #tmp_insert WHERE col IS NULL
DROP TABLE #tmp_insert
CREATE TABLE #tmp_insert (col TEXT NULL)
SELECT * FROM #tmp_insert WHERE DATALENGTH(col) = 0 OR DATALENGTH(col) IS NULL
DROP TABLE #tmp_insert
CREATE TABLE #tmp_insert (col MONEY NULL)
SELECT * FROM #tmp_insert WHERE col IS NULL
DROP TABLE #tmp_insert
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
SELECT CONVERT(INTEGER, '12345')
CREATE TABLE #tmp_insert (col TEXT)
SELECT * FROM #tmp_insert WHERE CONVERT(VARCHAR(255), col) = CONVERT(VARCHAR(255), '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 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, '2016-05-31 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(NUMERIC(20,3), '578246.234')
CREATE TABLE #tmp_insert (col VARCHAR(20))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARCHAR(20), '578246')
DROP TABLE #tmp_insert
SELECT CONVERT(NUMERIC(20,3), '578246.234')
CREATE TABLE #tmp_insert (col TEXT)
SELECT * FROM #tmp_insert WHERE CONVERT(VARCHAR(255), col) = CONVERT(VARCHAR(255), '578246')
DROP TABLE #tmp_insert
SELECT CONVERT(VARCHAR(100), '4145544F')
CREATE TABLE #tmp_insert (col VARBINARY(20))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARBINARY(20), 'AETO')
DROP TABLE #tmp_insert
SELECT CONVERT(TEXT, '4145544F')
CREATE TABLE #tmp_insert (col VARBINARY(20))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARBINARY(20), 'AETO')
DROP TABLE #tmp_insert
SELECT CONVERT(VARCHAR(100), '4145544F')
CREATE TABLE #tmp_insert (col IMAGE)
SELECT * FROM #tmp_insert WHERE CONVERT(VARBINARY(255), col) = CONVERT(VARBINARY(255), 'AETO')
DROP TABLE #tmp_insert
SELECT CONVERT(VARBINARY(100), 0x4145544F)
CREATE TABLE #tmp_insert (col VARCHAR(20))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARCHAR(20), 'AETO')
DROP TABLE #tmp_insert
SELECT CONVERT(IMAGE, 0x4145544F)
CREATE TABLE #tmp_insert (col VARCHAR(20))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARCHAR(20), 'AETO')
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), '1EasyTest')
CREATE TABLE #tmp_insert (col TEXT)
SELECT * FROM #tmp_insert WHERE CONVERT(VARCHAR(255), col) = CONVERT(VARCHAR(255), '1EasyTest')
DROP TABLE #tmp_insert
SELECT CONVERT(VARCHAR(10), 'Test 12345')
CREATE TABLE #tmp_insert (col VARCHAR(10))
SELECT * FROM #tmp_insert WHERE col = CONVERT(VARCHAR(10), 'Test 12345')
DROP TABLE #tmp_insert
SELECT CONVERT(VARCHAR(10), 'Test 12345')
CREATE TABLE #tmp_insert (col TEXT)
SELECT * FROM #tmp_insert WHERE CONVERT(VARCHAR(255), col) = CONVERT(VARCHAR(255), 'Test 12345')
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
SELECT CONVERT(VARCHAR(20), 'me')
CREATE TABLE #tmp_insert (col TEXT)
SELECT * FROM #tmp_insert WHERE CONVERT(VARCHAR(255), col) = CONVERT(VARCHAR(255), '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
Your connection seems to not support cursors, probably you are using wrong protocol version or Sybase
--21081-- Discarding syms at 0x7d7d700-0x7d7edd9 in /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so due to munmap()
--21081-- Discarding syms at 0x7b7a600-0x7b7b08d in /usr/lib/x86_64-linux-gnu/gconv/ISO8859-1.so due to munmap()
--21081-- Discarding syms at 0x733b2d0-0x7340bf1 in /lib/x86_64-linux-gnu/libnss_compat-2.23.so due to munmap()
--21081-- Discarding syms at 0x775e0b0-0x77648ce in /lib/x86_64-linux-gnu/libnss_nis-2.23.so due to munmap()
--21081-- Discarding syms at 0x7546ff0-0x75541e1 in /lib/x86_64-linux-gnu/libnsl-2.23.so due to munmap()
--21081-- Discarding syms at 0x796a1b0-0x79702a1 in /lib/x86_64-linux-gnu/libnss_files-2.23.so due to munmap()
==21081== 
==21081== HEAP SUMMARY:
==21081==     in use at exit: 1,824 bytes in 27 blocks
==21081==   total heap usage: 13,533 allocs, 13,506 frees, 6,642,458 bytes allocated
==21081== 
==21081== Searching for pointers to 27 not-freed blocks
==21081== Checked 471,864 bytes
==21081== 
==21081== LEAK SUMMARY:
==21081==    definitely lost: 0 bytes in 0 blocks
==21081==    indirectly lost: 0 bytes in 0 blocks
==21081==      possibly lost: 0 bytes in 0 blocks
==21081==    still reachable: 0 bytes in 0 blocks
==21081==         suppressed: 1,824 bytes in 27 blocks
==21081== 
==21081== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 0 from 0)
--21081-- 
--21081-- used_suppression:     26 openssl leak 4 /home/freddy/suppressions.supp:27 suppressed: 1,792 bytes in 26 blocks
--21081-- used_suppression:      1 openssl leak 5 /home/freddy/suppressions.supp:38 suppressed: 32 bytes in 1 blocks
==21081== 
==21081== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 0 from 0)

Main