- changed status to wontfix
Oracle ordering by a Text field fails
Issue #1718
resolved
When using Oracle, ordering by a text field fails: DatabaseError: (DatabaseError) ORA-00932: inconsistent datatypes: expected - got CLOB
The solution would be to order by a casted version of a string: select my_clob from my_table order by cast(my_clob as varchar2(4000))
Comments (1)
-
repo owner - Log in to comment
SQLA isn't going to make a decision like that for you, sorry.