linux-traipu team mailing list archive

[Patrick Crews <872451@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

test main.create is failing on my 11.04 machine as follows:
main.create                                                  [ fail ]
drizzletest: At line 1187: query 'create database имя_базы_в_кодировке_утф8_длиной_больше_чем_45' failed: 1006: Can't create schema 'имя_базы_в_кодировке_утф8_длиной_больше_чем_45' (errno: 36)

The result from queries just before the failure was:
< snip >
CREATE TEMPORARY TABLE t2 (a int, b int, primary key (a));
CREATE TEMPORARY TABLE IF NOT EXISTS t2 (primary key (a)) select * from t1;
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
SELECT * from t2;
a	b
TRUNCATE table t2;
INSERT INTO t2 select * from t1;
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
SELECT * from t2;
a	b
drop table t1,t2;
CREATE DATABASE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa;
ERROR 42000: Incorrect schema name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'
DROP DATABASE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa;
ERROR 42000: Incorrect schema name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'
USE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa;
ERROR 42000: Incorrect schema name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'
SHOW CREATE DATABASE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa;
Database	Create Database
create database имя_базы_в_кодировке_утф8_длиной_больше_чем_45;

** Affects: drizzle
     Importance: Undecided
         Status: Confirmed

** Affects: drizzle/fremont
     Importance: Undecided
         Status: Confirmed

** Changed in: drizzle
       Status: New => Confirmed

** Also affects: drizzle/fremont
   Importance: Undecided
       Status: Confirmed

-- 
You received this bug notification because you are a member of UBUNTU -
AL - BR, which is subscribed to Drizzle.
https://bugs.launchpad.net/bugs/872451

Title:
  main.create failing on Ubuntu 11.04

Status in A Lightweight SQL Database for Cloud Infrastructure and Web Applications:
  Confirmed
Status in Drizzle fremont series:
  Confirmed

Bug description:
  test main.create is failing on my 11.04 machine as follows:
  main.create                                                  [ fail ]
  drizzletest: At line 1187: query 'create database имя_базы_в_кодировке_утф8_длиной_больше_чем_45' failed: 1006: Can't create schema 'имя_базы_в_кодировке_утф8_длиной_больше_чем_45' (errno: 36)

  The result from queries just before the failure was:
  < snip >
  CREATE TEMPORARY TABLE t2 (a int, b int, primary key (a));
  CREATE TEMPORARY TABLE IF NOT EXISTS t2 (primary key (a)) select * from t1;
  ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
  SELECT * from t2;
  a	b
  TRUNCATE table t2;
  INSERT INTO t2 select * from t1;
  ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
  SELECT * from t2;
  a	b
  drop table t1,t2;
  CREATE DATABASE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa;
  ERROR 42000: Incorrect schema name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'
  DROP DATABASE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa;
  ERROR 42000: Incorrect schema name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'
  USE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa;
  ERROR 42000: Incorrect schema name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'
  SHOW CREATE DATABASE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa;
  Database	Create Database
  create database имя_базы_в_кодировке_утф8_длиной_больше_чем_45;

To manage notifications about this bug go to:
https://bugs.launchpad.net/drizzle/+bug/872451/+subscriptions