0000004: Wishlist - more detail on error output, ability to control error output

Viewing Issue Simple Details [ Jump to Notes ]

[ << ] [ >> ]

[ View Advanced ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0000004

[qot] general

feature

always

2008-04-30 17:41

2008-06-15 16:19

Reporter

anonymous

View Status

public

Assigned To

administrator

Priority

normal

Resolution

open

Status

confirmed

Product Version

0.0.3

Summary

0000004: Wishlist - more detail on error output, ability to control error output

Description

This is against 0.0.3.

I have a large schema file which is basically a mysqldump without data. Once I add the CREATE DATABASE and USE statements, qot reads it in and uses it, but it prints out some errors:
error syntax error, unexpected IDENT_QUOTED, expecting ')' met

1. I would like to request that the syntax error output also print the line number (if that info is available, if it's just in a struct and parsed char-by-char, then probably not and it's not worth keeping track of that info).

2. I would like to request a -q option to quiet error output or wrap it with /* */.

Additional Information

In regards to 0000002, when I find a common query that's based on fairly static data and a large covering query would help performance, I redirect the output of qot to a temp sql file, then I import that into the database. The presence of that error output means I have to grep it out.

Tags

No tags attached.

Attached Files

Relationships

Notes
(0000009) administrator (administrator) 2008-04-30 23:21	regarding the 2nd point - I think that should rather be handled by the output mode, e.g. in sql mode all errors (as well as all other non-sql output) will be printed in comments. Also I think all the errors should be printed always (as opposed to current state when they are printed as a part of the --info output)

(0000016) administrator (administrator) 2008-06-15 16:19	in version 0.0.4 error output out-of-comments in SQL mode is fixed.

Issue History
Date Modified	Username	Field	Change
2008-04-30 17:41	anonymous	New Issue
2008-04-30 17:53	mrballcb	Issue Monitored: mrballcb
2008-04-30 23:21	administrator	Note Added: 0000009
2008-04-30 23:21	administrator	Assigned To	=> administrator
2008-04-30 23:21	administrator	Status	new => confirmed
2008-04-30 23:21	administrator	version	0.0.2 => 0.0.3
2008-06-15 16:19	administrator	Note Added: 0000016

Mantis 1.1.1[^]

Upload File
Select File (Max size: 5,000k)