View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001413 | Database Comparer utility | General | public | 2018-05-31 14:41 | 2019-04-18 19:46 |
| Reporter | shirokov | Assigned To | barry | ||
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 7.0.0.1670 | ||||
| Target Version | 7.0.0.1670 | ||||
| Summary | 0001413: Firebird 2.6 SQL LIST ALL and DISTINCT cause the parsing error | ||||
| Description | Firebird 2.6 list(distinct np.narocilo_pozicija_id, '#') or list(all np.narocilo_pozicija_id, '#') throws an error when comparing sql procedures. list(np.narocilo_pozicija_id, '#') works ok. Screenshots and the sample script are attached. | ||||
| Tags | No tags attached. | ||||
|
|
SAMPLE.sql (1,654 bytes)
/******************************************************************************/
/**** Generated by IBExpert 2018.4.1.1 30.5.2018 8:48:34 ****/
/******************************************************************************/
SET SQL DIALECT 3;
SET NAMES WIN1250;
/******************************************************************************/
/**** Stored procedures ****/
/******************************************************************************/
SET TERM ^ ;
CREATE PROCEDURE SAMPLE
RETURNS (
FIELD1 INTEGER,
FIELD2 INTEGER,
LIST_FIELD3 VARCHAR(550))
AS
BEGIN
SUSPEND;
END^
SET TERM ; ^
/******************************************************************************/
/**** Tables ****/
/******************************************************************************/
CREATE TABLE X (
FIELD1 INTEGER,
FIELD3 INTEGER,
FIELD2 INTEGER
);
/******************************************************************************/
/**** Stored procedures ****/
/******************************************************************************/
SET TERM ^ ;
ALTER PROCEDURE SAMPLE
RETURNS (
FIELD1 INTEGER,
FIELD2 INTEGER,
LIST_FIELD3 VARCHAR(550))
AS
begin
for select sum(FIELD1), FIELD2, list(all FIELD3, '#') from X
group by FIELD2
into :FIELD1, :FIELD2, :LIST_FIELD3
do
suspend;
end^
SET TERM ; ^
|
|
|
7.0.0.1671 |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-05-31 14:41 | shirokov | New Issue | |
| 2018-05-31 14:41 | shirokov | Status | new => assigned |
| 2018-05-31 14:41 | shirokov | Assigned To | => barry |
| 2018-05-31 14:41 | shirokov | File Added: image001.png | |
| 2018-05-31 14:41 | shirokov | File Added: image002.png | |
| 2018-05-31 14:41 | shirokov | File Added: SAMPLE.sql | |
| 2018-06-01 00:23 | barry | Status | assigned => resolved |
| 2018-06-01 00:23 | barry | Resolution | open => fixed |
| 2018-06-01 00:23 | barry | Note Added: 0003736 | |
| 2019-04-18 19:46 | barry | Status | resolved => closed |
