View Issue Details

IDProjectCategoryView StatusLast Update
0034511FPCDatabasepublic2018-11-06 14:47
ReporterWim van den BosAssigned ToLacaK 
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
PlatformWindows 64bitOSWindowsOS Version7
Product Version3.0.4Product Build 
Target VersionFixed in Version3.3.1 
Summary0034511: Postgres package can not cope with schema's enclose in ""
DescriptionUsing a TSQLQuery whith SQL being:
SELECT * FROM link5_2data1;
works, but it resides in the public schema
I tried to use a schema
SELECT * FROM "schema_name".link5_2data1;
Then I got an error (" is going wrong in the parser)
See Uploaded screenshot in zip
Steps To ReproduceMake a Form with a connection, transaction and a TSQLQuery.
Bind them together.
Have a SQL like:
SELECT * FROM "schema_name".link5_2data1;
with double quotes
And activate/Open it.
(Project also added in zip)
Btw without quotes is also going wrong.
TagsNo tags attached.
Fixed in Revision40240
FPCOldBugId
FPCTarget
Attached Files

Activities

Wim van den Bos

2018-11-05 11:00

reporter  

project.zip (146,540 bytes)

LacaK

2018-11-06 14:47

developer   ~0111810

Quick fix applied in rev.40240

Issue History

Date Modified Username Field Change
2018-11-05 11:00 Wim van den Bos New Issue
2018-11-05 11:00 Wim van den Bos File Added: project.zip
2018-11-06 07:16 LacaK Assigned To => LacaK
2018-11-06 07:16 LacaK Status new => assigned
2018-11-06 14:47 LacaK Fixed in Revision => 40240
2018-11-06 14:47 LacaK Note Added: 0111810
2018-11-06 14:47 LacaK Status assigned => resolved
2018-11-06 14:47 LacaK Fixed in Version => 3.3.1
2018-11-06 14:47 LacaK Resolution open => fixed