SQLite Forum

Timeline
Login

12 forum posts by user bjoern

2021-06-14
00:08 Reply: Bug: ALTER TABLE RENAME COLUM TO vs CTE VIEWs (artifact: f8a2df559c user: bjoern)

In PostgreSQL 9.6 the ALTER TABLE statement succeeds and the VIEW is transformed into:

WITH
n AS ( SELECT t0.col2 AS col1 FROM t0 ),
o AS ( SELECT n.col1 FROM n )
SELECT o.col1 FROM o

For that matter,

CREATE TABLE t0 AS SELECT 1 AS col1;
CREATE VIEW v0 AS SELECT col1 FROM t0;
ALTER TABLE t0 RENAME COLUMN col1 TO col2;
SELECT col1 FROM v0; -- Works in PostgreSQL

This seems an unfortunate difference between PostgreSQL and SQLite. It would be nice if this was made clearer in the documentation and had a better error message.

2021-06-12
23:48 Post: Doc: Ā»generalized ALTER TABLE procedureĀ« treatment of VIEWs (artifact: 706bbd839c user: bjoern)

In https://sqlite.org/lang_altertable.html#otheralter Step 3 is:

Remember the format of all indexes, triggers, and views associated with table X. This information will be needed in step 8 below. One way to do this is to run a query like the following: SELECT type, sql FROM sqlite_schema WHERE tbl_name='X'.

The suggested query does not actually identify the relevant VIEWs, and this fails to mention that the VIEWs (and probably the other objects aswell) have to be dropped, otherwise the ALTER TABLE in Step 7 will fail, since the referenced table is dropped in Step 6.

Steps 8 and 9 are:

Use CREATE INDEX, CREATE TRIGGER, and CREATE VIEW to reconstruct indexes, triggers, and views associated with table X. Perhaps use the old format of the triggers, indexes, and views saved from step 3 above as a guide, making changes as appropriate for the alteration.

If any views refer to table X in a way that is affected by the schema change, then drop those views using DROP VIEW and recreate them with whatever changes are necessary to accommodate the schema change using CREATE VIEW.

Given that VIEWs have to be dropped in Step 3 and are re-created with the appropriate changes in Step 8, it seems that Step 9 is redundant.

Context:

% sqlite
-- Loading resources from /home/bjoern/.sqliterc
SQLite version 3.36.0 2021-06-11 13:18:56
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> savepoint s;
sqlite> create table t as select 1 as col;
sqlite> create view v as select * from t, missing;
sqlite> alter table t rename to u;
(1) statement aborts at 26: [alter table t rename to u;] error in view v: no such table: main.missing
Error: error in view v: no such table: main.missing
22:49 Post: Bug: ALTER TABLE RENAME COLUM TO vs CTE VIEWs (artifact: f697890752 user: bjoern)

Similar to https://sqlite.org/forum/forumpost/04f72b274e but with RENAME COLUMN and after the changes there. Test case:

SELECT sqlite_source_id();

CREATE TABLE t0 AS SELECT 1 AS col1;

CREATE VIEW v0 AS
  WITH
  n AS (
    SELECT
      t0.col1
    FROM
      t0 
  ),
  o AS (
    SELECT
      col1
    FROM
      n
  )
  SELECT * FROM o
;

SELECT * FROM v0;

ALTER TABLE t0 RENAME COLUMN col1 TO col2;
% sqlite < sqlite-bug-rename-column
sqlite_source_id()                                                                  
------------------------------------------------------------------------------------
2021-06-11 13:18:56 230fedd923c87741d20caf55f29e8464cc6df344536f9b89331e0a0059a926f7
Run Time: real 0.000 user 0.000211 sys 0.000000
Run Time: real 0.001 user 0.000624 sys 0.000000
Run Time: real 0.000 user 0.000379 sys 0.000000
col1
----
1   
Run Time: real 0.000 user 0.000187 sys 0.000000
(1) statement aborts at 157: [ALTER TABLE t0 RENAME COLUMN col1 TO col2;] error in view v0 after rename: no such column: col1
Run Time: real 0.003 user 0.000000 sys 0.003209
Error: near line 24: error in view v0 after rename: no such column: col1
14:34 Post: Bug: `GENERATED ALWAYS` constraint ends up in column type (artifact: ff3ffe0925 user: bjoern)

Some of the tokens forming a GENERATED ALWAYS column constraint sometimes end up in the column type. I think this is inconsistent with the syntax diagrams (when these tokens are interpreted as type-name they cannot also be interpreted as constraint syntax) and internally inconsistent (e.g., this happens with anonymous column constraints, but does not happen if the column constraint is named):

sqlite> create table t1(id int, x int generated always as (true));
sqlite> create view v1 as select * from t1;
sqlite> create table t2(id int, x int constraint c generated always as (true));
sqlite> create view v2 as select * from t2;
sqlite> select * from PRAGMA_TABLE_XINFO('t1');
cid  name  type                  notnull  dflt_value  pk  hidden
---  ----  --------------------  -------  ----------  --  ------
0    id    int                   0                    0   0     
1    x     int generated always  0                    0   2     
sqlite> select * from PRAGMA_TABLE_XINFO('t2');
cid  name  type  notnull  dflt_value  pk  hidden
---  ----  ----  -------  ----------  --  ------
0    id    int   0                    0   0     
1    x     int   0                    0   2     
2021-06-11
19:34 Reply: Bug: ALTER TABLE RENAME TO vs CTE VIEWs / multiple references (artifact: 04f72b274e user: bjoern)
2021-06-10
23:13 Reply: json_contains Function Idea (artifact: 29c15b0d40 user: bjoern)

I needed something like this a few days ago and implemented it using the https://github.com/0x09/sqlite-statement-vtab extension:

    DROP TABLE IF EXISTS JSON_SET_CONTAINS;
    CREATE VIRTUAL TABLE JSON_SET_CONTAINS USING statement((
      SELECT
        -- TODO: Should JSON_SET_CONTAINS(NULL, ...) return NULL?
        EXISTS(
          SELECT 1 FROM JSON_EACH(?1) each WHERE each.value = ?2
        ) AS value
    ))
    ;
sqlite> select value from json_set_contains('[3,2,1]', 2);
value
-----
1    
Run Time: real 0.000 user 0.000759 sys 0.000000

(My arrays are ordered and contain no duplicate values to make equivalence testing easy, hence the set in the name.)

