hsqldb 2.74 problem: loosing tables and data of a database
Dan Lewis <[email protected]> Sat, 18 Jan 2025 11:32:27 -0600
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format.
--===============7517376858731230638==
Content-Type: multipart/alternative;
boundary="------------EddBtO6JZZRU96SjX8okA3Mf"
Content-Language: en-US
This is a multi-part message in MIME format.
--------------EddBtO6JZZRU96SjX8okA3Mf
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
My database engine was LibreOffice 25.2 accessing my databases through
HSQLDB 2.74. I opened my database and did some work and closed it.
Later, I accessed it again and noticed that the tables were missing.
Then I open the Script file as a text document. This is when I noticed
that the bottom of this file was missing.
*What it should look like:*
CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE CACHED TABLE PUBLIC."Accounts"("Names" VARCHAR(100) NOT NULL
PRIMARY KEY)
CREATE CACHED TABLE PUBLIC."Auto"("Odometer" DECIMAL(8,1) NOT
NULL,"Maintenance" VARCHAR(100),"Next_Scheduled" DATE,"Fuel"
DECIMAL(6,3),"Data_ID" INTEGER NOT NULL,"Car" VARCHAR(100) NOT
NULL,PRIMARY KEY("Odometer","Car"))
CREATE CACHED TABLE PUBLIC."Data"("Data_ID" INTEGER GENERATED BY DEFAULT
AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"Transactions_ID" INTEGER
NOT NULL,"Budget_1" VARCHAR(50) NOT NULL,"Budget_2" VARCHAR(50) NOT
NULL,"Budget_3" VARCHAR(50),"Amount" DECIMAL(10,2) NOT NULL,"Account"
VARCHAR(50),"Reconcile" TINYINT,"Budget" DECIMAL(7,3))
ALTER TABLE PUBLIC."Data" ALTER COLUMN "Data_ID" RESTART WITH 7479
CREATE CACHED TABLE PUBLIC."Transactions"("Transactions_ID" INTEGER
GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY
KEY,"Transaction_No_" VARCHAR(50) NOT NULL,"Date" DATE NOT NULL,"Name"
VARCHAR(50) NOT NULL,"Amount" DECIMAL(10,2) NOT NULL,"Note" VARCHAR(254))
ALTER TABLE PUBLIC."Transactions" ALTER COLUMN "Transactions_ID" RESTART
WITH 3765
CREATE CACHED TABLE PUBLIC."Budget1"("Name" VARCHAR(100) NOT NULL
PRIMARY KEY)
CREATE CACHED TABLE PUBLIC."Budget2"("Name" VARCHAR(100) NOT NULL
PRIMARY KEY)
CREATE CACHED TABLE PUBLIC."Budget3"("Name" VARCHAR(100) NOT NULL
PRIMARY KEY)
CREATE CACHED TABLE PUBLIC."Car"("Name" VARCHAR(100) NOT NULL PRIMARY KEY)
CREATE CACHED TABLE PUBLIC."BRSchedule"("ID" INTEGER NOT NULL PRIMARY
KEY,"Date" DATE NOT NULL,"Today" VARCHAR(10) NOT NULL,"Second"
VARCHAR(20),"Third" VARCHAR(20),"Tomorrow" VARCHAR(20) NOT NULL)
CREATE CACHED TABLE PUBLIC."Book"("Book ID" INTEGER NOT NULL PRIMARY
KEY,"Book" VARCHAR(15))
CREATE CACHED TABLE PUBLIC."BP"("BP ID" INTEGER GENERATED BY DEFAULT AS
IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"Date" DATE,"ACE pill"
INTEGER,"Note" VARCHAR(255),"Diuretic" BOOLEAN)
ALTER TABLE PUBLIC."BP" ALTER COLUMN "BP ID" RESTART WITH 1287
CREATE CACHED TABLE PUBLIC."BPData"("ID" INTEGER GENERATED BY DEFAULT AS
IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"BP ID" INTEGER,"Systolic"
SMALLINT,"Time" VARCHAR(100),"Diastolic" SMALLINT,"Pulse"
SMALLINT,"Temperature" DECIMAL(16,1),"Glucose" DECIMAL(16,1),FOREIGN
KEY("BP ID") REFERENCES PUBLIC."BP"("BP ID"))
ALTER TABLE PUBLIC."BPData" ALTER COLUMN "ID" RESTART WITH 2859
CREATE CACHED TABLE PUBLIC."Category"("Category ID" INTEGER NOT NULL
PRIMARY KEY,"Category" VARCHAR(20))
CREATE CACHED TABLE PUBLIC."Commentary"("Commentary" VARCHAR(8000),"BR
ID" INTEGER,"C ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH
0) NOT NULL PRIMARY KEY,"book" VARCHAR(100),"chapter" INTEGER,"verse"
INTEGER)
ALTER TABLE PUBLIC."Commentary" ALTER COLUMN "C ID" RESTART WITH 1093
CREATE CACHED TABLE PUBLIC."Mileage"("MainID" INTEGER GENERATED BY
DEFAULT AS IDENTITY(START WITH 124) NOT NULL PRIMARY KEY,"Trip"
DECIMAL(16,1),"Odometer" DECIMAL(10),"Date" DATE)
ALTER TABLE PUBLIC."Mileage" ALTER COLUMN "MainID" RESTART WITH 199
CREATE CACHED TABLE PUBLIC."Mileage-data"("DailyID" INTEGER GENERATED BY
DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"MainID"
INTEGER,"EndTripOD" DECIMAL(5,1),"destination" VARCHAR(150),"Date"
DATE,"Dan-mi" DECIMAL(5,1),"Sherrie-mi" DECIMAL(5,1),"Total-mi"
DECIMAL(5,1),"Fuel mi" SMALLINT,"est mi" DECIMAL(16,1),FOREIGN
KEY("MainID") REFERENCES PUBLIC."Mileage"("MainID"))
ALTER TABLE PUBLIC."Mileage-data" ALTER COLUMN "DailyID" RESTART WITH 1891
CREATE CACHED TABLE PUBLIC."Filter"("ID" INTEGER NOT NULL PRIMARY
KEY,"Gallons" TINYINT NOT NULL,"0.5" DATE,"1" DATE,"1.5" DATE,"2"
DATE,"2.5" DATE,"3" DATE,"3.5" DATE,"4" DATE)
CREATE CACHED TABLE PUBLIC."MedLabResults"("Lab ID" INTEGER GENERATED BY
DEFAULT AS IDENTITY(START WITH 95) NOT NULL PRIMARY KEY,"Date" DATE,"BP"
VARCHAR(100),"Glucose" SMALLINT,"A1C" DECIMAL(16,1),"HDL" SMALLINT,"LDL"
SMALLINT,"Triglycerides" SMALLINT,"Na" SMALLINT,"K" DECIMAL(16,1),"CL"
SMALLINT,"Total Chol" SMALLINT,"CO2" SMALLINT,"Ca adj Albumin"
DECIMAL(16,1),"BUN" TINYINT,"Creatinine" DECIMAL(3,2),"Protein_total"
DECIMAL(16,1),"Albumin" DECIMAL(16,1),"Albumin/Globulin"
DECIMAL(16,1),"Bilirubin" DECIMAL(16,1),"Alkaline phosphatase"
TINYINT,"AST" TINYINT,"ALT" TINYINT,"eGFR" VARCHAR(100),"Chol/HDL"
DECIMAL(16,1),"LDL/HDL" DECIMAL(2,1),"Ave Glucose" SMALLINT,"weight"
DECIMAL(16,2),"PSA" DECIMAL(16,1),"Ca" DECIMAL(16,1),"Notes" VARCHAR(400))
ALTER TABLE PUBLIC."MedLabResults" ALTER COLUMN "Lab ID" RESTART WITH 104
CREATE CACHED TABLE PUBLIC."Time Period"("Time" VARCHAR(100) NOT NULL
PRIMARY KEY)
CREATE CACHED TABLE PUBLIC."Calorie Summary"("Food ID" INTEGER GENERATED
BY DEFAULT AS IDENTITY(START WITH 61) NOT NULL PRIMARY KEY,"Name"
VARCHAR(50),"Quantity" NUMERIC(50,3),"Calories" NUMERIC(50,2),"Protein"
NUMERIC(50,2),"Carbohydrates" NUMERIC(50,2),"Fat" NUMERIC(50,2),"Serving
Size" VARCHAR(50),"Consumed" BOOLEAN,"Food type" VARCHAR(50),"Fiber"
NUMERIC(50,1))
ALTER TABLE PUBLIC."Calorie Summary" ALTER COLUMN "Food ID" RESTART WITH 99
CREATE CACHED TABLE PUBLIC."Bible Reading"("BR ID" INTEGER NOT NULL
PRIMARY KEY,"Scriptures" VARCHAR(20),"Category" VARCHAR(20),"Book"
VARCHAR(15))
CREATE CACHED TABLE PUBLIC."Consumed"("Daily" INTEGER NOT
NULL,"Breakfast" VARCHAR(50),"Lunch" VARCHAR(50),"Supper"
VARCHAR(50),"Date" DATE NOT NULL PRIMARY KEY,"Total" VARCHAR(50))
CREATE CACHED TABLE PUBLIC."ProvVs"("id" TINYINT GENERATED BY DEFAULT AS
IDENTITY(START WITH 2) NOT NULL PRIMARY KEY,"prov_id" TINYINT,"verse"
TINYINT)
ALTER TABLE PUBLIC."ProvVs" ALTER COLUMN "id" RESTART WITH 14
CREATE CACHED TABLE PUBLIC."ProvCom"("id" INTEGER GENERATED BY DEFAULT
AS IDENTITY(START WITH 2) NOT NULL PRIMARY KEY,"provVs_id"
TINYINT,"commentary" VARCHAR(4000),FOREIGN KEY("provVs_id") REFERENCES
PUBLIC."ProvVs"("id") ON DELETE CASCADE ON UPDATE CASCADE)
ALTER TABLE PUBLIC."ProvCom" ALTER COLUMN "id" RESTART WITH 16
CREATE CACHED TABLE PUBLIC."ProvCh"("id" INTEGER GENERATED BY DEFAULT AS
IDENTITY(START WITH 3) NOT NULL PRIMARY KEY,"chapter" TINYINT)
ALTER TABLE PUBLIC."ProvCh" ALTER COLUMN "id" RESTART WITH 10
CREATE CACHED TABLE PUBLIC."Vocabulary"("id" INTEGER NOT NULL PRIMARY
KEY,"name" VARCHAR(100),"meanings" VARCHAR(100))
CREATE CACHED TABLE PUBLIC."Verbs"("id" INTEGER NOT NULL PRIMARY
KEY,"name" VARCHAR(100),"present_tense" INTEGER,"past_tense"
INTEGER,"gerands" INTEGER)
CREATE CACHED TABLE PUBLIC."present_tense"("id" INTEGER NOT NULL PRIMARY
KEY,"1s" VARCHAR(100),"2s" VARCHAR(100),"3s" VARCHAR(100),"1p"
VARCHAR(100),"2p" VARCHAR(100),"3p" VARCHAR(100))
CREATE CACHED TABLE PUBLIC."past_tense"("id" INTEGER NOT NULL PRIMARY
KEY,"1s" VARCHAR(100),"2s" VARCHAR(100),"3s" VARCHAR(100),"1p"
VARCHAR(100),"2p" VARCHAR(100),"3p" VARCHAR(100))
CREATE CACHED TABLE PUBLIC."Gerands"("id" INTEGER NOT NULL PRIMARY
KEY,"pre_participle" VARCHAR(100),"past_participle" VARCHAR(100))
CREATE CACHED TABLE PUBLIC."Months"("id" INTEGER GENERATED BY DEFAULT AS
IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,"name" VARCHAR(100))
ALTER TABLE PUBLIC."Months" ALTER COLUMN "id" RESTART WITH 14
CREATE CACHED TABLE PUBLIC."jewCal"("id" INTEGER GENERATED BY DEFAULT AS
IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,"date" DATE,"feast"
VARCHAR(4000))
ALTER TABLE PUBLIC."jewCal" ALTER COLUMN "id" RESTART WITH 23
ALTER TABLE PUBLIC."Auto" ADD FOREIGN KEY("Data_ID") REFERENCES
PUBLIC."Data"("Data_ID")
ALTER TABLE PUBLIC."Data" ADD FOREIGN KEY("Transactions_ID") REFERENCES
PUBLIC."Transactions"("Transactions_ID") ON DELETE CASCADE ON UPDATE CASCADE
ALTER TABLE PUBLIC."Commentary" ADD FOREIGN KEY("BR ID") REFERENCES
PUBLIC."Bible Reading"("BR ID") ON DELETE CASCADE ON UPDATE CASCADE
ALTER TABLE PUBLIC."ProvVs" ADD FOREIGN KEY("prov_id") REFERENCES
PUBLIC."ProvCh"("id") ON DELETE CASCADE ON UPDATE CASCADE
ALTER SEQUENCE SYSTEM_LOBS.LOB_ID RESTART WITH 1
SET DATABASE DEFAULT INITIAL SCHEMA PUBLIC
SET TABLE PUBLIC."Accounts" INDEX '14 0 13'
SET TABLE PUBLIC."Auto" INDEX '114457 114457 0 0 1'
SET TABLE PUBLIC."Data" INDEX '114039 114047 0 0 59'
SET TABLE PUBLIC."Transactions" INDEX '114113 0 21'
SET TABLE PUBLIC."Budget1" INDEX '37158 0 14'
SET TABLE PUBLIC."Budget2" INDEX '37232 0 61'
SET TABLE PUBLIC."Budget3" INDEX '37462 0 90'
SET TABLE PUBLIC."Car" INDEX '37538 0 4'
SET TABLE PUBLIC."BRSchedule" INDEX '37817 0 334'
SET TABLE PUBLIC."Book" INDEX '38356 0 66'
SET TABLE PUBLIC."BP" INDEX '39644 0 1273'
SET TABLE PUBLIC."BPData" INDEX '44390 46588 0 0 2825'
SET TABLE PUBLIC."Category" INDEX '49784 0 9'
SET TABLE PUBLIC."Commentary" INDEX '105376 105367 0 0 9'
SET TABLE PUBLIC."Mileage" INDEX '87273 0 186'
SET TABLE PUBLIC."Mileage-data" INDEX '91963 91898 0 0 1795'
SET TABLE PUBLIC."Filter" INDEX '95032 0 10'
SET TABLE PUBLIC."MedLabResults" INDEX '95208 0 69'
SET TABLE PUBLIC."Time Period" INDEX '98638 0 18'
SET TABLE PUBLIC."Calorie Summary" INDEX '98919 0 91'
SET TABLE PUBLIC."Bible Reading" INDEX '99470 0 334'
SET TABLE PUBLIC."Consumed" INDEX '103630 0 9'
SET TABLE PUBLIC."ProvVs" INDEX '104528 104520 0 0 12'
SET TABLE PUBLIC."ProvCom" INDEX '104610 104648 0 0 11'
SET TABLE PUBLIC."ProvCh" INDEX '104750 0 9'
SET TABLE PUBLIC."Months" INDEX '105114 0 13'
SET TABLE PUBLIC."jewCal" INDEX '105281 0 19'
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CARDINAL_NUMBER TO PUBLIC
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.YES_OR_NO TO PUBLIC
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CHARACTER_DATA TO PUBLIC
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.SQL_IDENTIFIER TO PUBLIC
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.TIME_STAMP TO PUBLIC
GRANT DBA TO SA
SET SCHEMA SYSTEM_LOBS
INSERT INTO BLOCKS VALUES(0,2147483647,0)
*What it did look like*
SET DATABASE DEFAULT INITIAL SCHEMA PUBLIC
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CARDINAL_NUMBER TO PUBLIC
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.YES_OR_NO TO PUBLIC
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CHARACTER_DATA TO PUBLIC
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.SQL_IDENTIFIER TO PUBLIC
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.TIME_STAMP TO PUBLIC
GRANT DBA TO SA
SET SCHEMA SYSTEM_LOBS
INSERT INTO BLOCKS VALUES(0,2147483647,0).
I was using LibreOffice 25.2.01 with 2.73 before 2.74 came out. When
2.74 came out, I used LibreOffice to switch to 2.74 in late October. I
got the results as above. Since that time I have switch LibreOffice to
24.8.4 with HSQLDB 2.73. I rebuilt the database using a back up of it,
and I have had no further problems.
*What happened?*
*Dan
*
--------------EddBtO6JZZRU96SjX8okA3Mf
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<p>My database engine was LibreOffice 25.2 accessing my databases
through HSQLDB 2.74. I opened my database and did some work and
closed it. Later, I accessed it again and noticed that the tables
were missing. Then I open the Script file as a text document. This
is when I noticed that the bottom of this file was missing. </p>
<p><b>What it should look like:</b><br>
</p>
<p>CREATE SCHEMA PUBLIC AUTHORIZATION DBA<br>
CREATE CACHED TABLE PUBLIC."Accounts"("Names" VARCHAR(100) NOT
NULL PRIMARY KEY)<br>
CREATE CACHED TABLE PUBLIC."Auto"("Odometer" DECIMAL(8,1) NOT
NULL,"Maintenance" VARCHAR(100),"Next_Scheduled" DATE,"Fuel"
DECIMAL(6,3),"Data_ID" INTEGER NOT NULL,"Car" VARCHAR(100) NOT
NULL,PRIMARY KEY("Odometer","Car"))<br>
CREATE CACHED TABLE PUBLIC."Data"("Data_ID" INTEGER GENERATED BY
DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY
KEY,"Transactions_ID" INTEGER NOT NULL,"Budget_1" VARCHAR(50) NOT
NULL,"Budget_2" VARCHAR(50) NOT NULL,"Budget_3"
VARCHAR(50),"Amount" DECIMAL(10,2) NOT NULL,"Account"
VARCHAR(50),"Reconcile" TINYINT,"Budget" DECIMAL(7,3))<br>
ALTER TABLE PUBLIC."Data" ALTER COLUMN "Data_ID" RESTART WITH 7479<br>
CREATE CACHED TABLE PUBLIC."Transactions"("Transactions_ID"
INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL
PRIMARY KEY,"Transaction_No_" VARCHAR(50) NOT NULL,"Date" DATE NOT
NULL,"Name" VARCHAR(50) NOT NULL,"Amount" DECIMAL(10,2) NOT
NULL,"Note" VARCHAR(254))<br>
ALTER TABLE PUBLIC."Transactions" ALTER COLUMN "Transactions_ID"
RESTART WITH 3765<br>
CREATE CACHED TABLE PUBLIC."Budget1"("Name" VARCHAR(100) NOT NULL
PRIMARY KEY)<br>
CREATE CACHED TABLE PUBLIC."Budget2"("Name" VARCHAR(100) NOT NULL
PRIMARY KEY)<br>
CREATE CACHED TABLE PUBLIC."Budget3"("Name" VARCHAR(100) NOT NULL
PRIMARY KEY)<br>
CREATE CACHED TABLE PUBLIC."Car"("Name" VARCHAR(100) NOT NULL
PRIMARY KEY)<br>
CREATE CACHED TABLE PUBLIC."BRSchedule"("ID" INTEGER NOT NULL
PRIMARY KEY,"Date" DATE NOT NULL,"Today" VARCHAR(10) NOT
NULL,"Second" VARCHAR(20),"Third" VARCHAR(20),"Tomorrow"
VARCHAR(20) NOT NULL)<br>
CREATE CACHED TABLE PUBLIC."Book"("Book ID" INTEGER NOT NULL
PRIMARY KEY,"Book" VARCHAR(15))<br>
CREATE CACHED TABLE PUBLIC."BP"("BP ID" INTEGER GENERATED BY
DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"Date"
DATE,"ACE pill" INTEGER,"Note" VARCHAR(255),"Diuretic" BOOLEAN)<br>
ALTER TABLE PUBLIC."BP" ALTER COLUMN "BP ID" RESTART WITH 1287<br>
CREATE CACHED TABLE PUBLIC."BPData"("ID" INTEGER GENERATED BY
DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"BP ID"
INTEGER,"Systolic" SMALLINT,"Time" VARCHAR(100),"Diastolic"
SMALLINT,"Pulse" SMALLINT,"Temperature" DECIMAL(16,1),"Glucose"
DECIMAL(16,1),FOREIGN KEY("BP ID") REFERENCES PUBLIC."BP"("BP
ID"))<br>
ALTER TABLE PUBLIC."BPData" ALTER COLUMN "ID" RESTART WITH 2859<br>
CREATE CACHED TABLE PUBLIC."Category"("Category ID" INTEGER NOT
NULL PRIMARY KEY,"Category" VARCHAR(20))<br>
CREATE CACHED TABLE PUBLIC."Commentary"("Commentary"
VARCHAR(8000),"BR ID" INTEGER,"C ID" INTEGER GENERATED BY DEFAULT
AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"book"
VARCHAR(100),"chapter" INTEGER,"verse" INTEGER)<br>
ALTER TABLE PUBLIC."Commentary" ALTER COLUMN "C ID" RESTART WITH
1093<br>
CREATE CACHED TABLE PUBLIC."Mileage"("MainID" INTEGER GENERATED BY
DEFAULT AS IDENTITY(START WITH 124) NOT NULL PRIMARY KEY,"Trip"
DECIMAL(16,1),"Odometer" DECIMAL(10),"Date" DATE)<br>
ALTER TABLE PUBLIC."Mileage" ALTER COLUMN "MainID" RESTART WITH
199<br>
CREATE CACHED TABLE PUBLIC."Mileage-data"("DailyID" INTEGER
GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY
KEY,"MainID" INTEGER,"EndTripOD" DECIMAL(5,1),"destination"
VARCHAR(150),"Date" DATE,"Dan-mi" DECIMAL(5,1),"Sherrie-mi"
DECIMAL(5,1),"Total-mi" DECIMAL(5,1),"Fuel mi" SMALLINT,"est mi"
DECIMAL(16,1),FOREIGN KEY("MainID") REFERENCES
PUBLIC."Mileage"("MainID"))<br>
ALTER TABLE PUBLIC."Mileage-data" ALTER COLUMN "DailyID" RESTART
WITH 1891<br>
CREATE CACHED TABLE PUBLIC."Filter"("ID" INTEGER NOT NULL PRIMARY
KEY,"Gallons" TINYINT NOT NULL,"0.5" DATE,"1" DATE,"1.5" DATE,"2"
DATE,"2.5" DATE,"3" DATE,"3.5" DATE,"4" DATE)<br>
CREATE CACHED TABLE PUBLIC."MedLabResults"("Lab ID" INTEGER
GENERATED BY DEFAULT AS IDENTITY(START WITH 95) NOT NULL PRIMARY
KEY,"Date" DATE,"BP" VARCHAR(100),"Glucose" SMALLINT,"A1C"
DECIMAL(16,1),"HDL" SMALLINT,"LDL" SMALLINT,"Triglycerides"
SMALLINT,"Na" SMALLINT,"K" DECIMAL(16,1),"CL" SMALLINT,"Total
Chol" SMALLINT,"CO2" SMALLINT,"Ca adj Albumin" DECIMAL(16,1),"BUN"
TINYINT,"Creatinine" DECIMAL(3,2),"Protein_total"
DECIMAL(16,1),"Albumin" DECIMAL(16,1),"Albumin/Globulin"
DECIMAL(16,1),"Bilirubin" DECIMAL(16,1),"Alkaline phosphatase"
TINYINT,"AST" TINYINT,"ALT" TINYINT,"eGFR" VARCHAR(100),"Chol/HDL"
DECIMAL(16,1),"LDL/HDL" DECIMAL(2,1),"Ave Glucose"
SMALLINT,"weight" DECIMAL(16,2),"PSA" DECIMAL(16,1),"Ca"
DECIMAL(16,1),"Notes" VARCHAR(400))<br>
ALTER TABLE PUBLIC."MedLabResults" ALTER COLUMN "Lab ID" RESTART
WITH 104<br>
CREATE CACHED TABLE PUBLIC."Time Period"("Time" VARCHAR(100) NOT
NULL PRIMARY KEY)<br>
CREATE CACHED TABLE PUBLIC."Calorie Summary"("Food ID" INTEGER
GENERATED BY DEFAULT AS IDENTITY(START WITH 61) NOT NULL PRIMARY
KEY,"Name" VARCHAR(50),"Quantity" NUMERIC(50,3),"Calories"
NUMERIC(50,2),"Protein" NUMERIC(50,2),"Carbohydrates"
NUMERIC(50,2),"Fat" NUMERIC(50,2),"Serving Size"
VARCHAR(50),"Consumed" BOOLEAN,"Food type" VARCHAR(50),"Fiber"
NUMERIC(50,1))<br>
ALTER TABLE PUBLIC."Calorie Summary" ALTER COLUMN "Food ID"
RESTART WITH 99<br>
CREATE CACHED TABLE PUBLIC."Bible Reading"("BR ID" INTEGER NOT
NULL PRIMARY KEY,"Scriptures" VARCHAR(20),"Category"
VARCHAR(20),"Book" VARCHAR(15))<br>
CREATE CACHED TABLE PUBLIC."Consumed"("Daily" INTEGER NOT
NULL,"Breakfast" VARCHAR(50),"Lunch" VARCHAR(50),"Supper"
VARCHAR(50),"Date" DATE NOT NULL PRIMARY KEY,"Total" VARCHAR(50))<br>
CREATE CACHED TABLE PUBLIC."ProvVs"("id" TINYINT GENERATED BY
DEFAULT AS IDENTITY(START WITH 2) NOT NULL PRIMARY KEY,"prov_id"
TINYINT,"verse" TINYINT)<br>
ALTER TABLE PUBLIC."ProvVs" ALTER COLUMN "id" RESTART WITH 14<br>
CREATE CACHED TABLE PUBLIC."ProvCom"("id" INTEGER GENERATED BY
DEFAULT AS IDENTITY(START WITH 2) NOT NULL PRIMARY KEY,"provVs_id"
TINYINT,"commentary" VARCHAR(4000),FOREIGN KEY("provVs_id")
REFERENCES PUBLIC."ProvVs"("id") ON DELETE CASCADE ON UPDATE
CASCADE)<br>
ALTER TABLE PUBLIC."ProvCom" ALTER COLUMN "id" RESTART WITH 16<br>
CREATE CACHED TABLE PUBLIC."ProvCh"("id" INTEGER GENERATED BY
DEFAULT AS IDENTITY(START WITH 3) NOT NULL PRIMARY KEY,"chapter"
TINYINT)<br>
ALTER TABLE PUBLIC."ProvCh" ALTER COLUMN "id" RESTART WITH 10<br>
CREATE CACHED TABLE PUBLIC."Vocabulary"("id" INTEGER NOT NULL
PRIMARY KEY,"name" VARCHAR(100),"meanings" VARCHAR(100))<br>
CREATE CACHED TABLE PUBLIC."Verbs"("id" INTEGER NOT NULL PRIMARY
KEY,"name" VARCHAR(100),"present_tense" INTEGER,"past_tense"
INTEGER,"gerands" INTEGER)<br>
CREATE CACHED TABLE PUBLIC."present_tense"("id" INTEGER NOT NULL
PRIMARY KEY,"1s" VARCHAR(100),"2s" VARCHAR(100),"3s"
VARCHAR(100),"1p" VARCHAR(100),"2p" VARCHAR(100),"3p"
VARCHAR(100))<br>
CREATE CACHED TABLE PUBLIC."past_tense"("id" INTEGER NOT NULL
PRIMARY KEY,"1s" VARCHAR(100),"2s" VARCHAR(100),"3s"
VARCHAR(100),"1p" VARCHAR(100),"2p" VARCHAR(100),"3p"
VARCHAR(100))<br>
CREATE CACHED TABLE PUBLIC."Gerands"("id" INTEGER NOT NULL PRIMARY
KEY,"pre_participle" VARCHAR(100),"past_participle" VARCHAR(100))<br>
CREATE CACHED TABLE PUBLIC."Months"("id" INTEGER GENERATED BY
DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,"name"
VARCHAR(100))<br>
ALTER TABLE PUBLIC."Months" ALTER COLUMN "id" RESTART WITH 14<br>
CREATE CACHED TABLE PUBLIC."jewCal"("id" INTEGER GENERATED BY
DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,"date"
DATE,"feast" VARCHAR(4000))<br>
ALTER TABLE PUBLIC."jewCal" ALTER COLUMN "id" RESTART WITH 23<br>
ALTER TABLE PUBLIC."Auto" ADD FOREIGN KEY("Data_ID") REFERENCES
PUBLIC."Data"("Data_ID")<br>
ALTER TABLE PUBLIC."Data" ADD FOREIGN KEY("Transactions_ID")
REFERENCES PUBLIC."Transactions"("Transactions_ID") ON DELETE
CASCADE ON UPDATE CASCADE<br>
ALTER TABLE PUBLIC."Commentary" ADD FOREIGN KEY("BR ID")
REFERENCES PUBLIC."Bible Reading"("BR ID") ON DELETE CASCADE ON
UPDATE CASCADE<br>
ALTER TABLE PUBLIC."ProvVs" ADD FOREIGN KEY("prov_id") REFERENCES
PUBLIC."ProvCh"("id") ON DELETE CASCADE ON UPDATE CASCADE<br>
ALTER SEQUENCE SYSTEM_LOBS.LOB_ID RESTART WITH 1<br>
SET DATABASE DEFAULT INITIAL SCHEMA PUBLIC<br>
SET TABLE PUBLIC."Accounts" INDEX '14 0 13'<br>
SET TABLE PUBLIC."Auto" INDEX '114457 114457 0 0 1'<br>
SET TABLE PUBLIC."Data" INDEX '114039 114047 0 0 59'<br>
SET TABLE PUBLIC."Transactions" INDEX '114113 0 21'<br>
SET TABLE PUBLIC."Budget1" INDEX '37158 0 14'<br>
SET TABLE PUBLIC."Budget2" INDEX '37232 0 61'<br>
SET TABLE PUBLIC."Budget3" INDEX '37462 0 90'<br>
SET TABLE PUBLIC."Car" INDEX '37538 0 4'<br>
SET TABLE PUBLIC."BRSchedule" INDEX '37817 0 334'<br>
SET TABLE PUBLIC."Book" INDEX '38356 0 66'<br>
SET TABLE PUBLIC."BP" INDEX '39644 0 1273'<br>
SET TABLE PUBLIC."BPData" INDEX '44390 46588 0 0 2825'<br>
SET TABLE PUBLIC."Category" INDEX '49784 0 9'<br>
SET TABLE PUBLIC."Commentary" INDEX '105376 105367 0 0 9'<br>
SET TABLE PUBLIC."Mileage" INDEX '87273 0 186'<br>
SET TABLE PUBLIC."Mileage-data" INDEX '91963 91898 0 0 1795'<br>
SET TABLE PUBLIC."Filter" INDEX '95032 0 10'<br>
SET TABLE PUBLIC."MedLabResults" INDEX '95208 0 69'<br>
SET TABLE PUBLIC."Time Period" INDEX '98638 0 18'<br>
SET TABLE PUBLIC."Calorie Summary" INDEX '98919 0 91'<br>
SET TABLE PUBLIC."Bible Reading" INDEX '99470 0 334'<br>
SET TABLE PUBLIC."Consumed" INDEX '103630 0 9'<br>
SET TABLE PUBLIC."ProvVs" INDEX '104528 104520 0 0 12'<br>
SET TABLE PUBLIC."ProvCom" INDEX '104610 104648 0 0 11'<br>
SET TABLE PUBLIC."ProvCh" INDEX '104750 0 9'<br>
SET TABLE PUBLIC."Months" INDEX '105114 0 13'<br>
SET TABLE PUBLIC."jewCal" INDEX '105281 0 19'<br>
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CARDINAL_NUMBER TO PUBLIC<br>
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.YES_OR_NO TO PUBLIC<br>
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CHARACTER_DATA TO PUBLIC<br>
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.SQL_IDENTIFIER TO PUBLIC<br>
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.TIME_STAMP TO PUBLIC<br>
GRANT DBA TO SA<br>
SET SCHEMA SYSTEM_LOBS<br>
INSERT INTO BLOCKS VALUES(0,2147483647,0)</p>
<p><b>What it did look like</b></p>
<p>SET DATABASE DEFAULT INITIAL SCHEMA PUBLIC<br>
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CARDINAL_NUMBER TO PUBLIC<br>
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.YES_OR_NO TO PUBLIC<br>
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CHARACTER_DATA TO PUBLIC<br>
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.SQL_IDENTIFIER TO PUBLIC<br>
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.TIME_STAMP TO PUBLIC<br>
GRANT DBA TO SA<br>
SET SCHEMA SYSTEM_LOBS<br>
INSERT INTO BLOCKS VALUES(0,2147483647,0).</p>
<p>I was using LibreOffice 25.2.01 with 2.73 before 2.74 came out.
When 2.74 came out, I used LibreOffice to switch to 2.74 in late
October. I got the results as above. Since that time I have switch
LibreOffice to 24.8.4 with HSQLDB 2.73. I rebuilt the database
using a back up of it, and I have had no further problems.</p>
<p><b>What happened?</b></p>
<p><b>Dan<br>
</b></p>
</body>
</html>
--------------EddBtO6JZZRU96SjX8okA3Mf--
--===============7517376858731230638==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
--===============7517376858731230638==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
--===============7517376858731230638==--