Results of 1 - 10 of about 23 for fail (0.003 sec.)
- Catch C/C++ Tests – DuckDB 14997
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...// 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)...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/1.3/dev/sqllogictest/catch.html
- Transaction Management – DuckDB 11009
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ersistent 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..., which has an identical behavior: ABORT ; If you are not in an active transaction, the ROLLBACK and ABORT statements will fail. Example We illustrate the use of transactions through a simple example. CREATE TABLE person ( name VARCHAR , age BIGINT )...ion transactions DuckDB changes made also abort Statements database visible committed aborted statements commit persistent fail Bruce inserting Documentation Copy Markdown Management supports 関連するページ ALTER VIEW Statement Prepared Statements Ru... - https://man.mtool.work/duckdb/1.3/sql/statements/transactions.html
- Enum Data Type – DuckDB 10121
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...rchar ); Create an anonymous enum value on the fly: SELECT 'happy' :: ENUM ( 'sad' , 'ok' , 'happy' ); This statement will fail since enums cannot hold NULL values: CREATE TYPE breed AS ENUM ( 'maltese' , NULL ); This statement will fail since enum v...ALUES ( 'Pedro' , 'happy' ), ( 'Mark' , NULL ), ( 'Pagliacci' , 'sad' ), ( 'Mr. Mackey' , 'ok' ); The following query will fail since the mood type does not have quackity-quack value. INSERT INTO person VALUES ( 'Hannes' , 'quackity-quack' ); The str... - https://man.mtool.work/duckdb/1.3/sql/data_types/enum.html
- Building Configuration – DuckDB 8998
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...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/1.3/dev/building/build_configuration.html
- Subqueries – DuckDB 8780
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...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 maybe used instead... - https://man.mtool.work/duckdb/1.3/sql/expressions/subqueries.html
- Struct Data Type – DuckDB 8344
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...AS ( SELECT row ( 'a' , 42 ):: STRUCT ( v VARCHAR , i INTEGER ) ); Initializing a struct column with the row function will fail: CREATE TABLE t2 AS SELECT row ( 'a' ); Invalid Input Error: A table cannot be created from an unnamed struct When casting...between structs, the names of at least one field have to match. Therefore, the following query will fail: SELECT a :: STRUCT ( y INTEGER ) AS b FROM ( SELECT { 'x' : 42 } AS a ); Binder Error: STRUCT to STRUCT cast must have at... - https://man.mtool.work/duckdb/1.3/sql/data_types/struct.html
- SQL Introduction – DuckDB 8127
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...e = weather.city ; It is widely considered good style to qualify all column names in a join query, so that the query won't fail if a duplicate column name is later added to one of the tables. Join queries of the kind seen thus far can also be written...t than adding the restriction to HAVING , because we avoid doing the grouping and aggregate calculations for all rows that fail the WHERE check. Updates You can update existing rows using the UPDATE command. Suppose you discover the temperature readi... - https://man.mtool.work/duckdb/1.3/sql/introduction.html
- CHECKPOINT Statement – DuckDB 8127
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...L size (see Configuration ). This statement is for manual checkpoint actions. Behavior The default CHECKPOINT command will fail if there are any running transactions. Including FORCE will abort any transactions and execute the checkpoint operation. A... - https://man.mtool.work/duckdb/1.3/sql/statements/checkpoint.html
- Concurrency – DuckDB 7892
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...pt to edit (update or delete) the same row at the same time. In that situation, the second thread to attempt the edit will fail with a conflict error. Writing to DuckDB from Multiple Processes Writing to DuckDB from multiple processes is not supporte... - https://man.mtool.work/duckdb/1.3/connect/concurrency.html
- CSV Import Tips – DuckDB 7892
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...Header Flag if the Header Is Not Correctly Detected If a file contains only string columns the header auto-detection might fail. Provide the header option to override this behavior. SELECT * FROM read_csv ( 'flights.csv' , header = true ); Provide Na... - https://man.mtool.work/duckdb/1.3/data/csv/tips.html
DuckDB 1.3 Documentation / man.mtool.work