You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Describe the bug
PowerBI Desktop, Direct Query, Slicer - try to Search "Test" - DB::Exception: Syntax error
To Reproduce
Steps to reproduce the behavior:
1.
create table test_pbi_slicer_search (code String not null) Engine = MergeTree() order by (code);
insert into test_pbi_slicer_search values ('test_01'),('test_02'),('test_03'),('test_04'),('test_05');
PowerBI Desktop, standard Slicer, try to search "test"
ERROR: see screenshot
Exception in Logs
(version 24.1.2.5 (official build))
2024.02.16 11:42:50.431448 [ 1173 ]
<Error> executeQuery: Code: 62. DB::Exception: Syntax error: failed at position 101 ('locate') (line 6, col 16): locate({odbc_positional_1:LowCardinality(String)}
,(case^M
when `code` is not null^M
then `code`^M
else {odbc_positional_2:LowCardinality(S. Expected colon between name and type. (SYNTAX_ERROR)
(version 24.1.2.5 (official build))
(in query: select `code` from ( select `code` from `dev`.`test_pbi_slicer_search` where { fn locate({odbc_positional_1:LowCardinality(String)}, (case when `code` is not null then `code` else {odbc_positional_2:LowCardinality(String)} end), {odbc_positional_3:Nullable(Int32)}) } >= {odbc_positional_4:Nullable(Int32)} ) as `ITBL` group by `code` order by `code` limit 101), Stack trace (when copying this message, always include the lines below):
QUERY from logs
select `code` from (
select `code` from `dev`.`test_pbi_slicer_search`
where { fn locate(
{odbc_positional_1:LowCardinality(String)}
,(case when `code` is not null then `code` else {odbc_positional_2:LowCardinality(String)} end)
,{odbc_positional_3:Nullable(Int32)}) }
>= {odbc_positional_4:Nullable(Int32)}
) as `ITBL` group by `code` order by `code` limit 101
Screenshots
Configuration
Environment
PowerBI version: MS PowerBI Desktop. Version: 2.124.2028.0 64-bit (December 2023)
power-bi-clickhouse version: v0.1.2-beta
ClickHouse ODBC driver version: 1.2.1.20220905
ClickHouse: 24.1.2.5
Operating system: Microsoft Windows [Version 10.0.19045.3930]; Ubuntu 20.04.5 LTS
The text was updated successfully, but these errors were encountered:
Describe the bug
PowerBI Desktop, Direct Query, Slicer - try to Search "Test" - DB::Exception: Syntax error
To Reproduce
Steps to reproduce the behavior:
1.
PowerBI Desktop, standard Slicer, try to search "test"
ERROR: see screenshot
Exception in Logs
Screenshots
Configuration
Environment
The text was updated successfully, but these errors were encountered: