Skip to content

DROP FUNCTION Marformed SQL Statement #236

@MegaCoolBlood

Description

@MegaCoolBlood

Describe the bug

The Script as Drop for Function and Procedures includes the Default Keyword.

To Reproduce

Steps to reproduce the behavior:

  1. Go to Connections
  2. Click on Connect to a database
  3. Scroll down to a function with parameters with default values
  4. click right and select "Script as Drop"
  5. Try to execute
  6. See error: syntax error at or near "DEFAULT"

Expected behavior

I Expect the SQL Dropstatement to be generated without the DEFAULT Keyword and Value.

Same happens with the
ALTER FUNCTION ....
OWNER TO ...; Statement at the end of a Script as Create

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions