randgen team mailing list archive

[Patrick Crews <961630@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

The random data generator is inconsistent in how it quotes table names:
Note the DROP TABLE and INSERT statements vs. the CREATE TABLE and ALTER TABLE statements.

DROP TABLE /*! IF EXISTS*/ c;
CREATE TABLE `c` (
`col_char_255` char(255),
ALTER TABLE `c` DISABLE KEYS;
INSERT /*! IGNORE */ INTO c VALUES ('k', 'j', 'jcszxwbj', NULL, -656211968, 'r', 'cszxwb', 'TTNNK', -1458634752, NULL, 'l', 2, 'szxwbjj') ;
COMMIT;
ALTER TABLE `c` ENABLE KEYS;

** Affects: randgen
     Importance: Medium
     Assignee: Patrick Crews (patrick-crews)
         Status: Fix Committed

** Changed in: randgen
       Status: New => Fix Committed

** Changed in: randgen
   Importance: Undecided => Low

** Changed in: randgen
     Assignee: (unassigned) => Patrick Crews (patrick-crews)

** Changed in: randgen
   Importance: Low => Medium

-- 
You received this bug notification because you are a member of Random
Query Generator Team, which is subscribed to Random Query Generator.
https://bugs.launchpad.net/bugs/961630

Title:
  inconsistent table name quoting by the random data generator

Status in SQL Generator for testing SQL servers (MySQL, JavaDB, PostgreSQL):
  Fix Committed

Bug description:
  The random data generator is inconsistent in how it quotes table names:
  Note the DROP TABLE and INSERT statements vs. the CREATE TABLE and ALTER TABLE statements.

  DROP TABLE /*! IF EXISTS*/ c;
  CREATE TABLE `c` (
  `col_char_255` char(255),
  ALTER TABLE `c` DISABLE KEYS;
  INSERT /*! IGNORE */ INTO c VALUES ('k', 'j', 'jcszxwbj', NULL, -656211968, 'r', 'cszxwb', 'TTNNK', -1458634752, NULL, 'l', 2, 'szxwbjj') ;
  COMMIT;
  ALTER TABLE `c` ENABLE KEYS;

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