This repository has been archived by the owner on Sep 30, 2024. It is now read-only.
The table-valued parameters are not being created #22
Labels
Comments
davidguilherme
pushed a commit
to davidguilherme/sql-source-control
that referenced
this issue
Apr 3, 2018
The idempotency method was not scripting out properly when the object type is `TT` when the option is `if-not-exists`. This commit fixes that. fixes justinlettau#22
3 tasks
justinlettau
pushed a commit
that referenced
this issue
Apr 4, 2018
* chore(pull): fix the idempotency method for table-valued parameters The idempotency method was not scripting out properly when the object type is `TT` when the option is `if-not-exists`. This commit fixes that. fixes #22 * chore(pull): do not script comma out after the tvp's last column The comma after the last column is not allowed. It raises a syntax error. Exception: `Incorrect syntax near ')'. `
Sign up for free
to subscribe to this conversation on GitHub.
Already have an account?
Sign in.
Type
What kind of issue is this?
Current Behavior
The
table-valued parametersare not being created when the idempotency option fortable-valued parametersisif-not-existseven though they are not already created.Expected behavior
The command
pushshould create thetable-valued parameterswhen the idempotency option for this isif-not-existsand they are not already created.Steps to Reproduce
table-valued parametertoif-not-exists.Other Information
I believe this problem is related to this line: https://github.com/justinlettau/sql-source-control/blob/master/src/sql/script.ts#L76
I can open a Pull Request for this.
The text was updated successfully, but these errors were encountered: