[PHOENIX-3635] Many tests failing for not resolving table name properly in Phoenix-Calcite

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: calcite
• Assignee: Rajeshbabu Chintaguntla
• Reporter: Rajeshbabu Chintaguntla
• Created: 25/Jan/17 06:09
• Updated: 27/Jan/17 18:50

Description

There are around 2000 tests failing to resolve the table name and failing with below kind of error.

additionOnDescCompositePK(org.apache.phoenix.end2end.SortOrderIT)  Time elapsed: 1.267 sec  <<< ERROR!
java.sql.SQLException: Error while preparing statement [UPSERT INTO T000161 (n1,n2,n3,d1) VALUES(?,?,?,?)]
	at org.apache.phoenix.end2end.SortOrderIT.runQueryTest(SortOrderIT.java:613)
	at org.apache.phoenix.end2end.SortOrderIT.runQueryTest(SortOrderIT.java:586)
	at org.apache.phoenix.end2end.SortOrderIT.additionOnDescCompositePK(SortOrderIT.java:391)
Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 13 to line 1, column 19: Object 'T000161' not found
	at org.apache.phoenix.end2end.SortOrderIT.runQueryTest(SortOrderIT.java:613)
	at org.apache.phoenix.end2end.SortOrderIT.runQueryTest(SortOrderIT.java:586)
	at org.apache.phoenix.end2end.SortOrderIT.additionOnDescCompositePK(SortOrderIT.java:391)
Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Object 'T000161' not found
	at org.apache.phoenix.end2end.SortOrderIT.runQueryTest(SortOrderIT.java:613)
	at org.apache.phoenix.end2end.SortOrderIT.runQueryTest(SortOrderIT.java:586)
	at org.apache.phoenix.end2end.SortOrderIT.additionOnDescCompositePK(SortOrderIT.java:391)

Issue Links

• relates to: CALCITE-1549 Improve error message when table or column not found