[
https://issues.apache.org/jira/browse/IGNITE-10631?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergey Kozlov updated IGNITE-10631:
-----------------------------------
Description:
{noformat}
['/var/lib/teamcity/data/work/dd4d79acf76cc870/i2test/var/suite-examples/art-gg-pro/bin/sqlline.sh',
'-d', 'org.apache.ignite.IgniteJdbcDriver', '--verbose=true', '--force=true',
'--showWarnings=true', '--showNestedErrs=true', '-u',
'jdbc:ignite:cfg://cache=default:transactionsAllowed=true@/var/lib/teamcity/data/work/dd4d79acf76cc870/i2test/var/suite-examples/test_modules/test_sql_world/jdbc-memory-region.3/client.xml',
'-f',
'/var/lib/teamcity/data/work/dd4d79acf76cc870/i2test/var/suite-examples/test_modules/test_sql_world/jdbc-memory-region.3/sqlline_output.1.batch.txt']
...
9/5330 CREATE TABLE City (
ID INT,
Name VARCHAR,
CountryCode CHAR(3),
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";
No rows affected (0.118 seconds)
10/5330
11/5330 CREATE INDEX idx_country_code ON city (CountryCode);
Error: Table doesn't exist: CITY (state=42000,code=3001)
java.sql.SQLException: Table doesn't exist: CITY
at
org.apache.ignite.internal.processors.query.IgniteSQLException.toJdbcException(IgniteSQLException.java:143)
at
org.apache.ignite.internal.jdbc2.JdbcUtils.convertToSqlException(JdbcUtils.java:179)
at
org.apache.ignite.internal.jdbc2.JdbcUtils.convertToSqlException(JdbcUtils.java:158)
at
org.apache.ignite.internal.jdbc2.JdbcStatement.executeSingle(JdbcStatement.java:181)
at
org.apache.ignite.internal.jdbc2.JdbcStatement.execute0(JdbcStatement.java:195)
at
org.apache.ignite.internal.jdbc2.JdbcStatement.execute(JdbcStatement.java:303)
at sqlline.Commands.execute(Commands.java:823)
at sqlline.Commands.sql(Commands.java:733)
at sqlline.SqlLine.dispatch(SqlLine.java:795)
at sqlline.SqlLine.runCommands(SqlLine.java:1706)
at sqlline.Commands.run(Commands.java:1317)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38)
at sqlline.SqlLine.dispatch(SqlLine.java:791)
at sqlline.SqlLine.initArgs(SqlLine.java:595)
at sqlline.SqlLine.begin(SqlLine.java:643)
at sqlline.SqlLine.start(SqlLine.java:373)
at sqlline.SqlLine.main(SqlLine.java:265)
{noformat}
> examples/sql/world.sql doesn't work for IgniteJdbcDriver
> --------------------------------------------------------
>
> Key: IGNITE-10631
> URL: https://issues.apache.org/jira/browse/IGNITE-10631
> Project: Ignite
> Issue Type: Bug
> Components: examples
> Affects Versions: 2.7
> Reporter: Sergey Kozlov
> Priority: Major
>
> {noformat}
> ['/var/lib/teamcity/data/work/dd4d79acf76cc870/i2test/var/suite-examples/art-gg-pro/bin/sqlline.sh',
> '-d', 'org.apache.ignite.IgniteJdbcDriver', '--verbose=true',
> '--force=true', '--showWarnings=true', '--showNestedErrs=true', '-u',
> 'jdbc:ignite:cfg://cache=default:transactionsAllowed=true@/var/lib/teamcity/data/work/dd4d79acf76cc870/i2test/var/suite-examples/test_modules/test_sql_world/jdbc-memory-region.3/client.xml',
> '-f',
> '/var/lib/teamcity/data/work/dd4d79acf76cc870/i2test/var/suite-examples/test_modules/test_sql_world/jdbc-memory-region.3/sqlline_output.1.batch.txt']
> ...
> 9/5330 CREATE TABLE City (
> ID INT,
> Name VARCHAR,
> CountryCode CHAR(3),
> 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";
> No rows affected (0.118 seconds)
> 10/5330
> 11/5330 CREATE INDEX idx_country_code ON city (CountryCode);
> Error: Table doesn't exist: CITY (state=42000,code=3001)
> java.sql.SQLException: Table doesn't exist: CITY
> at
> org.apache.ignite.internal.processors.query.IgniteSQLException.toJdbcException(IgniteSQLException.java:143)
> at
> org.apache.ignite.internal.jdbc2.JdbcUtils.convertToSqlException(JdbcUtils.java:179)
> at
> org.apache.ignite.internal.jdbc2.JdbcUtils.convertToSqlException(JdbcUtils.java:158)
> at
> org.apache.ignite.internal.jdbc2.JdbcStatement.executeSingle(JdbcStatement.java:181)
> at
> org.apache.ignite.internal.jdbc2.JdbcStatement.execute0(JdbcStatement.java:195)
> at
> org.apache.ignite.internal.jdbc2.JdbcStatement.execute(JdbcStatement.java:303)
> at sqlline.Commands.execute(Commands.java:823)
> at sqlline.Commands.sql(Commands.java:733)
> at sqlline.SqlLine.dispatch(SqlLine.java:795)
> at sqlline.SqlLine.runCommands(SqlLine.java:1706)
> at sqlline.Commands.run(Commands.java:1317)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at
> sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38)
> at sqlline.SqlLine.dispatch(SqlLine.java:791)
> at sqlline.SqlLine.initArgs(SqlLine.java:595)
> at sqlline.SqlLine.begin(SqlLine.java:643)
> at sqlline.SqlLine.start(SqlLine.java:373)
> at sqlline.SqlLine.main(SqlLine.java:265)
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
