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

sql: error during Eval on parser.RangeCond #7411

Closed
knz opened this issue Jun 22, 2016 · 2 comments
Closed

sql: error during Eval on parser.RangeCond #7411

knz opened this issue Jun 22, 2016 · 2 comments

Comments

@knz
Copy link
Contributor

knz commented Jun 22, 2016

Found by #7409:

pq: sql/parser/eval.go:1824: unhandled type *parser.RangeCond
    SELECT - CASE WHEN NOT NULL BETWEEN NULL AND NULL THEN 17 ELSE NULL END + + 12; -- /home/kena/go/src/github.com/cockroachdb/sqllogictest/test/random/expr/slt_good_1.test:8777
    SELECT ( + - CASE WHEN NULL BETWEEN NULL AND 93 THEN - CAST ( 90 AS INTEGER ) END ) AS col1; -- /home/kena/go/src/github.com/cockroachdb/sqllogictest/test/random/expr/slt_good_1.test:46258
@knz
Copy link
Contributor Author

knz commented Jun 22, 2016

Some more:

    SELECT ( - 4 ) * CASE WHEN NOT NULL NOT BETWEEN NULLIF ( ( + 3 ), + 68 ) AND + 76 + - 6 * + - 82 + - + 1 THEN NULL ELSE + + CAST ( NULL AS INTEGER ) END + + 76; -- /home/kena/go/src/github.com/cockroachdb/sqllogictest/test/random/expr/slt_good_4.test:35789
    SELECT + CASE WHEN NULL NOT BETWEEN 71 AND + 29 THEN + COUNT ( * ) WHEN ( - 13 ) NOT BETWEEN NULL AND ( NULL ) AND CAST ( NULL AS INTEGER ) * + 76 <= ( - 92 + + 93 ) THEN NULL END AS col2; -- /home/kena/go/src/github.com/cockroachdb/sqllogictest/test/random/expr/slt_
    SELECT CASE WHEN NOT NULL NOT BETWEEN - 39 AND - 79 THEN + + 28 END * + MIN ( - + 11 ); -- /home/kena/go/src/github.com/cockroachdb/sqllogictest/test/random/expr/slt_good_4.test:67180

@knz
Copy link
Contributor Author

knz commented Jul 11, 2016

Fixed by #7512 or #7729.

@knz knz closed this as completed Jul 11, 2016
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

1 participant