test

Clone Tools
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Move new DCS files to dcs tree

  1. … 2 more files in changeset.
Test prefix in SQL Statement

Add JDBCBasic27()

Change-Id: I241346a732c270c06e576ff29f5c627995e1ed78

Move wms into subdir to combine repos

    • -40
    • +0
    ./java/org/trafodion/wms/AppTest.java
    • -5
    • +0
    ./java/org/trafodion/wms/LargeTests.java
    • -5
    • +0
    ./java/org/trafodion/wms/MediumTests.java
    • -5
    • +0
    ./java/org/trafodion/wms/SmallTests.java
    • -258
    • +0
    ./java/org/trafodion/wms/ZkDataTest.java
    • -130
    • +0
    ./java/org/trafodion/wms/ZkStatsTest.java
  1. … 364 more files in changeset.
Add jdbc test case for bug #1451707 adn #1452993

Change-Id: Ifebe3477eb25bef56d7a9c4c9f3baa3557b5ed44

Move phoenix_test into test subdir to combine repos

    • -191
    • +0
    ./java/com/hp/phoenix/end2end/AlterTableTest.java
    • -126
    • +0
    ./java/com/hp/phoenix/end2end/AutoCommitTest.java
    • -1175
    • +0
    ./java/com/hp/phoenix/end2end/BaseTest.java
    • -125
    • +0
    ./java/com/hp/phoenix/end2end/CreateTableTest.java
    • -137
    • +0
    ./java/com/hp/phoenix/end2end/DeleteRangeTest.java
    • -195
    • +0
    ./java/com/hp/phoenix/end2end/FunkyNamesTest.java
  1. … 78 more files in changeset.
Move phoenix_test into test subdir to combine repos

    • -191
    • +0
    ./java/com/hp/phoenix/end2end/AlterTableTest.java
    • -126
    • +0
    ./java/com/hp/phoenix/end2end/AutoCommitTest.java
    • -1175
    • +0
    ./java/com/hp/phoenix/end2end/BaseTest.java
    • -125
    • +0
    ./java/com/hp/phoenix/end2end/CreateTableTest.java
    • -137
    • +0
    ./java/com/hp/phoenix/end2end/DeleteRangeTest.java
    • -195
    • +0
    ./java/com/hp/phoenix/end2end/FunkyNamesTest.java
  1. … 76 more files in changeset.
Move phoenix_test into test subdir to combine repos

    • -191
    • +0
    ./java/com/hp/phoenix/end2end/AlterTableTest.java
    • -126
    • +0
    ./java/com/hp/phoenix/end2end/AutoCommitTest.java
    • -1175
    • +0
    ./java/com/hp/phoenix/end2end/BaseTest.java
    • -125
    • +0
    ./java/com/hp/phoenix/end2end/CreateTableTest.java
    • -137
    • +0
    ./java/com/hp/phoenix/end2end/DeleteRangeTest.java
    • -195
    • +0
    ./java/com/hp/phoenix/end2end/FunkyNamesTest.java
  1. … 78 more files in changeset.
Move dcs into subdir to combine repos

    • -21
    • +0
    ./java/org/trafodion/dcs/LargeTests.java
    • -21
    • +0
    ./java/org/trafodion/dcs/MediumTests.java
    • -21
    • +0
    ./java/org/trafodion/dcs/SmallTests.java
  1. … 560 more files in changeset.
Move dcs into subdir to combine repos

    • -21
    • +0
    ./java/org/trafodion/dcs/LargeTests.java
    • -21
    • +0
    ./java/org/trafodion/dcs/MediumTests.java
    • -21
    • +0
    ./java/org/trafodion/dcs/SmallTests.java
  1. … 468 more files in changeset.
Move dcs into subdir to combine repos

    • -21
    • +0
    ./java/org/trafodion/dcs/LargeTests.java
    • -21
    • +0
    ./java/org/trafodion/dcs/MediumTests.java
    • -21
    • +0
    ./java/org/trafodion/dcs/SmallTests.java
  1. … 562 more files in changeset.
