0000015: BOOLEAN columns are not supported

Viewing Issue Simple Details [ Jump to Notes ]

[ << ] [ >> ]

[ View Advanced ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0000015

[qot] general

minor

always

2009-02-08 13:31

2009-02-16 18:09

Reporter

philipp_t

View Status

public

Assigned To

administrator

Priority

normal

Resolution

fixed

Status

resolved

Product Version

0.0.4

Summary

0000015: BOOLEAN columns are not supported

Description

If I extend the example table "orders" with a BOOLEAN column called "shipped" and execute the following query
qot --input-file=schema.sql --input-query="SELECT count(*) FROM orders WHERE shipped=0;" --info
I get a segmentation fault.

Changing the column's type to INT resolves the problem.

By the way: Might it be easier to read the database structure from the database directly instead of parsing the schema file? It seems to me that there's an awful lot that can go wrong when parsing this stuff...

Philipp

Additional Information

CREATE SCHEMA qot_test;

USE qot_test;

CREATE TABLE clients (
  id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  first_name VARCHAR(255),
  last_name VARCHAR(255));

CREATE TABLE orders (
  id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  client_id INT NOT NULL,
  entity VARCHAR(255),
  amount INT NOT NULL,
  total INT NOT NULL,
  shipped BOOLEAN);

Tags

No tags attached.

Attached Files

Relationships

Notes
(0000094) administrator (administrator) 2009-02-16 16:41	Thanks for the report!

(0000095) administrator (administrator) 2009-02-16 18:09	Fix is pushed to lp:qot. As in MySQL the BOOLEAN type is treated as an alias for TINYINT

Issue History
Date Modified	Username	Field	Change
2009-02-08 13:31	philipp_t	New Issue
2009-02-16 16:35	administrator	Status	new => assigned
2009-02-16 16:35	administrator	Assigned To	=> administrator
2009-02-16 16:41	administrator	Note Added: 0000094
2009-02-16 16:41	administrator	Status	assigned => confirmed
2009-02-16 18:09	administrator	Status	confirmed => resolved
2009-02-16 18:09	administrator	Fixed in Version	=> lp:qot
2009-02-16 18:09	administrator	Resolution	open => fixed
2009-02-16 18:09	administrator	Note Added: 0000095

Mantis 1.1.1[^]