Trafodion

Clone Tools
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
ESP-colocation fixes (Ravisha and Qifan)

    • -0
    • +3
    /core/sql/executor/HBaseClient_JNI.cpp
    • -7
    • +11
    /core/sql/optimizer/OptPhysRelExpr.cpp
    • -603
    • +603
    /core/sql/regress/core/EXPECTEDRTS
    • -63
    • +63
    /core/sql/regress/seabase/EXPECTED016
TM Support for DDL Alter Table

Addition of TM support for DDL Alter Table

Merge remote branch 'origin/pr/12/head' into mrg_9

Merge remote branch 'origin/pr/12/head' into mrg_9

Merge remote branch 'origin/pr/10/head' into mrg_8

Added copyright statements and some comments.

closes TRAFODION-11

Merge remote branch 'origin/pr/8/head' into mrg_7

Merge remote branch 'origin/master' into mybranch1

TRAFODION-13 Multiple MTD-related bug fixes, UDF and RI constraint fixes

Bug fixes for Multi-temperature Data aka MTD aka divisioning and a related bug for RI constraints. These will be converted to JIRAs soon.

Also added an Excel tool to draw query plans, has limited support only.

LaunchPad 1466209 Referential constraint column correspondence not recorded correctly in metadata

LaunchPad 1417739 Multi-temperature data: should not allow divisioning on float datatype.

