File: bigint

package info (click to toggle)
duckdb 1.5.1-3
  • links: PTS, VCS
  • area: main
  • in suites:
  • size: 299,196 kB
  • sloc: cpp: 865,414; ansic: 57,292; python: 18,871; sql: 12,663; lisp: 11,751; yacc: 7,412; lex: 1,682; sh: 747; makefile: 564
file content (11 lines) | stat: -rwxr-xr-x 449 bytes parent folder | download | duplicates (4)
1
2
3
4
5
6
7
8
9
10
11
#!/bin/sh
set -e

# Verify that BIGINT (int64_t) arithmetic is correct.
result=$(echo "SELECT 9223372036854775807::BIGINT AS max_bigint;" | duckdb)
echo "$result" | grep -q "9223372036854775807"

# Collect 250 million integers into an array (~2 GB allocation) and verify
# the count. Tests that large contiguous allocations succeed.
result=$(echo "SELECT len(array_agg(i)) FROM range(250000000) t(i);" | duckdb)
echo "$result" | grep -q "250000000"