New issue 285: Query result should be empty string instead of None so ORDER BY
can work
https://bitbucket.org/blais/beancount/issues/285/query-result-should-be-empty-string
Martin Michlmayr:
I'm trying to do an `ORDER BY` query but I get an error because some results
don't have values:
```
beancount> select account, any_meta('who'), sum(position) WHERE account ~
'Assets:Receivable' GROUP BY 1, 2
account any_me sum_positi
----------------- ------ ----------
Assets:Receivable Martin 100.00 EUR
Assets:Receivable 100.00 EUR
beancount>
```
With `ORDER BY 2`:
```
beancount> select account, any_meta('who'), sum(position) WHERE account ~
'Assets:Receivable' GROUP BY 1, 2 ORDER BY 2
Traceback (most recent call last):
File "/usr/lib/python3.5/cmd.py", line 214, in onecmd
func = getattr(self, 'do_' + cmd)
AttributeError: 'BQLShell' object has no attribute 'do_select'
...
File
"/home/tbm/.local/lib/python3.5/site-packages/beancount/query/query_execute.py",
line 328, in execute_query
reverse=(query.ordering == 'DESC'))
TypeError: unorderable types: NoneType() < str()
```
Test case:
```
plugin "beancount.plugins.auto"
2018-04-22 * "Test 1"
Assets:Receivable 100.00 EUR
who: "Martin"
Assets:Bank -100.00 EUR
2018-04-22 * "Test 2"
Assets:Receivable 100.00 EUR
Assets:Bank -100.00 EUR
```
--
You received this message because you are subscribed to the Google Groups
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/beancount/20180423105416.26151.84381%40celery-worker-106.ash1.bb-inf.net.
For more options, visit https://groups.google.com/d/optout.
