Dennis Volodomanov wrote:
Funny enough, but it doesn't work on real data using v3.6.1...
Here's the table:
sqlite> .dump test_table
BEGIN TRANSACTION;
CREATE TABLE test_table (ID INTEGER PRIMARY KEY, ExternalID2 INTEGER,
ExternalID
INTEGER, Value );
INSERT INTO "test_table" VALUES(1007,1,37,'-5');
INSERT INTO "test_table" VALUES(1044,4,37,'-10');
INSERT INTO "test_table" VALUES(1081,2,37,'-20');
INSERT INTO "test_table" VALUES(1118,3,37,'-1');
INSERT INTO "test_table" VALUES(1155,5,37,'-7');
COMMIT;
sqlite>
And here's the output:
sqlite> select * from test_table;
1007|1|37|-5
1044|4|37|-10
1081|2|37|-20
1118|3|37|-1
1155|5|37|-7
sqlite> select min(Value) from test_table;
-1
sqlite> select max(Value) from test_table;
-7
I'm confused :)
Thanks,
Dennis
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Works just fine with 3.6.1 if you declare the Value column to be
INTEGER. As it is, I have no idea what collation is used, but the Value
column will be declared to default to TEXT values, as shown by
select typeof(value) from test_table;
--
Multumesc,
Mihai Limbasan
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
