Clone Tools
  • last updated 25 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
[NO ISSUE][COMP] Minor cleanup in VariableCheckAndRewriteVisitor

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

- VariableCheckAndRewriteVisitor should create FieldAccessor

expressions when resolving identifiers as field accessors.

Currently it produces an internal function call in these cases.

FieldAccessor expressions will be converted into internal

function calls later by LangExpressionToPlanTranslator.

Change-Id: Icaab2a29f787439eebd67e44aa6a9e92df422a98

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

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

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

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

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

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

    • -2
    • +2
    ./q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.3.ast
    • -2
    • +2
    ./q03_shipping_priority_nt/q03_shipping_priority_nt.3.ast
    • -2
    • +2
    ./q05_local_supplier_volume/q05_local_supplier_volume.3.ast
    • -4
    • +4
    ./q08_national_market_share/q08_national_market_share.3.ast
    • -2
    • +2
    ./q09_product_type_profit_nt/q09_product_type_profit_nt.3.ast
    • -2
    • +2
    ./q13_customer_distribution/q13_customer_distribution.3.ast
    • -4
    • +4
    ./q14_promotion_effect/q14_promotion_effect.3.ast
    • -2
    • +2
    ./q16_parts_supplier_relationship/q16_parts_supplier_relationship.3.ast
    • -22
    • +22
    ./q17_large_gby_variant/q17_large_gby_variant.3.ast
    • -4
    • +4
    ./q18_large_volume_customer/q18_large_volume_customer.3.ast
    • -2
    • +2
    ./q20_potential_part_promotion/q20_potential_part_promotion.3.ast
    • -2
    • +2
    ./q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.3.ast
    • -4
    • +4
    ./q22_global_sales_opportunity/q22_global_sales_opportunity.3.ast
  1. … 31 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
    ./q22_global_sales_opportunity/q22_global_sales_opportunity.3.ast
  1. … 107 more files in changeset.
[ASTERIXDB-2193][SQLPP] Fix dataverse resolution in functions

- user model changes: yes

- storage format changes: no

- interface changes: no

Details:

- When compiling user-defined function set default dataverse

to be the function's dataverse to correclty resolve dataset

accesses within that function

- Fix incorrect interpretation of quoted dataset names

FROM `a.b` now means FROM default_dataverse.`a.b`

(previously it meant FROM `a`.`b`)

Change-Id: I699b35fb46a739e9fdfcaf5cbfd6a4a00ce4da38

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

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

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

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

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

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

    • -1
    • +1
    ./q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.3.ast
    • -3
    • +3
    ./q03_shipping_priority_nt/q03_shipping_priority_nt.3.ast
    • -1
    • +1
    ./q04_order_priority/q04_order_priority.3.ast
    • -6
    • +6
    ./q05_local_supplier_volume/q05_local_supplier_volume.3.ast
    • -1
    • +1
    ./q06_forecast_revenue_change/q06_forecast_revenue_change.3.ast
    • -1
    • +1
    ./q06_forecast_revenue_change/q06_forecast_revenue_change.4.ast
    • -4
    • +4
    ./q07_volume_shipping/q07_volume_shipping.3.ast
    • -8
    • +8
    ./q08_national_market_share/q08_national_market_share.3.ast
    • -6
    • +6
    ./q09_product_type_profit_nt/q09_product_type_profit_nt.3.ast
    • -4
    • +4
    ./q10_returned_item/q10_returned_item.3.ast
    • -4
    • +4
    ./q10_returned_item_int64/q10_returned_item_int64.3.ast
    • -6
    • +6
    ./q11_important_stock/q11_important_stock.3.ast
  1. … 1502 more files in changeset.
[ASTERIXDB-2170][SQL] Fix resolution order of implicit field access

- user model changes: yes

- storage format changes: no

- interface changes: no

Details:

- Improved name resolution rules

- Resolve field access to the nearest variable in scope

instead of raising compile-time error

- Do not rely on type information when resolving names

- Cleanup group variable handling in GroupBy clause,

