I carry out the following steps, which I have done many times before
without any problem:
Copy Query <Query name>
Paste as table, <Table name>
Definition and data
Create primary key IDT
Next

At this point I get a message:
"<Table name> is no SQL conform identifier"
If I click for more information I get the message:
"Choose the option 'Append data' on the first page to append data to an
existing table."
Which is not what I am trying to do, I am trying to create a new table
from the query.

As far as I have found out up to now this is something to do with the
primary key.

So, questions:

- Are the changes to SQL intentional, meaning that SQL statements will
need to be edited, or not, this is a bug and normal service will be
resumed when it is sorted out?
- Are these errors connected with the migration to Firebird?
- "is no SQL conform identifier" does not make sense, should it be "does
not conform to SQL identifier specification".

I found that the setting:
"Use SQL-92 naming constraints"
in Edit > Database > Advanced settings" was set.  I unset it and the
problem seems to be resolved.

Is this a new setting that defaults to being set?  Or a setting that has
been changed to default to set?

I suppose I could have inadvertently set it, but I don't know how as
these are not settings that I am not aware of ever having changed.

John

retitle 911859 libreoffice-base: "<table> is no SQL conform identifier" if containing non-SQL-92-allowed
characters
thanks

Hi,

sorry for the late answer.

I am not actually sure but I wouldn't be surprised for either.
Priobably for hsqldb->firebird.

Being strict about the SQL standard is a good thing in principle and the
bug imho is that you didn't confirm to it/whatever hsqldb/the code created
didn't.

What is your table name? Does it contain special characters or so?
Is it SQL 92 conform? See e.g.
https://db.apache.org/derby/docs/10.9/ref/crefsqlj1003454.html

Ah, I see that in a previous mail you wrote

As far as I have found out up to now this is something to do with the
primary key.

So, questions:

- Are the changes to SQL intentional, meaning that SQL statements will
need to be edited, or not, this is a bug and normal service will be
resumed when it is sorted out?
- Are these errors connected with the migration to Firebird?
- "is no SQL conform identifier" does not make sense, should it be "does
not conform to SQL identifier specification".
--- snip ---

which would explain it.

Nah, don't think you set it.

Regards,

Rene

Dear submitter,

as the package libreoffice has just been removed from the Debian archive
experimental we hereby close the associated bug reports.  We are sorry
that we couldn't deal with your issue properly.

For details on the removal, please see https://bugs.debian.org/1069123

The version of this package that was in Debian prior to this removal
can still be found using https://snapshot.debian.org/.

Please note that the changes have been done on the master archive and
will not propagate to any mirrors until the next dinstall run at the
earliest.

This message was generated automatically; if you believe that there is
a problem with it please contact the archive administrators by mailing
ftpmaster@ftp-master.debian.org.

Debian distribution maintenance software
pp.
Scott Kitterman (the ftpmaster behind the curtain)

Humanitarian Grant of 1.5M for you. Reply for claims