[ 
https://issues.apache.org/jira/browse/DERBY-6825?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Rick Hillegas updated DERBY-6825:
---------------------------------
    Attachment: derby-6825-03-aa-datatypeTests.diff

Attaching derby-6825-03-aa-datatypeTests.diff. This patch adds tests for all of 
the JSON datatypes supported by the SimpleJsonVTI.

In addition, this patch closes InputStreams opened by the readArrayFromFile() 
and readArrayFromURL() functions. Hopefully this will fix errors which we are 
seeing when SimpleJsonTest runs on Windows platforms. On those platforms we see 
errors under SupportFilesSetup. That's because the test machinery can't delete 
the files which are read by SimpleJsonVTI.

Touches the following files:

-------------------------

M       java/optional/org/apache/derby/optional/api/SimpleJsonUtils.java

Close InputStreams which are read by SimpleJsonVTI.

-------------------------

A       java/testing/org/apache/derbyTesting/functionTests/tests/lang/json.dat
M       
java/testing/org/apache/derbyTesting/functionTests/tests/lang/SimpleJsonTest.java

New datatype tests.


> Add basic JSON support to Derby.
> --------------------------------
>
>                 Key: DERBY-6825
>                 URL: https://issues.apache.org/jira/browse/DERBY-6825
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 10.12.0.0
>            Reporter: Rick Hillegas
>            Assignee: Rick Hillegas
>         Attachments: SimpleJsonVTI.java, derby-6825-01-aa-optionalTool.diff, 
> derby-6825-01-ab-optionalTool.diff, derby-6825-02-aa-vti.diff, 
> derby-6825-03-aa-datatypeTests.diff
>
>
> Other database are adding support for the popular JSON data interchange 
> format defined by https://www.ietf.org/rfc/rfc4627.txt. We could add a VTI to 
> Derby which would unpack a JSON document into a set of rows. We could also 
> add a reverse transformation, which turns a query result into a JSON document.



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

Reply via email to