Aloha, estoy teniendo un problemita con SQLite y DBX.<br>En primer lugar, no se porque no pasa en las otras bases, es algo a mirar quizas...<br><br>Bueno, lo que pasa es que Glorp quiere tirar un query así (cuando tiene un mapeo de una herencia):<br>
<br>SELECT * FROM <br> (SELECT t2.ID, t2.NAME, t2.SERIAL_NUMBER, NULL AS t4nullField1, NULL AS t4nullField2, NULL AS t4nullField3, NULL AS t5nullField1, NULL AS t5nullField2, NULL AS t5nullField3, NULL AS t5nullField4<br>
FROM NONPERISHABLE_ITEM t2, WAREHOUSE_ITEM_LINK t3<br> WHERE t2.ID = t3.ITEM_ID AND t3.WAREHOUSE_ID = 1 <br>UNION ALL <br> SELECT NULL AS t4nullField1, NULL AS t4nullField2, NULL AS t4nullField3, t2.ID, t2.NAME, t2.AGE, NULL AS t5nullField1, NULL AS t5nullField2, NULL AS t5nullField3, NULL AS t5nullField4<br>
FROM PERISHABLE_ITEM t2, WAREHOUSE_ITEM_LINK t3<br> WHERE t2.ID = t3.ITEM_ID AND t3.WAREHOUSE_ID = 1 <br><br>UNION ALL <br> SELECT NULL AS t4nullField1, NULL AS t4nullField2, NULL AS t4nullField3, NULL AS t5nullField1, NULL AS t5nullField2, NULL AS t5nullField3, t2.ID, t2.NAME, t2.SERIAL_NUMBER, t2.ASSEM_COST<br>
FROM UNASSEMBLED_ITEM t2, WAREHOUSE_ITEM_LINK t3<br> WHERE t2.ID = t3.ITEM_ID AND t3.WAREHOUSE_ID = 1) t2<br><br>Y eso hace que OpenDBX devuelva como Description del query esto:<br><br>an OrderedCollection(<br>('ID':Number)<br>
('NAME':String)<br> ('SERIAL_NUMBER':Number)<br> ('t4nullField1':a DBXTypeNotSupported)<br> ('t4nullField2':a DBXTypeNotSupported)<br> ('t4nullField3':a DBXTypeNotSupported)<br> ('t5nullField1':a DBXTypeNotSupported)<br>
('t5nullField2':a DBXTypeNotSupported)<br> ('t5nullField3':a DBXTypeNotSupported)<br> ('t5nullField4':a DBXTypeNotSupported))<br><br>Porque evidentemente para definir los tipos del resultset, esta usando solo la primera row parece. ¿Bug de openDBX no?<br>
<p></p>
-- <br />
You received this message because you are subscribed to the Google Groups "proyecto_relacional" group.<br />
To post to this group, send email to proyecto_relacional@googlegroups.com.<br />
To unsubscribe from this group, send email to proyecto_relacional+unsubscribe@googlegroups.com.<br />
For more options, visit this group at http://groups.google.com/group/proyecto_relacional?hl=en.<br />