t.sh

application/x-shellscript

Filename: t.sh

Type: application/x-shellscript

Part: 0

Message: Optimization issue of branching UNION ALL

#!/bin/bash

echo "EXPLAIN" > test.sql

echo "SELECT 1,1" >> test.sql
for i in {1..15000}
do
  echo "  UNION ALL" >> test.sql
  echo "SELECT $i,$i" >> test.sql
done
echo ";" >> test.sql