proton icon indicating copy to clipboard operation
proton copied to clipboard

list stream rest endpoint is broken when there is broken view

Open ye11ow opened this issue 1 year ago • 0 comments

Describe what's wrong

On top of #729 , when there is broken view, the list stream endpoint is completely broken with the following error:

code: 62, message: Code: 62. DB::Exception: Syntax error: failed at position 389 (')') (line 13, col 60): ) WHERE time >= (now() - INTERVAL MINUTE) GROUP BY symbol, time ), Stats AS ( SELECT symbol, time, aggressive_buys, lags(aggr. Expected one of: token, Arrow, UUID, NOT, BETWEEN, IS, AS, NANOSECOND, SQL_TSI_NANOSECOND, NS, MICROSECOND, SQL_TSI_MICROSECOND, MCS, MILLISECOND, SQL_TSI_MILLISECOND, MS, SECOND, SQL_TSI_SECOND, SS, S, MINUTE, SQL_TSI_MINUTE, MI, N, HOUR, SQL_TSI_HOUR, HH, DAY, SQL_TSI_DAY, DD, D, WEEK, SQL_TSI_WEEK, WK, WW, MONTH, SQL_TSI_MONTH, MM, M, QUARTER, SQL_TSI_QUARTER, QQ, Q, YEAR, SQL_TSI_YEAR, YYYY, YY. (SYNTAX_ERROR) (version 1.5.6)

Ideally Proton should return error with broken view name and error

How to reproduce

Error message and/or stacktrace

Additional context

#729

ye11ow avatar May 15 '24 21:05 ye11ow