Bind or column index out of range

SQLITE_RANGE (25) is returned when the second argument to sqlite3_bind_*() or sqlite3_column_*() is out of range. Column and parameter indices are 1-based in the C API.

1. 1Passing a parameter index of 0 or greater than the number of bind parameters.
2. 2Accessing a column index beyond the number of columns in the result set.
3. 3Off-by-one error in C extension code — SQLite bind indices start at 1, not 0.

sqlite3_bind_*() and sqlite3_column_*() calls with invalid indices.

import sqlite3
conn = sqlite3.connect(':memory:')
conn.execute('CREATE TABLE t(a,b)')
conn.execute('INSERT INTO t VALUES(?,?)', (1, 2))
cur = conn.execute('SELECT a FROM t')
row = cur.fetchone()
# Python driver abstracts index; in C API:
# sqlite3_column_int(stmt, 5) on a 1-column result → SQLITE_RANGE

In C: SQLITE_RANGE; in Python driver: IndexError or similar.

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev