Clone
Anoop Sharma <anoop.sharma@hp.com>
committed
on 17 Mar 15
repository upgrade and explain enhancements. Details below.
-- repository upgrade infrastructure integrated
with 'initialize trafodion, u… Show more
repository upgrade and explain enhancements. Details below.

-- repository upgrade infrastructure integrated

  with 'initialize trafodion, upgrade'

-- fields have been added/removed/modified in repos tables

-- new repos table has been added

-- upgrade enhanced to only upgrade subset of components that

  need to be upgraded. One or more of metadata, repos, views, priv.

-- metadata version now tracks release version and indicates

  the traf release where upgrade was needed.

  Current metadata version will be 1.1.0.

-- packed explain data is now returned to caller so it could be

  stored in repository

-- explain info from repository for a query id could be retrieved

  and displayed

    explain qid <query-id>;

    explain options 'f' qid <query-id>

    select * from table(explain(null, 'EXPLAIN_QID=<query-id>'));

-- a sql query could be explained and returned in relational format.

    select * from table(explain(null, 'EXPLAIN_STMT=<query-str>));

  Users only need to have select permission on tables referenced

  in query-str.

-- explain and statistics tables could be invoked

    invoke table(explain(null, null));

    invoke table(statistics(null, null));

Squashed commit of the following:

commit 09004ff7260b771378bc1a29f0ecb82e5e0c6100

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Mon Mar 16 12:24:03 2015 -0700

   repos and explain, #12

   Change-Id: Ia08151b5c7087b6b7daa5b662df2a584e5a7b2a1

commit 46f05ada264094626e45445d3875ccf876cad802

Merge: 3393587 6b3a4c4

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Sun Mar 15 21:27:48 2015 -0700

   Merge remote branch 'gerrit/master' into fix1

commit 3393587de319a3ad43d7d360cd74501e8b8103e4

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Sun Mar 15 21:26:30 2015 -0700

   repos and explain, #11

   Change-Id: I895a4b4766e0a92b7472a6b347f0bb3ee07fa9b6

commit cf6ffee549b37ffbcd6ce750a1fdbf7f0c410d61

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Sun Mar 15 16:07:22 2015 -0700

   repos and explain, #10

   Change-Id: I19e182ec6600525cec986f173afaf68a44e04af2

commit e331eec68feea59d9fa11e0154e3093762120eb2

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Fri Mar 13 18:19:03 2015 -0700

   repos and explain, #9

   Change-Id: I783c75513a432f718d2cd7c6030d410c419a79c8

commit 9e9da221eb45b760963741657fe9cb910a753c84

Merge: 20b64e5 9eb7f37

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Fri Mar 13 14:52:09 2015 -0700

   Merge remote branch 'gerrit/master' into fix1

   Conflicts:

       sql/common/ComSmallDefs.h

       sql/executor/ExExeUtilCli.h

       sql/generator/GenRelExeUtil.cpp

       sql/sqlcomp/CmpSeabaseDDLcommon.cpp

       sql/sqlcomp/CmpSeabaseDDLupgrade.cpp

       sql/sqlcomp/CmpSeabaseDDLupgrade.h

   Change-Id: Id21b10ff35ad506f409a83a8d955c2e643a2bcf5

commit 20b64e5552d8f614586ed843aad76d87d3473e2e

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Fri Mar 13 13:44:15 2015 -0700

   repos and explain, #8

   Change-Id: I2b49d962f08a22ca6c8b437a583855e2344f513c

commit 500b7a9486f23fff6b1c17bb6e79c2f614a7e3e6

Merge: f2c050e fc1c31d

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Fri Mar 13 08:07:34 2015 -0700

   Merge remote branch 'gerrit/master' into fix1

commit f2c050ea048b409b7d6769172e16c4ab26267bd0

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Fri Mar 13 08:07:15 2015 -0700

   repos and explain, #7

   Change-Id: I0bc04b6e8f147af1defbfd023c3700e26cc5b6f1

commit fabdb7dadd34238a8a227e880aa868ce484dc580

Merge: 59bb689 74640d7

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Thu Mar 12 09:01:20 2015 -0700

   Merge remote branch 'gerrit/master' into fix1

commit 59bb6893437abe3999a53188503c60cf47633458

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Thu Mar 12 09:00:44 2015 -0700

   repos and explain, #7

   Change-Id: I6595a04ad59c1f705a04beee18c877cb81db0fac

commit a86353b45436126915fd2ba74c9af53f8bfd4d19

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Mon Mar 9 16:21:16 2015 -0700

   repos and explain, #6

   Change-Id: Ie4fe2b2bece7de3697eb8ada0d1cb1067b89bb88

commit 61272e0d6107536ab8b691415770e856267b6da5

Merge: 1708cb4 ca5dfb4

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Mon Mar 9 15:52:43 2015 -0700

   Merge remote branch 'gerrit/master' into fix1

commit 1708cb44511809bf8e63800d226ac8ea34916726

Merge: 1284f4f 31f25ec

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Fri Mar 6 14:55:13 2015 -0800

   Merge remote branch 'gerrit/master' into fix1

commit 1284f4f78f1f43657f29899cc8b9a96c02f37815

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Fri Mar 6 14:54:54 2015 -0800

   commit: repos and explain, #6

   Change-Id: I38d796fd4ab58bf29fa62c4bd5492ce44de9c8a0

commit f639911a1ea4247ae4c297bbbd904b84c7587b3a

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Mon Mar 2 06:31:21 2015 -0800

   repos and explain, #5

   Change-Id: Ie97ba3cac8dc78784d0a7eef57176e51b9e16224

commit da69fe9595d4ad5c9adf3b32ae8f848a0e6be964

Merge: 9b95b8c a5caeef

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Mon Mar 2 06:31:00 2015 -0800

   Merge remote branch 'gerrit/master' into fix1

commit 9b95b8c3240a4186704b8b7f2ff8cefebf211732

Merge: ea2f687 8cd8a92

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Thu Feb 26 08:50:25 2015 -0800

   Merge remote branch 'gerrit/master' into fix1

commit ea2f6871b7c7803d0f1e3fa664b474e069a0befd

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Thu Feb 26 08:50:03 2015 -0800

   commit: repos and explain, #5

   Change-Id: I44d8f87b3652e6300e41302d3a3e88b9b18652a3

commit 522a47eb991df2245005c693e4d034235adbfdc5

Merge: d986988 f42694e

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Wed Feb 25 13:13:02 2015 -0800

   Merge remote branch 'gerrit/master' into fix1

commit d98698856a4be479a7603b0fb79210e80e88e1c1

Merge: 5841e47 2aad3ef

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Wed Feb 18 14:00:24 2015 -0800

   Merge remote branch 'gerrit/master' into fix1

commit 5841e47f1e3f9a018424298a92cd134f4430e6bf

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Wed Feb 18 13:57:46 2015 -0800

   repos and explain, #4

   Change-Id: I01f53003069598381743c9be80b405ed37cefe6d

commit e7b5966d8ce653a57b8128c0b24c15fc05737668

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Wed Feb 11 11:28:20 2015 -0800

   repos and explain, #3

   Change-Id: Iff148ef175a7641ea37e27e60435ccf8f613e6db

commit aba98dc8cfda62d4e708cd892ed626f2a3051eb0

Merge: 66f1926 19a0c32

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Tue Feb 10 14:09:58 2015 -0800

   Merge remote branch 'gerrit/master' into fix1

commit 66f1926d279f2b408d436b0aa53a3a6a5388901e

Merge: 9d0ef2a b68f59b

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Mon Feb 9 10:52:35 2015 -0800

   Merge remote branch 'gerrit/master' into fix1

   Conflicts:

       sql/sqlcomp/CmpSeabaseDDLcommon.cpp

       sql/sqlcomp/CmpSeabaseDDLtable.cpp

   Change-Id: I6348fec3aece2baad9e9570749f43c086416219e

commit 9d0ef2aa01a62ea3e4e0ab35f8ec9687ef3336ef

Merge: aac268d 2cd8fbb

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Fri Feb 6 14:15:49 2015 -0800

   Merge remote branch 'gerrit/master' into fix1

commit aac268d097afbe506dcf76de4d8f49652a1d4df7

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Tue Feb 3 16:31:17 2015 -0800

   repos and explain, #2

   Change-Id: Ia2a50159e577cd6ff8110dca35236fa90ea0d260

commit 2e6160411c8facb448e78d387fa3227e7b759c5d

Merge: c6e2fe5 566706d

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Tue Feb 3 15:21:03 2015 -0800

   Merge remote branch 'gerrit/master' into fix1

commit c6e2fe529f9d1e59d3eb26cb145b260d81814443

Author: Anoop Sharma <anoop.sharma@hp.com>

Date:   Tue Feb 3 15:16:36 2015 -0800

   repository updated and explain changes, #1

   Change-Id: I5daf66a2064b46ad65f1200579385965f7f56808

Change-Id: I0211d754524b8c06a05bb7ade20f884ec91340d2

Show less

default + 9 more