I tried to update the quote table customer_note column type to text using setup script and schema patch. Column type updated after run setup:upgrade but when I run setup:upgrade the second time then column type revert to varchar as previously. This issue because Magento creates a quote table using declarative schema. How I can extend that db_schema.xml file in my custom module to change customer_note column type to text.
I review this link Magento2.3 – How to set text column table value default is None using declarative schema? and follow steps but I got Invalid Document Element 'column', attribute 'length': The attribute 'length' is not allowed. Error while run setup:upgrade command
I face above error because of in Magento quote module db_schema.xml file has this customer_note definition and it’s has type varchar and length element. If remove length from that definition line then code working without any error.
