I receive erroneous data when I try to populate a table using data from
another table: Here is how!
I have TABLE A (that has IDs of INTEGER, Seats as INTEGER, and so forth)
I want to take this master table and in essence transfer the data I only
need into
another table called TABLE B (say it only has IDs of INTEGER)
To do this I do the following
INSERT INTO TABLE B SELECT DISTINCT Content_ID from TABLE A
unfortunately numbers like
854459, 854477,
900499, 900517,
905209, 905227,
will produce float results of 854459.000000001, 854477.000000001, etc.
but the neighboring numbers stay intact and do not produce a float value.
If I do the following :
INSERT INTO TABLE B SELECT * from TABLE A
It does not produce the float values of course I have extra data I don't
need.
As a final test to make sure it was the DISTINCT value I did
INSERT INTO TABLE B SELECT DISTINCT * from TABLE A
and sure enough those values that I mentioned before produced the same
floating values.
I noticed they are always 18 numbers apart and end in a 9 or 7. I would
appreciate some advice on why this would be the case is there a bug
or did I find a silly Easter Egg :-(.
Thank you,
David Cortez
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
