FreeTDS Development Group

["Pothen, Abi" <APothen AT nb.com>]

Hi,
  I am the same person who posted this problem before.
  I would like to provide few more information related to the following
problem.
  Problem is existing with freetds.conf option being, "tds version = 7.0".
  With "tds version = 4.2", result set is fine.
  
Thanks,
Abi.
> Hi,
>   I am getting inconsistent results for the following sql statements. I
> would really appreciate if someone could help me to resolve this problem.
> 
>   I am using FreeTDS ( .53) and DBD Sybase ( 94 ) to connect to MS SQL 7
> and 2000 from a Sun Solaris box.
> 
>   Please see Case 1 and Case 2.
>   Case 2 is producing inconsistent results.
> 
> Thanks in advance.
> 
> 
> 
> 
> 
> 
> CREATE TABLE test 
> (
>     row_id         int    NOT NULL,
>     amt     decimal(18,4) NULL    
> )
> go
> 
> Case : 1
>    delete from test
>    insert into test ( row_id, amt) values (9631, 398880.0000)
>    insert into test ( row_id, amt) values (9632, 955.0000)
>    insert into test ( row_id, amt) values (9633, 1590.0000)
>    insert into test ( row_id, amt) values (9634, 851.0000)
> 
> Output of "select * from test" for the above data in the test table 
> =============================================
>   9631    398880.0000
>   9632    955.0000
>   9633    1590.0000
>   9634    851.0000
> 
> Case : 2
>    delete from test
>    insert into test ( row_id, amt) values   (9630, 498880.0000)
>    insert into test ( row_id, amt) values (9632, 955.0000)
>    insert into test ( row_id, amt) values (9633, 1590.0000)
>    insert into test ( row_id, amt) values (9634, 851.0000)
> 
> Output of "select * from test" for the above data in the test table (
> Incorrect )
> =====================================================
>   9630    498880.0000
>   9632    430451.7296
>   9633    431086.7296
>   9634    430347.7296
> 
> 
> 
> 
> 
> test.pl
> =====
>   $ENV{'SYBASE'} = '/usr/local/freetds' ;
>   use DBI;
> 
>   $dbh = DBI->connect('dbi:Sybase:server='SQLSERVER' , 'user', 'password')
>       or die 'connect';
>   $dbh->do("use mydata");
> 
>   $sth = $dbh->prepare('select * from test') or die 'prepare';
>   $sth->execute or die 'execute';
>   while (@data = $sth->fetchrow_array) {
>       print join("\t",@data) , "\n"; 
>   }
>   $sth->finish;
>   $dbh->disconnect;