Hi,
We make use of a number of queries which we also run against other databases.
Consider this simplified example:
SELECT psim_objects.ObjectName, property.AttributeTextValue, data.Attribute,
data.AttributeUOM FROM psim_objects INNER JOIN (psim_objectdata data INNER
JOIN psim_objectdata property ON data.ObjectID = property.ObjectID) ON
psim_objects.ObjectID = data.OwnerObject
It executes fine on other databases, but on SQLite it gives the error:
SQL Error: Error running Query - no such column: property.AttributeTextValue
Now, one can rewrite this query so it does work, but it should work as is on
SQLite, it works as is on other databases, and a number of tools that build
queries tend to build queries like this.
Please evaluate this and log it as a bug or enhancement request as appropriate?
Also, I am sure this must be logged somewhere, yet I can not see it in the bug
and enhancement list, but it would be very convenient if SQLite would support
more of the now standard SQL string functions like LEFT, RIGHT, SUBSTRING, etc.
I know SQLite has SUBSTR and you can extend the functions and SQLite does not
compete with Oracle, SQL Server etc. but there is some benefit in being able to
write one SQL query that runs on a number of databases rather than "if Oracle
do this... If sqlite do this...". I think SQLite is possibly the only database
which does not have the LEFT string function. Please log that as an enhancement
request.
Thank you kindly for your consideration.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
