0005380: Invalid LEFT JOIN syntax for Oracle - MantisBT

MantisBT

View Issue Details [ Jump to Notes ] [ Wiki ]

[ Issue History ] [ Print ]

ID

Project

Category

View Status

Date Submitted

Last Update

0005380

mantisbt

sql

public

2005-03-23 16:06

2005-04-18 10:40

Reporter

zariok

Assigned To

thraxisp

Priority

normal

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS

OS Version

Product Version

git trunk

Target Version

Fixed in Version

1.0.0a1

Summary

0005380: Invalid LEFT JOIN syntax for Oracle

Description

There are several places within the code with invalid LEFT JOIN syntax.

Example:

LEFT JOIN a AS sudo ON b.id = sudo.id

*SHOULD BE*

LEFT JOIN a sudo ON b.id = sudo.id

Additional Information

Quick cursory look for files affected:

admin/upgrades/0_18_inc.php:627
core/filter_api.php:496
core/filter_api.php:525
core/filter_api.php:527
core/filter_api.php:555
core/custom_field_api.php:781
core/bugnote_api.php:305

Tags

No tags attached.

Relationships

has duplicate

closed

Unknown column p.field_id when closing bug when using MySQL >= 5.0.12

Notes
(0009656) thraxisp (manager) 2005-03-23 21:55	Fixed in CVS

Issue History
Date Modified	Username	Field	Change
2005-03-23 16:06	zariok	New Issue
2005-03-23 17:47	thraxisp	Assigned To	=> thraxisp
2005-03-23 17:47	thraxisp	Status	new => assigned
2005-03-23 21:55	thraxisp	Status	assigned => resolved
2005-03-23 21:55	thraxisp	Fixed in Version	=> 1.0.0rc1
2005-03-23 21:55	thraxisp	Resolution	open => fixed
2005-03-23 21:55	thraxisp	Note Added: 0009656
2005-04-18 10:40	vboctor	Status	resolved => closed
2006-04-17 21:50	thraxisp	Relationship added	has duplicate 0006394

MantisBT 1.2.16dev master-1.2.x-05091f5 [^]

Copyright © 2000 - 2013 MantisBT Team

Time: 0.0608 seconds.
memory usage: 2,797 KB