{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":9589397,"defaultBranch":"master","name":"generate-sql-merge","ownerLogin":"dnlnln","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2013-04-22T02:32:35.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/2928446?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1703651213.0","currentOid":""},"activityList":{"items":[{"before":"f18f46d1408ec0c21606e1d1048beb82d686d9ec","after":"46c04f90bbf47735d72d1fb50f92cce2d7e4ae92","ref":"refs/heads/master","pushedAt":"2024-05-06T00:51:48.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"},"commit":{"message":"Merge pull request #109 from swiggins/master\n\nAllow for column names of 'Source'","shortMessageHtmlLink":"Merge pull request #109 from swiggins/master"}},{"before":"1c1671e897538b00a6934afbcaae549a522fa6fe","after":"4809ec37fc8aca6a972e80538ba534f0a94d710d","ref":"refs/heads/fix-line-endings","pushedAt":"2023-12-27T04:25:42.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"},"commit":{"message":"Fix accuracy issue in scripting of (N)VARCHAR columns with linebreaks on SQL Linux","shortMessageHtmlLink":"Fix accuracy issue in scripting of (N)VARCHAR columns with linebreaks…"}},{"before":"f18f46d1408ec0c21606e1d1048beb82d686d9ec","after":"1c1671e897538b00a6934afbcaae549a522fa6fe","ref":"refs/heads/fix-line-endings","pushedAt":"2023-12-18T07:47:22.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"},"commit":{"message":"Use LF (Unix) on line endings instead of CRLF (Windows)\n\nReduces the likelihood of the current bug with generating multi-line data in SQL Server Linux causing a 'string or binary data would be truncated' error upon executing the generated MERGE statement.","shortMessageHtmlLink":"Use LF (Unix) on line endings instead of CRLF (Windows)"}},{"before":null,"after":"f18f46d1408ec0c21606e1d1048beb82d686d9ec","ref":"refs/heads/fix-line-endings","pushedAt":"2023-12-18T07:44:18.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"},"commit":{"message":"Resolve collation conflict error when installing as a tempdb proc","shortMessageHtmlLink":"Resolve collation conflict error when installing as a tempdb proc"}},{"before":"936386c1a6594a1f75b0e32f4c754dafab5d52b6","after":"f18f46d1408ec0c21606e1d1048beb82d686d9ec","ref":"refs/heads/master","pushedAt":"2023-12-04T07:25:34.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"},"commit":{"message":"Resolve collation conflict error when installing as a tempdb proc","shortMessageHtmlLink":"Resolve collation conflict error when installing as a tempdb proc"}},{"before":"82813577dcd6dfc652d38cefa19630caf8de533e","after":null,"ref":"refs/heads/add-execute-on-generate-param","pushedAt":"2023-11-20T08:13:16.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"}},{"before":"3fb7315e066f50f8bb0b7999c1ab29b7f7a045c7","after":"936386c1a6594a1f75b0e32f4c754dafab5d52b6","ref":"refs/heads/master","pushedAt":"2023-11-20T08:13:15.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"},"commit":{"message":"Merge pull request #107 from dnlnln/add-execute-on-generate-param\n\nAdd @execute param to auto-execute generated MERGE","shortMessageHtmlLink":"Merge pull request #107 from dnlnln/add-execute-on-generate-param"}},{"before":"4a4bfed25d90f72ccd40f7eec4fc6ddc2de92215","after":"82813577dcd6dfc652d38cefa19630caf8de533e","ref":"refs/heads/add-execute-on-generate-param","pushedAt":"2023-11-20T08:12:10.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"},"commit":{"message":"Add @execute=1 param to auto-execute generated MERGE","shortMessageHtmlLink":"Add @execute=1 param to auto-execute generated MERGE"}},{"before":null,"after":"4a4bfed25d90f72ccd40f7eec4fc6ddc2de92215","ref":"refs/heads/add-execute-on-generate-param","pushedAt":"2023-11-20T08:06:10.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"},"commit":{"message":"Add @execute=1 param to auto-execute generated MERGE","shortMessageHtmlLink":"Add @execute=1 param to auto-execute generated MERGE"}},{"before":"28bcf15cb0e4e9d4bed844cd7072c42f2c5a2364","after":"3fb7315e066f50f8bb0b7999c1ab29b7f7a045c7","ref":"refs/heads/master","pushedAt":"2023-11-20T08:01:59.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"},"commit":{"message":"Improve documentation (esp examples)","shortMessageHtmlLink":"Improve documentation (esp examples)"}},{"before":"8ec414315e1b667357f010ac69d3c5f64ec2f641","after":null,"ref":"refs/heads/use-except-instead-of-nullif-in-change-detection","pushedAt":"2023-11-09T09:43:23.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"}},{"before":"cfb83a7ebbc0785db1d6059c70408f9f206715ed","after":"28bcf15cb0e4e9d4bed844cd7072c42f2c5a2364","ref":"refs/heads/master","pushedAt":"2023-11-09T09:43:22.000Z","pushType":"pr_merge","commitsCount":10,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"},"commit":{"message":"Merge pull request #106 from dnlnln/use-except-instead-of-nullif-in-change-detection\n\nChange detection via EXCEPT (instead of NULLIF)","shortMessageHtmlLink":"Merge pull request #106 from dnlnln/use-except-instead-of-nullif-in-c…"}},{"before":"8ce3c4364e43a563d12cb161190d22e765ee5d70","after":"8ec414315e1b667357f010ac69d3c5f64ec2f641","ref":"refs/heads/use-except-instead-of-nullif-in-change-detection","pushedAt":"2023-11-06T02:13:13.000Z","pushType":"push","commitsCount":4,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"},"commit":{"message":"Condense formatting of change detection within MERGE","shortMessageHtmlLink":"Condense formatting of change detection within MERGE"}},{"before":"d54f829258de84d93b1bb29993a2de3de5b6cc5b","after":"8ce3c4364e43a563d12cb161190d22e765ee5d70","ref":"refs/heads/use-except-instead-of-nullif-in-change-detection","pushedAt":"2023-11-06T00:37:46.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"},"commit":{"message":"Correct unicode encoding for output string datatypes","shortMessageHtmlLink":"Correct unicode encoding for output string datatypes"}},{"before":"7ceb7881a35f46b40569627f6ac42f213e258f4e","after":"d54f829258de84d93b1bb29993a2de3de5b6cc5b","ref":"refs/heads/use-except-instead-of-nullif-in-change-detection","pushedAt":"2023-11-06T00:16:55.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"},"commit":{"message":"Ensure Xml columns only get updated if actually changed","shortMessageHtmlLink":"Ensure Xml columns only get updated if actually changed"}},{"before":"0ecc6806ea74c2327849411cfd1ab312a00a09c2","after":"7ceb7881a35f46b40569627f6ac42f213e258f4e","ref":"refs/heads/use-except-instead-of-nullif-in-change-detection","pushedAt":"2023-11-06T00:03:26.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"},"commit":{"message":"Fix SSMS output encoding issue for all data types, not just Xml","shortMessageHtmlLink":"Fix SSMS output encoding issue for all data types, not just Xml"}},{"before":"5d6f0f169ed89e0c7b77369f6441d9c37ee7e568","after":"0ecc6806ea74c2327849411cfd1ab312a00a09c2","ref":"refs/heads/use-except-instead-of-nullif-in-change-detection","pushedAt":"2023-11-05T07:16:43.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"},"commit":{"message":"Correct serialising of Xml columns that contain processing directives\n\nFixes \"incorrect processing instruction syntax\" error when executing the generated MERGE statement","shortMessageHtmlLink":"Correct serialising of Xml columns that contain processing directives"}},{"before":null,"after":"5d6f0f169ed89e0c7b77369f6441d9c37ee7e568","ref":"refs/heads/use-except-instead-of-nullif-in-change-detection","pushedAt":"2023-10-23T09:07:00.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"},"commit":{"message":"Fix #65 Change detection via EXCEPT instead of NULLIF\n\nOvercame lack of equality support for geometry and geography columns by selecting 1 if the value has changed and 0 if not (change detection is achieved for those types by always returning 0 in the second SELECT in the EXCEPT).","shortMessageHtmlLink":"Fix #65 Change detection via EXCEPT instead of NULLIF"}},{"before":"b0a9c11def39a19a59fae2c1f0840b760e277968","after":null,"ref":"refs/heads/prevent-race-condition-in-upsert","pushedAt":"2023-10-23T07:21:56.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"}},{"before":"c78fabc0fc6c633beadc4fba6319a01e4f2d2a10","after":"cfb83a7ebbc0785db1d6059c70408f9f206715ed","ref":"refs/heads/master","pushedAt":"2023-10-23T07:21:55.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"},"commit":{"message":"Merge pull request #105 from dnlnln/prevent-race-condition-in-upsert\n\nAdd SERIALIZABLE table hint to prevent race condition in concurrent executions","shortMessageHtmlLink":"Merge pull request #105 from dnlnln/prevent-race-condition-in-upsert"}},{"before":null,"after":"b0a9c11def39a19a59fae2c1f0840b760e277968","ref":"refs/heads/prevent-race-condition-in-upsert","pushedAt":"2023-10-23T07:20:25.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"},"commit":{"message":"Prevent a race condition from occurring in concurrent executions\n\nAdds the WITH (SERIALIZABLE) hint to prevent inconsistent results when more than one simultaneous execution of a MERGE or INSERT/UPDATE occurs on a given table.\n\nFor more information, see:\n* https://dba.stackexchange.com/a/317527/2767\n* https://web.archive.org/web/20210405205926/https://weblogs.sqlteam.com/dang/2009/01/31/upsert-race-condition-with-merge/","shortMessageHtmlLink":"Prevent a race condition from occurring in concurrent executions"}},{"before":"6f318a26aae4daffe5c9332d8a9bb573cac1cecf","after":null,"ref":"refs/heads/support_variant_datatype_columns","pushedAt":"2023-10-17T07:58:48.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"}},{"before":"36ec67d76feb3c41ceec5b8f6cd9c42375c7666e","after":"c78fabc0fc6c633beadc4fba6319a01e4f2d2a10","ref":"refs/heads/master","pushedAt":"2023-10-17T07:58:47.000Z","pushType":"pr_merge","commitsCount":6,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"},"commit":{"message":"Merge pull request #104 from dnlnln/support_variant_datatype_columns\n\nSupport sql_variant datatype columns","shortMessageHtmlLink":"Merge pull request #104 from dnlnln/support_variant_datatype_columns"}},{"before":"099156f0085597d9628b663ab6af88b1a5920a2d","after":"6f318a26aae4daffe5c9332d8a9bb573cac1cecf","ref":"refs/heads/support_variant_datatype_columns","pushedAt":"2023-10-17T07:34:25.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"},"commit":{"message":"With sql_variant columns, ensure the base type is preserved","shortMessageHtmlLink":"With sql_variant columns, ensure the base type is preserved"}},{"before":"51bf2be3cc7cfb0c294faa3c4b4db764e54e7066","after":"099156f0085597d9628b663ab6af88b1a5920a2d","ref":"refs/heads/support_variant_datatype_columns","pushedAt":"2023-10-17T06:12:50.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"},"commit":{"message":"Refactor: Reduce the number of uses of COALESCE","shortMessageHtmlLink":"Refactor: Reduce the number of uses of COALESCE"}},{"before":"dfa6eeb7c5b603afca834ca3a26a8daf38d25d8f","after":"51bf2be3cc7cfb0c294faa3c4b4db764e54e7066","ref":"refs/heads/support_variant_datatype_columns","pushedAt":"2023-10-14T09:32:34.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"},"commit":{"message":"Fix #78: Support sql_variant data type columns","shortMessageHtmlLink":"Fix #78: Support sql_variant data type columns"}},{"before":"d005fb80b34f22fb8ee20bd4001061e3e1a6b62d","after":null,"ref":"refs/heads/support_image_datatype_columns","pushedAt":"2023-10-14T09:31:52.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"}},{"before":"1ee0e2c97e332fa4c5f9afd1ca8afb752375308f","after":"36ec67d76feb3c41ceec5b8f6cd9c42375c7666e","ref":"refs/heads/master","pushedAt":"2023-10-14T09:31:51.000Z","pushType":"pr_merge","commitsCount":3,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"},"commit":{"message":"Merge pull request #103 from dnlnln/support_image_datatype_columns\n\nImage data type support","shortMessageHtmlLink":"Merge pull request #103 from dnlnln/support_image_datatype_columns"}},{"before":null,"after":"dfa6eeb7c5b603afca834ca3a26a8daf38d25d8f","ref":"refs/heads/support_variant_datatype_columns","pushedAt":"2023-10-14T09:30:15.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"},"commit":{"message":"Fix #78: Support sql_variant data type columns","shortMessageHtmlLink":"Fix #78: Support sql_variant data type columns"}},{"before":null,"after":"d005fb80b34f22fb8ee20bd4001061e3e1a6b62d","ref":"refs/heads/support_image_datatype_columns","pushedAt":"2023-10-14T08:24:06.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"dnlnln","name":"Daniel Nolan","path":"/dnlnln","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2928446?s=80&v=4"},"commit":{"message":"Obsolete the @include_timestamp column","shortMessageHtmlLink":"Obsolete the @include_timestamp column"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEQhVY-wA","startCursor":null,"endCursor":null}},"title":"Activity · dnlnln/generate-sql-merge"}