Update to 23.1.0.089.0929

5 files changed, 125 insertions, 77 deletions

diff --git a/.SRCINFO b/.SRCINFO
index 2088bc497a8a..2d0e755be410 100644
--- a/.SRCINFO
+++ b/.SRCINFO
@@ -1,16 +1,16 @@
 pkgbase = sqlcl
 	pkgdesc = SQL Developer command line interface for Oracle
-	pkgver = 22.2.0.172.1718
+	pkgver = 23.1.0.089.0929
 	pkgrel = 1
-	url = https://oracle.com/database/technologies/appdev/sqlcl.html
+	url = https://www.oracle.com/database/sqldeveloper/technologies/sqlcl
+	changelog = CHANGELOG.md
 	arch = any
 	license = custom
+	depends = bash
 	depends = java-runtime>=8
-	source = sqlcl-22.2.0.172.1718.zip::https://download.oracle.com/otn_software/java/sqldeveloper/sqlcl-22.2.0.172.1718.zip
+	source = sqlcl-23.1.0.089.0929.zip::https://download.oracle.com/otn_software/java/sqldeveloper/sqlcl-23.1.0.089.0929.zip
 	source = sqlcl.sh
-	source = LICENSE
-	sha256sums = eb69022227fec14578e319a398bd20958e94da77b263300ba09af8bd5aac4aa1
+	sha256sums = 093f0d752bd9a497e168b7f3de4a3b68ea977bfe5948e2602ad91dd3a0147568
 	sha256sums = 34c5f2be48639dcd8ec9f38f950916a394ae399a0e583fbde4020acdccf951e0
-	sha256sums = 8f5642d74925ba3a4543c52b7a84b65c18aaa7dd3599c141e72ad5117e748929
 
 pkgname = sqlcl
