TCL test on insert misbehaves

[krishvishal]

Put the following code in insert.test and call make test to reproduce the bug.

#!/usr/bin/env tclsh

set testdir [file dirname $argv0]
source $testdir/tester.tcl

do_execsql_test insert-basic-create {
    CREATE TABLE test_table ( id INTEGER PRIMARY KEY, name TEXT, value INTEGER);
} {}

do_execsql_test insert-basic-insert {
    INSERT INTO test_table (id, name, value) VALUES (NULL, 'test item', 43);
} {}

do execsql_test insert-basic-select {
    SELECT id, name, value FROM test_table WHERE name = 'test item';
} {1|test item|43}

This results in the following error:

Running test: insert-basic-create
Running test: insert-basic-insert
Corrupt database: Parse error: no such table: test_table
    while executing
"exec {*}$command"
    (procedure "evaluate_sql" line 3)
    invoked from within
"evaluate_sql $sqlite_exec $sql"
    (procedure "run_test" line 2)
    invoked from within
"run_test $::sqlite_exec $combined_sql $combined_expected_output"
    (procedure "do_execsql_test" line 5)
    invoked from within
"do_execsql_test insert-basic-insert {
    INSERT INTO test_table (id, name, value) VALUES (NULL, 'test item', 43);
} {}"
    (file "./testing/insert.test" line 11)
make: *** [Makefile:64: test-compat-insert] Error 1

Expected behavior: being able to INSERT into database and successfully perform SELECT operation to get the previous INSERT's row.

Check SQLite source for more info: https://github.com/sqlite/sqlite/blob/master/test/e_insert.test#L42