[ python-Bugs-1573854 ] sqlite3 documentation on rowcount is contradictory

[SourceForge.net]

Bugs item #1573854, was opened at 2006-10-09 18:18
Message generated for change (Comment added) made by ghaering
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=105470&aid=1573854&group_id=5470

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Documentation
>Group: Python 2.5
Status: Open
Resolution: None
>Priority: 3
Submitted By: Seo Sanghyeon (sanxiyn)
>Assigned to: Gerhard Häring (ghaering)
Summary: sqlite3 documentation on rowcount is contradictory

Initial Comment:
http://docs.python.org/lib/sqlite3-Cursor-Objects.html
says:

----
For SELECT statements, rowcount is always None because
we cannot determine the number of rows a query produced
until all rows were fetched.

As required by the Python DB API Spec, the rowcount
attribute "is -1 in case no executeXX() has been
performed on the cursor or the rowcount of the last
operation is not determinable by the interface".
----

Clearly, both can't be true. My experiment showed that
rowcount is set to -1, not None. I suggest rewriting
this to something like:

----
As required by the Python DB API Spec, the rowcount
attribute "is -1 in case no executeXX() has been
performed on the cursor or the rowcount of the last
operation is not determinable by the interface".

This includes SELECT statements, because we cannot
determine the number of rows a query produced until all
rows are fetched.
----

----------------------------------------------------------------------

>Comment By: Gerhard Häring (ghaering)
Date: 2006-10-10 12:04

Message:
Logged In: YES 
user_id=163326

Thanks for the bug report. I will perform the suggested 
change.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=105470&aid=1573854&group_id=5470