Results of 1 - 7 of about 7 for rely (0.001 sec.)
- ALTER TABLE Statement 12977
- The ALTER TABLE statement changes the schema of an existing table in the catalog. Examples CREATE TABLE integers (i INTEGER, j INTEGER); Add a new column with name k to the table integers , it will be filled with the default value NULL : AL
...E TO integers_old; The RENAME TO clause renames an entire table, changing its name in the schema. Note that any views that rely on the table are not automatically updated. New As of DuckDB 2.0, ALTER TABLE ⟨view⟩ RENAME TO ⟨new_name⟩ can also rename...LTER TABLE integers RENAME i TO j; The RENAME [COLUMN] clause renames a single column within a table. Any constraints that rely on this name (e.g., CHECK constraints) are automatically updated. However, note that any views that rely on this column na...se can be used to remove a column from a table. Note that columns can only be removed if they do not have any indexes that rely on them. This includes any indexes created as part of a PRIMARY KEY or UNIQUE constraint. Columns that are part of multi-c... - https://man.mtool.work/duckdb/2.0/sql/statements/alter_table.html
- ALTER VIEW Statement 10342
- The ALTER VIEW statement changes the schema of an existing view in the catalog. Examples Rename a view: ALTER VIEW view1 RENAME TO view2; ALTER VIEW changes the schema of an existing view. All the changes made by ALTER VIEW fully respect th
...be visible to other transactions until committed, and can be fully reverted through a rollback. Note that other views that rely on the view are not automatically updated.... - https://man.mtool.work/duckdb/2.0/sql/statements/alter_view.html
- Lambda Functions 8797
- DuckDB lambda functions (a.k.a. 'lambdas' or 'lambda expressions') are expressions that define an inline anonymous function. Lambdas are passed as argument to certain list functions , which evaluate the passed lambda expression against its
...d the like. The expression may contain macro invocations. However, only scalar macros are allowed, and only if they do not rely on a subquery. For example, the following are all valid lambda functions: lambda param : param > 1 lambda s : contains(con...on can contain macro calls, but only if the macro is a scalar macro. In addition, the macro must not contain a subquery or rely on another macro that contains a subquery. 3) lambda functions must be defined inline as argument to the list function. Yo...arrow' to revert to the deprecated behavior. DuckDB 2.1 will remove the lambda_syntax flag and the single arrow syntax entirely, so the old behavior will no longer be possible.... - https://man.mtool.work/duckdb/2.0/sql/functions/lambda.html
- Result Verification 8142
- The standard way of verifying results of queries is using the query statement, followed by the letter I times the number of columns that are expected in the result. After the query, four dashes ( ---- ) are expected followed by the result v
...: query I rowsort SELECT 'world' UNION ALL SELECT 'hello' ---- hello world In general, we prefer not to use this field and rely on ORDER BY in the query to generate deterministic query answers. However, existing sqllogictests use this field extensive... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/result_verification.html
- Schema 8142
- Types It is important to use the correct type for encoding columns (e.g., BIGINT , DATE , DATETIME ). While it is always possible to use string types ( VARCHAR , etc.) to encode more specific values, this is not recommended. Strings use mor
...ve a negative effect on load performance as they necessitate building indexes and performing checks. Moreover, they very rarely improve the performance of queries as DuckDB does not rely on these indexes for join and aggregation operators (see indexi... - https://man.mtool.work/duckdb/2.0/guides/performance/schema.html
- Security 7688
- This page covers Quack's security posture end to end: what the server exposes, what stays local, the role of a TLS-terminating reverse proxy, and the authentication / authorization callbacks the server runs on every connection and every que
...means they can read tables, call other UDFs, and reference extensions, but each invocation starts a new session and cannot rely on session-local state. Authentication Hook The server invokes the authentication function by issuing the following SQL st... - https://man.mtool.work/duckdb/2.0/quack/security.html
- CREATE MACRO Statement 7470
- The CREATE MACRO statement defines a named, callable SQL expression as a database schema object. Macros may declare parameters, which can be referenced by its expression. Once a macro is created, it may be called by referencing its name and
...le evaluated at definition-time - NOT at run-time. (There are a few exceptions, like CURRENT_SCHEMA . But it's best not to rely on that: if you need a default value to be dynamic, use a well-known value like NULL as default and use conditional logic... - https://man.mtool.work/duckdb/2.0/sql/statements/create_macro.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work