Firebird Embedded глюк!

SELECT
  PERSON.*,
  (select PERENUM.NLSOLD from perenum where  PERSON.NLS=PERENUM.NLSNEW)
FROM
 PERSON

CREATE TABLE PERSON (
    ID INTEGER,
    STATE SMALLINT,
    SDATE DATE,
    CEH INTEGER,
    F VARCHAR (20) CHARACTER SET WIN1251 COLLATE WIN1251,
    I VARCHAR (20) CHARACTER SET WIN1251 COLLATE WIN1251,
    O VARCHAR (20) CHARACTER SET WIN1251 COLLATE WIN1251,
    NLS VARCHAR (20) CHARACTER SET WIN1251 COLLATE WIN1251,
    NCARD VARCHAR (18) CHARACTER SET WIN1251 COLLATE WIN1251,
    S_PASS VARCHAR (8) CHARACTER SET WIN1251 COLLATE WIN1251,
    N_PASS VARCHAR (20) CHARACTER SET WIN1251 COLLATE WIN1251,
    W_PASS VARCHAR (45) CHARACTER SET WIN1251 COLLATE WIN1251,
    D_PASS DATE,
    P_INDEX VARCHAR (6) CHARACTER SET WIN1251 COLLATE WIN1251,
    REGION VARCHAR (35) CHARACTER SET WIN1251 COLLATE WIN1251,
    NPUNKT VARCHAR (20) CHARACTER SET WIN1251 COLLATE WIN1251,
    NPUNKTTYPE INTEGER,
    RAYON VARCHAR (30) CHARACTER SET WIN1251 COLLATE WIN1251,
    STREET VARCHAR (35) CHARACTER SET WIN1251 COLLATE WIN1251,
    STREETTYPE INTEGER,
    HOUSE INTEGER,
    KORP VARCHAR (2) CHARACTER SET WIN1251 COLLATE WIN1251,
    NOMER VARCHAR (3) CHARACTER SET WIN1251 COLLATE WIN1251,
    TEL1 VARCHAR (9) CHARACTER SET WIN1251 COLLATE WIN1251,
    TEL2 VARCHAR (9) CHARACTER SET WIN1251 COLLATE WIN1251,
    D_BIRTH DATE,
    P_BIRTH VARCHAR (45) CHARACTER SET WIN1251 COLLATE WIN1251,
    TABN INTEGER,
    SOZN VARCHAR (12) CHARACTER SET WIN1251 COLLATE WIN1251,
    KLIENTID INTEGER,
    EXPDATE DATE);



/* Indices definition */

CREATE INDEX IDX_PERSON_CEH ON PERSON (CEH);
CREATE INDEX IDX_PERSON_F ON PERSON (F);
CREATE INDEX IDX_PERSON_I ON PERSON (I);
CREATE UNIQUE INDEX IDX_PERSON_ID ON PERSON (ID);
CREATE INDEX IDX_PERSON_KLIENTID ON PERSON (KLIENTID);
CREATE INDEX IDX_PERSON_O ON PERSON (O);
CREATE INDEX IDX_PERSON_STATE ON PERSON (STATE);

SET TERM ^ ;

/* Triggers definition */



/* Trigger: AI_PERSON_ID */
CREATE TRIGGER AI_PERSON_ID FOR PERSON ACTIVE
BEFORE INSERT POSITION 0
AS
BEGIN
  IF (NEW.ID IS NULL) THEN
      NEW.ID = GEN_ID(PERSON_ID_GEN, 1);
END
^


SET TERM ; ^

CREATE TABLE PERENUM (
    NCARD VARCHAR (18) CHARACTER SET WIN1251 COLLATE WIN1251,
    NLSOLD VARCHAR (20) CHARACTER SET WIN1251 COLLATE WIN1251,
    NLSNEW VARCHAR (20) CHARACTER SET WIN1251 COLLATE WIN1251);

/* Indices definition */

CREATE UNIQUE INDEX IDX_NLSNEW ON PERENUM (NLSNEW);
CREATE UNIQUE INDEX IDX_NLSOLD ON PERENUM (NLSOLD);

SELECT
  PERSON.*,
  (select PERENUM.NLSOLD from perenum where  PERSON.NLS=PERENUM.NLSNEW)
FROM
 PERSON
WHERE (PERSON.KLIENTID=:KLIENTID)AND(Всякие фильтры)AND(всякие фильтры)
ORDER BY название поля