LaunchPad 1417741 multi-temperature data: divisioning on (date_part('year', add_months(...)) fails with ERROR[3044], ERROR[1135]

LaunchPad 1417743 multi-temperature data: able to define a RI constraint on a system column.

LaunchPad 1427527 Multi-temperature data: create-table-like-with-constrains-without-division table should not be divisioned

LaunchPad 1442774 TMUDF: Compiling a TPCH query with TMUDF returns internal assertion in BaseTypes.cpp:118

Details:

LaunchPad 1466209 Referential constraint column correspondence not recorded correctly in metadata

For an RI constraint, we record a list of foreign key columns in the

KEYS metadata table, as well as the UID of the referenced uniqueness

constraint. The foreign key column list is matched with the unique key

columns. We needed to add logic to reorder the lists in case the

unique constraint was specified in a different order. For example, in

seabase/TEST020:

alter table test020t9 add constraint test020t9ri4

foreign key (r1,r2) references test020t8 (c3,c2);

This will trigger the reorder logic to convert it to

foreign key (r2,r1) references test020t8 (c2,c3)

to match the index on test020t8 (c2,c3).

LaunchPad 1417739 Multi-temperature data: should not allow divisioning on float datatype.

Added a check and a new error number 4257. Note that we do allow float

as key columns, and that could have similar issues that rounding

errors could cause us to find a row sometimes and not other times,

although those issues should be rare. Nevertheless, I prefer not to

take that chance and allow divisioning on floating point columns (it

does not make much sense anyway).

LaunchPad 1417741 multi-temperature data: divisioning on (date_part('year', add_months(...)) fails with ERROR[3044], ERROR[1135]

There are really two issues here. First, the CAST operator that is

internally used in ADD_MONTHS in the parser generates a nullable

result, since in the parser we don't know whether the result is

nullable or not. We need to fix that in the binder to avoid the error

1135. Second, there were some cases where the interval leading

precision of a data type was not initialized correctly (error 3044).

LaunchPad 1417743 multi-temperature data: able to define a RI constraint on a system column.

This uncovered a bigger issue in the integration between MTD and RI

constraints. We need to ignore salt and divisioning columns in the

keys we consider, since these columns are redundant and not

user-visible. Added code to do that and while working on it, also

found the first bug in this list.

LaunchPad 1427527 Multi-temperature data: create-table-like-with-constrains-without-division table should not be divisioned

A typo in the parser code led us to ignore the WITHOUT DIVISION clause.

LaunchPad 1442774 TMUDF: Compiling a TPCH query with TMUDF returns internal assertion in BaseTypes.cpp:118

Used incorrect set of values in preCodeGen.

    • -45
    • +128
    /core/sql/optimizer/NATable.cpp
    • -0
    • +2
    /core/sql/regress/compGeneral/EXPECTED071
    • -6
    • +72
    /core/sql/regress/seabase/EXPECTED020
    • -2
    • +2
    /core/sql/sqlcomp/CmpDDLCatErrorCodes.h
  1. … 4 more files in changeset.
Changed pom file to use java version 7

    • -1
    • +8
    /dcs/src/test/jdbc_test/pom.xml.template
Merge remote branch 'origin/pr/9/head' into mrg_6

Merge remote branch 'origin/pr/2/head' into mrg_5

Fix for Trafodion-5

System with large number of nodes, some created tables can not be used

The code that generates the unique ID that has been used as OBJECT_UID

is reworked to avoid getting negative numbers. Earlier, it was possible

to get negative number on the nodes at or above 64 nodes.

Please see the inline comments in CatSQLShare.cpp for the new

algorithm.

Change-Id: I7df665c16d9c156e110d9d2db3dcd82bd6dfd615

    • -22
    • +13
    /core/sql/sqlshare/CatSQLShare.cpp
[TRAFODION-11] Add tests for big column size and transactions

Merge remote branch 'origin/pr/6/head' into mrg_4

Fix for TRAFODION-10, fix stale URLs in install_local_hadoop

    • -1
    • +7
    /core/sqf/sql/scripts/install_local_hadoop
Merge remote branch 'origin/pr/3/head' into mrg_2

Fix #1369853

T2 and T4 drivers return different errors if fetch/get data is issued

when cursor is after last row.

Change-Id: Ia91119b57c147e43ad5ea06fe1fd2c28ceca7c52

[TRAFODION-6]JDBC T2 has compilation errors when use -D_DEBUG option

With this check-in, JDBC T2 can use -D_DEBUG to make a debug version.

The debug version can output many debug informations and detect the

memory leak.

Change-Id: Ibf5dc2ae7e73b232bf0f3499fa3194d7f04c2e0e

    • -20
    • +7
    /core/conn/jdbc_type2/native/Debug.cpp
Fix for TRAFODION-4

    • -16
    • +22
    /core/sql/optimizer/BindRelExpr.cpp
    • -12
    • +113
    /core/sql/regress/executor/EXPECTED015.SB
    • -31
    • +39
    /core/sql/regress/hive/EXPECTED015
Allow scan esps to take # of partitions.

    • -24
    • +33
    /core/sql/optimizer/OptPhysRelExpr.cpp
Merge remote branch 'log4cxx/temp-merge' into migrate_log4cpp_to_log4cxx

Conflicts:

core/log4cpp/.gitignore

core/log4cpp/log4cpp-1.1.1/COPYING

core/log4cpp/log4cpp-1.1.1/ChangeLog

core/log4cpp/log4cpp-1.1.1/include/.cvsignore

core/log4cpp/log4cpp-1.1.1/include/Makefile.am

core/log4cpp/log4cpp-1.1.1/include/Makefile.in

core/log4cpp/log4cpp-1.1.1/include/config.h.in

core/log4cpp/log4cpp-1.1.1/include/log4cpp/.cvsignore

core/log4cpp/log4cpp-1.1.1/include/log4cpp/AbortAppender.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/Appender.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/AppenderSkeleton.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/AppendersFactory.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/BasicConfigurator.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/BasicLayout.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/BufferingAppender.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/Category.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/CategoryStream.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/Configurator.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/Export.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/FactoryParams.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/FileAppender.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/Filter.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/FixedContextCategory.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/HierarchyMaintainer.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/IdsaAppender.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/Layout.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/LayoutAppender.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/LayoutsFactory.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/LevelEvaluator.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/LoggingEvent.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/Makefile.am

core/log4cpp/log4cpp-1.1.1/include/log4cpp/Makefile.in

core/log4cpp/log4cpp-1.1.1/include/log4cpp/Manipulator.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/NDC.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/NTEventLogAppender.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/OstreamAppender.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/PassThroughLayout.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/PatternLayout.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/Portability.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/Priority.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/PropertyConfigurator.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/RemoteSyslogAppender.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/RollingFileAppender.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/SimpleConfigurator.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/SimpleLayout.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/SmtpAppender.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/StringQueueAppender.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/SyslogAppender.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/TimeStamp.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/TriggeringEventEvaluator.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/TriggeringEventEvaluatorFactory.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/Win32DebugAppender.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/config-MinGW32.h

core/log4cpp/log4cpp-1.1.1/include/log4cpp/config-openvms.h

core/log4cpp/log4cpp-1.1.1/include/log4cpp/config-win32-stlport-boost.h

core/log4cpp/log4cpp-1.1.1/include/log4cpp/config.h

core/log4cpp/log4cpp-1.1.1/include/log4cpp/convenience.h

core/log4cpp/log4cpp-1.1.1/include/log4cpp/threading/BoostThreads.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/threading/DummyThreads.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/threading/MSThreads.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/threading/Makefile.am

core/log4cpp/log4cpp-1.1.1/include/log4cpp/threading/Makefile.in

core/log4cpp/log4cpp-1.1.1/include/log4cpp/threading/OmniThreads.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/threading/PThreads.hh

core/log4cpp/log4cpp-1.1.1/include/log4cpp/threading/Threading.hh

core/log4cpp/log4cpp-1.1.1/src/.cvsignore

core/log4cpp/log4cpp-1.1.1/src/AbortAppender.cpp

core/log4cpp/log4cpp-1.1.1/src/Appender.cpp

core/log4cpp/log4cpp-1.1.1/src/AppenderSkeleton.cpp

core/log4cpp/log4cpp-1.1.1/src/AppendersFactory.cpp

core/log4cpp/log4cpp-1.1.1/src/BasicConfigurator.cpp

core/log4cpp/log4cpp-1.1.1/src/BasicLayout.cpp

core/log4cpp/log4cpp-1.1.1/src/BufferingAppender.cpp

core/log4cpp/log4cpp-1.1.1/src/Category.cpp

core/log4cpp/log4cpp-1.1.1/src/CategoryStream.cpp

core/log4cpp/log4cpp-1.1.1/src/Configurator.cpp

core/log4cpp/log4cpp-1.1.1/src/DllMain.cpp

core/log4cpp/log4cpp-1.1.1/src/DummyThreads.cpp

core/log4cpp/log4cpp-1.1.1/src/FactoryParams.cpp

core/log4cpp/log4cpp-1.1.1/src/FileAppender.cpp

core/log4cpp/log4cpp-1.1.1/src/Filter.cpp

core/log4cpp/log4cpp-1.1.1/src/FixedContextCategory.cpp

core/log4cpp/log4cpp-1.1.1/src/HierarchyMaintainer.cpp

core/log4cpp/log4cpp-1.1.1/src/IdsaAppender.cpp

core/log4cpp/log4cpp-1.1.1/src/LayoutAppender.cpp

core/log4cpp/log4cpp-1.1.1/src/LayoutsFactory.cpp

core/log4cpp/log4cpp-1.1.1/src/LevelEvaluator.cpp

core/log4cpp/log4cpp-1.1.1/src/Localtime.cpp

core/log4cpp/log4cpp-1.1.1/src/Localtime.hh

core/log4cpp/log4cpp-1.1.1/src/LoggingEvent.cpp

core/log4cpp/log4cpp-1.1.1/src/MSThreads.cpp

core/log4cpp/log4cpp-1.1.1/src/Makefile

core/log4cpp/log4cpp-1.1.1/src/Makefile.am

core/log4cpp/log4cpp-1.1.1/src/Makefile.in

core/log4cpp/log4cpp-1.1.1/src/Manipulator.cpp

core/log4cpp/log4cpp-1.1.1/src/NDC.cpp

core/log4cpp/log4cpp-1.1.1/src/NTEventLogAppender.cpp

core/log4cpp/log4cpp-1.1.1/src/OmniThreads.cpp

core/log4cpp/log4cpp-1.1.1/src/OstreamAppender.cpp

core/log4cpp/log4cpp-1.1.1/src/PThreads.cpp

core/log4cpp/log4cpp-1.1.1/src/PassThroughLayout.cpp

core/log4cpp/log4cpp-1.1.1/src/PatternLayout.cpp

core/log4cpp/log4cpp-1.1.1/src/PortabilityImpl.cpp

core/log4cpp/log4cpp-1.1.1/src/PortabilityImpl.hh

core/log4cpp/log4cpp-1.1.1/src/Priority.cpp

core/log4cpp/log4cpp-1.1.1/src/Properties.cpp

core/log4cpp/log4cpp-1.1.1/src/Properties.hh

core/log4cpp/log4cpp-1.1.1/src/PropertyConfigurator.cpp

core/log4cpp/log4cpp-1.1.1/src/PropertyConfiguratorImpl.cpp

core/log4cpp/log4cpp-1.1.1/src/PropertyConfiguratorImpl.hh

core/log4cpp/log4cpp-1.1.1/src/RemoteSyslogAppender.cpp

core/log4cpp/log4cpp-1.1.1/src/RollingFileAppender.cpp

core/log4cpp/log4cpp-1.1.1/src/SimpleConfigurator.cpp

core/log4cpp/log4cpp-1.1.1/src/SimpleLayout.cpp

core/log4cpp/log4cpp-1.1.1/src/SmtpAppender.cpp

core/log4cpp/log4cpp-1.1.1/src/StringQueueAppender.cpp

core/log4cpp/log4cpp-1.1.1/src/StringUtil.cpp

core/log4cpp/log4cpp-1.1.1/src/StringUtil.hh

core/log4cpp/log4cpp-1.1.1/src/SyslogAppender.cpp

core/log4cpp/log4cpp-1.1.1/src/TimeStamp.cpp

core/log4cpp/log4cpp-1.1.1/src/TriggeringEventEvaluatorFactory.cpp

core/log4cpp/log4cpp-1.1.1/src/Win32DebugAppender.cpp

core/log4cpp/log4cpp-1.1.1/src/macros.gmk

core/log4cpp/log4cpp-1.1.1/src/snprintf.c

core/log4cpp/log4cpp-1.1.1/src/verslib.h

core/log4cpp/log4cpp-1.1.1/src/verslog4cpplib.cpp

core/sqf/conf/log4cpp.monitor.mon.config

core/sqf/conf/log4cpp.monitor.mon.snmp.config

core/sqf/conf/log4cpp.monitor.psd.config

core/sqf/conf/log4cpp.monitor.wdg.config

core/sqf/conf/log4cpp.monitor.wdg.snmp.config

core/sqf/conf/log4cpp.trafodion.lob.config

core/sqf/conf/log4cpp.trafodion.masterexe.config

core/sqf/conf/log4cpp.trafodion.sscp.config

core/sqf/conf/log4cpp.trafodion.ssmp.config

core/sqf/conf/log4cpp.trafodion.tm.config

core/sqf/conf/log4cpp.trafodion.udr.config

core/sql/bin/vers_log4cpp.cpp

sql/bin/vers_log4cpp.cpp

sql/bin/vers_log4cxx.cpp

    • -3
    • +3
    /core/conn/odbc/src/odbc/nsksrvr/Makefile
    • -1
    • +1
    /core/conn/odbc/src/odbc/nsksrvr/SrvrMain.cpp
    • -30
    • +64
    /core/sqf/commonLogger/CommonLogger.cpp
    • -13
    • +19
    /core/sqf/commonLogger/CommonLogger.h
    • -0
    • +25
    /core/sqf/conf/log4cxx.monitor.mon.config
    • -0
    • +25
    /core/sqf/conf/log4cxx.monitor.mon.snmp.config
    • -0
    • +25
    /core/sqf/conf/log4cxx.monitor.psd.config
    • -0
    • +25
    /core/sqf/conf/log4cxx.monitor.wdg.config
    • -0
    • +25
    /core/sqf/conf/log4cxx.monitor.wdg.snmp.config
  1. … 206 more files in changeset.
Merge remote branch 'origin/master' into temp-merge

    • -0
    • +14
    /conn/odbc/src/odbc/nsksrvr/SrvrConnect.cpp
More fixes to CClusterConfig

Change-Id: I39d98eefb67296f4b90bfcd2e1dce6d5d5a5660a

Merge branch 'master' into traf/opensrc

Merge remote branch 'gerrit/master' into traf/opensrc

Final move into core sub-tree for restructured repo

    • -0
    • +1602
    /core/sql/regress/core/EXPECTED162
    • -0
    • +79
    /core/sql/regress/core/TEST162
    • -1602
    • +0
    /sql/regress/core/EXPECTED162
Merge remote branch 'core/master'

    • -1
    • +3
    /core/conn/odbc/src/odbc/Common/QSData.cpp
    • -1
    • +3
    /core/conn/odbc/src/odbc/Common/QSData.h
    • -1
    • +1
    /core/sql/regress/tools/runregr_core.ksh
Merge "Added a hive test to core"

Merge branch 'master' of https://github.com/trafodion/core

Conflicts:

sqf/sqenvcom.sh

sql/nskgmake/Makerules.linux

sql/nskgmake/qms/Makefile

sql/nskgmake/sqlci/Makefile

Change-Id: I2589648e978c247c96f6c914e689010916b04037

    • -2
    • +4
    /conn/odbc/src/odbc/nsksrvr/SrvrMain.cpp