Upgrade to SqlLine 1.9 once it is released (https://github.com/julianhyde/sqlline/issues/350).
1. Add SqlLine properties:
connectInteractionMode: useNPTogetherOrEmpty - supports connection mehanism used in SqlLine 1.17 and earlier:
a. if user and password are not indicated, connects without them (user and password are set t empty string): ./drill-embedded
b. if user is indicated, asks for password in interactive mode: ./drill-embedded -n "user1"
c. if user is indicated as empty string, behaives like in point a (user and password are set t empty string): ./drill-embedded -n ""
d. if user and password are indicated, connects using provided input ./drill-embedded -n "user1" -p "123"
showLineNumbers: true - adds line numbers when query is more than one line:
2. Remove nohup support code from sqlline.sh since it is not needed any more (nohup support wroks without flag):
3. Add -Dorg.jline.terminal.dumb=true to avoid JLine terminal warning when submitting query in sqlline.sh to execute via -e or -f:
4. Remove unneeded echo commands in sqlline.bat during start up: