Bug 757875 - query_descendants fails on order by clause
Summary: query_descendants fails on order by clause
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Fedora
Classification: Fedora
Component: python-sqlamp
Version: 16
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Martin Bacovsky
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-11-28 21:14 UTC by Martin Bacovsky
Modified: 2011-12-12 21:58 UTC (History)
1 user (show)

Fixed In Version: python-sqlamp-0.5.2-3.fc16
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-12-12 21:58:56 UTC
Type: ---


Attachments (Terms of Use)

Description Martin Bacovsky 2011-11-28 21:14:20 UTC
Description of problem:
when calling node.mp.query_descendants(and_self=True)
it fails with:

...
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2028, in __iter__
    context = self._compile_context()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2796, in _compile_context
    **self._select_args
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/expression.py", line 296, in select
    **kwargs)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/expression.py", line 4410, in __init__
    _SelectBase.__init__(self, **kwargs)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/expression.py", line 4064, in __init__
    self._order_by_clause = ClauseList(*util.to_list(order_by))
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/expression.py", line 2827, in __init__
    for clause in clauses if clause is not None]
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/expression.py", line 1288, in _literal_as_text
    "SQL expression object or string expected."
ArgumentError: SQL expression object or string expected.
 
It seems that sqlalchemy 0.7.x expect different args in order_by clause.

Comment 1 Fedora Update System 2011-12-03 22:56:38 UTC
python-sqlamp-0.5.2-3.fc16 has been submitted as an update for Fedora 16.
https://admin.fedoraproject.org/updates/python-sqlamp-0.5.2-3.fc16

Comment 2 Fedora Update System 2011-12-05 00:26:59 UTC
Package python-sqlamp-0.5.2-3.fc16:
* should fix your issue,
* was pushed to the Fedora 16 testing repository,
* should be available at your local mirror within two days.
Update it with:
# su -c 'yum update --enablerepo=updates-testing python-sqlamp-0.5.2-3.fc16'
as soon as you are able to.
Please go to the following url:
https://admin.fedoraproject.org/updates/FEDORA-2011-16785/python-sqlamp-0.5.2-3.fc16
then log in and leave karma (feedback).

Comment 3 Fedora Update System 2011-12-12 21:58:56 UTC
python-sqlamp-0.5.2-3.fc16 has been pushed to the Fedora 16 stable repository.  If problems still persist, please make note of it in this bug report.


Note You need to log in before you can comment on or make changes to this bug.