Skip to content

Comments

v.overlay: preserve SQL type text#6406

Merged
nilason merged 1 commit intoOSGeo:mainfrom
metzm:v.overlay_db_sql_type_text
Sep 28, 2025
Merged

v.overlay: preserve SQL type text#6406
nilason merged 1 commit intoOSGeo:mainfrom
metzm:v.overlay_db_sql_type_text

Conversation

@metzm
Copy link
Contributor

@metzm metzm commented Sep 25, 2025

back then support for SQL type text (unlimited varchar) was added to v.overlay and for reasons of backwards compatibility with dbf, columns of type "text" were converted to type "varchar(250)" which is not the same. The db drivers automatically convert text to varchar if text is not supported.

This should be regarded as a bug because column types should not be changed by modules when copying columns.

@metzm metzm added this to the 8.5.0 milestone Sep 25, 2025
@metzm metzm requested a review from neteler September 25, 2025 16:04
@metzm metzm added bug Something isn't working vector Related to vector data processing C Related code is in C module backport to 8.4 PR needs to be backported to release branch 8.4 labels Sep 25, 2025
Copy link
Member

@wenzeslaus wenzeslaus left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Looks good to me. It seems like we should have a library function for this.

I agree with the current behavior being a bug, although I'm not familiar with the history there. In relation to backport, it does not seem to me that anyone would rely on degradation of the type here, but waiting for a next release may reduce some surprises, so I don't feel strongly either way.

@nilason nilason merged commit 158d98b into OSGeo:main Sep 28, 2025
27 checks passed
neteler pushed a commit that referenced this pull request Oct 2, 2025
@neteler neteler removed the backport to 8.4 PR needs to be backported to release branch 8.4 label Oct 2, 2025
@neteler neteler modified the milestones: 8.5.0, 8.4.2 Oct 2, 2025
@metzm metzm deleted the v.overlay_db_sql_type_text branch October 10, 2025 09:22
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

bug Something isn't working C Related code is in C module vector Related to vector data processing

Projects

None yet

Development

Successfully merging this pull request may close these issues.

4 participants