search

siddhi-io / siddhi-store-rdbms

Extension that can be used to perform DB operations with an RDBMS
https://siddhi-io.github.io/siddhi-store-rdbms/
Apache License 2.0
7 stars 57 forks source link

Filter condition fails when more than one str:contains() is present in the condition #215

Closed niveathika closed 5 years ago

niveathika commented 5 years ago

Description: $subject

@info(name = 'query2') 
from CheckStockStream join StockTable 
on (
   str:contains(StockTable.symbol, 'test') AND 
   str:contains(StockTable.symbol2, 'test1')
)
select CheckStockStream.symbol as checkSymbol, StockTable.symbol as symbol, 
StockTable.volume as volume  
insert into OutputStream ;

The above query resolves to SQL query as,

where symbol LIKE test and symbol2 like %test1%

Affected Product Version: siddhi store RDBMS 7.0.x

OS, DB, other environment details and versions:
H2