Tags: google/zetasql
Tags
Export of internal ZetaSQL changes. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Added the sqlbuilder implementation for functions with argument aliases. -- Change by ZetaSQL Team <[email protected]>: Stores argument alias information in resolved ast by using `generic_argument_list` rather than `argument_list` if the function signature has aliased arguments. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Add MakeRangeFromValidatedInputs, similar to MakeStructFromValidatedInputs for performance-sensitive cases -- Change by ZetaSQL Team <[email protected]>: Fix the generation_expression syntax, the current syntax requires () after AS. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Instead of relying on column id for order to create catalog columns to resolved columns map for the target table scan, ResolvePathExpressionAsTableScan now takes the map to be populated as a function argument. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by Christoph Dibak <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Multiway UNNEST test case refactoring -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Make Textmapper the default parser, except when the opt-out flag is set. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Fix create table with struct field that requires type coercion. -- Change by ZetaSQL Team <[email protected]>: Added the compliance test cases for EXCEPT (ALL|DISTINCT) for INNER CORRESPONDING BY. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Lift the ErrorMessageOptions() refactor to error_helpers.h and update callers to MaybeUpdateErrorFromPayload() -- Change by John Fremlin <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Remove unnecessary check in ConvertInternalErrorLocationAndAdjustErrorString() -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by Christoph Dibak <[email protected]>: Allow LIMIT and TABLESAMPLE in public group joins -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Mark `IeeeDivide()` and friends as `no_sanitize("float-divide-by-zero")`. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Introduce an opt-out flag for Textmapper, in preparation for making it the default primary parser. -- Change by ZetaSQL Team <[email protected]>: Remove dead code in AnonymizationRewriter. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Add a convenience overload to ConvertInternalErrorMessage() that accepts AnalyzerOptions. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Add compliance tests for IS [NOT] DISTINCT over RANGE types. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Extend cosine and euclidean distance functions to work with float32 arrays. -- Change by ZetaSQL Team <[email protected]>: Handle value table results more consistently. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Enable FEATURE_TEXTMAPPER_PARSER by default. Calling EnableMaximumFeatures() now sets TM as the parser. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Benchmark for EUCLIDEAN_DISTANCE implementation -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Heap allocate several larger objects in FunctionResolver::ResolveTemplatedSQLFunctionCall to reduce stack space consumption. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Modify JSON functions to allow constant expressions for JSONPaths. -- Change by ZetaSQL Team <[email protected]>: Directly set child values instead of merging. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Modify JSON functions to allow constant expressions for JSONPaths. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Improve a log line in the type factory. (And 23 more changes) GitOrigin-RevId: d5b7efe5a5d7157472b259c9c595c5d2ebb6f410 Change-Id: I68e3d0af8010af8adef7082902b0e2b80abb5322
Export of internal ZetaSQL changes. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Removed the `depth_limit_detector_test_cases_test` from zetasql. -- Change by John Fremlin <[email protected]>: Internal change GitOrigin-RevId: e6d88e9515744687cd24e0c05460c1ee362c7f69 Change-Id: I056cb0c1a190714ff4e94715ec8ffe8dbb716013
Export of internal ZetaSQL changes. -- Change by ZetaSQL Team <[email protected]>: Updated the zetasql doc for the zetasql release in Sept. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Minor refactoring against c++ resolved ast node generation templates -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by Brandon Dolphin <[email protected]>: No public description -- Change by Christoph Dibak <[email protected]>: Fix rewriting of public groups -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Added `ARG_TYPE_ANY_3` and `ARG_ARRAY_TYPE_ANY_3`. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by Christoph Dibak <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by Christoph Dibak <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Refactor ResolvedAggreateScan algebrizer to remove duplicated logic -- Change by ZetaSQL Team <[email protected]>: Added more tests to validate that argument aliases are not supported. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Added `argument_alias` fields to `ResolvedFunctionArgument`. -- Change by ZetaSQL Team <[email protected]>: Change edit distance implementation to use existing shared library. -- Change by ZetaSQL Team <[email protected]>: Add support for null handling in the AggregateFunctionEvaluator interface -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Simplify logic for CASE expression formatting. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Do not include internal alias in UserFacingName for table argument. -- Change by ZetaSQL Team <[email protected]>: Adding utility functions `GreaterOrEqual` and `Subtract` to the rewriter utils. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Bugfix for JSON_ARRAY_APPEND and JSON_ARRAY_INSERT. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by Richard Levasseur <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Added alias validation for function signatures. -- Change by ZetaSQL Team <[email protected]>: Add test coverage for conditional evaluation in WITH queries and WITH expressions. -- Change by ZetaSQL Team <[email protected]>: Add language feature to support multiway explicit UNNEST syntax -- Change by ZetaSQL Team <[email protected]>: Added a new language feature FEATURE_V_1_4_ARRAY_ZIP for the array_zip function. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Add a test case for conditional_evaluation on PIVOT and UNPIVOT -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Add test coverage for anonymization with conditional evaluation -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Replace CHECK with Status return in builtin function registry -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Added alias validation for function signatures. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Move SetFormatValueContentOptions to SQLTestBase protected section. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Moved `GetAliasForExpression` from the resolver code to resolved_ast_helper.h. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Added function_signature_testutil.cc to zetasql allowlist. -- Change by ZetaSQL Team <[email protected]>: Added function_signature_testutil.h into zetasql allowlist. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Unify ReferenceDriver constructors. -- Change by ZetaSQL Team <[email protected]>: Cleanup some calls to MaybeUpdateErrorMessageWithLocation() with explicit values for keep_error_location_payload. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Add collation support for NULLIF function in the reference implementation. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by Richard Levasseur <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Add reference implementation of UDFs and templated UDFs without rewriter. -- Change by ZetaSQL Team <[email protected]>: Add node_source to ResolvedArrayScan for single table array path shape -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: Clean up deprecated function signature. -- Change by ZetaSQL Team <[email protected]>: Add topologically sorted generated columns information to the ResolvedInsertStmt. -- Change by ZetaSQL Team <[email protected]>: Add a note about module support in docs for UDFs, TVFs, and UDAs. -- Change by ZetaSQL Team <[email protected]>: No public description (And 57 more changes) GitOrigin-RevId: 2ff92e98da5ba81417caa763616253336d7d8407 Change-Id: Ib851d471d1bd3d96a36e4996ab25d5c7d381c27b
Export of internal ZetaSQL changes. -- Change by ZetaSQL Team <[email protected]>: No public description -- Change by ZetaSQL Team <[email protected]>: No public description GitOrigin-RevId: 818f40fee6483a896ba208ff7ee2c227a5185535 Change-Id: I9696673a553289d27c5831f9731d0641096ee934
Export of internal ZetaSQL changes. -- Change by Matthew Brown <[email protected]>: Additional RewriteVisitor tests for error paths. -- Change by Matthew Brown <[email protected]>: ZetaSQL: Fix small issues blocking release -- Change by ZetaSQL Team <[email protected]>: Internal change GitOrigin-RevId: e1cd537590fec7a87d0e8b4967dcee93a711105a Change-Id: I5ebfc43120f6e0ec3f230893b5e3ac0608b68384
Export of internal ZetaSQL changes. -- Change by Matthew Brown <[email protected]>: ZetaSQL: Fix proto dependencies in ZetaSQL artifact rules -- Change by ZetaSQL Team <[email protected]>: Correct a comment which implies that ResolvedAnalyticFunctionGroup.analytic_function_list only contains ResolvedAggregateFunctionCall, when it also contains ResolvedAnalyticFunctionCall. -- Change by ZetaSQL Team <[email protected]>: add REPLICA as a non-reserve keyword and make it usable as a generic sub entity type. -- Change by ZetaSQL Team <[email protected]>: Add minimal compliance test framework support for invoking views. -- Change by ZetaSQL Team <[email protected]>: Simplify sql_test_base to eliminate multiple result sets for an individual test case. -- Change by ZetaSQL Team <[email protected]>: Simplify sql_test_base to eliminate the set of feature sets implementation of test_features1 and test_features2 -- Change by ZetaSQL Team <[email protected]>: Remove test_features1 compliance test option. -- Change by ZetaSQL Team <[email protected]>: Remove "test_features1=" use from anonymization.test -- Change by ZetaSQL Team <[email protected]>: Remove "test_features1=" use from dml_nested.test -- Change by ZetaSQL Team <[email protected]>: Remove "test_features1=" use from dml_insert.test -- Change by ZetaSQL Team <[email protected]>: Remove "test_features1=" use in geography_functions.test -- Change by ZetaSQL Team <[email protected]>: Remove "test_features1=" use in analytic_partitionby_orderby.test -- Change by ZetaSQL Team <[email protected]>: Remove "test_features1=" use in orderby_collate_queries.test -- Change by ZetaSQL Team <[email protected]>: Remove "test_features1=" use in with_queries.test -- Change by ZetaSQL Team <[email protected]>: Remove "test_features1=" use in serveral files where it was used with DISALLOW_GROUP_BY_FLOAT probably because `forbidden_features=` didn't exist yet. -- Change by ZetaSQL Team <[email protected]>: Remove "test_features1=" use in several places related to array comparisons. -- Change by ZetaSQL Team <[email protected]>: Remove "test_features1=" use in several time related test files. -- Change by ZetaSQL Team <[email protected]>: Remove "test_features1=" use in several more files with only one to two uses each. -- Change by ZetaSQL Team <[email protected]>: Remove "test_features1=" use for several files related to specific analytic window functions. -- Change by ZetaSQL Team <[email protected]>: Flag and test infra enhancement for detailed error message for signature mismatch. -- Change by ZetaSQL Team <[email protected]>: Internal Change GitOrigin-RevId: ccfcb5e9a72c160e62f407ead492830e4abeb627 Change-Id: I0b1b5317e6d534e1cce37ca14952322fd1b2d59c
Export of internal ZetaSQL changes. -- Change by Matthew Brown <[email protected]>: Support setting reserved keywords in Java LanguageOptions -- Change by Matthew Brown <[email protected]>: ZetaSQL release formatter support in java client -- Change by ZetaSQL Team <[email protected]>: Never add a line break before -> in a lambda expression. -- Change by ZetaSQL Team <[email protected]>: Support inferring proto type through a subquery. -- Change by ZetaSQL Team <[email protected]>: Throw more explicit error when a script variable is used incorrectly -- Change by ZetaSQL Team <[email protected]>: Add a test that will fail if any language feature that isn't currently applied to a test where it shouldn't be is applied to a test where it shouldn't be. This at least should slow down addition of cases that wrap language features around tests where they shouldn't be added. -- Change by ZetaSQL Team <[email protected]>: Add anonymization support for TABLESAMPLE -- Change by ZetaSQL Team <[email protected]>: Removing IdString::data() -- Change by ZetaSQL Team <[email protected]>: Add helper functions to FunctionCallBuilder for the $case_no_value and $not functions -- Change by ZetaSQL Team <[email protected]>: Used TypedList instead of TypedRange as a container for values of Range type -- Change by ZetaSQL Team <[email protected]>: add helper: IntervalValue.isZero -- Change by ZetaSQL Team <[email protected]>: Create a helper function to build the AggregateScan for the LIKE ANY and LIKE ALL <subquery> cases -- Change by ZetaSQL Team <[email protected]>: Add ARRAY_SLICE reference implementation and compliance test -- Change by ZetaSQL Team <[email protected]>: Update the ColumnFactory::MakeCol function to support collation when creating columns -- Change by ZetaSQL Team <[email protected]>: Changes to the semantics of the LIKE ALL operator to comply with discussed changes when handling NULL patterns -- Change by ZetaSQL Team <[email protected]>: fix bug that COLLATE() function validates number of arguments in a wrong position. -- Change by ZetaSQL Team <[email protected]>: Add a KitchenSinkEnumPB type with a required enum to the test_schema -- Change by ZetaSQL Team <[email protected]>: Delete a pointer to Type from TypedList since it's not used -- Change by ZetaSQL Team <[email protected]>: Rollback @nullable annotation added in CL 464181150. -- Change by ZetaSQL Team <[email protected]>: Add non-determinism to evaluation context for ARRAY_FILTER and ARRAY_TRANSFORM reference implementation function eval -- Change by ZetaSQL Team <[email protected]>: Fix returning clause sql builder when there are table alias and column alias. -- Change by ZetaSQL Team <[email protected]>: Fix bug in reference implementation of $like_any_array and $like_all_array causing errors for certain ARRAY cases -- Change by ZetaSQL Team <[email protected]>: Add error messages to opaque `Preconditions.checkState()` calls in `Value`, so callers can tell what mistake they made without reading the code. -- Change by ZetaSQL Team <[email protected]>: Support "RANGE" type in parser -- Change by ZetaSQL Team <[email protected]>: When the parse location record type is FULL_SCOPE, make the location of an array element call include both the array expr and the index, like what the parser AST does. -- Change by ZetaSQL Team <[email protected]>: Add ARRAY_SLICE reference implementation and compliance test -- Change by ZetaSQL Team <[email protected]>: Documentation for WITH expression -- Change by ZetaSQL Team <[email protected]>: Add ARRAY_SLICE reference implementation and compliance test -- Change by ZetaSQL Team <[email protected]>: Implement range type serialization/deserialization to/from TypeProto. -- Change by ZetaSQL Team <[email protected]>: Fix the default set of rewrites for the execute_query tool to be the 'ALL' set, instead of 'NONE'. -- Change by ZetaSQL Team <[email protected]>: Fix regex to match string literals with ')' in parser tests -- Change by ZetaSQL Team <[email protected]>: Add ARRAY_SLICE builtin function signature and rewriter -- Change by ZetaSQL Team <[email protected]>: Fix NOLINT comment - START/END should be matching -- Change by ZetaSQL Team <[email protected]>: Fix collation propagation on resolved column for rewriter's internal API AnalyzeSubstitute by re-designing the substitute framework. -- Change by ZetaSQL Team <[email protected]>: Rename the test_outcome field of ComplianceTestCaseLables to test_error_mode so it's more clear when reading a message of this time what that field means. -- Change by ZetaSQL Team <[email protected]>: fix bug that the variables inside a procedure are checked against the variables outside of the procedure. -- Change by ZetaSQL Team <[email protected]>: Make ValidateTypeProto error message more clear if passed argument is empty proto -- Change by ZetaSQL Team <[email protected]>: Resolve bug in FlattenRewriter that generated invalid ResolvedASTs for some query shapes. -- Change by ZetaSQL Team <[email protected]>: Accommodate NULL templates in RET_CHECK() post-resolving Format() calls. -- Change by ZetaSQL Team <[email protected]>: Minor change to FORMAT error handling for invalid specifiers. -- Change by ZetaSQL Team <[email protected]>: remove the flag to defer folding errors to runtime. -- Change by Matthew Brown <[email protected]>: Fix parse tree for IN expression -- Change by ZetaSQL Team <[email protected]>: Factor code for processing the file based test segments out of SQLTestBase. Provides a strongly typed API for SQLTestBase to interact with the [key=...] options in filebase test segments. More importantly, this consolidates the validating and parsing of those options into a single place instead of being spread all over the expansive SQLTestBase class. In some cases (such as required_features) the same option was being parsed as each time it was used. -- Change by Matthew Brown <[email protected]>: ZetaSQL: Fix RoundingMode in java client -- Change by ZetaSQL Team <[email protected]>: Canonicalize CAST-ing and FORMAT-ing NaN and 0 to not be signed. -- Change by ZetaSQL Team <[email protected]>: Add compliance test labels to undeclared output file -- Change by Matthew Brown <[email protected]>: ZetaSQL: Fix formatter for ZetaSQL, release basic test -- Change by Matthew Brown <[email protected]>: Fix parse tree for BETWEEN and << expressions (And 289 more changes) GitOrigin-RevId: 58a2a39ffafcb968074d8d3217b186df3a532287 Change-Id: Id3f7e303be7d73b20647de35e4756d0b9c523b74
Export of internal ZetaSQL changes.
Major changes:
We now require bazel 4.0.0
GRPC and Protobuf have been upgraded
- Older version may still work, but are not being tested
Mac builds should be improved
WORKSPACE management is different (if you require java), please
see WORKSPACE file for more info
maven_install rule is now used for java dependencies, which may
affect how bazel-based java builds work.
--
Change by Matthew Brown <[email protected]>:
Fix some spammy warnings in ZetaSQL
--
Change by ZetaSQL Team <[email protected]>:
Fix interactions between joins and value tables
--
Change by ZetaSQL Team <[email protected]>:
Use the KW_EXCEPT_IN_SET_OP constant rather than a string in the grammar.
--
Change by Matthew Brown <[email protected]>:
Fix macos Builds in ZetaSQL
- Clang-based builds (like the default on mac) seem to have trouble with
some of the gcc-style warning suppression - so we just spam out
all the warnings.
- Some high-frequency warnings will be cleaned up in a follow-on CL
--
Change by ZetaSQL Team <[email protected]>:
Add annotation to error message when casting a STRING to INTERVAL, which is not a valid INTERVAL value.
--
Change by ZetaSQL Team <[email protected]>:
Fixes SqlBuilder component for `EXCEPT DISTINCT` statements and adds a regression test.
Bug identified by GitHub user @JordyHeusdensDT and fix first proposed in #82
--
Change by ZetaSQL Team <[email protected]>:
INTERNAL
--
Change by ZetaSQL Team <[email protected]>:
rename tvf_bad_call_error_message to mismatch_message.
--
Change by Matthew Brown <[email protected]>:
ZetaSQL: Upgrade GRPC
--
Change by ZetaSQL Team <[email protected]>:
Switch Value::Struct to Value::MakeStruct to handle errors gracefully.
--
Change by ZetaSQL Team <[email protected]>:
INTERNAL
--
Change by Matthew Brown <[email protected]>:
ZetaSQL: Upgrade several java dependencies to newer versions
--
Change by ZetaSQL Team <[email protected]>:
Remove some dead code.
--
Change by Matthew Brown <[email protected]>:
Stop storing a pointer to language options (make a copy instead)
--
Change by Matthew Brown <[email protected]>:
Propagate language options into parser when resolving TemplatedSqlUdf
--
Change by ZetaSQL Team <[email protected]>:
Add COTH to ZetaSQL as part of adding new math functions
--
Change by ZetaSQL Team <[email protected]>:
Add SECH to ZetaSQL as part of adding new math functions
--
Change by ZetaSQL Team <[email protected]>:
Add CSCH to ZetaSQL as part of adding new math functions
--
Change by Matthew Brown <[email protected]>:
ZetaSQL: Require bazel 4.0.0+
--
Change by ZetaSQL Team <[email protected]>:
Fix RET_CHECK failure in ResolveArrayElement related to FLATTEN.
--
Change by ZetaSQL Team <[email protected]>:
Documentation for braced new constructors.
--
Change by Matthew Brown <[email protected]>:
ZetaSQL: Update protobuf version to 3.19.3
GitOrigin-RevId: 185a07d6cd6ba697ac569f3df298f9a38b24e51c
Change-Id: I454d4947229bb3aa51706923e37f55ab0919eb0b
Export of internal ZetaSQL changes. ZetaSQL now requires gcc8+ -- Change by ZetaSQL Team <[email protected]>: Add collation support for COUNT(DISTINCT) in reference implementation. -- Change by ZetaSQL Team <[email protected]>: Add collation support for $case_with_value function in reference implementation. -- Change by ZetaSQL Team <[email protected]>: Fix zetaSQL analyzer tests that were broken by a missed include. -- Change by ZetaSQL Team <[email protected]>: fix ALTER TABLE RENAME COLUMN error message while combining with other action -- Change by ZetaSQL Team <[email protected]>: Refactoring function to fetch collation name from ResolvedCollation object. -- Change by ZetaSQL Team <[email protected]>: Running IWYU and clean_builder on "types" project. -- Change by ZetaSQL Team <[email protected]>: Rename FunctionArgumentTypeOptions::affects_function_collation -- Change by ZetaSQL Team <[email protected]>: Fix internal error in SQLBuilder. -- Change by ZetaSQL Team <[email protected]>: Add test case to prove HAVING clause could handle collation correctly -- Change by ZetaSQL Team <[email protected]>: propagates collation through MakeResolvedCast in type casting case -- Change by ZetaSQL Team <[email protected]>: Support anonymization userid column for TVFs returning value tables. -- Change by ZetaSQL Team <[email protected]>: Remove deprecated and unused field `ResolvedCreateFunctionStmt::return_type` -- Change by ZetaSQL Team <[email protected]>: Add a comment in all_rewriters that causes clang-format to bin-pack in a way that is less likely to cause line conflicts between changes. -- Change by ZetaSQL Team <[email protected]>: Add collation support for STARTS_WITH/ENDS_WITH functions in reference implementation. -- Change by ZetaSQL Team <[email protected]>: Adds a dedicated function to recursively print annotation values with a specific AnnotationSpec ID. -- Change by ZetaSQL Team <[email protected]>: resolve collation for any aggregate function call with is_distinct==true -- Change by ZetaSQL Team <[email protected]>: Add compliance tests for collation features with JOIN and HAVING. -- Change by ZetaSQL Team <[email protected]>: change collation handling options on several built-in functions -- Change by Matthew Brown <[email protected]>: Add sql_mode to execute_query to allow evaluating sql expressions -- Change by ZetaSQL Team <[email protected]>: Add test to prove that collation propagation works in qualify clause. -- Change by ZetaSQL Team <[email protected]>: Adjust required features in `tablesample.test` so that compliance tests for regular `TABLESAMPLE` aren't gated on the stratified version. -- Change by ZetaSQL Team <[email protected]>: Add more compliance tests for collation features with collation name being 'binary'. -- Change by ZetaSQL Team <[email protected]>: Add deprecated annotation to some already deprecated functions. #cleanup -- Change by ZetaSQL Team <[email protected]>: For CTAS, propagates collation from the select query output column list to column definition list. -- Change by ZetaSQL Team <[email protected]>: generate ResolvedCast node when casting string collation into string without collation. -- Change by ZetaSQL Team <[email protected]>: Set preserve_in_literal_remover field of second argument of COLLATE function. Also did a small cleanup for resolved_ast validator. -- Change by ZetaSQL Team <[email protected]>: Convert one more `AddCastOrConvertLiteral` to `CoerceExprToType`. In this case, we are incidentally moving the error message parser location. Either location is reasonable. Before we were pointing at the `RETURNS` clause if the `CoercesTo` check failed but pointing at the function body if the literal conversion failed. Now we are pointing to the function body in both cases. -- Change by Matthew Brown <[email protected]>: Refactor replace_with_collation compliance tests; add explicit testing of 'und' -- Change by ZetaSQL Team <[email protected]>: Change type and message for a few collation-related error. This would make known-error detection easier for random query tests. -- Change by ZetaSQL Team <[email protected]>: Convert two more simple cases `AddCastOrConvertLiteral` to `CoerceExprToType`. -- Change by ZetaSQL Team <[email protected]>: Cleanup. Resolve TODO by moving `SelectListColumn` classes from expr_resolution_helper.h to query_resolution_helper.h -- Change by ZetaSQL Team <[email protected]>: Cleanup the construction of `SelectColumnState` to make it more like a class according to our syleguide. Use unique_ptr to transfer ownership and include the mostly commonly initialized fields as constructor arguments. -- Change by ZetaSQL Team <[email protected]>: Add a team policy that attaches or replaces a ParseLocation to a status when propagated using RETURN_IF_ERROR or ASSIGN_OR_RETURN. There is an existing macro `RETURN_SQL_ERROR_AT_IF_ERROR` that is similar. There are two differences. The new `LocationOverride` team policy only overrides the attached parse location. It doesn't also override the error code. This makes it much less likely that its usage will cause accidental consumption of kInternal, kResourceExhausted, kUnimplemented and other error codes that the using code didn't expect to be handed. The second difference is a bit more cosmetic, we use the TeamPolicy idiom instead of defining our own macro. -- Change by ZetaSQL Team <[email protected]>: Add more tests related to `SELECT AS <prototype> <literal>` -- Change by ZetaSQL Team <[email protected]>: [Bug Fix] Avoid algrebrizing Empty ResolvedCollation for KeyArg AggregateOp. -- Change by ZetaSQL Team <[email protected]>: Support label in GetNextStatementProperties. -- Change by ZetaSQL Team <[email protected]>: Migrate calls to `AddCastOrConvertLiteral` to the more idiomatic and less likely to use incorrectly `CoerceExprToType`. This is a yak-shaving cleanup that will hopefully reduce copy-paste bugs and makes existing code more readable. -- Change by ZetaSQL Team <[email protected]>: Add some more interesting corner case tests regarding `LIMIT` -- Change by ZetaSQL Team <[email protected]>: Add a `GetStatementProperties` test to verify correct behavior for struct variable assignment. -- Change by ZetaSQL Team <[email protected]>: Fix implementation of TO_JSON_STRING for JSON inputs when pretty_print is true. -- Change by ZetaSQL Team <[email protected]>: Refactor `CoerceExprToType` to be a bit more convenient and a bit more readable. Change the boolean argument that controls coercion mode into an enum. The enum will allow more modes and makes callsites more readable. Remove the overload taking `char* clause_name` and replace it with two overloads, one taking a complete error message template (for custom error message without a lambda) and another with no error message parameter to return the generic template (the equivalent of providing a nullptr to `cluase_name` before). -- Change by ZetaSQL Team <[email protected]>: Add collation support for STRPOS/INSTR functions in reference implementation. -- Change by ZetaSQL Team <[email protected]>: Support several missed statement types in GetNextStatementProperties. -- Change by ZetaSQL Team <[email protected]>: Update structure of signatures for aggregate functions. -- Change by ZetaSQL Team <[email protected]>: Reference impl for ARRAY_INCLUDES functions. -- Change by ZetaSQL Team <[email protected]>: Add a test to show behavior for window spec with literal `>=2^63` -- Change by ZetaSQL Team <[email protected]>: Add no-op case in `FunctionResolver::AddCastOrConvertLiteral` and simplify callsites that previously checked for unequal types. -- Change by ZetaSQL Team <[email protected]>: Bugfix. Do not override `has_explicit_type` in `ConvertLiteralToType` unless `set_has_explicit_type` is true. -- Change by ZetaSQL Team <[email protected]>: Update error message when an INTERVAL literal contains an expression that is neither INT64 or string literal. -- (And 276 more changes) GitOrigin-RevId: 25c5bf17ad00c8b8f341b2cf15da3d94ec95b796 Change-Id: I8128bb928a617c1256ae766d129a311891588fa7