Bug 60490 - mono.data.sqlite works incorrect
Summary: mono.data.sqlite works incorrect
Alias: None
Product: Android
Classification: Xamarin
Component: General ()
Version: unspecified
Hardware: Other Other
: --- normal
Target Milestone: ---
Assignee: Atsushi Eno
Depends on:
Reported: 2017-11-02 08:32 UTC by Roman
Modified: 2017-11-14 00:48 UTC (History)
2 users (show)

Is this bug a regression?: ---
Last known good build:

Notice (2018-05-24): bugzilla.xamarin.com is now in read-only mode.

Please join us on Visual Studio Developer Community and in the Xamarin and Mono organizations on GitHub to continue tracking issues. Bugzilla will remain available for reference in read-only mode. We will continue to work on open Bugzilla bugs, copy them to the new locations as needed for follow-up, and add the new items under Related Links.

Our sincere thanks to everyone who has contributed on this bug tracker over the years. Thanks also for your understanding as we make these adjustments and improvements for the future.

Please create a new report for Bug 60490 on Developer Community or GitHub if you have new information to add and do not yet see a matching new report.

If the latest results still closely match this report, you can use the original description:

  • Export the original title and description: Developer Community HTML or GitHub Markdown
  • Copy the title and description into the new report. Adjust them to be up-to-date if needed.
  • Add your new information.

In special cases on GitHub you might also want the comments: GitHub Markdown with public comments

Related Links:

Description Roman 2017-11-02 08:32:38 UTC
I have data base table which contains some quantity fields and one field is decimal type (10,2).
I've written several records to table. And when I selected records from table I looked unreal paradox.
I use DataTable class for select query. 
So if select query returns one record that all works good no issues.
But when select query returns several count of records that decimal value (boxed in object) in DataTable.Rows was rounded to integer type.
For example if decimal value in database is 1.5 that after select I get value 2.
I've resolved problem by adding to sql query operator round(...) but I think that sqlite api must not round to integer a decimal value by default. Why does equal select query returns different results for one record and many records.
If you need my database and code I will can give it after 10 hours.
Comment 1 Jon Douglas [MSFT] 2017-11-14 00:48:17 UTC
Hi Roman,

We're missing a few details on this report. If you can, please look through the following guidelines for reporting a bug:


We will need:

1. Steps to reproduce and a reproduction project
2. Actual Results
3. Expected Results

Thank you in advance and thanks for reporting a bug!