[ 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)