Problem with registering

[lancew]

Problem with registering

[lancew]

Interesting....

So I am running locally:

$ perl6 -v
This is Rakudo version 2017.11 built on MoarVM version 2017.11
implementing Perl 6.c.

Bailador:
Bailador:ver<0.0.14>

Not yet able to replicate a failure such as you have found.

[JJ]

Could it be an error in DBDish;:SQLite itself of which you might have a different version?

[JJ]

Hum, no. The error seems to be in this statement:

        $sth = $.dbh.prepare(q:to/STATEMENT/);
            WITH CTE AS
            (
            SELECT parent_sensei_id
                FROM sensei_sensei
                WHERE child_Sensei_id=?
            UNION ALL
            SELECT sensei_sensei.parent_sensei_id
                FROM CTE
                JOIN sensei_sensei
                ON CTE.parent_sensei_id=sensei_sensei.child_sensei_id
            )
            SELECT distinct * FROM CTE;
        STATEMENT

[JJ]

I would say it's a problem with the SQLite version number

[JJ]

It's an sqlite error:

sqlite>            WITH CTE AS
   ...>             (
   ...>             SELECT parent_sensei_id
   ...>                 FROM sensei_sensei
   ...>                 WHERE child_Sensei_id=?
   ...>             UNION ALL
   ...>             SELECT sensei_sensei.parent_sensei_id
   ...>                 FROM CTE
   ...>                 JOIN sensei_sensei
   ...>                 ON CTE.parent_sensei_id=sensei_sensei.child_sensei_id
   ...>             )
   ...>             SELECT distinct * FROM CTE;
Error: near "WITH": syntax error

And right on: https://stackoverflow.com/questions/27048349/sqlite-with-syntax-error
...

$ sqlite3 --version
3.8.2 2013-12-06 14:53:30 27392118af4c38c5203a04b8013e1afdb1cebd0d

[lancew]

I may also remove that insane query that I was using to get teh family tree of instructors (sensei). There are other approaches. :-)

[JJ]

👍