unit tests using sqlite do not check foreign keys
Bug #1021023 reported by
dan wendlandt
This bug affects 2 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
neutron |
Fix Released
|
Medium
|
Jason |
Bug Description
for sqllite the foreign keys are not enabled by default.
this means that our db unit tests are not really testing what someone would see in real use.
more info here: http://
Changed in quantum: | |
importance: | Undecided → High |
Changed in quantum: | |
milestone: | folsom-3 → none |
Changed in quantum: | |
importance: | High → Medium |
Changed in quantum: | |
status: | Confirmed → In Progress |
Changed in quantum: | |
assignee: | David Ripton (dripton) → Jason Zhang (bearovercloud) |
Changed in quantum: | |
milestone: | none → grizzly-2 |
status: | Fix Committed → Fix Released |
Changed in quantum: | |
milestone: | grizzly-2 → 2013.1 |
To post a comment you must log in.
Dan,
This is a half true bug, it only affects systems running with python2.4/2.5 and have python sqlite module built with sqlite version >= 3.6.19.
http:// www.hwaci. com/sw/ sqlite/ foreignkeys. html
Python on debian, ubuntu and systems using python2.6 have sqlite3 with foreign keys.
squeeze ncode@atomsk:~$ ldd /usr/lib/ python2. 6/lib-dynload/ _sqlite3. so 4000) libsqlite3. so.0 (0x00007fd33fc3 3000) .so.0 (0x00007fd33fa1 7000) 4000) 0000) ld-linux- x86-64. so.2 (0x00007fd3400e 3000)
linux-vdso.so.1 => (0x00007fff6f7f
libsqlite3.so.0 => /usr/lib/
libpthread.so.0 => /lib/libpthread
libc.so.6 => /lib/libc.so.6 (0x00007fd33f6b
libdl.so.2 => /lib/libdl.so.2 (0x00007fd33f4b
/lib64/
squeeze ncode@atomsk:~$ dpkg -S /usr/lib/ libsqlite3. so.0 libsqlite3. so.0
libsqlite3-0: /usr/lib/
squeeze ncode@atomsk:~$ dpkg -l libsqlite3-0 Unknown/ Install/ Remove/ Purge/Hold Not/Inst/ Conf-files/ Unpacked/ halF-conf/ Half-inst/ trig-aWait/ Trig-pend /Reinst- required (Status,Err: uppercase=bad) ======= ======= ======= =-===== ======= ======= ======- ======= ======= ======= ======= ======= ======= ======= ======= ======= ===
Desired=
| Status=
|/ Err?=(none)
||/ Name Version Description
+++-===
ii libsqlite3-0 3.7.3-1 SQLite 3 shared library