W3cubDocs

/MariaDB

creating pivot table fails

I tried to create a pivot table based on an existing table "test1" and get an error. I am logged in and I can use "test1", so this error makes no sense to me. What I am doing wrong? Any hints?

MariaDB [nav]> create table xsort engine=connect table_type=pivot tabname=test1;

ERROR 1105 (HY000): (1045) Access denied for user 'root'@'localhost' (using password: NO)

MariaDB [nav]>

Answer Answered by Sergei Golubchik in this comment.

if you think it's a bug, please, report it on mariadb.org/jira and you can expect it to be fixed in the next version.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/creating-pivot-table-fails/