Clone Tools
  • last updated a few minutes ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
[NO ISSUE][OTH] Convert string-equal-public test to single query

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

- Convert string-equal-public test to single query

to avoid random failure on the cancellation test

due to having multiple queries in a single file.

Change-Id: I99ab027caeb028e22842b04c3dd401d95b285a2e

Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/4443

Contrib: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Hussain Towaileb <hussainht@gmail.com>

Reviewed-by: Dmitry Lychagin <dmitry.lychagin@couchbase.com>

    • -4
    • +1
    ./string-equal-public/string-equal-public.1.query.sqlpp
  1. … 2 more files in changeset.
[ASTERIXDB-2667][FUN] Share code base between string functions

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

- String functions concat, string_concat and string_join

now share the same code instead of each having a different

evaluator class.

- Added test cases for string_join function.

- Added support to deep missing/null checking in list

items. Now it's possible to give a deeper (list items)

missing value a higher priority over null arguments

outside a list between parameters.

Example:

somefun([1, missing], null);

It's possible to deeply check the list items first,

and hence return a missing, or only do first level check

and output would be null.

Change-Id: I41b644c6841b222d1c6c529b2f9189f42178e28c

Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/4023

Contrib: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Hussain Towaileb <hussainht@gmail.com>

Reviewed-by: Ali Alsuliman <ali.al.solaiman@gmail.com>

    • -0
    • +22
    ./concat/000/concat.1.ddl.sqlpp
    • -0
    • +19
    ./concat/000/concat.2.update.sqlpp
    • -0
    • +23
    ./concat/000/concat.3.query.sqlpp
    • -0
    • +26
    ./concat/001/concat.1.ddl.sqlpp
    • -0
    • +23
    ./concat/001/concat.2.update.sqlpp
    • -0
    • +27
    ./concat/001/concat.3.query.sqlpp
    • -0
    • +26
    ./concat/002/concat.1.ddl.sqlpp
    • -0
    • +23
    ./concat/002/concat.2.update.sqlpp
    • -0
    • +31
    ./concat/002/concat.3.query.sqlpp
    • -0
    • +28
    ./concat/003/concat.0.query.sqlpp
    • -0
    • +22
    ./concat/004/concat.1.ddl.sqlpp
    • -0
    • +19
    ./concat/004/concat.2.update.sqlpp
    • -0
    • +23
    ./concat/004/concat.3.query.sqlpp
    • -0
    • +25
    ./concat/005/concat.1.query.sqlpp
    • -0
    • +25
    ./concat/005/concat.2.query.sqlpp
  1. … 81 more files in changeset.
[ASTERIXDB-2680][FUN] Add support to regexp_matches() and regexp_split()

- user model changes: yes

- storage format changes: no

- interface changes: no

Details:

- Added support to regexp_matches().

- Added support to regexp_split().

- Added test cases for regexp_matches().

- Added test cases for regexp_split().

- Changed behavior of UTF8CharSequence when

subSequence is called with start = end, originally

it returns a null char[] array which causes an NPE,

now it returns an empty char[].

Change-Id: Iccf5ba14f5c8b8cf4bcd6dd6e412bb515d68dd74

Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/4243

Contrib: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Hussain Towaileb <hussainht@gmail.com>

Reviewed-by: Dmitry Lychagin <dmitry.lychagin@couchbase.com>

    • -0
    • +30
    ./regexp_matches/001/regexp_matches.000.ddl.sqlpp
    • -0
    • +29
    ./regexp_matches/001/regexp_matches.001.update.sqlpp
    • -0
    • +22
    ./regexp_matches/001/regexp_matches.002.query.sqlpp
    • -0
    • +20
    ./regexp_matches/001/regexp_matches.003.ddl.sqlpp
    • -0
    • +30
    ./regexp_matches/002/regexp_matches.000.ddl.sqlpp
    • -0
    • +28
    ./regexp_matches/002/regexp_matches.001.update.sqlpp
    • -0
    • +28
    ./regexp_matches/002/regexp_matches.002.query.sqlpp
    • -0
    • +20
    ./regexp_matches/002/regexp_matches.003.ddl.sqlpp
    • -0
    • +27
    ./regexp_matches/003/regexp_matches.000.query.sqlpp
    • -0
    • +26
    ./regexp_matches/004/regexp_matches.000.query.sqlpp
    • -0
    • +30
    ./regexp_split/001/regexp_split.000.ddl.sqlpp
    • -0
    • +36
    ./regexp_split/001/regexp_split.001.update.sqlpp
    • -0
    • +22
    ./regexp_split/001/regexp_split.002.query.sqlpp
    • -0
    • +20
    ./regexp_split/001/regexp_split.003.ddl.sqlpp
    • -0
    • +30
    ./regexp_split/002/regexp_split.000.ddl.sqlpp
  1. … 22 more files in changeset.
