forbitdata.out

derby database source code.good for you.

START testNegative
CREATE TABLE FBDFAIL.T001 (C001 CHAR(255) FOR BIT DATA)
EXPECTED SQL Exception: (42611) The length, precision, or scale attribute for column, or type mapping 'CHAR (255) FOR BIT DATA' is not valid. 
CREATE TABLE FBDFAIL.T002 (C002 VARCHAR(32673) FOR BIT DATA)
EXPECTED SQL Exception: (42611) The length, precision, or scale attribute for column, or type mapping 'VARCHAR (32673) FOR BIT DATA' is not valid. 
CREATE TABLE FBDFAIL.T003 (C003 VARCHAR FOR BIT DATA)
EXPECTED SQL Exception: (42X01) Syntax error: Encountered "FOR" at line 1, column 41.
CREATE TABLE FBDFAIL.T004 (C004 LONG VARCHAR(100) FOR BIT DATA)
EXPECTED SQL Exception: (42X01) Syntax error: Encountered "(" at line 1, column 45.
END testNegative
START testTypes
CREATE TABLE FBDOK.T001 (C001 CHAR FOR BIT DATA)
CREATE TABLE FBDOK.T002 (C002 CHAR(1) FOR BIT DATA)
CREATE TABLE FBDOK.T003 (C003 CHAR(10) FOR BIT DATA)
CREATE TABLE FBDOK.T004 (C004 CHAR(254) FOR BIT DATA)
CREATE TABLE FBDOK.T005 (C005 VARCHAR(1) FOR BIT DATA)
CREATE TABLE FBDOK.T006 (C006 VARCHAR(100) FOR BIT DATA)
CREATE TABLE FBDOK.T007 (C007 VARCHAR(32672) FOR BIT DATA)
CREATE TABLE FBDOK.T008 (C008 LONG VARCHAR FOR BIT DATA)
FBDOK,T001,C001,-2,CHAR () FOR BIT DATA,1,null,null,1,null,null,1,YES
FBDOK,T002,C002,-2,CHAR () FOR BIT DATA,1,null,null,1,null,null,1,YES
FBDOK,T003,C003,-2,CHAR () FOR BIT DATA,10,null,null,1,null,null,1,YES
FBDOK,T004,C004,-2,CHAR () FOR BIT DATA,254,null,null,1,null,null,1,YES
FBDOK,T005,C005,-3,VARCHAR () FOR BIT DATA,1,null,null,1,null,null,1,YES
FBDOK,T006,C006,-3,VARCHAR () FOR BIT DATA,100,null,null,1,null,null,1,YES
FBDOK,T007,C007,-3,VARCHAR () FOR BIT DATA,32672,null,null,1,null,null,1,YES
FBDOK,T008,C008,-4,LONG VARCHAR FOR BIT DATA,32700,null,null,1,null,null,1,YES
TABLE FBDOK.T001
  C001 CHAR () FOR BIT DATA precision 1
TABLE FBDOK.T002
  C002 CHAR () FOR BIT DATA precision 1
TABLE FBDOK.T003
  C003 CHAR () FOR BIT DATA precision 10
TABLE FBDOK.T004
  C004 CHAR () FOR BIT DATA precision 254
TABLE FBDOK.T005
  C005 VARCHAR () FOR BIT DATA precision 1
TABLE FBDOK.T006
  C006 VARCHAR () FOR BIT DATA precision 100
TABLE FBDOK.T007
  C007 VARCHAR () FOR BIT DATA precision 32672
TABLE FBDOK.T008
  C008 LONG VARCHAR FOR BIT DATA precision 32700
DATABASE META DATA.getTypeInfo()
LONG VARCHAR FOR BIT DATA(-4) precision 32700
VARCHAR () FOR BIT DATA(-3) precision 32762
CHAR () FOR BIT DATA(-2) precision 254
VALUES X'2345d45a2e44'
  1 CHAR () FOR BIT DATA precision 6
VALUES X''
  1 CHAR () FOR BIT DATA precision 0
END testTypes
START testValues
**** NULL
  ORG <NULL> CHR <NULL> VAR <NULL> LVC <NULL> BLOB <NULL> 
  ORG <NULL> CHR <NULL> VAR <NULL> LVC <NULL> BLOB <NULL> 
**** 7 bytes (EMPTY)
  ORG 00000000000000 (7) CHR 00000000000000202020 (10) VAR 00000000000000 (7) LVC 00000000000000 (7) BLOB 00000000000000 (7) 
  ORG 00000000000000 (7) CHR 00000000000000202020 (10) VAR 00000000000000 (7) LVC 00000000000000 (7) BLOB 00000000000000 (7) 
**** 15 bytes (EMPTY)
  >> CHAR FOR BIT DATA
