Details
-
Bug
-
Resolution: Done
-
P3: Somewhat important
-
4.7.3
-
None
-
8b3b227173ab6b112bb2f5c61a4afdd79dbcc1d3
Description
Each property of row (from transaction.executeSql() result) holds a string value, even if the database return different type (integer, null, etc.)
A quote from Web Database W3C Working Draft:
Each row must be represented by a native ordered dictionary data type. In the JavaScript binding, this must be Object. Each row object must have one property (or dictionary entry) per column, with those properties enumerating in the order that these columns were returned by the database. Each property must have the name of the column and the value of the cell, as they were returned by the database.
Please take a look at the attached example source file. I would rather expect to get Number ad null value instead of two string values.
As an example Google Chrome - which implements the same draft (but only asynchronous API) - implements it the right way.