Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users
Tabletop RPGs
Tabletop RPGs
Community Proposals
Community Proposals
tag:snake search within a tag
answers:0 unanswered questions
user:xxxx search by author id
score:0.5 posts with 0.5+ score
"snake oil" exact phrase
votes:4 posts with 4+ votes
created:<1w created < 1 week ago
post_type:xxxx type of post
Search help
Notifications
Mark all as read See all your notifications »

Welcome to Software Development on Codidact!

Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.

Activity for artaxerxe‭

Type On... Excerpt Status Date
Edit Post #286027 Post edited:
over 2 years ago
Edit Post #286027 Post edited:
over 2 years ago
Edit Post #286027 Initial revision over 2 years ago
Question Conditions which always matches returns no result with CTE
I have the following scenario (in MySQL 8): CREATE TABLE `steps` ( `id` int NOT NULL AUTOINCREMENT, `number` varchar(30) DEFAULT NULL, `parentnumber` varchar(30) DEFAULT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENTTIMESTAMP, `step` varchar(20) DEFAULT NULL, ...
(more)
over 2 years ago
Edit Post #285784 Post edited:
almost 3 years ago
Comment Post #285784 Why did you downvote?
(more)
almost 3 years ago
Comment Post #285784 I didn't say that javax.mail is dependent on bouncycastle. I just presented my scenario. :). Yes, createMDNData() uses some MIME type which is handled by bouncycastle.
(more)
almost 3 years ago
Edit Post #285784 Post edited:
almost 3 years ago
Edit Post #285784 Initial revision almost 3 years ago
Question Cannot write multipart message to byte array
I'm trying to write a MIME message to the console. ByteArrayOutputStream out = new ByteArrayOutputStream(); MimeMultipart replyMsg = mdnCreator.createMDNData(); replyMsg.writeTo(out); out.close(); System.out.println(new String(out.toByteArray())); I'm using bouncycastle ...
(more)
almost 3 years ago
Comment Post #281456 @Peter, the only problem with this is that if you get cycles, you will do unnecessary work.
(more)
over 3 years ago
Comment Post #281448 @Alexei In my case, I think this wouldn't be recommendable, even if I shouldn't stick with SQL. Anyway, taking 100K rows form DB to parse them on the middleware seems to me not a good idea. I think this should be done on the DB side. Your SQL is quite useful for me except the recursivity limitation....
(more)
over 3 years ago
Comment Post #281448 @Alexei 'this type of query might be better be done in a language/framework like C++, Java or .NET'. Yes, I'm forced to remain to SQL. But do you mean to use an ORM or do you mean to make the logic from such a framework? I ask because second option seems to me not efficient.
(more)
over 3 years ago
Comment Post #281415 @Estela the relationship is transitive. I would say that in my case 5 should be considered as a grandchild of 3. But let's see where we get.
(more)
over 3 years ago
Comment Post #281415 @Estela have a look now at my edited post.
(more)
over 3 years ago
Edit Post #281415 Post edited:
over 3 years ago
Comment Post #281415 id isn't relevant. you have to look for childId and parentId.
(more)
over 3 years ago
Comment Post #281417 Nope. ON clause is good. See my edit.
(more)
over 3 years ago
Edit Post #281415 Post edited:
over 3 years ago
Edit Post #281415 Post edited:
over 3 years ago
Edit Post #281415 Initial revision over 3 years ago
Question How to break infinite loop in CTE
I have a parent-child relation in my table, with possibly circular cases. Is it possible to break the infinite recursion in CTE checking values of all previous rows? I would need something like this: with mycte(childId, parentId, col1) AS ( SELECT r.childId, r.parentId, r.col1 FROM...
(more)
over 3 years ago