22001 truncation error
22001 truncation error
  >> VARCHAR FOR BIT DATA
22001 truncation error
22001 truncation error
  >> LONG VARCHAR FOR BIT DATA
  >> BLOB
22001 truncation error
22001 truncation error
  ORG 000000000000000000000000000000 (15) CHR <NULL> VAR <NULL> LVC 000000000000000000000000000000 (15) BLOB <NULL> 
  ORG 000000000000000000000000000000 (15) CHR <NULL> VAR <NULL> LVC 000000000000000000000000000000 (15) BLOB <NULL> 
**** 4 bytes
  ORG 0423a2fd (4) CHR 0423a2fd202020202020 (10) VAR 0423a2fd (4) LVC 0423a2fd (4) BLOB 0423a2fd (4) 
  ORG 0423a2fd (4) CHR 0423a2fd202020202020 (10) VAR 0423a2fd (4) LVC 0423a2fd (4) BLOB 0423a2fd (4) 
**** 10 bytes
  ORG 0b27a2fd016de2356690 (10) CHR 0b27a2fd016de2356690 (10) VAR 0b27a2fd016de2356690 (10) LVC 0b27a2fd016de2356690 (10) BLOB 0b27a2fd016de2356690 (10) 
  ORG 0b27a2fd016de2356690 (10) CHR 0b27a2fd016de2356690 (10) VAR 0b27a2fd016de2356690 (10) LVC 0b27a2fd016de2356690 (10) BLOB 0b27a2fd016de2356690 (10) 
**** 15 bytes
  >> CHAR FOR BIT DATA
22001 truncation error
22001 truncation error
  >> VARCHAR FOR BIT DATA
22001 truncation error
22001 truncation error
  >> LONG VARCHAR FOR BIT DATA
  >> BLOB
22001 truncation error
22001 truncation error
  ORG ebcafebabefeedface24784392316d (15) CHR <NULL> VAR <NULL> LVC ebcafebabefeedface24784392316d (15) BLOB <NULL> 
  ORG ebcafebabefeedface24784392316d (15) CHR <NULL> VAR <NULL> LVC ebcafebabefeedface24784392316d (15) BLOB <NULL> 
**** 4 spaces 
  ORG 20202020 (4) CHR 20202020202020202020 (10) VAR 20202020 (4) LVC 20202020 (4) BLOB 20202020 (4) 
  ORG 20202020 (4) CHR 20202020202020202020 (10) VAR 20202020 (4) LVC 20202020 (4) BLOB 20202020 (4) 
**** 6 data with trailing space 
  ORG cafe20202020 (6) CHR cafe2020202020202020 (10) VAR cafe20202020 (6) LVC cafe20202020 (6) BLOB cafe20202020 (6) 
  ORG cafe20202020 (6) CHR cafe2020202020202020 (10) VAR cafe20202020 (6) LVC cafe20202020 (6) BLOB cafe20202020 (6) 
**** 12 data with trailing space 
  >> CHAR FOR BIT DATA
22001 truncation error
22001 truncation error
  >> VARCHAR FOR BIT DATA
22001 truncation error
22001 truncation error
  >> LONG VARCHAR FOR BIT DATA
  >> BLOB
22001 truncation error
22001 truncation error
  ORG cafe20202020cafe20202020 (12) CHR <NULL> VAR <NULL> LVC cafe20202020cafe20202020 (12) BLOB <NULL> 
  ORG cafe20202020cafe20202020 (12) CHR <NULL> VAR <NULL> LVC cafe20202020cafe20202020 (12) BLOB <NULL> 
**** INSERT INTO FBDVAL.T001 VALUES(80, X'2020202020', X'2020202020', X'2020202020', null)
  ORG 20202020 (4) CHR 20202020202020202020 (10) VAR 2020202020 (5) LVC 2020202020 (5) BLOB <NULL> 
**** INSERT INTO FBDVAL.T001 VALUES(90, X'CAFE20202020CAFE20202020', null, null, null)
  ORG cafe20202020cafe20202020 (12) CHR cafe20202020cafe2020 (10) VAR <NULL> LVC <NULL> BLOB <NULL> 
**** INSERT INTO FBDVAL.T001 VALUES(100, null, X'CAFE20202020CAFE20202020', null, null)
  ORG cafe20202020cafe20202020 (12) CHR <NULL> VAR cafe20202020cafe2020 (10) LVC <NULL> BLOB <NULL> 
**** INSERT INTO FBDVAL.T001 VALUES(110, null, null, X'CAFE20202020CAFE20202020', null)
  ORG cafe20202020cafe20202020 (12) CHR <NULL> VAR <NULL> LVC cafe20202020cafe20202020 (12) BLOB <NULL> 
