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 |
---|---|---|---|---|
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) |
— | about 2 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) |
— | over 2 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) |
— | about 3 years ago |