no longer use ‘with’ map for it

- Fix ByNameToByIndexFieldAccessRule to use type environment

of its input operator when analyzing its expression

- Fix ExternalGroupByPOperator to use input schema of its

aggregate function when generating runtime for that function

- Fix invalid free variable computation for GroupBy clause

Change-Id: I50bc823ff53da06507a5454b30f4f500b862d4bf

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

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

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

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

    • -4
    • +2
    ./q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.3.ast
    • -5
    • +2
    ./q03_shipping_priority_nt/q03_shipping_priority_nt.3.ast
    • -3
    • +2
    ./q05_local_supplier_volume/q05_local_supplier_volume.3.ast
    • -0
    • +5
    ./q06_forecast_revenue_change/q06_forecast_revenue_change.4.ast
    • -0
    • +1
    ./q07_volume_shipping/q07_volume_shipping.3.ast
    • -6
    • +4
    ./q08_national_market_share/q08_national_market_share.3.ast
    • -4
    • +2
    ./q09_product_type_profit_nt/q09_product_type_profit_nt.3.ast
    • -14
    • +6
    ./q13_customer_distribution/q13_customer_distribution.3.ast
    • -12
    • +6
    ./q14_promotion_effect/q14_promotion_effect.3.ast
    • -5
    • +2
    ./q16_parts_supplier_relationship/q16_parts_supplier_relationship.3.ast
    • -33
    • +22
    ./q17_large_gby_variant/q17_large_gby_variant.3.ast
    • -12
    • +4
    ./q18_large_volume_customer/q18_large_volume_customer.3.ast
    • -4
    • +2
    ./q20_potential_part_promotion/q20_potential_part_promotion.3.ast
    • -13
    • +6
    ./q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.3.ast
  1. … 300 more files in changeset.
[NO ISSUE][COMP] Function references cleanup

- user model changes: no

- storage format changes: no

- interface change: no

Details: cleanup function references

- Use function identifiers when referring to built-in functions

- Use OperatorType enum when referring to operators

- Add FunctionSignature constructor that takes FunctionIdentifier

- Use asterix/algebricks namespace when referring to built-in functions

Change-Id: Ibad290182ed0f248f65987df97e6c61aac95b232

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

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: Ian Maxon <imaxon@apache.org>

Reviewed-by: Taewoo Kim <wangsaeu@gmail.com>

    • -2
    • +2
    ./q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.3.ast
    • -4
    • +4
    ./q03_shipping_priority_nt/q03_shipping_priority_nt.3.ast
    • -1
    • +1
    ./q04_order_priority/q04_order_priority.3.ast
    • -7
    • +7
    ./q05_local_supplier_volume/q05_local_supplier_volume.3.ast
    • -1
    • +1
    ./q06_forecast_revenue_change/q06_forecast_revenue_change.3.ast
    • -1
    • +1
    ./q06_forecast_revenue_change/q06_forecast_revenue_change.4.ast
    • -4
    • +4
    ./q07_volume_shipping/q07_volume_shipping.3.ast
    • -10
    • +10
    ./q08_national_market_share/q08_national_market_share.3.ast
    • -7
    • +7
    ./q09_product_type_profit_nt/q09_product_type_profit_nt.3.ast
    • -4
    • +4
    ./q10_returned_item/q10_returned_item.3.ast
    • -4
    • +4
    ./q10_returned_item_int64/q10_returned_item_int64.3.ast
    • -6
    • +6
    ./q11_important_stock/q11_important_stock.3.ast
  1. … 1569 more files in changeset.
[ASTERIXDB-2078][SQL] DISTINCT modifier for aggregate functions

- user model changes: yes

- storage format changes: no

- interface changes: no

Details:

- Adds support for DISTINCT modifier in aggregate functions:

AGG(DISTINCT expr), ARRAY_AGG(DISTINCT expr), COLL_AGG(DISTINCT expr)

where AGG = COUNT | SUM | AVG | MIN | MAX