**** INSERT INTO FBDVAL.T001 VALUES(120, X'CAFE20202020CAFE20202020DD', null, null, null)
22001 truncation error
**** INSERT INTO FBDVAL.T001 VALUES(130, null, X'CAFE20202020CAFE20202020DD', null, null)
22001 truncation error
**** INSERT INTO FBDVAL.T001 VALUES(140, null, null, X'CAFE20202020CAFE20202020DD', null)
  ORG cafe20202020cafe20202020 (12) CHR <NULL> VAR <NULL> LVC cafe20202020cafe20202020dd (13) BLOB <NULL> 
**** INSERT INTO FBDVAL.X001 VALUES(200, X'CAFE20202020CAFE20202020', null, null, null)
**** INSERT INTO FBDVAL.T001 SELECT * FROM FBDVAL.X001
  ORG cafe20202020cafe20202020 (12) CHR cafe20202020cafe2020 (10) VAR <NULL> LVC <NULL> BLOB <NULL> 
END testValues
START testCompare
SELECT T.ID, T.C1, O.ID, O.C1 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C1 = O.C1 ORDER BY 1,3
  30 0423a2fd202020202020 (10)   30 0423a2fd202020202020 (10) 
  30 0423a2fd202020202020 (10)   60 0423a2fd202020202020 (10) 
  40 0423a1fd202020202020 (10)   40 0423a1fd202020202020 (10) 
  50 0423a2ff202020202020 (10)   50 0423a2ff202020202020 (10) 
  60 0423a2fd202020202020 (10)   30 0423a2fd202020202020 (10) 
  60 0423a2fd202020202020 (10)   60 0423a2fd202020202020 (10) 
  70 0b27a2fd016de2356690 (10)   70 0b27a2fd016de2356690 (10) 
SELECT T.ID, T.C1, O.ID, O.C1 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C1 <> O.C1 ORDER BY 1,3
  30 0423a2fd202020202020 (10)   40 0423a1fd202020202020 (10) 
  30 0423a2fd202020202020 (10)   50 0423a2ff202020202020 (10) 
  30 0423a2fd202020202020 (10)   70 0b27a2fd016de2356690 (10) 
  40 0423a1fd202020202020 (10)   30 0423a2fd202020202020 (10) 
  40 0423a1fd202020202020 (10)   50 0423a2ff202020202020 (10) 
  40 0423a1fd202020202020 (10)   60 0423a2fd202020202020 (10) 
  40 0423a1fd202020202020 (10)   70 0b27a2fd016de2356690 (10) 
  50 0423a2ff202020202020 (10)   30 0423a2fd202020202020 (10) 
  50 0423a2ff202020202020 (10)   40 0423a1fd202020202020 (10) 
  50 0423a2ff202020202020 (10)   60 0423a2fd202020202020 (10) 
  50 0423a2ff202020202020 (10)   70 0b27a2fd016de2356690 (10) 
  60 0423a2fd202020202020 (10)   40 0423a1fd202020202020 (10) 
  60 0423a2fd202020202020 (10)   50 0423a2ff202020202020 (10) 
  60 0423a2fd202020202020 (10)   70 0b27a2fd016de2356690 (10) 
  70 0b27a2fd016de2356690 (10)   30 0423a2fd202020202020 (10) 
  70 0b27a2fd016de2356690 (10)   40 0423a1fd202020202020 (10) 
  70 0b27a2fd016de2356690 (10)   50 0423a2ff202020202020 (10) 
  70 0b27a2fd016de2356690 (10)   60 0423a2fd202020202020 (10) 
SELECT T.ID, T.C1, O.ID, O.C1 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C1 < O.C1 ORDER BY 1,3
  30 0423a2fd202020202020 (10)   50 0423a2ff202020202020 (10) 
  30 0423a2fd202020202020 (10)   70 0b27a2fd016de2356690 (10) 
  40 0423a1fd202020202020 (10)   30 0423a2fd202020202020 (10) 
  40 0423a1fd202020202020 (10)   50 0423a2ff202020202020 (10) 
  40 0423a1fd202020202020 (10)   60 0423a2fd202020202020 (10) 
  40 0423a1fd202020202020 (10)   70 0b27a2fd016de2356690 (10) 
  50 0423a2ff202020202020 (10)   70 0b27a2fd016de2356690 (10) 
  60 0423a2fd202020202020 (10)   50 0423a2ff202020202020 (10) 
  60 0423a2fd202020202020 (10)   70 0b27a2fd016de2356690 (10) 
