[jira] [Commented] (IGNITE-10356) JDBC thin driver returns wrong data type for Date and Decimal SQL type
[
https://issues.apache.org/jira/browse/IGNITE-10356?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16711178#comment-16711178
]
ASF GitHub Bot commented on IGNITE-10356:
-
Github user asfgit closed the pull request at:
https://github.com/apache/ignite/pull/5454
> JDBC thin driver returns wrong data type for Date and Decimal SQL type
> --
>
> Key: IGNITE-10356
> URL: https://issues.apache.org/jira/browse/IGNITE-10356
> Project: Ignite
> Issue Type: Bug
> Components: jdbc
>Affects Versions: 2.6, 2.7
>Reporter: Ray
>Assignee: Ray
>Priority: Critical
> Fix For: 2.8
>
>
> JDBC thin driver will return wrong metadata for column type when user creates
> a table with Date and Decimal type.
>
> Steps to reproduce.
> 1. Start one node and create table using this command
> create table a(a varchar, b decimal,c date, primary key(a));
> 2. Run "!desc a" to show the metadata of table a
> This results is as follows:
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME A
> DATA_TYPE 12
> TYPE_NAME VARCHAR
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> COLUMN_DEF
> SQL_DATA_TYPE 12
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 1
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME B
> {color:#d04437}DATA_TYPE {color}
> {color:#d04437}TYPE_NAME OTHER{color}
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> COLUMN_DEF
> {color:#d04437}SQL_DATA_TYPE {color}
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 2
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME C
> {color:#d04437}DATA_TYPE {color}
> {color:#d04437}TYPE_NAME OTHER{color}
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> {color:#33}COLUMN_DEF{color}
> {color:#d04437} SQL_DATA_TYPE {color}
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 3
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
>
> Column b and c has the wrong DATA_TYPE and TYPE_NAME.
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Commented] (IGNITE-10356) JDBC thin driver returns wrong data type for Date and Decimal SQL type
[
https://issues.apache.org/jira/browse/IGNITE-10356?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16711174#comment-16711174
]
Vladimir Ozerov commented on IGNITE-10356:
--
[~ldz], I pushed the patch to master. Thank you for contribution.
> JDBC thin driver returns wrong data type for Date and Decimal SQL type
> --
>
> Key: IGNITE-10356
> URL: https://issues.apache.org/jira/browse/IGNITE-10356
> Project: Ignite
> Issue Type: Bug
> Components: jdbc
>Affects Versions: 2.6, 2.7
>Reporter: Ray
>Assignee: Ray
>Priority: Critical
> Fix For: 2.8
>
>
> JDBC thin driver will return wrong metadata for column type when user creates
> a table with Date and Decimal type.
>
> Steps to reproduce.
> 1. Start one node and create table using this command
> create table a(a varchar, b decimal,c date, primary key(a));
> 2. Run "!desc a" to show the metadata of table a
> This results is as follows:
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME A
> DATA_TYPE 12
> TYPE_NAME VARCHAR
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> COLUMN_DEF
> SQL_DATA_TYPE 12
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 1
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME B
> {color:#d04437}DATA_TYPE {color}
> {color:#d04437}TYPE_NAME OTHER{color}
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> COLUMN_DEF
> {color:#d04437}SQL_DATA_TYPE {color}
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 2
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME C
> {color:#d04437}DATA_TYPE {color}
> {color:#d04437}TYPE_NAME OTHER{color}
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> {color:#33}COLUMN_DEF{color}
> {color:#d04437} SQL_DATA_TYPE {color}
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 3
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
>
> Column b and c has the wrong DATA_TYPE and TYPE_NAME.
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Commented] (IGNITE-10356) JDBC thin driver returns wrong data type for Date and Decimal SQL type
[
https://issues.apache.org/jira/browse/IGNITE-10356?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16708104#comment-16708104
]
Ray commented on IGNITE-10356:
--
[~vozerov]
I have expanded imports.
Please take a look.
> JDBC thin driver returns wrong data type for Date and Decimal SQL type
> --
>
> Key: IGNITE-10356
> URL: https://issues.apache.org/jira/browse/IGNITE-10356
> Project: Ignite
> Issue Type: Bug
> Components: jdbc
>Affects Versions: 2.6, 2.7
>Reporter: Ray
>Assignee: Ray
>Priority: Critical
> Fix For: 2.8
>
>
> JDBC thin driver will return wrong metadata for column type when user creates
> a table with Date and Decimal type.
>
> Steps to reproduce.
> 1. Start one node and create table using this command
> create table a(a varchar, b decimal,c date, primary key(a));
> 2. Run "!desc a" to show the metadata of table a
> This results is as follows:
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME A
> DATA_TYPE 12
> TYPE_NAME VARCHAR
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> COLUMN_DEF
> SQL_DATA_TYPE 12
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 1
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME B
> {color:#d04437}DATA_TYPE {color}
> {color:#d04437}TYPE_NAME OTHER{color}
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> COLUMN_DEF
> {color:#d04437}SQL_DATA_TYPE {color}
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 2
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME C
> {color:#d04437}DATA_TYPE {color}
> {color:#d04437}TYPE_NAME OTHER{color}
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> {color:#33}COLUMN_DEF{color}
> {color:#d04437} SQL_DATA_TYPE {color}
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 3
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
>
> Column b and c has the wrong DATA_TYPE and TYPE_NAME.
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Commented] (IGNITE-10356) JDBC thin driver returns wrong data type for Date and Decimal SQL type
[
https://issues.apache.org/jira/browse/IGNITE-10356?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16704169#comment-16704169
]
Ray commented on IGNITE-10356:
--
[~vozerov]
I ran the failed test suite again manually.
Here's the detailed results.
Platform .NET with one flaky failed test
[https://ci.ignite.apache.org/viewLog.html?buildId=2423396=buildResultsDiv=IgniteTests24Java8_PlatformNet]
{color:#33}Compute (Affinity Run) (Green with no failed test){color}
[https://ci.ignite.apache.org/viewLog.html?buildId=2427996=buildResultsDiv=IgniteTests24Java8_ComputeAffinityRun]
{color:#33}Cache 3 (Green with no failed test){color}
[https://ci.ignite.apache.org/viewLog.html?buildId=2423400=buildResultsDiv=IgniteTests24Java8_Cache3]
{color:#33}Activate | Deactivate Cluster (Green with no failed test){color}
[https://ci.ignite.apache.org/viewLog.html?buildId=2423402=buildResultsDiv=IgniteTests24Java8_ActivateDeactivateCluster]
{color:#33}Platform .NET (NuGet) (Green with no failed test){color}
[https://ci.ignite.apache.org/viewLog.html?buildId=2423404=buildResultsDiv=IgniteTests24Java8_PlatformNetNuGet]
{color:#33}PDS 1 (Green with no failed test){color}
[https://ci.ignite.apache.org/viewLog.html?buildId=2423406=buildResultsDiv=IgniteTests24Java8_Pds1]
Please review the results and comment.
> JDBC thin driver returns wrong data type for Date and Decimal SQL type
> --
>
> Key: IGNITE-10356
> URL: https://issues.apache.org/jira/browse/IGNITE-10356
> Project: Ignite
> Issue Type: Bug
> Components: jdbc
>Affects Versions: 2.6, 2.7
>Reporter: Ray
>Assignee: Ray
>Priority: Critical
> Fix For: 2.8
>
>
> JDBC thin driver will return wrong metadata for column type when user creates
> a table with Date and Decimal type.
>
> Steps to reproduce.
> 1. Start one node and create table using this command
> create table a(a varchar, b decimal,c date, primary key(a));
> 2. Run "!desc a" to show the metadata of table a
> This results is as follows:
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME A
> DATA_TYPE 12
> TYPE_NAME VARCHAR
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> COLUMN_DEF
> SQL_DATA_TYPE 12
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 1
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME B
> {color:#d04437}DATA_TYPE {color}
> {color:#d04437}TYPE_NAME OTHER{color}
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> COLUMN_DEF
> {color:#d04437}SQL_DATA_TYPE {color}
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 2
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME C
> {color:#d04437}DATA_TYPE {color}
> {color:#d04437}TYPE_NAME OTHER{color}
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> {color:#33}COLUMN_DEF{color}
> {color:#d04437} SQL_DATA_TYPE {color}
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 3
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
>
> Column b and c has the wrong DATA_TYPE and TYPE_NAME.
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Commented] (IGNITE-10356) JDBC thin driver returns wrong data type for Date and Decimal SQL type
[
https://issues.apache.org/jira/browse/IGNITE-10356?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16702947#comment-16702947
]
Vladimir Ozerov commented on IGNITE-10356:
--
[~ldz], please find the list of suspicious failures above. You should went
through them and confirm that they are not new comparing to master. Once done
please re-submit the ticket for review.
> JDBC thin driver returns wrong data type for Date and Decimal SQL type
> --
>
> Key: IGNITE-10356
> URL: https://issues.apache.org/jira/browse/IGNITE-10356
> Project: Ignite
> Issue Type: Bug
> Components: jdbc
>Affects Versions: 2.6, 2.7
>Reporter: Ray
>Assignee: Ray
>Priority: Critical
> Fix For: 2.8
>
>
> JDBC thin driver will return wrong metadata for column type when user creates
> a table with Date and Decimal type.
>
> Steps to reproduce.
> 1. Start one node and create table using this command
> create table a(a varchar, b decimal,c date, primary key(a));
> 2. Run "!desc a" to show the metadata of table a
> This results is as follows:
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME A
> DATA_TYPE 12
> TYPE_NAME VARCHAR
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> COLUMN_DEF
> SQL_DATA_TYPE 12
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 1
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME B
> {color:#d04437}DATA_TYPE {color}
> {color:#d04437}TYPE_NAME OTHER{color}
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> COLUMN_DEF
> {color:#d04437}SQL_DATA_TYPE {color}
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 2
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME C
> {color:#d04437}DATA_TYPE {color}
> {color:#d04437}TYPE_NAME OTHER{color}
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> {color:#33}COLUMN_DEF{color}
> {color:#d04437} SQL_DATA_TYPE {color}
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 3
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
>
> Column b and c has the wrong DATA_TYPE and TYPE_NAME.
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Commented] (IGNITE-10356) JDBC thin driver returns wrong data type for Date and Decimal SQL type
[
https://issues.apache.org/jira/browse/IGNITE-10356?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16702944#comment-16702944
]
Ignite TC Bot commented on IGNITE-10356:
{panel:title=Possible
Blockers|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1}
{color:#d04437}[Inspections] Core{color} [[tests 0 BuildFailureOnMetric
|https://ci.ignite.apache.org/viewLog.html?buildId=2407702]]
{color:#d04437}Platform .NET{color} [[tests
1|https://ci.ignite.apache.org/viewLog.html?buildId=2407694]]
* exe: PeerAssemblyLoadingTest.TestRuntimeDependency - 0,0% fails in last 100
master runs.
{color:#d04437}Compute (Affinity Run){color} [[tests
9|https://ci.ignite.apache.org/viewLog.html?buildId=2407614]]
* IgniteCacheAffinityRunTestSuite:
IgniteBaselineLockPartitionOnAffinityRunAtomicCacheTest.testNotReservedTxCacheOp
- 3,0% fails in last 100 master runs.
* IgniteCacheAffinityRunTestSuite:
IgniteBaselineLockPartitionOnAffinityRunTxCacheTest.testNotReservedTxCacheOp -
3,0% fails in last 100 master runs.
* IgniteCacheAffinityRunTestSuite:
IgniteBaselineLockPartitionOnAffinityRunAtomicCacheTest.testReservedPartitionCacheOp
- 3,0% fails in last 100 master runs.
* IgniteCacheAffinityRunTestSuite:
IgniteBaselineLockPartitionOnAffinityRunTxCacheTest.testReservedPartitionCacheOp
- 3,0% fails in last 100 master runs.
* IgniteCacheAffinityRunTestSuite:
IgniteBaselineLockPartitionOnAffinityRunTxCacheTest.testNotReservedAtomicCacheOp
- 3,0% fails in last 100 master runs.
* IgniteCacheAffinityRunTestSuite:
IgniteBaselineLockPartitionOnAffinityRunAtomicCacheTest.testNotReservedAtomicCacheOp
- 3,0% fails in last 100 master runs.
{color:#d04437}Cache 3{color} [[tests
2|https://ci.ignite.apache.org/viewLog.html?buildId=2407674]]
* IgniteBinaryObjectsCacheTestSuite3:
IgniteCacheGroupsTest.testEntriesTtlAtomicPartitioned - 0,0% fails in last 100
master runs.
{color:#d04437}Activate | Deactivate Cluster{color} [[tests
1|https://ci.ignite.apache.org/viewLog.html?buildId=2407611]]
* IgniteStandByClusterSuite:
IgniteClusterActivateDeactivateTest.testActivateFailover1 - 0,0% fails in last
100 master runs.
{color:#d04437}Platform .NET (NuGet)*{color} [[tests
9|https://ci.ignite.apache.org/viewLog.html?buildId=2407699]]
* exe: StartupTest.TestSpringConfig - 0,0% fails in last 100 master runs.
* exe: EntityFrameworkCacheTest.TestStartupPutGet - 0,0% fails in last 100
master runs.
* exe: Log4NetTest.TestIgniteStartup - 0,0% fails in last 100 master runs.
* exe: StartupTest.TestApacheIgniteExe - 0,0% fails in last 100 master runs.
* exe: NLogTest.TestIgniteStartup - 0,0% fails in last 100 master runs.
* exe: StartupTest.TestCodeConfig - 0,0% fails in last 100 master runs.
{color:#d04437}PDS 1{color} [[tests 0 TIMEOUT , Exit Code
|https://ci.ignite.apache.org/viewLog.html?buildId=2407690]]
{panel}
[TeamCity Run All
Results|https://ci.ignite.apache.org/viewLog.html?buildId=2407706buildTypeId=IgniteTests24Java8_RunAll]
> JDBC thin driver returns wrong data type for Date and Decimal SQL type
> --
>
> Key: IGNITE-10356
> URL: https://issues.apache.org/jira/browse/IGNITE-10356
> Project: Ignite
> Issue Type: Bug
> Components: jdbc
>Affects Versions: 2.6, 2.7
>Reporter: Ray
>Assignee: Ray
>Priority: Critical
> Fix For: 2.8
>
>
> JDBC thin driver will return wrong metadata for column type when user creates
> a table with Date and Decimal type.
>
> Steps to reproduce.
> 1. Start one node and create table using this command
> create table a(a varchar, b decimal,c date, primary key(a));
> 2. Run "!desc a" to show the metadata of table a
> This results is as follows:
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME A
> DATA_TYPE 12
> TYPE_NAME VARCHAR
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> COLUMN_DEF
> SQL_DATA_TYPE 12
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 1
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME B
> {color:#d04437}DATA_TYPE {color}
> {color:#d04437}TYPE_NAME OTHER{color}
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> COLUMN_DEF
> {color:#d04437}SQL_DATA_TYPE {color}
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 2
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME C
> {color:#d04437}DATA_TYPE {color}
>
[jira] [Commented] (IGNITE-10356) JDBC thin driver returns wrong data type for Date and Decimal SQL type
[
https://issues.apache.org/jira/browse/IGNITE-10356?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16701318#comment-16701318
]
Ray commented on IGNITE-10356:
--
[~vozerov]
The Run All has finished, there's a lot of failed tests in other modules.
Most of them looks flaky to me.
What's the next step here?
> JDBC thin driver returns wrong data type for Date and Decimal SQL type
> --
>
> Key: IGNITE-10356
> URL: https://issues.apache.org/jira/browse/IGNITE-10356
> Project: Ignite
> Issue Type: Bug
> Components: jdbc
>Affects Versions: 2.6, 2.7
>Reporter: Ray
>Assignee: Ray
>Priority: Critical
> Fix For: 2.8
>
>
> JDBC thin driver will return wrong metadata for column type when user creates
> a table with Date and Decimal type.
>
> Steps to reproduce.
> 1. Start one node and create table using this command
> create table a(a varchar, b decimal,c date, primary key(a));
> 2. Run "!desc a" to show the metadata of table a
> This results is as follows:
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME A
> DATA_TYPE 12
> TYPE_NAME VARCHAR
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> COLUMN_DEF
> SQL_DATA_TYPE 12
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 1
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME B
> {color:#d04437}DATA_TYPE {color}
> {color:#d04437}TYPE_NAME OTHER{color}
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> COLUMN_DEF
> {color:#d04437}SQL_DATA_TYPE {color}
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 2
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME C
> {color:#d04437}DATA_TYPE {color}
> {color:#d04437}TYPE_NAME OTHER{color}
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> {color:#33}COLUMN_DEF{color}
> {color:#d04437} SQL_DATA_TYPE {color}
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 3
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
>
> Column b and c has the wrong DATA_TYPE and TYPE_NAME.
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Commented] (IGNITE-10356) JDBC thin driver returns wrong data type for Date and Decimal SQL type
[
https://issues.apache.org/jira/browse/IGNITE-10356?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16699837#comment-16699837
]
Ray commented on IGNITE-10356:
--
[~tledkov-gridgain] [~vozerov]
The test run is finished, looks like we have one flaky test
JdbcThinTransactionsServerAutoCommitComplexSelfTest.testInsertAndQueryMultipleCaches.
Can you review the PR please?
> JDBC thin driver returns wrong data type for Date and Decimal SQL type
> --
>
> Key: IGNITE-10356
> URL: https://issues.apache.org/jira/browse/IGNITE-10356
> Project: Ignite
> Issue Type: Bug
> Components: jdbc
>Affects Versions: 2.6, 2.7
>Reporter: Ray
>Assignee: Ray
>Priority: Critical
> Fix For: 2.8
>
>
> JDBC thin driver will return wrong metadata for column type when user creates
> a table with Date and Decimal type.
>
> Steps to reproduce.
> 1. Start one node and create table using this command
> create table a(a varchar, b decimal,c date, primary key(a));
> 2. Run "!desc a" to show the metadata of table a
> This results is as follows:
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME A
> DATA_TYPE 12
> TYPE_NAME VARCHAR
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> COLUMN_DEF
> SQL_DATA_TYPE 12
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 1
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME B
> {color:#d04437}DATA_TYPE {color}
> {color:#d04437}TYPE_NAME OTHER{color}
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> COLUMN_DEF
> {color:#d04437}SQL_DATA_TYPE {color}
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 2
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME C
> {color:#d04437}DATA_TYPE {color}
> {color:#d04437}TYPE_NAME OTHER{color}
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> {color:#33}COLUMN_DEF{color}
> {color:#d04437} SQL_DATA_TYPE {color}
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 3
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
>
> Column b and c has the wrong DATA_TYPE and TYPE_NAME.
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Commented] (IGNITE-10356) JDBC thin driver returns wrong data type for Date and Decimal SQL type
[
https://issues.apache.org/jira/browse/IGNITE-10356?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16698525#comment-16698525
]
Ray commented on IGNITE-10356:
--
[~tledkov-gridgain] Tests added and updated PR.
I try to trigger the JDBC test run manually, but it looks like it's been queued
forever.
> JDBC thin driver returns wrong data type for Date and Decimal SQL type
> --
>
> Key: IGNITE-10356
> URL: https://issues.apache.org/jira/browse/IGNITE-10356
> Project: Ignite
> Issue Type: Bug
> Components: jdbc
>Affects Versions: 2.6, 2.7
>Reporter: Ray
>Assignee: Ray
>Priority: Critical
> Fix For: 2.8
>
>
> JDBC thin driver will return wrong metadata for column type when user creates
> a table with Date and Decimal type.
>
> Steps to reproduce.
> 1. Start one node and create table using this command
> create table a(a varchar, b decimal,c date, primary key(a));
> 2. Run "!desc a" to show the metadata of table a
> This results is as follows:
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME A
> DATA_TYPE 12
> TYPE_NAME VARCHAR
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> COLUMN_DEF
> SQL_DATA_TYPE 12
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 1
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME B
> {color:#d04437}DATA_TYPE {color}
> {color:#d04437}TYPE_NAME OTHER{color}
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> COLUMN_DEF
> {color:#d04437}SQL_DATA_TYPE {color}
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 2
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
> TABLE_CAT
> TABLE_SCHEM PUBLIC
> TABLE_NAME A
> COLUMN_NAME C
> {color:#d04437}DATA_TYPE {color}
> {color:#d04437}TYPE_NAME OTHER{color}
> COLUMN_SIZE null
> BUFFER_LENGTH null
> DECIMAL_DIGITS null
> NUM_PREC_RADIX 10
> NULLABLE 1
> REMARKS
> {color:#33}COLUMN_DEF{color}
> {color:#d04437} SQL_DATA_TYPE {color}
> SQL_DATETIME_SUB null
> CHAR_OCTET_LENGTH 2147483647
> ORDINAL_POSITION 3
> IS_NULLABLE YES
> SCOPE_CATLOG
> SCOPE_SCHEMA
> SCOPE_TABLE
> SOURCE_DATA_TYPE null
> IS_AUTOINCREMENT NO
> IS_GENERATEDCOLUMN NO
>
> Column b and c has the wrong DATA_TYPE and TYPE_NAME.
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Commented] (IGNITE-10356) JDBC thin driver returns wrong data type for Date and Decimal SQL type
[ https://issues.apache.org/jira/browse/IGNITE-10356?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16696684#comment-16696684 ] Vladimir Ozerov commented on IGNITE-10356: -- [~tledkov-gridgain], could you please take a look? > JDBC thin driver returns wrong data type for Date and Decimal SQL type > -- > > Key: IGNITE-10356 > URL: https://issues.apache.org/jira/browse/IGNITE-10356 > Project: Ignite > Issue Type: Bug > Components: jdbc >Affects Versions: 2.6, 2.7 >Reporter: Ray >Assignee: Ray >Priority: Critical > Fix For: 2.8 > > > JDBC thin driver will return wrong metadata for column type when user creates > a table with Date and Decimal type. > > Steps to reproduce. > 1. Start one node and create table using this command > create table a(a varchar, b decimal,c date, primary key(a)); > 2. Run "!desc a" to show the metadata of table a > This results is as follows: > TABLE_CAT > TABLE_SCHEM PUBLIC > TABLE_NAME A > COLUMN_NAME A > DATA_TYPE 12 > TYPE_NAME VARCHAR > COLUMN_SIZE null > BUFFER_LENGTH null > DECIMAL_DIGITS null > NUM_PREC_RADIX 10 > NULLABLE 1 > REMARKS > COLUMN_DEF > SQL_DATA_TYPE 12 > SQL_DATETIME_SUB null > CHAR_OCTET_LENGTH 2147483647 > ORDINAL_POSITION 1 > IS_NULLABLE YES > SCOPE_CATLOG > SCOPE_SCHEMA > SCOPE_TABLE > SOURCE_DATA_TYPE null > IS_AUTOINCREMENT NO > IS_GENERATEDCOLUMN NO > TABLE_CAT > TABLE_SCHEM PUBLIC > TABLE_NAME A > COLUMN_NAME B > DATA_TYPE > TYPE_NAME OTHER > COLUMN_SIZE null > BUFFER_LENGTH null > DECIMAL_DIGITS null > NUM_PREC_RADIX 10 > NULLABLE 1 > REMARKS > COLUMN_DEF > SQL_DATA_TYPE > SQL_DATETIME_SUB null > CHAR_OCTET_LENGTH 2147483647 > ORDINAL_POSITION 2 > IS_NULLABLE YES > SCOPE_CATLOG > SCOPE_SCHEMA > SCOPE_TABLE > SOURCE_DATA_TYPE null > IS_AUTOINCREMENT NO > IS_GENERATEDCOLUMN NO > TABLE_CAT > TABLE_SCHEM PUBLIC > TABLE_NAME A > COLUMN_NAME C > DATA_TYPE > TYPE_NAME OTHER > COLUMN_SIZE null > BUFFER_LENGTH null > DECIMAL_DIGITS null > NUM_PREC_RADIX 10 > NULLABLE 1 > REMARKS > COLUMN_DEF > SQL_DATA_TYPE > SQL_DATETIME_SUB null > CHAR_OCTET_LENGTH 2147483647 > ORDINAL_POSITION 3 > IS_NULLABLE YES > SCOPE_CATLOG > SCOPE_SCHEMA > SCOPE_TABLE > SOURCE_DATA_TYPE null > IS_AUTOINCREMENT NO > IS_GENERATEDCOLUMN NO > > Column b and c has the wrong DATA_TYPE and TYPE_NAME. > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (IGNITE-10356) JDBC thin driver returns wrong data type for Date and Decimal SQL type
[ https://issues.apache.org/jira/browse/IGNITE-10356?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16695569#comment-16695569 ] Ray commented on IGNITE-10356: -- TC results attached. [~vozerov] Can you review the fix please? > JDBC thin driver returns wrong data type for Date and Decimal SQL type > -- > > Key: IGNITE-10356 > URL: https://issues.apache.org/jira/browse/IGNITE-10356 > Project: Ignite > Issue Type: Bug >Affects Versions: 2.6, 2.7 >Reporter: Ray >Assignee: Ray >Priority: Critical > Fix For: 2.8 > > > JDBC thin driver will return wrong metadata for column type when user creates > a table with Date and Decimal type. > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (IGNITE-10356) JDBC thin driver returns wrong data type for Date and Decimal SQL type
[ https://issues.apache.org/jira/browse/IGNITE-10356?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16694334#comment-16694334 ] ASF GitHub Bot commented on IGNITE-10356: - GitHub user ldzhjn opened a pull request: https://github.com/apache/ignite/pull/5454 IGNITE-10356 JDBC thin driver returns wrong data type for Date and Decimal SQL type You can merge this pull request into a Git repository by running: $ git pull https://github.com/ldzhjn/ignite IGNITE-10356 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/ignite/pull/5454.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #5454 commit 1927c1617d165a8647ff45b010f395765d2ac68a Author: rayliu Date: 2018-11-21T07:29:05Z Fix bug > JDBC thin driver returns wrong data type for Date and Decimal SQL type > -- > > Key: IGNITE-10356 > URL: https://issues.apache.org/jira/browse/IGNITE-10356 > Project: Ignite > Issue Type: Bug >Affects Versions: 2.6, 2.7 >Reporter: Ray >Assignee: Ray >Priority: Critical > Fix For: 2.8 > > > JDBC thin driver will return wrong metadata for column type when user creates > a table with Date and Decimal type. > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
