Hans Zeller

Merge [TRAFODION-3220] Executor GUI PR-1724

[TRAFODION-3220] Executor GUI

Adding the ability to display query execution with the "display"

command in Trafodion (sqlci only, requires an X Windows display,

just as the compiler GUI does).

    • -1
    • +1
    /core/sql/SqlCompilerDebugger/AboutBox.ui
    • -0
    • +94
    /core/sql/SqlCompilerDebugger/ExeSchedWindow.h
  1. … 30 more files in changeset.
Merge [TRAFODION-3177] Error when selecting count(*) from event_log_reader UDF PR-1682

[TRAFODION-3177] Addressing review comments.

[TRAFODION-3177] Error when selecting count(*) from event_log_reader UDF

See the JIRA for a description of the issues.

- Removed code that required usage of a set of output columns

to evaluate code. This check caused the error described in the

test case, and I think it is no longer necessary. Removing it

can speed up some cases where we now evaluate predicates in the

UDF, for example:

select count(*)

from udf("_LIBMGR_".event_log_reader('f'))

where log_file_node = 0;

- Added predicate evaluation code for MESSAGE, LOG_FILE_NODE,

LOG_FILE_LINE, and PARSE_STATUS columns.

    • -46
    • +99
    /core/sql/sqludr/SqlUdrPredefLogReader.cpp
[TRAFODION-3164] Restart mxosrvrs on-demand

This code adds a zookeeper value to signal to mxosrvr processes

when it is time to exit. This allows to phase out processes when

things in the environment change. The process will wait until it

is idle before exiting.

    • -1
    • +39
    /core/conn/odbc/src/odbc/nsksrvr/SrvrMain.cpp
Merge [TRAFODION-3136] Bug fixed: If position is a negative value, the result does not match expectations. PR-1654

Merge [TRAFODION-2901] Self-reference Holloween problem fix PR-1581

Merge [TRAFODION-3109] comment can not transfer single quote normally in co… PR-1610

Merge [TRAFODION 3091] Unnamed Dynamic parameter doesn't work in WITH state… PR-1585

Merge [TRAFODION-510] Internal error or core dump with set table timeout PR-1554

[TRAFODION-510] Internal error or core dump with set table timeout

Disable this syntax that is no longer supported, so that we don't

get a core dump in debug builds. This caused a core every time I

ran the core/TEST019 regression test on a debug build.

Merge [TRAFODION-3042] RAND() function is not always random PR-1539

[TRAFODION-3042] Addressed review comment

[TRAFODION-3042] Switch to nanosecond-resolution time

Getting ready for the day where we can do two RAND() calls

in a microsecond - hopefully soon :-)

[TRAFODION-3042] RAND() function is not always random

When called without a seed, we use a seed based on the

system timestamp. The random generator we use generates similar

output values for seeds that are close together. Adding another

randomization step to avoid that.

Merge [TRAFODION-3028] Support CONTROL QUERY SHAPE (CQS) for Hive insert PR-1525

[TRAFODION-3028] Support CONTROL QUERY SHAPE (CQS) for Hive insert

Adding fast_extract() and hive_insert() CQS operator syntax to be able to force shapes of Hive insert statements.

Example:

control query shape hive_insert(cut);

explain insert into hive.hive.t values(1,1);

Note: I don't think this fix works for UNLOAD, since that seems to be

an "ExeUtil" statement that gets executed in two phases.

Merge [TRAFODION-2993] Add *SYSDATE* in *Trafodion SQL Reference Manual* PR-1479

Conflicts:

docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc

Merge [TRAFODION-2992] Add *SYSTIMESTAMP* in *Trafodion SQL Reference Manual* PR-1478

Merge Removing the "WITH PARTITIONS" syntax description PR-1476

Removing the "WITH PARTITIONS" syntax description

This option does not do anything in Trafodion.

Merge [TRAFODION-2974] Update expected files PR-1463

[TRAFODION-2974] Update expected files

New privileges granted to public caused several tests to fail.

    • -0
    • +32
    /core/sql/regress/privs1/EXPECTED123
Merge [TRAFODION-2974] Make event log reader and JDBC real TMUDFs PR-1460

    • -0
    • +12
    /core/sql/optimizer/BindRelExpr.cpp
[TRAFODION-2974] Rework based on review, update messages guide.

[TRAFODION-2974] Make event log reader and JDBC real TMUDFs

Roberta pointed out that we have two predefined UDFs, EVENT_LOG_READER

and JDBC, where the system administrator should have the ability to

control who can execute these functions.

To do this, these two UDFs cannot be "predefined" UDFs anymore, since

those don't have the metadata that's required for doing grant and

revoke.

Roberta also pointed out that the JDBC UDF should refuse to connect to

the T2 driver, for security reasons.

The fix leaves the predefined TMUDFs in place, for now, they will be

removed in R2.4 (see TRAFODION-2975).

The new "real" TMUDFs are in the "_LIBMGR_" schema, mostly for

convenience, as this schema has other UDFs that are created when

Trafodion is initialized.

    • -0
    • +12
    /core/sql/optimizer/BindRelExpr.cpp
    • -16
    • +100
    /core/sql/sqlcomp/CmpSeabaseDDLroutine.cpp
    • -12
    • +84
    /core/sql/sqlcomp/CmpSeabaseDDLroutine.h
Merge [TRAFODION-2965] Fix row count stats for partial groupby PR-1451

[TRAFODION-2965] Fix row count stats for partial groupby

Hash partial groupbys now report their row count in operator-level

statistics. These are not considered BMOs, so they need to use the

generic stats entry, not the BMO stats, to report the row count.

Merge [TRAFODION-2912] Better handling of non-deterministic scalar UDFs PR-1420

    • -6
    • +13
    /core/sql/optimizer/NormRelExpr.cpp