View Incident Report

Minor

Reported By: Grzegorz Rewucki
Reported On: 1/17/2005
For: Version 4.16 Build 1

# 1946 Functions Cannot Be Used as Only Condition in SQL Joins

have problem with SQL joins based on full text indexes. I need to select all contacts containing specified GUID in Contacts.BizonSearch field and for each found contact select post containing ContactGUID in Post.BizonSearch:

The following query generates 11949 SQL parsing error.

select C.DisplayName, P.PostInSign from Contacts C
inner join PostIn P on TextSearch('R'+C.ContactGUID, P.BizonSearch)
where TextSearch('{420C4890-CC04-46E6-9070-5A930F33BEAD}',C.BizonSearch)

Comments

This issue applied to using any function with parameters that represent the join as the sole join condition.

Resolution

Fixed Problem on 1/18/2005 in version 4.17 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap