Results of 1 - 10 of about 20 for followed (0.004 sec.)
- Indexes – DuckDB 14172
- 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
...tatements on indexed columns and columns that cannot be updated in place are transformed into a DELETE of the original row followed by an INSERT of the updated row. This rewrite has performance implications, particularly for wide tables, as entire rows a...the number of rows exceeds DuckDB's standard vector size, which is 2048. The UPDATE statement is rewritten into a DELETE , followed by an INSERT . This rewrite happens per chunk of data (2048 rows) moving through DuckDB's processing pipeline. When updati...plicate key "i: 2048" violates primary key constraint. 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 i... - https://man.mtool.work/duckdb/1.3/sql/indexes.html
- Result Verification – DuckDB 12167
- 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
.../ Testing Copy Markdown Result Verification The standard way of verifying results of queries is using the query statement, followed by the letter I times the number of columns that are expected in the result. After the query, four dashes ( ---- ) are exp...ected followed by the result values separated by tabs. For example, query II SELECT 42 , 84 UNION ALL SELECT 10 , 20 ; ---- 42 84 10 20 F...only be interested in whether or not the result contains a snippet of text. In that case, we can use the <REGEX>: modifier followed by a certain regex. If the result value matches the regex the test is passed. This is primarily used for query plan analys... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/result_verification.html
- Literal Types – DuckDB 9312
- 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
...-- 2.0 Non-integer numeric literals can also be denoted using E notation . In E notation, an integer or decimal literal is followed by and exponential part, which is denoted by e or E , followed by a literal integer indicating the exponent. The exponenti... - https://man.mtool.work/duckdb/1.3/sql/data_types/literal_types.html
- Storage Versions and Format – DuckDB 9023
- 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
...file1 TO converted_file ; Storage Header DuckDB files start with a uint64_t which contains a checksum for the main header, followed by four magic bytes ( DUCK ), followed by the storage version number in a uint64_t . hexdump -n 20 -C mydata.db 00000000 0... - https://man.mtool.work/duckdb/1.3/internals/storage.html
- Timestamp Types – DuckDB 8751
- 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
...estamps represent points in time. As such, they combine DATE and TIME information. They can be created using the type name followed by a string formatted according to the ISO 8601 format, YYYY-MM-DD hh:mm:ss[.zzzzzzzzz][+-TT[:tt]] , which is also the for...ts, into unambiguous TIMESTAMP WITH TIME ZONE instants. One possible solution to this is to append UTC offsets to strings, followed by an explicit cast to TIMESTAMP WITH TIME ZONE . Alternatively, a TIMESTAMP WITHOUT TIME ZONE may be created first and th... - https://man.mtool.work/duckdb/1.3/sql/data_types/timestamp.html
- CREATE MACRO Statement – DuckDB 8751
- 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
...SELECT statement (similar to a VIEW ), but it has the benefit of accepting parameters. For a scalar macro, CREATE MACRO is followed by the name of the macro, and optionally parameters within a set of parentheses. The keyword AS is next, followed by the t... - https://man.mtool.work/duckdb/1.3/sql/statements/create_macro.html
- CLI Client – DuckDB 8462
- 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
...argument: duckdb my_database.duckdb Running SQL Statements in the CLI Once the CLI has been opened, enter a SQL statement followed by a semicolon, then hit enter and it will be executed. Results will be displayed in a table in the terminal. If a semicol...commands may be entered into the CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, space separated, after th... - https://man.mtool.work/duckdb/1.3/clients/cli/overview.html
- Appender – DuckDB 8173
- 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
...tion returns DuckDBError. It is not possible to append more values. Call duckdb_appender_error to obtain the error message followed by duckdb_appender_destroy to destroy the invalidated appender. Syntax duckdb_state duckdb_appender_flush ( duckdb_appende...hen all data is invalidated, and this function returns DuckDBError. Call duckdb_appender_error to obtain the error message followed by duckdb_appender_destroy to destroy the invalidated appender. Syntax duckdb_state duckdb_appender_close ( duckdb_appende... - https://man.mtool.work/duckdb/1.3/clients/c/appender.html
- Debugging – DuckDB 7885
- 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
...ldb: break s -n query_break -c line==43 You can also skip certain queries from executing by placing mode skip in the file, followed by an optional mode unskip . Any queries between the two statements will not be executed. Triggering Which Tests to Run Wh... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/debugging.html
- Describe – DuckDB 7885
- 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
...ribe Describing a Table In order to view the schema of a table, use the DESCRIBE statement (or its aliases DESC and SHOW ) followed by the table name. CREATE TABLE tbl ( i INTEGER PRIMARY KEY , j VARCHAR ); DESCRIBE tbl ; SHOW tbl ; -- equivalent to DESC... - https://man.mtool.work/duckdb/1.3/guides/meta/describe.html
DuckDB 1.3 Documentation / man.mtool.work