On Dec 7, 6:06 pm, Michael Bayer <mike...@zzzcomputing.com> wrote:
> I hadn't planned any future 0.5 releases, 0.7 is almost ready for betas.  
> What are the incompatibilities you have with 0.6 ?

One example is that Numeric(x,y) in oracle is now translated into
Python's Decimal in 0.6.x, was 'float' before in 0.5.x. Also somehow
this conversion gives weird errors, like

engine.execute("select IEP from mytable where name='IP3'").fetchone()
  File "<stdin>", line 1, in <module>
  File "/home/heinkel/Cellzome/Pyenv/lims-py2.7--sqlalchemy-0.6.5/lib/
python2.7/site-packages/SQLAlchemy-0.6.5-py2.7.egg/sqlalchemy/engine/
base.py", line 2527, in fetchone
    row = self._fetchone_impl()
  File "/home/heinkel/Cellzome/Pyenv/lims-py2.7--sqlalchemy-0.6.5/lib/
python2.7/site-packages/SQLAlchemy-0.6.5-py2.7.egg/sqlalchemy/engine/
base.py", line 2445, in _fetchone_impl
    return self.cursor.fetchone()
  File "/usr/local/lib/python2.7/decimal.py", line 548, in __new__
    "Invalid literal for Decimal: %r" % value)
  File "/usr/local/lib/python2.7/decimal.py", line 3825, in
_raise_error
    raise error(explanation)
decimal.InvalidOperation: Invalid literal for Decimal: '7,01'

It has a comma instead of a dot!
I have NLS_LANG="GERMAN_GERMANY.AL32UTF8 set which we need for other
reasons. Unsetting it helps for this problem but creates others.
Everything works fine for my 0.5.8 code, all modules are exactly the
same, I've just replaced the SA version.

Any idea?

ciao ciao
Ralph

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.

Reply via email to