Results of 1 - 2 of about 2 for endloop (0.001 sec.)
- Multiple Connections 11228
- For tests whose purpose is to verify that the transactional management or versioning of data works correctly, it is generally necessary to use multiple connections. For example, if we want to verify that the creation of tables is correctly
...0 10 statement ok CREATE TEMP TABLE t2 AS (SELECT 1); statement ok INSERT INTO t2 VALUES (42); statement ok DELETE FROM t2 endloop One caveat with concurrentloop is that results are often unpredictable – as multiple clients can hammer the database at th...REATE OR REPLACE TABLE t2 AS (SELECT -54124033386577348004002656426531535114 FROM t2 LIMIT 70%); ---- write-write conflict endloop... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/multiple_connections.html
- Loops 7485
- 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, suppose we want to fire off 100 queries that check for the presence of the values 0..
...SELECT count(*) FROM integers WHERE i = ${i}; ---- 1 # end the loop (note that multiple statements can be part of a loop) endloop Similarly, foreach can be used to iterate over a set of values. foreach partcode millennium century decade year quarter mo...i, date_part('${partcode}', i) AS p, date_part(['${partcode}'], i) AS st FROM intervals WHERE p <> st['${partcode}']; ---- endloop foreach also has a number of preset combinations that should be used when required. In this manner, when new combinations... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/loops.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work