Results of 1 - 8 of about 8 for Verification (0.002 sec.)
- sqllogictest Introduction 13393
- 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
...of a test file is shown below: # name: test/sql/projection/test_simple_projection.test # group [projection] # enable query verification statement ok PRAGMA enable_verification # create table statement ok CREATE TABLE a (i INTEGER, j INTEGER); # insertion: 1...). The values of the row are expected to be 42 and 84 (separated by a tab character). For more information on query result verification, see the result verification section . The top of every file should contain a comment describing the name and group of the...ests are explicitly run using unittest * . Tests with the extension .test will be included in the fast set of tests. Query Verification Many simple tests start by enabling query verification. This can be done through the following PRAGMA statement: statement... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/intro.html
- Result Verification 9832
- 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 expected followed by the result v
...current statement or query. For that reason, empty strings and NULL values have special syntax that must be used in result verification. NULL values should use the string NULL , and empty strings should use the string (empty) , e.g.: query II SELECT NULL, ''...---- NULL (empty) Error Verification In order to signify that an error is expected, the statement error indicator can be used. The statement error also takes a...e-wise query II SELECT 42, 84 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 ver... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/result_verification.html
- Pragmas 9308
- 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
...eprecation warning in the CLI. To return NULL for a specific expression, wrap it in TRY instead, e.g., TRY(1 // 0) . Query Verification (for Development) The following PRAGMA s are mostly used for development and internal testing. Deprecated The enable_verif...ication and disable_verification pragmas are deprecated in DuckDB 2.0 and no longer have any effect. Enable query verification: PRAGMA enable_verification;...Disable query verification: PRAGMA disable_verification; Enable force parallel query processing: PRAGMA verify_parallelism; Disable force parallel qu... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
- HTTP(S) Support 8476
- With the httpfs extension, it is possible to directly query files over the HTTP(S) protocol. This works for all files supported by DuckDB or its various extensions, and provides read-only access. SELECT * FROM 'https://domain.tld/file.exten
...ation options prior to loading the extension: LOAD httpfs; SET ca_cert_file = '⟨certificate_file⟩'; SET enable_server_cert_verification = true; If you would like to disable SSL verification for all HTTP requests using an HTTP secret you can do so with the fo... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/https.html
- Configuration 8097
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...n-memory benchmarks. BOOLEAN true enable_optimizer Whether the query optimizer is enabled. BOOLEAN true enable_server_cert_verification Enable server side certificate verification. BOOLEAN false enable_view_dependencies Enable created VIEWs to create depende...are deprecated and will be removed in a future release. Name Description Type Default value Scope enable_curl_server_cert_verification Enable server side certificate verification for CURL backend. BOOLEAN true GLOBAL enable_object_cache Deprecated legacy se... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- Iceberg Options 7862
- This page lists the options of the iceberg extension: the parameters accepted by the Iceberg functions , the options of the ATTACH and CREATE SECRET statements used to connect to a catalog , and the global settings. ATTACH Options To make a
...en creating a new table without an explicit format-version property. Valid values are 2 and 3 . iceberg_unsafe_skip_puffin_verification BOOLEAN false When reading V3 Deletion Vectors, skip the Puffin file verification (for compatibility with files written by... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_options.html
- Load Extensions 7645
- Overview DuckDB-Wasm's (dynamic) extension loading is modeled after regular DuckDB's extension loading, with a few relevant differences due to the difference in platform. A growing subset of core, community, and external extensions is suppo
...default checked on LOAD to verify the signature and confirm the extension has not been tampered with. Extension signature verification can be disabled via a configuration option. Signing is a property of the binary itself, so copying a DuckDB extension (say... - https://man.mtool.work/duckdb/2.0/clients/wasm/extensions.html
- Unit Tester Configuration 7645
- 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
..._name and env_value --test-memory-leaks , --no-test-memory-leaks Run memory leak tests --verify-vector <string> Run vector verification for a specific vector type (options: dictionary_expression, dictionary_operator, constant_operator, sequence_operator, nes... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/test_configuration.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work