[sqlite] Does SELECT cover uncommitted INSERTS?

[Rafael Buchbinder]

Hi, list!

I think my question is totally a newbie one, but still:

Does a SELECT query return rows from uncommitted inserts on same sqlite3 handle 
(and same thread) ?

I assume it does not do that when BEGIN; INSERT ...; END; is done on a distinct 
sqlite3 handle (and different thread).

Thanks.

rafi