Frantisek Hanzlik
2014-07-02 16:33:03 UTC
I'm absolute newbie in SQL, thus please forgive me if I do something
stupid.
I tried run this script (which is working fine with
\Program Files\Microsoft SQL Server\90\Tools\Binn\osql.exe
from MS SQL server 2005 on Windows 2003 server) :
--- script begin
declare
@CityOd varchar(10),
@CityDo varchar(10),
@datumStavu datetime
set @CityOd = 'ADAMOV'
set @CityDo = 'WIEN'
set @datumStavu = '2014-07-02'
create table #tmp(no_ varchar(20), up decimal(38,20),
s12 decimal(38,20), s14 decimal(38,20), s5416 decimal(38,20))
declare c cursor for
select No_, [Unit Price] from [MyDB$Item] k
where [Item Category Code] = 'E-SHOP'
declare @no varchar(20),
@up decimal(38,20),
@s12 decimal(38,20),
@s14 decimal(38,20),
@s5416 decimal(38,20)
open c
fetch c into @no, @up
while @@fetch_status=0
begin
SELECT @s12 = isnull(SUM([s12]),0), at s14=isnull(SUM([s14]),0) FROM
[MyDB$TBL1]
WITH (READUNCOMMITTED) WHERE (bucket=5 AND f2=@no AND
((f8>=@CityOd AND f8<=@CityDo)))
AND f3 < @datumStavu
SELECT @s5416=isnull(SUM([s5416]),0) FROM [MyDB$TBL2] WITH
(READUNCOMMITTED)
WHERE (bucket=6 AND f1=1 AND f5=2 AND f6=@no AND ((f7>=@CityOd AND
f7<=@CityDo)))
and f10 < @datumStavu
insert into #tmp values(@no, @up, @s12, @s14, @s5416)
fetch c into @no, @up
end
close c
deallocate c
select * from #tmp
drop table #tmp
go
--- script end
on bsqldb and fisql from freetds-0.91-6.gitf3ae29d.fc19.x86_64 on
Fedora 19 x86_64.
When I run bsqldb with params:
-i SQL -U user -P pwd -S sqlsrv -D test -t " " -e SQLerr -o SQLout -h -v
*** Error in `/bin/bsqldb': free(): invalid pointer: 0x000000000064ae00 ***
======= Backtrace: =========
/lib64/libc.so.6[0x3b2607d0b8]
/lib64/libsybdb.so.5(dbnextrow+0x369)[0x3ec820e1b9]
/bin/bsqldb[0x40308b]
/bin/bsqldb[0x4022a2]
/lib64/libc.so.6(__libc_start_main+0xf5)[0x3b26021b45]
/bin/bsqldb[0x402431]
======= Memory map: ========
00400000-00406000 r-xp 00000000 09:01 1736030 /usr/bin/bsqldb
00605000-00606000 r--p 00005000 09:01 1736030 /usr/bin/bsqldb
00606000-0060a000 rw-p 00006000 09:01 1736030 /usr/bin/bsqldb
0060a000-0064f000 rw-p 00000000 00:00 0 [heap]
3974200000-3974279000 r-xp 00000000 09:01 1707453 /usr/lib64/libfreebl3.so
3974279000-3974478000 ---p 00079000 09:01 1707453 /usr/lib64/libfreebl3.so
...
7ffff1ab2000-7ffff7fd7000 r--p 00000000 09:01 1734848 /usr/lib/locale/locale-archive
7ffff7fd7000-7ffff7fe3000 rw-p 00000000 00:00 0
7ffff7ff1000-7ffff7ff4000 rw-p 00000000 00:00 0
7ffff7ff4000-7ffff7ffb000 r--s 00000000 09:01 1734941 /usr/lib64/gconv/gconv-modules.cache
7ffff7ffb000-7ffff7ffd000 rw-p 00000000 00:00 0
7ffff7ffd000-7ffff7fff000 r-xp 00000000 00:00 0 [vdso]
7ffffffde000-7ffffffff000 rw-p 00000000 00:00 0 [stack]
ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall]
Program received signal SIGABRT, Aborted.
0x0000003b260359e9 in __GI_raise (sig=sig at entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
56 return INLINE_SYSCALL (tgkill, 3, pid, selftid, sig);
And stack backtrace is:
#0 0x0000003b260359e9 in __GI_raise (sig=sig at entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#1 0x0000003b260370f8 in __GI_abort () at abort.c:90
#2 0x0000003b26075d17 in __libc_message (do_abort=do_abort at entry=2, fmt=fmt at entry=0x3b2617e568 "*** Error in `%s': %s: 0x%s ***\n") at ../sysdeps/unix/sysv/linux/libc_fatal.c:196
#3 0x0000003b2607d0b8 in malloc_printerr (ptr=<optimized out>, str=0x3b2617bc75 "free(): invalid pointer", action=3) at malloc.c:4937
#4 _int_free (av=0x3b263ba780 <main_arena>, p=<optimized out>, have_lock=0) at malloc.c:3789
#5 0x0000003ec820e1b9 in buffer_add_row (resinfo=0x614440, dbproc=0x6133c0) at buffering.h:500
#6 dbnextrow (dbproc=dbproc at entry=0x6133c0) at dblib.c:2071
#7 0x000000000040308b in print_results (dbproc=dbproc at entry=0x6133c0) at bsqldb.c:535
#8 0x00000000004022a2 in main (argc=<optimized out>, argv=0x7fffffffe508) at bsqldb.c:210
When I tried run this SQL script with 'fisql' with params:
-i SQL -U user -P pwd -S sqlsrv -D test -e SQLerr -o SQLout -w 65500 -n
then program run seemingly without error, but SQLout output is weird:
no_ up s12 s14 s5416
-------------------------------------------------------------------------------- -- --- --- -----
DB-LIBRARY error:
Data conversion resulted in overflow
Operating-system error:
Success
K2030446 -- --- --- -----
DB-LIBRARY error:
Data conversion resulted in overflow
Operating-system error:
Success
K2030457 -- --- --- -----
DB-LIBRARY error:
Data conversion resulted in overflow
Operating-system error:
Success
K2030469 -- --- --- -----
DB-LIBRARY error:
Data conversion resulted in overflow
Operating-system error:
Success
K2030471 -- --- --- -----
...
Can anyone advise me what I'm doing wrong?
Thanks in advance, Franta Hanzlik
stupid.
I tried run this script (which is working fine with
\Program Files\Microsoft SQL Server\90\Tools\Binn\osql.exe
from MS SQL server 2005 on Windows 2003 server) :
--- script begin
declare
@CityOd varchar(10),
@CityDo varchar(10),
@datumStavu datetime
set @CityOd = 'ADAMOV'
set @CityDo = 'WIEN'
set @datumStavu = '2014-07-02'
create table #tmp(no_ varchar(20), up decimal(38,20),
s12 decimal(38,20), s14 decimal(38,20), s5416 decimal(38,20))
declare c cursor for
select No_, [Unit Price] from [MyDB$Item] k
where [Item Category Code] = 'E-SHOP'
declare @no varchar(20),
@up decimal(38,20),
@s12 decimal(38,20),
@s14 decimal(38,20),
@s5416 decimal(38,20)
open c
fetch c into @no, @up
while @@fetch_status=0
begin
SELECT @s12 = isnull(SUM([s12]),0), at s14=isnull(SUM([s14]),0) FROM
[MyDB$TBL1]
WITH (READUNCOMMITTED) WHERE (bucket=5 AND f2=@no AND
((f8>=@CityOd AND f8<=@CityDo)))
AND f3 < @datumStavu
SELECT @s5416=isnull(SUM([s5416]),0) FROM [MyDB$TBL2] WITH
(READUNCOMMITTED)
WHERE (bucket=6 AND f1=1 AND f5=2 AND f6=@no AND ((f7>=@CityOd AND
f7<=@CityDo)))
and f10 < @datumStavu
insert into #tmp values(@no, @up, @s12, @s14, @s5416)
fetch c into @no, @up
end
close c
deallocate c
select * from #tmp
drop table #tmp
go
--- script end
on bsqldb and fisql from freetds-0.91-6.gitf3ae29d.fc19.x86_64 on
Fedora 19 x86_64.
When I run bsqldb with params:
-i SQL -U user -P pwd -S sqlsrv -D test -t " " -e SQLerr -o SQLout -h -v
*** Error in `/bin/bsqldb': free(): invalid pointer: 0x000000000064ae00 ***
======= Backtrace: =========
/lib64/libc.so.6[0x3b2607d0b8]
/lib64/libsybdb.so.5(dbnextrow+0x369)[0x3ec820e1b9]
/bin/bsqldb[0x40308b]
/bin/bsqldb[0x4022a2]
/lib64/libc.so.6(__libc_start_main+0xf5)[0x3b26021b45]
/bin/bsqldb[0x402431]
======= Memory map: ========
00400000-00406000 r-xp 00000000 09:01 1736030 /usr/bin/bsqldb
00605000-00606000 r--p 00005000 09:01 1736030 /usr/bin/bsqldb
00606000-0060a000 rw-p 00006000 09:01 1736030 /usr/bin/bsqldb
0060a000-0064f000 rw-p 00000000 00:00 0 [heap]
3974200000-3974279000 r-xp 00000000 09:01 1707453 /usr/lib64/libfreebl3.so
3974279000-3974478000 ---p 00079000 09:01 1707453 /usr/lib64/libfreebl3.so
...
7ffff1ab2000-7ffff7fd7000 r--p 00000000 09:01 1734848 /usr/lib/locale/locale-archive
7ffff7fd7000-7ffff7fe3000 rw-p 00000000 00:00 0
7ffff7ff1000-7ffff7ff4000 rw-p 00000000 00:00 0
7ffff7ff4000-7ffff7ffb000 r--s 00000000 09:01 1734941 /usr/lib64/gconv/gconv-modules.cache
7ffff7ffb000-7ffff7ffd000 rw-p 00000000 00:00 0
7ffff7ffd000-7ffff7fff000 r-xp 00000000 00:00 0 [vdso]
7ffffffde000-7ffffffff000 rw-p 00000000 00:00 0 [stack]
ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall]
Program received signal SIGABRT, Aborted.
0x0000003b260359e9 in __GI_raise (sig=sig at entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
56 return INLINE_SYSCALL (tgkill, 3, pid, selftid, sig);
And stack backtrace is:
#0 0x0000003b260359e9 in __GI_raise (sig=sig at entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#1 0x0000003b260370f8 in __GI_abort () at abort.c:90
#2 0x0000003b26075d17 in __libc_message (do_abort=do_abort at entry=2, fmt=fmt at entry=0x3b2617e568 "*** Error in `%s': %s: 0x%s ***\n") at ../sysdeps/unix/sysv/linux/libc_fatal.c:196
#3 0x0000003b2607d0b8 in malloc_printerr (ptr=<optimized out>, str=0x3b2617bc75 "free(): invalid pointer", action=3) at malloc.c:4937
#4 _int_free (av=0x3b263ba780 <main_arena>, p=<optimized out>, have_lock=0) at malloc.c:3789
#5 0x0000003ec820e1b9 in buffer_add_row (resinfo=0x614440, dbproc=0x6133c0) at buffering.h:500
#6 dbnextrow (dbproc=dbproc at entry=0x6133c0) at dblib.c:2071
#7 0x000000000040308b in print_results (dbproc=dbproc at entry=0x6133c0) at bsqldb.c:535
#8 0x00000000004022a2 in main (argc=<optimized out>, argv=0x7fffffffe508) at bsqldb.c:210
When I tried run this SQL script with 'fisql' with params:
-i SQL -U user -P pwd -S sqlsrv -D test -e SQLerr -o SQLout -w 65500 -n
then program run seemingly without error, but SQLout output is weird:
no_ up s12 s14 s5416
-------------------------------------------------------------------------------- -- --- --- -----
DB-LIBRARY error:
Data conversion resulted in overflow
Operating-system error:
Success
K2030446 -- --- --- -----
DB-LIBRARY error:
Data conversion resulted in overflow
Operating-system error:
Success
K2030457 -- --- --- -----
DB-LIBRARY error:
Data conversion resulted in overflow
Operating-system error:
Success
K2030469 -- --- --- -----
DB-LIBRARY error:
Data conversion resulted in overflow
Operating-system error:
Success
K2030471 -- --- --- -----
...
Can anyone advise me what I'm doing wrong?
Thanks in advance, Franta Hanzlik