We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
Support multiple model calls in selecting from predictor with using IN statement.
This select
SELECT * FROM model WHERE a IN (100,101)
Should call model twice, with two inputs and return two records in output. Equivalent calls:
SELECT * FROM model WHERE a = 100; SELECT * FROM model WHERE a = 101;
Edge cases
SELECT * FROM model WHERE a IN (100,101) and b = 1
is converted to:
SELECT * FROM model WHERE a = 100 and b = 1; SELECT * FROM model WHERE a = 101 and b = 1;
SELECT * FROM model WHERE a IN (100,101) and b IN (1,2)
SELECT * FROM model WHERE a = 100 and b = 1; SELECT * FROM model WHERE a = 101 and b = 2;
SELECT * FROM model WHERE a IN (100,101) and b IN (1,2,3)
raises an error
SELECT * FROM model WHERE a IN (select a from table1)
Raise not supported ? To be able to handle this case this logic should be implemented in mindsdb.
The text was updated successfully, but these errors were encountered:
No branches or pull requests
Support multiple model calls in selecting from predictor with using IN statement.
This select
Should call model twice, with two inputs and return two records in output.
Equivalent calls:
Edge cases
is converted to:
is converted to:
raises an error
Raise not supported ?
To be able to handle this case this logic should be implemented in mindsdb.
The text was updated successfully, but these errors were encountered: