Details
-
Type:
Bug
-
Status: Open (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 10.4.10
-
Fix Version/s: 10.4
-
Component/s: Data Definition - Create Table, Storage Engine - Connect
-
Labels:
-
Environment:Windows 10 Professional 64 bit
Description
I am not able to run:
create table xpivot1
engine=connect table_type=PIVOT
option_list='PivotCol=FirstLetter,FncCol=cnt'
Srcdef='select table_type, left(table_name,1) as FirstLetter , count(table_type) as cnt from tables group by 1, 2';
The query returns an error:
SQL error (1105): (1045) Access denied for user 'root'@'localhost' (using password: NO) |
, while root is still connected.
If I run the query from the command line, the same error reveals.