Details

    Description

      create table xt1 (
      id int not null,
      msg varchar(32))
      engine=myisam;
       
      create table xt2 (
      id int not null,
      msg varchar(32)); /* engine=innoDB */
       
      create table xt3 (
      id int not null,
      msg varchar(32))
      engine=connect table_type=CSV;
       
       
      create table t3 (
      id int not null,
      msg varchar(32))
      engine=connect table_type=PROXY tabname='xt%s'
      partition by range columns(id) (
      partition `1` values less than(10),
      partition `2` values less than(50),
      partition `3` values less than(MAXVALUE));
      

      Error with RocksDB because hidden directory :

       select partition_name, table_rows from
          -> information_schema.partitions where table_name = 't3';
      ERROR 1102 (42000): Incorrect database name '#mysql50#.rocksdb'
      

      Attachments

        Issue Links

          Activity

            other point :

            insert into t3 values
            (4, 'four'),(7,'seven'),(10,'ten'),(40,'forty'),
            (60,'sixty'),(81,'eighty one'),(72,'seventy two'),
            (11,'eleven'),(1,'one'),(35,'thirty five'),(8,'eight');
             
            select * from t3;
            ERROR 1296 (HY000): Got error 174 '(1045) Access denied for user 'root'@'localhost' (using password: NO)' from CONNECT
            
            

            i would it's only make proxy, i mean if same host not instantoate new connexion on DB

            Aurelien_LEQUOY Aurélien LEQUOY added a comment - other point : insert into t3 values ( 4 , 'four' ),( 7 , 'seven' ),( 10 , 'ten' ),( 40 , 'forty' ), ( 60 , 'sixty' ),( 81 , 'eighty one' ),( 72 , 'seventy two' ), ( 11 , 'eleven' ),( 1 , 'one' ),( 35 , 'thirty five' ),( 8 , 'eight' );   select * from t3; ERROR 1296 (HY000): Got error 174 '(1045) Access denied for user ' root '@' localhost ' (using password: NO)' from CONNECT i would it's only make proxy, i mean if same host not instantoate new connexion on DB

            Does the latter problem also only happen with RocksDB enabled?

            elenst Elena Stepanova added a comment - Does the latter problem also only happen with RocksDB enabled?

            yes, if rocksdb was enabled.

            this hidden directory make a lot of trouble, it's not firdt time i got troublevwith this.

            Aurelien_LEQUOY Aurélien LEQUOY added a comment - yes, if rocksdb was enabled. this hidden directory make a lot of trouble, it's not firdt time i got troublevwith this.

            I agree. We already have reports about it causing troubles, but I'm going to keep this one as well, as yet another proof that it must be sorted out before RocksDB goes to the next level.

            elenst Elena Stepanova added a comment - I agree. We already have reports about it causing troubles, but I'm going to keep this one as well, as yet another proof that it must be sorted out before RocksDB goes to the next level.

            Fixed as part of fix for MDEV-14123. Marking as a duplicate.

            psergei Sergei Petrunia added a comment - Fixed as part of fix for MDEV-14123 . Marking as a duplicate.

            solved confirmed

            Aurelien_LEQUOY Aurélien LEQUOY added a comment - solved confirmed

            People

              psergei Sergei Petrunia
              Aurelien_LEQUOY Aurélien LEQUOY
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.