Bug 17191 – HTML5: Client-side database queries should return values of type number

• Component: Platform
• Status: RESOLVED FIXED

[Kimmo Kinnunen]

HTML5 Client-side database storage spec doesn't seem to say what type of return values queries should return. However, it'd make sense in some cases to get numbers as results of queries. Currently DB queries return only string values.

SQLite doesn't enforce the column types, but at least it'd be useful to get the same type out as was put in.

[Kimmo Kinnunen]

Created attachment 18958 [details]
Makes inserted numbers come back as numbers (not as strings)

[Timothy Hatcher]

Comment on attachment 18958 [details]
Makes inserted numbers come back as numbers (not as strings)

This looks good.

No need for the braces around the for loop now. Remove them to match our style.

             for (int i = 0; i < columnCount; i++) {
-                // FIXME: Look at the column type?
-                rows->addResult(statement.getColumnText(i));
+                rows->addResult(statement.getColumnValue(i));
             }

[Oliver Hunt]

Will land this shortly, just incorporating tim's comment and building, etc.

[Oliver Hunt]

Landed r30087