TAJO-1360: VALUES_ field in OPTIONS table of catalog store should be longer.
Closes #436 Signed-off-by: Jihun Kang <[email protected]> Project: http://git-wip-us.apache.org/repos/asf/tajo/repo Commit: http://git-wip-us.apache.org/repos/asf/tajo/commit/d6735fb9 Tree: http://git-wip-us.apache.org/repos/asf/tajo/tree/d6735fb9 Diff: http://git-wip-us.apache.org/repos/asf/tajo/diff/d6735fb9 Branch: refs/heads/index_support Commit: d6735fb929daf86df3c8adb729a4e64bce95462b Parents: 6e7f1c7 Author: DaeMyung Kang <[email protected]> Authored: Thu Apr 2 16:12:56 2015 +0900 Committer: Jihun Kang <[email protected]> Committed: Thu Apr 2 16:12:56 2015 +0900 ---------------------------------------------------------------------- CHANGES | 3 +++ .../src/main/resources/schemas/derby/derby.xml | 2 +- .../src/main/resources/schemas/mariadb/table_properties.sql | 2 +- .../src/main/resources/schemas/mysql/table_properties.sql | 2 +- .../src/main/resources/schemas/oracle/oracle.xml | 2 +- .../src/main/resources/schemas/postgresql/postgresql.xml | 2 +- 6 files changed, 8 insertions(+), 5 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/tajo/blob/d6735fb9/CHANGES ---------------------------------------------------------------------- diff --git a/CHANGES b/CHANGES index 1ccd016..71c5159 100644 --- a/CHANGES +++ b/CHANGES @@ -52,6 +52,9 @@ Release 0.11.0 - unreleased BUG FIXES + TAJO-1360: VALUES_ field in OPTIONS table of catalog store should be longer. + (Contributed by DaeMyung Kang, Committed by jihun) + TAJO-1479: NPE during startup CatalogStore. (jaehwa) TAJO-1437: Resolve findbug warnings on Tajo JDBC Module. http://git-wip-us.apache.org/repos/asf/tajo/blob/d6735fb9/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/derby/derby.xml ---------------------------------------------------------------------- diff --git a/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/derby/derby.xml b/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/derby/derby.xml index 1e60d15..a239e68 100644 --- a/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/derby/derby.xml +++ b/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/derby/derby.xml @@ -92,7 +92,7 @@ CREATE TABLE OPTIONS ( TID INT NOT NULL REFERENCES TABLES (TID) ON DELETE CASCADE, KEY_ VARCHAR(255) NOT NULL, - VALUE_ VARCHAR(255) NOT NULL, + VALUE_ VARCHAR(4000) NOT NULL, CONSTRAINT C_OPTIONS_UNIQUE UNIQUE (TID, KEY_, VALUE_) )]]> </tns:sql> http://git-wip-us.apache.org/repos/asf/tajo/blob/d6735fb9/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/mariadb/table_properties.sql ---------------------------------------------------------------------- diff --git a/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/mariadb/table_properties.sql b/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/mariadb/table_properties.sql index 7ce5362..b9a84e0 100644 --- a/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/mariadb/table_properties.sql +++ b/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/mariadb/table_properties.sql @@ -1,7 +1,7 @@ CREATE TABLE OPTIONS ( TID INT NOT NULL, KEY_ VARCHAR(255) BINARY NOT NULL, - VALUE_ VARCHAR(255) NOT NULL, + VALUE_ VARCHAR(4000) NOT NULL, PRIMARY KEY (TID, KEY_), FOREIGN KEY (TID) REFERENCES TABLES (TID) ON DELETE CASCADE ) http://git-wip-us.apache.org/repos/asf/tajo/blob/d6735fb9/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/mysql/table_properties.sql ---------------------------------------------------------------------- diff --git a/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/mysql/table_properties.sql b/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/mysql/table_properties.sql index 7ce5362..b9a84e0 100644 --- a/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/mysql/table_properties.sql +++ b/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/mysql/table_properties.sql @@ -1,7 +1,7 @@ CREATE TABLE OPTIONS ( TID INT NOT NULL, KEY_ VARCHAR(255) BINARY NOT NULL, - VALUE_ VARCHAR(255) NOT NULL, + VALUE_ VARCHAR(4000) NOT NULL, PRIMARY KEY (TID, KEY_), FOREIGN KEY (TID) REFERENCES TABLES (TID) ON DELETE CASCADE ) http://git-wip-us.apache.org/repos/asf/tajo/blob/d6735fb9/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/oracle/oracle.xml ---------------------------------------------------------------------- diff --git a/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/oracle/oracle.xml b/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/oracle/oracle.xml index c39f9c8..8c28b97 100644 --- a/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/oracle/oracle.xml +++ b/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/oracle/oracle.xml @@ -135,7 +135,7 @@ CREATE TABLE OPTIONS ( TID INT NOT NULL, KEY_ VARCHAR2(255) NOT NULL, - VALUE_ VARCHAR2(255) NOT NULL, + VALUE_ VARCHAR2(4000) NOT NULL, CONSTRAINT OPTIONS_PKEY PRIMARY KEY (TID, KEY_), FOREIGN KEY (TID) REFERENCES TABLES (TID) ON DELETE CASCADE )]]> http://git-wip-us.apache.org/repos/asf/tajo/blob/d6735fb9/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/postgresql/postgresql.xml ---------------------------------------------------------------------- diff --git a/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/postgresql/postgresql.xml b/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/postgresql/postgresql.xml index b51451b..56bc3a3 100644 --- a/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/postgresql/postgresql.xml +++ b/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/postgresql/postgresql.xml @@ -94,7 +94,7 @@ xsi:schemaLocation="http://tajo.apache.org/catalogstore ../DBMSSchemaDefinition. CREATE TABLE OPTIONS ( TID INT NOT NULL, KEY_ VARCHAR(255) NOT NULL, - VALUE_ VARCHAR(255) NOT NULL, + VALUE_ VARCHAR(4000) NOT NULL, CONSTRAINT OPTIONS_PKEY PRIMARY KEY (TID, KEY_), FOREIGN KEY (TID) REFERENCES TABLES (TID) ON DELETE CASCADE )]]>
