<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
Hmm, looks like it was introduced in November 2010, so fairly
recent. I think a quick hack version would be just to make the
useSingleQuery: method ignore the boolean and leave the value as
false all the time.<br>
<br>
<br>
<blockquote style="border: 0px none;"
cite="mid:BANLkTimoAQUNJ=WwBmFbpVRtVyBVVtuPPA@mail.gmail.com"
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; height: 1px; margin: 0pt;"
class="__pbConvHr"><br>
</div>
<div style="margin-left: 40px;"><a moz-do-not-send="true"
href="mailto:guillermopolito@gmail.com" style="color: rgb(0,
136, 204) ! important; text-decoration: none ! important;">Guillermo
Polito</a><br>
<font color="#888888">June 18, 2011 4:57 PM</font></div>
<br>
<div style="color: rgb(136, 136, 136); margin-left: 40px;"
__pbrmquotes="true" class="__pbConvBody"><br>
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>
<br>
<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; height: 1px; margin: 15px 0pt 0pt;"
class="__pbConvHr"><br>
</div>
<div style="margin-left: 40px;"><a moz-do-not-send="true"
href="mailto:knight@acm.org" style="color: rgb(0, 136, 204) !
important; text-decoration: none ! important;">Alan Knight</a><br>
<font color="#888888">June 13, 2011 8:38 AM</font></div>
<br>
<div style="color: rgb(136, 136, 136); margin-left: 40px;"
__pbrmquotes="true" class="__pbConvBody"><br>
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
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>
<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; height: 1px; margin: 15px 0pt 0pt;"
class="__pbConvHr"><br>
</div>
<div style="margin-left: 40px;"><a moz-do-not-send="true"
href="mailto:guillermopolito@gmail.com" style="color: rgb(0,
136, 204) ! important; text-decoration: none ! important;">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;"
__pbrmquotes="true" class="__pbConvBody"><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>
-- <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 class="moz-txt-link-abbreviated" href="mailto:proyecto_relacional@googlegroups.com">proyecto_relacional@googlegroups.com</a>.<br>
To unsubscribe from this group, send email to
<a class="moz-txt-link-abbreviated" href="mailto:proyecto_relacional+unsubscribe@googlegroups.com">proyecto_relacional+unsubscribe@googlegroups.com</a>.<br>
For more options, visit this group at
<a class="moz-txt-link-freetext" href="http://groups.google.com/group/proyecto_relacional?hl=en">http://groups.google.com/group/proyecto_relacional?hl=en</a>.<br>
<div>_______________________________________________<br>
SqueakDBX mailing list<br>
<a class="moz-txt-link-abbreviated" href="mailto:SqueakDBX@lists.squeakfoundation.org">SqueakDBX@lists.squeakfoundation.org</a><br>
<a class="moz-txt-link-freetext" href="http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx">http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx</a><br>
</div>
</div>
</blockquote>
</body>
</html>