[JIRA] Commented: (NXP-5689) VCS: store PostgreSQL fulltext in clear text
[
https://jira.nuxeo.com/browse/NXP-5689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=107103#comment-107103
]
Florent Guillaume commented on NXP-5689:
Fixing this error appearing since PostgreSQL 9.1:
{noformat}
java.sql.SQLException: Error post creating table: CREATE INDEX
fulltext_fulltext_idx ON fulltext USING GIN(NX_TO_TSVECTOR(fulltext)) :
ERROR: functions in index expression must be marked IMMUTABLE
{noformat}
http://hg.nuxeo.org/nuxeo/nuxeo-core/rev/ae616fa13c67
VCS: store PostgreSQL fulltext in clear text
Key: NXP-5689
URL: https://jira.nuxeo.com/browse/NXP-5689
Project: Nuxeo Enterprise Platform
Issue Type: Improvement
Components: Core SQL Storage
Affects Versions: 5.3.2
Environment: PostgreSQL
Reporter: Florent Guillaume
Assignee: Florent Guillaume
Priority: Major
Fix For: 5.5
Attachments: tsvector_to_text.sql.txt
We must store the fulltext columns (simpletext, binarytext, fulltext) in
clear text instead of in a tsvector.
This is needed to:
- allow LIKE-based matches on the text (NXP-5450),
- allow reindexing with a different analyzer without re-extracting all the
text from the documents.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
___
ECM-tickets mailing list
ECM-tickets@lists.nuxeo.com
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
[JIRA] Commented: (NXP-8001) querying for complex types and ordering is failing
[
https://jira.nuxeo.com/browse/NXP-8001?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=107104#comment-107104
]
Florent Guillaume commented on NXP-8001:
I just made an additional fix to make your query legal, the code was overly
restrictive when no wildcards were involved.
http://hg.nuxeo.org/nuxeo/nuxeo-core/rev/2853b482b0e6
And your second query works as well.
querying for complex types and ordering is failing
--
Key: NXP-8001
URL: https://jira.nuxeo.com/browse/NXP-8001
Project: Nuxeo Enterprise Platform
Issue Type: Bug
Components: Core SQL Storage
Affects Versions: 5.5-SNAPSHOT
Reporter: Stéphane Lacoin
Assignee: Florent Guillaume
Priority: Major
Fix For: 5.5
Cannot execute queries with constraints on complex types and with an ordering
clause. The generated SQL statements is not correct. The ordering field is
not included in the output fields, but it's required (on PostgreSQL at least)
when there's a {{DISTINCT}}.
{code}
SELECT * from Document where ecm:isProxy = 0 and content/name =
'testfile.txt' ORDER BY dc:title
{code}
{noformat}
SELECT DISTINCT HIERARCHY.ID AS _C1
FROM HIERARCHY
JOIN HIERARCHY _H1 ON HIERARCHY.ID = _H1.PARENTID
LEFT JOIN CONTENT _F1 ON _H1.ID = _F1.ID
LEFT JOIN DUBLINCORE _F2 ON HIERARCHY.ID = _F2.ID
WHERE HIERARCHY.PRIMARYTYPE IN ('Document', '...')
AND _F1.NAME = 'testfile.txt'
AND _H1.NAME = 'content'
ORDER BY _F2.TITLE
{noformat}
{noformat}
ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
{noformat}
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
___
ECM-tickets mailing list
ECM-tickets@lists.nuxeo.com
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
[JIRA] Updated: (NXP-8036) Make DashBoardItem and Task translation system more consitent
[ https://jira.nuxeo.com/browse/NXP-8036?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thierry Delprat updated NXP-8036: - Status: Open (was: Triage) Make DashBoardItem and Task translation system more consitent - Key: NXP-8036 URL: https://jira.nuxeo.com/browse/NXP-8036 Project: Nuxeo Enterprise Platform Issue Type: Improvement Reporter: Thierry Delprat Assignee: Thierry Delprat Fix For: 5.5 Tasks and DashboardItems has inconsitent translation systems : - sometimes the Name = Label translation is done in the template (single_tasks_widget_template.xhtml) - sometimes the Name = Label is done in the Automation Operation - looks like is was partially done inside JBPMTaskInstances before This ends up in inconsitencies between the JSF Dashboard and the OpenSocial Dashboard. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira ___ ECM-tickets mailing list ECM-tickets@lists.nuxeo.com http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
[JIRA] Created: (NXP-8036) Make DashBoardItem and Task translation system more consitent
Make DashBoardItem and Task translation system more consitent - Key: NXP-8036 URL: https://jira.nuxeo.com/browse/NXP-8036 Project: Nuxeo Enterprise Platform Issue Type: Improvement Reporter: Thierry Delprat Assignee: Thierry Delprat Fix For: 5.5 Tasks and DashboardItems has inconsitent translation systems : - sometimes the Name = Label translation is done in the template (single_tasks_widget_template.xhtml) - sometimes the Name = Label is done in the Automation Operation - looks like is was partially done inside JBPMTaskInstances before This ends up in inconsitencies between the JSF Dashboard and the OpenSocial Dashboard. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira ___ ECM-tickets mailing list ECM-tickets@lists.nuxeo.com http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
[JIRA] Created: (NXP-8037) Theme is broken when hot reloading Studio config from Update center
Theme is broken when hot reloading Studio config from Update center --- Key: NXP-8037 URL: https://jira.nuxeo.com/browse/NXP-8037 Project: Nuxeo Enterprise Platform Issue Type: Bug Affects Versions: 5.5-SNAPSHOT Reporter: Alain Escaffre Fix For: 5.5-SNAPSHOT When hot reloading the Studio configuration, the theme is broken, see attached screenshot. (in the reproduction case, the studio plugin doesn't override the theme). -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira ___ ECM-tickets mailing list ECM-tickets@lists.nuxeo.com http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
[JIRA] Updated: (NXP-8037) Theme is broken when hot reloading Studio config from Update center
[ https://jira.nuxeo.com/browse/NXP-8037?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alain Escaffre updated NXP-8037: Attachment: Capture d’écran 2011-12-04 à 23.57.59.png Theme is broken when hot reloading Studio config from Update center --- Key: NXP-8037 URL: https://jira.nuxeo.com/browse/NXP-8037 Project: Nuxeo Enterprise Platform Issue Type: Bug Affects Versions: 5.5-SNAPSHOT Reporter: Alain Escaffre Fix For: 5.5 Attachments: Capture d’écran 2011-12-04 à 23.57.59.png When hot reloading the Studio configuration, the theme is broken, see attached screenshot. (in the reproduction case, the studio plugin doesn't override the theme). -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira ___ ECM-tickets mailing list ECM-tickets@lists.nuxeo.com http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
[JIRA] Updated: (NXP-8037) 5.
[ https://jira.nuxeo.com/browse/NXP-8037?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alain Escaffre updated NXP-8037: Priority: Blocker (was: Minor) Fix Version/s: (was: 5.5-SNAPSHOT) 5.5 Summary: 5. (was: Theme is broken when hot reloading Studio config from Update center) 5. -- Key: NXP-8037 URL: https://jira.nuxeo.com/browse/NXP-8037 Project: Nuxeo Enterprise Platform Issue Type: Bug Affects Versions: 5.5-SNAPSHOT Reporter: Alain Escaffre Priority: Blocker Fix For: 5.5 Attachments: Capture d’écran 2011-12-04 à 23.57.59.png When hot reloading the Studio configuration, the theme is broken, see attached screenshot. (in the reproduction case, the studio plugin doesn't override the theme). -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira ___ ECM-tickets mailing list ECM-tickets@lists.nuxeo.com http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
[JIRA] Updated: (NXP-8037) Theme is broken when hot reloading Studio config from Update center
[ https://jira.nuxeo.com/browse/NXP-8037?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alain Escaffre updated NXP-8037: Summary: Theme is broken when hot reloading Studio config from Update center (was: 5.) Theme is broken when hot reloading Studio config from Update center --- Key: NXP-8037 URL: https://jira.nuxeo.com/browse/NXP-8037 Project: Nuxeo Enterprise Platform Issue Type: Bug Affects Versions: 5.5-SNAPSHOT Reporter: Alain Escaffre Priority: Blocker Fix For: 5.5 Attachments: Capture d’écran 2011-12-04 à 23.57.59.png When hot reloading the Studio configuration, the theme is broken, see attached screenshot. (in the reproduction case, the studio plugin doesn't override the theme). -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira ___ ECM-tickets mailing list ECM-tickets@lists.nuxeo.com http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
