[DRILL-3253] Add test/mock storage plugin providing columns of all data types for testing metadata (etc.)

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: Future
• Component/s: Client - JDBC, Storage - Information Schema, Tools, Build & Test
• Assignee: Unassigned
• Reporter: Daniel Barclay
• Created: 04/Jun/15 18:16
• Updated: 20/Sep/19 13:23

Description

There probably should be a test/dummy/mock storage plugin that provides an easy way to have views and/or tables with columns covering all* supported data types.

(*for appropriate values of "all"--all top-level cases (atomic types (e.g., INTEGER, VARCHAR(...))); some, but obviously not all, subcases (e.g., VARCHAR(1) vs. VARCHAR(2), INTEGER ARRAY vs. INTEGER ARRAY ARRAY)).

This would allow more-complete and/or easier testing of things such as INFORMATION_SCHEMA.COLUMNS and DatabaseMetaData.getColumns(...).

Issue Links

• is related to: DRILL-3151 ResultSetMetaData not as specified by JDBC (null/dummy value, not ""/etc.)
• relates to: DRILL-2480 [umbrella] Identify, fix INFORMATION_SCHEMA and JDBC metadata bugs