[
https://issues.apache.org/jira/browse/TRAFODION-1700?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15167562#comment-15167562
]
ASF GitHub Bot commented on TRAFODION-1700:
-------------------------------------------
GitHub user selvaganesang reopened a pull request:
https://github.com/apache/incubator-trafodion/pull/227
[TRAFODION-1700] Upsert with omitted default value columns leave the
aligned format table in corrupted state.
The user is now required to supply the default values in upsert/upsert with
load command. When the columns with default value is omitted, the following
error is returned.
*** ERROR[7001] Default value is missing for upsert or is not valid for
column <column_name>
*** ERROR[8822] The statement was not prepared.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/selvaganesang/incubator-trafodion
trafodion-1700
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/227.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 #227
----
commit f36566710f430d48616a0ec9de1efbb1752007ee
Author: Sandhya Sundaresan <sand...@apache.org>
Date: 2016-01-08T04:11:27Z
Remvoving erroneous backup file.
commit 61f57f1f32c8d2657b2cae05e44adf8e33f16dfd
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date: 2016-01-08T06:03:49Z
conditional check fixed
commit fca75ed3df0f001caf148bc7f5d6f5190233b55a
Author: Gunnar Tapper <gtapper@esgyn.local>
Date: 2016-01-08T07:16:10Z
Addded SQL Clauses and SQL Functions and Expression.
commit 441769d8bb2c1bc812e84ee7d9d8e4a5c8789a92
Author: Kevin Xu <kaihua...@esgyn.cn>
Date: 2016-01-08T07:21:15Z
redefine PRODUCEDURE_TYPE
commit 90795250785f50cc0538284f22b1b8589a84734a
Author: Eric Owhadi <eric.owh...@esgyn.com>
Date: 2016-01-08T15:05:38Z
Fix issue where optimization on key column addition should be turned off
for MDAM scans, and update EXPECTEDTESTRTS to showcase the new value expected
as byte read showing a 53% improvement over previous code
commit 3676fee0cc798ab308c0d26ebb6acc1138e6ab8e
Author: Dave Birdsall <dbirds...@apache.org>
Date: 2016-01-08T16:42:36Z
Merge [TRAFODION-1739] Add CQD to allow more ESPs per core
commit 9f8afad66f6cb5152069e25d19d28a042bb5d23c
Author: Arvind Narain <arvi...@apache.org>
Date: 2016-01-08T17:04:25Z
Merge [TRAFODION-1727] PR-244 Fixes for DatabaseMetaData.getProcedures and
getProcedureColumns
commit 60ffbd9aade42401011ebfffddd681dca96e0d4d
Author: Sandhya Sundaresan <sand...@apache.org>
Date: 2016-01-08T18:01:04Z
Merge remote branch 'origin/pr/248/head' into merge_248
commit 7ea42ea6f7274c856f9f7e30471408af1e44265a
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date: 2016-01-08T18:30:26Z
Fixed the aws commands
commit 9ef29540108fbe4d69c74e408289419ab42accbc
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date: 2016-01-08T18:37:28Z
fixed a minor issue
commit fc9f514e0adca3496613ead047ca24d79381970d
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date: 2016-01-08T19:32:37Z
added informational messages for aws configuration
commit 4723e1a3f3ca9451101011011fce4ea1d93a1ba4
Author: Sean Broeder <sbroeder@edev03.esgyn.local>
Date: 2016-01-08T19:58:16Z
Fix for JIRA TRAFODION-1748
UnknownTransactionException in prepare causes error 97
commit 8b5ced6ad51324ef33abf2469468b6650c6438fc
Author: Anuradha Hegde <anuradha.he...@esgyn.com>
Date: 2016-01-08T22:35:16Z
minor fix
commit 47ca2755ba47d7297f3f25b24cda04bee89f490c
Author: Dave Birdsall <dbirds...@apache.org>
Date: 2016-01-09T00:08:00Z
Merge [TRAFODION-1748] PR 256 Fix to error 97 problem
commit 141f35434f2a89e0be5a0c45a75a9aeb4e00838e
Author: Arvind Narain <arvi...@apache.org>
Date: 2016-01-09T01:26:00Z
Merge [TRAFODION-1680] PR-251 Dcs needs to provide support for HA on AWS
commit 9bcd0e2b9cbb954bddb67ffe839d2a7280b5b54f
Author: Gunnar Tapper <gtapper@esgyn.local>
Date: 2016-01-09T08:32:18Z
Completed functions and expressions.
commit d51d2016d29725e3d863b351b3a548ee1b325c0c
Author: Cloud User <centos@ming01.novalocal>
Date: 2016-01-09T11:43:21Z
for jira 1720, add support to convert gbk into utf8
commit d16c4a1a798811ded8d3cabcc16719b8fafda400
Author: Gunnar Tapper <gtapper@esgyn.local>
Date: 2016-01-10T23:02:06Z
Completd the port of the SQL Reference Manual.
commit 11f9686b5df87f70b79edac5621da0610c7e70b8
Author: mashengchen <mashengc...@gmail.com>
Date: 2016-01-11T02:49:44Z
jira1729
commit cac96bc7ea69a3f1293e9ddef5e752f8785fb886
Author: mashengchen <mashengc...@gmail.com>
Date: 2016-01-11T03:19:05Z
Merge pull request #5 from apache/master
update head
commit 62237083f0db8230e257b6a8a12b5ca21c3831d8
Author: mashengchen <mashengc...@gmail.com>
Date: 2016-01-11T04:03:24Z
Merge branch 'master' of github.com:apache/incubator-trafodion
commit 5292fdc470db2317f4ab1133d298e98b97992e1e
Author: mashengchen <mashengc...@gmail.com>
Date: 2016-01-11T04:19:31Z
Merge branch 'master' of github.com:mashengchen/incubator-trafodion
commit 8681b49819031d3c1f4da6cf9b93de88de5fa1ff
Author: Gunnar Tapper <gtapper@esgyn.local>
Date: 2016-01-11T04:50:09Z
Updated to use standard theme.
commit 0ea8552120bd12d8c5ed1757325276cca3eac172
Author: mashengchen <mashengc...@gmail.com>
Date: 2016-01-11T05:39:43Z
Update HBaseClient.java
remove unnecessary log.
commit 6e0193a1837148fe5fecd3653402ddaff61f54ce
Author: mashengchen <mashengc...@gmail.com>
Date: 2016-01-11T05:41:00Z
Update CoprocessorUtils.java
change log level
commit 0dbaf3b3164069587a854968869211d1b69c3434
Author: mashengchen <mashengc...@gmail.com>
Date: 2016-01-11T05:52:45Z
jira1729
commit 9f00dd53b5254695761787dbbc9ebd90e0ac1963
Author: Hans Zeller <hzel...@apache.org>
Date: 2016-01-11T17:48:16Z
[TRAFODION-1747] Avoid generating SQL errors in successful statements
commit 17b39a0a3ee8b0a6e8523180f13b54364eb40879
Author: Gunnar Tapper <gtapper@esgyn.local>
Date: 2016-01-11T20:28:17Z
Updated the Command Interface Guide to use the standard PDF template.
commit e3d65c1519b559a13b09b2b7766c7bb48a2882c7
Author: Roberta Marton <roberta.mar...@apache.org>
Date: 2016-01-11T21:44:18Z
TRAFODION-1087 & TRAFODION-1671 fixes
TRAFODION-1087: Security Regressions take too long
Removed catman1 test suite and replaced with privs1 & privs2.
Moved catman1/TEST131 to core, TEST131 tests query invalidation.
Added back skipped privilege tests because catman1 took to long to run.
Also, cleaned up runregr scripts a bit - still need some more work.
TRAFODION-1671: Hive regression TEST009 fails
Changed the cleanup procedure to remove damaged files
Added an order by to select statement to make it more robust
commit d8b594f2b585de224a007e48ba735f0f5db860be
Author: mashengchen <mashengc...@gmail.com>
Date: 2016-01-12T04:15:12Z
add copyright
----
> Upsert with omitted default value columns leave the aligned format table in
> corrupted state.
> --------------------------------------------------------------------------------------------
>
> Key: TRAFODION-1700
> URL: https://issues.apache.org/jira/browse/TRAFODION-1700
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-general
> Affects Versions: 2.0-incubating
> Reporter: Suresh Subbiah
> Assignee: Selvaganesan Govindarajan
>
> Please use this to reproduce the problem
> CREATE TABLE al_bug
> (
> a LARGEINT GENERATED BY DEFAULT AS IDENTITY
> , b LARGEINT DEFAULT NULL
> , c TIMESTAMP(6) DEFAULT CURRENT
> , d TIMESTAMP(6) DEFAULT CURRENT
> , e SMALLINT DEFAULT NULL SERIALIZED
> , f VARCHAR(10 BYTES) CHARACTER SET UTF8 DEFAULT NULL
> , primary key (a))
> salt using 2 partitions
> attributes aligned format ;
> upsert into al_bug(b,f) select * from (values(1,'a'),(2,'b'),(3,'c')) x ;
> >>select * from al_bug ;
> ..
> A B C D
> E F
> -------------------- -------------------- --------------------------
> -------------------------- ------ ----------
> 1 1 97- 00:00:00.425344
> 00:00:00.000000 1
> 2 2 98- 00:00:00.425344
> 00:00:00.000000 1
> 3 3 99- 00:00:00.425344
> 00:00:00.000000 1
> --- 3 row(s) selected.
> >>
> Columns C, D have wrong values here and likely E & F too.
> If F is declared as VARCHAR(4K) more junk characters can be seen in output.
> These similar table definitions do not seem to have the problem
> create table al_bug (a int default null, b int ) attributes aligned format ;
> create table al_bug3 (a0 largeint generated by default as identity, a
> timestamp default current, e int default null, b varchar(10), primary key(a0)
> ) attributes aligned format ;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