Update release version to 1.2 - dcs

Distinguish master branch from stable/1.1 branch.

If next release is determined to be a major release, this will

be updated again before release. Assuming minor release keeps

options open.

Test depends on version of server, since we are transitioning the

release version, relax the tests to accept 1.1 or 1.2.

Change-Id: I299cffad66dd661f05c711142ab05ffe3271e768

  1. … 1 more file in changeset.
Added more exception handling

Change-Id: Ida87f03b4891050de3df31d48dd0b88f89b556c8

Changed pwd to password.

Change-Id: I0363ee8ad7154df3eb3f4bbd31f142a312d00190

Update version to 1.1.0 on master branch

Next minor feature release.

TestBasic updated to match latest DB version number (1.1.0) in core.

Change-Id: I101060deb2fc1dfd68cb6681d12ef5f40eec52af

  1. … 1 more file in changeset.
Update release number to 1.0.0

Includes test changes for matching major/minor number of DB (trafodion/core).

Also DB product name test updated. Per Arvind:

This comment could be taken out now. Both return Trafodion with

commit a3a91d16fc6bb53a66fe544362ed5a3e0472ca19

Change-Id: I3233853543c7c3c783097b718ba7163866d8368a

  1. … 1 more file in changeset.
Reduced number of rows used in batch tests.

Reduced from to 6000 from 60000 to avoid tests timing out.

Also changed TOTALUPDATECOUNT to not be hardcoded.

Change-Id: I61741b9127b9041124995addade8b6df41d34150

Closes-bug:1407829

Explicit create schema stmts executed in tests

Change-Id: I25b07f4689516dd1c271ad8803981e155c9bc06e

Fixed a query predicate from year 2015 to 2115

Fixed a query predicate expecting

CURRENT_TIMESTAMP < TIMESTAMP '2015-01-01 00:00:00'.

This worked prior to 2015-01-01 and has started to fail now that year 2015

has begun. The timestamp is now changed to 2115-01-01 00:00:00 so that the

test can be run for another 100 years.

Change-Id: I0710081a883a6878b39873084a0134d76af402e1

Manageability changes in DCS

1) Port mapping

At startup DcsMaster now creates a list of TCP/IP ports based on the

entries in the conf/servers file and writes it to the zookeeper

/<username>/trafodion/dcs/servers/registered znode. Each MXOSRVR reads

the port map list and retrieves its unique port number.

2) Trafodion repository

JDBC type4 is used to access SQL from DcsMaster. The feature is disabled

by default but may be enabled by overriding the unpublished

"dcs.master.trafodion.repository" property with a value of .true. in

your dcs-site.xml file.

3) HA for DcsMaster

A new file, /bin/master-backup.sh, was added that when called from

dcs-start/dcs-stop script look for the presence of optional

/conf/backup-masters file. This feature works like the existing

.servers. in that you can specify hostnames, one per line, e.g.,

.localhost.. The script will start/stop DcsMaster processes on all hosts

defined in the file. The DcsMaster has new leader election code so that

only one DcsMaster process is the .leader.. All others wait, in a

non-herding fashion, for other DcsMasters to fail. The vision is that

the Seaquest .ndcsbind. script may be run prior to starting DCS but

more effort is needed to test this. This commit sets up the

infrastructure. There.s no property for this feature as it.s enabled

only the /conf/backup-masters file exists and has host names defined.

4) Trafodion logs

As a convenience DcsMaster can display the Trafodion log files found in

$MY_SQROOT/logs. There was no requirement for this rather I added for my

development use. Be warned that DcsMaster is not aware of Trafodion

configuration changes so right now it only looks in $MY_SQROOT/logs.

This feature is disabled by default but may be enabled by overriding the

unpublished "dcs.master.trafodion.logs" property with a value of .true.

