You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Kathey Marsden (JIRA)" <ji...@apache.org> on 2007/10/12 18:56:50 UTC
[jira] Created: (DERBY-3128) embedded: Inserting BigDecimal value
into non-DECIMAL column with setObject using specified scale does not
adjust scale
embedded: Inserting BigDecimal value into non-DECIMAL column with setObject using specified scale does not adjust scale
-----------------------------------------------------------------------------------------------------------------------
Key: DERBY-3128
URL: https://issues.apache.org/jira/browse/DERBY-3128
Project: Derby
Issue Type: Bug
Components: JDBC
Reporter: Kathey Marsden
Priority: Minor
For embedded specifying target type java.sql.Types.DECIMAL and inserting into a non-decimal column, e.g. REAL, DOUBLE, VARCHAR, does not properly adjust the scale when using the api calls below:
public void *setObject*(int parameterIndex,
Object x,
int targetSqlType)
and
public void *setObject*(int parameterIndex,
Objec x,
int targetSqlType,
int scale)
For example, with a scale specified as zero embeded will not truncate the fractional digits if inserted into a DOUBLE column (DECIMAL columns are fine). Client will truncate the fractional digits properly.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3128) embedded: Inserting BigDecimal value
into non-DECIMAL column with setObject using specified scale does not
adjust scale
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12534350 ]
Kathey Marsden commented on DERBY-3128:
---------------------------------------
Daniel John Debrunner - 12/Oct/07 10:31 AM asked :
>Is this limited to passing a BigDecimal object or does the same bug exist for passing a Double, Float or String object?
It is the same for passing a Double object.
> embedded: Inserting BigDecimal value into non-DECIMAL column with setObject using specified scale does not adjust scale
> -----------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-3128
> URL: https://issues.apache.org/jira/browse/DERBY-3128
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Reporter: Kathey Marsden
> Priority: Minor
> Attachments: ZeroScaleTest.java
>
>
> For embedded specifying target type java.sql.Types.DECIMAL and inserting into a non-decimal column, e.g. REAL, DOUBLE, VARCHAR, does not properly adjust the scale when using the api calls below:
> public void *setObject*(int parameterIndex,
> Object x,
> int targetSqlType)
> and
> public void *setObject*(int parameterIndex,
> Objec x,
> int targetSqlType,
> int scale)
> For example, with a scale specified as zero embeded will not truncate the fractional digits if inserted into a DOUBLE column (DECIMAL columns are fine). Client will truncate the fractional digits properly.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-3128) embedded: Inserting object into
non-DECIMAL column with setObject using specified scale does not adjust
scale
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden updated DERBY-3128:
----------------------------------
Affects Version/s: 10.4.0.0
> embedded: Inserting object into non-DECIMAL column with setObject using specified scale does not adjust scale
> --------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-3128
> URL: https://issues.apache.org/jira/browse/DERBY-3128
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.4.0.0
> Reporter: Kathey Marsden
> Priority: Minor
> Attachments: ZeroScaleTest.java
>
>
> For embedded specifying target type java.sql.Types.DECIMAL and inserting into a non-decimal column, e.g. REAL, DOUBLE, VARCHAR, does not properly adjust the scale when using the api calls below:
> public void *setObject*(int parameterIndex,
> Object x,
> int targetSqlType)
> and
> public void *setObject*(int parameterIndex,
> Objec x,
> int targetSqlType,
> int scale)
> For example, with a scale specified as zero embeded will not truncate the fractional digits if inserted into a DOUBLE column (DECIMAL columns are fine). Client will truncate the fractional digits properly.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3128) embedded: Inserting BigDecimal value
into non-DECIMAL column with setObject using specified scale does not
adjust scale
Posted by "Daniel John Debrunner (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12534348 ]
Daniel John Debrunner commented on DERBY-3128:
----------------------------------------------
Is this limited to passing a BigDecimal object or does the same bug exist for passing a Double, Float or String object?
> embedded: Inserting BigDecimal value into non-DECIMAL column with setObject using specified scale does not adjust scale
> -----------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-3128
> URL: https://issues.apache.org/jira/browse/DERBY-3128
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Reporter: Kathey Marsden
> Priority: Minor
> Attachments: ZeroScaleTest.java
>
>
> For embedded specifying target type java.sql.Types.DECIMAL and inserting into a non-decimal column, e.g. REAL, DOUBLE, VARCHAR, does not properly adjust the scale when using the api calls below:
> public void *setObject*(int parameterIndex,
> Object x,
> int targetSqlType)
> and
> public void *setObject*(int parameterIndex,
> Objec x,
> int targetSqlType,
> int scale)
> For example, with a scale specified as zero embeded will not truncate the fractional digits if inserted into a DOUBLE column (DECIMAL columns are fine). Client will truncate the fractional digits properly.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-3128) embedded: Inserting object into
non-DECIMAL column with setObject using specified scale does not adjust
scale
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden updated DERBY-3128:
----------------------------------
Summary: embedded: Inserting object into non-DECIMAL column with setObject using specified scale does not adjust scale (was: embedded: Inserting BigDecimal value into non-DECIMAL column with setObject using specified scale does not adjust scale)
> embedded: Inserting object into non-DECIMAL column with setObject using specified scale does not adjust scale
> --------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-3128
> URL: https://issues.apache.org/jira/browse/DERBY-3128
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Reporter: Kathey Marsden
> Priority: Minor
> Attachments: ZeroScaleTest.java
>
>
> For embedded specifying target type java.sql.Types.DECIMAL and inserting into a non-decimal column, e.g. REAL, DOUBLE, VARCHAR, does not properly adjust the scale when using the api calls below:
> public void *setObject*(int parameterIndex,
> Object x,
> int targetSqlType)
> and
> public void *setObject*(int parameterIndex,
> Objec x,
> int targetSqlType,
> int scale)
> For example, with a scale specified as zero embeded will not truncate the fractional digits if inserted into a DOUBLE column (DECIMAL columns are fine). Client will truncate the fractional digits properly.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-3128) embedded: Inserting object into
non-DECIMAL column with setObject using specified scale does not adjust
scale
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden updated DERBY-3128:
----------------------------------
Urgency: Normal
Bug behavior facts: [Deviation from standard]
Triaged for 10.5.2. Set urgency to normal.
> embedded: Inserting object into non-DECIMAL column with setObject using specified scale does not adjust scale
> --------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-3128
> URL: https://issues.apache.org/jira/browse/DERBY-3128
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.4.1.3
> Reporter: Kathey Marsden
> Priority: Minor
> Attachments: ZeroScaleTest.java
>
>
> For embedded specifying target type java.sql.Types.DECIMAL and inserting into a non-decimal column, e.g. REAL, DOUBLE, VARCHAR, does not properly adjust the scale when using the api calls below:
> public void *setObject*(int parameterIndex,
> Object x,
> int targetSqlType)
> and
> public void *setObject*(int parameterIndex,
> Objec x,
> int targetSqlType,
> int scale)
> For example, with a scale specified as zero embeded will not truncate the fractional digits if inserted into a DOUBLE column (DECIMAL columns are fine). Client will truncate the fractional digits properly.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Issue Comment Edited: (DERBY-3128) embedded: Inserting
BigDecimal value into non-DECIMAL column with setObject using specified
scale does not adjust scale
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12534350 ]
kmarsden edited comment on DERBY-3128 at 10/12/07 10:48 AM:
------------------------------------------------------------------
Daniel John Debrunner - 12/Oct/07 10:31 AM asked :
>Is this limited to passing a BigDecimal object or does the same bug exist for passing a Double, Float or String object?
It is the same for passing a Double, Float or String object.
was (Author: kmarsden):
Daniel John Debrunner - 12/Oct/07 10:31 AM asked :
>Is this limited to passing a BigDecimal object or does the same bug exist for passing a Double, Float or String object?
It is the same for passing a Double object.
> embedded: Inserting BigDecimal value into non-DECIMAL column with setObject using specified scale does not adjust scale
> -----------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-3128
> URL: https://issues.apache.org/jira/browse/DERBY-3128
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Reporter: Kathey Marsden
> Priority: Minor
> Attachments: ZeroScaleTest.java
>
>
> For embedded specifying target type java.sql.Types.DECIMAL and inserting into a non-decimal column, e.g. REAL, DOUBLE, VARCHAR, does not properly adjust the scale when using the api calls below:
> public void *setObject*(int parameterIndex,
> Object x,
> int targetSqlType)
> and
> public void *setObject*(int parameterIndex,
> Objec x,
> int targetSqlType,
> int scale)
> For example, with a scale specified as zero embeded will not truncate the fractional digits if inserted into a DOUBLE column (DECIMAL columns are fine). Client will truncate the fractional digits properly.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-3128) embedded: Inserting BigDecimal value
into non-DECIMAL column with setObject using specified scale does not
adjust scale
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden updated DERBY-3128:
----------------------------------
Attachment: ZeroScaleTest.java
> embedded: Inserting BigDecimal value into non-DECIMAL column with setObject using specified scale does not adjust scale
> -----------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-3128
> URL: https://issues.apache.org/jira/browse/DERBY-3128
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Reporter: Kathey Marsden
> Priority: Minor
> Attachments: ZeroScaleTest.java
>
>
> For embedded specifying target type java.sql.Types.DECIMAL and inserting into a non-decimal column, e.g. REAL, DOUBLE, VARCHAR, does not properly adjust the scale when using the api calls below:
> public void *setObject*(int parameterIndex,
> Object x,
> int targetSqlType)
> and
> public void *setObject*(int parameterIndex,
> Objec x,
> int targetSqlType,
> int scale)
> For example, with a scale specified as zero embeded will not truncate the fractional digits if inserted into a DOUBLE column (DECIMAL columns are fine). Client will truncate the fractional digits properly.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.