[
https://issues.apache.org/jira/browse/DRILL-3791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14989847#comment-14989847
]
ASF GitHub Bot commented on DRILL-3791:
---------------------------------------
Github user jacques-n commented on a diff in the pull request:
https://github.com/apache/drill/pull/235#discussion_r43903120
--- Diff: contrib/storage-jdbc/src/test/resources/mysql-test-data.sql ---
@@ -0,0 +1,53 @@
+
+set global time_zone = "+00:00";
+
+use drill_mysql_test;
+
+create table person (
+ person_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
+
+ first_name VARCHAR(255),
+ last_name VARCHAR(255),
+ address VARCHAR(255),
+ city VARCHAR(255),
+ state CHAR(2),
+ zip INT,
+
+ json VARCHAR(255),
+
+ bigint_field BIGINT,
+ smallint_field SMALLINT,
+ numeric_field NUMERIC(10, 2),
+ boolean_field BOOLEAN,
+ double_field DOUBLE,
+ float_field FLOAT,
+ real_field REAL,
+
+ time_field TIME,
+ timestamp_field TIMESTAMP,
+ date_field DATE,
+ datetime_field DATETIME
--- End diff --
If I recall correctly, we previously had issues with TEXT, BLOB, CLOB and
BIT columns. Can you add these column types to the tests?
> Test JDBC plugin with MySQL
> ---------------------------
>
> Key: DRILL-3791
> URL: https://issues.apache.org/jira/browse/DRILL-3791
> Project: Apache Drill
> Issue Type: Test
> Components: Storage - Other
> Reporter: Andrew
> Assignee: Andrew
> Priority: Blocker
>
> Testing the new JDBC storage plugin against MySQL.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