in your dcs-site.xml file.

5) Basic Security

Provide basic infrastructure to authenticate DcsMaster Web UI users. A

new file /conf/realm.properties was added as a first step. It allows for

definition of users with roles. The embedded Jetty web server reads this

file and uses it to authenticate users attempting to access the

DcsMaster web UI. This feature will surely change over time. It also

supports #3 above as we need username/password for the connection to SQL

in T4 driver. We want users to only see/cancel their own queries. This

feature is disabled by default but may be enabled by overriding the

unpublished "dcs.master.security" property with a value of .true. in

your dcs-site.xml file.

Change-Id: I3e258f698dd828e683f0de03c2fe67c3ce4a5d26

    • -53
    • +0
    ./java/org/trafodion/dcs/AppTest.java
    • -0
    • +21
    ./java/org/trafodion/dcs/LargeTests.java
    • -0
    • +21
    ./java/org/trafodion/dcs/MediumTests.java
    • -0
    • +47
    ./java/org/trafodion/dcs/ReposPublicationTest.java
    • -0
    • +47
    ./java/org/trafodion/dcs/ReposTableAccessTest.java
    • -0
    • +203
    ./java/org/trafodion/dcs/ResourceChecker.java
    • -0
    • +84
    ./java/org/trafodion/dcs/ResourceCheckerJUnitRule.java
    • -0
    • +21
    ./java/org/trafodion/dcs/SmallTests.java
    • -0
    • +61
    ./resources/log4j.properties
  1. … 54 more files in changeset.
Updated Phoenix tests to cope with ANSI schemas

Updated Phoenix tests to do 'create schema' and 'drop schema' before and after

each test to cope with the new behavior with ANSI schemas. Up to now, schemas

in Trafodion do not need to be created or dropped, but the ANSI schema support

will change that. This update for Phoenix tests need to go in first before

the implement of ANSI schemas can go in, to ensure a smooth transition for

Jenkins builds. Since 'create schema' and 'drop schema' are just no-op right

now, Phoenix tests will continue to work for the existing builds even with this

update.

Change-Id: Ifa6902a122c78bdb899516cf8121295092cad0a9

Change jdbc_test directory structure

Change jdbc_test directory structure to org/trafodion/jdbc_test

Change-Id: Ifb6e3a8e96c766c3b0c16656a14f6caf5c411f90

    • -0
    • +1968
    ./jdbc_test/src/test/java/org/trafodion/jdbc_test/TestBasic.java
Change test reference from com.hp to org.trafodion

Change-Id: Idbd4d7f167f51be7d833771216e540193a788bc1

Update release version to 0.9.0

Also patching tests which query the database version. This returns

different result now that core has changed to version 0.9.

Change-Id: Iecf8d31e252c1eb5e19c491f289b9c200c139a2d

  1. … 1 more file in changeset.
Update phoenix tests for it to work for both JDBC T2 and T4 drivers

Updated 3 files to allow phoenix tests to work for both T2 and T4:

BaseTest.java:

updated the T2 class path that has been recently changed.

ArithmeticQueryTest.java & VariableLengthPKTest.java:

updated the tests to deal with different error messages and minor different

behaviors on decimal rounding.

Change-Id: I1409605073e9fcfeed3bcecfd9085352c051be3e

JDBC T4 Gate tests.

These tests will be run with every build to test the stability of DCS.

Please see README.rst for detailed instructions.

jdbc_test.py is the Python script that execute the JUnit testcases.

jdbc_test.py -help will show all the various parameters accepted.

The Java files contain the JUnit tests for the DCS component of Trafodion.

Change-Id: Iafc7c50cacfe90d44efbcfc16351d46a425b30bb

    • -0
    • +70
    ./jdbc_test/README.rst
    • -0
    • +411
    ./jdbc_test/jdbc_test.py
    • -0
    • +65
    ./jdbc_test/pom.xml.template
    • -0
    • +1968
    ./jdbc_test/src/test/java/com/hp/jdbc_test/TestBasic.java
    • -0
    • +182
    ./jdbc_test/src/test/java/com/hp/jdbc_test/Utils.java
