postgres model.drop() throws error without options object passed

[aliatsis]

Issue Description

When using postgres dialect, calling model.drop() throws an error such as:
Cannot set property 'supportsSearchPath' of undefined

What do you expect to happen?

The drop options should be optional and should not error if not passed

What is actually happening?

It appears the abstract query interface relies on a super call to default the options object. However, the mutated options reference in the super function is not available in the child dropTable function so options is still undefined when supportsSearchPath is trying to be set

Output here

Additional context

Add any other context or screenshots about the feature request here.

Environment

• Sequelize version: 6.6.2
• Node.js version: 14.16
• Operating System: MacOS Catalina
• If TypeScript related: TypeScript version: 4.1.3

Issue Template Checklist

How does this problem relate to dialects?

• I think this problem happens regardless of the dialect.
• [X ] I think this problem happens only for the following dialect(s): postgres
• I don't know, I was using PUT-YOUR-DIALECT-HERE, with connector library version XXX and database version XXX

Would you be willing to resolve this issue by submitting a Pull Request?

• Yes, I have the time and I know how to start.
• Yes, I have the time but I don't know how to start, I would need guidance.
• [X ] No, I don't have the time, although I believe I could do it if I had the time...
• No, I don't have the time and I wouldn't even know how to start.

[github-actions]

This issue has been automatically marked as stale because it has been open for 7 days without activity. It will be closed if no further activity occurs. If this is still an issue, just leave a comment or remove the "stale" label. 🙂

[aperkaz]

For future reference, the error goes away when passing an empty object as parameter: dbConnection.sequelize?.drop({})

[ephys]

Looks like a bug in the postgres dialect caused by this line:
https://github.com/sequelize/sequelize/blob/main/src/dialects/postgres/query-interface.js#L240

[wbourne0]

fwiw this is also an issue with queryInterface.dropTable. Should be a pretty trivial fix.