Re: [sqlite] Having in prepared statement with parameters

2012-05-09 Thread Black, Michael (IS)
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of elmo [elm...@gmail.com] Sent: Tuesday, May 08, 2012 8:34 AM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] Having in prepared statement with parameters I have code that looks like that: --- begin ma

Re: [sqlite] Having in prepared statement with parameters

2012-05-09 Thread Simon Davies
On 9 May 2012 14:17, Pavel Ivanov wrote: >> As the last three statements are exactly the same (in meaning). >> Can someone explain what's happening? > > I think you've got trapped by double value storage imprecision. > Comparing double values for exact equality is pretty

Re: [sqlite] Having in prepared statement with parameters

2012-05-09 Thread Pavel Ivanov
> As the last three statements are exactly the same (in meaning). > Can someone explain what's happening? I think you've got trapped by double value storage imprecision. Comparing double values for exact equality is pretty dangerous - two numbers can differ in one last bit, be not equal and be

[sqlite] Having in prepared statement with parameters

2012-05-09 Thread elmo
I have code that looks like that: --- begin main.cpp --- #include #include #include #include void print( sqlite3_stmt * pStmt ) { const char* col1name = sqlite3_column_name( pStmt, 0 ); printf("res: "); while ( sqlite3_step( pStmt ) == SQLITE_ROW ){ printf("%lf ",