/*
function may work with 64-bit integers

from, to, step, table name
create table testrange(rowid);
select intrange2table (1,10,1,'testrange');
select * from testrange;
1
2
3
4
5
6
7
8
9
10

select intrange2table (10000000000,100000000000,10000000000,'testrange');
select * from testrange;
1
2
3
4
5
6
7
8
9
10
10000000000
20000000000
30000000000
40000000000
50000000000
60000000000
70000000000
80000000000
90000000000
100000000000
*/
static void intrange2table4Func(
	sqlite3_context *context,
	int argc,
	sqlite3_value **argv
) {
	u_int64_t i;
	const unsigned char *zTable;
	sqlite3 *db;
	sqlite3_stmt *pStmt;        /* A statement */
	int rc;                     /* Result code */
	char *zSql;                 /* An SQL statement */

	if( sqlite3_value_type(argv[ 0 ]) == SQLITE_NULL || sqlite3_value_type(argv[ 1 ]) == SQLITE_NULL  || \
sqlite3_value_type(argv[ 2 ]) == SQLITE_NULL  || sqlite3_value_type(argv[ 3 ]) == SQLITE_NULL ){
		sqlite3_result_null(context);
		return;
	}
	zTable = sqlite3_value_text(argv[ 3 ]);
	db = (sqlite3*) sqlite3_context_db_handle(context);
	zSql = sqlite3_mprintf("INSERT INTO %Q (rowid) VALUES (?)", zTable);
   	rc = sqlite3_prepare(db, zSql, - 1 , &pStmt,  0 );
	sqlite3_free(zSql);
   	if( rc != SQLITE_OK ){
		sqlite3_result_error(context, sqlite3_errmsg(db), - 1 );
		return;
   	}
	for (i=sqlite3_value_int64(argv[ 0 ]);i<=sqlite3_value_int64(argv[ 1 ]);i=i+sqlite3_value_int64(argv[ 2 ])) {
		sqlite3_bind_int64(pStmt,  1 , i);
		sqlite3_step(pStmt);
		if( rc != SQLITE_OK ) {
			sqlite3_result_error(context, sqlite3_errmsg(db), - 1 );
			return;
		}
		rc = sqlite3_reset(pStmt);
	}
	sqlite3_finalize(pStmt);
	return;
}

gcc -fPIC -lm -shared tablefunc.c -o libsqlitetablefunc.so