[GitHub] [superset] ensky commented on issue #20155: Big Number with Trendline coudn't work with PostgreSQL's date field

Mon, 23 May 2022 02:10:56 -0700 


ensky commented on issue #20155:
URL: https://github.com/apache/superset/issues/20155#issuecomment-1134399460

   @villebro I can reproduce it in SQL Lab with your reproduce step with query
   
   ```
   SELECT DATE_TRUNC('day', publish_date),
          count(*) AS count
   FROM
     (SELECT '2021-01-01'::date as publish_date) AS virtual_table
   GROUP BY DATE_TRUNC('day', publish_date)
   LIMIT 50000;
   ```
   
   
![image](https://user-images.githubusercontent.com/797580/169784929-43fbffb8-e364-4b7e-bba5-22d5e5ab9ff0.png)
   
   pgsql version
   PostgreSQL 12.7 (Debian 12.7-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled 
by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
   
   
![image](https://user-images.githubusercontent.com/797580/169785388-d163833d-e4bd-4d61-8793-0dfb55a0342c.png)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to