0000205: Queries on error with PostgreSQL

Viewing Issue Advanced Details [ Jump to Notes ]

[ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0000205

[Talend Open Studio] code generation

minor

always

2006-10-19 03:46

2007-05-23 11:14

Reporter

cantoine

View Status

public

Assigned To

Priority

normal

Resolution

fixed

Platform

Status

closed

Projection

none

OS Version

ETA

none

Fixed in Version

1.0.2

Product Version

1.0.0

Target Version

Product Build

Summary

0000205: Queries on error with PostgreSQL

Description

Queries are on error with PostgreSQL, because the Queries are case sensitive, and it appears that PostgreSQL automatically lower-case the column names in queries before running them - even though the columns have mixed-case names.

Steps To Reproduce

Additional Information

Tags

No tags attached.

generated language

workload (in half days)

Attached Files

Relationships

has duplicate

0000307

closed

Postgres and case

Notes
(0000282) cantoine (developer) 2006-11-27 05:41	With postgresql database you can resolve this bug to enclose with " Character theSchema_name, Table_name or Column_name of the SQL request. By example : SELECT "ID_CLIENT" from "Clients"

(0000284) plegall (reporter) 2006-11-27 07:37	Adding double quotes around each column name is an easy task in the insert query of the tDBOutput, it becomes much harder in the free query of the tDBInput. I won't resolve this problem in tDBInput, but only in tDBOuput.

(0000297) plegall (reporter) 2006-11-30 03:53	Fixed for column names in the insert query in branch 1.0 [Subversion, tos] r784 Correction reported on trunk in [Subversion, tos] r785 Warning: the bug was only fixed for column names, not for schema names and table names. If you want to mix upper and lower case characters, you have to double quote names by yourself. Same thing on column names in the tDBInput query which is never parsed by Talend Open Studio.

Issue History
Date Modified	Username	Field	Change
2006-10-19 03:46	cantoine	New Issue
2006-10-19 03:46	cantoine	Status	new => assigned
2006-10-19 03:46	cantoine	Assigned To	=> plegall
2006-10-19 03:47	cantoine	Status	assigned => confirmed
2006-11-27 05:41	cantoine	Note Added: 0000282
2006-11-27 07:37	plegall	Note Added: 0000284
2006-11-30 00:51	plegall	Relationship added	has duplicate 0000307
2006-11-30 03:53	plegall	Note Added: 0000297
2006-11-30 03:53	plegall	Status	confirmed => resolved/needs doc
2006-11-30 03:53	plegall	Resolution	open => fixed
2006-11-30 03:53	plegall	Fixed in Version	=> 1.0.2
2007-05-23 11:14	plegall	Status	resolved/needs doc => closed

Mantis 1.1.6[^]