Not finding tables
k2xl opened this issue · 2 comments
k2xl commented
I'm trying with min-percent 0, with debugging and sql log turned on seeing this in dexter logs:
SELECT CAST("public"."jhd_sooth"."Date" AS date) AS "Date", sum("public"."jhd_sooth"."New_Deaths") AS "sum", sum("public"."jhd_sooth"."ICU_Beds") AS "sum_2" FROM "public"."jhd_sooth" WHERE date_trunc('year', CAST("public"."jhd_sooth"."Date" AS timestamp)) = date_trunc('year', CAST(now() AS timestamp)) GROUP BY CAST("public"."jhd_sooth"."Date" AS date) ORDER BY CAST("public"."jhd_sooth"."Date" AS date) ASC
I'm wondering if the regex can't find the jhd_sooth
table since it's in the form "public"."jhd_sooth"
?
ankane commented
Hey @k2xl, can you paste the complete output for that query with --log-sql --log-level debug2
? Dexter uses the Postgres parser to parse queries (thanks to pg_query) rather than regexes.
ankane commented
Closing due to no response