DuckDB 1.4 LTS

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

-- duckdb_functions() has examples we can run
create or replace table example as
from duckdb_functions(), unnest(examples) as t(eg)
select distinct function_name as name, eg;

from example select count(*) as examples;


examples


498


# Run each example
import duckdb, time

con = duckdb.connect('/data/fiddle.duckdb')
egs = con.sql('from example select name, eg').fetchall()
con.execute('create or replace table verdict (name varchar, eg varchar, ok boolean, err varchar)')

rows, t0 = [], time.perf_counter()
for name, e in egs:
    try:
        con.sql('select (' + e.strip().rstrip(';') + ')::varchar').fetchone()
        rows.append((name, e, True, None))
    except Exception as ex:
        rows.append((name, e, False, str(ex).splitlines()[0]))
con.executemany('insert into verdict values (?,?,?,?)', rows)
con.close()

ok = sum(r[2] for r in rows)
print(f'{len(rows)} examples in {time.perf_counter()-t0:.2f}s: '
      f'{ok} ran as-is, {len(rows)-ok} did not')
498 examples in 1.40s: 421 ran as-is, 77 did not

-- Bucketing by error kind
from verdict
select coalesce(regexp_extract(err, '^[A-Za-z ]+Error'), 'ran clean') as outcome
     , count(*) as n
     , any_value(eg) as for_example
group by all
order by n desc;


outcome
n
for_example


ran clean
421
log2(8)

Binder Error
68
is_histogram_other_bin(v)

Catalog Error
7
nextval('my_sequence_name')

Parser Error
1
variant_typeof({'a': 42, 'b': [1,2,3]})::VARIANT)

Invalid Input Error
1
error('access_mode')


-- One does not parse at all. Count the brackets.
from verdict
select name
     , eg
     , len(regexp_split_to_array(eg, '\(')) - 1 as opens
     , len(regexp_split_to_array(eg, '\)')) - 1 as closes
where err like 'Parser Error%';


name
eg
opens
closes


variant_typeof
variant_typeof({'a': 42, 'b': [1,2,3]})::VARIANT)
1
2

outcome	n	for_example
ran clean	421	log2(8)
Binder Error	68	is_histogram_other_bin(v)
Catalog Error	7	nextval('my_sequence_name')
Parser Error	1	variant_typeof({'a': 42, 'b': [1,2,3]})::VARIANT)
Invalid Input Error	1	error('access_mode')