On 4/27/19, Manuel Rigger <[email protected]> wrote:
>
> when executing the example below, I get "Error: no such column: asdf". This
> behavior is surprising to me, as I would have expected "asdf" to be
> interpreted as a string and not as a column name.
>
> CREATE TABLE test (c0);
> CREATE INDEX index_1 ON test('asdf');
>
> Could this be a bug or an unnoticed inconsistency?
This is intentional, though undocumented (or at least I don't recall
documenting it). You can, in fact, use a string literal for the name
of a table or column. For example:
CREATE TABLE 'test'('c0');
Which is logically equivalent to your original:
CREATE TABLE test(c0);
--
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
