Saving all output to "!!{outputDirectory}!!/show_indexes_edge_cases.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/show_indexes_edge_cases.q
>>>  DROP TABLE show_idx_empty;
No rows affected 
>>>  DROP TABLE show_idx_full;
No rows affected 
>>>  
>>>  CREATE TABLE show_idx_empty(KEY STRING, VALUE STRING);
No rows affected 
>>>  CREATE TABLE show_idx_full(KEY STRING, VALUE1 STRING, VALUE2 STRING);
No rows affected 
>>>  
>>>  CREATE INDEX idx_1 ON TABLE show_idx_full(KEY) AS "COMPACT" WITH DEFERRED REBUILD;
No rows affected 
>>>  CREATE INDEX idx_2 ON TABLE show_idx_full(VALUE1) AS "COMPACT" WITH DEFERRED REBUILD;
No rows affected 
>>>  
>>>  CREATE INDEX idx_comment ON TABLE show_idx_full(VALUE2) AS "COMPACT" WITH DEFERRED REBUILD COMMENT "index comment";
No rows affected 
>>>  CREATE INDEX idx_compound ON TABLE show_idx_full(KEY, VALUE1) AS "COMPACT" WITH DEFERRED REBUILD;
No rows affected 
>>>  
>>>  ALTER INDEX idx_1 ON show_idx_full REBUILD;
No rows affected 
>>>  ALTER INDEX idx_2 ON show_idx_full REBUILD;
No rows affected 
>>>  ALTER INDEX idx_comment ON show_idx_full REBUILD;
No rows affected 
>>>  ALTER INDEX idx_compound ON show_idx_full REBUILD;
No rows affected 
>>>  
>>>  EXPLAIN SHOW INDEXES ON show_idx_full;
'Explain'
'ABSTRACT SYNTAX TREE:'
'  (TOK_SHOWINDEXES show_idx_full)'
''
'STAGE DEPENDENCIES:'
'  Stage-0 is a root stage'
'  Stage-1 is a root stage'
''
'STAGE PLANS:'
'  Stage: Stage-0'
'      Show Index Operator:'
'        Show Indexes'
''
'  Stage: Stage-1'
'    Fetch Operator'
'      limit: -1'
''
''
17 rows selected 
>>>  SHOW INDEXES ON show_idx_full;
'idx_name','tab_name','col_names','idx_tab_name','idx_type','comment'
'idx_1               ','show_idx_full       ','key                 ','show_indexes_edge_cases__show_idx_full_idx_1__','compact             ',''
'idx_2               ','show_idx_full       ','value1              ','show_indexes_edge_cases__show_idx_full_idx_2__','compact             ',''
'idx_comment         ','show_idx_full       ','value2              ','show_indexes_edge_cases__show_idx_full_idx_comment__','compact             ','index comment       '
'idx_compound        ','show_idx_full       ','key, value1         ','show_indexes_edge_cases__show_idx_full_idx_compound__','compact             ',''
4 rows selected 
>>>  
>>>  EXPLAIN SHOW INDEXES ON show_idx_empty;
'Explain'
'ABSTRACT SYNTAX TREE:'
'  (TOK_SHOWINDEXES show_idx_empty)'
''
'STAGE DEPENDENCIES:'
'  Stage-0 is a root stage'
'  Stage-1 is a root stage'
''
'STAGE PLANS:'
'  Stage: Stage-0'
'      Show Index Operator:'
'        Show Indexes'
''
'  Stage: Stage-1'
'    Fetch Operator'
'      limit: -1'
''
''
17 rows selected 
>>>  SHOW INDEXES ON show_idx_empty;
'idx_name','tab_name','col_names','idx_tab_name','idx_type','comment'
No rows selected 
>>>  
>>>  DROP INDEX idx_1 on show_idx_full;
No rows affected 
>>>  DROP INDEX idx_2 on show_idx_full;
No rows affected 
>>>  DROP TABLE show_idx_empty;
No rows affected 
>>>  DROP TABLE show_idx_full;
No rows affected 
>>>  !record