[NO ISSUE][TEST] Translated old aql tests to sqlpp

-user model changes: no

-storage format changes: no

-interface changes: no

Details:

-Translated old aql tests to sqlpp and added them to queries_sqlpp

-Added new translated tests to testsuite_sqlpp.xml

Change-Id: Id73f4603898f95ccb05352ab5bc2fb193e421126

Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/3946

Contrib: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Ian Maxon <imaxon@uci.edu>

    • -0
    • +29
    ./query-ASTERIXDB-1190/query-ASTERIXDB-1190.1.ddl.sqlpp
    • -0
    • +31
    ./query-ASTERIXDB-1190/query-ASTERIXDB-1190.2.update.sqlpp
    • -0
    • +23
    ./query-ASTERIXDB-1190/query-ASTERIXDB-1190.3.query.sqlpp
    • -0
    • +22
    ./string-equal-public/string-equal-public.1.query.sqlpp
    • -0
    • +29
    ./substring-after-5/substring-after-5.1.ddl.sqlpp
    • -0
    • +29
    ./substring-after-5/substring-after-5.2.update.sqlpp
    • -0
    • +26
    ./substring-after-5/substring-after-5.3.query.sqlpp
    • -0
    • +28
    ./substring-after-6/substring-after-6.1.ddl.sqlpp
    • -0
    • +29
    ./substring-after-6/substring-after-6.2.update.sqlpp
    • -0
    • +26
    ./substring-after-6/substring-after-6.3.query.sqlpp
  1. … 252 more files in changeset.
[ASTERIXDB-2657][FUN] String 1-based functions + function aliases

- user model changes: yes

- storage format changes: no

- interface changes: no

Details:

- Removed compiler property compiler.stringoffset.

- Add 1-based string function to the following functions:

position, regex_position

- Add aliases to the following functions:

position, substring, regex_contains, regex_like,

regex_position, regex_replace

- Add test cases for the above mentioned functions and

aliases.

Change-Id: I0df799f197e430a9cd7d1b2a45e372a0cd77347e

Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/3643

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Hussain Towaileb <hussainht@gmail.com>

    • -0
    • +22
    ./position/offset0/pos/pos.1.query.sqlpp
    • -0
    • +22
    ./position/offset0/pos0/pos0.1.query.sqlpp
    • -0
    • +21
    ./position/offset0/position/position.1.query.sqlpp
    • -0
    • +22
    ./position/offset0/position0/position0.1.query.sqlpp
    • -0
    • +24
    ./position/offset1/pos1/pos1.1.query.sqlpp
    • -0
    • +25
    ./position/offset1/position1/position1.1.query.sqlpp
    • -0
    • +25
    ./regexp_contains/contains_regex/contains_regex.1.ddl.sqlpp
    • -0
    • +27
    ./regexp_contains/contains_regex/contains_regex.2.update.sqlpp
    • -0
    • +39
    ./regexp_contains/contains_regex/contains_regex.3.query.sqlpp
    • -0
    • +23
    ./regexp_contains/contains_regex/contains_regex.4.query.sqlpp
    • -0
    • +20
    ./regexp_contains/contains_regex/contains_regex.5.ddl.sqlpp
    • -0
    • +25
    ./regexp_contains/contains_regexp/contains_regexp.1.ddl.sqlpp
    • -0
    • +27
    ./regexp_contains/contains_regexp/contains_regexp.2.update.sqlpp
    • -0
    • +39
    ./regexp_contains/contains_regexp/contains_regexp.3.query.sqlpp
  1. … 411 more files in changeset.
[ASTERIXDB-2651][RT][FUN] Handle matching a literal backslash properly in LIKE

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

- fixed an issue in the build() of RegExpMatcher where the "flags" argument gets ignored if the flags

argument does not change in the subsequent evaluation of the regexp_* functions over the tuples of dataset.

- added the missing Java regex meta characters.

- split test case "regexp_replace" into two, "regexp_replace" & "regexp_replace_with_flag".

