My Query Does Not Return The Column Name That I Expect. Is This A Bug

1.	My Query Does Not Return The Column Name That I Expect. Is This A Bug?
Answer» If the columns of your result set are named by AS CLAUSES, then SQLite is guaranteed to use the identifier to the right of the AS keyword as the column NAME. If the result set does not use an AS clause, then SQLite is FREE to name the column anything it wants. If the columns of your result set are named by AS clauses, then SQLite is guaranteed to use the identifier to the right of the AS keyword as the column name. If the result set does not use an AS clause, then SQLite is free to name the column anything it wants.

My Query Does Not Return The Column Name That I Expect. Is This A Bug?

Answer»

If the columns of your result set are named by AS CLAUSES, then SQLite is guaranteed to use the identifier to the right of the AS keyword as the column NAME.

If the result set does not use an AS clause, then SQLite is FREE to name the column anything it wants.

If the columns of your result set are named by AS clauses, then SQLite is guaranteed to use the identifier to the right of the AS keyword as the column name.

If the result set does not use an AS clause, then SQLite is free to name the column anything it wants.

Discussion

No Comment Found

Related InterviewSolutions

I Accidentally Deleted Some Important Information From My Sqlite Database. How Can I Recover It?
What Is An Sqlite_corrupt Error? What Does It Mean For The Database To Be "malformed"? Why Am I Getting This Error?
Does Sqlite Support Foreign Keys?
The Sql Standard Requires That A Unique Constraint Be Enforced Even If One Or More Of The Columns In The Constraint Are Null, But Sqlite Does Not Do This. Isn't That A Bug?
What Is The Export Control Classification Number (eccn) For Sqlite?
My Query Does Not Return The Column Name That I Expect. Is This A Bug?
Insert Is Really Slow - I Can Only Do Few Dozen Inserts Per Second?
Case-insensitive Matching Of Unicode Characters Does Not Work?
Why Does Round(9.95,1) Return 9.9 Instead Of 10.0? Shouldn't 9.95 Round Up?
What Is An Sqlite_schema Error, And Why Am I Getting One?