You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@geode.apache.org by "xiaojian zhou (JIRA)" <ji...@apache.org> on 2019/03/05 01:59:00 UTC

[jira] [Updated] (GEODE-6481) add tests to verify create jdbc mapping should get correct field type

     [ https://issues.apache.org/jira/browse/GEODE-6481?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

xiaojian zhou updated GEODE-6481:
---------------------------------
    Description: 
Add 2 test cases here:
1) when using numeric fields in domain class, create mapping and describe mapping should get correct fieldMapping between field and column, such as:
PDX Field | PDX Type | JDBC Column | JDBC Type | Nullable
--------- | -------- | ----------- | --------- | --------
income    | FLOAT    | INCOME      | REAL      | true
id        | STRING   | ID          | VARCHAR   | false
refid     | LONG     | REFID       | BIGINT    | true
name      | STRING   | NAME        | VARCHAR   | true
age       | INT      | AGE         | INTEGER   | true

It should NOT be:
PDX Field | PDX Type | JDBC Column |  JDBC Type  | Nullable
--------- | -------- | ----------- | ----------- | --------
income    | OBJECT   | income      | REAL        | true
name      | STRING   | name        | LONGVARCHAR | true
id        | OBJECT   | id          | BIGINT      | false

2) since we enforce the --pdx-name should be a PdxSerializable. We also support to convert a regular class into PdxSerializable using AutoSerializableManager.

  was:
Add 2 test cases here:
1) when using numeric fields in domain class, create mapping and describe mapping should get correct fieldMapping between field and column, such as:
PDX Field | PDX Type | JDBC Column | JDBC Type | Nullable
--------- | -------- | ----------- | --------- | --------
income    | FLOAT    | INCOME      | REAL      | true
id        | STRING   | ID          | VARCHAR   | false
refid     | LONG     | REFID       | BIGINT    | true
name      | STRING   | NAME        | VARCHAR   | true
age       | INT      | AGE         | INTEGER   | true

It should NOT be:
PDX Field | PDX Type | JDBC Column |  JDBC Type  | Nullable
--------- | -------- | ----------- | ----------- | --------
income    | OBJECT   | income      | REAL        | true
name      | STRING   | name        | LONGVARCHAR | true
id        | OBJECT   | id          | BIGINT      | false

2) since we enforce the --pdx-name should be a PdxSerializable. If using other interface, such as Serializable, create mapping should fail. 


> add tests to verify create jdbc mapping should get correct field type
> ---------------------------------------------------------------------
>
>                 Key: GEODE-6481
>                 URL: https://issues.apache.org/jira/browse/GEODE-6481
>             Project: Geode
>          Issue Type: Bug
>            Reporter: xiaojian zhou
>            Assignee: xiaojian zhou
>            Priority: Major
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> Add 2 test cases here:
> 1) when using numeric fields in domain class, create mapping and describe mapping should get correct fieldMapping between field and column, such as:
> PDX Field | PDX Type | JDBC Column | JDBC Type | Nullable
> --------- | -------- | ----------- | --------- | --------
> income    | FLOAT    | INCOME      | REAL      | true
> id        | STRING   | ID          | VARCHAR   | false
> refid     | LONG     | REFID       | BIGINT    | true
> name      | STRING   | NAME        | VARCHAR   | true
> age       | INT      | AGE         | INTEGER   | true
> It should NOT be:
> PDX Field | PDX Type | JDBC Column |  JDBC Type  | Nullable
> --------- | -------- | ----------- | ----------- | --------
> income    | OBJECT   | income      | REAL        | true
> name      | STRING   | name        | LONGVARCHAR | true
> id        | OBJECT   | id          | BIGINT      | false
> 2) since we enforce the --pdx-name should be a PdxSerializable. We also support to convert a regular class into PdxSerializable using AutoSerializableManager.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)