451437 - pragma main.table_info does not return correct info sometimes

Status: RESOLVED FIXED

(Core :: SQLite and Embedded Database Bindings, defect)

Description

[lazierthanthou]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.1) Gecko/2008070208 Firefox/3.0.1
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.1) Gecko/2008070208 Firefox/3.0.1

please see the ticket number 3320 filed by me at sqlite.org:
http://www.sqlite.org/cvstrac/tktview?tn=3320

This is an sqlite bug which has been fixed now.
The fix should be incorporated in firefox 3 too.

Reproducible: Always

Comment 1

[Shawn Wilsher :sdwilsh]

Fixed in what version of sqlite?

Comment 2

[lazierthanthou]

The following is a remark in the aforesaid tkt no 3320:

"2008-Aug-20 21:46:08 by drh:
The patch is available on-line. You can (try to) apply it to any version of SQLite you want. The patch will only be supported in the next regular release of SQLite - version 3.6.2 - currently scheduled for 2008-08-25 12:00:00 UTC. We do not do public branch releases or public patches to historical versions."

I was hoping we could have something like 3.5.9.1 with such simple fixes so that Ff 3.0.x could benefit too.

Comment 3

[Shawn Wilsher :sdwilsh]

It's highly unlikely that we'll do that, but it is likely that we'll take the next upgrade of sqlite that sticks on mozilla-central to Firefox 3.0

Comment 4

[Shawn Wilsher :sdwilsh]

This was fixed by bug 449443.