Bug (or feature?) Trailing comment becomes part of column name

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Bug (or feature?) Trailing comment becomes part of column name

petern
sqlite> .mode column
sqlite> SELECT sqlite_source_id()--sql_comment
   ...> ;
sqlite_source_id()--sql_comment

------------------------------------------------------------------------------------
2018-01-22 18:45:57
0c55d179733b46d8d0ba4d88e01a25e10677046ee3da1d5b1581e86726f2alt1

sqlite> SELECT sqlite_source_id()/*sql_comment*/
   ...> ;
sqlite_source_id()/*sql_comment*/

------------------------------------------------------------------------------------
2018-01-22 18:45:57
0c55d179733b46d8d0ba4d88e01a25e10677046ee3da1d5b1581e86726f2alt1

However, with column alias present, column name is as expected:

sqlite> SELECT sqlite_source_id()ssid/*sql_comment*/
   ...> ;
ssid

------------------------------------------------------------------------------------
2018-01-22 18:45:57
0c55d179733b46d8d0ba4d88e01a25e10677046ee3da1d5b1581e86726f2alt1
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users