Loading...

XML

Word

Printable

Steps to Reproduce:

Hide

– Fails

Select day_date, month_name from warehouse.dim_date

where

"day_date" >= TimestampAdd(SQL_TSI_DAY, 1, '2020-09-17')

and

month_name != 'Tuesday''s'

limit 5

;

--Succeeds and pushes down the date filter

Select day_date, month_name from warehouse.dim_date

where

"day_date" >= TimestampAdd(SQL_TSI_DAY, 1, '2020-09-17')

– and

– month_name != 'Tuesday''s'

limit 5

;

– Succeeds and pushes down the string filter

Select day_date, month_name from warehouse.dim_date

where

– "day_date" >= TimestampAdd(SQL_TSI_DAY, 1, '2020-09-17')

– and

month_name != 'Tuesday''s'

limit 5

;

limit 5

;

Show
– Fails Select day_date, month_name from warehouse.dim_date where "day_date" >= TimestampAdd(SQL_TSI_DAY, 1, '2020-09-17') and month_name != 'Tuesday''s' limit 5 ; --Succeeds and pushes down the date filter Select day_date, month_name from warehouse.dim_date where "day_date" >= TimestampAdd(SQL_TSI_DAY, 1, '2020-09-17') – and – month_name != 'Tuesday''s' limit 5 ; – Succeeds and pushes down the string filter Select day_date, month_name from warehouse.dim_date where – "day_date" >= TimestampAdd(SQL_TSI_DAY, 1, '2020-09-17') – and month_name != 'Tuesday''s' limit 5 ; limit 5 ;
Release Note Text:
Undefined

Combining filter with quotes in strings and TimestampAdd causes query to fail: