docs: update JDBC type mapping tables for V2#89
Open
mintlify[bot] wants to merge 1 commit into
Open
Conversation
3 tasks
Contributor
Author
|
Preview deployment for your docs. Learn more about Mintlify Previews.
|
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Add this suggestion to a batch that can be applied as a single commit.This suggestion is invalid because no changes were made to the code.Suggestions cannot be applied while the pull request is closed.Suggestions cannot be applied while viewing a subset of changes.Only one suggestion per line can be applied in a batch.Add this suggestion to a batch that can be applied as a single commit.Applying suggestions on deleted lines is not supported.You must change the existing code in this line in order to create a valid suggestion.Outdated suggestions cannot be applied.This suggestion has been applied or marked resolved.Suggestions cannot be applied from pending reviews.Suggestions cannot be applied on multi-line comments.Suggestions cannot be applied while the pull request is queued to merge.Suggestion cannot be applied right now. Please check back later.
Summary
Ports ClickHouse/clickhouse-docs#6297 — updates JDBC type mapping documentation for V2.
Changes
TINYINT (-6),NUMERIC (2)) to all V2 type-mapping tables (Numeric, String, Enum, Date/Time, Nested).Int128/256andUInt64/128/256→NUMERIC;UInt8/16/32→SMALLINT/INTEGER/BIGINT;Float32→FLOAT;Enum8/16→VARCHAR.Array.getBaseTypeName()/getBaseType()and the V1 vs V2 differences, with a comprehensive example table.Float32REAL→FLOAT,DateTime/DateTime64V1 column nowTIMESTAMP_WITH_TIMEZONE.Note
Low Risk
Documentation-only changes to JDBC type mapping tables; no runtime or security impact.
Overview
Updates the Java JDBC reference in
jdbc.mdxso V2 type mapping matches current driver behavior and is easier to use fromResultSetMetaData/ArrayAPIs.JDBC type mapping tables now include standard
java.sql.Typescodes (e.g.NUMERIC (2),VARCHAR (12)) alongside type names. Several V2 mappings are corrected vs the old doc: wide integers and large unsigned types use NUMERIC instead of OTHER; UInt8/16/32 map to SMALLINT/INTEGER/BIGINT; Float32 is FLOAT; Enum8/16 are VARCHAR; nested types list explicit ARRAY/JAVA_OBJECT codes.A new Array Element Type Metadata section documents
Array.getBaseTypeName()andArray.getBaseType()for V2, including nested/wrapper types (Nullable,LowCardinality, tuples, enums) and notes that V2 keeps full ClickHouse type strings where V1 strips them.The V1↔V2 migration tables are aligned with the same JDBC labels (unsigned numeric JDBC types, FLOAT for Float32 on both sides, and V1 DateTime/DateTime64 documented as TIMESTAMP_WITH_TIMEZONE vs V2 TIMESTAMP).
Reviewed by Cursor Bugbot for commit d65fb60. Bugbot is set up for automated code reviews on this repo. Configure here.