SELECT T.ID, T.C1, O.ID, O.C1 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C1 <= O.C1 ORDER BY 1,3
  30 0423a2fd202020202020 (10)   30 0423a2fd202020202020 (10) 
  30 0423a2fd202020202020 (10)   50 0423a2ff202020202020 (10) 
  30 0423a2fd202020202020 (10)   60 0423a2fd202020202020 (10) 
  30 0423a2fd202020202020 (10)   70 0b27a2fd016de2356690 (10) 
  40 0423a1fd202020202020 (10)   30 0423a2fd202020202020 (10) 
  40 0423a1fd202020202020 (10)   40 0423a1fd202020202020 (10) 
  40 0423a1fd202020202020 (10)   50 0423a2ff202020202020 (10) 
  40 0423a1fd202020202020 (10)   60 0423a2fd202020202020 (10) 
  40 0423a1fd202020202020 (10)   70 0b27a2fd016de2356690 (10) 
  50 0423a2ff202020202020 (10)   50 0423a2ff202020202020 (10) 
  50 0423a2ff202020202020 (10)   70 0b27a2fd016de2356690 (10) 
  60 0423a2fd202020202020 (10)   30 0423a2fd202020202020 (10) 
  60 0423a2fd202020202020 (10)   50 0423a2ff202020202020 (10) 
  60 0423a2fd202020202020 (10)   60 0423a2fd202020202020 (10) 
  60 0423a2fd202020202020 (10)   70 0b27a2fd016de2356690 (10) 
  70 0b27a2fd016de2356690 (10)   70 0b27a2fd016de2356690 (10) 
SELECT T.ID, T.C1, O.ID, O.C1 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C1 > O.C1 ORDER BY 1,3
  30 0423a2fd202020202020 (10)   40 0423a1fd202020202020 (10) 
  50 0423a2ff202020202020 (10)   30 0423a2fd202020202020 (10) 
  50 0423a2ff202020202020 (10)   40 0423a1fd202020202020 (10) 
  50 0423a2ff202020202020 (10)   60 0423a2fd202020202020 (10) 
  60 0423a2fd202020202020 (10)   40 0423a1fd202020202020 (10) 
  70 0b27a2fd016de2356690 (10)   30 0423a2fd202020202020 (10) 
  70 0b27a2fd016de2356690 (10)   40 0423a1fd202020202020 (10) 
  70 0b27a2fd016de2356690 (10)   50 0423a2ff202020202020 (10) 
  70 0b27a2fd016de2356690 (10)   60 0423a2fd202020202020 (10) 
SELECT T.ID, T.C1, O.ID, O.C1 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C1 >= O.C1 ORDER BY 1,3
  30 0423a2fd202020202020 (10)   30 0423a2fd202020202020 (10) 
  30 0423a2fd202020202020 (10)   40 0423a1fd202020202020 (10) 
  30 0423a2fd202020202020 (10)   60 0423a2fd202020202020 (10) 
  40 0423a1fd202020202020 (10)   40 0423a1fd202020202020 (10) 
  50 0423a2ff202020202020 (10)   30 0423a2fd202020202020 (10) 
  50 0423a2ff202020202020 (10)   40 0423a1fd202020202020 (10) 
  50 0423a2ff202020202020 (10)   50 0423a2ff202020202020 (10) 
  50 0423a2ff202020202020 (10)   60 0423a2fd202020202020 (10) 
  60 0423a2fd202020202020 (10)   30 0423a2fd202020202020 (10) 
  60 0423a2fd202020202020 (10)   40 0423a1fd202020202020 (10) 
  60 0423a2fd202020202020 (10)   60 0423a2fd202020202020 (10) 
  70 0b27a2fd016de2356690 (10)   30 0423a2fd202020202020 (10) 
  70 0b27a2fd016de2356690 (10)   40 0423a1fd202020202020 (10) 
  70 0b27a2fd016de2356690 (10)   50 0423a2ff202020202020 (10) 
  70 0b27a2fd016de2356690 (10)   60 0423a2fd202020202020 (10) 
  70 0b27a2fd016de2356690 (10)   70 0b27a2fd016de2356690 (10) 
SELECT T.ID, T.C1, O.ID, O.C2 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C1 = O.C2 ORDER BY 1,3
  30 0423a2fd202020202020 (10)   30 0423a2fd (4) 
  30 0423a2fd202020202020 (10)   60 0423a2fd20 (5) 
  40 0423a1fd202020202020 (10)   40 0423a1fd (4) 
  50 0423a2ff202020202020 (10)   50 0423a2ff (4) 
  60 0423a2fd202020202020 (10)   30 0423a2fd (4) 
  60 0423a2fd202020202020 (10)   60 0423a2fd20 (5) 
  70 0b27a2fd016de2356690 (10)   70 0b27a2fd016de2356690 (10) 
SELECT T.ID, T.C1, O.ID, O.C2 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C1 <> O.C2 ORDER BY 1,3
  30 0423a2fd202020202020 (10)   40 0423a1fd (4) 
  30 0423a2fd202020202020 (10)   50 0423a2ff (4)