APSW Column affinity override not working?

Scott Chapman <[email protected]>
Newsgroups gmane.comp.python.db.pysqlite.user
Message-ID <[email protected]>
I have a table with a column type of NUMERIC (I'm building a shim layer 
to convert python types to some of the SQL types).

When I insert a string value of '123.3231' into this column, it goes in 
as a REAL rather than an INTEGER.

I read in the docs that a declared column type of NUMERIC should have a 
column affinity of REAL, and that I can override the column affinity by 
inserting a literal in single or double quotes.  However when I insert a 
literal in single quotes it is getting stored (and subsequently 
retrieved) as a REAL, not a string.

If I read the docs right, this is a bug.  Please kill the bug or tell me 
how to make that override work! :)

I can make the column type NUMERIC_TEXT and it works correctly but I 
don't want to use _TEXT in the column type (and if I'm reading the docs 
right, shouldn't have to.)

APSW version 3.3.13r1 on Windows under Python 2.5.

Please advise.

Thanks!
Scott
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.