20:11 Reply: Feature request: Stored Procedures (artifact: 28c03d56a1 user: bjoern)

https://github.com/0x09/sqlite-statement-vtab/ gives you essentially parameterized VIEWs (but with an optimization boundary).

2021-06-09
20:42 Post: Bug: ALTER TABLE RENAME TO vs CTE VIEWs / multiple references (artifact: 9d965f2956 user: bjoern)

SQLite seems to get confused when a CTE VIEW references a table multiple times when renaming that table:

% sqlite                                                                                                  
-- Loading resources from /home/bjoern/.sqliterc
SQLite version 3.35.4 2021-04-02 15:20:15
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> CREATE VIEW v0 AS
   ...> WITH
   ...> p AS (
   ...>   SELECT 1 FROM t1
   ...> ),
   ...> g AS (
   ...>   SELECT
   ...>     1
   ...>   FROM
   ...>     p, t1
   ...> )
   ...> SELECT
   ...>   1
   ...> FROM
   ...>   g
   ...> ;
Run Time: real 0.000 user 0.000417 sys 0.000139
sqlite> 
sqlite> create table t1(x);
Run Time: real 0.000 user 0.000277 sys 0.000000

sqlite> alter table t1 rename to t2;
(1) statement aborts at 119: [alter table t1 rename to t2;] error in view v0 after rename: no such table: main.t1
Run Time: real 0.001 user 0.001657 sys 0.000000
Error: error in view v0 after rename: no such table: main.t1

When I comment out the FROM g, the ALTER TABLE oddly succeeds, but fails to rename the second reference:

% sqlite
-- Loading resources from /home/bjoern/.sqliterc
SQLite version 3.35.4 2021-04-02 15:20:15
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> 
sqlite> CREATE VIEW v0 AS
   ...> WITH
   ...> p AS (
   ...>   SELECT 1 FROM t1
   ...> ),
   ...> g AS (
   ...>   SELECT
   ...>     1
   ...>   FROM
   ...>     p, t1
   ...> )
   ...> SELECT
   ...>   1
   ...> -- FROM
   ...> --   g
   ...> ;
Run Time: real 0.001 user 0.000000 sys 0.000697
sqlite> 

sqlite> create table t1(x);
Run Time: real 0.000 user 0.000000 sys 0.000231

sqlite> alter table t1 rename to t2;
Run Time: real 0.001 user 0.000018 sys 0.001597

sqlite> .schema v0
(1) invalid arguments to fts4aux constructor in "PRAGMA "main".table_info='fts4aux';"
(21) API called with NULL prepared statement
(21) misuse at line 84383 of [5d4c65779d]
CREATE VIEW v0 AS
WITH
p AS (
  SELECT 1 FROM "t2"
),
g AS (
  SELECT
    1
  FROM
    p, t1
)
SELECT
  1
-- FROM
--   g
/* v0("1
-- FROM
--   g") */;
2021-06-07
17:53 Edit: (Deleted) (artifact: acf1adc1f2 user: bjoern)
Deleted
17:53 Delete reply: (Deleted) (artifact: 14ed8c7879 user: bjoern)
Deleted
17:46 Reply: (Deleted) (artifact: 510a643126 user: bjoern)

Ah, did not realise during refactoring that the "table" now has a field with the name, and SQLite seemingly resolves names in GROUP BY by looking at the names through FROM before it considers names in SELECT (and does not complain about ambiguous names in that situation).

17:38 Post: (Deleted) (artifact: f521a30caa user: bjoern)
% sqlite BUG.sqlite
-- Loading resources from /home/bjoern/.sqliterc
SQLite version 3.35.4 2021-04-02 15:20:15
Enter ".help" for usage hints.
sqlite>     SELECT
   ...>       JSON('[6516,6611,7084,11,7199,7672]') AS goal_dc,
   ...>       o.state,
   ...>       JSON_GROUP_ARRAY(DISTINCT next.value) AS next_dc
   ...>     FROM
   ...>       JSON_EACH(JSON('[6516,6611,7084,11,7199,7672]')) goal
   ...>         INNER JOIN view_dc_dfa_options2 o ON o.goal_dc = goal.value
   ...>         INNER JOIN JSON_EACH(o.next_dc) next
   ...>     WHERE
   ...>       o.state > 2
   ...>     GROUP BY
   ...>       goal_dc,
   ...>       o.state
   ...> ;
goal_dc                        state  next_dc                                  
-----------------------------  -----  -----------------------------------------
[6516,6611,7084,11,7199,7672]  3      [12,7,7859,7915,8116,9979,8242,9615]     
[6516,6611,7084,11,7199,7672]  53     [6241,7,12,7859,7915,8116,9958,8242,9917]
[6516,6611,7084,11,7199,7672]  225    [6516,6611,7084]                         
[6516,6611,7084,11,7199,7672]  442    [6516,6611,7084]                         
[6516,6611,7084,11,7199,7672]  573    [6516,6611,7084]                         
[6516,6611,7084,11,7199,7672]  10     [6516]                                   
[6516,6611,7084,11,7199,7672]  27     [6516]                                   
[6516,6611,7084,11,7199,7672]  225    [11,7199,7672]                           
[6516,6611,7084,11,7199,7672]  442    [11,7199,7672]                           
[6516,6611,7084,11,7199,7672]  573    [11,7199,7672]                           
[6516,6611,7084,11,7199,7672]  10     [11]                                     
[6516,6611,7084,11,7199,7672]  27     [11]                                     
Run Time: real 0.002 user 0.000459 sys 0.001379

There should only be one row for each unique goal_dc,state pair. Using the literal value instead of the alias name gives the desired result:

sqlite>     SELECT
   ...>       JSON('[6516,6611,7084,11,7199,7672]') AS goal_dc,
   ...>       o.state,
   ...>       JSON_GROUP_ARRAY(DISTINCT next.value) AS next_dc
   ...>     FROM
   ...>       JSON_EACH(JSON('[6516,6611,7084,11,7199,7672]')) goal
   ...>         INNER JOIN view_dc_dfa_options2 o ON o.goal_dc = goal.value
   ...>         INNER JOIN JSON_EACH(o.next_dc) next
   ...>     WHERE
   ...>       o.state > 2
   ...>     GROUP BY
   ...>       JSON('[6516,6611,7084,11,7199,7672]'),
   ...>       o.state
   ...> ;