Change-Id: I4f218f87f0c1736e2d8b5de07221d7efa0f9aef1

Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/3614

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Ali Alsuliman <ali.al.solaiman@gmail.com>

Reviewed-by: Dmitry Lychagin <dmitry.lychagin@couchbase.com>

    • -0
    • +25
    ./like_02/like_02.1.ddl.sqlpp
    • -0
    • +26
    ./like_02/like_02.2.update.sqlpp
    • -0
    • +33
    ./like_02/like_02.3.query.sqlpp
    • -0
    • +22
    ./like_02/like_02.4.query.sqlpp
    • -0
    • +20
    ./like_02/like_02.5.ddl.sqlpp
    • -0
    • +22
    ./like_03_negative/like_03_negative.1.query.sqlpp
    • -0
    • +22
    ./like_03_negative/like_03_negative.2.query.sqlpp
    • -0
    • +25
    ./regexp_contains/regexp_contains.1.ddl.sqlpp
    • -39
    • +0
    ./regexp_contains/regexp_contains.1.query.sqlpp
    • -0
    • +27
    ./regexp_contains/regexp_contains.2.update.sqlpp
    • -0
    • +39
    ./regexp_contains/regexp_contains.3.query.sqlpp
    • -0
    • +22
    ./regexp_contains/regexp_contains.4.query.sqlpp
    • -0
    • +20
    ./regexp_contains/regexp_contains.5.ddl.sqlpp
    • -20
    • +0
    ./regexp_contains_with_flag/regexp_contains.1.query.sqlpp
    • -0
    • +25
    ./regexp_contains_with_flag/regexp_contains_with_flag.1.ddl.sqlpp
  1. … 86 more files in changeset.
[ASTERIXDB-2634][COMP] String functions return null on data/type errors

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

Functions changed:

substring(string, start_idx),

repeat(string, num_times),

string_join([string], string_separator),

replace(string, search_string, string_replacement, num_times),

regexp_replace(string, string_pattern, string_replacement, num_times)

Those functions (except string_join) can return NULL even if the

arguments types are valid since the argument values could be not

valid at runtime. Their type computer is always nullable.

- int argument can be double/float on the condition that its value

is integer

- clean-ups:

UnaryStringInt64TypeComputer & AbstractStringTypeComputer.

ExceptionUtil:

- changed signature of toExpectedTypeString(). Overloading

with varargs with Object made it confusing.

- changed some args to Supplier to allow code sharing.

- removed StringIntToStringTypeComputer since now the instances

are not being used by the above functions.

- reorganized/renamed test cases

Change-Id: Ia85a0d08888021ae439a1d9f2f5858bcd52c79f3

Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/3605

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Ali Alsuliman <ali.al.solaiman@gmail.com>

Reviewed-by: Michael Blow <mblow@apache.org>

    • -20
    • +0
    ./repeat_error/repeat_error.1.query.sqlpp
  1. … 63 more files in changeset.
[ASTERIXDB-2633][FUN] Fix LIKE to regex translation

- user model changes: no

- storage format changes: no

- interface changes: no

Change-Id: I6138f62fdcd60bcc641f662d1fdb05b46dafbebf

Reviewed-on: https://asterix-gerrit.ics.uci.edu/3558

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Murtadha Hubail <mhubail@apache.org>

  1. … 4 more files in changeset.
[ASTERIXDB-2449][FUN] Incorrect NULL/MISSING handling by concat functions

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

- Infer function return type as unknownable if

its input list item can be NULL/MISSING

- Always return MISSING if there is a MISSING argument

Change-Id: Idc364b061f3e74bdc9d7715bbadedc957e9e8223

Reviewed-on: https://asterix-gerrit.ics.uci.edu/2946

Sonar-Qube: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Till Westmann <tillw@apache.org>

    • -0
    • +25
    ./string-concat2/string-concat2.1.query.sqlpp
    • -0
    • +25
    ./string-concat2/string-concat2.2.query.sqlpp
  1. … 9 more files in changeset.
[ASTERIXDB-2442][FUN] substring() should return NULL if the operation cannot be performed

- user model changes: yes

- storage format changes: no

- interface changes: no

Details:

- substring() should return NULL if starting offset is out of bounds

for given string or length is negative

Change-Id: Ia43a4266a2406ebba65809d527de896ad11fdffa

Reviewed-on: https://asterix-gerrit.ics.uci.edu/2914

