The following returns an erroneous fsdir error. Tested on macOS 10.13.6.
SQLite version 3.25.3 2018-11-05 20:37:38
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> CREATE TABLE d AS SELECT '.' d;
sqlite> CREATE TABLE x AS SELECT 1 x;
sqlite> SELECT name
...> FROM d
...> JOIN x
...> JOIN fsdir(d)
...> ORDER BY 1;
Error: table function fsdir requires an argument
sqlite>
These variants all run as expected:
SELECT name
FROM d
JOIN x
JOIN fsdir('.')
ORDER BY 1;
SELECT name
FROM (SELECT '.' d)
JOIN (SELECT 1 x)
JOIN fsdir(d)
ORDER BY 1;
SELECT name
FROM d
JOIN x
JOIN fsdir(d);
SELECT name
FROM d
JOIN fsdir(d)
ORDER BY 1;
Regards
Jake
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
