[sqlite] Column naming between 3.2.0 and 3.2.8

[Eric Boudaillier]

Hello all,

I use (tcl)sqlite since May 2005, primarily in an application which
build a database of electrical equipment along a railway line.

I started with sqlite 3.2.0. Now I try to use the version 3.2.8,
installed with ActiveTcl. But I have a lots of errors due to the column
naming.

For example, the following query don't give the same column names:

db eval {
   SELECT
     equipment_type_name,
     io_type.io_type_id,
     io_type_name,
     alarm_if_active
   FROM (equipment_type JOIN equipment_type_has_io_type
         USING (equipment_type_id))
   JOIN io_type USING (io_type_id)
   JOIN io_type_digital_input USING (io_type_id)
} arr { break }

The result is in the "arr" variable.
With sqlite 3.2.0, "arr" contains:

arr(*)                   = equipment_type_name io_type_id io_type_name
alarm_if_active
arr(alarm_if_active)     = DC1
arr(equipment_type_name) = CB72_C
arr(io_type_id)          = 71
arr(io_type_name)        = DC1

With sqlite 3.2.8, "arr" contains:

arr(*)                   = equipment_type_name io_type.io_type_id
io_type_name alarm_if_active
arr(alarm_if_active)     = DC1
arr(equipment_type_name) = CB72_C
arr(io_type.io_type_id)  = 71       <===== Now has the table in its name
arr(io_type_name)        = DC1

I have checked the two PRAGMA controlling the column naming, and they
are identical in both version.
I have not seen a note concerning this change.
Is there something wrong in 3.2.8? Or have I to update all the queries?

Thanks.

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------