[CALCITE-6652] RelDecorrelator can't decorrelate query with limit 1 #14800

Job	Run time
Linux (JDK 8, oldest Guava, America/New_York Timezone)	0s
Windows (JDK 21)	0s
Windows (JDK 8)	0s
Windows (JDK 17)	0s
Linux (JDK 21)	0s
Linux (JDK 17)	0s
Linux (JDK 11, Pacific/Chatham Timezone)	0s
Linux (JDK 8, latest Guava, America/New_York Timezone)	0s
Linux (JDK 11, Avatica main)	0s
ErrorProne (JDK 11, latest Guava)	0s
CheckerFramework (JDK 11)	11m 11s
CheckerFramework (JDK 11, oldest Guava)	11m 31s
Linux (JDK 23)	0s
macOS (JDK 21)	0s
Druid Tests	0s
Linux (JDK 8) Slow Tests	0s
	22m 42s

Provide feedback