REAL number with double-precision truncated/rounded (iOS version)

[brodycj]

As reported in the forum: https://groups.google.com/d/msg/cordova-sqliteplugin/01Zzh2m-iiQ/dpxj7vF6ZVIJ

Reproduced by the following test:

        test(suiteName + "Double precision decimal number insertion", function() {
          stop();
          var db = openDatabase("Double-precision-number-insertion.db", "1.0", "Demo", DEFAULT_SIZE);
          db.transaction(function(tx) {
            tx.executeSql('DROP TABLE IF EXISTS tt');
            tx.executeSql('CREATE TABLE IF NOT EXISTS tt (tr REAL)');
          }, function(err) { ok(false, err.message) }, function() {
            db.transaction(function(tx) {
              tx.executeSql("insert into tt (tr) VALUES (?)", [123456.789], function(tx, res) {
                equal(res.rowsAffected, 1, "row inserted");
                tx.executeSql("select * from tt", [], function(tx, res) {
                  start();
                  var row = res.rows.item(0);
                  strictEqual(row.tr, 123456.789, "Decimal number inserted properly");
                });
              });
            });
          });
        });

The double-precision decimal number is working OK in the Android & WP(8) versions.

[brodycj]

The following change fixes the issue (and passes the other tests):

--- a/src/ios/SQLitePlugin.m
+++ b/src/ios/SQLitePlugin.m
@@ -410,7 +410,7 @@ static void sqlite_regexp(sqlite3_context* context, int argc, sqlite3_value** va
 #endif
                             break;
                         case SQLITE_FLOAT:
-                            columnValue = [NSNumber numberWithFloat: sqlite3_column_double(statement, i)];
+                            columnValue = [NSNumber numberWithDouble: sqlite3_column_double(statement, i)];
                             break;
                         case SQLITE_NULL:
                             columnValue = [NSNull null];

[brodycj]

The fix has been tested and published.