Subject | IB_SQL Metadata-extract issues false warning for DbKey_Length |
---|---|
Author | Frank Emser |
Post date | 2003-07-01T15:27:55Z |
IB_SQL, Extract Metadata SQL, issues false warning.
After extracting the metadata, for views,
IB_SQL warns (on FB1.5,Rc3,Dialect3):
View.T2_VYS_TEST_VERRECHNETE: DbKey_Length should be 8 but is 32
but according to the fb developers, 32 is correct ?
=====================================================================
============== TEST CASE T2_VYS_TEST_VERRECHNETE ===================
=====================================================================
CREATE TABLE T2_STKD (
INTROWID INTEGER NOT NULL,
NAME VARCHAR(45) NOT NULL);
CREATE TABLE T2_BWLS (
INTROWID INTEGER NOT NULL,
TOUR INTEGER NOT NULL,
KUNDE INTEGER NOT NULL,
DATUM DATE NOT NULL,
LIEFERSCHEINLAUF INTEGER NOT NULL);
CREATE TABLE T2_BWLL (
INTROWID INTEGER NOT NULL,
TOURFOLGE INTEGER NOT NULL,
DATUM DATE,
KENNUNG VARCHAR(45) NOT NULL );
CREATE TABLE T2_FBTR (
INTROWID INTEGER NOT NULL,
NAME VARCHAR(45) NOT NULL );
CREATE VIEW T2_VXBWLS (
NR,
DATUM,
KUNDE,
KUNDE_NR,
LIEFERSCHEINLAUF_DATUM,
LIEFERSCHEINLAUF,
TOUR,
ZZZINTERNALID )
AS
SELECT
MainTbl.IntRowId
, MainTbl.Datum
, StKd299.Name
, StKd299.IntRowId
, BwLl1106.Datum
, BwLl1106.Kennung
, FbTr298.Name
, MainTbl.IntRowId
FROM ((( T2_BwLs MainTbl
LEFT OUTER JOIN T2_StKd StKd299
ON MainTbl.Kunde = StKd299.IntRowId)
LEFT OUTER JOIN T2_BwLl BwLl1106
ON MainTbl.Lieferscheinlauf = BwLl1106.IntRowId)
LEFT OUTER JOIN T2_FbTr FbTr298
ON MainTbl.Tour = FbTr298.IntRowId);
CREATE VIEW T2_VYS_TEST_VERRECHNETE
AS
/* === Kern - Source */
/* START */
SELECT
T2_VxBwLs.Nr,
T2_VxBwLs.Datum,
T2_VxBwLs.Kunde,
T2_VxBwLs.Kunde_Nr,
T2_VxBwLs.Lieferscheinlauf_Datum,
T2_VxBwLs.Lieferscheinlauf,
T2_VxBwLs.Tour,
T2_VxBwLs.zzzInternalId
FROM T2_VxBwLs;
=====================================================================
==END========= TEST CASE T2_VYS_TEST_VERRECHNETE ===========END=====
=====================================================================
After extracting the metadata, for views,
IB_SQL warns (on FB1.5,Rc3,Dialect3):
View.T2_VYS_TEST_VERRECHNETE: DbKey_Length should be 8 but is 32
but according to the fb developers, 32 is correct ?
=====================================================================
============== TEST CASE T2_VYS_TEST_VERRECHNETE ===================
=====================================================================
CREATE TABLE T2_STKD (
INTROWID INTEGER NOT NULL,
NAME VARCHAR(45) NOT NULL);
CREATE TABLE T2_BWLS (
INTROWID INTEGER NOT NULL,
TOUR INTEGER NOT NULL,
KUNDE INTEGER NOT NULL,
DATUM DATE NOT NULL,
LIEFERSCHEINLAUF INTEGER NOT NULL);
CREATE TABLE T2_BWLL (
INTROWID INTEGER NOT NULL,
TOURFOLGE INTEGER NOT NULL,
DATUM DATE,
KENNUNG VARCHAR(45) NOT NULL );
CREATE TABLE T2_FBTR (
INTROWID INTEGER NOT NULL,
NAME VARCHAR(45) NOT NULL );
CREATE VIEW T2_VXBWLS (
NR,
DATUM,
KUNDE,
KUNDE_NR,
LIEFERSCHEINLAUF_DATUM,
LIEFERSCHEINLAUF,
TOUR,
ZZZINTERNALID )
AS
SELECT
MainTbl.IntRowId
, MainTbl.Datum
, StKd299.Name
, StKd299.IntRowId
, BwLl1106.Datum
, BwLl1106.Kennung
, FbTr298.Name
, MainTbl.IntRowId
FROM ((( T2_BwLs MainTbl
LEFT OUTER JOIN T2_StKd StKd299
ON MainTbl.Kunde = StKd299.IntRowId)
LEFT OUTER JOIN T2_BwLl BwLl1106
ON MainTbl.Lieferscheinlauf = BwLl1106.IntRowId)
LEFT OUTER JOIN T2_FbTr FbTr298
ON MainTbl.Tour = FbTr298.IntRowId);
CREATE VIEW T2_VYS_TEST_VERRECHNETE
AS
/* === Kern - Source */
/* START */
SELECT
T2_VxBwLs.Nr,
T2_VxBwLs.Datum,
T2_VxBwLs.Kunde,
T2_VxBwLs.Kunde_Nr,
T2_VxBwLs.Lieferscheinlauf_Datum,
T2_VxBwLs.Lieferscheinlauf,
T2_VxBwLs.Tour,
T2_VxBwLs.zzzInternalId
FROM T2_VxBwLs;
=====================================================================
==END========= TEST CASE T2_VYS_TEST_VERRECHNETE ===========END=====
=====================================================================