[
https://issues.apache.org/jira/browse/CAY-2962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andrus Adamchik closed CAY-2962.
--------------------------------
Resolution: Fixed
> Allow unconstrained VARCHAR
> ---------------------------
>
> Key: CAY-2962
> URL: https://issues.apache.org/jira/browse/CAY-2962
> Project: Cayenne
> Issue Type: Task
> Reporter: Andrus Adamchik
> Assignee: Andrus Adamchik
> Priority: Minor
> Fix For: 5.0-M3
>
>
> PostgreSQL "text" is an unconstrained VARCHAR. Cayenne doesn't like it very
> much. Reverse engineering sets the max length to 2147483647, and the absence
> of max length causes validation warning.
> 1. Let's handle this specific case on PostgreSQL by setting max length to -1
> (unknown)
> 2. No longer warn about VARCHAR without max length
> 3. When generating DDL SQL for PG use "text" type for an unconstrained VARCHAR
> 4. When generating DDL SQL for MySQL use "longtext" type for an unconstrained
> VARCHAR
> 5. When generating DDL SQL for H2 and HSQLDB, use unconstrained VARCHAR
> 6. For other databases, come up with a per-DB default length number supported
> by their VARCHAR analog
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
