I've built a cockpit that shows the same value repeated many times instead of only one (I expect that if I do a table where I ask only a field, to get the DISTINCT of that field) -> ex: I have a data source PEOPLE(Name, Surname, Sex, Id), I expect that if i build a table on top of that data source where I put only SEX column, I get at most 3 rows: M,F,NULL, now I get repetitions.
EDIT:
Now I'm on MSSQL12 table without cache
EDIT2:
I tryed enabling cache and and I got no duplicates
UPDATE:
I can confirm distinct is missing from the queryes: I logged the query on both MSSQL and MySQL and on mysql's there is the distinct absent in MSSQL ones.
From MySQL:
SELECT COUNT(*) FROM (select distinct `ATC_1` from sbicache79676581730511e8aed507) temptable
Query (logged by knowage) on SQLSERVER:
SELECT COUNT(*) FROM (select "ATC_1" AS "ATC_1" from (SELECT
,[some columns]
,[ATC_1]
FROM [dbo].[AFO_e_magazzino_join_materializzata]) T ) temptable ... |
EDIT3:
I'm using JDBC connection (if it can help)
