[New-bugs-announce] [issue18892] sqlite3, valued records not persisted, default ones are

Heijink report at bugs.python.org
Sat Aug 31 09:10:38 CEST 2013

New submission from Heijink:

In the end I tracked down the behaviour with the attached program
behaviour with an initially empty table:

7 : insert two records with values in the columns
two records show up, # 1,2
as expected
9 : show al records
whereas two are to be expected
8 : add records with default values
two records show up # 1,2
as expected in an empty table
two records # 3,4
record numbers as expected, but where are records 1,2?  (ABC)
the default records are present #1,2
the previous valued records 3,4 not
  unexpected, but identical to first behaviour issuing 7
4 records show up # 1-4
record numbers as expected when valued records are not present
0  :  I quit

to summarize:
It is not possible to store records in the database with valued columns.
Records with default values can be stored and retrieved, they are the ones that are persistent
Additional strange behaviour is that after adding valued records (3,4) also the already present records with default values (1,2) should have shown show up, remark (ABC).

components: Demos and Tools
files: dump.py
messages: 196617
nosy: debewerker
priority: normal
severity: normal
status: open
title: sqlite3, valued records not persisted, default ones are
type: behavior
versions: Python 3.2
Added file: http://bugs.python.org/file31531/dump.py

Python tracker <report at bugs.python.org>

More information about the New-bugs-announce mailing list