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 |