Steps to reproduce
Use .getTables(null, "system", "columns", new String[]{"TABLE", "SYSTEM TABLE"}), and the returning result will be nothing.
Problem code:
while (result.next()) {
List<String> row = new ArrayList<>();
row.add(TimeplusDefines.DEFAULT_CATALOG);
row.add(result.getString(1));
row.add(result.getString(2));
String type, e = result.getString(3).intern();
switch (e) {
case "View":
case "MaterializedView":
case "Merge":
case "Distributed":
case "Null":
type = "VIEW"; // some kind of view
break;
case "Set":
case "Join":
case "Buffer":
type = "OTHER"; // not a real table
break;
default:
type = "STREAM";
break;
}
Steps to reproduce
Use .getTables(null, "system", "columns", new String[]{"TABLE", "SYSTEM TABLE"}), and the returning result will be nothing.
Problem code: