Access violation on nested table

Discussion of open issues, suggestions and bugs regarding PgDAC (PostgreSQL Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
upscene
Posts: 306
Joined: Thu 19 Oct 2006 08:13

Access violation on nested table

Post by upscene » Wed 06 Jul 2016 08:37

Hi,

Performing a query on nested table fails with:
Access violation at address 00000000. Read of address 00000000

Use this:

Code: Select all

CREATE TABLE IF NOT EXISTS public.nested_tablename2 (
  colname2 Serial NOT NULL ,
  vc30 VarChar(30)
);

CREATE TABLE IF NOT EXISTS public.nested_tablename (
  colname Serial NOT NULL,
  field01 Integer,
  field02 public.nested_tablename2
);

commit;

insert into nested_tablename(field01)
values (1)

commit;

and simply a select * from nested_tablename will do the trick.

I'm using the PgDAC 4.7.23, RAD Studio 2009, on PostgreSQL 9.4

Hope this helps.

With regards,

Martijn Tonies

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Access violation on nested table

Post by AlexP » Wed 06 Jul 2016 09:59

Hello,

We have reproduced AV on PostgreSQL 9.4. We will investigate the reasons for such behavior and inform you as soon as we get any results.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Access violation on nested table

Post by AlexP » Thu 07 Jul 2016 08:15

We have already fixed the problem. The fix will be included in the next version.

upscene
Posts: 306
Joined: Thu 19 Oct 2006 08:13

Re: Access violation on nested table

Post by upscene » Thu 07 Jul 2016 08:26

Excellent.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Access violation on nested table

Post by AlexP » Thu 07 Jul 2016 12:44

If you have any other questions, feel free to contact us

Post Reply