[NO ISSUE][TEST] Migrate feed test cases from AQL to SQLPP - user model changes: no - storage format changes: no - interface changes: no
Details: Moved all feed test cases from AQL to SQLPP with syntax adaptations. Change-Id: I06d20b09912735003b76df0e337cadf1a7551a97 Reviewed-on: https://asterix-gerrit.ics.uci.edu/2304 Sonar-Qube: Jenkins <jenk...@fulliautomatix.ics.uci.edu> Tested-by: Jenkins <jenk...@fulliautomatix.ics.uci.edu> Contrib: Jenkins <jenk...@fulliautomatix.ics.uci.edu> Reviewed-by: Steven Jacobs <sjaco...@ucr.edu> Integration-Tests: Jenkins <jenk...@fulliautomatix.ics.uci.edu> Project: http://git-wip-us.apache.org/repos/asf/asterixdb/repo Commit: http://git-wip-us.apache.org/repos/asf/asterixdb/commit/ca8d0830 Tree: http://git-wip-us.apache.org/repos/asf/asterixdb/tree/ca8d0830 Diff: http://git-wip-us.apache.org/repos/asf/asterixdb/diff/ca8d0830 Branch: refs/heads/master Commit: ca8d0830ea6d097fe0ae26348a893a904151dc63 Parents: 86a12d5 Author: Xikui Wang <xkk...@gmail.com> Authored: Mon Feb 12 12:01:27 2018 -0800 Committer: Xikui Wang <xkk...@gmail.com> Committed: Wed Feb 14 11:51:25 2018 -0800 ---------------------------------------------------------------------- .../queries/feeds/PLEASE_ADD_SQLPP_TEST_CASE | 18 ++ .../change-feed-with-meta-csv.1.ddl.aql | 62 ----- .../change-feed-with-meta-csv.2.update.aql | 29 --- .../change-feed-with-meta-csv.3.query.aql | 30 --- .../change-feed-with-meta-csv.4.ddl.aql | 24 -- ...-feed-with-meta-open-index-in-meta.1.ddl.aql | 60 ----- ...-feed-with-meta-open-index-in-meta.2.ddl.aql | 26 --- ...meta-pk-in-meta-index-after-ingest.1.ddl.aql | 58 ----- ...a-pk-in-meta-index-after-ingest.2.update.aql | 30 --- ...meta-pk-in-meta-index-after-ingest.3.ddl.aql | 27 --- ...ta-pk-in-meta-index-after-ingest.4.query.aql | 31 --- ...meta-pk-in-meta-index-after-ingest.5.ddl.aql | 25 -- ...with-meta-pk-in-meta-index-in-meta.1.ddl.aql | 60 ----- ...h-meta-pk-in-meta-index-in-meta.2.update.aql | 30 --- ...th-meta-pk-in-meta-index-in-meta.3.query.aql | 31 --- ...with-meta-pk-in-meta-index-in-meta.4.ddl.aql | 25 -- ...ta-index-with-missing-after-ingest.1.ddl.aql | 58 ----- ...index-with-missing-after-ingest.2.update.aql | 30 --- ...ta-index-with-missing-after-ingest.3.ddl.aql | 27 --- ...-index-with-missing-after-ingest.4.query.aql | 31 --- ...ta-index-with-missing-after-ingest.5.ddl.aql | 25 -- ...eta-pk-in-meta-open-index-in-value.1.ddl.aql | 60 ----- ...-pk-in-meta-open-index-in-value.2.update.aql | 30 --- ...a-pk-in-meta-open-index-in-value.3.query.aql | 29 --- ...eta-pk-in-meta-open-index-in-value.4.ddl.aql | 25 -- ...pk-in-meta-open-index-with-missing.1.ddl.aql | 60 ----- ...in-meta-open-index-with-missing.2.update.aql | 30 --- ...-in-meta-open-index-with-missing.3.query.aql | 29 --- ...pk-in-meta-open-index-with-missing.4.ddl.aql | 25 -- .../change-feed-with-meta-pk-in-meta.1.ddl.aql | 57 ----- ...hange-feed-with-meta-pk-in-meta.2.update.aql | 29 --- ...change-feed-with-meta-pk-in-meta.3.query.aql | 29 --- ...change-feed-with-meta-pk-in-meta.4.query.aql | 30 --- ...change-feed-with-meta-pk-in-meta.5.query.aql | 34 --- .../change-feed-with-meta-pk-in-meta.6.ddl.aql | 24 -- ...ge-feed-with-meta-with-mixed-index.1.ddl.aql | 61 ----- ...feed-with-meta-with-mixed-index.2.update.aql | 30 --- ...-feed-with-meta-with-mixed-index.3.query.aql | 30 --- ...ge-feed-with-meta-with-mixed-index.4.ddl.aql | 25 -- .../feeds/change-feed/change-feed.1.ddl.aql | 44 ---- .../feeds/change-feed/change-feed.2.update.aql | 29 --- .../feeds/change-feed/change-feed.3.query.aql | 29 --- .../feeds/change-feed/change-feed.4.ddl.aql | 24 -- .../connect-feed-with-function.1.ddl.aql | 57 ----- .../connect-feed-with-function.2.update.aql | 32 --- .../connect-feed-with-function.3.ddl.aql | 27 --- .../feeds/connect-feed/connect-feed.0.ddl.aql | 46 ---- .../connect-feed/connect-feed.1.update.aql | 29 --- .../connect-feed/connect-feed.2.update.aql | 20 -- .../feeds/connect-feed/connect-feed.3.query.aql | 20 -- .../feeds/connect-feed/connect-feed.4.ddl.aql | 19 -- .../connect-live-feed.0.ddl.aql | 40 ---- .../connect-live-feed.1.update.aql | 21 -- .../connect-live-feed.2.sleep.aql | 19 -- .../connect-live-feed.3.update.aql | 21 -- .../create-feed-with-policy.1.ddl.aql | 58 ----- .../create-feed-with-policy.2.update.aql | 32 --- .../create-feed-with-policy.3.server.aql | 26 --- .../create-feed-with-policy.4.sleep.aql | 26 --- .../create-feed-with-policy.5.update.aql | 29 --- .../create-feed-with-policy.6.query.aql | 31 --- .../create-feed-with-policy.7.server.aql | 27 --- .../create-feed-with-policy.8.ddl.aql | 28 --- .../create-policy-from-file.1.ddl.aql | 29 --- .../create-policy-from-file.2.query.aql | 27 --- .../create-policy-from-file.3.ddl.aql | 27 --- .../disconnect-live-feed.0.ddl.aql | 41 ---- .../disconnect-live-feed.1.update.aql | 21 -- .../disconnect-live-feed.2.sleep.aql | 19 -- .../disconnect-live-feed.3.update.aql | 21 -- ...p-dataverse-with-disconnected-feed.1.ddl.aql | 54 ----- ...ataverse-with-disconnected-feed.2.update.aql | 29 --- ...p-dataverse-with-disconnected-feed.3.ddl.aql | 26 --- ...taverse-with-function-used-by-feed.1.ddl.aql | 26 --- ...taverse-with-function-used-by-feed.2.ddl.aql | 39 ---- ...erse-with-function-used-by-feed.3.update.aql | 23 -- ...taverse-with-function-used-by-feed.4.ddl.aql | 20 -- ...op-function-no-longer-used-by-feed.1.ddl.aql | 44 ---- ...function-no-longer-used-by-feed.2.update.aql | 24 -- ...op-function-no-longer-used-by-feed.3.ddl.aql | 21 -- .../drop-function-used-by-feed.1.ddl.aql | 44 ---- .../drop-function-used-by-feed.2.update.aql | 23 -- .../drop-function-used-by-feed.3.ddl.aql | 21 -- .../drop-nonexistent-feed.1.ddl.aql | 28 --- .../feed-push-socket/feed-push-socket.1.ddl.aql | 58 ----- .../feed-push-socket.2.update.aql | 32 --- .../feed-push-socket.3.server.aql | 26 --- .../feed-push-socket.4.sleep.aql | 26 --- .../feed-push-socket.5.update.aql | 29 --- .../feed-push-socket.6.query.aql | 31 --- .../feed-push-socket.7.server.aql | 27 --- .../feed-push-socket/feed-push-socket.8.ddl.aql | 28 --- .../feed-with-external-function.1.ddl.aql | 58 ----- .../feed-with-external-function.2.lib.aql | 20 -- .../feed-with-external-function.3.update.aql | 35 --- .../feed-with-external-function.5.pollquery.aql | 33 --- .../feed-with-external-function.6.lib.aql | 19 -- .../feed-with-external-function.7.ddl.aql | 19 -- ...th-external-parser-with-open-index.1.ddl.aql | 33 --- ...th-external-parser-with-open-index.2.lib.aql | 26 --- ...th-external-parser-with-open-index.3.ddl.aql | 37 --- ...external-parser-with-open-index.4.update.aql | 33 --- ...-external-parser-with-open-index.5.query.aql | 30 --- ...th-external-parser-with-open-index.6.lib.aql | 26 --- ...th-external-parser-with-open-index.7.ddl.aql | 26 --- ...ernal-parser-with-two-open-indexes.1.ddl.aql | 33 --- ...ernal-parser-with-two-open-indexes.2.lib.aql | 26 --- ...ernal-parser-with-two-open-indexes.3.ddl.aql | 38 ---- ...al-parser-with-two-open-indexes.4.update.aql | 33 --- ...nal-parser-with-two-open-indexes.5.query.aql | 30 --- ...ernal-parser-with-two-open-indexes.6.lib.aql | 26 --- ...ernal-parser-with-two-open-indexes.7.ddl.aql | 26 --- .../feed-with-external-parser.1.ddl.aql | 32 --- .../feed-with-external-parser.2.lib.aql | 19 -- .../feed-with-external-parser.3.ddl.aql | 35 --- .../feed-with-external-parser.4.update.aql | 32 --- .../feed-with-external-parser.5.query.aql | 29 --- .../feed-with-external-parser.6.lib.aql | 19 -- .../feed-with-external-parser.7.ddl.aql | 25 -- .../feed-with-filtered-dataset.1.ddl.aql | 47 ---- .../feed-with-filtered-dataset.2.update.aql | 29 --- .../feed-with-filtered-dataset.3.query.aql | 29 --- .../feed-with-filtered-dataset.4.ddl.aql | 25 -- .../feed-with-meta-pk-in-meta.1.ddl.aql | 56 ----- .../feed-with-meta-pk-in-meta.2.update.aql | 29 --- .../feed-with-meta-pk-in-meta.3.query.aql | 29 --- .../feed-with-meta-pk-in-meta.4.query.aql | 29 --- .../feed-with-meta-pk-in-meta.5.ddl.aql | 24 -- .../feed-with-multiple-indexes.1.ddl.aql | 49 ---- .../feed-with-multiple-indexes.2.lib.aql | 19 -- .../feed-with-multiple-indexes.3.ddl.aql | 34 --- .../feed-with-multiple-indexes.4.update.aql | 32 --- .../feed-with-multiple-indexes.5.query.aql | 29 --- .../feed-with-multiple-indexes.6.lib.aql | 19 -- .../feed-with-multiple-indexes.7.ddl.aql | 25 -- .../feed-with-undefined-function.1.ddl.aql | 40 ---- .../feed-with-undefined-function.2.update.aql | 26 --- .../queries/feeds/feeds_01/feeds_01.1.ddl.aql | 45 ---- .../feeds/feeds_01/feeds_01.2.update.aql | 24 -- .../queries/feeds/feeds_01/feeds_01.3.query.aql | 27 --- .../queries/feeds/feeds_02/feeds_02.1.ddl.aql | 48 ---- .../feeds/feeds_02/feeds_02.2.update.aql | 32 --- .../queries/feeds/feeds_02/feeds_02.3.query.aql | 30 --- .../queries/feeds/feeds_03/feeds_03.1.ddl.aql | 51 ----- .../feeds/feeds_03/feeds_03.2.update.aql | 28 --- .../queries/feeds/feeds_03/feeds_03.3.query.aql | 28 --- .../queries/feeds/feeds_07/feeds_07.1.ddl.aql | 66 ------ .../feeds/feeds_07/feeds_07.2.update.aql | 36 --- .../queries/feeds/feeds_07/feeds_07.3.query.aql | 40 ---- .../queries/feeds/feeds_08/feeds_08.1.ddl.aql | 70 ------ .../feeds/feeds_08/feeds_08.2.update.aql | 38 ---- .../queries/feeds/feeds_08/feeds_08.3.query.aql | 42 ---- .../queries/feeds/feeds_08/feeds_08.4.sleep.aql | 31 --- .../queries/feeds/feeds_09/feeds_09.1.ddl.aql | 67 ------ .../feeds/feeds_09/feeds_09.2.update.aql | 36 --- .../queries/feeds/feeds_09/feeds_09.3.query.aql | 40 ---- .../queries/feeds/feeds_09/feeds_09.4.ddl.aql | 30 --- .../queries/feeds/feeds_10/feeds_10.1.ddl.aql | 52 ----- .../feeds/feeds_10/feeds_10.2.update.aql | 35 --- .../queries/feeds/feeds_10/feeds_10.3.query.aql | 34 --- .../queries/feeds/feeds_10/feeds_10.4.ddl.aql | 30 --- .../queries/feeds/feeds_11/feeds_11.1.ddl.aql | 47 ---- .../feeds/feeds_11/feeds_11.2.update.aql | 32 --- .../queries/feeds/feeds_11/feeds_11.3.query.aql | 29 --- .../queries/feeds/feeds_12/feeds_12.1.ddl.aql | 50 ---- .../feeds/feeds_12/feeds_12.2.update.aql | 32 --- .../queries/feeds/feeds_12/feeds_12.3.query.aql | 29 --- .../queries/feeds/feeds_12/feeds_12.4.ddl.aql | 30 --- .../feeds/insert-feed/insert-feed.1.ddl.aql | 45 ---- .../feeds/insert-feed/insert-feed.2.update.aql | 24 -- .../feeds/insert-feed/insert-feed.3.server.aql | 19 -- .../feeds/insert-feed/insert-feed.4.sleep.aql | 19 -- .../feeds/insert-feed/insert-feed.5.update.aql | 21 -- .../feeds/insert-feed/insert-feed.6.query.aql | 24 -- .../feeds/insert-feed/insert-feed.7.server.aql | 20 -- .../feeds/insert-feed/insert-feed.8.ddl.aql | 20 -- .../issue_230_feeds/issue_230_feeds.1.ddl.aql | 47 ---- .../issue_230_feeds.2.update.aql | 32 --- .../issue_230_feeds/issue_230_feeds.3.query.aql | 29 --- .../issue_230_feeds/issue_230_feeds.4.ddl.aql | 30 --- .../push-socket-with-auuid.1.ddl.aql | 71 ------ .../push-socket-with-auuid.2.update.aql | 35 --- .../push-socket-with-auuid.3.server.aql | 27 --- .../push-socket-with-auuid.4.sleep.aql | 27 --- .../push-socket-with-auuid.5.update.aql | 32 --- .../push-socket-with-auuid.6.query.aql | 37 --- .../push-socket-with-auuid.7.server.aql | 28 --- .../push-socket-with-auuid.8.ddl.aql | 29 --- ...reader-with-malformed-input-stream.1.ddl.aql | 34 --- ...der-with-malformed-input-stream.2.update.aql | 25 -- ...ader-with-malformed-input-stream.4.sleep.aql | 19 -- ...der-with-malformed-input-stream.5.update.aql | 22 -- ...ader-with-malformed-input-stream.6.query.aql | 23 -- ...reader-with-malformed-input-stream.8.ddl.aql | 21 -- .../revised-tweet-parser.1.ddl.aql | 57 ----- .../revised-tweet-parser.2.update.aql | 24 -- .../feeds/start-feed/start-feed.1.ddl.aql | 59 ----- .../feeds/start-feed/start-feed.2.update.aql | 33 --- .../feeds/start-feed/start-feed.3.server.aql | 26 --- .../feeds/start-feed/start-feed.4.sleep.aql | 26 --- .../feeds/start-feed/start-feed.5.update.aql | 30 --- .../feeds/start-feed/start-feed.6.query.aql | 32 --- .../feeds/start-feed/start-feed.7.server.aql | 27 --- .../feeds/start-feed/start-feed.8.ddl.aql | 28 --- .../start-started-feed.0.ddl.aql | 40 ---- .../start-started-feed.1.update.aql | 21 -- .../start-started-feed.2.sleep.aql | 26 --- .../start-started-feed.3.update.aql | 21 -- .../start-started-feed.4.ddl.aql | 21 -- .../stop-stopped-feed.0.ddl.aql | 41 ---- .../stop-stopped-feed.1.update.aql | 21 -- .../stop-stopped-feed.2.sleep.aql | 19 -- .../stop-stopped-feed.3.update.aql | 21 -- .../stop-stopped-feed.4.sleep.aql | 20 -- .../stop-stopped-feed.5.update.aql | 21 -- .../feeds/twitter-feed/twitter-feed.1.ddl.aql | 56 ----- .../twitter-feed/twitter-feed.2.update.aql | 27 --- .../change-feed-with-meta-csv.1.ddl.sqlpp | 62 +++++ .../change-feed-with-meta-csv.2.update.sqlpp | 29 +++ .../change-feed-with-meta-csv.3.query.sqlpp | 26 +++ .../change-feed-with-meta-csv.4.ddl.sqlpp | 24 ++ ...eed-with-meta-open-index-in-meta.1.ddl.sqlpp | 60 +++++ ...eed-with-meta-open-index-in-meta.2.ddl.sqlpp | 26 +++ ...ta-pk-in-meta-index-after-ingest.1.ddl.sqlpp | 58 +++++ ...pk-in-meta-index-after-ingest.2.update.sqlpp | 30 +++ ...ta-pk-in-meta-index-after-ingest.3.ddl.sqlpp | 27 +++ ...-pk-in-meta-index-after-ingest.4.query.sqlpp | 28 +++ ...ta-pk-in-meta-index-after-ingest.5.ddl.sqlpp | 25 ++ ...th-meta-pk-in-meta-index-in-meta.1.ddl.sqlpp | 60 +++++ ...meta-pk-in-meta-index-in-meta.2.update.sqlpp | 30 +++ ...-meta-pk-in-meta-index-in-meta.3.query.sqlpp | 29 +++ ...th-meta-pk-in-meta-index-in-meta.4.ddl.sqlpp | 25 ++ ...-index-with-missing-after-ingest.1.ddl.sqlpp | 58 +++++ ...dex-with-missing-after-ingest.2.update.sqlpp | 30 +++ ...-index-with-missing-after-ingest.3.ddl.sqlpp | 27 +++ ...ndex-with-missing-after-ingest.4.query.sqlpp | 29 +++ ...-index-with-missing-after-ingest.5.ddl.sqlpp | 25 ++ ...a-pk-in-meta-open-index-in-value.1.ddl.sqlpp | 60 +++++ ...k-in-meta-open-index-in-value.2.update.sqlpp | 30 +++ ...pk-in-meta-open-index-in-value.3.query.sqlpp | 29 +++ ...a-pk-in-meta-open-index-in-value.4.ddl.sqlpp | 25 ++ ...-in-meta-open-index-with-missing.1.ddl.sqlpp | 60 +++++ ...-meta-open-index-with-missing.2.update.sqlpp | 30 +++ ...n-meta-open-index-with-missing.3.query.sqlpp | 29 +++ ...-in-meta-open-index-with-missing.4.ddl.sqlpp | 25 ++ ...change-feed-with-meta-pk-in-meta.1.ddl.sqlpp | 57 +++++ ...nge-feed-with-meta-pk-in-meta.2.update.sqlpp | 29 +++ ...ange-feed-with-meta-pk-in-meta.3.query.sqlpp | 26 +++ ...ange-feed-with-meta-pk-in-meta.4.query.sqlpp | 26 +++ ...ange-feed-with-meta-pk-in-meta.5.query.sqlpp | 29 +++ ...change-feed-with-meta-pk-in-meta.6.ddl.sqlpp | 24 ++ ...-feed-with-meta-with-mixed-index.1.ddl.sqlpp | 61 +++++ ...ed-with-meta-with-mixed-index.2.update.sqlpp | 30 +++ ...eed-with-meta-with-mixed-index.3.query.sqlpp | 29 +++ ...-feed-with-meta-with-mixed-index.4.ddl.sqlpp | 25 ++ .../feeds/change-feed/change-feed.1.ddl.sqlpp | 44 ++++ .../change-feed/change-feed.2.update.sqlpp | 29 +++ .../feeds/change-feed/change-feed.3.query.sqlpp | 29 +++ .../feeds/change-feed/change-feed.4.ddl.sqlpp | 24 ++ .../feeds/connect-feed/connect-feed.0.ddl.sqlpp | 46 ++++ .../connect-feed/connect-feed.1.update.sqlpp | 29 +++ .../connect-feed/connect-feed.2.update.sqlpp | 20 ++ .../connect-feed/connect-feed.3.query.sqlpp | 21 ++ .../feeds/connect-feed/connect-feed.4.ddl.sqlpp | 19 ++ .../connect-live-feed.0.ddl.sqlpp | 40 ++++ .../connect-live-feed.1.update.sqlpp | 21 ++ .../connect-live-feed.2.sleep.sqlpp | 19 ++ .../connect-live-feed.3.update.sqlpp | 21 ++ .../connect-live-feed.4.ddl.sqlpp | 20 ++ .../create-feed-with-policy.1.ddl.sqlpp | 58 +++++ .../create-feed-with-policy.2.update.sqlpp | 32 +++ .../create-feed-with-policy.3.server.sqlpp | 26 +++ .../create-feed-with-policy.4.sleep.sqlpp | 26 +++ .../create-feed-with-policy.5.update.sqlpp | 29 +++ .../create-feed-with-policy.6.query.sqlpp | 31 +++ .../create-feed-with-policy.7.server.sqlpp | 27 +++ .../create-feed-with-policy.8.ddl.sqlpp | 28 +++ .../disconnect-live-feed.0.ddl.sqlpp | 41 ++++ .../disconnect-live-feed.1.update.sqlpp | 21 ++ .../disconnect-live-feed.2.sleep.sqlpp | 19 ++ .../disconnect-live-feed.3.update.sqlpp | 21 ++ .../disconnect-live-feed.4.ddl.sqlpp | 20 ++ ...dataverse-with-disconnected-feed.1.ddl.sqlpp | 54 +++++ ...averse-with-disconnected-feed.2.update.sqlpp | 29 +++ ...dataverse-with-disconnected-feed.3.ddl.sqlpp | 26 +++ ...verse-with-function-used-by-feed.1.ddl.sqlpp | 25 ++ ...verse-with-function-used-by-feed.2.ddl.sqlpp | 39 ++++ ...se-with-function-used-by-feed.3.update.sqlpp | 23 ++ ...verse-with-function-used-by-feed.4.ddl.sqlpp | 20 ++ ...-function-no-longer-used-by-feed.1.ddl.sqlpp | 43 ++++ ...nction-no-longer-used-by-feed.2.update.sqlpp | 24 ++ ...-function-no-longer-used-by-feed.3.ddl.sqlpp | 21 ++ ...-function-no-longer-used-by-feed.4.ddl.sqlpp | 19 ++ .../drop-function-used-by-feed.1.ddl.sqlpp | 43 ++++ .../drop-function-used-by-feed.2.update.sqlpp | 23 ++ .../drop-function-used-by-feed.3.ddl.sqlpp | 21 ++ .../drop-function-used-by-feed.4.ddl.sqlpp | 19 ++ .../drop-nonexistent-feed.1.ddl.sqlpp | 28 +++ .../drop-nonexistent-feed.2.ddl.sqlpp | 24 ++ .../feed-push-socket.1.ddl.sqlpp | 58 +++++ .../feed-push-socket.2.update.sqlpp | 32 +++ .../feed-push-socket.3.server.sqlpp | 26 +++ .../feed-push-socket.4.sleep.sqlpp | 26 +++ .../feed-push-socket.5.update.sqlpp | 29 +++ .../feed-push-socket.6.query.sqlpp | 30 +++ .../feed-push-socket.7.server.sqlpp | 27 +++ .../feed-push-socket.8.ddl.sqlpp | 28 +++ ...-external-parser-with-open-index.1.ddl.sqlpp | 33 +++ ...-external-parser-with-open-index.2.lib.sqlpp | 26 +++ ...-external-parser-with-open-index.3.ddl.sqlpp | 37 +++ ...ternal-parser-with-open-index.4.update.sqlpp | 33 +++ ...xternal-parser-with-open-index.5.query.sqlpp | 28 +++ ...-external-parser-with-open-index.6.lib.sqlpp | 26 +++ ...-external-parser-with-open-index.7.ddl.sqlpp | 26 +++ ...nal-parser-with-two-open-indexes.1.ddl.sqlpp | 33 +++ ...nal-parser-with-two-open-indexes.2.lib.sqlpp | 26 +++ ...nal-parser-with-two-open-indexes.3.ddl.sqlpp | 38 ++++ ...-parser-with-two-open-indexes.4.update.sqlpp | 33 +++ ...l-parser-with-two-open-indexes.5.query.sqlpp | 28 +++ ...nal-parser-with-two-open-indexes.6.lib.sqlpp | 26 +++ ...nal-parser-with-two-open-indexes.7.ddl.sqlpp | 26 +++ .../feed-with-external-parser.1.ddl.sqlpp | 32 +++ .../feed-with-external-parser.2.lib.sqlpp | 19 ++ .../feed-with-external-parser.3.ddl.sqlpp | 35 +++ .../feed-with-external-parser.4.update.sqlpp | 32 +++ .../feed-with-external-parser.5.query.sqlpp | 28 +++ .../feed-with-external-parser.6.lib.sqlpp | 19 ++ .../feed-with-external-parser.7.ddl.sqlpp | 25 ++ .../feed-with-filtered-dataset.1.ddl.sqlpp | 47 ++++ .../feed-with-filtered-dataset.2.update.sqlpp | 29 +++ .../feed-with-filtered-dataset.3.query.sqlpp | 28 +++ .../feed-with-filtered-dataset.4.ddl.sqlpp | 25 ++ .../feed-with-meta-pk-in-meta.1.ddl.sqlpp | 56 +++++ .../feed-with-meta-pk-in-meta.2.update.sqlpp | 29 +++ .../feed-with-meta-pk-in-meta.3.query.sqlpp | 29 +++ .../feed-with-meta-pk-in-meta.4.query.sqlpp | 29 +++ .../feed-with-meta-pk-in-meta.5.ddl.sqlpp | 24 ++ .../feed-with-multiple-indexes.1.ddl.sqlpp | 49 ++++ .../feed-with-multiple-indexes.2.lib.sqlpp | 19 ++ .../feed-with-multiple-indexes.3.ddl.sqlpp | 34 +++ .../feed-with-multiple-indexes.4.update.sqlpp | 32 +++ .../feed-with-multiple-indexes.5.query.sqlpp | 28 +++ .../feed-with-multiple-indexes.6.lib.sqlpp | 19 ++ .../feed-with-multiple-indexes.7.ddl.sqlpp | 25 ++ .../feed-with-undefined-function.1.ddl.sqlpp | 40 ++++ .../feed-with-undefined-function.2.update.sqlpp | 26 +++ .../feed-with-undefined-function.3.ddl.sqlpp | 20 ++ .../push-socket-with-auuid.1.ddl.sqlpp | 71 ++++++ .../push-socket-with-auuid.2.update.sqlpp | 35 +++ .../push-socket-with-auuid.3.server.sqlpp | 27 +++ .../push-socket-with-auuid.4.sleep.sqlpp | 27 +++ .../push-socket-with-auuid.5.update.sqlpp | 32 +++ .../push-socket-with-auuid.6.query.sqlpp | 32 +++ .../push-socket-with-auuid.7.server.sqlpp | 28 +++ .../push-socket-with-auuid.8.ddl.sqlpp | 29 +++ ...ader-with-malformed-input-stream.1.ddl.sqlpp | 34 +++ ...r-with-malformed-input-stream.2.update.sqlpp | 25 ++ ...er-with-malformed-input-stream.4.sleep.sqlpp | 19 ++ ...r-with-malformed-input-stream.5.update.sqlpp | 22 ++ ...er-with-malformed-input-stream.6.query.sqlpp | 22 ++ ...ader-with-malformed-input-stream.8.ddl.sqlpp | 21 ++ .../revised-tweet-parser.1.ddl.sqlpp | 57 +++++ .../revised-tweet-parser.2.update.sqlpp | 24 ++ .../revised-tweet-parser.3.ddl.sqlpp | 30 +++ .../feeds/start-feed/start-feed.1.ddl.sqlpp | 59 +++++ .../feeds/start-feed/start-feed.2.update.sqlpp | 33 +++ .../feeds/start-feed/start-feed.3.server.sqlpp | 26 +++ .../feeds/start-feed/start-feed.4.sleep.sqlpp | 26 +++ .../feeds/start-feed/start-feed.5.update.sqlpp | 30 +++ .../feeds/start-feed/start-feed.6.query.sqlpp | 29 +++ .../feeds/start-feed/start-feed.7.server.sqlpp | 27 +++ .../feeds/start-feed/start-feed.8.ddl.sqlpp | 28 +++ .../start-started-feed.0.ddl.sqlpp | 40 ++++ .../start-started-feed.1.update.sqlpp | 21 ++ .../start-started-feed.2.sleep.sqlpp | 26 +++ .../start-started-feed.3.update.sqlpp | 21 ++ .../start-started-feed.4.ddl.sqlpp | 21 ++ .../stop-stopped-feed.0.ddl.sqlpp | 41 ++++ .../stop-stopped-feed.1.update.sqlpp | 21 ++ .../stop-stopped-feed.2.sleep.sqlpp | 19 ++ .../stop-stopped-feed.3.update.sqlpp | 21 ++ .../stop-stopped-feed.4.sleep.sqlpp | 20 ++ .../stop-stopped-feed.5.update.sqlpp | 21 ++ .../stop-stopped-feed.6.ddl.sqlpp | 20 ++ .../feeds/twitter-feed/twitter-feed.1.ddl.sqlpp | 56 +++++ .../twitter-feed/twitter-feed.2.update.sqlpp | 27 +++ .../feeds/twitter-feed/twitter-feed.3.ddl.sqlpp | 24 ++ .../src/test/resources/runtimets/testsuite.xml | 227 ------------------- .../test/resources/runtimets/testsuite_it.xml | 27 --- .../resources/runtimets/testsuite_it_sqlpp.xml | 27 +++ .../resources/runtimets/testsuite_sqlpp.xml | 167 ++++++++++++++ asterixdb/asterix-server/pom.xml | 8 + 392 files changed, 5439 insertions(+), 7242 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/PLEASE_ADD_SQLPP_TEST_CASE ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/PLEASE_ADD_SQLPP_TEST_CASE b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/PLEASE_ADD_SQLPP_TEST_CASE new file mode 100644 index 0000000..042f3ce --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/PLEASE_ADD_SQLPP_TEST_CASE @@ -0,0 +1,18 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, + * software distributed under the License is distributed on an + * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + * KIND, either express or implied. See the License for the + * specific language governing permissions and limitations + * under the License. + */ http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-csv/change-feed-with-meta-csv.1.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-csv/change-feed-with-meta-csv.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-csv/change-feed-with-meta-csv.1.ddl.aql deleted file mode 100644 index 965605a..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-csv/change-feed-with-meta-csv.1.ddl.aql +++ /dev/null @@ -1,62 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"; you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a dataset with meta part and attempt to load the csv file using localFS change feed - * Expected Res : Success - * Date : 19th Nov 2017 - */ - drop dataverse test if exists; - create dataverse test; - use dataverse test; - - create type TestType as closed { - test: string - } - create type MetaType as { - id:int - } - -create dataset TestDS(TestType) with meta(MetaType) primary key meta().id; -create index TestIdx on TestDS(test); -drop feed TestFeed if exists; - -create feed TestFeed with { - "adapter-name" : "localfs", - "parser" : "record-with-metadata", - "reader" : "localfs", - "path" : "asterix_nc1://target/data/csv/change_feed.csv", - //type of the record - "type-name" : "TestType", - //type of the meta record - "meta-type-name" : "MetaType", - //format of the record - "record-format" : "adm", - // format of the meta record - "format" : "csv", - "delimiter" : ",", - // index of the primary key the record (meta or orig) - "key-indexes" : "0", - // indicates that PK originates from meta - "key-indicators" : "1", - //index of the record in the meta record - "record-index" : "1", - "change-feed" : "true", - // whether CSV header is present in the input - "header" : "false" -}; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-csv/change-feed-with-meta-csv.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-csv/change-feed-with-meta-csv.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-csv/change-feed-with-meta-csv.2.update.aql deleted file mode 100644 index da5331a..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-csv/change-feed-with-meta-csv.2.update.aql +++ /dev/null @@ -1,29 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a dataset with meta part and attempt to load the csv file using localFS change feed - * Expected Res : Success - * Date : 19th Nov 2017 - */ - use dataverse test; - - set wait-for-completion-feed "true"; - connect feed TestFeed to dataset TestDS; - - start feed TestFeed; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-csv/change-feed-with-meta-csv.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-csv/change-feed-with-meta-csv.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-csv/change-feed-with-meta-csv.3.query.aql deleted file mode 100644 index 317ab90..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-csv/change-feed-with-meta-csv.3.query.aql +++ /dev/null @@ -1,30 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a dataset with meta part and attempt to load the csv file using localFS change feed - * Expected Res : Success - * Date : 19th Nov 2017 - */ - use dataverse test; - - for $x in dataset TestDS - return { - "record": $x, - "id": meta().id - } \ No newline at end of file http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-csv/change-feed-with-meta-csv.4.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-csv/change-feed-with-meta-csv.4.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-csv/change-feed-with-meta-csv.4.ddl.aql deleted file mode 100644 index 21697d6..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-csv/change-feed-with-meta-csv.4.ddl.aql +++ /dev/null @@ -1,24 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a dataset with meta part and attempt to load the csv file using localFS change feed - * Expected Res : Success - * Date : 19th Nov 2017 - */ - drop dataverse test; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-open-index-in-meta/change-feed-with-meta-open-index-in-meta.1.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-open-index-in-meta/change-feed-with-meta-open-index-in-meta.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-open-index-in-meta/change-feed-with-meta-open-index-in-meta.1.ddl.aql deleted file mode 100644 index 58f2091..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-open-index-in-meta/change-feed-with-meta-open-index-in-meta.1.ddl.aql +++ /dev/null @@ -1,60 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a dataset with meta part and attempt to - * build a secondary index on an open meta field - * Expected Res : Failure - * Date : 18th Jun 2016 - */ - -drop dataverse KeyVerse if exists; -create dataverse KeyVerse; -use dataverse KeyVerse; - -create type DocumentType as open{ -}; - -create type KVMetaType as open{ -"key":string, -vbucket:int32, -seq:int64, -cas:int64, -expiration:int32, -flags:int32, -revSeq:int64, -lockTime:int32 -}; - -create dataset KVStore(DocumentType) with meta(KVMetaType)primary key meta()."key"; - -create feed KVChangeStream with { - "adapter-name" : "adapter", - "type-name" : "DocumentType", - "meta-type-name" : "KVMetaType", - "reader" : "org.apache.asterix.external.input.record.reader.kv.KVTestReaderFactory", - "parser" : "record-with-metadata", - "format" : "dcp", - "record-format" : "json", - "change-feed" : "true", - "key-indexes" : "0", - "key-indicators" : "1", - "num-of-records" : "1000" -}; - -create index OpenIndex on KVStore(meta().id:int32?) enforced; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-open-index-in-meta/change-feed-with-meta-open-index-in-meta.2.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-open-index-in-meta/change-feed-with-meta-open-index-in-meta.2.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-open-index-in-meta/change-feed-with-meta-open-index-in-meta.2.ddl.aql deleted file mode 100644 index dec8611..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-open-index-in-meta/change-feed-with-meta-open-index-in-meta.2.ddl.aql +++ /dev/null @@ -1,26 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a dataset with meta part and attempt to - * build a secondary index on an open meta field - * Expected Res : Failure - * Date : 18th Jun 2016 - */ - -drop dataverse KeyVerse; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-after-ingest/change-feed-with-meta-pk-in-meta-index-after-ingest.1.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-after-ingest/change-feed-with-meta-pk-in-meta-index-after-ingest.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-after-ingest/change-feed-with-meta-pk-in-meta-index-after-ingest.1.ddl.aql deleted file mode 100644 index 4f4ea0f..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-after-ingest/change-feed-with-meta-pk-in-meta-index-after-ingest.1.ddl.aql +++ /dev/null @@ -1,58 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a change feed with meta-data, ingest some records then - * build a secondary index after the dataset has data - * Expected Res : Success - * Date : 18th Jun 2016 - */ - -drop dataverse KeyVerse if exists; -create dataverse KeyVerse; -use dataverse KeyVerse; - -create type DocumentType as open{ -}; - -create type KVMetaType as open{ -"key":string, -vbucket:int32, -seq:int64, -cas:int64, -expiration:int32, -flags:int32, -revSeq:int64, -lockTime:int32 -}; - -create dataset KVStore(DocumentType) with meta(KVMetaType)primary key meta()."key"; - -create feed KVChangeStream with { - "adapter-name" : "adapter", - "type-name" : "DocumentType", - "meta-type-name" : "KVMetaType", - "reader" : "org.apache.asterix.external.input.record.reader.kv.KVTestReaderFactory", - "parser" : "record-with-metadata", - "format" : "dcp", - "record-format" : "json", - "change-feed" : "true", - "key-indexes" : "0", - "key-indicators" : "1", - "num-of-records" : "1000" -}; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-after-ingest/change-feed-with-meta-pk-in-meta-index-after-ingest.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-after-ingest/change-feed-with-meta-pk-in-meta-index-after-ingest.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-after-ingest/change-feed-with-meta-pk-in-meta-index-after-ingest.2.update.aql deleted file mode 100644 index 59c04ff..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-after-ingest/change-feed-with-meta-pk-in-meta-index-after-ingest.2.update.aql +++ /dev/null @@ -1,30 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a change feed with meta-data, ingest some records then - * build a secondary index after the dataset has data - * Expected Res : Success - * Date : 18th Jun 2016 - */ -use dataverse KeyVerse; - -set wait-for-completion-feed "true"; -connect feed KVChangeStream to dataset KVStore; - -start feed KVChangeStream; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-after-ingest/change-feed-with-meta-pk-in-meta-index-after-ingest.3.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-after-ingest/change-feed-with-meta-pk-in-meta-index-after-ingest.3.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-after-ingest/change-feed-with-meta-pk-in-meta-index-after-ingest.3.ddl.aql deleted file mode 100644 index 4a0b32b..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-after-ingest/change-feed-with-meta-pk-in-meta-index-after-ingest.3.ddl.aql +++ /dev/null @@ -1,27 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a change feed with meta-data, ingest some records then - * build a secondary index after the dataset has data - * Expected Res : Success - * Date : 18th Jun 2016 - */ -use dataverse KeyVerse; - -create index VBucketIndex on KVStore(meta().vbucket); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-after-ingest/change-feed-with-meta-pk-in-meta-index-after-ingest.4.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-after-ingest/change-feed-with-meta-pk-in-meta-index-after-ingest.4.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-after-ingest/change-feed-with-meta-pk-in-meta-index-after-ingest.4.query.aql deleted file mode 100644 index 5ef3a13..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-after-ingest/change-feed-with-meta-pk-in-meta-index-after-ingest.4.query.aql +++ /dev/null @@ -1,31 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a change feed with meta-data, ingest some records then - * build a secondary index after the dataset has data - * Expected Res : Success - * Date : 18th Jun 2016 - */ -use dataverse KeyVerse; - -count( - for $d in dataset KVStore - where meta($d).vbucket = 8 - return $d -); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-after-ingest/change-feed-with-meta-pk-in-meta-index-after-ingest.5.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-after-ingest/change-feed-with-meta-pk-in-meta-index-after-ingest.5.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-after-ingest/change-feed-with-meta-pk-in-meta-index-after-ingest.5.ddl.aql deleted file mode 100644 index bf60e83..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-after-ingest/change-feed-with-meta-pk-in-meta-index-after-ingest.5.ddl.aql +++ /dev/null @@ -1,25 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a change feed with meta-data, ingest some records then - * build a secondary index after the dataset has data - * Expected Res : Success - * Date : 18th Jun 2016 - */ -drop dataverse KeyVerse; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-in-meta/change-feed-with-meta-pk-in-meta-index-in-meta.1.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-in-meta/change-feed-with-meta-pk-in-meta-index-in-meta.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-in-meta/change-feed-with-meta-pk-in-meta-index-in-meta.1.ddl.aql deleted file mode 100644 index c3e82f2..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-in-meta/change-feed-with-meta-pk-in-meta-index-in-meta.1.ddl.aql +++ /dev/null @@ -1,60 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a change feed with meta-data - * build secondary index on a meta field and then test ingestion of records - * Expected Res : Success - * Date : 18th Jun 2016 - */ - -drop dataverse KeyVerse if exists; -create dataverse KeyVerse; -use dataverse KeyVerse; - -create type DocumentType as open{ -}; - -create type KVMetaType as open{ -"key":string, -vbucket:int32, -seq:int64, -cas:int64, -expiration:int32, -flags:int32, -revSeq:int64, -lockTime:int32 -}; - -create dataset KVStore(DocumentType) with meta(KVMetaType)primary key meta()."key"; - -create feed KVChangeStream with { - "adapter-name" : "adapter", - "type-name" : "DocumentType", - "meta-type-name" : "KVMetaType", - "reader" : "org.apache.asterix.external.input.record.reader.kv.KVTestReaderFactory", - "parser" : "record-with-metadata", - "format" : "dcp", - "record-format" : "json", - "change-feed" : "true", - "key-indexes" : "0", - "key-indicators" : "1", - "num-of-records" : "1000" -}; - -create index VBucketIndex on KVStore(meta().vbucket); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-in-meta/change-feed-with-meta-pk-in-meta-index-in-meta.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-in-meta/change-feed-with-meta-pk-in-meta-index-in-meta.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-in-meta/change-feed-with-meta-pk-in-meta-index-in-meta.2.update.aql deleted file mode 100644 index 6d6c4ef..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-in-meta/change-feed-with-meta-pk-in-meta-index-in-meta.2.update.aql +++ /dev/null @@ -1,30 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a change feed with meta-data - * build secondary index on a meta field and then test ingestion of records - * Expected Res : Success - * Date : 18th Jun 2016 - */ -use dataverse KeyVerse; - -set wait-for-completion-feed "true"; -connect feed KVChangeStream to dataset KVStore; - -start feed KVChangeStream; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-in-meta/change-feed-with-meta-pk-in-meta-index-in-meta.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-in-meta/change-feed-with-meta-pk-in-meta-index-in-meta.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-in-meta/change-feed-with-meta-pk-in-meta-index-in-meta.3.query.aql deleted file mode 100644 index 59f70c8..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-in-meta/change-feed-with-meta-pk-in-meta-index-in-meta.3.query.aql +++ /dev/null @@ -1,31 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a change feed with meta-data - * build secondary index on a meta field and then test ingestion of records - * Expected Res : Success - * Date : 18th Jun 2016 - */ -use dataverse KeyVerse; - -count( - for $d in dataset KVStore - where meta($d).vbucket = 5 - return $d -); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-in-meta/change-feed-with-meta-pk-in-meta-index-in-meta.4.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-in-meta/change-feed-with-meta-pk-in-meta-index-in-meta.4.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-in-meta/change-feed-with-meta-pk-in-meta-index-in-meta.4.ddl.aql deleted file mode 100644 index b1cda6d..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-in-meta/change-feed-with-meta-pk-in-meta-index-in-meta.4.ddl.aql +++ /dev/null @@ -1,25 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a change feed with meta-data - * build secondary index on a meta field and then test ingestion of records - * Expected Res : Success - * Date : 18th Jun 2016 - */ -drop dataverse KeyVerse; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest.1.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest.1.ddl.aql deleted file mode 100644 index 689456d..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest.1.ddl.aql +++ /dev/null @@ -1,58 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a change feed with meta-data, ingest data then create an index - * on a field which sometimes is missing and sometimes is null - * Expected Res : Success - * Date : 18th Jun 2016 - */ - -drop dataverse KeyVerse if exists; -create dataverse KeyVerse; -use dataverse KeyVerse; - -create type DocumentType as open{ -}; - -create type KVMetaType as open{ -"key":string, -vbucket:int32, -seq:int64, -cas:int64, -expiration:int32, -flags:int32, -revSeq:int64, -lockTime:int32 -}; - -create dataset KVStore(DocumentType) with meta(KVMetaType)primary key meta()."key"; - -create feed KVChangeStream with { - "adapter-name" : "adapter", - "type-name" : "DocumentType", - "meta-type-name" : "KVMetaType", - "reader" : "org.apache.asterix.external.input.record.reader.kv.KVTestReaderFactory", - "parser" : "record-with-metadata", - "format" : "dcp", - "record-format" : "json", - "change-feed" : "true", - "key-indexes" : "0", - "key-indicators" : "1", - "num-of-records" : "1000" -}; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest.2.update.aql deleted file mode 100644 index 11f80f1..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest.2.update.aql +++ /dev/null @@ -1,30 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a change feed with meta-data, ingest data then create an index - * on a field which sometimes is missing and sometimes is null - * Expected Res : Success - * Date : 18th Jun 2016 - */ -use dataverse KeyVerse; - -set wait-for-completion-feed "true"; -connect feed KVChangeStream to dataset KVStore; - -start feed KVChangeStream; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest.3.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest.3.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest.3.ddl.aql deleted file mode 100644 index e0965b9..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest.3.ddl.aql +++ /dev/null @@ -1,27 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a change feed with meta-data, ingest data then create an index - * on a field which sometimes is missing and sometimes is null - * Expected Res : Success - * Date : 18th Jun 2016 - */ -use dataverse KeyVerse; - -create index VBucketIndex on KVStore(exp:int32?) enforced; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest.4.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest.4.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest.4.query.aql deleted file mode 100644 index 883be64..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest.4.query.aql +++ /dev/null @@ -1,31 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a change feed with meta-data, ingest data then create an index - * on a field which sometimes is missing and sometimes is null - * Expected Res : Success - * Date : 18th Jun 2016 - */ -use dataverse KeyVerse; - -count( - for $d in dataset KVStore - where $d.exp = 15 - return $d -); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest.5.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest.5.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest.5.ddl.aql deleted file mode 100644 index 2f043ba..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest/change-feed-with-meta-pk-in-meta-index-with-missing-after-ingest.5.ddl.aql +++ /dev/null @@ -1,25 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a change feed with meta-data, ingest data then create an index - * on a field which sometimes is missing and sometimes is null - * Expected Res : Success - * Date : 18th Jun 2016 - */ -drop dataverse KeyVerse; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-in-value/change-feed-with-meta-pk-in-meta-open-index-in-value.1.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-in-value/change-feed-with-meta-pk-in-meta-open-index-in-value.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-in-value/change-feed-with-meta-pk-in-meta-open-index-in-value.1.ddl.aql deleted file mode 100644 index 928f3ce..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-in-value/change-feed-with-meta-pk-in-meta-open-index-in-value.1.ddl.aql +++ /dev/null @@ -1,60 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a change feed with meta-data, create an index - * on an open field in the record part then ingest data - * Expected Res : Success - * Date : 18th Jun 2016 - */ - -drop dataverse KeyVerse if exists; -create dataverse KeyVerse; -use dataverse KeyVerse; - -create type DocumentType as open{ -}; - -create type KVMetaType as open{ -"key":string, -vbucket:int32, -seq:int64, -cas:int64, -expiration:int32, -flags:int32, -revSeq:int64, -lockTime:int32 -}; - -create dataset KVStore(DocumentType) with meta(KVMetaType)primary key meta()."key"; - -create feed KVChangeStream with { - "adapter-name" : "adapter", - "type-name" : "DocumentType", - "meta-type-name" : "KVMetaType", - "reader" : "org.apache.asterix.external.input.record.reader.kv.KVTestReaderFactory", - "parser" : "record-with-metadata", - "format" : "dcp", - "record-format" : "json", - "change-feed" : "true", - "key-indexes" : "0", - "key-indicators" : "1", - "num-of-records" : "1000" -}; - -create index OpenIndex on KVStore(id:int32?) enforced; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-in-value/change-feed-with-meta-pk-in-meta-open-index-in-value.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-in-value/change-feed-with-meta-pk-in-meta-open-index-in-value.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-in-value/change-feed-with-meta-pk-in-meta-open-index-in-value.2.update.aql deleted file mode 100644 index 748af2e..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-in-value/change-feed-with-meta-pk-in-meta-open-index-in-value.2.update.aql +++ /dev/null @@ -1,30 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a change feed with meta-data, create an index - * on an open field in the record part then ingest data - * Expected Res : Success - * Date : 18th Jun 2016 - */ -use dataverse KeyVerse; - -set wait-for-completion-feed "true"; -connect feed KVChangeStream to dataset KVStore; - -start feed KVChangeStream; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-in-value/change-feed-with-meta-pk-in-meta-open-index-in-value.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-in-value/change-feed-with-meta-pk-in-meta-open-index-in-value.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-in-value/change-feed-with-meta-pk-in-meta-open-index-in-value.3.query.aql deleted file mode 100644 index 5e9b3f4..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-in-value/change-feed-with-meta-pk-in-meta-open-index-in-value.3.query.aql +++ /dev/null @@ -1,29 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a change feed with meta-data, create an index - * on an open field in the record part then ingest data - * Expected Res : Success - * Date : 18th Jun 2016 - */ -use dataverse KeyVerse; - -for $d in dataset KVStore -where $d.id = 5 -return $d; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-in-value/change-feed-with-meta-pk-in-meta-open-index-in-value.4.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-in-value/change-feed-with-meta-pk-in-meta-open-index-in-value.4.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-in-value/change-feed-with-meta-pk-in-meta-open-index-in-value.4.ddl.aql deleted file mode 100644 index 004cebe..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-in-value/change-feed-with-meta-pk-in-meta-open-index-in-value.4.ddl.aql +++ /dev/null @@ -1,25 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a change feed with meta-data, create an index - * on an open field in the record part then ingest data - * Expected Res : Success - * Date : 18th Jun 2016 - */ -drop dataverse KeyVerse; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-with-missing/change-feed-with-meta-pk-in-meta-open-index-with-missing.1.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-with-missing/change-feed-with-meta-pk-in-meta-open-index-with-missing.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-with-missing/change-feed-with-meta-pk-in-meta-open-index-with-missing.1.ddl.aql deleted file mode 100644 index 05e7564..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-with-missing/change-feed-with-meta-pk-in-meta-open-index-with-missing.1.ddl.aql +++ /dev/null @@ -1,60 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a change feed with meta-data, create an index - * on a field which sometimes is missing and sometimes is null and then ingest data - * Expected Res : Success - * Date : 18th Jun 2016 - */ - -drop dataverse KeyVerse if exists; -create dataverse KeyVerse; -use dataverse KeyVerse; - -create type DocumentType as open{ -}; - -create type KVMetaType as open{ -"key":string, -vbucket:int32, -seq:int64, -cas:int64, -expiration:int32, -flags:int32, -revSeq:int64, -lockTime:int32 -}; - -create dataset KVStore(DocumentType) with meta(KVMetaType)primary key meta()."key"; - -create feed KVChangeStream with { - "adapter-name" : "adapter", - "type-name" : "DocumentType", - "meta-type-name" : "KVMetaType", - "reader" : "org.apache.asterix.external.input.record.reader.kv.KVTestReaderFactory", - "parser" : "record-with-metadata", - "format" : "dcp", - "record-format" : "json", - "change-feed" : "true", - "key-indexes" : "0", - "key-indicators" : "1", - "num-of-records" : "1000" -}; - -create index OpenIndex on KVStore(exp:int32?) enforced; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-with-missing/change-feed-with-meta-pk-in-meta-open-index-with-missing.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-with-missing/change-feed-with-meta-pk-in-meta-open-index-with-missing.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-with-missing/change-feed-with-meta-pk-in-meta-open-index-with-missing.2.update.aql deleted file mode 100644 index 00c8645..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-with-missing/change-feed-with-meta-pk-in-meta-open-index-with-missing.2.update.aql +++ /dev/null @@ -1,30 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a change feed with meta-data, create an index - * on a field which sometimes is missing and sometimes is null and then ingest data - * Expected Res : Success - * Date : 18th Jun 2016 - */ -use dataverse KeyVerse; - -set wait-for-completion-feed "true"; -connect feed KVChangeStream to dataset KVStore; - -start feed KVChangeStream; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-with-missing/change-feed-with-meta-pk-in-meta-open-index-with-missing.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-with-missing/change-feed-with-meta-pk-in-meta-open-index-with-missing.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-with-missing/change-feed-with-meta-pk-in-meta-open-index-with-missing.3.query.aql deleted file mode 100644 index 8c887f1..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-with-missing/change-feed-with-meta-pk-in-meta-open-index-with-missing.3.query.aql +++ /dev/null @@ -1,29 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a change feed with meta-data, create an index - * on a field which sometimes is missing and sometimes is null and then ingest data - * Expected Res : Success - * Date : 18th Jun 2016 - */ -use dataverse KeyVerse; - -for $d in dataset KVStore -where $d.exp = 15 -return $d; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ca8d0830/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-with-missing/change-feed-with-meta-pk-in-meta-open-index-with-missing.4.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-with-missing/change-feed-with-meta-pk-in-meta-open-index-with-missing.4.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-with-missing/change-feed-with-meta-pk-in-meta-open-index-with-missing.4.ddl.aql deleted file mode 100644 index 2fcc497..0000000 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/feeds/change-feed-with-meta-pk-in-meta-open-index-with-missing/change-feed-with-meta-pk-in-meta-open-index-with-missing.4.ddl.aql +++ /dev/null @@ -1,25 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ -/* - * Description : Create a change feed with meta-data, create an index - * on a field which sometimes is missing and sometimes is null and then ingest data - * Expected Res : Success - * Date : 18th Jun 2016 - */ -drop dataverse KeyVerse; \ No newline at end of file