{"action":"created","comment":{"url":"https://api.github.com/repos/apache/incubator-trafodion/pulls/comments/70833180","id":70833180,"diff_hunk":"@@ -47,8 +47,17 @@ short CmpSeabaseDDL::createRepos(ExeCliInterface * cliInterface)\n \n   NABoolean xnWasStartedHere = FALSE;\n \n+  cliRC = cliInterface->holdAndSetCQD\n+    (\"TRAF_MAX_CHARACTER_COL_LENGTH\", \"1000000\");\n+","path":"core/sql/sqlcomp/CmpSeabaseDDLrepos.cpp","position":6,"original_position":6,"commit_id":"301e22b367d81c6fdbe0e69a3bfba6b92555b6b7","original_commit_id":"301e22b367d81c6fdbe0e69a3bfba6b92555b6b7","user":{"login":"robertamarton","id":13022496,"avatar_url":"https://avatars.githubusercontent.com/u/13022496?v=3","gravatar_id":"","url":"https://api.github.com/users/robertamarton","html_url":"https://github.com/robertamarton","followers_url":"https://api.github.com/users/robertamarton/followers","following_url":"https://api.github.com/users/robertamarton/following{/other_user}","gists_url":"https://api.github.com/users/robertamarton/gists{/gist_id}","starred_url":"https://api.github.com/users/robertamarton/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/robertamarton/subscriptions","organizations_url":"https://api.github.com/users/robertamarton/orgs","repos_url":"https://api.github.com/users/robertamarton/repos","events_url":"https://api.github.com/users/robertamarton/events{/privacy}","received_events_url":"https://api.github.com/users/robertamarton/received_events","type":"User","site_admin":false},"body":"Why was 1000000 chosen?","created_at":"2016-07-14T16:03:28Z","updated_at":"2016-07-14T16:03:28Z","html_url":"https://github.com/apache/incubator-trafodion/pull/565#discussion_r70833180","pull_request_url":"https://api.github.com/repos/apache/incubator-trafodion/pulls/565","_links":{"self":{"href":"https://api.github.com/repos/apache/incubator-trafodion/pulls/comments/70833180"},"html":{"href":"https://github.com/apache/incubator-trafodion/pull/565#discussion_r70833180"},"pull_request":{"href":"https://api.github.com/repos/apache/incubator-trafodion/pulls/565"}}},"pull_request":{"url":"https://api.github.com/repos/apache/incubator-trafodion/pulls/565","id":75680105,"html_url":"https://github.com/apache/incubator-trafodion/pull/565","diff_url":"https://github.com/apache/incubator-trafodion/pull/565.diff","patch_url":"https://github.com/apache/incubator-trafodion/pull/565.patch","issue_url":"https://api.github.com/repos/apache/incubator-trafodion/issues/565","number":565,"state":"open","locked":false,"title":"[TRAFODION-2037] Improve DDL concurrency + repository and metadata upgrades","user":{"login":"DaveBirdsall","id":5659628,"avatar_url":"https://avatars.githubusercontent.com/u/5659628?v=3","gravatar_id":"","url":"https://api.github.com/users/DaveBirdsall","html_url":"https://github.com/DaveBirdsall","followers_url":"https://api.github.com/users/DaveBirdsall/followers","following_url":"https://api.github.com/users/DaveBirdsall/following{/other_user}","gists_url":"https://api.github.com/users/DaveBirdsall/gists{/gist_id}","starred_url":"https://api.github.com/users/DaveBirdsall/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DaveBirdsall/subscriptions","organizations_url":"https://api.github.com/users/DaveBirdsall/orgs","repos_url":"https://api.github.com/users/DaveBirdsall/repos","events_url":"https://api.github.com/users/DaveBirdsall/events{/privacy}","received_events_url":"https://api.github.com/users/DaveBirdsall/received_events","type":"User","site_admin":false},"body":"This change includes all the planned metadata changes for Trafodion release 2.1. The following changes are included:\r\n\r\n1. Fix for JIRA TRAFODION-2037: This adds a new index, TABLE_CONSTRAINTS_IDX, to the metadata TABLE_CONSTRAINTS table, along with a CONTROL QUERY SHAPE in one of the metadata code paths to force its use. This change improves DDL concurrency.\r\n\r\n2. A FLAGS column (LARGEINT) for future use has been added to the DEFAULTS, ROUTINES, LIBRARIES and LIBRARY_USAGES metadata tables. For now, the value of this column will always be zero. On upgrade of existing metadata, these columns are set to zero.\r\n\r\n3. The repository tables have been upgraded. On upgrade of existing metadata, new columns are set to NULL. Specifically:\r\na. The following columns added to “_REPOS_”.METRIC_QUERY_AGGR_TABLE table:\r\nAVERAGE_RESPONSE_TIME  (LARGEINT) and THROUGHPUT_PER_SECOND (LARGEINT)\r\nb. The following columns added to “_REPOS_”.METRIC_QUERY_TABLE table:\r\nQUERY_SIGNATURE_ID (CHAR(160) CHARACTER SET ISO88591) and LAST_UPDATED_TIME                (TIMESTAMP(6))\r\nc. The length of the EXPLAIN_PLAN column in METRIC_QUERY_TABLE was changed from 200000 to 1000000.\r\nd. The following columns added to “_REPOS_”.METRIC_SESSION_TABLE table:\r\nPROFILE_NAME (VARCHAR(130 CHARS) CHARACTER SET UTF8) and SLA_NAME                         (VARCHAR(130 CHARS) CHARACTER SET UTF8).\r\n\r\nThe version of the metadata changes from 1.0.1 to 2.1.0 with this change.\r\n\r\nWhen you include this patch in your Trafodion 2.1 development instance, if you have existing metadata you will find that any SQL operation will fail with error 1395, which asks you to upgrade your metadata. You may find it useful to perform a backup of your instance before including this patch.\r\n\r\nTo upgrade your metadata, perform the command \"initialize trafodion, upgrade\" in a fresh sqlci session. After successful completion, exit that session, and start a new one. It would be helpful if you could forward any experiences you have with this procedure to the Trafodion dev list or to file JIRAs if the experience was negative.\r\n\r\nUsers of older releases of Trafodion will need to perform these same steps when installing Trafodion 2.1.","created_at":"2016-06-29T16:30:21Z","updated_at":"2016-07-14T16:03:28Z","closed_at":null,"merged_at":null,"merge_commit_sha":"5b5b4888d006691478448335095b5ac93cb34b7b","assignee":null,"assignees":[],"milestone":null,"commits_url":"https://api.github.com/repos/apache/incubator-trafodion/pulls/565/commits","review_comments_url":"https://api.github.com/repos/apache/incubator-trafodion/pulls/565/comments","review_comment_url":"https://api.github.com/repos/apache/incubator-trafodion/pulls/comments{/number}","comments_url":"https://api.github.com/repos/apache/incubator-trafodion/issues/565/comments","statuses_url":"https://api.github.com/repos/apache/incubator-trafodion/statuses/301e22b367d81c6fdbe0e69a3bfba6b92555b6b7","head":{"label":"DaveBirdsall:Trafodion2037","ref":"Trafodion2037","sha":"301e22b367d81c6fdbe0e69a3bfba6b92555b6b7","user":{"login":"DaveBirdsall","id":5659628,"avatar_url":"https://avatars.githubusercontent.com/u/5659628?v=3","gravatar_id":"","url":"https://api.github.com/users/DaveBirdsall","html_url":"https://github.com/DaveBirdsall","followers_url":"https://api.github.com/users/DaveBirdsall/followers","following_url":"https://api.github.com/users/DaveBirdsall/following{/other_user}","gists_url":"https://api.github.com/users/DaveBirdsall/gists{/gist_id}","starred_url":"https://api.github.com/users/DaveBirdsall/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DaveBirdsall/subscriptions","organizations_url":"https://api.github.com/users/DaveBirdsall/orgs","repos_url":"https://api.github.com/users/DaveBirdsall/repos","events_url":"https://api.github.com/users/DaveBirdsall/events{/privacy}","received_events_url":"https://api.github.com/users/DaveBirdsall/received_events","type":"User","site_admin":false},"repo":{"id":38782828,"name":"incubator-trafodion","full_name":"DaveBirdsall/incubator-trafodion","owner":{"login":"DaveBirdsall","id":5659628,"avatar_url":"https://avatars.githubusercontent.com/u/5659628?v=3","gravatar_id":"","url":"https://api.github.com/users/DaveBirdsall","html_url":"https://github.com/DaveBirdsall","followers_url":"https://api.github.com/users/DaveBirdsall/followers","following_url":"https://api.github.com/users/DaveBirdsall/following{/other_user}","gists_url":"https://api.github.com/users/DaveBirdsall/gists{/gist_id}","starred_url":"https://api.github.com/users/DaveBirdsall/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DaveBirdsall/subscriptions","organizations_url":"https://api.github.com/users/DaveBirdsall/orgs","repos_url":"https://api.github.com/users/DaveBirdsall/repos","events_url":"https://api.github.com/users/DaveBirdsall/events{/privacy}","received_events_url":"https://api.github.com/users/DaveBirdsall/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/DaveBirdsall/incubator-trafodion","description":"Mirror of Apache Trafodion (Incubating)","fork":true,"url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion","forks_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/forks","keys_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/keys{/key_id}","collaborators_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/teams","hooks_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/hooks","issue_events_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/issues/events{/number}","events_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/events","assignees_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/assignees{/user}","branches_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/branches{/branch}","tags_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/tags","blobs_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/git/refs{/sha}","trees_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/git/trees{/sha}","statuses_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/statuses/{sha}","languages_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/languages","stargazers_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/stargazers","contributors_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/contributors","subscribers_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/subscribers","subscription_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/subscription","commits_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/commits{/sha}","git_commits_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/git/commits{/sha}","comments_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/comments{/number}","issue_comment_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/issues/comments{/number}","contents_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/contents/{+path}","compare_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/compare/{base}...{head}","merges_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/merges","archive_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/downloads","issues_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/issues{/number}","pulls_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/pulls{/number}","milestones_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/milestones{/number}","notifications_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/labels{/name}","releases_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/releases{/id}","deployments_url":"https://api.github.com/repos/DaveBirdsall/incubator-trafodion/deployments","created_at":"2015-07-08T22:12:46Z","updated_at":"2015-07-08T22:13:26Z","pushed_at":"2016-07-14T15:11:49Z","git_url":"git://github.com/DaveBirdsall/incubator-trafodion.git","ssh_url":"git@github.com:DaveBirdsall/incubator-trafodion.git","clone_url":"https://github.com/DaveBirdsall/incubator-trafodion.git","svn_url":"https://github.com/DaveBirdsall/incubator-trafodion","homepage":null,"size":71398,"stargazers_count":0,"watchers_count":0,"language":"C++","has_issues":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"apache:master","ref":"master","sha":"ea2087410bcf23ff2800be03ca0fc8592fa0bb48","user":{"login":"apache","id":47359,"avatar_url":"https://avatars.githubusercontent.com/u/47359?v=3","gravatar_id":"","url":"https://api.github.com/users/apache","html_url":"https://github.com/apache","followers_url":"https://api.github.com/users/apache/followers","following_url":"https://api.github.com/users/apache/following{/other_user}","gists_url":"https://api.github.com/users/apache/gists{/gist_id}","starred_url":"https://api.github.com/users/apache/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/apache/subscriptions","organizations_url":"https://api.github.com/users/apache/orgs","repos_url":"https://api.github.com/users/apache/repos","events_url":"https://api.github.com/users/apache/events{/privacy}","received_events_url":"https://api.github.com/users/apache/received_events","type":"Organization","site_admin":false},"repo":{"id":36349344,"name":"incubator-trafodion","full_name":"apache/incubator-trafodion","owner":{"login":"apache","id":47359,"avatar_url":"https://avatars.githubusercontent.com/u/47359?v=3","gravatar_id":"","url":"https://api.github.com/users/apache","html_url":"https://github.com/apache","followers_url":"https://api.github.com/users/apache/followers","following_url":"https://api.github.com/users/apache/following{/other_user}","gists_url":"https://api.github.com/users/apache/gists{/gist_id}","starred_url":"https://api.github.com/users/apache/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/apache/subscriptions","organizations_url":"https://api.github.com/users/apache/orgs","repos_url":"https://api.github.com/users/apache/repos","events_url":"https://api.github.com/users/apache/events{/privacy}","received_events_url":"https://api.github.com/users/apache/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/apache/incubator-trafodion","description":"Mirror of Apache Trafodion (Incubating)","fork":false,"url":"https://api.github.com/repos/apache/incubator-trafodion","forks_url":"https://api.github.com/repos/apache/incubator-trafodion/forks","keys_url":"https://api.github.com/repos/apache/incubator-trafodion/keys{/key_id}","collaborators_url":"https://api.github.com/repos/apache/incubator-trafodion/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/apache/incubator-trafodion/teams","hooks_url":"https://api.github.com/repos/apache/incubator-trafodion/hooks","issue_events_url":"https://api.github.com/repos/apache/incubator-trafodion/issues/events{/number}","events_url":"https://api.github.com/repos/apache/incubator-trafodion/events","assignees_url":"https://api.github.com/repos/apache/incubator-trafodion/assignees{/user}","branches_url":"https://api.github.com/repos/apache/incubator-trafodion/branches{/branch}","tags_url":"https://api.github.com/repos/apache/incubator-trafodion/tags","blobs_url":"https://api.github.com/repos/apache/incubator-trafodion/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/apache/incubator-trafodion/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/apache/incubator-trafodion/git/refs{/sha}","trees_url":"https://api.github.com/repos/apache/incubator-trafodion/git/trees{/sha}","statuses_url":"https://api.github.com/repos/apache/incubator-trafodion/statuses/{sha}","languages_url":"https://api.github.com/repos/apache/incubator-trafodion/languages","stargazers_url":"https://api.github.com/repos/apache/incubator-trafodion/stargazers","contributors_url":"https://api.github.com/repos/apache/incubator-trafodion/contributors","subscribers_url":"https://api.github.com/repos/apache/incubator-trafodion/subscribers","subscription_url":"https://api.github.com/repos/apache/incubator-trafodion/subscription","commits_url":"https://api.github.com/repos/apache/incubator-trafodion/commits{/sha}","git_commits_url":"https://api.github.com/repos/apache/incubator-trafodion/git/commits{/sha}","comments_url":"https://api.github.com/repos/apache/incubator-trafodion/comments{/number}","issue_comment_url":"https://api.github.com/repos/apache/incubator-trafodion/issues/comments{/number}","contents_url":"https://api.github.com/repos/apache/incubator-trafodion/contents/{+path}","compare_url":"https://api.github.com/repos/apache/incubator-trafodion/compare/{base}...{head}","merges_url":"https://api.github.com/repos/apache/incubator-trafodion/merges","archive_url":"https://api.github.com/repos/apache/incubator-trafodion/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/apache/incubator-trafodion/downloads","issues_url":"https://api.github.com/repos/apache/incubator-trafodion/issues{/number}","pulls_url":"https://api.github.com/repos/apache/incubator-trafodion/pulls{/number}","milestones_url":"https://api.github.com/repos/apache/incubator-trafodion/milestones{/number}","notifications_url":"https://api.github.com/repos/apache/incubator-trafodion/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/apache/incubator-trafodion/labels{/name}","releases_url":"https://api.github.com/repos/apache/incubator-trafodion/releases{/id}","deployments_url":"https://api.github.com/repos/apache/incubator-trafodion/deployments","created_at":"2015-05-27T07:00:05Z","updated_at":"2016-07-13T02:22:12Z","pushed_at":"2016-07-14T15:11:49Z","git_url":"git://github.com/apache/incubator-trafodion.git","ssh_url":"git@github.com:apache/incubator-trafodion.git","clone_url":"https://github.com/apache/incubator-trafodion.git","svn_url":"https://github.com/apache/incubator-trafodion","homepage":null,"size":76070,"stargazers_count":56,"watchers_count":56,"language":"C++","has_issues":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":70,"mirror_url":"git://git.apache.org/incubator-trafodion.git","open_issues_count":9,"forks":70,"open_issues":9,"watchers":56,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/apache/incubator-trafodion/pulls/565"},"html":{"href":"https://github.com/apache/incubator-trafodion/pull/565"},"issue":{"href":"https://api.github.com/repos/apache/incubator-trafodion/issues/565"},"comments":{"href":"https://api.github.com/repos/apache/incubator-trafodion/issues/565/comments"},"review_comments":{"href":"https://api.github.com/repos/apache/incubator-trafodion/pulls/565/comments"},"review_comment":{"href":"https://api.github.com/repos/apache/incubator-trafodion/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/apache/incubator-trafodion/pulls/565/commits"},"statuses":{"href":"https://api.github.com/repos/apache/incubator-trafodion/statuses/301e22b367d81c6fdbe0e69a3bfba6b92555b6b7"}}}}
{"actor":{"display_login":"robertamarton"}}