変更履歴

General Changes


Date	Build Number	Change Type	Description
11/29/2023	8733	General	Changed The ROUND function doesn't accept the negative precision values anymore. Changed The returning types of the FDMonth, FDQuarter, FDWeek, LDMonth, LDQuarter, LDWeek functions are changed from Timestamp to Date. The return type of the ABS function will be consistent with the parameter value type.
10/27/2023	8700	jdbc	Changed Added support for Connection.abort() method.
09/18/2023	8661	Square	Removed Removed the Settlements view as Square has deprecated the Settlements API. Added Added Payouts and PayoutEntries views.
07/26/2023	8607	Square	Removed TaxesCatalogObjectId,TaxesName,TaxesPercentage,TaxesMoneyAmount,TaxesMoneyCurrency,DiscountsCatalogObjectId,DiscountsName,DiscountsPercentage,DiscountsMoneyAmount and DiscountsMoneyCurrency columns from orders views as we have made taxes and discount as aggregate column and created a different views. Added Added OrderDiscounts and OrderTaxes views. CustomerId,Discounts,LineItems,NetDueAmount,NetDueCurrency,NetDiscountAmount,NetDiscountCurrency,NetServiceChargeAmount,NetServiceChargeCurrency,NetTaxAmount,NetTaxCurrency,NetTipAmount,NetTipCurrency,NetTotalAmount,NetTotalCurrency,PricingAutoApplyDiscounts,SourceName,State,Taxes,Tenders,TotalDiscountAmount,TotalDiscountCurrency,TotalAmount,TotalCurrency,ServiceChargeAmount,ServiceChargeCurrency,TaxAmount,TaxCurrency,TipAmount,TipCurrency and Version columns in orders views.
07/03/2023	8584	Square	Changed Changed the datatype of Birthday column in Customers table from datetime to string.
06/20/2023	8571	General	Added Added the new sys_lastresultinfo system table.
04/25/2023	8515	General	Removed Removed support for the SELECT INTO CSV statement. The core code doesn't support it anymore.
03/21/2023	8480	Square	Added Added Variations column in the CatalogItems table. Added Type column in the CatalogItemVariations table.
12/14/2022	8383	General	Changed Added the Default column to the sys_procedureparameters table.
11/18/2022	8357	Square	Added Added the TeamMemberId column in the Payments table.
09/30/2022	8308	General	Changed Added the IsPath column to the sys_procedureparameters table.
09/21/2022	8299	Square	Added Added Content as input attribute to support input streams on the CreateCatalogImage stored procedure.
06/11/2022	8197	jdbc	Changed The method GetJDBCMinorVersion() and GetJDBCMajorVersion() return 4.2 as the supported JDBC major / minor version.
06/03/2022	8189	Square	Added Added CreatedAt column to Merchants table. Added CreatedAt and UpdatedAt columns to Orders table.
05/05/2022	8160	Square	Replacements Cards table has been added to replace CustomerCards table.
04/28/2022	8153	jdbc	Changed Removed support for JRE 1.6. JRE 1.8 and above is now required.
02/25/2022	8091	jdbc	Changed The method DatabaseMetaData.getTypeInfo() now returns all of the data types that the driver supports. Previously, it was returning only a portion of the data types. The types include: tinyint, smallint, int, bigint, float, double, numeric, decimal, bit, date, datetime, time, varchar, binary, uuid.
02/24/2022	8090	jdbc	Changed Corrected the return value of method DatabaseMetaData.supportsOuterJoins(), which used to return an incorrect value.
10/27/2021	7970	jdbc	Changed Added support for JDK 17
09/12/2021	7925	jdbc	Removed Removed the IS_READONLY, IS_KEY, NUMERIC_PRECISION, and DECIMAL_DIGITS columns from DatabaseMetadata.GetColumns(), as they are not part of the JDBC Specification. This information is still available via other metadata calls.
09/08/2021	7921	Square	Added Added the ImageId column to the CatalogItems table.
09/03/2021	7916	Square	Added Added the stored procedures CreateCatalogImage and AddItemImage to the V2 schema. Deprecated Removed the AddItemImage Stored Procedure from the V1 schema.
09/02/2021	7915	General	Added Added support for the STRING_SPLIT table-valued function in the CROSS APPLY clause.
08/07/2021	7889	General	Changed Added the KeySeq column to the sys_foreignkeys table.
08/06/2021	7888	General	Changed Added the new sys_primarykeys system table.
07/23/2021	7874	General	Changed Updated the Literal Function Names for relative date/datetime functions. Previously, relative date/datetime functions resolved to a different value when used in the projection as opposed to the predicate. For example: SELECT LAST_MONTH() AS lm, Col FROM Table WHERE Col > LAST_MONTH(). Formerly, the two LAST_MONTH() methods would resolve to different datetimes. Now, they will match. As a replacement for the previous behavior, the relative date/datetime functions in the criteria may have an 'L' appended to them. For example: WHERE col > L_LAST_MONTH(). This will continue to resolve to the same values that were previously calculated in the criteria. Note that the "L_" prefix will only work in the predicate - it not available for the projection.
07/15/2021	7866	Square	Added Added the Version column in the CatalogCategories, CatalogDiscounts, CatalogImages, CatalogItems, CatalogItemVariations, CatalogModifierLists, CatalogModifiers and CatalogTaxes table in the V2 Schema. Deprecated Cells and Pages table from the V1 Schema as the functionality has been discontinued by the Square API. There is no replacement for these endpoints. Refunds, Transactions, TransactionTenders, Payments and PaymentItemizations API support from V1 schema as they are deprecated. Customers view from the V1 Schema as it is not supported in V1. Locations view and Fees table from the V1 Schema as both the endpoints has been retired from the V1 Schema. Replacements v1 Locations are replaced with v2 Locations. v1 Fees are replaced with v2 CatalogTaxes. v1 Refunds are replaced with v2 Refunds. v1 Transactions and TransactionTenders are replaced with v2 Orders and Payments. v1 Payments and PaymentItemizations are replaced with v2 Payments.
06/01/2021	7822	Square	Deprecated Removed the Groups column in the Customers table as it is deprecated in the Customers V2 Schema API.
04/25/2021	7785	General	Added Added support for handling client side formulas during insert / update. For example: UPDATE Table SET Col1 = CONCAT(Col1, " - ", Col2) WHERE Col2 LIKE 'A%'
04/23/2021	7783	General	Changed Updated how display sizes are determined for varchar primary key and foreign key columns so they will match the reported length of the column.
04/16/2021	7776	General	Added Non-conditional updates between two columns is now available to all drivers. For example: UPDATE Table SET Col1=Col2
04/16/2021	7776	General	Changed Reduced the length to 255 for varchar primary key and foreign key columns. Changed Updated index naming convention to avoid duplicates.
04/16/2021	7776	General	Changed Updated implicit and metadata caching to improve performance and support for multiple connections. Old metadata caches are not compatible - you need to generate new metadata caches if you are currently using CacheMetadata.
03/30/2021	7759	Square	Added Added CRUD support for the V2 tables CatalogCategories, CatalogDiscounts, CatalogImages, CatalogItems, CatalogItemVariations, CatalogModifierLists, CatalogModifiers and CatalogTaxes. Deprecated Employees, BankAccounts, Items, ItemVariations, Discounts, Categories, Inventory, Modifieroptions and ModifierLists API support from V1 schema as they are deprecated. Replacements v1 Employees replaced with v2 Teams v1 BankAccounts replaced with v2 BankAccounts v1 Inventory replaced with v2 InventoryChanges v1 Items replaced with v2 CatalogItems v1 ItemVariations replaced with v2 CatalogItemVariations v1 Discounts replaced with v2 CatalogDiscounts v1 Categories replaced with v2 CatalogCategories v1 ModifierOptions replaced with v2 CatalogModifiers v1 ModifierLists replaced with v2 CatalogModifierLists

JDBC Driver for Square

変更履歴

General Changes