Development

#557 (Propel generated SQL not used in Postgresql)

You must first sign up to be able to contribute.

Ticket #557 (closed defect: fixed)

Opened 2 years ago

Last modified 2 years ago

Propel generated SQL not used in Postgresql

Reported by: kiryu tsukimiya Assigned to:
Priority: blocker Milestone: 0.6.3
Component: Version: 0.7.X
Keywords: Cc:
Qualification:

Description

changeset:1336 generate SQL as follows: 

 ... FROM (table A, table B)

PostgreSQL is not allowed this SQL.

What is mean with this changeset?

Change History

05/16/06 18:56:01 changed by anonymous

It's a fix for a compatibility problem with propel and mysql 5.0.13+. Nothing to do with pgsql.

05/17/06 03:30:58 changed by Kiryu Tsukimiya

  • version set to 0.7.X.

PostgreSQL 7.x/8.x 

select * from (foo,bar);
ERROR:  syntax error at or near "," at character 19

SQLServer2000 

select * from (foo,bar);
Line 1: Incorrect syntax near ','.

05/19/06 11:23:35 changed by brujahRg

Confirmed. Seems like this syntax is non-standard. I think the patches to the propel should be reverted before 0.6.3 is released. And some other solution to the askeet-mysql 5.0.13+ compatibility issue can be researched meanwhile. (Thinking of using CROSS JOIN syntax for the cartesian product it may still be not possible either, since for example Oracle only began supporting CROSS JOIN syntax in 9i)

06/09/06 15:16:00 changed by fabien

  • priority changed from minor to blocker.
  • milestone set to 0.6.3.

06/16/06 09:46:47 changed by fabien

  • milestone changed from 0.6.3 to 1.0.0.

06/16/06 09:46:48 changed by fabien

  • milestone changed from 0.6.4 to 0.6.3.

06/16/06 11:17:26 changed by fabien

  • status changed from new to closed.
  • resolution set to fixed.

in r1456