Change-Id: I52772349cbcbfc68a3a1ff261d610871ca38748d

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

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>

    • -8
    • +8
    ./q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.3.ast
    • -1
    • +1
    ./q02_minimum_cost_supplier/q02_minimum_cost_supplier.3.ast
    • -1
    • +1
    ./q03_shipping_priority_nt/q03_shipping_priority_nt.3.ast
    • -1
    • +1
    ./q04_order_priority/q04_order_priority.3.ast
    • -1
    • +1
    ./q05_local_supplier_volume/q05_local_supplier_volume.3.ast
    • -1
    • +1
    ./q06_forecast_revenue_change/q06_forecast_revenue_change.3.ast
    • -1
    • +1
    ./q06_forecast_revenue_change/q06_forecast_revenue_change.4.ast
    • -1
    • +1
    ./q07_volume_shipping/q07_volume_shipping.3.ast
    • -2
    • +2
    ./q08_national_market_share/q08_national_market_share.3.ast
    • -1
    • +1
    ./q09_product_type_profit_nt/q09_product_type_profit_nt.3.ast
    • -1
    • +1
    ./q10_returned_item/q10_returned_item.3.ast
    • -1
    • +1
    ./q10_returned_item_int64/q10_returned_item_int64.3.ast
    • -2
    • +2
    ./q11_important_stock/q11_important_stock.3.ast
  1. … 347 more files in changeset.
[ASTERIXDB-1753][SQL] Disable auto-plural for group-by.

- user model changes: do not perform auto-scalar-to-plural

transition for variables that are defined prior to a group-by

group clause after the group-by clause.

- storage format changes: no

- interface changes: no

details:

- migrated existing test queries that use auto-plural;

- added a negative test query.

Change-Id: I5d6383fc7453fe7537fc291c3483708b59df3871

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

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

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

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

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

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

    • -19
    • +61
    ./q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.3.ast
    • -2
    • +6
    ./q02_minimum_cost_supplier/q02_minimum_cost_supplier.3.ast
    • -2
    • +15
    ./q03_shipping_priority_nt/q03_shipping_priority_nt.3.ast
    • -2
    • +13
    ./q05_local_supplier_volume/q05_local_supplier_volume.3.ast
    • -4
    • +10
    ./q07_volume_shipping/q07_volume_shipping.3.ast
    • -3
    • +25
    ./q08_national_market_share/q08_national_market_share.3.ast
    • -2
    • +14
    ./q09_product_type_profit_nt/q09_product_type_profit_nt.3.ast
    • -4
    • +10
    ./q10_returned_item/q10_returned_item.3.ast
    • -4
    • +10
    ./q10_returned_item_int64/q10_returned_item_int64.3.ast
    • -4
    • +10
    ./q11_important_stock/q11_important_stock.3.ast
    • -9
    • +27
    ./q13_customer_distribution/q13_customer_distribution.3.ast
    • -2
    • +28
    ./q14_promotion_effect/q14_promotion_effect.3.ast
    • -3
    • +10
    ./q15_top_supplier/q15_top_supplier.3.ast
  1. … 247 more files in changeset.
Supports flexible degree of parallelism.

Detailed list of changes include:

- Add the IClusterInfoCollector interface and feed that to the compiler;

- Add the number of cores into the heartbeat;

- Add partition calculation in APIFramework;

- Fix partitioning property requirements in binary operators such as Join and UnionAll;

- Fix PushSubplanIntoGroupByRule for type propagation;

- Fix InlineLeftNtsInSubplanJoinFlatteningVisitor for the returned top join operator;

- Add unit test for partition calculation in APIFrameworkTest

- Add integration test SqlppExecutionFullParallelismIT, SqlppExecutionLessParallelismIT,

AqlExecutionFullParallelismIT, and AqlExecutionLessParallelismIT for different

parallelism settings;

- Refactor AQLExecutionTest and SqlppExecutionTest;

- Separate one cluster state test out from AqlExecutionTest.