Sonar-Qube: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Till Westmann <tillw@apache.org>

    • -2
    • +4
    ./substring2-4/substring2-4.3.query.sqlpp
  1. … 17 more files in changeset.
[NO ISSUE][FUN] Fix string replace with negative limit

- user model changes: yes

- storage format changes: no

- interface changes: no

Details:

- REPLACE() and REGEXP_REPLACE() must replace all occurrences

if negative limit is specified

Change-Id: I240b57bb90f5349d09dc91e868277b9cdcba89b8

Reviewed-on: https://asterix-gerrit.ics.uci.edu/2868

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Contrib: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Till Westmann <tillw@apache.org>

    • -1
    • +1
    ./replace_with_limit/replace_with_limit.1.query.sqlpp
  1. … 5 more files in changeset.
[ASTERIXDB-2419][COMP] Replacement limit in regexp_replace()

- user model changes: yes

- storage format changes: no

- interface changes: no

Details:

- Support replacement limit parameter in regexp_replace()

Change-Id: I9bcf633ea6af1ade49daffec4784a70355c08a0e

Reviewed-on: https://asterix-gerrit.ics.uci.edu/2797

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Contrib: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Till Westmann <tillw@apache.org>

    • -0
    • +26
    ./regexp_replace/regexp_replace.6.query.sqlpp
  1. … 9 more files in changeset.
[NO ISSUE] Format test query

- user model changes: no

- storage format changes: no

- interface changes: no

Change-Id: I6e8e8cd75f401a085fb93a5d599a3b1ecda50a9e

Reviewed-on: https://asterix-gerrit.ics.uci.edu/2647

Sonar-Qube: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Contrib: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Murtadha Hubail <mhubail@apache.org>

[ASTERIXDB-2378][SQL] Add “DIV”, “MOD”, change “/“ for integers

- user model changes: yes

- storage format changes: no

- interface changes: no

Details:

- Make "/" operator return double if both operands are integers

- Add "DIV" operator which is the same as "/" except that

it returns integer if both operands are integers

(as "/" did before this change)

- Add "MOD" operator which is an alias for "%" operator

- Remove "IDIV" operator from the grammar

Change-Id: I7c6b0704ce60a03dd3c10e1c75cb9761acc56536

Reviewed-on: https://asterix-gerrit.ics.uci.edu/2630

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Contrib: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Dmitry Lychagin <dmitry.lychagin@couchbase.com>

  1. … 41 more files in changeset.
[ASTERIXDB-2376][FUN] Negative offset for substring()

- user model changes: yes

- storage format changes: no

- interface changes: no

Details:

- Support negative offset as an argument to substring()

(that means: count from the end of the string)

Change-Id: I849c38819ea2df2c203fd1d794c6b0b3a0eca9d1

Reviewed-on: https://asterix-gerrit.ics.uci.edu/2626

Sonar-Qube: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Contrib: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Till Westmann <tillw@apache.org>

    • -1
    • +1
    ./substring2-4/substring2-4.3.query.sqlpp
  1. … 11 more files in changeset.
[NO ISSUE][FUN] Implement reverse() function

- user model changes: yes

- storage format changes: no

- interface changes: no

Details:

- Implement string reverse function: reverse()

Change-Id: I4bc30217f160a5365fd4aa34bc09cce85e06230a

Reviewed-on: https://asterix-gerrit.ics.uci.edu/2605

Sonar-Qube: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Contrib: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Till Westmann <tillw@apache.org>

    • -0
    • +26
    ./reverse/reverse.1.query.sqlpp
  1. … 8 more files in changeset.
[ASTERIXDB-2305][FUN] replace() should not accept regular expressions

- user model changes: yes

- storage format changes: no

- interface changes: no

Details:

- replace() function was equivalent to regexp_replace(),

both were based on regular expressions

- this change makes replace() function operate on plain strings

- regexp_replace() continues to operate on regular expressions

Change-Id: Ic01db334c2ef0cab5834cc161ee4f212cf2cb105

Reviewed-on: https://asterix-gerrit.ics.uci.edu/2440

Reviewed-by: Till Westmann <tillw@apache.org>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Contrib: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

    • -2
    • +0
    ./regexp_replace/regexp_replace.1.query.sqlpp
    • -0
    • +24
    ./regexp_replace/regexp_replace.2.query.sqlpp
    • -0
    • +22
    ./regexp_replace/regexp_replace.3.query.sqlpp
    • -0
    • +22
    ./regexp_replace/regexp_replace.4.query.sqlpp
    • -0
    • +24
    ./regexp_replace/regexp_replace.5.query.sqlpp
    • -0
    • +33
    ./replace/replace.1.query.sqlpp
    • -0
    • +22
    ./replace/replace.2.query.sqlpp
    • -19
    • +0
    ./replace21/replace21.2.update.sqlpp
  1. … 64 more files in changeset.
