We are using int columns in an equation to determine values that could be larger then an int but the casting is setting the variable to an integer. We need to either declare one of the variables in the equation as a big integer or cast the equation into a big integer value so that its receiving variable gets the correct data type allocation.
This query came from the Sybase team and currently is used in extraction of index information and storage information. Code changes required in two classes.
com.sybase.jdbc4.jdbc.SybSQLException: Arithmetic overflow occurred.
at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4003)
at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3093)
at com.sybase.jdbc4.tds.TdsResultSet.nextResult(TdsResultSet.java:796)
at com.sybase.jdbc4.tds.TdsResultSet.next(TdsResultSet.java:504)
at com.sybase.jdbc4.jdbc.SybResultSet.next(SybResultSet.java:193)
at \\...\\ .\\हिñçêČάй語简�?한\\._ꋸꁴᢐꈺ.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\._ꋸꁴᢐꈺ.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\._ꋸꁴᢐꈺ.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\._ꋸꁴᢐꈺ.a(Unknown Source)
at com.aquafold.datastudio.queryanalyzer.qꈏꎹꀋꊪ.dMN(Unknown Source)
at com.aquafold.datastudio.queryanalyzer.qꈏꎹꀋꊪ.Qn(Unknown Source)
at com.aquafold.datastudio.queryanalyzer.qꈏꎹꀋꊪ.Qm(Unknown Source)
at com.aquafold.datastudio.queryanalyzer.sꉯꂡꆍᝋ 8$9.process(Unknown Source) at com.common.ui.util.BackgroundThread.run(Unknown Source)
converted variables that store index variable sizes to bigint. In order to test this we need to create objects with large data page & reserved page size.