Activity
From 09/18/2019 to 10/17/2019
10/17/2019
- 04:33 PM Support #3871: determine how to change codepages/locales during import
- At this moment I suppose now that PostgreSQL database has been configured to have @UTF-8@ encoding. If another one-by...
10/16/2019
- 01:31 PM Support #3871: determine how to change codepages/locales during import
- Yes, these are the only three supported dialects (see implementations of @P2JDialect@) at this moment.
- 12:00 PM Support #3871: determine how to change codepages/locales during import
- Ovidiu, thank you for help. Should we support only PostgreSql, H2 and MS SQL Server?
- 10:22 AM Support #3871: determine how to change codepages/locales during import
- It seems that not all database developers have chosen to honour ANSI standard.
For H2 (I updated my h2 test envir... - 04:26 AM Support #3871: determine how to change codepages/locales during import
- Ovidiu Maxiniuc wrote:
> Review of r11346 / 3871a.
>
> Generally I am OK with the new code as it seem logical, ex... - 07:04 AM Feature #2156: datetime-tz and hibernate
- > * In what use case(s) is the UTC timestamp sufficient?
Also comparison and WHERE statement. - 06:46 AM Feature #2156: datetime-tz and hibernate
- > * In what use case(s) do we need the timezone that originally was known when the datum was stored?
When @datetim...
10/15/2019
- 07:29 PM Feature #2156: datetime-tz and hibernate
- Sorry, I've gotten lost in all the circles here. Can we take a step back? Please help me understand the following fun...
- 05:00 PM Feature #2156: datetime-tz and hibernate
- > either we force the same-zone column for all dialects
I suppose we are going that way. And basically I was wonde... - 04:38 PM Feature #2156: datetime-tz and hibernate
- OK, I understand, thanks. I was mislead because of the final convert. But the idea is the same.
- 04:35 PM Feature #2156: datetime-tz and hibernate
- >The additional column is added only because of PSQL. It converts all DTZs to local (not UTC) DT and store them that ...
- 04:10 PM Feature #2156: datetime-tz and hibernate
- Actually, all supported db engines (H2, PSQL and MSSQL) will handle the mixed-timezone timestamps. Please see note 23...
- 03:41 PM Feature #2156: datetime-tz and hibernate
- Stanislav Lomany wrote:
> In addition: now we have timestamps with different timezones in one column (correct me if ... - 03:38 PM Feature #2156: datetime-tz and hibernate
- In addition: now we have timestamps with different timezones in one column (correct me if I'm wrong). I suggest to us...
- 03:22 PM Feature #2156: datetime-tz and hibernate
- Currently when we create a @datetime-tz@ instance with, e.g. @TIMESTAMP+05@, it stores @TIMESTAMP(+05)@ timestamp and...
- 02:24 PM Feature #2156: datetime-tz and hibernate
- > for PostgreSQL timezone is a session parameter
Are you assuming that all @datetime-tz@ instances have the same ... - 12:24 PM Feature #2156: datetime-tz and hibernate
- > We are going to use 2 columns. BUT the 2nd column is only for us to restore the offset when we use it in the JVM. ...
- 04:29 PM Support #3871: determine how to change codepages/locales during import
- Review of r11346 / 3871a.
Generally I am OK with the new code as it seem logical, except for the query from @Impor... - 02:15 PM Feature #3814: more schema metadata
- Additional metadata requirements:
Need conversion and runtime support:... - 02:07 PM Feature #4176: make certain metadata tables aware of live runtime state
- Add to the list of metadata which must be made "live":...
- 12:46 PM Feature #3815: more temp-table options
- Everything is complete in this task?
Is the gap marking up to date as well?
10/14/2019
- 04:44 PM Support #4080: AWS Aurora support
- Greg Shah wrote:
> Some thoughts from Eric:
>
> In regard to pljava, as long as this can be selected/enabled for ... - 04:12 PM Support #4080: AWS Aurora support
- Some thoughts from Eric:
In regard to pljava, as long as this can be selected/enabled for an Aurora instance, we s...
10/13/2019
- 01:59 PM Feature #3809: ProDataSet support
- Ovidiu, please add history entries to the files you modified in 3809e. Thanks!
10/11/2019
- 06:32 AM Support #3871: determine how to change codepages/locales during import
- 3871a was rebased up to revision 11346 over 11337 trunc.
10/10/2019
- 04:40 PM Feature #4323: parse full FQL statements and convert them to SQL
- Ovidiu Maxiniuc wrote:
> I am trying to clean-up the code after DDL changes and I am not sure whether we need the @m... - 02:50 PM Feature #4323: parse full FQL statements and convert them to SQL
- Eric,
I am trying to clean-up the code after DDL changes and I am not sure whether we need the @merge-dmo-root@ se... - 04:04 PM Feature #3815 (Review): more temp-table options
- 3816a has been merged into the trunk as bzr revision 11337.
- 03:10 PM Support #3871: determine how to change codepages/locales during import
- Committed revision 11344 (3871a) fixed missed comment.
- 03:01 PM Support #3871 (Review): determine how to change codepages/locales during import
- The committed revision 11343 (3871a) should fix the cases when the source code page is UTF8 or a different code page ...
- 03:53 AM Support #3871: determine how to change codepages/locales during import
- This it the test example. The question for me is that BOM (https://en.wikipedia.org/wiki/Byte_order_mark) is generate...
- 03:46 AM Support #3871: determine how to change codepages/locales during import
- I found that the UTF-8 source dump file is imported incorrectly now. The problem here is @FileStream@ is supposed to ...
10/09/2019
- 08:49 AM Support #3871: determine how to change codepages/locales during import
- Greg, please review the committed rev 11338 (3871a). It was tested with UTF-8 PostgresSql database.
10/08/2019
- 03:00 PM Feature #2156: datetime-tz and hibernate
- Constantin Asofiei wrote:
> There's one other thing to add for @datetime-tz@ - its usage in indexes and sort clauses... - 01:47 PM Feature #2156: datetime-tz and hibernate
- Stanislav Lomany wrote:
> Could you please elaborate what should be done for this task? datetime-tz seems to be work... - 12:21 PM Feature #2156: datetime-tz and hibernate
- Could you please elaborate what should be done for this task? datetime-tz seems to be working in general.
- 10:37 AM Support #3871: determine how to change codepages/locales during import
- I doesn't matter what one byte encoding is used. If it is internally mapped into UTF-8, then this issue can be observ...
- 10:32 AM Support #3871: determine how to change codepages/locales during import
- Sergey Ivanovskiy wrote:
> OK, it seems that the Hibernate uses UTF-8 internally because I experimented with US-ASCI... - 06:52 AM Support #3871: determine how to change codepages/locales during import
- OK, it seems that the Hibernate uses UTF-8 internally because I experimented with US-ASCII encoding as a default enco...
- 06:42 AM Support #3871: determine how to change codepages/locales during import
- If there is no valid codepage conversion for the INPUT_ENCODING to the DATABASE_ENCODING, then you should throw an ex...
- 06:26 AM Support #3871: determine how to change codepages/locales during import
- This is that imported file encoded as WINDOWS-1251.
- 06:24 AM Support #3871: determine how to change codepages/locales during import
- I don't know the way how to convert parameters for HSQL queries like this one...
- 06:16 AM Support #3871: determine how to change codepages/locales during import
- Sergey Ivanovskiy wrote:
> Greg Shah wrote:
> > > Then the client will read the imported data from this database as... - 06:10 AM Support #3871: determine how to change codepages/locales during import
- >Where are the UTF-8 strings coming from? Are they from the import data?
UTF-8 is the default encoding for my java e... - 05:59 AM Support #3871: determine how to change codepages/locales during import
- Greg Shah wrote:
> > Then the client will read the imported data from this database as LATIN-1 strings because the d... - 05:47 AM Support #3871: determine how to change codepages/locales during import
- > Then the client will read the imported data from this database as LATIN-1 strings because the database has LATIN-1 ...
- 05:25 AM Support #3871: determine how to change codepages/locales during import
- Sergey Ivanovskiy wrote:
> I think that there is only one way to save UTF-8 strings into LATIN-1 database is to conv... - 05:15 AM Support #3871: determine how to change codepages/locales during import
- I think that there is only one way to save UTF-8/Unicode strings into LATIN-1 database that is to convert UTF-8 strin...
10/07/2019
- 02:17 PM Support #3871: determine how to change codepages/locales during import
- I encountered the following issue that the WINDOWS-1251 string decoded into the UTF-8 string (if UTF-8 is a default j...
- 06:26 AM Support #3871: determine how to change codepages/locales during import
- Let us consider this case in which the database has LATIN-1 encoding and the import table has WINDOWS-1251 encoding. ...
- 10:21 AM Feature #4323: parse full FQL statements and convert them to SQL
- These are generateDDL() calls for the metadata database. I am working on it right now.
10/04/2019
- 05:35 PM Feature #4323: parse full FQL statements and convert them to SQL
- Are there any other project-level changes that need to be made, beside those in your last note? I'm trying to convert...
- 04:01 PM Feature #4323: parse full FQL statements and convert them to SQL
- I committed latest changes to 4011a/rr11344.
If you have an old ddl directory, please backup it. The conversion wi... - 02:16 PM Feature #4323: parse full FQL statements and convert them to SQL
- Is there a new class @DDLGeneratorWorker@ that was supposed to be checked in?...
- 01:59 PM Feature #4323: parse full FQL statements and convert them to SQL
- I forgot to CTRL+F5 :(.
- 01:57 PM Feature #4323: parse full FQL statements and convert them to SQL
- Sorry, Eric. I cleaned the .g file only looking at the @ExpressionParser@. Indeed, I was too eager to drop the @java....
- 01:54 PM Feature #4323: parse full FQL statements and convert them to SQL
- BTW, Greg has decreed that "FWDQL" should be "FQL" :)
Please work that name change back into the code, file names,... - 01:50 PM Feature #4323: parse full FQL statements and convert them to SQL
- Ovidiu, I'm getting the following compile errors with 4011a/11342:...
- 07:02 AM Bug #3471: incremental conversion is regressed
- > for OO, the tricky part is keeping the Java converted method name consistent. If you recall, we need to keep this c...
10/03/2019
- 05:34 PM Bug #3471: incremental conversion is regressed
- I'm still checking, but the current issues are:
* for OO, the tricky part is keeping the Java converted method name ...
10/02/2019
- 01:54 PM Support #3871: determine how to change codepages/locales during import
- Created task branch 3871a.
- 01:09 PM Bug #3471 (WIP): incremental conversion is regressed
- 01:09 PM Bug #3471: incremental conversion is regressed
- Full convert/compile will always be required when someones updates FWD, and there are parser changes where the token ...
09/27/2019
- 03:15 PM Bug #3379 (Closed): do not copy index definitions when defining WORKFILE like TABLE
- I'm ok with the changes.
- 02:41 PM Bug #3379: do not copy index definitions when defining WORKFILE like TABLE
- Greg Shah wrote:
> 4103a was merged to trunk as revision 11331. Can this task be closed?
I think yes. - 02:37 PM Bug #3379: do not copy index definitions when defining WORKFILE like TABLE
- 4103a was merged to trunk as revision 11331. Can this task be closed?
09/25/2019
- 09:05 AM Support #3871: determine how to change codepages/locales during import
- Google helps that this query follows ANSI standard schema view https://en.wikipedia.org/wiki/Information_schema
<pre... - 09:00 AM Support #3871: determine how to change codepages/locales during import
- I don't know a database-independent way to query a database encoding. For PosgreSQL this query returns its encoding
...
09/24/2019
- 10:22 AM Support #3871: determine how to change codepages/locales during import
- Please read #3871-7 for the details on what you are meant to implement.
* For the input encoding,tThe @DataFileR... - 10:15 AM Support #3871: determine how to change codepages/locales during import
- Greg, I imported UTF-8 data into LATIN-1 PostgresSQL database using @-Dfile.encoding=UTF-8@ input parameter. I am not...
- 09:52 AM Support #3871: determine how to change codepages/locales during import
- It seems that the client can use different encodings https://www.postgresql.org/docs/9.6/multibyte.html and hence the...
- 09:50 AM Support #3871: determine how to change codepages/locales during import
- > What is the proper database encoding if data dump files are UTF-8? Should not it be UTF-8? Can it be LATIN-1 if ano...
- 09:46 AM Support #3871: determine how to change codepages/locales during import
- What is the proper database encoding if data dump files are UTF-8? Should not it be UTF-8? Can it be LATIN-1 if anoth...
- 09:15 AM Support #3871: determine how to change codepages/locales during import
- Ovidiu, thank you.
Now the db import scripts work properly, although the import of UTF-8 data
1 "cat"
2 "КОШК... - 08:55 AM Support #3871: determine how to change codepages/locales during import
- This is normal. The database was already imported at least once. Remove the sequence manually.
Note that if a table... - 08:50 AM Support #3871: determine how to change codepages/locales during import
- Running this script for PostgreSQL...
09/23/2019
- 04:22 PM Support #3871: determine how to change codepages/locales during import
- It seems that H2 or PostgreSQL should have the same issue when importing UTF-8 dumps. OK. I will test PostgreSQL. It ...
- 03:29 PM Support #3871: determine how to change codepages/locales during import
- Sergey Ivanovskiy wrote:
> This configuration
> [...]
> doesn't work too.
What exactly is not working? If ther... - 03:27 PM Support #3871: determine how to change codepages/locales during import
- Debug into the @PatternEngine@ to see why it is failing.
- 03:16 PM Support #3871: determine how to change codepages/locales during import
- This configuration ...
- 02:48 PM Support #3871: determine how to change codepages/locales during import
- This ant task works properly for this project:...
- 02:39 PM Support #3871: determine how to change codepages/locales during import
- Yes, command line is wrong. It seems like @data/namespace encode2.p2o@ should not have a space in it.
- 02:11 PM Support #3871: determine how to change codepages/locales during import
- Greg Shah wrote:
> Please see #4279-91 for how to fix the unicode character escape sequence. I don't know what is w...
09/22/2019
- 04:30 PM Support #3871: determine how to change codepages/locales during import
- Please see #4279-91 for how to fix the unicode character escape sequence. I don't know what is wrong with the other ...
- 03:03 AM Support #3871: determine how to change codepages/locales during import
- The fragment of the converted program looks incorrect too...
- 02:20 AM Support #3871: determine how to change codepages/locales during import
- I created a 4GL databases @encode2.db@ using @UTF-8@ encoding based on @C:\Progress\OE116_64\prolang\utf\ICU-ru.df@. ...
09/20/2019
- 02:48 PM Support #3871: determine how to change codepages/locales during import
- Sergey Ivanovskiy wrote:
> Are these statements correct that @-cpinternal@ code page is used for character variables... - 02:00 PM Support #3871: determine how to change codepages/locales during import
- and @proutil encode1.db -C idxbuild all -cpinternal UTF-8@ was successful. It seems that for UTF-8 database encoding ...
- 01:50 PM Support #3871: determine how to change codepages/locales during import
- I used this command to rebuild indices for UTF-8 database and please look what was the output
@proutil encode1.db -C... - 01:45 PM Support #3871: determine how to change codepages/locales during import
- Are these statements correct that @-cpinternal@ code page is used for character variables and fields and @-cpstream@ ...
- 07:05 AM Support #3871: determine how to change codepages/locales during import
- Some other things to check:
* to access the data dump, you need to start the procedure editor; what happens if you ... - 06:18 AM Support #3871: determine how to change codepages/locales during import
- First step I think is to create a database in 4GL with non-default codepage/locale, add some records with non-ASCII c...
- 06:09 AM Support #3871: determine how to change codepages/locales during import
- What should be done in order to test solutions for this task?
- 06:07 AM Support #3871 (WIP): determine how to change codepages/locales during import
- 05:54 AM Support #3871: determine how to change codepages/locales during import
- It follows that within @ImportWorker@ namespace @DataFileReader.processPscHeader()@ fills @encoding@ field and this f...
09/19/2019
- 06:26 PM Feature #4323: parse full FQL statements and convert them to SQL
- In a recent email, you noted you had added support for field/column aliases. I'm not sure whether you were referring ...
- 06:13 PM Feature #4323: parse full FQL statements and convert them to SQL
- Ovidiu Maxiniuc wrote:
> Two questions I thought about but I do not have the answer yet:
> * how to handle EXTENTS ... - 10:44 AM Feature #4307: DMO conversion changes
- The @TempTableRecord@ methods are not directly accessed by the business logic. Instead they are accessed only interna...
09/18/2019
- 04:33 PM Feature #4307: DMO conversion changes
- Let me ask what I'm really trying to understand... Do the temp-table DMO proxies used by business logic ever need to ...
- 04:15 PM Feature #4307: DMO conversion changes
- Yes, you deduce correctly. @TempTableRecord@ adds 5 new fields to standard record. You need to look at 4124a to see a...
- 03:31 PM Feature #4307: DMO conversion changes
- Ovidiu, I am trying to rationalize the DMO class/interface hierarchy to eliminate casting and differential logic to h...
Also available in: Atom