Christoph Lukasiak wrote:
(just for info: HSQL is the native database engine for
staroffice/openoffice base)
moin database testing folks (and beyond),
for testing it out, paste the new hsqldb.jar file into the
'office/program/classes' folder and restart the office
(if you want to keep the current version, do not forget to rename it,
before pasting the new one ;)
the latest HSQL engine is currently available here:
http://dba.openoffice.org/servlets/ProjectDocumentList?folderID=719&expandFolder=719&folderID=0
please give feedback, if anything runs wrong
thx
p.s. some problems in handling of 'views' created with older versions
were fixed (means: no big change)
p.p.s. special thanks for the early pre-testing by the OOo database QA
Team (escecially drew)
(http://qa.openoffice.org/ooQAReloaded/DatabaseTeamsite/ooQA-TeamDatabase.html)
It appears I have found another problem with this jar and views.
Helping a user on the Forum the user sent me a Base file with a query
that was taking minutes to run - I used 2.4 and created a view, then a
query that used the view. This got the query down to under 2 seconds..so
far so good.
In testing it I went ahead and ran it under 2.3.1 with the second HSQLdb
1.0.10 jar file. At first it ran fine, till I made a change to the file
and saved it under 2.3.1 - at this point the view still ran but the
query stopped running.
The original view statement, as displayed in the query designer under 2.4:
SELECT
"AOU Birdlist"."EnglishName",
"Sightings"."Field Trip ID",
"Field Trips"."Date",
"Field Trips"."Location"
FROM "Sightings", "Field Trips", "AOU Birdlist"
WHERE
( "Sightings"."Field Trip ID" = "Field Trips"."ID" AND "AOU
Birdlist"."EnglishName" = "Sightings"."Bird Name" )
AND ( "Sightings"."User1Voice" = True )
UNION
SELECT
"AOU Birdlist"."EnglishName",
"Sightings"."Field Trip ID",
"Field Trips"."Date",
"Field Trips"."Location"
FROM "Sightings", "Field Trips", "AOU Birdlist"
WHERE
( "Sightings"."Field Trip ID" = "Field Trips"."ID" AND "AOU
Birdlist"."EnglishName" = "Sightings"."Bird Name" )
AND ( "Sightings"."User1Sight" = True )
and the query that used it:
SELECT
"EnglishName",
CAST( MIN( "Date" ) AS DATE ) AS "FirstSightedDate",
COUNT( "Date" ) AS "SightingsCount"
FROM "vUser1SightHeard"
GROUP BY "EnglishName"
What happened is that after the save 2.3.1 started returning the field
names from the view with double quotes as part of the field name. So,
the field name EnglishName became the string literal "EnglishName"
Going back to OO.o 2.4 it continued to do the same thing - I had to
actually open the views for edit in 2.4 and save them again, then save
the odb file to fix it.
I'll try to put together a smaller example database that does it again.
Should I open an issue for this or let the guys at the HSQLdb project
know directly, or just an email here with the location of the file.
Drew
--
OpenOffice.org User Community Forum: http://user.services.openoffice.org
United States PostgreSQL Association: http://www.postgresql.us/
--
OpenOffice.org User Community Forum: http://user.services.openoffice.org
United States PostgreSQL Association: http://www.postgresql.us/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
