Results of 1 - 10 of about 18 for logic (0.002 sec.)
- Logical Operators 12731
- The following logical operators are available: AND , OR and NOT . SQL uses a three-valued logic system with true , false and NULL . Note that logical operators involving NULL do not always evaluate to NULL . For example, NULL AND false will
... - https://man.mtool.work/duckdb/2.0/sql/expressions/logical_operators.html
- Internal Errors 12216
- Internal errors signal an assertion failure within DuckDB. They usually occur due to unexpected conditions or errors in the program's logic. For example, running issue 17002 on DuckDB 1.2.1 results in an internal error. INTERNAL Error: Atte
... - https://man.mtool.work/duckdb/2.0/dev/internal_errors.html
- Merge Statement for SCD Type 2 10655
- This is a practical, step-by-step guide to using DuckDB's MERGE statement (introduced in v1.4.0) to perform upserts and build Slowly Changing Dimension Type 2 (SCD Type 2) tables . Type 2 SCDs let you keep full historical versions of record
...statement for INSERT , UPDATE , and soft DELETE (upsert and expire). Much cleaner and faster than equivalent Python/Pandas logic. Full history tracking without hard deletes. Works directly on Parquet, CSV, databases, thanks to DuckDB's connectivity! P...merge, it will check for differences between the data of target and source and follow the WHEN MATCHED or WHEN NOT MATCHED logic specified. MERGE INTO master_ducks AS target USING incoming_ducks AS source ON target.duck_id = source.duck_id AND target.... - https://man.mtool.work/duckdb/2.0/guides/sql_features/merge.html
- Numeric Types 10123
- Fixed-Width Integer Types The types TINYINT , SMALLINT , INTEGER , BIGINT and HUGEINT store whole numbers, that is, numbers without fractional components, of various ranges. Attempts to store values outside of the allowed range will result
...floating-point or fixed-point types to integers means that the source numbers are rounded. The following default rounding logic applies: Casting from FLOAT and DOUBLE to integers of any size: round to the nearest integer, with ties (halfs) rounded to...literals are treated as DECIMALs text ┌────────┐ │ result │ │ int32 │ ├────────┤ │ 3 │ └────────┘ If non-default rounding logic is required, functions like ceil , floor , round and round_even should be used. Functions See Numeric Functions and Operat... - https://man.mtool.work/duckdb/2.0/sql/data_types/numeric.html
- FROM and JOIN Clauses 9093
- The FROM clause specifies the source of the data on which the remainder of the query should operate. Logically, the FROM clause is where the query starts execution. The FROM clause can contain a single table, a combination of multiple table
...using a semi or anti join the result will never have more rows than the left hand side table. Semi joins provide the same logic as the IN operator statement. Anti joins provide the same logic as the NOT IN operator, except anti joins ignore NULL valu... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/from.html
- DuckDB Wasm Client 8579
- Installation To use the DuckDB Wasm client, visit the duckdb-wasm GitHub repository . The latest stable version of the DuckDB WebAssembly client is 2.0.0. DuckDB-Wasm is a version of DuckDB that has been compiled to WebAssembly , the portab
...ng DuckDB-Wasm exchange data efficiently and interoperate with other JavaScript data tools without reimplementing SQL type logic in JavaScript. DuckDB-Wasm is built on a virtual filesystem that treats local files, remote HTTP(S) servers and in-memory... - https://man.mtool.work/duckdb/2.0/clients/wasm/overview.html
- sqllogictest Introduction 8579
- For testing plain SQL, we use an extended version of the SQL logic test suite, adopted from SQLite . Every test is a single self-contained file located in the test/sql directory. To run tests located outside of the default test directory, s
...n the test directory are automatically added to the test suite. Note that the extension of the test is significant. The sqllogictests should either use the .test extension, or the .test_slow extension. The .test_slow extension indicates that the test...for all unit tests, except those involving larger datasets (more than ~10-100 rows). Editors & Syntax Highlighting The sqllogictests are not exactly an industry standard, but several other systems have adopted them as well. Parsing sqllogictests is i.... A syntax highlighter exists for Visual Studio Code . We have also made a fork that supports the DuckDB dialect of the sqllogictests . You can use the fork by installing the original, then copying the syntaxes/sqllogictest.tmLanguage.json into the in... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/intro.html
- Indexes 8579
- Index Types DuckDB has two built-in index types. Indexes can also be defined via extensions . Min-Max Index (Zonemap) A min-max index (also known as zonemap or block range index) is automatically created for columns of all general-purpose d
...nstraint. A workaround is to split the UPDATE into a DELETE ... RETURNING ... followed by an INSERT , with some additional logic to (temporarily) store the result of the DELETE . All statements should be run inside a transaction via BEGIN , and eventu... - https://man.mtool.work/duckdb/2.0/sql/indexes.html
- PostgreSQL Extension and the Secret Manager 8047
- User credentials and other PostgreSQL database connection details can be stored using the DuckDB Secrets Manager . The following syntax can be used to create a secret: CREATE SECRET ( TYPE postgres, HOST '127.0.0.1', PORT 5432, DATABASE pos
...s --region eu-west-1)" Configuring Secrets for IAM Authentication Authentication from the postgres extension uses the same logic as with psql : The secret of type rds is used to generate the authentication token, it takes the same configuration parame... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/secrets.html
- Security 7532
- 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
...policies that need to record every call to a table, maintain in-process state across calls, or otherwise drive imperative logic, register a scalar function via a DuckDB extension instead. DuckDB extensions can be written in C++ (the primary language)... - https://man.mtool.work/duckdb/2.0/quack/security.html
DuckDB 2.0 Documentation / man.mtool.work