thomasrebele commented on code in PR #6060: URL: https://github.com/apache/hive/pull/6060#discussion_r2354765201
########## ql/src/test/queries/clientpositive/view_with_where_exp.q: ########## Review Comment: Could we simplify the test case, please? E.g., by removing unnecessary columns, using simpler constants. The following test case reproduces the issue: ``` CREATE TABLE IF NOT EXISTS t0(col DOUBLE); CREATE VIEW v0 AS (SELECT ALL (t0.col) AS col FROM t0); INSERT INTO t0(col) VALUES(0.1); explain cbo SELECT t0.col from t0 WHERE ((1000)/(0)) IS NOT NULL; SELECT t0.col from t0 WHERE ((1000)/(0)) IS NOT NULL; explain cbo SELECT v0.col FROM v0 WHERE ((1000)/(0)) IS NOT NULL; SELECT v0.col FROM v0 WHERE ((1000)/(0)) IS NOT NULL; ``` -- 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]
