src/test/resources/org/embulk/input/oracle/test/expect/basic/setup.sql in embulk-input-oracle-0.8.1 vs src/test/resources/org/embulk/input/oracle/test/expect/basic/setup.sql in embulk-input-oracle-0.8.2
- old
+ new
@@ -29,6 +29,18 @@
'ABCDEFGH',
TO_DATE('2015-06-04', 'YYYY-MM-DD'),
TO_TIMESTAMP('2015-06-05 23:45:06', 'YYYY-MM-DD HH24:MI:SS'),
TO_TIMESTAMP('2015-06-06 23:45:06.789', 'YYYY-MM-DD HH24:MI:SS.FF3'));
+DROP TABLE TEST2;
+
+CREATE TABLE TEST2 (
+ ID CHAR(2),
+ C1 BINARY_DOUBLE,
+ C2 BINARY_FLOAT,
+ PRIMARY KEY (ID));
+
+INSERT INTO TEST2 VALUES('10', NULL, NULL);
+INSERT INTO TEST2 VALUES('11', 123456789.012345, 123.4567);
+INSERT INTO TEST2 VALUES('12', -123456789.012345, -123.4567);
+
EXIT;