diff --git a/.gitignore b/.gitignore
index ac4ea5a82839..b2d514f64177 100644
--- a/.gitignore
+++ b/.gitignore
@@ -1,6 +1,6 @@
-pkg
-src
-*.xz
-*.gz
-*.zip
-*.tar.zst
+*
+!.gitignore
+!PKGBUILD
+!.SRCINFO
+!CHANGELOG.md
+!sqlcl.sh
diff --git a/CHANGELOG.md b/CHANGELOG.md
new file mode 100644
index 000000000000..48a956f942dd
--- /dev/null
+++ b/CHANGELOG.md
@@ -0,0 +1,93 @@
+# SQLcl Release Notes 23.1.0.089.0929
+
+## New features in 23.1.0.089.0929
+
+* New features for 22.4.0
+* named connection..
+* 
+
+## New features in 22.3.0
+
+* Introduction of new command framework to standardise commands
+* Rewrite of Liquibase suppport to include all new flags and commands
+* Support for two factor authentication in connections
+* Support for connections to ADBs and ADBd with auto creation of Bastions where needed
+* Upgrade of JDBC Drivers to 21.8.0.0.0
+* Standardised numbering across distributions from ZIPs to RPMs
+
+## Bugs Fixed
+
+### 22.3.0
+
+This is a selection of the bugs fixed in this release, focussing on customers issues, security and usability.
+
+| bug      | Description                                                                    |
+|----------|--------------------------------------------------------------------------------|
+| 34624954 | FIX ALL VERSIONS SO THEY ALL MATCH FROM ZIP TO 'SHOW VERSION' COMMAND          |
+| 34620477 | APEX EXPORT COMMAND TO EXPORT ALL SUPPORTED TYPES. INCLUDES EXPTYPE            |
+| 34619719 | SHOW DATAPUMP - UPDATED TO NEW COMMAND STRUCTURE                               |
+| 34609419 | UPGRADE JDBC & UCP 22.1.0.0.0_220912                                           |
+| 34605409 | VULNERABILITIES CVE-2022-21510/CVE-2022-21511 IN SQLCL 22.2.1.201.1451         |
+| 34484571 | NEW -SOCKSPROXY OPTION NOT DOCUMENTED IN SQLCL USAGE HELP                      |
+| 34453113 | SQLCL UPDATE TO FULLY SUPPORT JDK17                                            |
+| 34432373 | EXTRA KEYWORDS ADDED TO QUERIES WHEN COPY/PASTING THE CODE IN SQLCL            |
+| 34430175 | INSIGHT: FAILING TO BRING UP LIST OF COLUMNS FOR A TABLE, VIA A SYNONYM.       |
+| 34379593 | ALTER SESSION SET CURRENT SCHEMA SQLCL FAIL ON TRYING TO CREATE CHANGE LOG TABLE|
+
+
+# Before You Start
+
+## JRE Support
+
+* SQLcl release 22.2.1 requires Oracle Java version 11 or 17.
+* If SQLcl cannot find a local JRE, you will be prompted to enter the location path for the JRE. Note that the prompt wants only the folder, not the java.exe.  For example C:\Program Files\Java\jdk-11.0.11
+
+## Known Issues
+Invoking SQL Recall for a previous statement which has a line exceeding the width of your display, the in-line editor will be unable to access or edit the line with the overflow. Workaround this issue by resizing your terminal display wide enough to prevent line-wrapping.
+
+## Platform Support
+
+SQLcl release 22.2.1 is available for Windows 10 and Windows Server 2008/2012, Linux or Mac OS X. (See full [Certification] (https://www-sites.oracle.com/database/technologies/appdev/sqldev/certification.html))
+If using a OCI “Thick” connection type, a 21c Oracle Client will be required
+
+
+## Installing or Upgrading
+
+All new releases of SQLcl and SQL Developer require a full installation. Download and unzip the file into an empty folder. Ensure the "Use folder names" checkbox is checked when unzipping the file.
+
+## Support
+Production Releases - you are supported by Oracle Support under your current database Support license for SQL Developer production releases. Log SQL Developer bugs and issues using [My Oracle Support] (http://support.oracle.com/) for the product.
+## Feedback
+There are a number of different forums supporting the features in SQLcl. When using the forums, be sure to use clear subject lines to initiate a thread and try to avoid using old, unrelated threads for a new issue.
+
+For all SQLcl queries, please use the [SQLcl Forum] (https://community.oracle.com/tech/developers/categories/sqlcl)
+
+## SQL*Plus List of Unsupported Commands and Features
+
+### Commands
+
+* REPHEADER
+* REPFOOTER
+*System Variables and Environment Settings via the SET Command*
+
+ * autoprint
+ * autorecovery
+ * cmdsep
+ * copytypecheck
+ * describe
+ * eschar
+ * flagger
+ * flush
+ * fullcolname
+ * logsource
+ * loboffset
+ * markup
+ * recsep* 
+ * recsepchar
+ * shiftinout
+ * sqlcase
+ * sqlprefix
+ * sqlterminator
+ * tab
+ * underline
+ * xmloptimizationcheck
diff --git a/LICENSE b/LICENSE
deleted file mode 100644
index e7952fb824f8..000000000000
--- a/LICENSE
+++ /dev/null
@@ -1,49 +0,0 @@
-Oracle Free Use Terms and Conditions
-
-Definitions
-
-"Oracle" refers to Oracle America, Inc. "You" and "Your" refers to (a) a company or organization (each an "Entity") accessing the Programs, if use of the Programs will be on behalf of such Entity; or (b) an individual accessing the Programs, if use of the Programs will not be on behalf of an Entity. "Program(s)" refers to Oracle software provided by Oracle pursuant to the following terms and any updates, error corrections, and/or Program Documentation provided by Oracle. "Program Documentation" refers to Program user manuals and Program installation manuals, if any. If available, Program Documentation may be delivered with the Programs and/or may be accessed from www.oracle.com/documentation. "Separate Terms" refers to separate license terms that are specified in the Program Documentation, readmes or notice files and that apply to Separately Licensed Technology. "Separately Licensed Technology" refers to Oracle or third party technology that is licensed under Separate Terms and not under the terms of this license.
-
-Separately Licensed Technology
-
-Oracle may provide certain notices to You in Program Documentation, readmes or notice files in connection with Oracle or third party technology provided as or with the Programs. If specified in the Program Documentation, readmes or notice files, such technology will be licensed to You under Separate Terms. Your rights to use Separately Licensed Technology under Separate Terms are not restricted in any way by the terms herein. For clarity, notwithstanding the existence of a notice, third party technology that is not Separately Licensed Technology shall be deemed part of the Programs licensed to You under the terms of this license.
-
-Source Code for Open Source Software
-
-For software that You receive from Oracle in binary form that is licensed under an open source license that gives You the right to receive the source code for that binary, You can obtain a copy of the applicable source code from https://oss.oracle.com/sources/ or http://www.oracle.com/goto/opensourcecode. If the source code for such software was not provided to You with the binary, You can also receive a copy of the source code on physical media by submitting a written request pursuant to the instructions in the "Written Offer for Source Code" section of the latter website.
-
--------------------------------------------------------------------------------
-
-The following license terms apply to those Programs that are not provided to You under Separate Terms.
-
-License Rights and Restrictions
-
-Oracle grants to You, as a recipient of this Program, a nonexclusive, nontransferable, limited license to, subject to the conditions stated herein, (a) internally use the unmodified Programs for the purposes of developing, testing, prototyping and demonstrating your applications, and running the Programs for your own internal business operations; and (b) redistribute unmodified Programs and Programs Documentation, under the terms of this License, provided that You do not charge Your end users any additional fees for the use of the Programs. You may make copies of the Programs to the extent reasonably necessary for exercising the license rights granted herein and for backup purposes. You are granted the right to use the Programs to provide third party training in the use of the Programs and associated Separately Licensed Technology only if there is express authorization of such use by Oracle on the Program's download page or in the Program Documentation.
-
-Your license is contingent on Your compliance with the following conditions:
-
-- You include a copy of this license with any distribution by You of the Programs;
-
-- You do not remove markings or notices of either Oracle's or a licensor's proprietary rights from the Programs or Program Documentation;
-
-- You comply with all U.S. and applicable export control and economic sanctions laws and regulations that govern Your use of the Programs (including technical data);
-
-- You do not cause or permit reverse engineering, disassembly or decompilation of the Programs (except as allowed by law) by You nor allow an associated party to do so.
-
-For clarity, any source code that may be included in the distribution with the Programs is provided solely for reference purposes and may not be modified, unless such source code is under Separate Terms permitting modification.
-
-Ownership
-
-Oracle or its licensors retain all ownership and intellectual property rights to the Programs.
-
-Information Collection
-
-The Programs' installation and/or auto-update processes, if any, may transmit a limited amount of data to Oracle or its service provider about those processes to help Oracle understand and optimize them. Oracle does not associate the data with personally identifiable information. Refer to Oracle's Privacy Policy at www.oracle.com/privacy.
-
-Disclaimer of Warranties; Limitation of Liability
-
-THE PROGRAMS ARE PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. ORACLE FURTHER DISCLAIMS ALL WARRANTIES, EXPRESS AND IMPLIED, INCLUDING WITHOUT LIMITATION, ANY IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NONINFRINGEMENT.
-
-IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW WILL ORACLE BE LIABLE TO YOU FOR DAMAGES, INCLUDING ANY GENERAL, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OR INABILITY TO USE THE PROGRAM (INCLUDING BUT NOT LIMITED TO LOSS OF DATA OR DATA BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD PARTIES OR A FAILURE OF THE PROGRAM TO OPERATE WITH ANY OTHER PROGRAMS), EVEN IF SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.
-
-Last updated: 9 October 2018
diff --git a/PKGBUILD b/PKGBUILD
index d80338e23767..20fa14007c24 100644
--- a/PKGBUILD
+++ b/PKGBUILD
@@ -1,27 +1,31 @@
-# Maintainer: Luis Martinez <luis dot martinez at disroot dot org>
+# Maintainer: Vlad Pirlog <(firstname) at (lastname) dot net>
+# Contributor: Luis Martinez <luis dot martinez at disroot dot org>
 # Contributor: Kevin Baxmann <kvbx@kvbx.de>
 # Contributor: Arne Hoch <arne@derhoch.de>
 
 pkgname=sqlcl
-pkgver=22.2.0.172.1718
+pkgver='23.1.0.089.0929'
 pkgrel=1
-pkgdesc="SQL Developer command line interface for Oracle"
+pkgdesc='SQL Developer command line interface for Oracle'
 arch=('any')
-url="https://oracle.com/database/technologies/appdev/sqlcl.html"
+url='https://www.oracle.com/database/sqldeveloper/technologies/sqlcl'
 license=('custom')
-depends=('java-runtime>=8')
+changelog=CHANGELOG.md
+depends=('bash' 'java-runtime>=8')
 source=("$pkgname-$pkgver.zip::https://download.oracle.com/otn_software/java/sqldeveloper/$pkgname-$pkgver.zip"
-        "$pkgname.sh"
-        'LICENSE')
-sha256sums=('eb69022227fec14578e319a398bd20958e94da77b263300ba09af8bd5aac4aa1'
-            '34c5f2be48639dcd8ec9f38f950916a394ae399a0e583fbde4020acdccf951e0'
-            '8f5642d74925ba3a4543c52b7a84b65c18aaa7dd3599c141e72ad5117e748929')
-
-PURGE_TARGETS=(*.exe *.txt)
+        "$pkgname.sh")
+sha256sums=('093f0d752bd9a497e168b7f3de4a3b68ea977bfe5948e2602ad91dd3a0147568'
+            '34c5f2be48639dcd8ec9f38f950916a394ae399a0e583fbde4020acdccf951e0')
 
 package() {
-	install -d "$pkgdir/opt/$pkgname/"
-	cp -a --no-preserve=ownership,mode "$pkgname"/* "$pkgdir/opt/$pkgname/"
-	install -D "$pkgname.sh" "$pkgdir/usr/bin/$pkgname"
-	install -Dm644 LICENSE -t "$pkgdir/usr/share/licenses/$pkgname/"
+    install -Dm755 "$pkgname.sh" "$pkgdir/usr/bin/$pkgname"
+
+    install -Dm644 "$pkgname/bin/license.txt" -t "$pkgdir/usr/share/licenses/$pkgname/"
+    install -Dm644 "$pkgname/third-party-licenses.txt" -t "$pkgdir/usr/share/licenses/$pkgname/"
+
+    rm "$pkgname"/{README.md,Release-Notes.md,third-party-licenses.txt} \
+       "$pkgname"/bin/{license.txt,README.md,sql.exe}
+
+    install -d "$pkgdir/opt/$pkgname/"
+    cp -a --no-preserve=ownership,mode "$pkgname"/* "$pkgdir/opt/$pkgname/"
 }