If the var_ref value exceeds 2,147,483,647 then we get back a negative value (rather than the large unsigned int stored in the database) |
If the REF value in the var_ref_table exceeds 2,147,483,647 in value, then the var_ref values that will be stored in user tables will be negative. For example: select ref from var_ref_table WHERE varname ='%toolkit2.2.value' and tablename='os_table' Result: 2,305,291,474 But in the Gateway, the resulting REF value is already translated into a negative value: DEBUG: Schema1_0::executePreparedQueryReturnLong QUERY=[SELECT ref FROM var_ref_table WHERE varname = :varname AND tablename = :tablename] DATA=[ :varname='%toolkit2.2.value' :tablename='os_table' ]
|
NOTE The value for the var_ref column is determined by auto-incrementing positive integer, databases should implement this as the largest value + 1. MySQL
A 4 byte positive integer displayed to 11 characters when selected. SQL Server / Sybase
Positive integer to 10 digits of precision. "identity" is the auto-increment type. Oracle
As before but a trigger is used to auto-increment the value.
|
||||||
The gateway should be able to detect the error conditions since version GA4.2 (AA-534). |
Comments
0 comments
Please sign in to leave a comment.