Github user anoopsharma00 commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1619#discussion_r197905685
--- Diff: core/sql/regress/compGeneral/EXPECTED023 ---
@@ -23,6 +23,10 @@ SB_HISTOGRAMS
SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
+=======================
--- End diff --
This is not that much of science fiction.
get commands can be used as derived tables within selects.
For ex: one can do the following to get this result:
>>create table if not exists "finance" (a int);
--- SQL operation complete.
>>select left(b, 10) from
+>((select * from (get tables in schema sch) x(a))
+> union all
+> (select * from (get users) x(a))) z(b)
+>where b like 'finance%';
(EXPR)
----------------------------------------
finance
--- 1 row(s) selected.
>>
---
