FWD » Core Development » Database

07/17/2021

09:04 AM Feature #5491: custom locale/collation implementations

The H2/Java collation names and Linux/PostgreSQL locale names were unified as described above.
Also, I think I updat... Ovidiu Maxiniuc

07/15/2021

06:30 PM Feature #4022: upgrade to a newer PostgreSQL release

I have been trying to get my test system going using PostgreSQL 13 for updated client code, and when I get to the PL/... Roger Borrello

04:46 PM Feature #5491: custom locale/collation implementations

@en_US.iso88591_fwd_basic@ will be then. Ovidiu Maxiniuc

04:36 PM Feature #5491: custom locale/collation implementations

I prefer the underscores. Greg Shah

04:03 PM Feature #5491: custom locale/collation implementations

Eric Faulhaber wrote:
> OK, Ovidiu, so it sounds like we need to keep this setting in @p2j.cfg.xml@. But for consist... Eric Faulhaber

04:02 PM Feature #5491: custom locale/collation implementations

OK, Ovidiu, so it sounds like we need to keep this setting in @p2j.cfg.xml@. But for consistency from the user's pers... Eric Faulhaber

03:38 PM Feature #5491: custom locale/collation implementations

Constantin Asofiei wrote:
> Do you mean this in @p2j.cfg.xml@?
> [...]
>
> The reason was to emit the @set colla... Constantin Asofiei

02:31 PM Feature #5491: custom locale/collation implementations

Do you mean this in @p2j.cfg.xml@?... Constantin Asofiei

02:18 PM Feature #5491: custom locale/collation implementations

Eric Faulhaber wrote:
> If we need to keep the collation setting in @p2j.cfg.xml@, we can accept either form. I th... Eric Faulhaber

02:16 PM Feature #5491: custom locale/collation implementations

Ovidiu Maxiniuc wrote:
> I did not think about it that way, but it makes sense. We can use the @@@, too in this ca... Eric Faulhaber

01:30 PM Feature #5491: custom locale/collation implementations

Eric Faulhaber wrote:
> Do you recall what that is used for?
According to bzr, it was added in 2010, with the _"sup... Ovidiu Maxiniuc

12:35 PM Feature #5491: custom locale/collation implementations

Ovidiu Maxiniuc wrote:
> This seems to fit in both worlds.
I don't think it really fits in the Linux world. The... Eric Faulhaber

12:24 PM Feature #5491: custom locale/collation implementations

H2 identifies the locale using its name this way:... Ovidiu Maxiniuc

11:22 AM Feature #5491: custom locale/collation implementations

Ovidiu Maxiniuc wrote:
> The SPI only provides a sort order. The language and country are probably irrelevant here... Eric Faulhaber

11:01 AM Feature #5491: custom locale/collation implementations

From #5034:
The SPI only provides a sort order. The language and country are probably irrelevant here, but they ar... Ovidiu Maxiniuc

07/14/2021

07:21 PM Feature #5491: custom locale/collation implementations

I assume that setting would be in the form @<language>_<COUNTRY>@, e.g., @en_US@, @en_GB@, etc. To compose an @embedd... Eric Faulhaber

06:58 PM Feature #5491: custom locale/collation implementations

Eric Faulhaber wrote:
> ...
> Do we already have comparable settings in the directory (or programmatic defaults) fo... Eric Faulhaber

06:53 PM Feature #5491 (WIP): custom locale/collation implementations

We need to simplify the configuration of the locale/collation in use for databases, including the @_temp@ database. I... Eric Faulhaber

07/10/2021

04:29 AM Bug #5540: can't query meta info for meta tables