Change-Id: If70faf52bed995c7098cc343f2fabd1b6c8d96e7

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

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

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

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

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

    • -1
    • +11
    ./query-issue601/query-issue601.3.ast
    • -0
    • +4
    ./query-issue785-2/query-issue785-2.3.ast
  1. … 113 more files in changeset.
Disable hash merge exchange.

- Hash merge exchange does not work very well on large clusters.

- Hash merge exchange is used only when a user explicitly enable it.

Change-Id: If82c4e4db1d4340cdd53d17e48a193ab2b7a05e0

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

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
    • +1
    ./q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.3.ast
  1. … 42 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>

    • -10
    • +10
    ./nest_aggregate/nest_aggregate.1.ast
    • -4
    • +4
    ./q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.1.ast
    • -20
    • +20
    ./q02_minimum_cost_supplier/q02_minimum_cost_supplier.1.ast
    • -20
    • +20
    ./q03_shipping_priority_nt/q03_shipping_priority_nt.1.ast
    • -20
    • +20
    ./q04_order_priority/q04_order_priority.1.ast
    • -20
    • +20
    ./q05_local_supplier_volume/q05_local_supplier_volume.1.ast
    • -20
    • +20
    ./q06_forecast_revenue_change/q06_forecast_revenue_change.1.ast
    • -20
    • +20
    ./q07_volume_shipping/q07_volume_shipping.1.ast
    • -20
    • +20
    ./q08_national_market_share/q08_national_market_share.1.ast
    • -20
    • +20
    ./q09_product_type_profit_nt/q09_product_type_profit_nt.1.ast
    • -20
    • +20
    ./q10_returned_item/q10_returned_item.1.ast
    • -20
    • +20
    ./q10_returned_item_int64/q10_returned_item_int64.1.ast
    • -20
    • +20
    ./q11_important_stock/q11_important_stock.1.ast
  1. … 3547 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>

    • -6
    • +6
    ./q19_discounted_revenue/q19_discounted_revenue.3.ast
  1. … 92 more files in changeset.
Clean up GROUP BY and WITH clause.

- fix ASTERIXDB-971, i.e., the expression to plan translator for FLWOGR without a "for";

- fix the scoping for nested WITH clause;

- fix the scoping for nested GROUP BY clause;

- fix default fields in group variables;

- fix/unify the expression substition AST visitor;

- enhance RemoveUnusedAssignAndAggregateRule to be able to remove unused GROUP BY

decoration varaibles;

- clearly sperate SQL++ aggregate functions and SQL-92 aggregate functions, i.e.,

SQL-92 aggregate sugars cannot apply to SQL++ aggregate functions;

- fix PushAggregateIntoGroupbyRule for nested plan deletions;

- enhance RemoveCartesianProductWithEmptyBranchRule;

- add ExtractGroupByDecorVariablesRule;

- add an aggregate function first-element;

- fix ASTERIXDB-1560, an error message issue.

Change-Id: I62fca7f937aa007d97ed87c75cef19f6aa3e5ade

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

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

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

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

    • -11
    • +1
    ./q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.3.ast
    • -2
    • +2
    ./q03_shipping_priority_nt/q03_shipping_priority_nt.3.ast
    • -1
    • +1
    ./q04_order_priority/q04_order_priority.3.ast
    • -1
    • +1
    ./q05_local_supplier_volume/q05_local_supplier_volume.3.ast
    • -2
    • +1
    ./q07_volume_shipping/q07_volume_shipping.3.ast
    • -2
    • +1
    ./q11_important_stock/q11_important_stock.3.ast
    • -3
    • +1
    ./q14_promotion_effect/q14_promotion_effect.3.ast
    • -11
    • +1
    ./q17_large_gby_variant/q17_large_gby_variant.3.ast
    • -5
    • +3
    ./q18_large_volume_customer/q18_large_volume_customer.3.ast
    • -12
    • +1
    ./q22_global_sales_opportunity/q22_global_sales_opportunity.3.ast
    • -5
    • +2
    ./query-issue785-2/query-issue785-2.3.ast
  1. … 221 more files in changeset.
