Comments (8)
Is that sufficient
Yep that's perfect, thanks! I'll write something up tomorrow if @frioux or @rabbiveesh don't beat me to it.
from dbix-class-helpers.
Hrm... Since the Oracle tests no longer work (d845dfc#diff-67f50785d40416a7a7689c5c353f1128): can you please distill this down to a one-liner-ish example and provide the full exception text.
from dbix-class-helpers.
It's as simple as $rs->results_exist
for any $rs as the generated SQL syntax SELECT EXISTS
doesn't exist 🤣.
from dbix-class-helpers.
Given the current state of affairs, I have to write a patch, completely blind, against a database I do not have easy access to. Please either provide a complete PR that solves your case (not a random SO link), OR alternatively provide the exact thing I requested above.
from dbix-class-helpers.
Is that sufficient? Devel::REPL run of
say rs('Device')->results_exists;
SELECT *
FROM (
SELECT EXISTS(
SELECT 42
FROM device me
)
) AS _existence_subq
Runtime error: DBD::Oracle::db prepare_cached failed: ORA-00936: missing expression (DBD ERROR: error possibly near <*> indicator at char 23 in 'SELECT * FROM ( SELECT <*>EXISTS (SELECT 42 FROM device me ) ) AS _existence_subq ') [for Statement "SELECT * FROM ( SELECT EXISTS (SELECT 42 FROM device me ) ) AS _existence_subq "]
Trace begun at /home/ahartmai/.plenv/versions/30.0/lib/perl5/site_perl/5.30.0/DBIx/Class/Storage/DBI.pm line 1850
DBIx::Class::Storage::DBI::_prepare_sth('DBIx::Class::Storage::DBI::Oracle::Generic=HASH(0x55f7d782e248)', 'DBI::db=HASH(0x55f7d7f60218)', 'SELECT * FROM ( SELECT EXISTS (SELECT 42 FROM device me ) ) AS _existence_subq ') called at /home/ahartmai/.plenv/versions/30.0/lib/perl5/site_perl/5.30.0/DBIx/Class/Storage/DBI.pm line 1829
from dbix-class-helpers.
And for all the work I spent making sure the codebase would even try to test it...
from dbix-class-helpers.
@rabbiveesh based on history Oracle broke prior to your fixes. I.e. it's been disabled for a while for some unrelated reason, @frioux would know more...
from dbix-class-helpers.
@rabbiveesh @abraxxa I see why this was disabled: https://github.com/wnameless/docker-oracle-xe-11g#docker-oracle-xe-11g
I suppose one of you could try to fix https://github.com/frioux/DBIx-Class-Helpers/blob/main/maint/run-oracle and then be able to run https://github.com/frioux/DBIx-Class-Helpers/blob/main/maint/dockerprove
I am not setup for docker properly, so yet again I'll have to try this towards the weekend, but knowing that the core tests run: would be a good starting point.
from dbix-class-helpers.
Related Issues (20)
- AutoRemoveColumns _should_column_fetch example incorrect HOT 6
- SelfResultSet returns a Result instead of a ResultSet in list context
- A tad cleaner ProxyResultMethod HOT 1
- Add StrictMode helper for columns
- [PATCH] spelling fixes HOT 1
- [PATCH] Fix a strictness error in a deprecated module HOT 1
- Hella Fast JSON Encoder
- Use DBIx::RetryConnect in tests to remove sleep in with-dbs HOT 1
- Make dont_serialize in Helper::Row::ToJSON a package global? HOT 6
- Problem installing on debian Stretch HOT 4
- Simply loading AutoRemoveColumns seems to interfere with DBICs group_by inferrence HOT 7
- SetOperations UNION needs extra brackets (PostgreSQL)? HOT 4
- Booleans with Helper::Row::ToJSON HOT 5
- AutoRemoveColumns doesn't work with prefetch HOT 1
- AutoRemoveColumns breaks `select =>` HOT 2
- Q: Why `Helper::Row::SelfResultSet` disables `InflateColumn::DateTime` if used first? HOT 2
- DateMethods1 returns week number for day_of_week under MSSQL
- OnColumnMissing breaks create with related objects
- It's swallowing the "-as" that's not for function HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dbix-class-helpers.