0000660: Crash on querying meta/system tables

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0000660

[NexusDB] SQL Engine

crash

always

2010-07-07 15:50

2010-09-03 13:31

Reporter

Eivind

View Status

public

Assigned To

hdanzl

Priority

normal

Resolution

fixed

Status

closed

Product Version

V3.0401 Release

Summary

0000660: Crash on querying meta/system tables

Description

SELECT TABLE_NAME AS TableName
FROM #Tables
INNER JOIN $SQL$TRIGGERS
ON Name = #Tables.TABLE_NAME + 'Trigger'
WHERE SUBSTRING(TABLE_NAME FROM 1 FOR 1) <> '#' AND TABLE_NAME LIKE '%_Log'
ORDER BY TABLE_NAME;

Additional Information

Attached Files

Relationships

There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2010-07-07 15:50	Eivind	New Issue
2010-07-07 15:50	Eivind	Status	new => assigned
2010-07-07 15:50	Eivind	Assigned To	=> hdanzl
2010-07-07 15:51	Eivind	Severity	minor => crash
2010-07-29 15:44	hdanzl	Status	assigned => QA Testing
2010-07-29 15:44	hdanzl	Resolution	open => fixed
2010-07-29 15:44	hdanzl	Fixed in Version	=> V3.05 Release
2010-07-29 15:44	hdanzl	Target Version	=> V3.05 Release
2010-09-03 13:31	hdanzl	Status	QA Testing => closed

Mantis 1.1.0a3[^]

36 total queries executed.
32 unique queries executed.