Package dev.frostlake.demo

Class LateralJoinDemo

java.lang.Object

dev.frostlake.demo.AbstractDemo

dev.frostlake.demo.LateralJoinDemo

public class LateralJoinDemo
extends AbstractDemo

Demonstration of LATERAL JOIN functionality in Frostlake SQL Engine LATERAL allows subqueries to reference columns from the outer query, enabling correlated subqueries in the FROM clause.

Field Summary

Fields inherited from class dev.frostlake.demo.AbstractDemo

engine

Constructor Summary

Constructors

Constructor	Description
LateralJoinDemo()

Method Summary

Modifier and Type	Method	Description
protected String	getDemoTitle()	Get the demo title to display at the start
protected int	getMaxDisplayRows()	Get maximum number of rows to display in result sets Subclasses can override to show more or fewer rows
static void	main(String[] args)
protected void	runDemo()	Main entry point - subclasses should implement this to define their demo logic

Methods inherited from class dev.frostlake.demo.AbstractDemo

execute, getRowCount, printQuery, printResultSet, printResultSet, printSectionHeader, printSeparator, printSubsection, printSuccess, printTable, printTitle, setup, setupDatabase, shutdown

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

LateralJoinDemo

public LateralJoinDemo()

Method Details

main

public static void main(String[] args)

getDemoTitle

protected String getDemoTitle()

Description copied from class: AbstractDemo

Get the demo title to display at the start

Specified by:

getDemoTitle in class AbstractDemo

Returns:

the title AbstractDemo.execute() prints before running the demo

runDemo

protected void runDemo()
                throws Exception

Description copied from class: AbstractDemo

Main entry point - subclasses should implement this to define their demo logic

Specified by:

runDemo in class AbstractDemo

Throws:

Exception - if any demo step fails; AbstractDemo.execute() reports it and still shuts down

getMaxDisplayRows

protected int getMaxDisplayRows()

Description copied from class: AbstractDemo

Get maximum number of rows to display in result sets Subclasses can override to show more or fewer rows

Overrides:

getMaxDisplayRows in class AbstractDemo

Returns:

the row display cap, 100 unless overridden