Results of 1 - 10 of about 370 for tests (0.004 sec.)
- Debugging – DuckDB 14942
- 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
...R Troubleshooting Unofficial and Unsupported Platforms Benchmark Suite Testing Overview sqllogictest Introduction Writing Tests Debugging Result Verification Persistent Testing Loops Multiple Connections Catch Internals Overview Storage Versions and...Execution Format Pivot Sitemap Live Demo Documentation / Development / Testing Copy Markdown Debugging The purpose of the tests is to figure out when things break. Inevitably changes made to the system will cause one of the tests to fail, and when th..., it is recommended to only run the test that breaks. This can be done by passing the filename of the breaking test to the test suite as a command line parameter (e.g., build/debug/test/unittest test/sql/projection/test_simple_projection.test ). For m... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/debugging.html
- Writing Tests – DuckDB 12713
- 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
...R Troubleshooting Unofficial and Unsupported Platforms Benchmark Suite Testing Overview sqllogictest Introduction Writing Tests Debugging Result Verification Persistent Testing Loops Multiple Connections Catch Internals Overview Storage Versions and...Format Execution Format Pivot Sitemap Live Demo Documentation / Development / Testing Copy Markdown Writing Tests Development and Testing It is crucial that any new features that get added have correct tests that not only test the “happ...y path”, but also test edge cases and incorrect usage of the feature. In this section, we describe how DuckDB tests are structured and how to make new tests for DuckDB. The tests can be run by running the unittest program located in the t... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/writing_tests.html
- sqllogictest Introduction – DuckDB 11427
- 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
...R Troubleshooting Unofficial and Unsupported Platforms Benchmark Suite Testing Overview sqllogictest Introduction Writing Tests Debugging Result Verification Persistent Testing Loops Multiple Connections Catch Internals Overview Storage Versions and...pment / Testing Copy Markdown sqllogictest Introduction 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 loc...he above test, we would run the command unittest test/sql/projection/test_simple_projection.test . If we wanted to run all tests in a specific directory, we would run the command unittest "[projection]" . Any tests that are placed in the test director... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/intro.html
- Catch C/C++ Tests – DuckDB 8766
- 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
...R Troubleshooting Unofficial and Unsupported Platforms Benchmark Suite Testing Overview sqllogictest Introduction Writing Tests Debugging Result Verification Persistent Testing Loops Multiple Connections Catch Internals Overview Storage Versions and...Format Execution Format Pivot Sitemap Live Demo Documentation / Development / Testing Copy Markdown Catch C/C++ Tests While we prefer the sqllogic tests for testing most functionality, for certain tests only SQL is not sufficient. This typi...test the C++ API. When using pure SQL is really not an option it might be necessary to make a C++ test using Catch. Catch tests reside in the test directory as well. Here is an example of a catch test that tests the storage of the system: #include "c... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/catch.html
- Persistent Testing – DuckDB 8079
- 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
...R Troubleshooting Unofficial and Unsupported Platforms Benchmark Suite Testing Overview sqllogictest Introduction Writing Tests Debugging Result Verification Persistent Testing Loops Multiple Connections Catch Internals Overview Storage Versions and...tion Format Pivot Sitemap Live Demo Documentation / Development / Testing Copy Markdown Persistent Testing By default, all tests are run in in-memory mode (unless --force-storage is enabled). In certain cases, we want to force the usage of a persisten...), ( 15 ), ( NULL ) # ... restart query I SELECT * FROM test ORDER BY a ---- NULL 11 12 13 14 15 Note that by default the tests run with SET wal_autocheckpoint = '0KB' – meaning a checkpoint is triggered after every statement. WAL tests typically run... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/persistent_testing.html
- Overview – DuckDB 7647
- 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
...R Troubleshooting Unofficial and Unsupported Platforms Benchmark Suite Testing Overview sqllogictest Introduction Writing Tests Debugging Result Verification Persistent Testing Loops Multiple Connections Catch Internals Overview Storage Versions and...keeps working properly. For that reason, we put a large emphasis on thorough and frequent testing: We run a batch of small tests on every commit using GitHub Actions , and run a more exhaustive batch of tests on pull requests and commits in the main b...DuckDB. We use SQLsmith for generating random queries. Pages in This Section 関連キーワード DuckDB Testing properly batch tests Documentation Development Copy Markdown Overview Tested make sure works keeps working reason large emphasis thorough frequ... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/overview.html
- Loops – DuckDB 5339
- 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
...R Troubleshooting Unofficial and Unsupported Platforms Benchmark Suite Testing Overview sqllogictest Introduction Writing Tests Debugging Result Verification Persistent Testing Loops Multiple Connections Catch Internals Overview Storage Versions and...tion Format Pivot Sitemap Live Demo Documentation / Development / Testing Copy Markdown Loops Loops can be used in sqllogictests when it is required to execute the same query many times but with slight modifications in constant values. For example, su...preset combinations that should be used when required. In this manner, when new combinations are added to the preset, old tests will automatically pick up these new combinations. Preset Expansion ⟨compression⟩ none uncompressed rle bitpacking diction... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/loops.html
- Result Verification – DuckDB 5162
- 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
...R Troubleshooting Unofficial and Unsupported Platforms Benchmark Suite Testing Overview sqllogictest Introduction Writing Tests Debugging Result Verification Persistent Testing Loops Multiple Connections Catch Internals Overview Storage Versions and...UNION ALL SELECT 10 , 20 ; ---- 42 84 10 20 Hashes and Outputting Values Besides direct result verification, the sqllogic test suite also has the option of using MD5 hashes for value comparisons. A test using hashes for result verification looks like...gs GROUP BY g ---- 200 values hashing to b8126ea73f21372cdb3f2dc483106a12 This approach is useful for reducing the size of tests when results have many output rows. However, it should be used sparingly, as hash values make the tests more difficult to... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/result_verification.html
- Data Sources – DuckDB 5074
- 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
...R Troubleshooting Unofficial and Unsupported Platforms Benchmark Suite Testing Overview sqllogictest Introduction Writing Tests Debugging Result Verification Persistent Testing Loops Multiple Connections Catch Internals Overview Storage Versions and...ページ Working with Huge Databases Delta Extension Cloudflare R2 Import Storage Versions and Format Excel Export Catch C/C++ Tests See this page as Markdown Edit this page on GitHub Report content issue © 2026 DuckDB Foundation, Amsterdam NL DuckDB Home... - https://man.mtool.work/duckdb/1.3/data/data_sources.html
- Subqueries – DuckDB 5074
- 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
...R Troubleshooting Unofficial and Unsupported Platforms Benchmark Suite Testing Overview sqllogictest Introduction Writing Tests Debugging Result Verification Persistent Testing Loops Multiple Connections Catch Internals Overview Storage Versions and...r equal to 5. The quantifier SOME maybe used instead of ANY : ANY and SOME are interchangeable. EXISTS The EXISTS operator tests for the existence of any row inside the subquery. It returns either true when the subquery returns one or more records, an...by other SQL systems but cannot fulfil any purpose in EXISTS and NOT EXISTS subqueries. NOT EXISTS The NOT EXISTS operator tests for the absence of any row inside the subquery. It returns either true when the subquery returns an empty result, and fals... - https://man.mtool.work/duckdb/1.3/sql/expressions/subqueries.html
DuckDB 1.3 Documentation / man.mtool.work