Are there known regressions with QoQ in 5.4.0.80? ...
# luceeh
harryk
06/28/2023, 1:15 PMAre there known regressions with QoQ in 5.4.0.80? I encountered an issue and will report the Bug soon in detail
harryk
06/28/2023, 1:18 PMSelect fields from query1, query2
Where query1.field = query2.field
doesn’t work anymore
z
zackster
06/28/2023, 2:14 PMwe had to upgrade the hsqldb engine to 2.7.2, which handles all the multi table stuff, native qoq only works on a single table
zackster
06/28/2023, 2:14 PMdue to CVEs
zackster
06/28/2023, 2:14 PMcan you knock out an example on trycf?
zackster
06/28/2023, 2:17 PMwhat's the error? i.e. stack
h
harryk
06/28/2023, 3:26 PMSo this code works in Lucee 5.3.10.120 but not in 5.4.0.80 and also not in Lucee 6.0.0-SNAPSHOT+451 (beta):
https://trycf.com/gist/ac722c80e79fc55e332699fb657f0efd/lucee6-beta?theme=monokai
harryk
06/28/2023, 3:27 PMQoQ HSQLDB: error executing sql statement on query
incompatible data type in operation
see stack on trycf.com
z
zackster
06/28/2023, 3:29 PMzackster
06/28/2023, 3:29 PMthat i can fix, we aren't mapping bit to int
zackster
06/28/2023, 3:30 PMfile a bug 🙂
zackster
06/28/2023, 3:40 PM2 ain't a bit value is it
h
harryk
06/28/2023, 3:59 PMSo I found the issue, the problem is that if I use 2 queries and one query has a bit field it crashes
If I remove this bit field and copy the values to a integer field it works
harryk
06/28/2023, 4:06 PM