W3C home > Mailing lists > Public > public-webapps@w3.org > July to September 2009

[web databases] about rowids

From: João Eiras <joaoe@opera.com>
Date: Wed, 02 Sep 2009 14:00:57 +0200
To: "public-webapps@w3.org" <public-webapps@w3.org>
Message-ID: <op.uzmozv162q99of@id-c0981>

Hi everyone.

1)
Currently, SqlResultSet.insertId is defined as a integer. This would prevent user agents to use an underlying database engine that does not rely on integers for rowids.
For instance, both SQLite, MS Access, Informix use integers it seems, DB2 uses a transparent type 17 bytes big, Oracle uses strings, Java JDBC uses byte[].

For the sake of compatibility, it would probably be better to make insertId either a string, or in the case of lack of agreement, a implementation defined type, which is not desirable.

2)
insertId only stores one row id. That's not very helpful for the case of a "INSERT INTO table(...) SELECT ..." dml. Considering that the query could produce an arbitrary number of rowids, the insertId field should probably be a SqlResultSetRowList, or an array.

-- 

João Eiras
Core Developer, Opera Software ASA, http://www.opera.com/
Received on Wednesday, 2 September 2009 12:01:40 GMT

This archive was generated by hypermail 2.3.1 : Tuesday, 26 March 2013 18:49:33 GMT