Increase flexibility on checking scan operator in a plan

Increase flexibility on checking the scan operator in a query plan to include both index and file scans.

Change-Id: I06f89109cdbcfccef0e917d5932fa131cdff2418

    • -10
    • +10
    ./java/com/hp/phoenix/end2end/IndexTest.java
Initial wms code drop

    • -0
    • +40
    ./java/org/trafodion/wms/AppTest.java
    • -0
    • +5
    ./java/org/trafodion/wms/LargeTests.java
    • -0
    • +5
    ./java/org/trafodion/wms/MediumTests.java
    • -0
    • +141
    ./java/org/trafodion/wms/MemoryMapTest.java
    • -0
    • +5
    ./java/org/trafodion/wms/SmallTests.java
    • -0
    • +258
    ./java/org/trafodion/wms/ZkDataTest.java
    • -0
    • +130
    ./java/org/trafodion/wms/ZkStatsTest.java
    • -0
    • +379
    ./resources/wms-default.xml
  1. … 178 more files in changeset.
DCS Initial Code Drop

Change-Id: I823bdb655c9c1d0dc8266b8efaecedb094624edd

    • -0
    • +53
    ./java/org/trafodion/dcs/AppTest.java
    • -0
    • +195
    ./java/org/trafodion/dcs/IntegrationTestEndurance.java
    • -0
    • +20
    ./java/org/trafodion/dcs/IntegrationTests.java
    • -0
    • +7
    ./pytests/.config.ini.tmpl
    • -0
    • +24
    ./pytests/.env.sh.tmpl
    • -0
    • +30
    ./pytests/.odbc.ini.tmpl
    • -0
    • +9
    ./pytests/.odbcinst.ini.tmpl
    • -0
    • +49
    ./pytests/.tox.ini.tmpl
    • -0
    • +146
    ./pytests/README.rst
    • -0
    • +278
    ./pytests/config.sh
    • -0
    • +11
    ./pytests/test-requirements.txt
    • -0
    • +263
    ./pytests/test_p2.py
    • -0
    • +85
    ./resources/dcs-default.xml
  1. … 106 more files in changeset.
Updated files to accommodate JDBC T2/T4 changes for Trafodion

Updated files to use the new T2/T4 jar file names, urls, and driver names. The JDBC changes have been checked into the datalake branch (v38027). Phoenix tests with this commit work for v38027 or higher revision number for the datalake branch.

T2:

JarFileName: jdbcMx.jar -> jdbcT2.jar

URL: jdbc:sqlmx: -> jdbc:sql:

DriverName: com.hp.sqlmx.SQLMXDrver -> org.trafodion.sql.T2Driver

Change-Id: I6c1ed66a0907dc345a44c2c2b50d10d9c370598f

T4:

JarFileName: hpt4jdbc.jar -> jdbcT4.jar

URL: jdbc:hpt4jdbc://server:port/: -> jdbc:t4jdbc://server:port/:

DriverName: com.hp.jdbc.HPT4Driver->org.trafodion.jdbc.t4.T4Driver

  1. … 2 more files in changeset.
Changed 10 java files to cope with the new behavior that a DDL statement now returns the error .ERROR[20124] This DDL operation cannot be performed if AUTOCOMMIT is OFF. when the test calls conn.setAutoCommit(false) to turn off the transactional auto-commit prior to the execution of a DLL statement. Trafodion currently does not support DDL statements in a transaction. It previously tolerated them even if the user couldn.t actually roll it back. But it has recently changed its behavior to return an error. DDLs in a transaction may be supported in the future. But for now, the tests need to make sure that all DDLs are run only when auto-commit is turned on.

Change-Id: I3eca2322825c8eb8d4e2e2486d72d893b941b76f