1 files changed, 20 insertions, 0 deletions
diff --git a/tests/data/parser/parseCreateTable7.in b/tests/data/parser/parseCreateTable7.in
new file mode 100644
index 0000000..2f80ff7
--- /dev/null
+++ b/tests/data/parser/parseCreateTable7.in
@@ -0,0 +1,20 @@
+CREATE TABLE `ts` (
+  `id` int(11) DEFAULT NULL,
+  `purchased` date DEFAULT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
+PARTITION BY RANGE (YEAR(purchased))
+SUBPARTITION BY HASH (TO_DAYS(purchased))
+(
+PARTITION p0 VALUES LESS THAN (1990)  (
+SUBPARTITION s0 ENGINE=InnoDB,
+SUBPARTITION s1 ENGINE=InnoDB
+),
+PARTITION p1 VALUES LESS THAN (2000)  (
+SUBPARTITION s2 ENGINE=InnoDB,
+SUBPARTITION s3 ENGINE=InnoDB
+),
+PARTITION p2 VALUES LESS THAN MAXVALUE  (
+SUBPARTITION s4 ENGINE=InnoDB,
+SUBPARTITION s5 ENGINE=InnoDB
+)
+);