System.Data.SQLite

Login
This project makes use of Eagle, provided by Mistachkin Systems.
Eagle: Secure Software Automation
2013-05-17
10:27 Closed ticket [48a6b8e4ca]: Reading PRAGMA table_info using SQLiteDataAdapter fails plus 2 other changes artifact: 3e5089e9f5 user: mistachkin
2013-04-29
23:18 Ticket [48a6b8e4ca]: 3 changes artifact: 63d5884e24 user: mistachkin
23:04 Ticket [48a6b8e4ca]: 3 changes artifact: 9ea8a43ae9 user: mistachkin
23:02 Fixed ticket [48a6b8e4ca]. artifact: de4c7e3ab6 user: mistachkin
23:00
NULL values should be mapped to type 'object', not 'DBNull'. Fix for ticket [48a6b8e4ca]. Also see ticket [49e30d7612]. check-in: dcc277f29a user: mistachkin tags: trunk
22:27 Pending ticket [48a6b8e4ca]: Reading PRAGMA table_info using SQLiteDataAdapter fails plus 3 other changes artifact: 2a37fd8ce4 user: mistachkin
22:24 Ticket [48a6b8e4ca]: 3 changes artifact: 1790c5951d user: mistachkin
22:04 Open ticket [48a6b8e4ca]. artifact: cb58f97b06 user: mistachkin
22:02 New ticket [48a6b8e4ca]. artifact: 5eadf9cb01 user: mistachkin

Ticket Hash: 48a6b8e4caab103c7f1cd87bcfbc528ed9f5b883
Title: Reading PRAGMA table_info using SQLiteDataAdapter fails
Status: Closed Type: Code_Defect
Severity: Important Priority: Blocker
Subsystem: Db_Type_Conversion Resolution: Fixed
Last Modified: 2013-05-17 10:27:40
Version Found In: 1.0.85.0
User Comments:
mistachkin (claiming to be anonymous) added on 2013-04-29 22:04:31:
After update from 1.0.84 to 1.0.85 the SQL-Statement
pragma table_info(<TABLENAME>) 
could not be read into a DataTable, because the DbDataReader returns "DBNull" as Column-Type for the "default-Value"-Column (Column No. 5) in the result.

mistachkin added on 2013-04-29 22:24:40:
This issue causes the SQLiteConvert.GetFieldType method to return an incorrect
value for NULL values.

mistachkin added on 2013-04-29 23:02:00:
Preliminary fix checked-in on trunk [dcc277f29a].

Is it possible for you to verify that this fixes the issue seen in your 
environment?

mistachkin added on 2013-04-29 23:18:06:
Also see ticket [49e30d7612].