New issue 344: bql: column name specified via AS can't be used in WHERE
https://bitbucket.org/blais/beancount/issues/344/bql-column-name-specified-via-as-cant-be
Martin Michlmayr:
I specify a column name via "AS foo" but then "WHERE foo" says that "foo" is an
invalid column. It would be nice if it would recognise the custom column names
I make via "AS".
```
beancount> SELECT ANY_META('entity') as entity WHERE ANY_META('entity') ~
'Michlmayr';
entity
---------
Michlmayr
Michlmayr
Michlmayr
Michlmayr
beancount> SELECT ANY_META('entity') as entity WHERE entity ~ 'Michlmayr';
ERROR: Invalid column name 'entity' in WHERE clause context.
beancount>
```
--
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/20181212210841.15203.30747%40celery-worker-111.ash1.bb-inf.net.
For more options, visit https://groups.google.com/d/optout.
