duursma

Bogus ERROR messages on generating points in geometry

7

In Ora2PG::GEOM::createPoint the line: `$self->logit("ERROR: SDO_ELEM_INFO for Point starting offset $sOffset inconsistent with ordinates length " . ($#{$coords} + 1));` is triggered regulary because the sOffset is tested against the...

INTERNAL conversion uses the srid from the object instead of the meta-data

3

On converting geometries from srid to epsg is seems that the correct epsg is found, but when using INTERNAL to convert, the conversion takes the srid from the geometry object...

I have a geometry collection consisting of a polygon followed by a linestring MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1,179,2,1) On conversion of the polygon the linestring is 'added' as a 'linear ring' as a result...

Missing commandline config option to import_all.sh

3

The import_all.sh uses commandline parameters to specify where to import all structural items. For the data copy it fall back to the config/ora2pg.conf file which may have different information. I...

The code: IF ((v_format = 'las1.2') OR (v_format = 'las2.0')) THEN read_las(p_file_dbk, p_filename, p_file_size, p_user_nm, v_format); ELSE unknown_format(p_filename); -- Onbekend fileformaat g_error_opgetreden := 1; END IF; IF (g_error_opgetreden = 1)...

NULL test for global variable fails if testing for NULL and empty string

1

The line: IF (g_bgm_imp_id IS NOT NULL) THEN gets translated to: IF (current_setting('bgm_file_import.g_bgm_imp_id')::(numeric(38) IS NOT NULL AND (numeric(38))::text '')) THEN where g_bgm_imp_id is a global variable. With the NULL_EQUAL_EMPTY setting.

The with part of a query: with data as ( select accumulation_nm, operator_nm, extract (year from t1.start_date) year, extract (month from t1.start_date) month, quantity / 1000 as quantity FROM res_prod_fig_mnth_acc_gas_d...

Package variable packed with 'current_setting' while used for input

4

The Oracle package procedure: ``` PROCEDURE write_las (p_text VARCHAR2) IS ERR_MSG VARCHAR2(100); BEGIN IF (g_bgm_seqnr IS NULL) THEN SELECT NVL(MAX(sequence_nr), 0) INTO g_bgm_seqnr FROM BGM_TEXT_FILE WHERE file_dbk = g_bgm_file_dbk; END...

NULL_EQUAL_EMPTY generates invalid code

1

The null_equal_empty configuration currently generates invalid code if the argument is a number. some_dbk is not null gets translated to (some_dbk and some_dbk::text '') This give the error that a...

## Expected Behavior The relation diagram currently shows the table name. Selecting the table show also the description of the table. I would like to have the command line option...