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

Cannot cache field info #2966

Closed
alouane opened this issue Jun 25, 2017 · 3 comments
Closed

Cannot cache field info #2966

alouane opened this issue Jun 25, 2017 · 3 comments

Comments

@alouane
Copy link
Contributor

alouane commented Jun 25, 2017

Hi
Can someone point me out what this error means

image

Is there something wrong with these queries?

Thanks

@sougou
Copy link
Contributor

sougou commented Jun 25, 2017

Alouane:
This is an optimization warning. It basically says that it can't cache the field info for the query (col name, type, etc). So, it will rebuild that info for every query.

The only time it should be unable to perform this caching is if you're using bind variables in your select expression (like select :a...). If so, the field info will change depending on the value you passed.

However, it looks like the analyzer has a bug. It's triggering this even if your group by expression has bind vars. The fix is trivial. I'll keep this bug open for it.

Until then, the queries should still execute fine. They may just be marginally more expensive than usual.

@aquarapid
Copy link
Contributor

#3538 removed this error message

@ajm188
Copy link
Contributor

ajm188 commented Jun 24, 2022

closing due to #3538

@ajm188 ajm188 closed this as completed Jun 24, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants