Using arithmetic operators when joining isn't working

[hvt]

The following query:

select appa.bytes + appb.bytes 
from test as appa 
inner join test as appb 
where appa.app == 'ssl' and appb.app == 'web-browsing'

Results in:

Error at 12473601:18. syntax error, unexpected '+', expecting FROM

Running 0.3.0 on amd64 (Linux Mint).

[jvshahid]

I updated the title to match what i think is the problem

[jvshahid]

I pushed a change to support arithmetic expressions in select queries. That said, the query above won't work as expected since the where clause takes effect after the two time series are joined. Since joining is done based on timestamps, the joined time series will have the same points merged together, i.e. appa.app will always equal appb.app. As a matter of fact, appa.<any column> will equal appb.<any column>. This means that the condition in your where clause will always evaluate to false. The only way to achieve what you're trying to do, is using subqueries which i'll work on next #52. After subqueries is implemented, the correct query should be:

select appa.bytes + appb.bytes
from (select bytes from test where app = 'ssl') as appa
inner join (select bytes from test where app = 'web-browsing') as appb

I hope my explanation makes sense. Please let me know if you have any questions.

[jvshahid]

Closed by 0bff817