Repository: ignite Updated Branches: refs/heads/master 3606b21bf -> d21f86f9e
IGNITE-10432: Fixed data types in world.sql. Project: http://git-wip-us.apache.org/repos/asf/ignite/repo Commit: http://git-wip-us.apache.org/repos/asf/ignite/commit/d21f86f9 Tree: http://git-wip-us.apache.org/repos/asf/ignite/tree/d21f86f9 Diff: http://git-wip-us.apache.org/repos/asf/ignite/diff/d21f86f9 Branch: refs/heads/master Commit: d21f86f9e7817481acbb9438a9e07ca605246807 Parents: 3606b21 Author: devozerov <voze...@gridgain.com> Authored: Wed Nov 28 11:11:20 2018 +0300 Committer: devozerov <voze...@gridgain.com> Committed: Wed Nov 28 11:11:20 2018 +0300 ---------------------------------------------------------------------- examples/sql/world.sql | 28 ++++++++++++++-------------- 1 file changed, 14 insertions(+), 14 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/ignite/blob/d21f86f9/examples/sql/world.sql ---------------------------------------------------------------------- diff --git a/examples/sql/world.sql b/examples/sql/world.sql index a34ee71..829fba1 100644 --- a/examples/sql/world.sql +++ b/examples/sql/world.sql @@ -2,30 +2,30 @@ DROP TABLE IF EXISTS Country; CREATE TABLE Country ( Code CHAR(3) PRIMARY KEY, - Name CHAR(52), - Continent CHAR(50), - Region CHAR(26), + Name VARCHAR, + Continent VARCHAR, + Region VARCHAR, SurfaceArea DECIMAL(10,2), - IndepYear SMALLINT(6), - Population INT(11), + IndepYear SMALLINT, + Population INT, LifeExpectancy DECIMAL(3,1), GNP DECIMAL(10,2), GNPOld DECIMAL(10,2), - LocalName CHAR(45), - GovernmentForm CHAR(45), - HeadOfState CHAR(60), - Capital INT(11), + LocalName VARCHAR, + GovernmentForm VARCHAR, + HeadOfState VARCHAR, + Capital INT, Code2 CHAR(2) ) WITH "template=partitioned, backups=1, CACHE_NAME=Country, VALUE_TYPE=demo.model.Country"; DROP TABLE IF EXISTS City; CREATE TABLE City ( - ID INT(11), - Name CHAR(35), + ID INT, + Name VARCHAR, CountryCode CHAR(3), - District CHAR(20), - Population INT(11), + District VARCHAR, + Population INT, PRIMARY KEY (ID, CountryCode) ) WITH "template=partitioned, backups=1, affinityKey=CountryCode, CACHE_NAME=City, KEY_TYPE=demo.model.CityKey, VALUE_TYPE=demo.model.City"; @@ -35,7 +35,7 @@ DROP TABLE IF EXISTS CountryLanguage; CREATE TABLE CountryLanguage ( CountryCode CHAR(3), - Language CHAR(30), + Language VARCHAR, IsOfficial CHAR(2), Percentage DECIMAL(4,1), PRIMARY KEY (CountryCode, Language)