Results of 1 - 5 of about 5 for volatile (0.004 sec.)
- TRY Expression 12851
- The TRY expression ensures that errors caused by the input rows in the child (scalar) expression result in NULL for those rows, instead of causing the query to throw an error. The TRY expression was inspired by the TRY_CAST expression . Exa
..., ('235')) t(a)) SELECT TRY(a::INTEGER) AS x FROM cte; x 123 NULL 235 Limitations TRY cannot be used in combination with a volatile function, an aggregate function, or a scalar subquery . For example: SELECT TRY(random()) Binder Error: TRY can not be use...d in combination with a volatile function... - https://man.mtool.work/duckdb/2.0/sql/expressions/try.html
- Complete API 8548
- This page contains the reference for DuckDB's C API. The reference contains several deprecation notices. These concern methods whose long-term availability is not guaranteed as they may be removed in the future. That said, DuckDB's develope
...id duckdb_scalar_function_set_special_handling ( duckdb_scalar_function scalar_function ); void duckdb_scalar_function_set_volatile ( duckdb_scalar_function scalar_function ); void duckdb_scalar_function_add_parameter ( duckdb_scalar_function scalar_func...g ( duckdb_scalar_function scalar_function ); Parameters scalar_function : The scalar function. duckdb_scalar_function_set_volatile Sets the Function Stability of the scalar function to VOLATILE, indicating the function should be re-run for every row. Th...is limits optimization that can be performed for the function. Syntax void duckdb_scalar_function_set_volatile ( duckdb_scalar_function scalar_function ); Parameters scalar_function : The scalar function. duckdb_scalar_function_add_p... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- Write User Defined Functions 8328
- Overview The JDBC driver can register user-defined functions (UDFs) written in Java, including scalar functions and table functions. This page covers building and registering both, from the simple functional-interface overloads to the vecto
...is NULL . The engine does not always take this shortcut, so an object callback should still check its arguments for null . Volatile Functions DuckDB may treat a scalar function as deterministic and cache or constant-fold its result for repeated inputs. C...all withVolatile() for a function whose output can change between calls with the same arguments — for example one that reads external state...withVarArgs(DuckDBLogicalType) withVarArgsFunction(Function<Object[], ?>) withVectorizedFunction(DuckDBScalarFunction) withVolatile() withNullInNullOut() register(java.sql.Connection) Table Functions Build a table function with the DuckDBFunctions.tableF... - https://man.mtool.work/duckdb/2.0/clients/java/functions.html
- DuckDB_% Metadata Functions 8089
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
...f using the function. Used to generate the documentation. VARCHAR[] stability The stability of the function ( CONSISTENT , VOLATILE , CONSISTENT_WITHIN_QUERY or NULL ) VARCHAR categories Categories of the function. Used to generate the documentation. VAR... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- WITH Clause 8089
- The WITH clause allows you to specify common table expressions (CTEs). Regular (non-recursive) common-table-expressions are essentially views that are limited in scope to a particular query. CTEs can reference each other and can be nested.
...Inlining is done using the following heuristics: * The CTE is not referenced more than once. * The CTE does not contain a VOLATILE function. * The CTE is using AS NOT MATERIALIZED and does not use AS MATERIALIZED . * The CTE does not perform a grouped a... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/with.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work