A couple of similar questions have been posted previously about SQL Anywhere 10 and 11, but I haven't seen this on SQL Anywhere 12. It appears to be fixed for SQL Anywhere 16.

Create a file C:\tmp\tnumtest.txt with three records (no extra blanks):

1.23
1.235
1.2345

Execute the following ISQL, connected to a database with DBA permissions (this drops and creates a table called "NumTest"):

DROP TABLE IF EXISTS NumTest;
CREATE TABLE NumTest ( myval NUMERIC(4,2) );
DESCRIBE NumTest;
-- shows: Column / Type / Nullable / Primary Key
--   myval / numeric(4,2) / 1 / 0
INSERT INTO NumTest VALUES(1.23);
INSERT INTO NumTest VALUES(1.235);
INSERT INTO NumTest VALUES(1.2345);
SELECT myval,myval+0.001,myval+0.0001 FROM NumTest;
-- shows (correctly): myval / NumTest.myval+.001 / NumTest.myval+.0001
-- 1.23 / 1.231 / 1.2301
-- 1.24 / 1.241 / 1.2401
-- 1.23 / 1.231 / 1.2301
DELETE FROM NumTest;
LOAD TABLE NumTest FROM 'c:/tmp/tnumtest.txt';
SELECT myval,myval+0.001,myval+0.0001 FROM NumTest;
-- shows (incorrectly): myval / NumTest.myval+.001 / NumTest.myval+.0001
-- 1.23 / 1.231 / 1.2301
-- 1.24 / 1.236 / 1.2351
-- 1.23 / 1.236 / 1.2346

In the second and third rows, the second and third column values are all incorrect given that myval is NUMERIC(4,2) and shouldn't ever store anything like 1.235 or 1.2345. I thought it might be a cache issue except the database can be stopped and restarted between the LOAD and SELECT and the same results are produced.