QoQ HSQLDB: error executing sql statement on query

Hi all,

After updating to we’ve started getting these errors

QoQ HSQLDB: error executing sql statement on query.

data exception: string data, right truncation ; size limit: 32768 table: QCATALOGUEITEMS column: TEXT1

It’s a QoQ joining two other queries.

The same thing is working fine on Lucee

I’d be grateful for any suggestions how to deal with it.

OS: Linux 6.2.0-1009-aws
Java Version: 11.0.7
Lucee Version:

what’s the DDL for the source table?

Both tables are from MS SQL Server

yeah, that’s not very helpful, what I’m asking is what does the column definition look like in sql server?

or share what you get when you dump a getMetaData for the source query

They are quite lengthy, only way I could get them is like this:

And the other one

And the QoQ that’s erroring out is:

	qCatalogueItems.*, qGetStoreProfile.DisplayPreviousPriceYN, qGetStoreProfile.DetailPageBuyIcon, qGetStoreProfile.DetailPageBuyLabel, 
	qGetStoreProfile.ViewLargerIcon, qGetStoreProfile.ViewLargerText, qGetStoreProfile.ListingBuyIcon, qGetStoreProfile.CatalogueItemCode, 
	qGetStoreProfile.Price, qGetStoreProfile.PreviousPrice, qGetStoreProfile.CostPrice, qGetStoreProfile.Tax, qGetStoreProfile.TaxOption, 
	qGetStoreProfile.TaxNote, qGetStoreProfile.ErrorOutOfStockYN, qGetStoreProfile.ErrorNotOnSaleYN, qGetStoreProfile.PreviousPricingLabel, 
	qGetStoreProfile.CurrentPricingLabel, qGetStoreProfile.TaxDisplayLabel, qGetStoreProfile.CatalogueAttributeProfileCode, 
	qGetStoreProfile.DynamicBasketForModifiersYN, qGetStoreProfile.StockLevel, qGetStoreProfile.ShippingStatus, qGetStoreProfile.EnableSubscriptionYN, 
	qGetStoreProfile.ShowStockLevelYN, qGetStoreProfile.CatalogueID, qGetStoreProfile.CatalogueISBN, qGetStoreProfile.CatalogueASIN, qGetStoreProfile.CatalogueASIN, 
	qGetStoreProfile.CatalogueEAN, qGetStoreProfile.CatalogueUPC, qGetStoreProfile.CatalogueGTIN, qGetStoreProfile.InventoryYN, qGetStoreProfile.StockLevelText, 
	qGetStoreProfile.PriceNote, qGetStoreProfile.eCommerceSetup, qGetStoreProfile.CurrencyCode, qGetStoreProfile.PrimaryCurrencyCode, qGetStoreProfile.SpecialOfferYN, 
	qGetStoreProfile.SpecialOfferImage, qGetStoreProfile.MaxQuantityLimit 
FROM qCatalogueItems, qGetStoreProfile

I appreciate you looking into it. Do you need any more information?

Hi all, is there any update on this one?

What’s the current thinking?

I would download and try the latest version and or come through the change log of the RC and beta versions if this is a concern.

please try