GutoVeronezi commented on a change in pull request #6080:
URL: https://github.com/apache/cloudstack/pull/6080#discussion_r832533365
##########
File path: engine/schema/src/main/resources/META-INF/db/schema-41610to41700.sql
##########
@@ -652,3 +652,5 @@ INSERT INTO `cloud`.`user_vm_details`(`vm_id`, `name`,
`value`)
INNER JOIN `cloud`.`vm_instance` ON vm_instance.id =
user_vm_details.vm_id
WHERE ssh_keypairs.account_id = vm_instance.account_id;
+-- PR #6080 Change column `value` size from 255 to 4096 characters, matching
the API "updateConfiguration" "value" size
+ALTER TABLE `cloud`.`account_details` MODIFY `value` VARCHAR(4096);
Review comment:
When calling `MODIFY` command, it removes all the column metadata and
only adds what is specified in the command (in this case, only
`VARCHAR(4096)`). Currently this field is `NOT NULL`, therefore it must be
informed in the command:
```suggestion
ALTER TABLE `cloud`.`account_details` MODIFY `value` VARCHAR(4096) NOT NULL;
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
