[digikam] [Bug 451289] Database identifiers should be protected with tick marks

[Jan Steinman]

https://bugs.kde.org/show_bug.cgi?id=451289

--- Comment #4 from Jan Steinman <jan.steinman at gmail.com> ---
(In reply to Maik Qualmann from comment #3)
> The variant with tick marks doesn't work.
> 
> GRANT ALL PRIVILEGES ON 'digikam.*' TO 'maik'@'127.0.0.1';
> 
> You have an error in your SQL syntax; check the manual that corresponds to
> your MariaDB server version for the right syntax to use near ''digikam.*' TO
> 'maik'@'127.0.0.1'' at line 1
> 
> In fact, it must be so-called backticks. 
> 
> Maik

ARGH! Yes, of course, you are right. I'll update the bug to say so.

Not only that, but each hierarchical part must be separately back-ticked.

So `digikam.*` will never work, but `digikam`.* should, at least in MySQL.
Likewise, `DigiKam-Core.Albums` won't work, but `DigiKam-Core`.`Albums` should.

The reference I noted in Comment 2 is ambiguous about Sqlite. I can't find a
proper BNF for their language spec.

-- 
You are receiving this mail because:
You are watching all bug changes.