dynamobi/dynamobi — Issue #214: [LDB-107] inserting SQLFLT8 from flatfile into a decimal sometimes produce different values
Author: dynamobi-build
Created: 2011-12-30 02:22:24+00:00
State: open
Labels: Flatfile, LDB

[reporter="kvu", created="Tue, 13 Jun 2006 12:35:09 -0500 (GMT-05:00)"]
Under directory luciddb/test/sql/company/

Run

ant clean

ant test -Dtestfile=test-idx.xml -Dbh.test-names=company-idx-test.joinEq

with following SALES.bcp:

6.0

4

1	SQLINT	0	2	","	1	CUSTID

2	SQLINT	0	3	","	2	EMPID

3	SQLINT	0	5	","	3	PRODID

4	SQLFLT8	0	4	"\n"	4	PRICE

there are some differences in the values of column price between the flat file and the sql table

If, on sqllineEngine, the following script is run:

create table adecimal (n numeric (3,2));

insert into adecimal select price from ff_server.bcp.sales where prodid=10002 and price=9.79;

0: jdbc:luciddb:> select * from adecimal;

+-------+

| N |

+-------+

| 9.78 |

+-------+