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):
Execute the following ISQL, connected to a database with DBA permissions (this drops and creates a table called "NumTest"):
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.
asked 15 Jan '15, 11:20
This looks like a bug that has been fixed. QTS# 708252 fixed an issue that is likely the root cause of this behaviour. All (past) versions could have been affected. The fix was checked into 12.0.1 build# 4004 and 16.0 build#1719
answered 16 Jan '15, 11:21
Nick Elson S...
What version / build are you using? This is what I see for the last result set using 22.214.171.12483 (SP 82).
It's identical to the previous result set.
Please also check your precision, scale.
You should see something like 30 and 6.
Rats. We're using 126.96.36.19917. ISQL pops up daily with "Updates Are Available" but whenever I've followed the various "click here" links I've wound up at pages with login prompts that don't work for me and then given up.
Lesson for me and everyone else - probably shouldn't ignore "Updates Are Available" messages.
I also just checked and the "Release notes" link from www.ianywhere.com/update_checker/... (linked from the SQL Anywhere "Do you want to view them now? Yes" button) requires a username/password that stymies me. Can Release Notes at least be made public? Anyway, I'm chasing down how to get myself validated. Early retirement also has some appeal. Thanks all for the help with this.
answered 16 Jan '15, 12:03