[ASTERIXDB-2303][API] Fix Supplementary Chars Printing

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

- Properly print supplementary chars as utf8

by converting their java surrogates to a string.

- Add test case.

Change-Id: I59e825c11ff750d5b651fb86712023c52e98367e

Reviewed-on: https://asterix-gerrit.ics.uci.edu/2429

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Contrib: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Michael Blow <mblow@apache.org>

    • -0
    • +19
    ./utf8/utf8.1.query.sqlpp
  1. … 3 more files in changeset.
[ASTERIXDB-2272][FUN] Count character positions from 0

- user model changes: yes

- storage format changes: no

- interface changes: no

Details:

- Count character positions in strings, binary from 0 instead of 1

- Affects following built-in functions:

position(), regexp_position(), substr()/subtring(),

sub_binary(), find-binary()

- Introduce new configuration property “compiler.stringoffset”

for backward compatibility

compiler.stringoffset = 0 - count from 0 (new default)

compiler.stringoffset = 1 - count from 1 (backwards-compatible setting)

Change-Id: Icdb2c241983d5f592b2695ef16eae9951518d7fd

Reviewed-on: https://asterix-gerrit.ics.uci.edu/2342

Reviewed-by: Dmitry Lychagin <dmitry.lychagin@couchbase.com>

Tested-by: Dmitry Lychagin <dmitry.lychagin@couchbase.com>

    • -1
    • +1
    ./substring2-1/substring2-1.3.query.sqlpp
    • -1
    • +1
    ./substring2-3/substring2-3.3.query.sqlpp
    • -1
    • +1
    ./substring_01/substring_01.3.query.sqlpp
  1. … 102 more files in changeset.
[ASTERIXDB-2096][COMP] Fix type casting for ExternalFunction

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

1. The current IntroduceDynamicTypeCastForExternalFunctionRule

cannot handle external function calls in nested record constructor.

This patch fix this issue by visiting all nested parameters for

external functions.

2. The ResultExtractor should be able to handle multiple queries

in single statement file as AQL does.

Change-Id: I65c298def75b18fab01f513012e28fc44fdc2fd4

Reviewed-on: https://asterix-gerrit.ics.uci.edu/2010

Sonar-Qube: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Contrib: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Dmitry Lychagin <dmitry.lychagin@couchbase.com>

  1. … 9 more files in changeset.
[ASTERIXDB-2050][SQL] Enforce a Semicolon After Each SQL++ Statement

- user model changes: a semicolon must be added after

every SQL++ statement.

- storage format changes: no

- interface changes: no

Details:

- Enforce a semicolon after each SQL++ statement.

- Adapt existing SQL++ test cases to new model.

Change-Id: I27e9e8fde5ff867ab569c8d443ba1522738046e3

Reviewed-on: https://asterix-gerrit.ics.uci.edu/1954

Sonar-Qube: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Till Westmann <tillw@apache.org>

    • -1
    • +1
    ./starts-with8/starts-with8.1.ddl.sqlpp
    • -1
    • +1
    ./toLowerCase03/toLowerCase03.1.ddl.sqlpp
    • -1
    • +1
    ./varlen-encoding/varlen-encoding.3.query.sqlpp
  1. … 2068 more files in changeset.
ASTERIXDB-1539: add aliases for several builtin types and builtin functions.

- tinyint for int8;

- smallint for int16;

- integer(or, int) for int32;

- bigint for int64;

- year_month_duration for year-month-duration;

- day_time_duration for day-time-duration;

- timestamp for datetime;

- double precision for double;

int8, int16, int32, int64, year-month-duration and day-time-duration

is going to be deprecated.

In addition, it

- converts underscores to hypens for SQL++ functions;

- uses "array_" prefix for builtin aggregation functions.

Change-Id: I5c4a933f9775e89c2d503d9ea1cb98c5934d1475

Reviewed-on: https://asterix-gerrit.ics.uci.edu/1199

Sonar-Qube: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Yingyi Bu <buyingyi@gmail.com>

  1. … 3559 more files in changeset.
Add string function repeat and split.

