[gcormier]

I think there’s a bug in the Generate SQL command when you right click on a table. Say we have a table

C REATE TABLE ME_TEST (
  NUMBER ID NOT NULL,
  NAME VARCHAR2(32) DEFAULT '');

This creates a simple table with a default empty string.

When you “Generate SQL” on this table, it looks like ME is escaping the single quotes so you get

C REATE TABLE ME_TEST (
  NUMBER ID NOT NULL,
  NAME VARCHAR2(32) DEFAULT '''');

Which is setting the default to.. well…. it’s setting the default value to a single quote.

ps. Bug in phpBB… I had to mess up the CREATE keyword or I get an error “Cannot access /index.php”

[Riyad Kalla]

Thank you for the report, that does infact look wonky.

[Author]

Posts