Re: Release Candidate Version 2.7.3

Hello,

This is a bit much, but I have one primary test for databases
via their datatypes and JDBC meta-data returned. Testing
is for adding, editing, deleting and import/export of SQL
DDL and DML. This does not test all functionality of course.

Issues: None

-- Host: localhost
-- Generated On: 2024.05.23 AD at 10:12:50 MDT
-- SQL version: HSQL Database Engine 2.7.3
-- Database: hsql_datatypes
--

-- ------------------------------------------

--
-- Table structure for table "PUBLIC"."HSQLTYPES"
--

DROP TABLE IF EXISTS "PUBLIC"."HSQLTYPES";
CREATE TABLE "PUBLIC"."HSQLTYPES" (
     "DATA_TYPE_ID" INTEGER IDENTITY NOT NULL,
     "CHAR_TYPE" CHAR(30) DEFAULT NULL,
     "VARCHAR_TYPE" VARCHAR(30) DEFAULT NULL,
     "LONGVARCHAR_TYPE" LONGVARCHAR DEFAULT NULL,
     "CLOB_TYPE" CLOB DEFAULT NULL,
     "BINARY_TYPE" BINARY(1) DEFAULT NULL,
     "VARBINARY_TYPE" VARBINARY(200000) DEFAULT NULL,
     "LONGVARBINARY_TYPE" LONGVARBINARY DEFAULT NULL,
     "BLOB_TYPE" BLOB DEFAULT NULL,
     "TINYINT_TYPE" TINYINT DEFAULT NULL,
     "SMALLINT_TYPE" SMALLINT DEFAULT NULL,
     "INT_TYPE" INTEGER DEFAULT NULL,
     "BIGINT_TYPE" BIGINT DEFAULT NULL,
     "FLOAT_TYPE" DOUBLE DEFAULT NULL,
     "DOUBLE_TYPE" DOUBLE DEFAULT NULL,
     "REAL_TYPE" DOUBLE DEFAULT NULL,
     "DECIMAL_TYPE" DECIMAL(16,2) DEFAULT NULL,
     "NUMERIC_TYPE" NUMERIC(128,32) DEFAULT NULL,
     "UUID_TYPE" UUID DEFAULT NULL,
     "BOOLEAN_TYPE" BOOLEAN DEFAULT NULL,
     "BIT_TYPE" BIT(1) DEFAULT NULL,
     "BIT2_TYPE" BIT(2) DEFAULT NULL,
     "BITVARYING_TYPE" BIT VARYING(5) DEFAULT NULL,
     "DATE_TYPE" DATE DEFAULT NULL,
     "TIME_TYPE" TIME(3) DEFAULT NULL,
     "TIMETMZ_TYPE" TIME(3) WITH TIME ZONE DEFAULT NULL,
     "DATETIME_TYPE" TIMESTAMP DEFAULT NULL,
     "TIMESTAMP_TYPE" TIMESTAMP(3) DEFAULT NULL,
     "TIMESTAMPTMZ_TYPE" TIMESTAMP(3) WITH TIME ZONE DEFAULT NULL,
     "INTERVAL_TYPE" INTERVAL YEAR(3) DEFAULT NULL
);

HyperSQL 2.7.3 (JDBC Meta Data)

Changes: None
Additions: Added UUID Type.

index Name	          Class              Type      Type Name     Scale 
Precision     Size
1  DATA_TYPE_ID       java.lang.Integer   4        INTEGER         0     
  32          11
2  CHAR_TYPE          java.lang.String    1        CHARACTER       0     
  30          30
3  VARCHAR_TYPE       java.lang.String    12       VARCHAR         0     
  30          30
4  LONGVARCHAR_TYPE   java.lang.String    12       VARCHAR         0     
  16777216    16777216
5  CLOB_TYPE          java.sql.Clob       2005     CLOB            0     
  1073741824  1073741824
6  BINARY_TYPE        [B                  -2       BINARY          0     
   0          0
7  VARBINARY_TYPE     [B                  -3       VARBINARY       0     
   200000     200000
8  LONGVARBINARY_TYPE [B                  -3       VARBINARY       0     
   16777216   16777216
9  BLOB_TYPE          java.sql.Blob       2004     BLOB            0     
   1073741824 1073741824
10 TINYINT_TYPE       java.lang.Integer   -6       TINYINT         0     
   8          4
11 SMALLINT_TYPE      java.lang.Integer    5       SMALLINT        0     
   16         6
12 INT_TYPE           java.lang.Integer    4       INTEGER         0     
   32         11
13 BIGINT_TYPE        java.lang.Long      -5       BIGINT          0     
   64         20
14 FLOAT_TYPE         java.lang.Double     8       DOUBLE          0     
   64         23
15 DOUBLE_TYPE        java.lang.Double     8       DOUBLE          0     
   64         23
16 REAL_TYPE          java.lang.Double     8       DOUBLE          0     
   64         23
17 DECIMAL_TYPE       java.math.BigDecimal 3       DECIMAL         2     
   16         18
18 NUMERIC_TYPE       java.math.BigDecimal 2       NUMERIC         32    
   128        130
19 UUID_TYPE          [B                  -2       UUID            0     
   16         36
20 BOOLEAN_TYPE       java.lang.Boolean   16       BOOLEAN         0     
   0          5
21 BIT_TYPE           [B                  -7       BIT             0     
   1          1
22 BIT2_TYPE          [B                  -7       BIT             0     
   2          2
23 BITVARYING_TYPE    [B                  -7       BIT VARYING     0     
   5          5
24 DATE_TYPE          java.sql.Date       91       DATE            0     
   10         10
25 TIME_TYPE          java.sql.Time       92       TIME            3     
   12         12
26 TIMETMZ_TYPE       java.time.OffsetTime 2013     TIME WITH TIME ZONE 
3   18         18
27 DATETIME_TYPE      java.sql.Timestamp  93       TIMESTAMP       6     
   26         26
28 TIMESTAMP_TYPE     java.sql.Timestamp  93       TIMESTAMP       3     
   23         23
29 TIMESTAMPTMZ_TYPE  java.time.OffsetDateTime 2014 TIMESTAMP WITH TIME 
ZONE 3    29   29
30 INTERVAL_TYPE      java.lang.String    12       INTERVAL YEAR   0     
    4         4

Dana M. Proctor
Ajqvue Project Manager.