Queries returning wrong result after upgradation to SQL anywhere 11

[chima]

We have upgraded DB from Sybase 6.0 to SQL Anywhere 11.
After upgradation we are facing a few issues.
One of them is as follows :

Please have a look at the attached DB.

While running the below query, the count returned is 0.
If we remove the //
in the below query,
the count is properly returned as 4.


Could you please let us the resolution for the same. We are badly stuck up.


Query:

SELECT count(*)

from dba.tblcompmst ,

dba.employeemastercompany //WITH (NO INDEX)

WHERE

dba.tblcompmst.ncocodegrp = dba.employeemastercompany.ncocodegrp and

dba.tblcompmst.ncocode = dba.employeemastercompany.ncocode and

dba.employeemastercompany.ncocodegrp = 2 AND

dba.employeemastercompany.employeeno =110 AND

dba.tblcompmst.ncostatus = 1

[skhanal]

I don't know much about Sybase, but is //WITH (NO INDEX) a valid syntax in new version?

Also you may try rebuilding index on employeemastercompany.

[chima]

With (no index) is valid in SQL Anywhere Version 11. I rebuilt the indexes too .. But still facing the issue.

[rmiao]

Is // valid in sqlanywhere 11?

[chima]

// is for comment.

If we remove // then with (no index) clause is included in the query and the results are properly returned.

[rmiao]

Tried update stats?

[jlahc]

Have you tried validating the database to make sure there wasn't a problem with the rebuild?
I am new to these forums, and I do not see any database attachment to your message, or I would try your query myself.

Jason Hinsperger
SQL Anywhere Product Manager
Sybase iAnywhere