Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | Tools - ER Modeler |
| Version | 13.0 |
1.) Convert the attached ER Model from SQl Server to Vertica. For the data types below
xml gets converted to varbinary(2147483647)
2.) For Vertica Datatypes, the range for varbinary and varchar is 1 to 65000
3.) So when i try to create the table in vertica the sql fails with the error
>[Error] Script lines: 1-44 -------------------------
[Vertica][VJDBC](3852) ERROR: Length for type varbinary cannot exceed 65000
|
716 B
In the current ADS implementation, conversion is performed by source-db based on its own limitation, not dest-db's limitation. If you apply the same test case to 'SQL Server -> Vertica', you likely will get the same problem because SQL Server converts 'text' to 'varchar(2GB)', 'xml' to 'varbinary(2GB)' and 'image' to 'varbinary(2GB)'.
References:
http://www.postgresql.org/docs/8.2/static/datatype-character.html
http://www.postgresql.org/docs/8.2/static/datatype-binary.html
This problem does not seem to be a bug to me based on current ADS approach.
Issue #8154 |
| Closed |
| Won't Fix |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
In the current ADS implementation, conversion is performed by source-db based on its own limitation, not dest-db's limitation. If you apply the same test case to 'SQL Server -> Vertica', you likely will get the same problem because SQL Server converts 'text' to 'varchar(2GB)', 'xml' to 'varbinary(2GB)' and 'image' to 'varbinary(2GB)'.
References:
http://www.postgresql.org/docs/8.2/static/datatype-character.html
http://www.postgresql.org/docs/8.2/static/datatype-binary.html
This problem does not seem to be a bug to me based on current ADS approach.