Results of 1 - 10 of about 51 for fail (0.001 sec.)
- Catch C/C++ Tests 16201
- While we prefer the sqllogic tests for testing most functionality, for certain tests only SQL is not sufficient. This typically happens when you want to test the C++ API. When using pure SQL is really not an option it might be necessary to
...abase); { // create a database and insert values DuckDB db(storage_database, config.get()); Connection con(db); REQUIRE_NO_FAIL(con.Query("CREATE TABLE test (a INTEGER, b INTEGER);")); REQUIRE_NO_FAIL(con.Query("INSERT INTO test VALUES (11, 22), (13,...22), (12, 21), (NULL, NULL)")); REQUIRE_NO_FAIL(con.Query("CREATE TABLE test2 (a INTEGER);")); REQUIRE_NO_FAIL(con.Query("INSERT INTO test2 VALUES (13), (12), (11)")); }...apper to create each test. The database is created and queried using the C++ API. Results are checked using either REQUIRE_FAIL / REQUIRE_NO_FAIL (corresponding to statement ok and statement error) or REQUIRE(CHECK_COLUMN(...)) (corresponding to quer... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/catch.html
- Typecasting 9606
- Typecasting is an operation that converts a value in one particular data type to the closest corresponding value in another data type. Like other SQL engines, DuckDB supports both implicit and explicit typecasting. Explicit Casting Explicit
...e. Implicit casts can only be added for a number of type combinations, and is generally only possible when the cast cannot fail. For example, an implicit cast can be added from INTEGER to DOUBLE – but not from DOUBLE to INTEGER . Consider the functio...m wide integer or DECIMAL types to FLOAT or DOUBLE , which can lose precision. Explicit-only casts may lose information or fail for particular values. In the matrix below, rows are the source type and columns are the target type. I marks a cast the s...lable explicitly (with CAST or :: ); an empty cell marks an unsupported cast. Even where a cast is supported, it may still fail at runtime for a particular value (for example, out of range or unparseable input). Column abbreviations: BOOL (BOOLEAN),... - https://man.mtool.work/duckdb/2.0/sql/data_types/typecasting.html
- Transaction Management 9606
- DuckDB supports ACID database transactions . Transactions provide isolation, i.e., changes made by a transaction are not visible from concurrent transactions until it is committed. A transaction can also be aborted, which discards any chang
...persistent mode). To commit a transaction, run: COMMIT; If you are not in an active transaction, the COMMIT statement will fail. Rolling Back a Transaction You can abort a transaction. This operation, also known as rolling back, will discard any chan...d, which has an identical behavior: ABORT; If you are not in an active transaction, the ROLLBACK and ABORT statements will fail. Multi-Statement Transactions When multiple SQL statements are submitted together (e.g., separated by semicolons), they ar...n auto-commit mode: each statement that succeeds is committed immediately, and execution stops at the first statement that fails. Statements that ran before the failing one are not rolled back. To make a batch atomic, wrap it in an explicit transacti... - https://man.mtool.work/duckdb/2.0/sql/statements/transactions.html
- Unit Tester Configuration 9262
- There are three ways of setting options for the unit tester: Command Line Arguments Configuration File Environment Variables Configuration Options List See the Configuration Options List for the full list of available options. Command Line
...olute/remote (e.g. az://... ) values are used verbatim. --database-destroy <on|off|on-success> Default on-success: keep on failure --description <string> Config description --emit-on-skip Print a SKIP_TEST marker per skipped test --emit-test-events W...itialize Initialize buffers with all 1; also see --zero-initialize --require <extension_name> If the extension is missing: fail rather than skip tests that require it --run-id <'auto'|<string>> Override per-run identity; the RUN_ID path level; shared...--skip-compiled , --no-skip-compiled Skip compiled tests --skip-error-messages <comma-separated strings> Skip rather than fail tests that fail with a message that contains any of these substrings --skip-tag <string> Skip tests which match named tag... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/test_configuration.html
- Enum Data Type 9262
- Name Description ENUM Dictionary representing all possible string values of a column The enum type represents a dictionary data structure with all possible unique values of a column. For example, a column storing the days of the week can be
...ums You can create an enum using hardcoded values: CREATE TYPE mood AS ENUM ('sad', 'ok', 'happy'); -- This statement will fail since enums cannot hold NULL values: -- CREATE TYPE mood AS ENUM ('sad', NULL); -- This statement will fail since enum val...NTO person VALUES ('Pedro', 'happy'), ('Mark', NULL), ('Pagliacci', 'sad'), ('Mr. Mackey', 'ok'); The following query will fail since the mood type does not have a quackity-quack value. INSERT INTO person VALUES ('Hannes', 'quackity-quack'); Enums vs... - https://man.mtool.work/duckdb/2.0/sql/data_types/enum.html
- Unity Catalog Extension 8767
- The unity_catalog extension attaches a Unity Catalog catalog, on Databricks or Unity Catalog OSS, as a DuckDB database. You can list, read, insert into and create its Delta Lake tables. It uses the delta extension to access the tables. For
...amespace. When you attach a Unity Catalog OSS catalog, always set DEFAULT_SCHEMA : without it, queries against the catalog fail, even with fully qualified table names. Attach Options When attaching a Unity Catalog catalog, you can pass the following...atest version committed at or before that time. A timestamp before the table's first commit or later than the current time fails with an error. Writing To append rows, use INSERT INTO : INSERT INTO my_catalog.my_schema.my_table VALUES (1, 'hello'); I...v1.5.6, a column of a type that DuckDB cannot read is listed with the type UNKNOWN , e.g., in DESCRIBE . Reading the table fails with an error that names the column. VARIANT Columns New Support for VARIANT columns was introduced in DuckDB 2.0. Unity... - https://man.mtool.work/duckdb/2.0/core_extensions/unity_catalog.html
- Troubleshoot 8602
- 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
...rs) the origin that hosts the DuckDB-Wasm instance to read it. If the server does not send the required headers, the query fails with a network error such as: Failed to execute 'send' on 'XMLHttpRequest' For example, when querying files from Amazon S...oints (see duckdb-wasm issue #2118 ). DuckDB relies on HTTP range requests to read only part of a file. Range requests can fail on Firefox (see issue #1932 ) and are not detected correctly for some S3 pre-signed URLs (see issue #2228 ), which forces...the whole file to be downloaded or makes the read fail. Cached reads of files in DuckDB's native format over HTTP can be corrupted (see issue #1957 ). HTTP authentication header... - https://man.mtool.work/duckdb/2.0/clients/wasm/troubleshoot.html
- Troubleshoot 8437
- Overview This page collects common issues encountered when using the DuckDB JDBC driver, together with their workarounds. If you run into a problem that is not covered here, search the driver's issue tracker on GitHub. Driver Class Not Foun
...Image: NoSuchMethodError When Opening a Connection In a GraalVM Native Image executable, opening the first connection may fail with: Exception in thread "main" java.lang.ExceptionInInitializerError ... Caused by: java.lang.NoSuchMethodError: ⟨class...ce eagerly when its native library initializes, so a single class, method, or field missing from the reachability metadata fails the whole initialization. This indicates that the metadata compiled into the image is missing or older than the driver: u...ffffffff, required by ⟨path⟩/libduckdb_java.⟨suffix⟩ This is what the library's JNI_OnLoad reports when an internal lookup failed, and the cause is the same missing metadata, not a JNI version problem. Native Image: UnsatisfiedLinkError: Can't load l... - https://man.mtool.work/duckdb/2.0/clients/java/troubleshoot.html
- Building Configuration 8437
- Build Types DuckDB can be built in many different settings, most of these correspond directly to CMake but not all of them. release This build has been stripped of all the assertions and debug symbols and code, optimized for performance. de
...Clang-Tidy to check for issues or style violations through static analysis. The CI will also run this check, causing it to fail if this check fails. format-fix | format-changes | format-main This doesn't actually create a build, but uses the followin...in the code. cmake-format to fix format issues in the CMakeLists.txt files. The CI will also run this check, causing it to fail if this check fails. Extension Selection Core DuckDB extensions are the ones maintained by the DuckDB team. These are host... - https://man.mtool.work/duckdb/2.0/dev/building/build_configuration.html
- Subqueries 8108
- 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
...st one of the individual 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... - https://man.mtool.work/duckdb/2.0/sql/expressions/subqueries.html
DuckDB 2.0 Documentation / man.mtool.work