Results of 1 - 10 of about 106 for because (0.002 sec.)
- sqllogictest Introduction 11728
- 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
...e relative file path of the file. The group is the folder that the file is in. The name and group of the test are relevant because they can be used to execute only that test in the unittest group. For example, if we wanted to execute only the above test...zed version of the query, and verifying that the results of these queries are identical. Query verification is very useful because it not only discovers bugs in optimizers, but also finds bugs in e.g., join implementations. This is because the unoptimiz...ed version will typically run using cross products instead. Because of this, query verification can be very slow to do when working with larger datasets. It is therefore recommended to turn... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/intro.html
- SQL Quirks 10344
- Like all programming languages and libraries, DuckDB has its share of idiosyncrasies and inconsistencies. Some are vestiges of our feathered friend's evolution; others are inevitable because we strive to adhere to the SQL Standard and speci
...xing . Types UINT8 vs. INT8 UINT8 and INT8 are aliases to integer types of different widths: UINT8 corresponds to UTINYINT because it's an 8-bit unsigned integer INT8 corresponds to BIGINT because it's an 8-byte signed integer Explanation: the n in the.../ map_extract_value return NULL on non-existing keys ( map_extract returns an empty list). struct_extract throws an error because keys of structs are like columns. Clauses Automatic Column Deduplication in SELECT Column names are deduplicated with the... - https://man.mtool.work/duckdb/2.0/sql/dialect/sql_quirks.html
- SQL Introduction 10344
- This page provides an overview of how to perform simple operations in SQL. This tutorial is only intended to give you an introduction and is in no way a complete tutorial on SQL. This tutorial is adapted from the PostgreSQL tutorial . DuckD
...k with in the following sections. Alternatively, you can use the COPY statement . This is faster for large amounts of data because the COPY command is optimized for bulk loading while allowing less flexibility than INSERT . An example with weather.csv w...Francisco -194.000 53.000 Observe two things about the result set: There is no result row for the city of Hayward. This is because there is no matching entry in the cities table for Hayward, so the join ignores the unmatched rows in the weather table. W...e will see shortly how this can be fixed. There are two columns containing the city name. This is correct because the lists of columns from the weather and cities tables are concatenated. In practice this is undesirable, though, so you... - https://man.mtool.work/duckdb/2.0/sql/introduction.html
- Internal Errors 9946
- 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
...here any further operations will result in the following error message: FATAL Error: Failed: database has been invalidated because of a previous fatal error. The database must be restarted prior to being used again. To continue working with the same dat...abase, start a new DuckDB session on the same database. The reason DuckDB enters “restricted mode” is because the database is in an undefined state. Internal errors are by definition bugs that should never happen so the code path is... - https://man.mtool.work/duckdb/2.0/dev/internal_errors.html
- Subqueries 9549
- Subqueries are parenthesized query expressions that appear as part of a larger, outer query. Subqueries are usually based on SELECT ... FROM , but in DuckDB other query constructs such as PIVOT can also appear as a subquery. Scalar Subquery
...comparison operator all evaluate to true : SELECT 6 <= ALL (SELECT grade FROM grades) AS adequate; returns: adequate true because 6 is less than or equal to each of the subquery results 7, 8 and 9. However, the following query SELECT 8 >= ALL (SELECT g...rade FROM grades) AS excellent; returns excellent false because 8 is not greater than or equal to the subquery result 9. And thus, because not all comparisons evaluate to true , >= ALL a...comparison results evaluates to true . For example: SELECT 5 >= ANY (SELECT grade FROM grades) AS fail; returns fail false because no result of the subquery is less than or equal to 5. The quantifier SOME may be used instead of ANY : ANY and SOME are in... - https://man.mtool.work/duckdb/2.0/sql/expressions/subqueries.html
- Troubleshoot 9357
- Overview This page collects common issues encountered when using the DuckDB Rust client, together with their workarounds. If you run into a problem that is not covered here, search the client's issue tracker on GitHub. Linking against a Sys
...version from GitHub Releases, caches it under target/ , and adds it to the linker search path. Leave DUCKDB_STATIC unset, because the downloaded archives contain only the dynamic library: DUCKDB_DOWNLOAD_LIB=1 cargo build Use a Package Manager If DuckD...atic libraries by default; set VCPKGRS_DYNAMIC=1 to link dynamically instead. ICU Extension Missing from the Bundled Build Because crates.io imposes a 10 MB package-size limit, the bundled source of earlier crate versions excluded the icu extension . In...en it is enabled, entry points such as Connection::open_in_memory() panic if they are called outside an extension context, because there is no host DuckDB instance to attach to. Do not enable loadable-extension for a client application. Use it only when... - https://man.mtool.work/duckdb/2.0/clients/rust/troubleshoot.html
- Troubleshoot 9152
- Overview This page collects common issues encountered when using DuckDB-Wasm, together with their workarounds. If you run into a problem that is not covered here, search the duckdb-wasm issue tracker on GitHub. Network Error When Querying R
...olicy), not a value you pass to DuckDB-Wasm. There is no db or connection option and no DuckDBGlobalFileInfo field for it, because the browser, not DuckDB-Wasm, enforces CORS. Apply it where the data is hosted, then read the file as usual. Beyond CORS,...reading remote files has several other known limitations: Because every request is upgraded to HTTPS, an http:// URL can be rewritten incorrectly (for example to https://http//… ), which b...arge results with send() instead of materializing them all at once with query() . Read only the columns and rows you need. Because DuckDB reads Parquet files lazily, projections, filters, and LIMIT clauses let entire row groups be skipped rather than lo... - https://man.mtool.work/duckdb/2.0/clients/wasm/troubleshoot.html
- Instantiate 8959
- Overview DuckDB-Wasm can be instantiated in several ways, depending on how your application bundles and serves its assets. Each approach resolves the mainModule (the WebAssembly file) and the mainWorker (the worker script) for the browser's
...run queries . Bundle Selection DuckDB-Wasm ships several WebAssembly modules compiled for different browser feature sets, because post-MVP WebAssembly features reach browsers at different speeds and each one can bring a flat performance improvement. Th...JsDelivrBundles() returns the set of bundles hosted on jsDelivr , and selectBundle picks the one that matches the browser. Because a Web Worker script must be same-origin, the CDN worker URL is wrapped in a Blob that importScripts it, and the temporary...meta.url) so that webpack fingerprints them and rewrites the paths to the emitted files. The bundles are declared manually because their final locations are known only after the build, and selectBundle then chooses between the mvp and eh variants at run... - https://man.mtool.work/duckdb/2.0/clients/wasm/instantiation.html
- Load Extensions 8370
- Overview DuckDB-Wasm's (dynamic) extension loading is modeled after regular DuckDB's extension loading, with a few relevant differences due to the difference in platform. A growing subset of core, community, and external extensions is suppo
...checks and dynamic load the binary with the main DuckDB binary. In DuckDB-Wasm, INSTALL performs no durable installation, because there is no cross-session storage; it only records where an extension will be fetched from (for example, with INSTALL ⟨nam...es for DuckDB-hosted extensions are documented below. HTTPFS The native HTTPFS extension is not compiled into DuckDB-Wasm, because HTTPS capabilities have to go through an additional layer, the browser, which adds both differences and some restrictions...cases, as it must follow the security rules imposed by the browser. In particular: Requests are always upgraded to HTTPS. Because of the browser's CORS policy, any request for data must target a site that allows (using CORS headers) the site hosting th... - https://man.mtool.work/duckdb/2.0/clients/wasm/extensions.html
- CREATE SEQUENCE Statement 8370
- The CREATE SEQUENCE statement creates a new sequence number generator. Examples Generate an ascending sequence starting from 1: CREATE SEQUENCE serial; Generate sequence from a given start number: CREATE SEQUENCE serial START 101; Generate
...ing to drop the sequence results in an error: DROP SEQUENCE id_sequence; Dependency Error: Cannot drop entry "id_sequence" because there are entries that depend on it. table "tbl" depends on sequence "id_sequence". Use DROP...CASCADE to drop all depende...eason, CREATE OR REPLACE SEQUENCE fails when the sequence is referenced by another object, such as a column DEFAULT value, because the replacement first drops the existing sequence: CREATE OR REPLACE SEQUENCE id_sequence; Dependency Error: Cannot drop e...ntry "id_sequence" because there are entries that depend on it. table "tbl" depends on sequence "id_sequence". Use DROP...CASCADE to drop all depende... - https://man.mtool.work/duckdb/2.0/sql/statements/create_sequence.html
DuckDB 2.0 Documentation / man.mtool.work