Hi Alan!<br><br>I've finally not found any supportsSingleQueryHorizontalInheritance selector in any Glorp class :(. Maybe it exists in a different version... Do you have a clue for us?<br><br>Thanks!<br>Guille<br><br>
<div class="gmail_quote">On Mon, Jun 13, 2011 at 9:38 AM, Alan Knight <span dir="ltr"><<a href="mailto:knight@acm.org">knight@acm.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<u></u>
<div bgcolor="#ffffff" text="#000000">
Yes, that's a clever thing that Glorp tries to do in order to read
an inheritance hierarchy as one query. The syntax that you have to
use is different between different databases. The simple thing is to
disable it for a particular platform using
#supportsSingleQueryHorizontalInheritance<br>
<br>
<blockquote style="border: 0px none;" type="cite">
<div style="margin-left: 40px;">
<hr style="border-width: 1px 0pt 0pt; border-style: dotted none none; border-color: rgb(181, 181, 181) -moz-use-text-color -moz-use-text-color; min-height: 1px; margin: 0pt;"><br>
</div>
<div style="margin-left: 40px;"><a href="mailto:guillermopolito@gmail.com" style="color: rgb(0, 136, 204) ! important; text-decoration: none ! important;" target="_blank">Guillermo
Polito</a><br>
<font color="#888888">June 13, 2011 12:32 AM</font></div>
<br>
<div style="color: rgb(136, 136, 136); margin-left: 40px;"><div><div></div><div class="h5"><br>
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></div></div>
-- <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
<a href="mailto:proyecto_relacional@googlegroups.com" target="_blank">proyecto_relacional@googlegroups.com</a>.<br>
To unsubscribe from this group, send email to
<a href="mailto:proyecto_relacional+unsubscribe@googlegroups.com" target="_blank">proyecto_relacional+unsubscribe@googlegroups.com</a>.<br>
For more options, visit this group at
<a href="http://groups.google.com/group/proyecto_relacional?hl=en" target="_blank">http://groups.google.com/group/proyecto_relacional?hl=en</a>.<br>
<div>_______________________________________________<br>
SqueakDBX mailing list<br>
<a href="mailto:SqueakDBX@lists.squeakfoundation.org" target="_blank">SqueakDBX@lists.squeakfoundation.org</a><br>
<a href="http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx" target="_blank">http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx</a><br>
</div>
</div>
</blockquote>
</div>
<br>_______________________________________________<br>
SqueakDBX mailing list<br>
<a href="mailto:SqueakDBX@lists.squeakfoundation.org">SqueakDBX@lists.squeakfoundation.org</a><br>
<a href="http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx" target="_blank">http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx</a><br>
<br></blockquote></div><br>