User view may not always return the correct last DDL operation and object

DASSL / ClassDB

An open-source system to let students experiment with relational data

https://dassl.github.io/ClassDB/

Other

8 stars 2 forks source link

Closed smurthys closed 6 years ago

smurthys commented 6 years ago

The derived table DDLActOB in the definition of User view depends on an ORDER BY to return the last DDL operation and object.

(I will review the issue and add comments later.)

smurthys commented 6 years ago

Sorry, I had not noticed the ON expression in DISTINCT.

The sub-query to compute last DDL op and object are more complex than necessary, but there is no error.