- Anonymous
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0007493 | VALENTINA STUDIO | Tool - Schema Editor | public | 2016-02-16 18:16 | 2016-02-22 17:51 |
| Reporter | Sergio Zordan | Assigned To | Sergey Pashkov | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Platform | Intel | OS | Windows | OS Version | 10 |
| Product Version | 6.3.x | ||||
| Target Version | 6.3.x | Fixed in Version | 6.3.x | ||
| Summary | 0007493: Generate SQL: problem with default values | ||||
| Description | If you make a right click on a table in the schema editor, and select "Generate SQL" -> "Create...", the resulting SQL has a glitch on the DEFAULT values: the numeric values are treated as character, like in the following example. CREATE TABLE "public"."table_name" ( "cd_field" Integer NOT NULL, "dt_field" Date NOT NULL, "nr_field" Numeric( 6, 2 ) DEFAULT '0', <--- ... | ||||
| Tags | No tags attached. | ||||
| Working with DB: | postgreSQL Server | ||||
| Version of your DB: | 9.4 | ||||
 |
As a side note, also the FOREIGN KEYs are missing from the create statement. |
 |
Fixed in the version 6.3.2. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-02-16 18:16 | Sergio Zordan | New Issue | |
| 2016-02-16 18:27 | Sergio Zordan | Note Added: 0008805 | |
| 2016-02-17 08:42 | Sergey Pashkov | Assigned To | => Sergey Pashkov |
| 2016-02-17 08:42 | Sergey Pashkov | Status | new => assigned |
| 2016-02-22 17:51 | Sergey Pashkov | Note Added: 0008822 | |
| 2016-02-22 17:51 | Sergey Pashkov | Status | assigned => resolved |
| 2016-02-22 17:51 | Sergey Pashkov | Resolution | open => fixed |
| 2016-02-22 17:51 | Sergey Pashkov | Product Version | => 6.3.x |
| 2016-02-22 17:51 | Sergey Pashkov | Fixed in Version | => 6.3.x |
| 2016-02-22 17:51 | Sergey Pashkov | Target Version | => 6.3.x |