SPARQL query after parsing, optimization, and converting back into SPARQL SELECT ?catAtt ?caDataType ?showInview ?valFormatKey ?multiple ?position ?link ?catAttName ?setting ?flag ?caUnit ?catId WHERE { GRAPH { QUAD MAP { ?catAtt ?caDataType } QUAD MAP { ?catAtt ?showInview } QUAD MAP { ?catAtt ?valFormatKey } QUAD MAP { ?catAtt ?multiple } QUAD MAP { ?catAtt ?position } QUAD MAP { ?catAtt ?link } QUAD MAP { ?catAtt ?catAttName } QUAD MAP { ?catAtt ?setting } QUAD MAP { ?catAtt ?flag } QUAD MAP { ?catAtt ?caUnit } QUAD MAP { ?catAtt ?catId } } FILTER (?catId = 1) FILTER ( = datatype( ?catId) ) } LIMIT 20 SPARQL query translated to SQL For security reasons, code responsible for graph-level security is not generated and some account-specific data are intentionally made wrong. SELECT TOP 20 __id2in ( "s_24_11_t10"."S") AS "catAtt", __ro2sq ( "s_24_11_t0"."O") AS "caDataType", __ro2sq ( "s_24_11_t1"."O") AS "showInview", __ro2sq ( "s_24_11_t2"."O") AS "valFormatKey", __ro2sq ( "s_24_11_t3"."O") AS "multiple", __ro2sq ( "s_24_11_t4"."O") AS "position", __ro2sq ( "s_24_11_t5"."O") AS "link", __ro2sq ( "s_24_11_t6"."O") AS "catAttName", __ro2sq ( "s_24_11_t7"."O") AS "setting", __ro2sq ( "s_24_11_t8"."O") AS "flag", __ro2sq ( "s_24_11_t9"."O") AS "caUnit", 1 AS "catId" FROM DB.DBA.RDF_QUAD AS "s_24_11_t0" INNER JOIN DB.DBA.RDF_QUAD AS "s_24_11_t1" ON ( "s_24_11_t1"."S" = "s_24_11_t0"."S") INNER JOIN DB.DBA.RDF_QUAD AS "s_24_11_t2" ON ( "s_24_11_t2"."S" = "s_24_11_t1"."S" AND "s_24_11_t2"."S" = "s_24_11_t0"."S") INNER JOIN DB.DBA.RDF_QUAD AS "s_24_11_t3" ON ( "s_24_11_t3"."S" = "s_24_11_t2"."S" AND "s_24_11_t3"."S" = "s_24_11_t1"."S" AND "s_24_11_t3"."S" = "s_24_11_t0"."S") INNER JOIN DB.DBA.RDF_QUAD AS "s_24_11_t4" ON ( "s_24_11_t4"."S" = "s_24_11_t3"."S" AND "s_24_11_t4"."S" = "s_24_11_t2"."S" AND "s_24_11_t4"."S" = "s_24_11_t1"."S" AND "s_24_11_t4"."S" = "s_24_11_t0"."S") INNER JOIN DB.DBA.RDF_QUAD AS "s_24_11_t5" ON ( "s_24_11_t5"."S" = "s_24_11_t4"."S" AND "s_24_11_t5"."S" = "s_24_11_t3"."S" AND "s_24_11_t5"."S" = "s_24_11_t2"."S" AND "s_24_11_t5"."S" = "s_24_11_t1"."S" AND "s_24_11_t5"."S" = "s_24_11_t0"."S") INNER JOIN DB.DBA.RDF_QUAD AS "s_24_11_t6" ON ( "s_24_11_t6"."S" = "s_24_11_t5"."S" AND "s_24_11_t6"."S" = "s_24_11_t4"."S" AND "s_24_11_t6"."S" = "s_24_11_t3"."S" AND "s_24_11_t6"."S" = "s_24_11_t2"."S" AND "s_24_11_t6"."S" = "s_24_11_t1"."S" AND "s_24_11_t6"."S" = "s_24_11_t0"."S") INNER JOIN DB.DBA.RDF_QUAD AS "s_24_11_t7" ON ( "s_24_11_t7"."S" = "s_24_11_t6"."S" AND "s_24_11_t7"."S" = "s_24_11_t5"."S" AND "s_24_11_t7"."S" = "s_24_11_t4"."S" AND "s_24_11_t7"."S" = "s_24_11_t3"."S" AND "s_24_11_t7"."S" = "s_24_11_t2"."S" AND "s_24_11_t7"."S" = "s_24_11_t1"."S" AND "s_24_11_t7"."S" = "s_24_11_t0"."S") INNER JOIN DB.DBA.RDF_QUAD AS "s_24_11_t8" ON ( "s_24_11_t8"."S" = "s_24_11_t7"."S" AND "s_24_11_t8"."S" = "s_24_11_t6"."S" AND "s_24_11_t8"."S" = "s_24_11_t5"."S" AND "s_24_11_t8"."S" = "s_24_11_t4"."S" AND "s_24_11_t8"."S" = "s_24_11_t3"."S" AND "s_24_11_t8"."S" = "s_24_11_t2"."S" AND "s_24_11_t8"."S" = "s_24_11_t1"."S" AND "s_24_11_t8"."S" = "s_24_11_t0"."S") INNER JOIN DB.DBA.RDF_QUAD AS "s_24_11_t9" ON ( "s_24_11_t9"."S" = "s_24_11_t8"."S" AND "s_24_11_t9"."S" = "s_24_11_t7"."S" AND "s_24_11_t9"."S" = "s_24_11_t6"."S" AND "s_24_11_t9"."S" = "s_24_11_t5"."S" AND "s_24_11_t9"."S" = "s_24_11_t4"."S" AND "s_24_11_t9"."S" = "s_24_11_t3"."S" AND "s_24_11_t9"."S" = "s_24_11_t2"."S" AND "s_24_11_t9"."S" = "s_24_11_t1"."S" AND "s_24_11_t9"."S" = "s_24_11_t0"."S") INNER JOIN DB.DBA.RDF_QUAD AS "s_24_11_t10" ON ( "s_24_11_t10"."S" = "s_24_11_t9"."S" AND "s_24_11_t10"."S" = "s_24_11_t8"."S" AND "s_24_11_t10"."S" = "s_24_11_t7"."S" AND "s_24_11_t10"."S" = "s_24_11_t6"."S" AND "s_24_11_t10"."S" = "s_24_11_t5"."S" AND "s_24_11_t10"."S" = "s_24_11_t4"."S" AND "s_24_11_t10"."S" = "s_24_11_t3"."S" AND "s_24_11_t10"."S" = "s_24_11_t2"."S" AND "s_24_11_t10"."S" = "s_24_11_t1"."S" AND "s_24_11_t10"."S" = "s_24_11_t0"."S") WHERE "s_24_11_t0"."G" = __i2idn ( __bft( 'http://localhost:8890/graph' , 1)) AND "s_24_11_t0"."P" = __i2idn ( __bft( 'https://graph.com/rdf/qq/caDataType' , 1)) AND "s_24_11_t1"."G" = __i2idn ( __bft( 'http://localhost:8890/graph' , 1)) AND "s_24_11_t1"."P" = __i2idn ( __bft( 'https://graph.com/rdf/qq/showInView' , 1)) AND "s_24_11_t2"."G" = __i2idn ( __bft( 'http://localhost:8890/graph' , 1)) AND "s_24_11_t2"."P" = __i2idn ( __bft( 'https://graph.com/rdf/qq/valFormat' , 1)) AND "s_24_11_t3"."G" = __i2idn ( __bft( 'http://localhost:8890/graph' , 1)) AND "s_24_11_t3"."P" = __i2idn ( __bft( 'https://graph.com/rdf/qq/multiple' , 1)) AND "s_24_11_t4"."G" = __i2idn ( __bft( 'http://localhost:8890/graph' , 1)) AND "s_24_11_t4"."P" = __i2idn ( __bft( 'https://graph.com/rdf/qq/position' , 1)) AND "s_24_11_t5"."G" = __i2idn ( __bft( 'http://localhost:8890/graph' , 1)) AND "s_24_11_t5"."P" = __i2idn ( __bft( 'https://graph.com/rdf/qq/link' , 1)) AND "s_24_11_t6"."G" = __i2idn ( __bft( 'http://localhost:8890/graph' , 1)) AND "s_24_11_t6"."P" = __i2idn ( __bft( 'https://graph.com/rdf/qq/catAttName' , 1)) AND "s_24_11_t7"."G" = __i2idn ( __bft( 'http://localhost:8890/graph' , 1)) AND "s_24_11_t7"."P" = __i2idn ( __bft( 'https://graph.com/rdf/qq/setting' , 1)) AND "s_24_11_t8"."G" = __i2idn ( __bft( 'http://localhost:8890/graph' , 1)) AND "s_24_11_t8"."P" = __i2idn ( __bft( 'https://graph.com/rdf/qq/flag' , 1)) AND "s_24_11_t9"."G" = __i2idn ( __bft( 'http://localhost:8890/graph' , 1)) AND "s_24_11_t9"."P" = __i2idn ( __bft( 'https://graph.com/rdf/qq/unit' , 1)) AND "s_24_11_t10"."G" = __i2idn ( __bft( 'http://localhost:8890/graph' , 1)) AND "s_24_11_t10"."P" = __i2idn ( __bft( 'https://graph.com/rdf/qq/catId' , 1)) AND "s_24_11_t10"."O" = 1 AND ( __bft( 'http://www.w3.org/2001/XMLSchema#integer' , 1) = __xsd_type ( 1)) OPTION (QUIETCAST) SQL execution plan { END Node After test: 0: __xsd_type$28 := Call __xsd_type ( 1 ) 5: if ( = __xsd_type$28) then 9 else 10 unkn 10 9: BReturn 1 10: BReturn 0 Precode: 0: __xsd_type$30 := Call __xsd_type ( 1 ) 5: BReturn 0 RDF_QUAD_POGS 11 rows(s_24_11_t10.S$33) P = IRI_ID"...catId" , O = 1 G = IRI_ID"...graph" END Node After test: 0: if ( = __xsd_type$30) then 4 else 5 unkn 5 4: BReturn 1 5: BReturn 0 RDF_QUAD 1 rows(s_24_11_t9.S$37, s_24_11_t9.O$36) inlined P = IRI_ID"...unit" , S = k_s_24_11_t10.S$132 G = IRI_ID"...graph" RDF_QUAD 1 rows(s_24_11_t8.S$41, s_24_11_t8.O$40) inlined P = IRI_ID"...flag" , S = k_s_24_11_t9.S$143 G = IRI_ID"...graph" RDF_QUAD 1 rows(s_24_11_t7.S$45, s_24_11_t7.O$44) inlined P = IRI_ID"...setting" , S = k_s_24_11_t8.S$154 G = IRI_ID"...graph" RDF_QUAD 1 rows(s_24_11_t6.S$49, s_24_11_t6.O$48) inlined P = IRI_ID"...catAttName" , S = k_s_24_11_t7.S$165 G = IRI_ID"...graph" RDF_QUAD 1 rows(s_24_11_t0.S$53, s_24_11_t0.O$52) inlined P = IRI_ID"...caDataType" , S = k_s_24_11_t6.S$176 G = IRI_ID"...graph" RDF_QUAD 1 rows(s_24_11_t1.S$57, s_24_11_t1.O$56) inlined P = IRI_ID"...showInView" , S = k_s_24_11_t0.S$187 G = IRI_ID"...graph" RDF_QUAD 1 rows(s_24_11_t2.S$61, s_24_11_t2.O$60) inlined P = IRI_ID"...valFormat" , S = k_s_24_11_t1.S$198 G = IRI_ID"...graph" RDF_QUAD 1 rows(s_24_11_t3.S$65, s_24_11_t3.O$64) inlined P = IRI_ID"...multiple" , S = k_s_24_11_t2.S$209 G = IRI_ID"...graph" RDF_QUAD 1 rows(s_24_11_t4.S$69, s_24_11_t4.O$68) inlined P = IRI_ID"...position" , S = k_s_24_11_t3.S$220 G = IRI_ID"...graph" RDF_QUAD 1 rows(s_24_11_t5.O$72) inlined P = IRI_ID"...link" , S = k_s_24_11_t4.S$231 G = IRI_ID"...graph" skip node 20 set_ctr$102 After code: 0: caUnit$74 := Call __ro2sq (s_24_11_t9.O$36) 5: flag$76 := Call __ro2sq (s_24_11_t8.O$40) 10: setting$78 := Call __ro2sq (s_24_11_t7.O$44) 15: catAttName$80 := Call __ro2sq (s_24_11_t6.O$48) 20: position$82 := Call __ro2sq (s_24_11_t4.O$68) 25: multiple$84 := Call __ro2sq (s_24_11_t3.O$64) 30: valFormatKey$86 := Call __ro2sq (s_24_11_t2.O$60) 35: showInview$88 := Call __ro2sq (s_24_11_t1.O$56) 40: caDataType$90 := Call __ro2sq (s_24_11_t0.O$52) 45: catAtt$92 := Call __id2in (s_24_11_t10.S$33) 50: link$94 := Call __ro2sq (s_24_11_t5.O$72) 55: BReturn 0 Select (catAtt$92, caDataType$90, showInview$88, valFormatKey$86, multiple$84, position$82, link$94, catAttName$80, setting$78, flag$76, caUnit$74, 1 ) } Internal optimizer data These data are primarily for OpenLink support, to get additional details about the query processing. QUERY: (line 28) REQUEST TOP NODE (SELECT result-mode): RETVALS: ARRAY OF NODES with 12 children: { (line 28) VARIABLE: notNULL reference exported NAME: UNAME `catAtt' SELECT ID: STRING `s_28_12' TABLE ID: LONG 0 EQUIV: LONG 12 (line 28) VARIABLE: notNULL exported NAME: UNAME `caDataType' SELECT ID: STRING `s_28_12' TABLE ID: LONG 0 EQUIV: LONG 13 (line 28) VARIABLE: notNULL exported NAME: UNAME `showInview' SELECT ID: STRING `s_28_12' TABLE ID: LONG 0 EQUIV: LONG 14 (line 28) VARIABLE: notNULL exported NAME: UNAME `valFormatKey' SELECT ID: STRING `s_28_12' TABLE ID: LONG 0 EQUIV: LONG 15 (line 28) VARIABLE: notNULL exported NAME: UNAME `multiple' SELECT ID: STRING `s_28_12' TABLE ID: LONG 0 EQUIV: LONG 16 (line 28) VARIABLE: notNULL exported NAME: UNAME `position' SELECT ID: STRING `s_28_12' TABLE ID: LONG 0 EQUIV: LONG 17 (line 28) VARIABLE: notNULL exported NAME: UNAME `link' SELECT ID: STRING `s_28_12' TABLE ID: LONG 0 EQUIV: LONG 18 (line 28) VARIABLE: notNULL exported NAME: UNAME `catAttName' SELECT ID: STRING `s_28_12' TABLE ID: LONG 0 EQUIV: LONG 19 (line 28) VARIABLE: notNULL exported NAME: UNAME `setting' SELECT ID: STRING `s_28_12' TABLE ID: LONG 0 EQUIV: LONG 20 (line 28) VARIABLE: notNULL exported NAME: UNAME `flag' SELECT ID: STRING `s_28_12' TABLE ID: LONG 0 EQUIV: LONG 21 (line 28) VARIABLE: notNULL exported NAME: UNAME `caUnit' SELECT ID: STRING `s_28_12' TABLE ID: LONG 0 EQUIV: LONG 22 (line 28) VARIABLE: notNULL fixed typed lit exported; dt=http://www.w3.org/2001/XMLSchema#integer; fixed INTEGER 1 NAME: UNAME `catId' SELECT ID: STRING `s_28_12' TABLE ID: LONG 0 EQUIV: LONG 23 } RETVALS SELECT ID: STRING `s_28_12' SOURCES: EMPTY ARRAY PATTERN: (line 28) GRAPH PATTERN:WHERE gp MEMBERS: ARRAY OF NODES with 11 children: { (line 8) TRIPLE: GRAPH: (line 6) QNAME: IRI: UNAME `http://localhost:8890/graph' SUBJECT: (line 8) VARIABLE: notNULL+ reference+ exported (subject) NAME: UNAME `catAtt' SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t0' EQUIV: LONG 12 PREDICATE: (line 8) QNAME: IRI: UNAME `https://graph.com/rdf/qq/caDataType' OBJECT: (line 8) VARIABLE: notNULL+ exported (object) NAME: UNAME `caDataType' SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t0' EQUIV: LONG 13 SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t0' (line 9) TRIPLE: GRAPH: (line 6) QNAME: IRI: UNAME `http://localhost:8890/graph' SUBJECT: (line 8) VARIABLE: notNULL+ reference+ exported (subject) NAME: UNAME `catAtt' SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t1' EQUIV: LONG 12 PREDICATE: (line 9) QNAME: IRI: UNAME `https://graph.com/rdf/qq/showInView' OBJECT: (line 9) VARIABLE: notNULL+ exported (object) NAME: UNAME `showInview' SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t1' EQUIV: LONG 14 SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t1' (line 10) TRIPLE: GRAPH: (line 6) QNAME: IRI: UNAME `http://localhost:8890/graph' SUBJECT: (line 8) VARIABLE: notNULL+ reference+ exported (subject) NAME: UNAME `catAtt' SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t2' EQUIV: LONG 12 PREDICATE: (line 10) QNAME: IRI: UNAME `https://graph.com/rdf/qq/valFormat' OBJECT: (line 10) VARIABLE: notNULL+ exported (object) NAME: UNAME `valFormatKey' SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t2' EQUIV: LONG 15 SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t2' (line 11) TRIPLE: GRAPH: (line 6) QNAME: IRI: UNAME `http://localhost:8890/graph' SUBJECT: (line 8) VARIABLE: notNULL+ reference+ exported (subject) NAME: UNAME `catAtt' SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t3' EQUIV: LONG 12 PREDICATE: (line 11) QNAME: IRI: UNAME `https://graph.com/rdf/qq/multiple' OBJECT: (line 11) VARIABLE: notNULL+ exported (object) NAME: UNAME `multiple' SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t3' EQUIV: LONG 16 SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t3' (line 12) TRIPLE: GRAPH: (line 6) QNAME: IRI: UNAME `http://localhost:8890/graph' SUBJECT: (line 8) VARIABLE: notNULL+ reference+ exported (subject) NAME: UNAME `catAtt' SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t4' EQUIV: LONG 12 PREDICATE: (line 12) QNAME: IRI: UNAME `https://graph.com/rdf/qq/position' OBJECT: (line 12) VARIABLE: notNULL+ exported (object) NAME: UNAME `position' SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t4' EQUIV: LONG 17 SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t4' (line 13) TRIPLE: GRAPH: (line 6) QNAME: IRI: UNAME `http://localhost:8890/graph' SUBJECT: (line 8) VARIABLE: notNULL+ reference+ exported (subject) NAME: UNAME `catAtt' SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t5' EQUIV: LONG 12 PREDICATE: (line 13) QNAME: IRI: UNAME `https://graph.com/rdf/qq/link' OBJECT: (line 13) VARIABLE: notNULL+ exported (object) NAME: UNAME `link' SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t5' EQUIV: LONG 18 SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t5' (line 14) TRIPLE: GRAPH: (line 6) QNAME: IRI: UNAME `http://localhost:8890/graph' SUBJECT: (line 8) VARIABLE: notNULL+ reference+ exported (subject) NAME: UNAME `catAtt' SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t6' EQUIV: LONG 12 PREDICATE: (line 14) QNAME: IRI: UNAME `https://graph.com/rdf/qq/catAttName' OBJECT: (line 14) VARIABLE: notNULL+ exported (object) NAME: UNAME `catAttName' SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t6' EQUIV: LONG 19 SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t6' (line 15) TRIPLE: GRAPH: (line 6) QNAME: IRI: UNAME `http://localhost:8890/graph' SUBJECT: (line 8) VARIABLE: notNULL+ reference+ exported (subject) NAME: UNAME `catAtt' SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t7' EQUIV: LONG 12 PREDICATE: (line 15) QNAME: IRI: UNAME `https://graph.com/rdf/qq/setting' OBJECT: (line 15) VARIABLE: notNULL+ exported (object) NAME: UNAME `setting' SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t7' EQUIV: LONG 20 SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t7' (line 16) TRIPLE: GRAPH: (line 6) QNAME: IRI: UNAME `http://localhost:8890/graph' SUBJECT: (line 8) VARIABLE: notNULL+ reference+ exported (subject) NAME: UNAME `catAtt' SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t8' EQUIV: LONG 12 PREDICATE: (line 16) QNAME: IRI: UNAME `https://graph.com/rdf/qq/flag' OBJECT: (line 16) VARIABLE: notNULL+ exported (object) NAME: UNAME `flag' SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t8' EQUIV: LONG 21 SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t8' (line 17) TRIPLE: GRAPH: (line 6) QNAME: IRI: UNAME `http://localhost:8890/graph' SUBJECT: (line 8) VARIABLE: notNULL+ reference+ exported (subject) NAME: UNAME `catAtt' SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t9' EQUIV: LONG 12 PREDICATE: (line 17) QNAME: IRI: UNAME `https://graph.com/rdf/qq/unit' OBJECT: (line 17) VARIABLE: notNULL+ exported (object) NAME: UNAME `caUnit' SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t9' EQUIV: LONG 22 SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t9' (line 18) TRIPLE: GRAPH: (line 6) QNAME: IRI: UNAME `http://localhost:8890/graph' SUBJECT: (line 8) VARIABLE: notNULL+ reference+ exported (subject) NAME: UNAME `catAtt' SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t10' EQUIV: LONG 12 PREDICATE: (line 18) QNAME: IRI: UNAME `https://graph.com/rdf/qq/catId' OBJECT: (line 18) VARIABLE: notNULL+ fixed typed lit exported; dt=http://www.w3.org/2001/XMLSchema#integer; fixed INTEGER 1 (object) NAME: UNAME `catId' SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t10' EQUIV: LONG 23 SELECT ID: STRING `s_28_12' TABLE ID: STRING `s_24_11_t10' } FILTERS: ARRAY OF NODES with 1 children: { (line 28) OPERATOR EXPRESSION (boolean operation '='): LEFT: UNAME `http://www.w3.org/2001/XMLSchema#integer' RIGHT: (line 28) BUILT-IN CALL:datatype ARGUMENT: ARRAY OF NODES with 1 children: { (line 28) VARIABLE: notNULL fixed typed lit exported; dt=http://www.w3.org/2001/XMLSchema#integer; fixed INTEGER 1 NAME: UNAME `catId' SELECT ID: STRING `s_28_12' TABLE ID: LONG 0 EQUIV: LONG 23 } } SELECT ID: STRING `s_28_12' EQUIVS: 12 13 14 15 16 17 18 19 20 21 22 23 LIMIT: LONG 20 EQUIVS: #0: merged and destroyed #1: merged and destroyed #2: merged and destroyed #3: merged and destroyed #4: merged and destroyed #5: merged and destroyed #6: merged and destroyed #7: merged and destroyed #8: merged and destroyed #9: merged and destroyed #10: merged and destroyed #11: merged and destroyed #12: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 11 gspo, 1 const, 0 opt, 0 subq: catAtt in s_28_12 s_24_11_t10 s_24_11_t9 s_24_11_t8 s_24_11_t7 s_24_11_t6 s_24_11_t5 s_24_11_t4 s_24_11_t3 s_24_11_t2 s_24_11_t1 s_24_11_t0; notNULL reference exported) #13: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 1 const, 0 opt, 0 subq: caDataType in s_28_12 s_24_11_t0; notNULL exported) #14: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 1 const, 0 opt, 0 subq: showInview in s_28_12 s_24_11_t1; notNULL exported) #15: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 1 const, 0 opt, 0 subq: valFormatKey in s_28_12 s_24_11_t2; notNULL exported) #16: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 1 const, 0 opt, 0 subq: multiple in s_28_12 s_24_11_t3; notNULL exported) #17: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 1 const, 0 opt, 0 subq: position in s_28_12 s_24_11_t4; notNULL exported) #18: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 1 const, 0 opt, 0 subq: link in s_28_12 s_24_11_t5; notNULL exported) #19: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 1 const, 0 opt, 0 subq: catAttName in s_28_12 s_24_11_t6; notNULL exported) #20: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 1 const, 0 opt, 0 subq: setting in s_28_12 s_24_11_t7; notNULL exported) #21: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 1 const, 0 opt, 0 subq: flag in s_28_12 s_24_11_t8; notNULL exported) #22: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 1 const, 0 opt, 0 subq: caUnit in s_28_12 s_24_11_t9; notNULL exported) #23: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 2 const, 0 opt, 0 subq: catId in s_28_12 s_24_11_t10 s_28_12; notNULL! fixed! typed! lit exported; dt=http://www.w3.org/2001/XMLSchema#integer; fixed INTEGER 1)