Hello SQLite Community Members,
I am facing an issue with SQLite latest version(3.28.0).
SQLITE Return Exponential value in the latest version(3.28.0) rather than
integer number .
The old version (3.6.2) return the same integer value which is inserted .
Below is the screenshots of my sample application which is shown the difference
beween the sqlite 3.6.2 and sqlite 3.28.0.
Sqlite version: 3.28.0
Sqlite version: 3.6.2
The Return Value is different in the both SQLite versions.
- I have downloaded latest SQLite version (3.28.0) from the below link:
https://www.sqlite.org/download.html
- I have downloaded the SQLite version (3.6.2) from the below link:
https://www.sqlite.org/src/info/88c51b9f1579707a
Below is the step how I build the Latest SQlite(3.28.0) Lib:-
-I downloaded the Source code “sqlite-amalgamation-3280000.zip” from the link:
https://www.sqlite.org/download.html
- After that, I build the Visual studio 2012 project name “SQLitelib” from the
downloaded source.(the downloaded source placed in the Project directory.)
- Build the Libarary.
Below is the step how I build the Old SQlite (3.6.2) Lib:-
-I downloaded the Zip file “SQLite-88c51b9f.zip” from the link:
https://www.sqlite.org/src/info/88c51b9f1579707a
- After that,I make “sqlite3.c” from the downloaded source.
-I build the Visual studio 2012 project name “sqlite362” from the source.(the
downloaded Zip file and source placed in the Project directory.)
- Build the Libarary.
Below is the step to Sqlite Test Application:-
-I create sample application in visual studio 2012 app name is “SQLiteCheck”.
-I placed the Both SQLite Lib (Sqlite 3.28.0 abd SQLite 3.6.2) placed in
(ProjectDir)/ Externals folder.
- when the Application Executes.
- Application creates database named “Mydb.db”.
- it will create the table with one column by below SQL Query:
“CREATE TABLE customer(Rate NUMERIC(4) COLLATE BINARY);”
-The it will insert value '.0000439857' by below Query:
“INSERT into customer (Rate) VALUES ('.0000439857')”
-Then it will get the value by below select Query:
“Select Rate from customer”
-Now, Check for “Return value:” it is different for both SQLite versions.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
