[sqlite] Having in prepared statement with parameters

[elmo]

I have code that looks like that:

--- begin main.cpp ---

#include <unistd.h>
#include <stdio.h>
#include <sqlite3.h>
#include <string.h>

void print(  sqlite3_stmt * pStmt )
{
    const char* col1name = sqlite3_column_name( pStmt, 0 );
    printf("res: ");

    while ( sqlite3_step( pStmt ) == SQLITE_ROW ){
        printf("%lf  ", sqlite3_column_double( pStmt, 0 ));
    }
    printf("\n");

    sqlite3_finalize(pStmt);
}

int main( int argc, char ** argv )
{
    const char filename[] = "test.db3";
    char * err = 0;

    unlink( filename );

    sqlite3 *db;
    sqlite3_open( filename, &db );

    sqlite3_exec(db, "create table test (a decimal(12,4))", 0, 0, &err);
    sqlite3_exec(db, "insert into test values (123.456)", 0, 0, &err);

    sqlite3_stmt * q;
    char buf[2048];

    strcpy( buf, "select * from test");
    sqlite3_prepare(db, buf, sizeof(buf), &q, NULL);
    print( q );

    strcpy( buf, "select * from test where a = ?");
    sqlite3_prepare(db, buf, sizeof(buf), &q, NULL);
    sqlite3_bind_text( q, 1, "123.456", 7, SQLITE_STATIC );
    print( q );

    strcpy( buf, "select sum(a) from test group by a");
    sqlite3_prepare(db, buf, sizeof(buf), &q, NULL);
    print( q );

    strcpy( buf, "select sum(a) from test group by a having sum(a) = 123.456");
    sqlite3_prepare(db, buf, sizeof(buf), &q, NULL);
    print( q );

    strcpy( buf, "select sum(a) from test group by a having sum(a) = ?");
    sqlite3_prepare(db, buf, sizeof(buf), &q, NULL);
    sqlite3_bind_text( q, 1, "123.456", 7, SQLITE_STATIC );
    print( q );

    strcpy( buf, "select sum(a) from test group by a having sum(a) = 0+?");
    sqlite3_prepare(db, buf, sizeof(buf), &q, NULL);
    sqlite3_bind_text( q, 1, "123.456", 7, SQLITE_STATIC );
    print( q );

    return 0;
}

--- end main.cpp ---

The output is:

res: 123.456000
res: 123.456000
res: 123.456000
res: 123.456000
res:
res: 123.456000

Whereas I would expect it to be:

res: 123.456000
res: 123.456000
res: 123.456000
res: 123.456000
res: 123.456000
res: 123.456000

As the last three statements are exactly the same (in meaning).
Can someone explain what's happening?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users