Bug 757875

Summary: query_descendants fails on order by clause
Product: [Fedora] Fedora Reporter: Martin Bacovsky <mbacovsk>
Component: python-sqlampAssignee: Martin Bacovsky <mbacovsk>
Status: CLOSED ERRATA QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 16CC: mbacovsk
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: python-sqlamp-0.5.2-3.fc16 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-12-12 21:58:56 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

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.