trinodb/trino

Test SQL Server handling of decimal type with negative scale

Open

#28418 opened on Feb 23, 2026

View on GitHub
 (8 comments) (0 reactions) (0 assignees)Java (9,113 stars) (2,678 forks)batch import
good first issuesqlserver

Description

The connector claims support for decimal with negative scale

https://github.com/trinodb/trino/blob/ec36302a2f1f9e256b4512213034ab2aa38dda8a/plugin/trino-sqlserver/src/main/java/io/trino/plugin/sqlserver/SqlServerClient.java#L635-L636

it's not tested and may not work

Contributor guide

Tech stack
javasql
Domain
databasetestingbackend
Issue type
test
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
half day
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
fresh
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
clear
Prerequisites
JavaSQLbasic testing
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
60
Research direction
Investigate the existing test suite for the SQL Server connector in the plugin/trino sqlserver directory. Review the linked PR #28414 to understand the current implementation. Write a test that verifies reading and writing decimal columns with negative scale from SQL Server. Ensure the test covers both positive and negative scale values. Check the comments in the issue for any additional edge cases mentioned.