Support CASE expression in SQL++.

- support both simple CASE expression and searched CASE expression;

- support heterogenous return types of a CASE expression;

- remove IfElseExpression in SQL++;

- remove IfElseToSwitchCaseFunctionRule.java since the plan pattern it tries to identify is no longer right;

- unify CastRecordDescriptor and CastListDescriptor into CastTypeDescriptor;

- fix IS NULL for the case that the input is MISSING;

- let CastTypeDescriptor have a generated runtime so as to handle NULL/MISSING correctly.

Change-Id: Id9de7c3df70be43456e38a61ce767cc14f09e661

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

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

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

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

    • -15
    • +19
    ./q08_national_market_share/q08_national_market_share.3.ast
    • -44
    • +49
    ./q12_shipping/q12_shipping.3.ast
    • -23
    • +24
    ./q14_promotion_effect/q14_promotion_effect.3.ast
  1. … 113 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>

    • -2
    • +4
    ./q02_minimum_cost_supplier/q02_minimum_cost_supplier.3.ast
    • -7
    • +6
    ./q13_customer_distribution/q13_customer_distribution.3.ast
    • -1
    • +2
    ./q14_promotion_effect/q14_promotion_effect.3.ast
    • -14
    • +12
    ./q16_parts_supplier_relationship/q16_parts_supplier_relationship.3.ast
  1. … 55 more files in changeset.
Add IS (NOT) NULL/MISSING/UNKOWN.

Change-Id: I7e4008d97f0d3a92816b90492dd8c887b05bac27

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

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

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

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

    • -1
    • +1
    ./q13_customer_distribution/q13_customer_distribution.3.ast
    • -2
    • +2
    ./q16_parts_supplier_relationship/q16_parts_supplier_relationship.3.ast
  1. … 42 more files in changeset.
Let SQL-92 aggregate functions behave the same as SQL-92.

Change-Id: Ia2929d1ca6344508bbf772884ea8ef1f39a0e19f

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

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
    ./q04_order_priority/q04_order_priority.3.ast
    • -1
    • +1
    ./q06_forecast_revenue_change/q06_forecast_revenue_change.4.ast
    • -1
    • +1
    ./q13_customer_distribution/q13_customer_distribution.3.ast
    • -1
    • +1
    ./q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.3.ast
  1. … 88 more files in changeset.
ASTERIXDB-1383: reduce the number of lines for "AS".

Change-Id: Ic655bf25701f33230787d175b78bedc489909cb0

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

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

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

    • -20
    • +10
    ./nest_aggregate/nest_aggregate.3.ast
    • -22
    • +11
    ./q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.3.ast
    • -38
    • +19
    ./q02_minimum_cost_supplier/q02_minimum_cost_supplier.3.ast
    • -16
    • +8
    ./q03_shipping_priority_nt/q03_shipping_priority_nt.3.ast
    • -14
    • +7
    ./q04_order_priority/q04_order_priority.3.ast
    • -28
    • +14
    ./q05_local_supplier_volume/q05_local_supplier_volume.3.ast
    • -2
    • +1
    ./q06_forecast_revenue_change/q06_forecast_revenue_change.3.ast
    • -4
    • +2
    ./q06_forecast_revenue_change/q06_forecast_revenue_change.4.ast
    • -30
    • +15
    ./q07_volume_shipping/q07_volume_shipping.3.ast
    • -38
    • +19
    ./q08_national_market_share/q08_national_market_share.3.ast
    • -28
    • +14
    ./q09_product_type_profit_nt/q09_product_type_profit_nt.3.ast
    • -18
    • +9
    ./q10_returned_item/q10_returned_item.3.ast
    • -18
    • +9
    ./q10_returned_item_int64/q10_returned_item_int64.3.ast
  1. … 1705 more files in changeset.
Move merged files

    • -0
    • +73
    ./q06_forecast_revenue_change/q06_forecast_revenue_change.4.ast
  1. … 163 more files in changeset.