[HIVE-8475] add test case for use of index from not-current database

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.14.0
• Component/s: Indexing
• Assignee: Thejas Nair
• Reporter: Thejas Nair
• Created: 15/Oct/14 21:42
• Updated: 13/Nov/14 19:43
• Resolved: 18/Oct/14 01:15

Description

In hive 0.13, the following sequence fails -

create database index_test_db;

use index_test_db;
create table testtb (id int, name string);
create index id_index on table testtb (id) as 'COMPACT' WITH DEFERRED REBUILD  in table testdb_id_idx_tb;

use default;
select * from index_test_db.testtb where id>2;
-- fails here with error "Table not found testdb_id_idx_tb" 

HIVE-4064 fixed the problem. It will be useful to have a test case that verifies the fix.

Issue Links

• breaks: HIVE-8514 TestCliDriver.testCliDriver_index_in_db fails in trunk