0000158: postgresql boolean field not recognized by sql_attr_bool

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0000158

[Sphinx] general

minor

always

2008-04-24 19:47

2008-05-22 15:29

Reporter

occulkot

View Status

public

Assigned To

glook

Priority

normal

Resolution

fixed

Status

resolved

Product Version

0.9.8-rc1

Summary

0000158: postgresql boolean field not recognized by sql_attr_bool

Description

Postgres column (BOOLEAN) is not coretly parsed by sphinx.
postgres returns "t" for True and "f" for False - and i guess sphinx is expecting 1 and 0 - as mysqls returns

ive tried:
CASE WHEN is_main THEN 1 ELSE 0 END AS is_main
in sql_query
and its working correctly

sphinx version 0.9.8_rc2 on gentoo

greetings

Additional Information

Tags

No tags attached.

Attached Files

Relationships

Notes
(0000229) glook (developer) 2008-05-22 15:29	fixed in r1281

Issue History
Date Modified	Username	Field	Change
2008-04-24 19:47	occulkot	New Issue
2008-05-22 15:29	glook	Status	new => resolved
2008-05-22 15:29	glook	Resolution	open => fixed
2008-05-22 15:29	glook	Assigned To	=> glook
2008-05-22 15:29	glook	Note Added: 0000229