[ 
https://issues.apache.org/jira/browse/DRILL-3253?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14632080#comment-14632080
 ] 

Jacques Nadeau commented on DRILL-3253:
---------------------------------------

Please note, there is already a MockStorageEngine.  It sounds like you'd like 
to extend this for SQL purposes.  Alternatively, you could use the VALUES 
operator.  For example:

{code}
SELECT * FROM (VALUES (1, 2), (3, 4), (5, 6), (7, 8), (9, 10) ) AS MyTable(a, 
b);
{code}

> Add test/mock storage plugin providing columns of all data types for testing 
> metadata (etc.)
> --------------------------------------------------------------------------------------------
>
>                 Key: DRILL-3253
>                 URL: https://issues.apache.org/jira/browse/DRILL-3253
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Client - JDBC, Storage - Information Schema, Tools, 
> Build & Test
>            Reporter: Daniel Barclay (Drill)
>            Assignee: Daniel Barclay (Drill)
>             Fix For: 1.2.0
>
>
> 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(...).



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to