Change-Id: Ib9de5a59807d5ff51fa5d72444053f87cf8dd289

Reviewed-on: https://asterix-gerrit.ics.uci.edu/1141

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Till Westmann <tillw@apache.org>

    • -0
    • +30
    ./repeat/repeat.1.query.sqlpp
    • -0
    • +20
    ./repeat_error/repeat_error.1.query.sqlpp
    • -0
    • +36
    ./split/split.3.query.sqlpp
  1. … 12 more files in changeset.
Add several builtin functions.

- add functions such as greatest, least, concat(||), initcap(title),

regexp_contains, regexp_like, regexp_position, regexp_replace, ltrim,

trim, rtrim, position;

- refactor string functions;

- remove undocumented function "regexp", which is equivalent to "matches";

- remove AQL.html and SQLPP.html since they are generated in "target/".

Change-Id: I26351af22f67d66b56176f55b29a4e7ff63583f7

Reviewed-on: https://asterix-gerrit.ics.uci.edu/1104

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Till Westmann <tillw@apache.org>

    • -0
    • +25
    ./concat_func/concat_func.1.query.sqlpp
    • -0
    • +25
    ./concat_pipe/concat_pipe.1.query.sqlpp
    • -0
    • +25
    ./concat_pipe_multi/concat_pipe_multi.1.query.sqlpp
    • -0
    • +26
    ./initcap/initcap.1.query.sqlpp
    • -0
    • +37
    ./ltrim/ltrim.1.query.sqlpp
    • -0
    • +23
    ./position/position.1.query.sqlpp
    • -0
    • +39
    ./regexp_contains/regexp_contains.1.query.sqlpp
    • -0
    • +20
    ./regexp_contains_with_flag/regexp_contains.1.query.sqlpp
    • -0
    • +41
    ./regexp_like/regexp_like.1.query.sqlpp
    • -0
    • +20
    ./regexp_like_with_flag/regexp_like_with_flag.1.query.sqlpp
    • -0
    • +39
    ./regexp_position/regexp_position.1.query.sqlpp
    • -0
    • +20
    ./regexp_position_with_flag/regexp_position_with_flag.1.query.sqlpp
    • -0
    • +31
    ./regexp_replace/regexp_replace.1.query.sqlpp
    • -0
    • +37
    ./rtrim/rtrim.1.query.sqlpp
    • -0
    • +26
    ./title/title.1.query.sqlpp
  1. … 78 more files in changeset.
Renaming: "table"->"dataset", "database"->"dataverse".

Change-Id: Ia80193f08651fc99341d9a8cf156d0feb6d0575f

Reviewed-on: https://asterix-gerrit.ics.uci.edu/1036

Sonar-Qube: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Till Westmann <tillw@apache.org>

    • -2
    • +2
    ./codepoint-to-string1/codepoint-to-string1.1.ddl.sqlpp
    • -2
    • +2
    ./codepoint-to-string2/codepoint-to-string2.1.ddl.sqlpp
  1. … 2760 more files in changeset.
Support LIKE, NOT LIKE, IN, NOT IN.

Change-Id: I497c4420431460bc461937dd5fc58956e1fad6ea

Reviewed-on: https://asterix-gerrit.ics.uci.edu/974

Reviewed-by: Till Westmann <tillw@apache.org>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

  1. … 57 more files in changeset.
Support implicit variable name and column name.

1. Support WITH clause for general cases;

2. Fixed open/closed type optimization;

3. Fixed scoping for nested aggregations;

4. Fixed side effects during partition property analysis;

5. Fixed type propagation policy for Subplan operator.

Change-Id: I409b9ba139c9f000a6b9b84d519d172d0069e4bb

Reviewed-on: https://asterix-gerrit.ics.uci.edu/950

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Till Westmann <tillw@apache.org>

    • -0
    • +2
    ./varlen-encoding/varlen-encoding.3.query.sqlpp
  1. … 231 more files in changeset.
Use backticks instead of double quotes for delimited identifiers in SQL++.

Change-Id: I2db58d68e8e28befa4105504c261b101fa0285af

Reviewed-on: https://asterix-gerrit.ics.uci.edu/909

Reviewed-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Till Westmann <tillw@apache.org>

    • -1
    • +1
    ./codepoint-to-string1/codepoint-to-string1.3.query.sqlpp
    • -1
    • +1
    ./codepoint-to-string2/codepoint-to-string2.3.query.sqlpp
  1. … 2118 more files in changeset.