View Issue Details

IDProjectCategoryView StatusLast Update
0002159Database Workbench v6Visual Query Builderpublic2023-09-23 12:55
ReporterPål Lillejord Assigned ToMartijn Tonies  
PrioritynormalSeveritymajorReproducibilityalways
Status assignedResolutionopen 
Product Version6.3.0 
Summary0002159: Visual query builder fail boolean field/values
DescriptionFail with error message when open, both with boolean in select and in where clause
Steps To ReproduceWrite
      select * from SEC$USERS where SEC$ADMIN
if try to open VQB it state error:
  Invalid SELECT statement.
   Unexpected token "EOF" at line 1, pos 41
same
select RDB$PROCEDURE_NAME , RDB$PROCEDURE_OUTPUTS = 0 as proc from RDB$PROCEDURES
  Invalid SELECT statement.
 Unexpected token "=" at line 1, pos 52
TagsNo tags attached.

Activities

Martijn Tonies

2023-09-07 09:54

administrator   ~0000590

What DBMS is this, Firebird or InterBase?

Pål Lillejord

2023-09-23 12:55

reporter   ~0000593

this is Firebird

Issue History

Date Modified Username Field Change
2023-09-06 08:13 Pål Lillejord New Issue
2023-09-07 09:54 Martijn Tonies Assigned To => Martijn Tonies
2023-09-07 09:54 Martijn Tonies Status new => feedback
2023-09-07 09:54 Martijn Tonies Note Added: 0000590
2023-09-23 12:55 Pål Lillejord Note Added: 0000593
2023-09-23 12:55 Pål Lillejord Status feedback => assigned