Bug Report: schemadiff: invalid schema when only entity is a view reading FROM DUAL

[shlomi-noach]

Overview of the Issue

In a scenario where the entire schema is:

create view v as select 1 from dual

We get a

view `v` has unresolved/loop dependencies

This is because of a delicate change in #11944 and a hidden assumption: that there's always going to be at least one table... In our case there isn't any table, and a counter was not incremented when the algorithm assumed it would be.

Reproduction Steps

func TestNewSchemaFromQueriesViewFromDual(t *testing.T) {
	queries := []string{
		"create view v20 as select 1 from dual",
	}
	_, err := NewSchemaFromQueries(queries)
	assert.NoError(t, err)
}

^ the above fails with error

Binary Version

-

Operating System and Environment details

-

Log Fragments

No response