View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001303 | Database Workbench v5 | InterBase Module | public | 2015-10-21 20:17 | 2015-10-27 14:46 |
| Reporter | Arno Brinkman | Assigned To | Martijn Tonies | ||
| Priority | high | Severity | major | Reproducibility | sometimes |
| Status | closed | Resolution | fixed | ||
| Product Version | 5.1.6 | ||||
| Fixed in Version | 5.1.8 | ||||
| Summary | 0001303: InterBase dialect 1 database select statements fail with Assertion | ||||
| Description | Assertion failure (E:\Developing\Projects\Database Workbench v5\DBSpecific\InterBase\Connectivity\uDBW_InterBaseProfiler_IBDAC.pas, line 188) Selecting from tables/SP's returns very often with error. | ||||
| Steps To Reproduce | - Create dialect 1 database (i used page-size 8192, charset NONE) - run this script: CREATE TABLE TESTTABLE ( F0 INTEGER DEFAULT 0 NOT NULL, F1 SMALLINT DEFAULT 0 NOT NULL, F2 SMALLINT DEFAULT 0 NOT NULL, F3 SMALLINT DEFAULT 0 NOT NULL, F4 SMALLINT DEFAULT 0 NOT NULL, F5 SMALLINT DEFAULT 0 NOT NULL, F6 SMALLINT DEFAULT 1 NOT NULL, F7 SMALLINT DEFAULT 0 NOT NULL, F8 VARCHAR( 2) COLLATE NONE, F9 SMALLINT DEFAULT 0 NOT NULL, F10 SMALLINT DEFAULT 0 NOT NULL, F11 SMALLINT DEFAULT 0 NOT NULL, F12 SMALLINT DEFAULT 0 NOT NULL, F13 INTEGER DEFAULT 0 NOT NULL, CONSTRAINT PK_TESTTABLE PRIMARY KEY (F0) ) ; COMMIT; /* TESTTABLE --------- Exporting all rows */ INSERT INTO TESTTABLE (F0, F1, F2, F3, F4, F5, F6, F7, F8, F9, F10, F11, F12, F13) VALUES (2, 2, 1, 1, 1, 2, 1, 0, '', 1, 1, 50, 0, 536870911); INSERT INTO TESTTABLE (F0, F1, F2, F3, F4, F5, F6, F7, F8, F9, F10, F11, F12, F13) VALUES (3, 3, 1, 3, 3, 2, 0, 0, '', 1, 1, 10, 0, 536870911); INSERT INTO TESTTABLE (F0, F1, F2, F3, F4, F5, F6, F7, F8, F9, F10, F11, F12, F13) VALUES (4, 4, 1, 3, 3, 2, 0, 0, '', 1, 1, 25, 0, 536870911); INSERT INTO TESTTABLE (F0, F1, F2, F3, F4, F5, F6, F7, F8, F9, F10, F11, F12, F13) VALUES (5, 5, 1, 1, 1, 1, 0, 0, '', 1, 5, 0, 0, 536870911); INSERT INTO TESTTABLE (F0, F1, F2, F3, F4, F5, F6, F7, F8, F9, F10, F11, F12, F13) VALUES (6, 6, 1, 3, 3, 2, 0, 0, '', 1, 6, 0, 0, 536870911); /* 5 row(s) exported */ COMMIT; - SELECT * FROM TESTTABLE | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2015-10-21 20:17 | Arno Brinkman | New Issue | |
| 2015-10-22 10:48 | Martijn Tonies | Assigned To | => Martijn Tonies |
| 2015-10-22 10:48 | Martijn Tonies | Status | new => acknowledged |
| 2015-10-27 10:06 | Martijn Tonies | Status | acknowledged => assigned |
| 2015-10-27 12:37 | Martijn Tonies | Status | assigned => resolved |
| 2015-10-27 12:37 | Martijn Tonies | Fixed in Version | => 5.1.8 |
| 2015-10-27 12:37 | Martijn Tonies | Resolution | open => fixed |
| 2015-10-27 14:46 | Martijn Tonies | Status | resolved => closed |
