Hi,
I just found another issue that looks like it might be related to
ticket #3461:
The following query returns incorrect data for the column
'column_56f32f43' - it seems to repeat the data from other rows for
some rows instead of picking the correct data.
SELECT
agent_ids.AgentName AS column_10d63af1,
IFNULL((SELECT value_en FROM enum_MachineModel WHERE
+enum_MachineModel.key=+hardware_info.MachineModel),
hardware_info.MachineModel) AS column_31169898,
(SELECT value_en FROM enum_OSPlatform WHERE +enum_OSPlatform.key=
+software_info.OSPlatform) AS column_56f32f43
FROM
agent_info
LEFT JOIN
agent_ids ON (Agent_Info.id=agent_ids.id)
LEFT JOIN
hardware_info ON (Agent_Info.id=hardware_info.agent_info_record_id)
LEFT JOIN
software_info ON (Agent_Info.id=software_info.agent_info_record_id)
WHERE
column_10d63af1 LIKE '%ow%' OR column_31169898 LIKE '%ow%' OR
column_56f32f43 LIKE '%ow%';
I tried with the latest sources from cvs and they don't reproduce the
problem, so my assumption was that this might be the same issue as
ticket #3461, but since I'm not sure, I thought I'd ask...
Do you want me to file another ticket for this (I can attach a small
database that allows to reproduce the problem), or can you confirm
that this is the same issue?
Also, since this is now the second issue we find with column aliases -
what are the plans for a new release that fixes this issue?
(We have to decide whether to wait for the next sqlite release or
whether to try and incorporate the fix for this problem into the 3.6.3
sources).
Thanks,
-jens
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
