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?
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---
