Issue1413

classification
Title: Array data type (PostgreSQL) is not supported (NPE)
Type: crash Severity: normal
Components: zxjdbc Versions: 2.5.0
process
Status: closed Resolution: fixed
Dependencies: Superseder:
Assigned To: pjenvey Nosy List: Lonebuddha, pjenvey
Priority: Keywords:

Created on 2009-07-27.13:56:56 by Lonebuddha, last changed 2009-07-30.03:11:53 by pjenvey.

Files
File name Uploaded Description Edit Remove
trace Lonebuddha, 2009-07-27.13:56:55 NPE stack trace
Messages
msg4951 (view) Author: Andrey Sukhanov (Lonebuddha) Date: 2009-07-27.13:56:55
NPE is raised if there is an array column (value is NULL) in PostgreSQL
table.

Database driver: postgresql-8.4-701.jdbc4.jar

Example:

CREATE TABLE private_info (
    _ppl_seq       INTEGER NOT NULL,
    tax_ident      VARCHAR(16) NOT NULL,
    ethnicity      VARCHAR(16)[]
);

INSERT INTO private_info (_ppl_seq,tax_ident,ethnicity) VALUES
(10,'222-22-1492',ARRAY['white']),
(11,'456-27-7645',NULL);

SELECT ethnicity FROM private_info;

Stack trace is attached.
msg4960 (view) Author: Philip Jenvey (pjenvey) Date: 2009-07-30.03:11:53
fixed in r6599, thanks
History
Date User Action Args
2009-07-30 03:11:53pjenveysetstatus: open -> closed
resolution: fixed
messages: + msg4960
2009-07-30 03:00:45pjenveysetassignee: pjenvey
nosy: + pjenvey
2009-07-27 14:20:20Lonebuddhasettype: crash
2009-07-27 13:56:56Lonebuddhacreate