MYSQL - 8.0.13 - Values on VIEW_DEFINITION column, from information_schema.VIEWS, only displayed to view...
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I tried to get values for all views created using this sentence:
select * from information_schema.views;
but, in spite of being root, only views created by the user running previous command, are filled with values in VIEW_DEFINITION column. Rest of columns are complety filled in all cases.
Looking for information I have found this link about a bug: BUG MYSQL 39733.
Not sure if it is the expected behaviour or it is still a bug in this MySQL version (8.0.13)
In MySQL version 5.7.9 it worked fine.
I know there is a workaround: show create view testView; but I'm interesting in first command to avoid modify the code of a program using MySQL 5.7.9.
mysql
edited Jan 4 at 12:04
wchiquito
12.1k22335
asked Jan 4 at 11:53
jveirasvjveirasv
13114
add a comment |
I tried to get values for all views created using this sentence:
select * from information_schema.views;
but, in spite of being root, only views created by the user running previous command, are filled with values in VIEW_DEFINITION column. Rest of columns are complety filled in all cases.
Looking for information I have found this link about a bug: BUG MYSQL 39733.
Not sure if it is the expected behaviour or it is still a bug in this MySQL version (8.0.13)
In MySQL version 5.7.9 it worked fine.
I know there is a workaround: show create view testView; but I'm interesting in first command to avoid modify the code of a program using MySQL 5.7.9.
mysql
edited Jan 4 at 12:04
wchiquito
12.1k22335
asked Jan 4 at 11:53
jveirasvjveirasv
13114
add a comment |
I tried to get values for all views created using this sentence:
select * from information_schema.views;
but, in spite of being root, only views created by the user running previous command, are filled with values in VIEW_DEFINITION column. Rest of columns are complety filled in all cases.
Looking for information I have found this link about a bug: BUG MYSQL 39733.
Not sure if it is the expected behaviour or it is still a bug in this MySQL version (8.0.13)
In MySQL version 5.7.9 it worked fine.
I know there is a workaround: show create view testView; but I'm interesting in first command to avoid modify the code of a program using MySQL 5.7.9.
mysql
edited Jan 4 at 12:04
wchiquito
12.1k22335
asked Jan 4 at 11:53
jveirasvjveirasv
13114
I tried to get values for all views created using this sentence:
select * from information_schema.views;
but, in spite of being root, only views created by the user running previous command, are filled with values in VIEW_DEFINITION column. Rest of columns are complety filled in all cases.
Looking for information I have found this link about a bug: BUG MYSQL 39733.
Not sure if it is the expected behaviour or it is still a bug in this MySQL version (8.0.13)
In MySQL version 5.7.9 it worked fine.
I know there is a workaround: show create view testView; but I'm interesting in first command to avoid modify the code of a program using MySQL 5.7.9.
mysql
mysql
edited Jan 4 at 12:04
wchiquito
12.1k22335
asked Jan 4 at 11:53
jveirasvjveirasv
13114
edited Jan 4 at 12:04
wchiquito
12.1k22335
asked Jan 4 at 11:53
jveirasvjveirasv
13114
edited Jan 4 at 12:04
wchiquito
12.1k22335
edited Jan 4 at 12:04
wchiquito
12.1k22335
edited Jan 4 at 12:04
wchiquito
12.1k22335
12.1k22335
asked Jan 4 at 11:53
jveirasvjveirasv
13114
asked Jan 4 at 11:53
jveirasvjveirasv
13114
asked Jan 4 at 11:53
jveirasvjveirasv
13114
13114
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
It is a MySQL version bug I think. Update your mysql.
answered Jan 4 at 12:00
AlmazAlmaz
449
Thanks, but 8.0.13 is the last available: MySQL Community Server (GPL) (Current Generally Available Release: 8.0.13)
– jveirasv
Jan 4 at 12:26
My suggestion is re-assign the root user by flushing all the privileges. Also check this linkhttps://stackoverflow.com/questions/53784296/mysql-server-is-not-starting?noredirect=1#comment94420587_53784296
– Almaz
Jan 5 at 3:26
i like your idea because only one user is using that feature. This workaround will work until a new MySQL version will be delivered without this bug. Thanks!
– jveirasv
Jan 5 at 7:43
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54038489%2fmysql-8-0-13-values-on-view-definition-column-from-information-schema-views%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
It is a MySQL version bug I think. Update your mysql.
answered Jan 4 at 12:00
AlmazAlmaz
449
Thanks, but 8.0.13 is the last available: MySQL Community Server (GPL) (Current Generally Available Release: 8.0.13)
– jveirasv
Jan 4 at 12:26
My suggestion is re-assign the root user by flushing all the privileges. Also check this linkhttps://stackoverflow.com/questions/53784296/mysql-server-is-not-starting?noredirect=1#comment94420587_53784296
– Almaz
Jan 5 at 3:26
i like your idea because only one user is using that feature. This workaround will work until a new MySQL version will be delivered without this bug. Thanks!
– jveirasv
Jan 5 at 7:43
add a comment |
It is a MySQL version bug I think. Update your mysql.
answered Jan 4 at 12:00
AlmazAlmaz
449
Thanks, but 8.0.13 is the last available: MySQL Community Server (GPL) (Current Generally Available Release: 8.0.13)
– jveirasv
Jan 4 at 12:26
My suggestion is re-assign the root user by flushing all the privileges. Also check this linkhttps://stackoverflow.com/questions/53784296/mysql-server-is-not-starting?noredirect=1#comment94420587_53784296
– Almaz
Jan 5 at 3:26
i like your idea because only one user is using that feature. This workaround will work until a new MySQL version will be delivered without this bug. Thanks!
– jveirasv
Jan 5 at 7:43
add a comment |
It is a MySQL version bug I think. Update your mysql.
answered Jan 4 at 12:00
AlmazAlmaz
449
It is a MySQL version bug I think. Update your mysql.
answered Jan 4 at 12:00
AlmazAlmaz
449
answered Jan 4 at 12:00
AlmazAlmaz
449
answered Jan 4 at 12:00
AlmazAlmaz
449
answered Jan 4 at 12:00
AlmazAlmaz
449
449
Thanks, but 8.0.13 is the last available: MySQL Community Server (GPL) (Current Generally Available Release: 8.0.13)
– jveirasv
Jan 4 at 12:26
My suggestion is re-assign the root user by flushing all the privileges. Also check this linkhttps://stackoverflow.com/questions/53784296/mysql-server-is-not-starting?noredirect=1#comment94420587_53784296
– Almaz
Jan 5 at 3:26
i like your idea because only one user is using that feature. This workaround will work until a new MySQL version will be delivered without this bug. Thanks!
– jveirasv
Jan 5 at 7:43
add a comment |
Thanks, but 8.0.13 is the last available: MySQL Community Server (GPL) (Current Generally Available Release: 8.0.13)
– jveirasv
Jan 4 at 12:26
My suggestion is re-assign the root user by flushing all the privileges. Also check this linkhttps://stackoverflow.com/questions/53784296/mysql-server-is-not-starting?noredirect=1#comment94420587_53784296
– Almaz
Jan 5 at 3:26
i like your idea because only one user is using that feature. This workaround will work until a new MySQL version will be delivered without this bug. Thanks!
– jveirasv
Jan 5 at 7:43
Thanks, but 8.0.13 is the last available: MySQL Community Server (GPL) (Current Generally Available Release: 8.0.13)
– jveirasv
Jan 4 at 12:26
Thanks, but 8.0.13 is the last available: MySQL Community Server (GPL) (Current Generally Available Release: 8.0.13)
– jveirasv
Jan 4 at 12:26
My suggestion is re-assign the root user by flushing all the privileges. Also check this link
https://stackoverflow.com/questions/53784296/mysql-server-is-not-starting?noredirect=1#comment94420587_53784296– Almaz
Jan 5 at 3:26
My suggestion is re-assign the root user by flushing all the privileges. Also check this link
https://stackoverflow.com/questions/53784296/mysql-server-is-not-starting?noredirect=1#comment94420587_53784296– Almaz
Jan 5 at 3:26
i like your idea because only one user is using that feature. This workaround will work until a new MySQL version will be delivered without this bug. Thanks!
– jveirasv
Jan 5 at 7:43
i like your idea because only one user is using that feature. This workaround will work until a new MySQL version will be delivered without this bug. Thanks!
– jveirasv
Jan 5 at 7:43
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54038489%2fmysql-8-0-13-values-on-view-definition-column-from-information-schema-views%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
