On Jan 27, 2009, at 5:24 AM, KurDtE wrote: > > Dear all, > > Yesterday I upgraded my SQLite version from version 3.5.9 to 3.6.10, > and I > now experience an issue while making a SELECT on one of my view : > > This query was previously working on version 3.5.9 : > SELECT [GENERAL.ID] FROM VIEW_GENERAL; > > where "GENERAL.ID" is the name of a column in the view. > > I now get this error : GENERAL.ID : no such column. > I think it gets confused with the dot, how to make the query > understand it > as column name, and not table name + column name ? > > Thanks for help,
This is probably due to a change (many would say a "bug fix") in version 3.6.0: "The result column names generated for compound subqueries have been simplified to show only the name of the column of the original table and omit the table name. This makes SQLite operate more like other SQL database engines." D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
