Mercurial > hg > monetdb-java

comparison src/main/java/org/monetdb/util/SQLExporter.java @ 424:709300b32284

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added entries for new Java 8 java.sql.Types: Types.TIME_WITH_TIMEZONE and Types.TIMESTAMP_WITH_TIMEZONE
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Wed, 03 Feb 2021 16:23:39 +0100 (2021-02-03)
parents a0f99a81ce8e
children 95d15f1d750d
comparison
equal deleted inserted replaced
423:de2ef68b672f 424:709300b32284
133 case Types.FLOAT: 133 case Types.FLOAT:
134 if (size > 0) 134 if (size > 0)
135 sb.append('(').append(size).append(')'); 135 sb.append('(').append(size).append(')');
136 break; 136 break;
137 case Types.TIME: 137 case Types.TIME:
138 case Types.TIME_WITH_TIMEZONE:
138 case Types.TIMESTAMP: 139 case Types.TIMESTAMP:
140 case Types.TIMESTAMP_WITH_TIMEZONE:
139 if (size > 1) 141 if (size > 1)
140 sb.append('(').append(size -1).append(')'); 142 sb.append('(').append(size -1).append(')');
141 if (digits == 1) // flag is set to include suffix: WITH TIME ZONE 143 if (digits == 1) // flag is set to include suffix: WITH TIME ZONE
142 sb.append(" WITH TIME ZONE"); 144 sb.append(" WITH TIME ZONE");
143 break; 145 break;
442 case Types.LONGVARCHAR: 444 case Types.LONGVARCHAR:
443 case Types.CLOB: 445 case Types.CLOB:
444 case Types.BLOB: 446 case Types.BLOB:
445 case Types.DATE: 447 case Types.DATE:
446 case Types.TIME: 448 case Types.TIME:
449 case Types.TIME_WITH_TIMEZONE:
447 case Types.TIMESTAMP: 450 case Types.TIMESTAMP:
451 case Types.TIMESTAMP_WITH_TIMEZONE:
448 types[i] = QUOTE; 452 types[i] = QUOTE;
449 break; 453 break;
450 case Types.NUMERIC: 454 case Types.NUMERIC:
451 case Types.DECIMAL: 455 case Types.DECIMAL:
452 case Types.BIT: // we don't use type BIT, it's here for completeness 456 case Types.BIT: // we don't use type BIT, it's here for completeness