@testcases/uast/dump_meta_info.p@ reads all the @_File@ records and outputs some meta information about all tables (f... Constantin Asofiei

04:27 AM Bug #5540 (New): can't query meta info for meta tables

Constantin Asofiei

07/07/2021

03:44 PM Feature #5491: custom locale/collation implementations

Code review 3821c/12640:
The changes in this revision look good.
I took another look at @gen-locale.p@ and I di... Eric Faulhaber

09:10 PM Feature #5491: custom locale/collation implementations

Done. Committed revision 12640.
I also updated the extractor procedure to create new files with fixed header/title a... Ovidiu Maxiniuc

10:20 AM Bug #5521 (Closed): [java] java.io.EOFException on import when no PSC footer

Greg Shah

10:15 AM Bug #5521: [java] java.io.EOFException on import when no PSC footer

My @ant import.db@ of the database went off without any issues (aside from my PL/Java getting upgraded to 1.6.2 again). Roger Borrello

06:22 AM Bug #5521 (Test): [java] java.io.EOFException on import when no PSC footer

Greg Shah

06:22 AM Bug #5521: [java] java.io.EOFException on import when no PSC footer

Code Review Task Branch 3821c Revison 12640
The changes look good. Greg Shah

09:07 PM Bug #5521 (WIP): [java] java.io.EOFException on import when no PSC footer

The issue should be fixed in revision 12640. Ovidiu Maxiniuc

07/06/2021

08:14 AM Bug #5521: [java] java.io.EOFException on import when no PSC footer

Some details are available in the related thread starting at #5034-814.
From Greg:
>I don't think we should be s... Roger Borrello

08:12 AM Bug #5521 (Closed): [java] java.io.EOFException on import when no PSC footer

Roger Borrello

07/05/2021

06:51 PM Feature #4022: upgrade to a newer PostgreSQL release

I noticed that @postgresql-10-pljava@ was on the auto-update list, and pljava was upgraded at 5pm to @1.6.2-2.pgdg20.... Roger Borrello

04:59 PM Feature #5491: custom locale/collation implementations

Please change the @title@ in the @LC_IDENTIFICATION@ section of the @en_GB@ locale definitions to say, "Great Britain... Eric Faulhaber

04:26 PM Feature #5491: custom locale/collation implementations

No, I'll close it after review of this current batch. As we create more locales/collators over time, we can reopen it... Eric Faulhaber

04:20 PM Feature #5491 (Review): custom locale/collation implementations

Do we keep this task open for adding new collations? Ovidiu Maxiniuc

07/02/2021

05:13 PM Support #5183: database collation

Ovidiu Maxiniuc wrote:
> The listing you obtained is pretty much the one we currently have in @locale/xx_XX@ISO8859-... Eric Faulhaber

10:27 AM Support #5183: database collation

The listing you obtained is pretty much the one we currently have in @locale/xx_XX@ISO8859-1@basic@FWD@ and @src/com/... Ovidiu Maxiniuc

10:06 AM Support #5183: database collation

Eric,
The space character (@0x20@, or @32@ decimal) is incorrectly listed in the 2nd position. This is because the c... Ovidiu Maxiniuc

04:43 AM Support #5183: database collation

h2. Comparison of OE ISO-8859-1 basic collation vs. PostgreSQL ISO-8859-1 default collation (en_US)
I created ISO-... Eric Faulhaber

03:33 PM Bug #5512: Java todate(text) UDF returns incorect value

@public.todate('06302001')@ returns '2001-06-29' which doesn't look correct. Igor Skornyakov

03:32 PM Bug #5512 (New): Java todate(text) UDF returns incorect value

Igor Skornyakov

02:01 PM Feature #4022: upgrade to a newer PostgreSQL release

Constantin Asofiei wrote:
> Please read the above as 'unofficial steps'. There may be a better way to do this, but ... Roger Borrello

01:57 PM Feature #4022: upgrade to a newer PostgreSQL release

The release notes for PL/Java https://tada.github.io/pljava/releasenotes.html indicate the moved to the Java 9 module... Roger Borrello

01:56 PM Feature #4022: upgrade to a newer PostgreSQL release

I went through setting up PL/Java 1.6.2 last week (with psql 12.7). 1.6.2 does require Java 11 - it is compiled as s... Constantin Asofiei

01:45 PM Feature #4022: upgrade to a newer PostgreSQL release

OK, don't install PL/Java through apt. This is actually untested, so you are breaking new ground here.
Does PL/Jav... Eric Faulhaber

01:09 PM Feature #4022: upgrade to a newer PostgreSQL release

Roger Borrello wrote:
> So getting to the Java 11 uninstall... it also uninstall pljava. So when this is done, I'll ... Roger Borrello

01:05 PM Feature #4022: upgrade to a newer PostgreSQL release

I started reading the fine manual at PL/Java: https://tada.github.io/pljava/install/install.html
When I ran @pg_co... Roger Borrello

02:12 AM Feature #4022: upgrade to a newer PostgreSQL release

Roger Borrello wrote:
> What are your thoughts on the @/opt/pljava/install.sql@ script (attached) in terms of when/h... Eric Faulhaber

12:08 AM Feature #4022: upgrade to a newer PostgreSQL release

What are your thoughts on the @/opt/pljava/install.sql@ script (attached) in terms of when/how to run it? I don't see... Roger Borrello

10:07 PM Feature #4022: upgrade to a newer PostgreSQL release

Roger Borrello wrote:
> ...
> Eric and I went over quite a few things, but it doesn't appear that the Java 11 I hav... Eric Faulhaber

08:25 PM Feature #4022: upgrade to a newer PostgreSQL release

Greg suggested I create a new task in database, but this task looks well suited for the issues related to installing ... Roger Borrello

01:53 PM Bug #5511: todate(text) Java UDF throws strange exception

Java UDF @todate(text)@ throws an exception @SQL Error [XX000]: ERROR: java.lang.NoClassDefFoundError: com/goldencode... Igor Skornyakov

01:52 PM Bug #5511 (New): todate(text) Java UDF throws strange exception

Igor Skornyakov

07/01/2021

12:54 PM Support #5183: database collation

> @locale -a@ does not list them
If @localedef@ was successful there should be new locale files. If that is the c... Greg Shah

12:44 PM Support #5183: database collation

Do you have @/usr/share/i18n/charmaps/CP1252.gz@? If so, @gunzip@ it. I think @locale-gen@ just runs @localedef@ unde... Eric Faulhaber

12:35 PM Support #5183: database collation

Eric Faulhaber wrote:
> These were the specific lines I added to @/etc/locale.gen@, based on some Googling:
> [...]... Ovidiu Maxiniuc

12:20 PM Support #5183: database collation

Roger Borrello wrote:
> A general question about the use of a custom locale. The database for an existing applicatio... Eric Faulhaber

12:17 PM Support #5183: database collation

Ovidiu Maxiniuc wrote:
> Eric,
> I have not tried to use the @en_US.cp1252@ locale until now. Only the custom local... Eric Faulhaber

11:39 AM Support #5183: database collation

A general question about the use of a custom locale. The database for an existing application would need to be droppe... Roger Borrello

11:33 AM Support #5183: database collation

Eric,
I have not tried to use the @en_US.cp1252@ locale until now. Only the custom locales. However, when I try to d... Ovidiu Maxiniuc

03:07 AM Support #5183: database collation

Ovidiu, I need your help.
In any of your encoding testing lately, have you been able to create a database cluster ... Eric Faulhaber

06/30/2021

09:20 PM Feature #5491: custom locale/collation implementations

Sorry, I do not know how these task properties has changed. I did not do it on purpose :(. Ovidiu Maxiniuc

09:15 PM Feature #5491: custom locale/collation implementations

Eric Faulhaber wrote:
> Ovidiu, please update the FWD documentation with the new approach to installation and config... Ovidiu Maxiniuc

06/29/2021

04:14 PM Feature #5491: custom locale/collation implementations

Ovidiu, please update the FWD documentation with the new approach to installation and configuration. Specifically, th... Eric Faulhaber

06/28/2021

03:20 PM Feature #5491 (WIP): custom locale/collation implementations

Yes. They would be identified by:
| PostgreSQL | @en_US@CP1252@basic@FWD@,
@en_GB@CP1252@basic@FWD@ and
@nl_NL@CP1... Ovidiu Maxiniuc

02:47 PM Feature #5491: custom locale/collation implementations

OK, understood.
Then shouldn't we mirror the same approach for the @p2jspi.jar@? This may avoid confusion. Greg Shah

02:20 PM Feature #5491: custom locale/collation implementations

It is a bit more complicated than that.
We need to keep the lang/land prefix. This is used within the locale script... Ovidiu Maxiniuc

02:05 PM Feature #5491: custom locale/collation implementations

Then perhaps we should not have @en_US@CP1252@FWD@, @en_GB@CP1252@FWD@ and @nl_NL@CP1252@FWD@ but instead just @basic... Greg Shah

01:36 PM Feature #5491: custom locale/collation implementations

I investigated the content of the @convmap.cp@ on my Windows test machine and I found the following collations availa... Ovidiu Maxiniuc

10:10 AM Feature #5491: custom locale/collation implementations

Indeed, at first I thought that using different CPs will automatically imply a specific sorting order since I did not... Ovidiu Maxiniuc

07:07 AM Feature #5491: custom locale/collation implementations

> The language and country parameters are not relevant (for what I know)
Are you saying that we've never found any... Greg Shah

06/26/2021

05:51 PM Feature #5491: custom locale/collation implementations

Committed revision 12576.
Added @ISO_8859_15Collator.java@ and @CP1252Collator.java@ identified as described above... Ovidiu Maxiniuc

06/25/2021

07:22 PM Feature #5491: custom locale/collation implementations

At this moment @ISO_8859_1Collator@ is the only collation registered with the 'identifier' <code class="Java">new Loc... Ovidiu Maxiniuc

10:53 AM Feature #5491: custom locale/collation implementations

The @locale/gen-locale.p@ program has recently been updated and several new OS-level custom locales have been generat... Eric Faulhaber

10:35 AM Feature #5491 (Closed): custom locale/collation implementations

Eric Faulhaber