Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Nested queries with date filter fail with honeysql error #9056

Closed
lenn4rd opened this Issue Nov 30, 2018 · 3 comments

Comments

Projects
None yet
3 participants
@lenn4rd
Copy link

lenn4rd commented Nov 30, 2018

Using a question that has a date filter defined as Saved Question in the query builder fails with the following error:

No method in multimethod '->honeysql' for dispatch value: [metabase.driver.h2.H2Driver :time-interval]

Steps to reproduce:

  1. Create a question from any table in the sample database and define a simple date filter, e.g. Created At is Current Year in Orders
  2. Use this question as a Saved Question and execute it; it'll fail with above error message

This seems to be a regression. I encountered it while testing our staging installation running v0.31.1 and also tested against our production installation running v0.30.1. It works in v0.30.1 and it's broken in v0.31.1.

I looked at the issues labeled Nested Queries and the ones with a similar error message but they seem a bit different. Let me know if I missed something and feel free to close issue as a duplicate.

  • Your browser and the version: Safari 12.0.1
  • Your operating system: macOS 10.13.6
  • Your databases: Postgres 10.4
  • Metabase version: v0.31.1
  • Metabase hosting environment: AWS ECS
  • Metabase internal database: Postgres 10.5
@camsaul

This comment has been minimized.

Copy link
Member

camsaul commented Nov 30, 2018

Duplicate of #9007

@lenn4rd

This comment has been minimized.

Copy link
Author

lenn4rd commented Mar 4, 2019

This is actually not a duplicate of #9007 because it's set up a bit differently. In contrast to that issue, my issue is caused by using the Custom query builder and setting a date in the underlying (to be nested) query. When using it as a nested query, it fails.

@flamber

This comment has been minimized.

Copy link

flamber commented Mar 4, 2019

@lenn4rd Yeah, it seems like a different issue. I can reproduce your issue on 0.31.2 with any datasource

@camsaul This issue seems to be valid, while I cannot reproduce #9007 on 0.31.2

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.