goal_dc                        state  next_dc                                  
-----------------------------  -----  -----------------------------------------
[6516,6611,7084,11,7199,7672]  3      [12,7,7859,7915,8116,9979,8242,9615]     
[6516,6611,7084,11,7199,7672]  10     [6516,11]                                
[6516,6611,7084,11,7199,7672]  27     [6516,11]                                
[6516,6611,7084,11,7199,7672]  53     [6241,7,12,7859,7915,8116,9958,8242,9917]
[6516,6611,7084,11,7199,7672]  225    [6516,6611,7084,11,7199,7672]            
[6516,6611,7084,11,7199,7672]  442    [6516,6611,7084,11,7199,7672]            
[6516,6611,7084,11,7199,7672]  573    [6516,6611,7084,11,7199,7672]            
Run Time: real 0.001 user 0.001523 sys 0.000000
sqlite> 

Data:

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE view_dc_dfa_options2(
  goal_dc INT,
  state,
  next_dc
);
INSERT INTO view_dc_dfa_options2 VALUES(1,2,'[7,49,546,822,552]');
INSERT INTO view_dc_dfa_options2 VALUES(3,2,'[8458,3,5,8571]');
INSERT INTO view_dc_dfa_options2 VALUES(4,11,'[8821,8768,3924,4,6,8676,8595,8588,8617,8669,8698]');
INSERT INTO view_dc_dfa_options2 VALUES(5,2,'[8458,3,5,8648]');
INSERT INTO view_dc_dfa_options2 VALUES(6,11,'[8821,8768,3924,4,6,8676,8595,8588,8617,8669,8698]');
INSERT INTO view_dc_dfa_options2 VALUES(7,54,'[6516,6611,7084,11,7199,7672]');
INSERT INTO view_dc_dfa_options2 VALUES(7,55,'[6516,6611,7084,11,7199,7672]');
INSERT INTO view_dc_dfa_options2 VALUES(7,56,'[6516,6611,7084,11,7199,7672]');
INSERT INTO view_dc_dfa_options2 VALUES(7,112,'[6516,6611,7084,11,7199,7672]');
INSERT INTO view_dc_dfa_options2 VALUES(7,113,'[6516,6611,7084,11,7199,7672]');
INSERT INTO view_dc_dfa_options2 VALUES(7,114,'[6516,6611,7084,11,7199,7672]');
INSERT INTO view_dc_dfa_options2 VALUES(7,115,'[6516,6611,7084,11,7199,7672]');
INSERT INTO view_dc_dfa_options2 VALUES(7,116,'[6516,6611,7084,11,7199,7672]');
INSERT INTO view_dc_dfa_options2 VALUES(7,117,'[6516,6611,7084,11,7199,7672]');
INSERT INTO view_dc_dfa_options2 VALUES(8,2,'[6241,7,12,7859,7915,8116,9958,8242,9917]');
INSERT INTO view_dc_dfa_options2 VALUES(11,3,'[12,7,7859,7915,8116,9979,8242,9615]');
INSERT INTO view_dc_dfa_options2 VALUES(12,169,'[6241,7,12,7859,7915,8116,9958,8242,9917]');
INSERT INTO view_dc_dfa_options2 VALUES(17,2,'[8458,5,3]');
INSERT INTO view_dc_dfa_options2 VALUES(18,2,'[4,6,8676,8595,8588,8617,8669,8698]');
INSERT INTO view_dc_dfa_options2 VALUES(40,2,'[7]');
INSERT INTO view_dc_dfa_options2 VALUES(49,639,'[50,219,361,527]');
INSERT INTO view_dc_dfa_options2 VALUES(50,40,'[7,546,822,552]');
INSERT INTO view_dc_dfa_options2 VALUES(219,442,'[50,361,527]');
INSERT INTO view_dc_dfa_options2 VALUES(361,573,'[50,527]');
INSERT INTO view_dc_dfa_options2 VALUES(527,10,'[50]');
INSERT INTO view_dc_dfa_options2 VALUES(527,27,'[50]');
INSERT INTO view_dc_dfa_options2 VALUES(546,2,'[552]');
INSERT INTO view_dc_dfa_options2 VALUES(546,108,'[614,750]');
INSERT INTO view_dc_dfa_options2 VALUES(546,109,'[614,750]');
INSERT INTO view_dc_dfa_options2 VALUES(546,110,'[614,750]');
INSERT INTO view_dc_dfa_options2 VALUES(546,111,'[614,750]');
INSERT INTO view_dc_dfa_options2 VALUES(546,122,'[614,750]');
INSERT INTO view_dc_dfa_options2 VALUES(546,159,'[614,750]');
INSERT INTO view_dc_dfa_options2 VALUES(546,160,'[614,750]');
INSERT INTO view_dc_dfa_options2 VALUES(546,161,'[614,750]');
INSERT INTO view_dc_dfa_options2 VALUES(546,162,'[614,750]');
INSERT INTO view_dc_dfa_options2 VALUES(546,163,'[614,750]');
INSERT INTO view_dc_dfa_options2 VALUES(546,164,'[614,750]');
INSERT INTO view_dc_dfa_options2 VALUES(546,165,'[614,750]');
INSERT INTO view_dc_dfa_options2 VALUES(546,177,'[614,750]');
INSERT INTO view_dc_dfa_options2 VALUES(546,282,'[546,822,7,552]');
INSERT INTO view_dc_dfa_options2 VALUES(547,2,'[7,546,822,552]');
INSERT INTO view_dc_dfa_options2 VALUES(551,2,'[546,822,7,552]');
INSERT INTO view_dc_dfa_options2 VALUES(552,2,'[546,822,7,552]');
INSERT INTO view_dc_dfa_options2 VALUES(614,40,'[546,822,7,552]');
INSERT INTO view_dc_dfa_options2 VALUES(748,2,'[750]');
INSERT INTO view_dc_dfa_options2 VALUES(749,2,'[9032,614,9047]');
INSERT INTO view_dc_dfa_options2 VALUES(750,2,'[9032,614,9047,750]');
INSERT INTO view_dc_dfa_options2 VALUES(822,392,'[823,1218,969,1201]');
INSERT INTO view_dc_dfa_options2 VALUES(822,393,'[823,1218,969,1201]');
INSERT INTO view_dc_dfa_options2 VALUES(822,394,'[823,1218,969,1201]');
INSERT INTO view_dc_dfa_options2 VALUES(822,426,'[823,1218,969,1201]');
INSERT INTO view_dc_dfa_options2 VALUES(822,427,'[823,1218,969,1201]');
INSERT INTO view_dc_dfa_options2 VALUES(822,428,'[823,1218,969,1201]');
INSERT INTO view_dc_dfa_options2 VALUES(822,429,'[823,1218,969,1201]');
INSERT INTO view_dc_dfa_options2 VALUES(822,430,'[823,1218,969,1201]');
INSERT INTO view_dc_dfa_options2 VALUES(822,431,'[823,1218,969,1201]');
INSERT INTO view_dc_dfa_options2 VALUES(823,3,'[7,5965,5971]');
INSERT INTO view_dc_dfa_options2 VALUES(969,368,'[823,1218,1201]');
INSERT INTO view_dc_dfa_options2 VALUES(969,459,'[823,1218,1201]');
INSERT INTO view_dc_dfa_options2 VALUES(1201,10,'[823,1218]');
INSERT INTO view_dc_dfa_options2 VALUES(1201,27,'[823,1218]');
INSERT INTO view_dc_dfa_options2 VALUES(1218,4,'[1229,5842,1222]');
INSERT INTO view_dc_dfa_options2 VALUES(1222,2,'[823,5951]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,108,'[1290,1426]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,109,'[1290,1426]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,110,'[1290,1426]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,111,'[1290,1426]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,122,'[1290,1426]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,159,'[1290,1426]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,160,'[1290,1426]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,161,'[1290,1426]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,162,'[1290,1426]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,163,'[1290,1426]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,164,'[1290,1426]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,165,'[1290,1426]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,177,'[1290,1426]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,282,'[1229,5842,1222]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,383,'[4066]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,384,'[4066]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,385,'[4066]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,387,'[4412,4554,5832]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,388,'[4412,4554,5832]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,389,'[4412,4554,5832]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,410,'[4066]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,411,'[4066]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,412,'[4066]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,413,'[4066]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,414,'[4066]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,415,'[4066]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,418,'[4412,4554,5832]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,419,'[4412,4554,5832]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,420,'[4412,4554,5832]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,421,'[4412,4554,5832]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,422,'[4412,4554,5832]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,423,'[4412,4554,5832]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,464,'[1229,5842,1222]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,553,'[1229,5842,1222]');
INSERT INTO view_dc_dfa_options2 VALUES(1229,666,'[1229,5842,1222]');
INSERT INTO view_dc_dfa_options2 VALUES(1230,2,'[1229,5842,1222]');
INSERT INTO view_dc_dfa_options2 VALUES(1290,40,'[1229,5842,1222]');
INSERT INTO view_dc_dfa_options2 VALUES(1424,2,'[1426]');
INSERT INTO view_dc_dfa_options2 VALUES(1425,2,'[9210,1290,9225]');
INSERT INTO view_dc_dfa_options2 VALUES(1426,2,'[9210,1290,9225,1426]');
INSERT INTO view_dc_dfa_options2 VALUES(3924,3,'[1229,5842,1222]');
INSERT INTO view_dc_dfa_options2 VALUES(3924,30,'[1229,5842,1222]');
INSERT INTO view_dc_dfa_options2 VALUES(4065,2,'[4363,4386,3,5,4098]');
INSERT INTO view_dc_dfa_options2 VALUES(4066,2,'[4363,4386,3,5,4098,4066]');
INSERT INTO view_dc_dfa_options2 VALUES(4075,2,'[3,5]');
INSERT INTO view_dc_dfa_options2 VALUES(4076,2,'[3924]');
INSERT INTO view_dc_dfa_options2 VALUES(4081,2,'[3]');
INSERT INTO view_dc_dfa_options2 VALUES(4082,2,'[8821,3924]');
INSERT INTO view_dc_dfa_options2 VALUES(4083,2,'[5]');
INSERT INTO view_dc_dfa_options2 VALUES(4084,2,'[8821,3924]');
INSERT INTO view_dc_dfa_options2 VALUES(4098,2,'[4128,4316,4119,4307]');
INSERT INTO view_dc_dfa_options2 VALUES(4099,2,'[3924]');
INSERT INTO view_dc_dfa_options2 VALUES(4119,10,'[4128]');
INSERT INTO view_dc_dfa_options2 VALUES(4119,27,'[4128]');
INSERT INTO view_dc_dfa_options2 VALUES(4128,243,'[4286,4180,4173,4277]');
INSERT INTO view_dc_dfa_options2 VALUES(4173,10,'[4180]');
INSERT INTO view_dc_dfa_options2 VALUES(4173,27,'[4180]');
INSERT INTO view_dc_dfa_options2 VALUES(4180,33,'[4286,4180,4173,4277]');
INSERT INTO view_dc_dfa_options2 VALUES(4180,34,'[4286,4180,4173,4277]');
INSERT INTO view_dc_dfa_options2 VALUES(4180,35,'[4286,4180,4173,4277]');
INSERT INTO view_dc_dfa_options2 VALUES(4180,77,'[4286,4180,4173,4277]');
INSERT INTO view_dc_dfa_options2 VALUES(4180,78,'[4286,4180,4173,4277]');
INSERT INTO view_dc_dfa_options2 VALUES(4180,79,'[4286,4180,4173,4277]');
INSERT INTO view_dc_dfa_options2 VALUES(4180,80,'[4286,4180,4173,4277]');
INSERT INTO view_dc_dfa_options2 VALUES(4180,81,'[4286,4180,4173,4277]');
INSERT INTO view_dc_dfa_options2 VALUES(4180,82,'[4286,4180,4173,4277]');
INSERT INTO view_dc_dfa_options2 VALUES(4277,10,'[4286]');
INSERT INTO view_dc_dfa_options2 VALUES(4277,27,'[4286]');
INSERT INTO view_dc_dfa_options2 VALUES(4286,11,'[3924]');
INSERT INTO view_dc_dfa_options2 VALUES(4307,10,'[4316]');
INSERT INTO view_dc_dfa_options2 VALUES(4307,27,'[4316]');
INSERT INTO view_dc_dfa_options2 VALUES(4316,277,'[3924]');
INSERT INTO view_dc_dfa_options2 VALUES(4316,317,'[3924]');
INSERT INTO view_dc_dfa_options2 VALUES(4363,83,'[8791]');
INSERT INTO view_dc_dfa_options2 VALUES(4386,15,'[8791]');
INSERT INTO view_dc_dfa_options2 VALUES(4412,3,'[1229,5842,1222]');
INSERT INTO view_dc_dfa_options2 VALUES(4554,197,'[4946,5041,5034,5110]');
INSERT INTO view_dc_dfa_options2 VALUES(4554,198,'[4946,5041,5034,5110]');
INSERT INTO view_dc_dfa_options2 VALUES(4554,199,'[4946,5041,5034,5110]');
INSERT INTO view_dc_dfa_options2 VALUES(4554,200,'[4946,5041,5034,5110]');
INSERT INTO view_dc_dfa_options2 VALUES(4554,201,'[4946,5041,5034,5110]');
INSERT INTO view_dc_dfa_options2 VALUES(4554,202,'[4946,5041,5034,5110]');
INSERT INTO view_dc_dfa_options2 VALUES(4554,204,'[4555]');
INSERT INTO view_dc_dfa_options2 VALUES(4554,320,'[4555]');
INSERT INTO view_dc_dfa_options2 VALUES(4554,321,'[4555]');
INSERT INTO view_dc_dfa_options2 VALUES(4554,345,'[4555]');
INSERT INTO view_dc_dfa_options2 VALUES(4554,488,'[4666,4838,4831,4935]');
INSERT INTO view_dc_dfa_options2 VALUES(4554,489,'[4666,4838,4831,4935]');
INSERT INTO view_dc_dfa_options2 VALUES(4554,490,'[4666,4838,4831,4935]');
INSERT INTO view_dc_dfa_options2 VALUES(4554,538,'[4666,4838,4831,4935]');
INSERT INTO view_dc_dfa_options2 VALUES(4554,539,'[4666,4838,4831,4935]');
INSERT INTO view_dc_dfa_options2 VALUES(4554,540,'[4666,4838,4831,4935]');
INSERT INTO view_dc_dfa_options2 VALUES(4554,541,'[4666,4838,4831,4935]');
INSERT INTO view_dc_dfa_options2 VALUES(4554,542,'[4666,4838,4831,4935]');
INSERT INTO view_dc_dfa_options2 VALUES(4554,543,'[4666,4838,4831,4935]');
INSERT INTO view_dc_dfa_options2 VALUES(4555,85,'[4412,4554,5832]');
INSERT INTO view_dc_dfa_options2 VALUES(4555,343,'[4412,4554,5832]');
INSERT INTO view_dc_dfa_options2 VALUES(4662,2,'[4555]');
INSERT INTO view_dc_dfa_options2 VALUES(4666,11,'[4555]');
INSERT INTO view_dc_dfa_options2 VALUES(4831,10,'[4838]');
INSERT INTO view_dc_dfa_options2 VALUES(4831,27,'[4838]');
INSERT INTO view_dc_dfa_options2 VALUES(4838,33,'[4666,4838,4831,4935]');
INSERT INTO view_dc_dfa_options2 VALUES(4838,34,'[4666,4838,4831,4935]');
INSERT INTO view_dc_dfa_options2 VALUES(4838,35,'[4666,4838,4831,4935]');
INSERT INTO view_dc_dfa_options2 VALUES(4838,77,'[4666,4838,4831,4935]');
INSERT INTO view_dc_dfa_options2 VALUES(4838,78,'[4666,4838,4831,4935]');
INSERT INTO view_dc_dfa_options2 VALUES(4838,79,'[4666,4838,4831,4935]');
INSERT INTO view_dc_dfa_options2 VALUES(4838,80,'[4666,4838,4831,4935]');
INSERT INTO view_dc_dfa_options2 VALUES(4838,81,'[4666,4838,4831,4935]');
INSERT INTO view_dc_dfa_options2 VALUES(4838,82,'[4666,4838,4831,4935]');
INSERT INTO view_dc_dfa_options2 VALUES(4935,10,'[4666]');
INSERT INTO view_dc_dfa_options2 VALUES(4935,27,'[4666]');
INSERT INTO view_dc_dfa_options2 VALUES(4946,11,'[4555]');
INSERT INTO view_dc_dfa_options2 VALUES(5034,10,'[5041]');
INSERT INTO view_dc_dfa_options2 VALUES(5034,27,'[5041]');
INSERT INTO view_dc_dfa_options2 VALUES(5041,33,'[4946,5041,5034,5110]');
INSERT INTO view_dc_dfa_options2 VALUES(5041,34,'[4946,5041,5034,5110]');
INSERT INTO view_dc_dfa_options2 VALUES(5041,35,'[4946,5041,5034,5110]');
INSERT INTO view_dc_dfa_options2 VALUES(5041,41,'[4946,5041,5034,5110]');
INSERT INTO view_dc_dfa_options2 VALUES(5041,42,'[4946,5041,5034,5110]');
INSERT INTO view_dc_dfa_options2 VALUES(5041,43,'[4946,5041,5034,5110]');
INSERT INTO view_dc_dfa_options2 VALUES(5041,44,'[4946,5041,5034,5110]');
INSERT INTO view_dc_dfa_options2 VALUES(5041,77,'[4946,5041,5034,5110]');
INSERT INTO view_dc_dfa_options2 VALUES(5041,78,'[4946,5041,5034,5110]');
INSERT INTO view_dc_dfa_options2 VALUES(5041,79,'[4946,5041,5034,5110]');
INSERT INTO view_dc_dfa_options2 VALUES(5041,80,'[4946,5041,5034,5110]');
INSERT INTO view_dc_dfa_options2 VALUES(5041,81,'[4946,5041,5034,5110]');
INSERT INTO view_dc_dfa_options2 VALUES(5041,82,'[4946,5041,5034,5110]');
INSERT INTO view_dc_dfa_options2 VALUES(5041,93,'[4946,5041,5034,5110]');
INSERT INTO view_dc_dfa_options2 VALUES(5041,94,'[4946,5041,5034,5110]');
INSERT INTO view_dc_dfa_options2 VALUES(5110,10,'[4946]');
INSERT INTO view_dc_dfa_options2 VALUES(5110,27,'[4946]');
INSERT INTO view_dc_dfa_options2 VALUES(5832,10,'[4412]');
INSERT INTO view_dc_dfa_options2 VALUES(5832,27,'[4412]');
INSERT INTO view_dc_dfa_options2 VALUES(5842,10,'[1229,5842,1222]');
INSERT INTO view_dc_dfa_options2 VALUES(5842,27,'[1229,5842,1222]');
INSERT INTO view_dc_dfa_options2 VALUES(5842,101,'[1229,5842,1222]');
INSERT INTO view_dc_dfa_options2 VALUES(5842,158,'[1229,5842,1222]');
INSERT INTO view_dc_dfa_options2 VALUES(5951,10,'[823]');
INSERT INTO view_dc_dfa_options2 VALUES(5951,27,'[823]');
INSERT INTO view_dc_dfa_options2 VALUES(5965,2,'[5971]');
INSERT INTO view_dc_dfa_options2 VALUES(5965,108,'[6033,6169]');
INSERT INTO view_dc_dfa_options2 VALUES(5965,109,'[6033,6169]');
INSERT INTO view_dc_dfa_options2 VALUES(5965,110,'[6033,6169]');
INSERT INTO view_dc_dfa_options2 VALUES(5965,111,'[6033,6169]');
INSERT INTO view_dc_dfa_options2 VALUES(5965,122,'[6033,6169]');
INSERT INTO view_dc_dfa_options2 VALUES(5965,159,'[6033,6169]');
INSERT INTO view_dc_dfa_options2 VALUES(5965,160,'[6033,6169]');
INSERT INTO view_dc_dfa_options2 VALUES(5965,161,'[6033,6169]');
INSERT INTO view_dc_dfa_options2 VALUES(5965,162,'[6033,6169]');
INSERT INTO view_dc_dfa_options2 VALUES(5965,163,'[6033,6169]');
INSERT INTO view_dc_dfa_options2 VALUES(5965,164,'[6033,6169]');
INSERT INTO view_dc_dfa_options2 VALUES(5965,165,'[6033,6169]');
INSERT INTO view_dc_dfa_options2 VALUES(5965,177,'[6033,6169]');
INSERT INTO view_dc_dfa_options2 VALUES(5965,282,'[5965,7,5971]');
INSERT INTO view_dc_dfa_options2 VALUES(5966,2,'[7,5965,5971]');
INSERT INTO view_dc_dfa_options2 VALUES(5970,2,'[5965,7,5971]');
INSERT INTO view_dc_dfa_options2 VALUES(5971,2,'[5965,7,5971]');
INSERT INTO view_dc_dfa_options2 VALUES(6033,40,'[5965,7,5971]');
INSERT INTO view_dc_dfa_options2 VALUES(6167,2,'[6169]');
INSERT INTO view_dc_dfa_options2 VALUES(6168,2,'[9388,6033,9403]');
INSERT INTO view_dc_dfa_options2 VALUES(6169,2,'[9388,6033,9403,6169]');
INSERT INTO view_dc_dfa_options2 VALUES(6235,2,'[7]');
INSERT INTO view_dc_dfa_options2 VALUES(6236,2,'[6241]');
INSERT INTO view_dc_dfa_options2 VALUES(6241,10,'[6241]');
INSERT INTO view_dc_dfa_options2 VALUES(6241,27,'[6241]');
INSERT INTO view_dc_dfa_options2 VALUES(6241,108,'[6309,6445]');
INSERT INTO view_dc_dfa_options2 VALUES(6241,109,'[6309,6445]');
INSERT INTO view_dc_dfa_options2 VALUES(6241,110,'[6309,6445]');
INSERT INTO view_dc_dfa_options2 VALUES(6241,111,'[6309,6445]');
INSERT INTO view_dc_dfa_options2 VALUES(6241,122,'[6309,6445]');
INSERT INTO view_dc_dfa_options2 VALUES(6241,159,'[6309,6445]');
INSERT INTO view_dc_dfa_options2 VALUES(6241,160,'[6309,6445]');
INSERT INTO view_dc_dfa_options2 VALUES(6241,161,'[6309,6445]');
INSERT INTO view_dc_dfa_options2 VALUES(6241,162,'[6309,6445]');
INSERT INTO view_dc_dfa_options2 VALUES(6241,163,'[6309,6445]');
INSERT INTO view_dc_dfa_options2 VALUES(6241,164,'[6309,6445]');
INSERT INTO view_dc_dfa_options2 VALUES(6241,165,'[6309,6445]');
INSERT INTO view_dc_dfa_options2 VALUES(6241,177,'[6309,6445]');
INSERT INTO view_dc_dfa_options2 VALUES(6241,282,'[6241]');
INSERT INTO view_dc_dfa_options2 VALUES(6242,2,'[6241]');
INSERT INTO view_dc_dfa_options2 VALUES(6309,40,'[6241]');
INSERT INTO view_dc_dfa_options2 VALUES(6443,2,'[6445]');
INSERT INTO view_dc_dfa_options2 VALUES(6444,2,'[9566,6309,9581]');
INSERT INTO view_dc_dfa_options2 VALUES(6445,2,'[9566,6309,9581,6445]');
INSERT INTO view_dc_dfa_options2 VALUES(6516,53,'[6241,7,12,7859,7915,8116,9958,8242,9917]');
INSERT INTO view_dc_dfa_options2 VALUES(6611,225,'[6516,6611,7084]');
INSERT INTO view_dc_dfa_options2 VALUES(6611,442,'[6516,6611,7084]');
INSERT INTO view_dc_dfa_options2 VALUES(6611,573,'[6516,6611,7084]');
INSERT INTO view_dc_dfa_options2 VALUES(7084,10,'[6516]');
INSERT INTO view_dc_dfa_options2 VALUES(7084,27,'[6516]');
INSERT INTO view_dc_dfa_options2 VALUES(7199,225,'[11,7199,7672]');
INSERT INTO view_dc_dfa_options2 VALUES(7199,442,'[11,7199,7672]');
INSERT INTO view_dc_dfa_options2 VALUES(7199,573,'[11,7199,7672]');
INSERT INTO view_dc_dfa_options2 VALUES(7672,10,'[11]');
INSERT INTO view_dc_dfa_options2 VALUES(7672,27,'[11]');
INSERT INTO view_dc_dfa_options2 VALUES(7799,2,'[7,12,7859,7915,8116,9979,8242,9615]');
INSERT INTO view_dc_dfa_options2 VALUES(7800,2,'[12,7859,7915,8116,7,8242]');
INSERT INTO view_dc_dfa_options2 VALUES(7859,282,'[12,7859,7915,8116,7,9958,8242,9917]');
INSERT INTO view_dc_dfa_options2 VALUES(7915,108,'[7916,8052]');
INSERT INTO view_dc_dfa_options2 VALUES(7915,109,'[7916,8052]');
INSERT INTO view_dc_dfa_options2 VALUES(7915,110,'[7916,8052]');
INSERT INTO view_dc_dfa_options2 VALUES(7915,111,'[7916,8052]');
INSERT INTO view_dc_dfa_options2 VALUES(7915,122,'[7916,8052]');
INSERT INTO view_dc_dfa_options2 VALUES(7915,159,'[7916,8052]');
INSERT INTO view_dc_dfa_options2 VALUES(7915,160,'[7916,8052]');
INSERT INTO view_dc_dfa_options2 VALUES(7915,161,'[7916,8052]');
INSERT INTO view_dc_dfa_options2 VALUES(7915,162,'[7916,8052]');
INSERT INTO view_dc_dfa_options2 VALUES(7915,163,'[7916,8052]');
INSERT INTO view_dc_dfa_options2 VALUES(7915,164,'[7916,8052]');
INSERT INTO view_dc_dfa_options2 VALUES(7915,165,'[7916,8052]');
INSERT INTO view_dc_dfa_options2 VALUES(7915,177,'[7916,8052]');
INSERT INTO view_dc_dfa_options2 VALUES(7916,40,'[12,7859,7915,8116,7,9958,8242,9917]');
INSERT INTO view_dc_dfa_options2 VALUES(8050,2,'[8052]');
INSERT INTO view_dc_dfa_options2 VALUES(8051,2,'[9797,7916,9812]');
INSERT INTO view_dc_dfa_options2 VALUES(8052,2,'[9797,7916,9812,8052]');
INSERT INTO view_dc_dfa_options2 VALUES(8116,425,'[12,7859,7915,8116,7,9958,8242,9917]');
INSERT INTO view_dc_dfa_options2 VALUES(8240,2,'[7]');
INSERT INTO view_dc_dfa_options2 VALUES(8241,2,'[12,7859,7915,8116,7,9958,8242,9917]');
INSERT INTO view_dc_dfa_options2 VALUES(8242,124,'[12,7859,7915,8116,7,9958,8242,9917]');
INSERT INTO view_dc_dfa_options2 VALUES(8242,179,'[12,7859,7915,8116,7,9958,8242,9917]');
INSERT INTO view_dc_dfa_options2 VALUES(8396,2,'[7,12,7859,7915,8116,9958,8242,9917]');
INSERT INTO view_dc_dfa_options2 VALUES(8397,2,'[12,7859,7915,8116,7,8242]');
INSERT INTO view_dc_dfa_options2 VALUES(8456,2,'[5]');
INSERT INTO view_dc_dfa_options2 VALUES(8457,2,'[8768,4,6,8676,8595,8588,8617,8669,8698]');
INSERT INTO view_dc_dfa_options2 VALUES(8458,14,'[8768,4,6,8676,8595,8588,8617,8669,8698]');
INSERT INTO view_dc_dfa_options2 VALUES(8458,15,'[8768,4,6,8676,8595,8588,8617,8669,8698]');
INSERT INTO view_dc_dfa_options2 VALUES(8458,21,'[8768,4,6,8676,8595,8588,8617,8669,8698]');
INSERT INTO view_dc_dfa_options2 VALUES(8458,22,'[8768,4,6,8676,8595,8588,8617,8669,8698]');
INSERT INTO view_dc_dfa_options2 VALUES(8458,23,'[8768,4,6,8676,8595,8588,8617,8669,8698]');
INSERT INTO view_dc_dfa_options2 VALUES(8458,24,'[8768,4,6,8676,8595,8588,8617,8669,8698]');
INSERT INTO view_dc_dfa_options2 VALUES(8458,36,'[8768,4,6,8676,8595,8588,8617,8669,8698]');
INSERT INTO view_dc_dfa_options2 VALUES(8458,63,'[8768,4,6,8676,8595,8588,8617,8669,8698]');
INSERT INTO view_dc_dfa_options2 VALUES(8458,64,'[8768,4,6,8676,8595,8588,8617,8669,8698]');
INSERT INTO view_dc_dfa_options2 VALUES(8458,65,'[8768,4,6,8676,8595,8588,8617,8669,8698]');
INSERT INTO view_dc_dfa_options2 VALUES(8458,66,'[8768,4,6,8676,8595,8588,8617,8669,8698]');
INSERT INTO view_dc_dfa_options2 VALUES(8458,67,'[8768,4,6,8676,8595,8588,8617,8669,8698]');
INSERT INTO view_dc_dfa_options2 VALUES(8458,68,'[8768,4,6,8676,8595,8588,8617,8669,8698]');
INSERT INTO view_dc_dfa_options2 VALUES(8458,69,'[8768,4,6,8676,8595,8588,8617,8669,8698]');
INSERT INTO view_dc_dfa_options2 VALUES(8458,83,'[8768,4,6,8676,8595,8588,8617,8669,8698]');
INSERT INTO view_dc_dfa_options2 VALUES(8458,180,'[8768,4,6,8676,8595,8588,8617,8669,8698]');
INSERT INTO view_dc_dfa_options2 VALUES(8535,2,'[3]');
INSERT INTO view_dc_dfa_options2 VALUES(8536,2,'[8768,4,6,8676,8595,8588,8617,8669,8698]');
INSERT INTO view_dc_dfa_options2 VALUES(8569,2,'[8571]');
INSERT INTO view_dc_dfa_options2 VALUES(8570,2,'[8458,3,5]');
INSERT INTO view_dc_dfa_options2 VALUES(8571,2,'[8458,3,5,8571]');
INSERT INTO view_dc_dfa_options2 VALUES(8576,2,'[8458,3,5]');
INSERT INTO view_dc_dfa_options2 VALUES(8577,2,'[8595,8588]');
INSERT INTO view_dc_dfa_options2 VALUES(8588,10,'[8595]');
INSERT INTO view_dc_dfa_options2 VALUES(8588,27,'[8595]');
INSERT INTO view_dc_dfa_options2 VALUES(8595,2,'[8458,3,5,8604]');
INSERT INTO view_dc_dfa_options2 VALUES(8602,2,'[8604]');
INSERT INTO view_dc_dfa_options2 VALUES(8603,2,'[8458,3,5]');
INSERT INTO view_dc_dfa_options2 VALUES(8604,2,'[8458,3,5,8604]');
INSERT INTO view_dc_dfa_options2 VALUES(8609,2,'[8458,3,5]');
INSERT INTO view_dc_dfa_options2 VALUES(8610,2,'[4,8595,8588,8617]');
INSERT INTO view_dc_dfa_options2 VALUES(8617,10,'[4]');
INSERT INTO view_dc_dfa_options2 VALUES(8617,27,'[4]');
INSERT INTO view_dc_dfa_options2 VALUES(8646,2,'[8648]');
INSERT INTO view_dc_dfa_options2 VALUES(8647,2,'[8458,3,5]');
INSERT INTO view_dc_dfa_options2 VALUES(8648,2,'[8458,3,5,8648]');
INSERT INTO view_dc_dfa_options2 VALUES(8653,2,'[8458,3,5]');
INSERT INTO view_dc_dfa_options2 VALUES(8654,2,'[6,8676,8669,8698]');
INSERT INTO view_dc_dfa_options2 VALUES(8669,10,'[8676]');
INSERT INTO view_dc_dfa_options2 VALUES(8669,27,'[8676]');
INSERT INTO view_dc_dfa_options2 VALUES(8676,2,'[8458,3,5,8685]');
INSERT INTO view_dc_dfa_options2 VALUES(8683,2,'[8685]');
INSERT INTO view_dc_dfa_options2 VALUES(8684,2,'[8458,3,5]');
INSERT INTO view_dc_dfa_options2 VALUES(8685,2,'[8458,3,5,8685]');
INSERT INTO view_dc_dfa_options2 VALUES(8690,2,'[8458,3,5]');
INSERT INTO view_dc_dfa_options2 VALUES(8691,2,'[6,8676,8669,8698]');
INSERT INTO view_dc_dfa_options2 VALUES(8698,10,'[6]');
INSERT INTO view_dc_dfa_options2 VALUES(8698,27,'[6]');
INSERT INTO view_dc_dfa_options2 VALUES(8710,2,'[49,546,822,7,552]');
INSERT INTO view_dc_dfa_options2 VALUES(8768,2,'[4,6,8676,8595,8588,8617,8669,8698]');
INSERT INTO view_dc_dfa_options2 VALUES(8791,2,'[3924]');
INSERT INTO view_dc_dfa_options2 VALUES(8821,2,'[3924]');
INSERT INTO view_dc_dfa_options2 VALUES(9032,2,'[9032,9047,614]');
INSERT INTO view_dc_dfa_options2 VALUES(9033,2,'[9032,614,9047]');
INSERT INTO view_dc_dfa_options2 VALUES(9046,2,'[9051,9047]');
INSERT INTO view_dc_dfa_options2 VALUES(9047,16,'[9051,614,9047]');
INSERT INTO view_dc_dfa_options2 VALUES(9051,2,'[9032,614,9047]');
INSERT INTO view_dc_dfa_options2 VALUES(9210,2,'[9210,9225,1290]');
INSERT INTO view_dc_dfa_options2 VALUES(9211,2,'[9210,1290,9225]');
INSERT INTO view_dc_dfa_options2 VALUES(9224,2,'[9229,9225]');
INSERT INTO view_dc_dfa_options2 VALUES(9225,16,'[9229,1290,9225]');
INSERT INTO view_dc_dfa_options2 VALUES(9229,2,'[9210,1290,9225]');
INSERT INTO view_dc_dfa_options2 VALUES(9388,2,'[9388,9403,6033]');
INSERT INTO view_dc_dfa_options2 VALUES(9389,2,'[9388,6033,9403]');
INSERT INTO view_dc_dfa_options2 VALUES(9402,2,'[9407,9403]');
INSERT INTO view_dc_dfa_options2 VALUES(9403,16,'[9407,6033,9403]');
INSERT INTO view_dc_dfa_options2 VALUES(9407,2,'[9388,6033,9403]');
INSERT INTO view_dc_dfa_options2 VALUES(9566,2,'[9566,9581,6309]');
INSERT INTO view_dc_dfa_options2 VALUES(9567,2,'[9566,6309,9581]');
INSERT INTO view_dc_dfa_options2 VALUES(9580,2,'[9585,9581]');
INSERT INTO view_dc_dfa_options2 VALUES(9581,16,'[9585,6309,9581]');
INSERT INTO view_dc_dfa_options2 VALUES(9585,2,'[9566,6309,9581]');
INSERT INTO view_dc_dfa_options2 VALUES(9615,2,'[7,12,7859,7915,8116,9979,8242,9943]');
INSERT INTO view_dc_dfa_options2 VALUES(9638,2,'[7,12,7859,7915,8116,9979,8242,9615]');
INSERT INTO view_dc_dfa_options2 VALUES(9797,2,'[9797,9812,7916]');
INSERT INTO view_dc_dfa_options2 VALUES(9798,2,'[9797,7916,9812]');
INSERT INTO view_dc_dfa_options2 VALUES(9811,2,'[9816,9812]');
INSERT INTO view_dc_dfa_options2 VALUES(9812,16,'[9816,7916,9812]');
INSERT INTO view_dc_dfa_options2 VALUES(9816,2,'[9797,7916,9812]');
INSERT INTO view_dc_dfa_options2 VALUES(9917,2,'[7,12,7859,7915,8116,9958,8242,9976]');
INSERT INTO view_dc_dfa_options2 VALUES(9940,2,'[7,12,7859,7915,8116,9958,8242,9917]');
INSERT INTO view_dc_dfa_options2 VALUES(9943,2,'[7,12,7859,7915,8116,9638,8242,9943]');
INSERT INTO view_dc_dfa_options2 VALUES(9958,2,'[7,12,7859,7915,8116,9958,8242,9917]');
INSERT INTO view_dc_dfa_options2 VALUES(9976,2,'[7,12,7859,7915,8116,9940,8242,9976]');
INSERT INTO view_dc_dfa_options2 VALUES(9979,2,'[7,12,7859,7915,8116,9979,8242,9615]');
COMMIT;