- Notifications
You must be signed in to change notification settings - Fork923
chore: release cherry-picks for 2.18.0#15719
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to ourterms of service andprivacy statement. We’ll occasionally send you account related emails.
Already on GitHub?Sign in to your account
Uh oh!
There was an error while loading.Please reload this page.
Changes fromall commits
12c4bb5
bf74f8b
54f7605
b359fb9
1d789ce
File filter
Filter by extension
Conversations
Uh oh!
There was an error while loading.Please reload this page.
Jump to
Uh oh!
There was an error while loading.Please reload this page.
Diff view
Diff view
There are no files selected for viewing
Some generated files are not rendered by default. Learn more abouthow customized files appear on GitHub.
Uh oh!
There was an error while loading.Please reload this page.
Some generated files are not rendered by default. Learn more abouthow customized files appear on GitHub.
Uh oh!
There was an error while loading.Please reload this page.
Some generated files are not rendered by default. Learn more abouthow customized files appear on GitHub.
Uh oh!
There was an error while loading.Please reload this page.
Original file line number | Diff line number | Diff line change |
---|---|---|
@@ -0,0 +1,28 @@ | ||
-- We cannot alter the column type while a view depends on it, so we drop it and recreate it. | ||
DROP VIEW template_version_with_user; | ||
ALTER TABLE | ||
template_versions | ||
DROP COLUMN source_example_id; | ||
-- Recreate `template_version_with_user` as described in dump.sql | ||
CREATE VIEW template_version_with_user AS | ||
SELECT | ||
template_versions.id, | ||
template_versions.template_id, | ||
template_versions.organization_id, | ||
template_versions.created_at, | ||
template_versions.updated_at, | ||
template_versions.name, | ||
template_versions.readme, | ||
template_versions.job_id, | ||
template_versions.created_by, | ||
template_versions.external_auth_providers, | ||
template_versions.message, | ||
template_versions.archived, | ||
COALESCE(visible_users.avatar_url, ''::text) AS created_by_avatar_url, | ||
COALESCE(visible_users.username, ''::text) AS created_by_username | ||
FROM (template_versions | ||
LEFT JOIN visible_users ON (template_versions.created_by = visible_users.id)); | ||
COMMENT ON VIEW template_version_with_user IS 'Joins in the username + avatar url of the created by user.'; |
Original file line number | Diff line number | Diff line change |
---|---|---|
@@ -0,0 +1,30 @@ | ||
-- We cannot alter the column type while a view depends on it, so we drop it and recreate it. | ||
DROP VIEW template_version_with_user; | ||
ALTER TABLE | ||
template_versions | ||
ADD | ||
COLUMN source_example_id TEXT; | ||
-- Recreate `template_version_with_user` as described in dump.sql | ||
CREATE VIEW template_version_with_user AS | ||
SELECT | ||
template_versions.id, | ||
template_versions.template_id, | ||
template_versions.organization_id, | ||
template_versions.created_at, | ||
template_versions.updated_at, | ||
template_versions.name, | ||
template_versions.readme, | ||
template_versions.job_id, | ||
template_versions.created_by, | ||
template_versions.external_auth_providers, | ||
template_versions.message, | ||
template_versions.archived, | ||
template_versions.source_example_id, | ||
COALESCE(visible_users.avatar_url, ''::text) AS created_by_avatar_url, | ||
COALESCE(visible_users.username, ''::text) AS created_by_username | ||
FROM (template_versions | ||
LEFT JOIN visible_users ON (template_versions.created_by = visible_users.id)); | ||
COMMENT ON VIEW template_version_with_user IS 'Joins in the username + avatar url of the created by user.'; |
Some generated files are not rendered by default. Learn more abouthow customized files appear on GitHub.
Uh oh!
There was an error while loading.Please reload this page.
Some generated files are not rendered by default. Learn more abouthow customized files appear on GitHub.
Uh oh!
There was an error while loading.Please reload this page.
Uh oh!
There was an error while loading.Please reload this page.
Uh oh!
There was an error while loading.Please reload this page.