Mercurial > hg > monetdb-java

comparison src/main/java/org/monetdb/jdbc/MonetParameterMetaData.java @ 885:e1f00e0e3598

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Improve isSigned() information on result columns and parameters of Types.DATE, Types.TIMESTAMP and Types.TIMESTAMP_WITH_TIMEZONE. These can have a negative year.
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Wed, 03 Apr 2024 15:02:24 +0200 (13 months ago)
parents e890195256ac
children 674f9ed21308
comparison
equal deleted inserted replaced
884:1956d8ba5ad3 885:e1f00e0e3598
141 case Types.REAL: 141 case Types.REAL:
142 case Types.FLOAT: 142 case Types.FLOAT:
143 case Types.DOUBLE: 143 case Types.DOUBLE:
144 case Types.DECIMAL: 144 case Types.DECIMAL:
145 case Types.NUMERIC: 145 case Types.NUMERIC:
146 case Types.DATE: // year can be negative
147 case Types.TIMESTAMP: // year can be negative
148 case Types.TIMESTAMP_WITH_TIMEZONE:
146 return true; 149 return true;
147 case Types.BIGINT: 150 case Types.BIGINT:
151 {
148 final String monettype = getParameterTypeName(param); 152 final String monettype = getParameterTypeName(param);
149 if (monettype != null && monettype.length() == 3) { 153 // data of type oid or ptr is not signed
150 // data of type oid or ptr is not signed 154 if ("oid".equals(monettype)
151 if ("oid".equals(monettype) 155 || "ptr".equals(monettype))
152 || "ptr".equals(monettype)) 156 return false;
153 return false;
154 }
155 return true; 157 return true;
156 // All other types should return false 158 }
157 // case Types.BOOLEAN:
158 // case Types.DATE: // can year be negative?
159 // case Types.TIME: // can time be negative?
160 // case Types.TIME_WITH_TIMEZONE:
161 // case Types.TIMESTAMP: // can year be negative?
162 // case Types.TIMESTAMP_WITH_TIMEZONE:
163 default: 159 default:
164 return false; 160 return false;
165 } 161 }
166 } 162 }
167 163