[
https://issues.apache.org/jira/browse/PHOENIX-118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13925110#comment-13925110
]
Hudson commented on PHOENIX-118:
--------------------------------
FAILURE: Integrated in Apache Phoenix - Branch:master #117 (See
[https://builds.apache.org/job/Phoenix/117/])
PHOENIX-118 Type mismatch error on upsert for unsigned_date and date
(jamestaylor: rev 65ac0ca34623c6ba69858a9c29dc78c11c46acfb)
* phoenix-core/src/test/java/org/apache/phoenix/client/TestClientKeyValue.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
*
phoenix-core/src/main/java/org/apache/phoenix/exception/ValueTypeIncompatibleException.java
* phoenix-core/src/test/java/org/apache/phoenix/util/MetaDataUtilTest.java
* phoenix-core/src/main/java/org/apache/phoenix/expression/DivideExpression.java
*
phoenix-core/src/main/java/org/apache/phoenix/expression/ArithmeticExpression.java
* phoenix-core/src/main/java/org/apache/phoenix/index/PhoenixIndexCodec.java
*
phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServicesImpl.java
* phoenix-core/src/main/java/org/apache/phoenix/schema/PArrayDataType.java
*
phoenix-core/src/test/java/org/apache/phoenix/end2end/ExecuteStatementsTest.java
* phoenix-core/src/main/java/org/apache/phoenix/util/NumberUtil.java
*
phoenix-core/src/test/java/org/apache/phoenix/end2end/index/MutableIndexTest.java
*
phoenix-core/src/test/java/org/apache/phoenix/client/TestClientKeyValueLocal.java
*
phoenix-core/src/main/java/org/apache/phoenix/hbase/index/util/KeyValueBuilder.java
*
phoenix-core/src/test/java/org/apache/phoenix/arithmetic/ArithmeticOperationTest.java
* phoenix-core/src/test/java/org/apache/phoenix/end2end/ArithmeticQueryTest.java
*
phoenix-core/src/main/java/org/apache/phoenix/coprocessor/UngroupedAggregateRegionObserver.java
* phoenix-core/src/test/java/org/apache/phoenix/end2end/UpsertValuesTest.java
*
phoenix-core/src/main/java/org/apache/phoenix/expression/DecimalAddExpression.java
*
phoenix-core/src/main/java/org/apache/phoenix/expression/DecimalSubtractExpression.java
* phoenix-core/src/main/java/org/apache/phoenix/schema/PDataType.java
*
phoenix-core/src/main/java/org/apache/phoenix/expression/DecimalMultiplyExpression.java
* phoenix-core/src/test/java/org/apache/phoenix/util/MinVersionTestRunner.java
*
phoenix-core/src/main/java/org/apache/phoenix/expression/LiteralExpression.java
* phoenix-core/src/main/java/org/apache/phoenix/util/IndexUtil.java
*
phoenix-core/src/main/java/org/apache/phoenix/expression/MultiplyExpression.java
* phoenix-core/src/test/java/org/apache/phoenix/schema/PDataTypeTest.java
*
phoenix-core/src/test/java/org/apache/phoenix/end2end/VariableLengthPKTest.java
*
phoenix-core/src/test/java/org/apache/phoenix/end2end/UpsertSelectAutoCommitTest.java
*
phoenix-core/src/main/java/org/apache/phoenix/expression/DecimalDivideExpression.java
*
phoenix-core/src/main/java/org/apache/phoenix/expression/BaseAddSubtractExpression.java
* phoenix-core/src/test/java/org/apache/phoenix/schema/SortOrderTest.java
* phoenix-core/src/main/java/org/apache/phoenix/exception/SQLExceptionCode.java
> Type mismatch error on upsert for unsigned_date and date
> --------------------------------------------------------
>
> Key: PHOENIX-118
> URL: https://issues.apache.org/jira/browse/PHOENIX-118
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 3.0.0
> Reporter: Mujtaba Chohan
> Assignee: James Taylor
> Fix For: 3.0.0
>
> Attachments: typeFixes.patch
>
>
> Following upsert statement fails for unsigned_date
> upsert into TEST values (TO_DATE('2013-01-04 01:01:01'));
> Error:ERROR 203 (22005): Type mismatch. DATE and UNSIGNED_DATE for
> expression: '2013-01-04 01:01:01.000' in column CREATED_DATE
> (state=22005,code=203)
> Uncovered during 2.x > 3.0 upgrade when date type is changed to unsigned_date
> type.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
