Results of 1 - 10 of about 15 for outside (0.002 sec.)
- Numeric Types 14908
- 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
...T , USMALLINT , UINTEGER , UBIGINT and UHUGEINT store whole unsigned numbers. Attempts to store negative numbers or values outside of the allowed range will result in an error. Name Aliases Min Max Size in bytes TINYINT INT1 - 2^7 2^7 - 1 1 SMALLINT INT...al point. The WIDTH must be between 1 and 38, and the SCALE must be between 0 and 38 and may not exceed the WIDTH . Values outside these bounds are rejected by the binder instead of being clamped: SELECT 1::DECIMAL(39, 2); Binder Error: DECIMAL type wid...The DOUBLE type typically has a range of around 1E-307 to 1E+308 with a precision of at least 15 digits. Positive numbers outside of these ranges (and negative numbers outside the mirrored ranges) may cause errors on some platforms but will usually be... - https://man.mtool.work/duckdb/2.0/sql/data_types/numeric.html
- Troubleshoot 9021
- 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
...than a client application. When 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... - https://man.mtool.work/duckdb/2.0/clients/rust/troubleshoot.html
- Pragmas 9021
- The PRAGMA statement is a SQL extension adopted by DuckDB from SQLite. PRAGMA statements can be issued in a similar manner to regular SQL statements. PRAGMA commands may alter the internal state of the database engine, and can influence the
...majority of the data processed. However, certain in-memory data structures such as vectors and query results are allocated outside of the buffer manager. Additionally, aggregate functions with complex state (e.g., list , mode , quantile , string_agg , a...nd approx functions) use memory outside of the buffer manager. Therefore, the actual memory consumption can be higher than the specified memory limit. Threads Set... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
- Import Data 8673
- Overview The Rust client offers two ways to get data into DuckDB in bulk: the high-performance Appender for inserting rows from Rust, and reading directly from data files such as Parquet, CSV, and JSON. Both are described below. Appender Th
...ll, use append_rows() : app.append_rows([[1, 2], [3, 4], [5, 6], [7, 8], [9, 10]])?; Additional constructors target tables outside the default schema: appender_to_db() takes a schema name, and appender_to_catalog_and_db() takes a catalog and a schema. T... - https://man.mtool.work/duckdb/2.0/clients/rust/data_import.html
- sqllogictest Introduction 8673
- 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
... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/intro.html
- Extension Distribution 8673
- Platforms Extension binaries are distributed for several platforms (see below). For platforms where packages for certain extensions are not available, users can build them from source and install the resulting binaries manually . Most offic
...nux_amd64_musl and linux_arm64_musl windows_amd64_mingw wasm_eh and wasm_mvp (see DuckDB-Wasm's extensions ) For platforms outside the ones listed above, we do not officially distribute extensions (e.g., linux_arm64_android ). Extensions Signing Signed... - https://man.mtool.work/duckdb/2.0/extensions/extension_distribution.html
- Appender 8324
- Use an appender to insert rows that your Python code produces. It collects rows and writes them together in one SQL statement; this is called flushing. The with block below flushes on successful exit: import duckdb con = duckdb.connect() co
...shes on successful exit. When an exception leaves the block, the buffered rows are discarded and the exception propagates. Outside a with block, call flush() to write the rows and clear() to discard them. There is no close() method. The appender remains... - https://man.mtool.work/duckdb/2.0/clients/python/appender.html
- Migrating Python Code to DuckDB 2.0 8324
- This page lists what Python code written for DuckDB 1.x must change to run on DuckDB 2.0. Each item gives the 1.x form, the 2.0 form and the page that explains it. For changes outside the Python client, see Migrating to DuckDB v2.0 . Python
... - https://man.mtool.work/duckdb/2.0/clients/python/migration.html
- Write User Defined Functions 8324
- Overview The Rust client can register user-defined functions written in Rust: scalar functions with the vscalar feature and table functions with the vtab feature. Both operate on DuckDB's columnar data chunks, so a single call processes a b
...extension. In a client application, that feature makes calls such as Connection::open_in_memory() panic, because they run outside an extension context. A plain cargo build does not produce a loadable file: DuckDB requires a file ending in .duckdb_exten... - https://man.mtool.work/duckdb/2.0/clients/rust/functions.html
- Statically Linking Extensions 8324
- This page is for client and binding authors, and for anyone who embeds libduckdb in their own application. It describes how statically linking extensions changed in DuckDB 2.0 and what builders on top of DuckDB need to do. This change is in
...stalled from the build's own extension repository and loaded the first time a query needs it. Linking the Archives by Hand Outside CMake, link one archive per extension, compile the generated loader, and put the engine archive last: LINK_EXTENSIONS='par... - https://man.mtool.work/duckdb/2.0/dev/building/linking_extensions.html
DuckDB 2.0 Documentation / man.mtool.work