What steps will reproduce the problem?

http=>https

What is the expected result?

What do you get instead?

Additional info

What does that mean "Oracle support for Yii 3.0"?

What steps will reproduce the problem?

I tried to install this package using composer via the command below as it is mentioned in the installation guide:
composer require --prefer-dist yiisoft/yii2-oracle "~1.0.0"

What I have got:

Your requirements could not be resolved to an installable set of packages.
  Problem 1
    - The requested package yiisoft/yii2-oracle ~1.0.0 is satisfiable by yiisoft/yii2-oracle[1.0.x-dev] but these conflict with your requirements or minimum-stability.
Installation failed, reverting ./composer.json to its original content.

Additional info

Hi,

I have some problems with AR queries in Oracle. Normally it's working alright, but sometimes makes mistakes. E.g. command:

->addSelect('SUM(pk_me.gtat_bt (a_m_id, et.tl_id, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL)) BD')

result:

..., "NULL", "0", "NULL))" BD

I wanted to install this extension in the hope that it gets maybe better, but I'm not able to do that. I've tried to install it many different ways, but I'm getting various error messages in Composer:

composer require --prefer-dist yiisoft/yii2-oracle

Could not find a version of package yiisoft/yii2-oracle matching your minimum-stability (stable). Require it with an explicit version constraint allowing its desired stability.

"yiisoft/yii2-oracle": "~1.0.0"

Problem 1 - The requested package yiisoft/yii2-oracle ~1.0.0 is satisfiable by yiisoft/yii2-oracle[1.0.x-dev] but these conflict with your requirements or minimum-stability.

"yiisoft/yii2-oracle": "@dev"

Your requirements could not be resolved to an installable set of packages.
Problem 1

• yiisoft/yii2-oracle 1.0.x-dev requires yiisoft/core ^3.0@dev -> satisfiable by yiisoft/core[3.0.x-dev] but these conflict with your requirements or minimum-stability.
• yiisoft/yii2-oracle dev-master requires yiisoft/core ^3.0@dev -> satisfiable by yiisoft/core[3.0.x-dev] but these conflict with your requirements or minimum-stability.
• Installation request for yiisoft/yii2-oracle @dev -> satisfiable by yiisoft/yii2-oracle[dev-master, 1.0.x-dev].

https://www.yiiframework.com/extension/yiisoft/yii2-oracle:

• says, it's for Yii 2.1 but the latest stable release is 2.0.15.1 (what I'm also already having)
• the link says yii2-oracle, but then I'm in yii-oracle, I have no clue if it's alright
  Does it mean there is no extension for the actual stable version of yii2?

Thank you.

Executing Query without FROM statement fails in Oracle:

$scalar = (new Query($db))->select(new Expression('1'))->scalar();

Tests yiisoft/db#760

https://github.com/yiisoft/db/actions/runs/6324733173/job/17174800505?pr=760

1) Yiisoft\Db\Oracle\Tests\QueryTest::testSelectWithoutFrom
Yiisoft\Db\Exception\IntegrityException: SQLSTATE[HY000]: General error: 923 OCIStmtExecute: ORA-00923: FROM keyword not found where expected
 (/tmp/php-src-php-8.2.10/ext/pdo_oci/oci_statement.c:153)
The SQL being executed was: SELECT 1

This can be solved by adding FROM DUAL for SQL expressions without FROM statement.

What steps will reproduce the problem?

What is the expected result?

What do you get instead?

Additional info

Remove travis if it exists