add data type to testCat in jdbc_test
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/c1cdc22b Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/c1cdc22b Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/c1cdc22b Branch: refs/heads/master Commit: c1cdc22b2ce1b77f5897cf2beed9b6994c3b786e Parents: 0cf25ec Author: Weixin-Xu <[email protected]> Authored: Wed Jan 10 10:02:37 2018 +0800 Committer: Weixin-Xu <[email protected]> Committed: Wed Jan 10 15:47:54 2018 +0800 ---------------------------------------------------------------------- .../java/org/trafodion/jdbc_test/TestCat.java | 77 +++++++++++--------- 1 file changed, 41 insertions(+), 36 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/trafodion/blob/c1cdc22b/dcs/src/test/jdbc_test/src/test/java/org/trafodion/jdbc_test/TestCat.java ---------------------------------------------------------------------- diff --git a/dcs/src/test/jdbc_test/src/test/java/org/trafodion/jdbc_test/TestCat.java b/dcs/src/test/jdbc_test/src/test/java/org/trafodion/jdbc_test/TestCat.java index 5faee9a..88cc28e 100644 --- a/dcs/src/test/jdbc_test/src/test/java/org/trafodion/jdbc_test/TestCat.java +++ b/dcs/src/test/jdbc_test/src/test/java/org/trafodion/jdbc_test/TestCat.java @@ -470,43 +470,48 @@ public class TestCat { "1: TYPE_NAME - NCHAR VARYING DATA_TYPE - -9 PRECISION - 32000", "2: TYPE_NAME - NCHAR DATA_TYPE - -8 PRECISION - 32000", - "3: TYPE_NAME - BIGINT DATA_TYPE - -5 PRECISION - 19", - "4: TYPE_NAME - BIGINT SIGNED DATA_TYPE - -5 PRECISION - 19", - "5: TYPE_NAME - CHAR DATA_TYPE - 1 PRECISION - 32000", - "6: TYPE_NAME - NUMERIC DATA_TYPE - 2 PRECISION - 128", - "7: TYPE_NAME - NUMERIC SIGNED DATA_TYPE - 2 PRECISION - 128", - "8: TYPE_NAME - NUMERIC UNSIGNED DATA_TYPE - 2 PRECISION - 128", - "9: TYPE_NAME - DECIMAL DATA_TYPE - 3 PRECISION - 18", - "10: TYPE_NAME - DECIMAL SIGNED DATA_TYPE - 3 PRECISION - 18", - "11: TYPE_NAME - DECIMAL UNSIGNED DATA_TYPE - 3 PRECISION - 18", - "12: TYPE_NAME - INTEGER DATA_TYPE - 4 PRECISION - 10", - "13: TYPE_NAME - INTEGER SIGNED DATA_TYPE - 4 PRECISION - 10", - "14: TYPE_NAME - INTEGER UNSIGNED DATA_TYPE - 4 PRECISION - 10", - "15: TYPE_NAME - SMALLINT DATA_TYPE - 5 PRECISION - 5", - "16: TYPE_NAME - SMALLINT SIGNED DATA_TYPE - 5 PRECISION - 5", - "17: TYPE_NAME - SMALLINT UNSIGNED DATA_TYPE - 5 PRECISION - 5", - "18: TYPE_NAME - FLOAT DATA_TYPE - 6 PRECISION - 15", - "19: TYPE_NAME - REAL DATA_TYPE - 7 PRECISION - 7", - "20: TYPE_NAME - DOUBLE PRECISION DATA_TYPE - 8 PRECISION - 15", - "21: TYPE_NAME - VARCHAR DATA_TYPE - 12 PRECISION - 32000", - "22: TYPE_NAME - DATE DATA_TYPE - 91 PRECISION - 10", - "23: TYPE_NAME - TIME DATA_TYPE - 92 PRECISION - 8", - "24: TYPE_NAME - TIMESTAMP DATA_TYPE - 93 PRECISION - 26", - "25: TYPE_NAME - INTERVAL DATA_TYPE - 101 PRECISION - 0", - "26: TYPE_NAME - INTERVAL DATA_TYPE - 102 PRECISION - 0", - "27: TYPE_NAME - INTERVAL DATA_TYPE - 103 PRECISION - 0", - "28: TYPE_NAME - INTERVAL DATA_TYPE - 104 PRECISION - 0", - "29: TYPE_NAME - INTERVAL DATA_TYPE - 105 PRECISION - 0", - "30: TYPE_NAME - INTERVAL DATA_TYPE - 106 PRECISION - 0", - "31: TYPE_NAME - INTERVAL DATA_TYPE - 107 PRECISION - 0", - "32: TYPE_NAME - INTERVAL DATA_TYPE - 108 PRECISION - 0", - "33: TYPE_NAME - INTERVAL DATA_TYPE - 109 PRECISION - 0", - "34: TYPE_NAME - INTERVAL DATA_TYPE - 110 PRECISION - 0", - "35: TYPE_NAME - INTERVAL DATA_TYPE - 111 PRECISION - 0", - "36: TYPE_NAME - INTERVAL DATA_TYPE - 112 PRECISION - 0", - "37: TYPE_NAME - INTERVAL DATA_TYPE - 113 PRECISION - 0" + "3: TYPE_NAME - TINYINT DATA_TYPE - -6 PRECISION - 3", + "4: TYPE_NAME - TINYINT SIGNED DATA_TYPE - -6 PRECISION - 3", + "5: TYPE_NAME - TINYINT UNSIGNED DATA_TYPE - -6 PRECISION - 3", + "6: TYPE_NAME - BIGINT DATA_TYPE - -5 PRECISION - 19", + "7: TYPE_NAME - BIGINT SIGNED DATA_TYPE - -5 PRECISION - 19", + "8: TYPE_NAME - BIGINT UNSIGNED DATA_TYPE - -5 PRECISION - 20", + "9: TYPE_NAME - LONG VARCHAR DATA_TYPE - -1 PRECISION - 2000", + "10: TYPE_NAME - CHAR DATA_TYPE - 1 PRECISION - 32000", + "11: TYPE_NAME - NUMERIC DATA_TYPE - 2 PRECISION - 128", + "12: TYPE_NAME - NUMERIC SIGNED DATA_TYPE - 2 PRECISION - 128", + "13: TYPE_NAME - NUMERIC UNSIGNED DATA_TYPE - 2 PRECISION - 128", + "14: TYPE_NAME - DECIMAL DATA_TYPE - 3 PRECISION - 18", + "15: TYPE_NAME - DECIMAL SIGNED DATA_TYPE - 3 PRECISION - 18", + "16: TYPE_NAME - DECIMAL UNSIGNED DATA_TYPE - 3 PRECISION - 18", + "17: TYPE_NAME - INTEGER DATA_TYPE - 4 PRECISION - 9", + "18: TYPE_NAME - INTEGER SIGNED DATA_TYPE - 4 PRECISION - 9", + "19: TYPE_NAME - INTEGER UNSIGNED DATA_TYPE - 4 PRECISION - 10", + "20: TYPE_NAME - SMALLINT DATA_TYPE - 5 PRECISION - 5", + "21: TYPE_NAME - SMALLINT SIGNED DATA_TYPE - 5 PRECISION - 5", + "22: TYPE_NAME - SMALLINT UNSIGNED DATA_TYPE - 5 PRECISION - 5", + "23: TYPE_NAME - FLOAT DATA_TYPE - 6 PRECISION - 15", + "24: TYPE_NAME - REAL DATA_TYPE - 7 PRECISION - 7", + "25: TYPE_NAME - DOUBLE PRECISION DATA_TYPE - 8 PRECISION - 15", + "26: TYPE_NAME - VARCHAR DATA_TYPE - 12 PRECISION - 32000", + "27: TYPE_NAME - DATE DATA_TYPE - 91 PRECISION - 10", + "28: TYPE_NAME - TIME DATA_TYPE - 92 PRECISION - 8", + "29: TYPE_NAME - TIMESTAMP DATA_TYPE - 93 PRECISION - 26", + "30: TYPE_NAME - INTERVAL DATA_TYPE - 101 PRECISION - 0", + "31: TYPE_NAME - INTERVAL DATA_TYPE - 102 PRECISION - 0", + "32: TYPE_NAME - INTERVAL DATA_TYPE - 103 PRECISION - 0", + "33: TYPE_NAME - INTERVAL DATA_TYPE - 104 PRECISION - 0", + "34: TYPE_NAME - INTERVAL DATA_TYPE - 105 PRECISION - 0", + "35: TYPE_NAME - INTERVAL DATA_TYPE - 106 PRECISION - 0", + "36: TYPE_NAME - INTERVAL DATA_TYPE - 107 PRECISION - 0", + "37: TYPE_NAME - INTERVAL DATA_TYPE - 108 PRECISION - 0", + "38: TYPE_NAME - INTERVAL DATA_TYPE - 109 PRECISION - 0", + "39: TYPE_NAME - INTERVAL DATA_TYPE - 110 PRECISION - 0", + "40: TYPE_NAME - INTERVAL DATA_TYPE - 111 PRECISION - 0", + "41: TYPE_NAME - INTERVAL DATA_TYPE - 112 PRECISION - 0", + "42: TYPE_NAME - INTERVAL DATA_TYPE - 113 PRECISION - 0" }; - int expTypes = 37; + int expTypes = 42; try (
