[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.
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.