#013072: SQLite schema reader does not work with uppercase type names

Description:

The ezcDbSchemaSqliteReader class bails out, if it needs to read an SQLite schema with upper case column types. Other database readers so so propably, too. Patch attached (needs tests, though).


Environment:

Operating System:
PHP Version: (please be specific, like '4.4.3' or '5.1.5')
Database and version:
Browser (and version):


- Attachments
sqlite_types.patch (843 b)
[Download] [Permanent Link]

- Comments

I don't see why this is needed. I've never seen SQLite return uppercase field types. Do you have a reproducing script?

#256827 by Derick Rethans on May 26th, 2008 [Permanent Link]

Yes, I have. I used the attached SQL to create my example database. I usually type uppercase type names. DbSchema gave me an error with these, that type '' was not supported. (Note that this used SQLite 3. Maybe that is important.)

#256828 by Tobias Schlitt on May 26th, 2008 [Permanent Link]
- Attachments: » database.sql

Fixed in rev. 8231.

#256910 by Derick Rethans on June 2nd, 2008 [Permanent Link]

- History
Properties
Type Bug
Priority Medium
Component Components » DatabaseSchema
Affects Unknown
Fix Version 2008.1RC1 - eZ components 2008.1RC1
Reporter Tobias Schlitt
Responsible Derick Rethans
Status 0 Closed
Resolution Fixed
Created May 22nd, 2008
Updated June 2nd, 2008
Resolved June 2nd, 2008
 
Navigation [Permanent Link]
Previous Issue
Back to Issues List
Next Issue: #015537
  Graph shows to small and truncated rotated axis labels